Duplicate Woocommerce Products

Hi @williamews

Are you using a separate “New Items” import when uploading the new file? If so, that might explain the issue – a “New Items” import can only detect posts that it created, it can’t detect posts that were created manually or by another import (regardless of the Unique Identifier).

When possible, it’s best to update the import that initially created the products with a new file: https://www.wpallimport.com/documentation/recurring/update-import. If that’s not possible, then you should use an “Existing Items” import instead: https://www.wpallimport.com/documentation/recurring/manual-record-matching/.

Ok. So is there anyway we can delete the duplicate products?

Thanks

Hi @williamews

If the duplicate products were created by a “New Items” import, then you can delete them via All Import > Manage Imports – just click “Delete” under your import and you’ll be presented with the option to delete the posts created by the import.

Thanks for your support!

The problems…

1- The CSV has about 40,000 products. And I guess almost half has been imported to the Woocommerce system, but with many duplicates.

2- When the server interrupts the import and we re-start the import again as “New Items” for a couple of times this cause the duplicate products, but a good number of the products are already imported. So we don’t want to start all over again.

Is there any trick to just purge the duplicate products and continue/ update the important with the “Existing Items” import feature?

Thanks!

PS: We have already increased the server’s PHP max execution time to 18000 but still running into the “The server has terminated the important” issue most of the time after about 20,000 products are imported.

Hi @williamews

Is there any trick to just purge the duplicate products and continue/ update the important with the “Existing Items” import feature?

You should delete your products to start with a clean slate – then, going forward, you’ll want to re-start the same “New Items” import that was terminated in order to avoid duplicates. If you are doing this already, then we’ll need to see the data to understand why there are duplicates – in this case, please open a support ticket about this issue here: https://www.wpallimport.com/support/

We have already increased the server’s PHP max execution time to 18000 but still running into the “The server has terminated the important” issue most of the time after about 20,000 products are imported.

First, you should try setting the records per iteration down to 1 via Manage Imports > Import Settings: see screenshot. If that doesn’t work, then you should contact your web host and ask them to check your servers error logs – there’s likely a different setting that needs to be adjusted here.

Marking this as resolved. @williamews let us know if you’re still having any issues. Anyone else reading this, please begin a new thread.