Product Count and CSV Upload Error

  • Resolved Adrian

    (@adrianpvc)


    4 years, 4 months ago

    Hi,

    I deleted all of the products from my WC inventory and deleted them permanently from the trash.
    Still, I see “All(19)” under Products in the the product page. So when I try to upload a CSV file with products, some products do not load becase their ID already exists even though I deleted all products.

    How can I fix this?

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi @adrianpvc ,

    The header showing as “All(19)” can happen when the database and caches are still synchronizing. That should go away after a while, but if not, you can force it to update under WP Admin > WooCommerce > Status > Tools > Product lookup tables > Click – Regenerate (Button on right). However, that won’t cause the particular issue you’re seeing with product IDs.

    Product IDs are automatically assigned by WordPress and previously used IDs can’t be reused.

    When importing a CSV file, the product ID isn’t required, and in cases like this should be skipped. You can do that by either removing IDs from the CSV or setting the ID column to “Do not import” when you import the file.

    Do not import ID
    Link to image: https://d.pr/i/68BoKM

    If you have variable products, the variations can be linked to the main product by SKU. There are more details about product imports here.

    Let us know if you have any other questions!

    Thread Starter Adrian

    (@adrianpvc)

    After a day the products were not disappearing but I fixed the issue by going to phpMyAdmin and erasing the products from the data base. I am now uploading products without the IDs ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Product Count and CSV Upload Error’ is closed to new replies.