Flaky .CSV import

  • Resolved mdv2026

    (@mdv2026)


    1 week, 3 days ago

    I’m trying to import reviews from a .CSV file. I started by downloading the template. I did a few tests. Seemed to work. Then I added more to the database and did another test. It did not load. I deleted the empty columns. It loaded. So I deleted all the reviews from WP. I added more to the database and tried to import again. It says it imported 49 of 49 reviews but then when I scroll up 49 entries were skipped. No error message in the console

    Any idea what the problem could be?

    • This topic was modified 1 week, 3 days ago by mdv2026.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Paul

    (@pryley)

    1 week, 3 days ago

    Do you have reviews in the trash? Site Reviews will skip reviews if they already exist during import to prevent duplicates.

    Thread Starter mdv2026

    (@mdv2026)

    1 week, 3 days ago

    Ah yes! Emptying the trash fixed it ! Thanks so much!

    Plugin Contributor Paul

    (@pryley)

    1 week, 3 days ago

    In that case, it’s working as expected.

    Thread Starter mdv2026

    (@mdv2026)

    1 week, 3 days ago

    Would be nice to have a warning as to why they were skipped. I was looking at my reviews and it was empty. Would be more intuitive it would not consider an existing review as duplicate if it’s the trash.

    Plugin Contributor Paul

    (@pryley)

    1 week, 3 days ago

    A deleted review is counted as an existing review because the only difference is the post status; if the review was ever untrashed, it would be an exact duplicate. WordPress itself ships exactly this with the post_exists() function. Trashed posts count as existing.

    It needs additional explanation in the notice, not a change in functionality. I’ll add this to the next release.

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

You must be logged in to reply to this topic.