Registered on : 12/04/2011
Posts : 494
Posted : 03/13/2014 08:59:34 "Quote"
Many of you are wondering what this sort of alert is all about:
This is not a bug, this is a warning indicating you that at least two products, in your database, have the same supplier_reference (with value ‘C004-VW-Golf6’). We call this “duplicates”.
Duplicates are dangerous because in case your file contains one line of data to update such duplicates, only of them will be updated (and it is impossible to determine which one).
The best, in such cases, is either to use another synchronisation key, either to correct the supplier_reference of all duplicates (or to delete the duplicates).
As of today, this process is manual. In future versions of PrestaPricing, I will probably propose an automatic database cleaning function.
If you are good at writting SQL requests and using PHPMyAdmin, be aware that this can be done automatically by switching the field to "Unique key".
But If you do not want to bother with this and simply ignore such warnings, there is an option for this, just check in: "Do not check keys uniqueness” . Then please read carefully the following warning message and confirm.