peterjot

Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Forum: Plugins
    In reply to: [WooCommerce] Junk in database after CSV import, even after removing all products
    Thread Starter peterjot

    (@peterjot)

    8 years, 3 months ago

    Yes, it worked, all orphan records has been removed from tables. Import working really fast now.

    Magick query:
    UPDATE wp_posts SET post_status='importing' WHERE post_title LIKE 'Import placeholder%'

    And then run any import to allow cleaning of tables.

    Thanks for help, Caleb!

    Best regards,
    Piotr

    • This reply was modified 8 years, 3 months ago by peterjot.
    • This reply was modified 8 years, 3 months ago by peterjot.
    Forum: Plugins
    In reply to: [WooCommerce] Junk in database after CSV import, even after removing all products
    Thread Starter peterjot

    (@peterjot)

    8 years, 3 months ago

    I’ve done before full import thinkting it would clean up, but probably this status prevented this.

    This query looks complicated to run outside wordpress to delete all records, so i think that safest and easiest way would be change manually status to ‘importing’ for those entries in wp_posts.

    I’ll update this thread if this work, maybe someone will have similar issue.

    Forum: Plugins
    In reply to: [WooCommerce] Junk in database after CSV import, even after removing all products
    Thread Starter peterjot

    (@peterjot)

    8 years, 3 months ago

    Hi Caleb,

    Thanks for your reply.

    SKU. I don’t have any problems until yesterday, where I got time-out, have trouble removing products, and after that I found unusual amount of records in those tables.

    When checking dates, those items were created during last 9 days, probably since i started importing products, and happened many times. I’ve created csv files myself, but syntax should be ok, as products were imported without issues. I had at the begining some problems with product images field with | as delimeter, what was not working due to error in WooCommerce documentation.

    One thing unusual, I several times used option to “Update existing products”, having more products in csv (around 90 x 4 variations) than in shop (12 products with 4 variations each), but according to documentation it should skip not matched records.

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