We are trying to get the CSV importer to work properly and we’re having issues because it’s creating duplicate products. Ultimately we want to import hundreds of product variations, but we’re not close to getting that working yet. We’ve eliminated all of the possible variables that we can think of to getting this to work and we have a pretty simple test that’s failing.
What we did was this:
- Export all of the products (WooCommerce >> CSV Import Suite >>
Export Products Tab, Limit = unlimited, Offset=0, Columns = All
Columns. We’ve tested it with “include hidden data” checked and
- Save the CSV file to the desktop (Windows) and didn’t
open it or edit it in any way.
- Click on the import button, upload the files and click on the final button to start the process.
I would expect it to skip every product in the import file because it already exists in the database, but it routinely adds 8 of the 67 products as new ones. Each time we’ve tested has been the same 8 products and the option for including hidden data on the export doesn’t impact the results.
Has anyone seen this issue? Any ideas on a workaround or fix?
If not, does anyone have any suggestions on how to de-duplicate the records?
Read more here: WooCommerce CSV Import Suite Creating Duplicate Products