Utilization module PrestaShop PrestaPricing »
[FAQ]Duplicates: "The selected synchronization key created an issue" message when running the importation.
Author | Post |
---|---|
Sitolog Registered on : 12/04/2011 Posts : 520 |
Posted : 03/13/2014 08:59:34 "Quote" Many of you are wondering what this sort of alert is all about: Code : When this option left unchecked (default value): When creating new items, the synchronization key will be converted to a unique key in the database. This means this field could not contain any duplicate value(except NULL values). This modification to the database can be reverted by changing again the synchronization key. The import will fail if this field already contains any duplicate (on any products, not necessarily on the products you want to import). In this case, you will have to take the time to clean the base, by removing ALL duplicates. However, you can also disable this constraint by setting this option to ON. In this case, no checking of key uniqueness is made, with the risk to update the wrong item. It is often the first item found by the SQL query that will be updated (usually the one with the lowest id). Disabling a uniqueness rule key is therefor a dangerous choice, do so only if you are sure that duplicates do not apply to the products you wish to update. Rgds Franck |