Duplicate and missing products in export

  • Resolved zgall1

    (@zgall1)


    4 years, 10 months ago

    I have a database with 1,049 WooCommerce products (simple and variable combined).

    When I export the products with the built in WooCommerce export functionality, it exports 1,052 rows, including many duplicates, some of which are duplicated more than once.

    When I export the products with the plugin, it exports 1,049 rows, many of which are duplicates, some of which are duplicated more than once.

    In the first two cases, it is clear that many products are not exported at all.

    When I do a straight dump from SQL (SELECT * FROM lfbr4_posts WHERE post_type = ‘product’), all 1,049 unique products are visible.

    All of the data has been pasted into this spreadsheet on three separate tabs – https://docs.google.com/spreadsheets/d/1qulnEj_PdFsMPIBFhgCp2WVNpmN9KFd5Yk5-hCuwm6g/edit?usp=sharing.

    I have no idea what is going on. Do you have any thoughts?

    • This topic was modified 4 years, 10 months ago by zgall1.
    • This topic was modified 4 years, 10 months ago by zgall1.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author WebToffee

    (@webtoffee)

    Hi @zgall1,

    Could you please mention the version of the product import-export plugin, WordPress and Woocommerce that is installed on your site?

    Thread Starter zgall1

    (@zgall1)

    Of course.
    WP 5.3.2
    WooCommerece 3.9.3
    Product CSV Import Export (BASIC) 1.7.7

    Thread Starter zgall1

    (@zgall1)

    Any thoughts on this?

    I’ve been thinking about this some more and the only point that might be worth mentioning is that I used some manual SQL scripts on this database at some point to delete all of the WooCommerce products after some previous test imports. I wonder if that somehow messed something up.

    Plugin Author WebToffee

    (@webtoffee)

    Hi @zgall1,

    Could you please try disabling all the other plugins on your site except Woocommerce and try exporting the products.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Duplicate and missing products in export’ is closed to new replies.