My feed has 400 duplicate rows

  • Resolved korvak

    (@korvak)


    2 years, 5 months ago

    My entire feed is less than 2,000 rows. But lately I noticed that about 400 of my SKU’s are duplicated and appear in the CSV feed twice. Why is this happening?

    I went into the plugin settings and set “Change products per batch number” to 400. But I still have the issue with duplicate rows.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter korvak

    (@korvak)

    Debug log

    https://drive.google.com/file/d/13U10FTG_4FCu7LHIkytHc3OsWajXW30q/view?usp=sharing

    Hi,

    Thanks for using our plugin and reaching out to us. I noticed that you have used your SKU in your field mapping. Are you absolutely sure the SKU’s are unique in all products? Also, do all product variations have unique SKU’s?

    Thread Starter korvak

    (@korvak)

    Yes! All products have unique SKU’s. Woocommerce doesn’t allow us to set the same SKU for two products. We do not use variations for any products.

    We have wp-cron disabled and we use server cron to invoke the wp-cron periodically. Could this cause duplicates in the feed? I thought this would only cause the feed to generate slower.

    EDIT: As a test, I opened the URL to wp-cron.php in another web browser. Then I refreshed my feed, and I kept refreshing the wp-cron.php window to allow the cron job to keep running. This time, the feed genearted in 10-20 seconds, and no duplicates.

    Why would using server-cron instead of wp-cron cause duplicates? Is there a way to keep using server-cron and avoiding the duplicates? I don’t care if my feed generates too slowly.

    • This reply was modified 2 years, 5 months ago by korvak.
    • This reply was modified 2 years, 5 months ago by korvak.
    Thread Starter korvak

    (@korvak)

    Update: I tried to set my server cron to invoke wp-cron every 5 minutes, but still the feed had duplicates. Then, I enabled wp-cron completely, and now all the duplicates are gone.

    Is there a way to disable wp-cron and avoid the duplicates? I don’t mind if the feed takes longer to generate.

    Did you already try lowering the batch size of the plugin from the default 750 products per batch to a much lower number, such as 250? This is how you can do so: https://adtribes.io/batch-size-configuration-product-feed/

    Assuming the issue at hand has been resolved and our support is no longer required I will close this topic for housekeeping reasons now.

    Do not hesitate to reach out to us again in-case you need our help again.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘My feed has 400 duplicate rows’ is closed to new replies.