• Resolved Alex Pravdin

    (@alexpravdin)


    Hello.
    I’m trying to import a lot of products – approx 40,000. I was trying to do that with the standard WC importer, but it always hangs on 73% with 502 error on ajax requests. It has created approx. 25,000 products. Next, I installed WP All Import and started import on the same CSV file. I’ve set it to ignore duplicates. But, in fact, it adds duplicates to the products already imported by the standard WC importer. How to solve this problem? And, do you have an idea of how to remove all the 25,000 products and run All WP Importer from scratch?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Alex Pravdin

    (@alexpravdin)

    I’ve rechecked. The option “Create new products from records newly present in your file” doesn’t work. It ALWAYS adds new products. Even if the option to update data in existing rows is set. The plugin doesn’t work and unusable.

    Plugin Author WP All Import

    (@wpallimport)

    Hi @alexpravdin

    I’ve set it to ignore duplicates. But, in fact, it adds duplicates to the products already imported by the standard WC importer. I’ve rechecked. The option “Create new products from records newly present in your file” doesn’t work. It ALWAYS adds new products. Even if the option to update data in existing rows is set.

    A “New Items” import (see: https://d.pr/5s8uX9) cannot recognize products that it didn’t previously create, so it’s expected behavior for duplicates to be created since they were created by a different import (or a different plugin).

    Also, the “Update existing products with changed data in your file” option in this case is used to update the products when you re-run the import later: https://www.wpallimport.com/documentation/recurring/update-import.

    How to solve this problem?

    If you’re only importing simple/grouped/affiliate products (not variable products), and you don’t need to utilize the “Delete products that are no longer present in your file” option, you can use an “Existing Items” import: https://www.wpallimport.com/documentation/recurring/manual-record-matching/.

    Alternatively, you could use our API (see documentation) to make sure that you’re not creating products with SKUs that already exist. Here is an example snippet: https://d.pr/n/mex05J.

    And, do you have an idea of how to remove all the 25,000 products and run All WP Importer from scratch?

    You could use a plugin like this to bulk delete them: https://www.ads-software.com/plugins/woocommerce-store-toolkit/.

    Thread Starter Alex Pravdin

    (@alexpravdin)

    Hi, thank you for your reply.
    Unfortunately, the plugin was duplicating products imported by itself on the previous runs. Also, I can’t understand the logic of duplicating products imported by other plugins when the key is the SKU field, a standard WC field.
    BTW, I’ve done my task successfully using another plugin which is tolerant to products imported by other plugins.

    Plugin Author WP All Import

    (@wpallimport)

    Hi @alexpravdin

    Unfortunately, the plugin was duplicating products imported by itself on the previous runs.

    Assuming that the data in the Unique Identifier field was unchanged, that’s extremely strange and is not something I can replicate. If you’d like us to look into this please contact us at https://www.wpallimport.com/support/ and we’d be happy to figure out what’s going wrong.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Products are duplicated’ is closed to new replies.