• Resolved molden

    (@molden)


    I have tried the max_timeout value change (from 60 to 6000) but only still get 1 deletion out of +11,485 and the error “Stopped processing due to imminent timeout.”

    I see some folks have luck getting at least the capitated 250 records. I can only ever get one.

    Might you know the query I could enter into MySQL that would simply remove all the products?

    I have searched and found one query that does not work for me. I hoped your plug in would be essentially a non-SQL execution point and accomplish the same.

    Query I had found:

    DELETE relations.*, taxes.*, terms.*
    FROM wp_term_relationships AS relations
    INNER JOIN wp_term_taxonomy AS taxes
    ON relations.term_taxonomy_id=taxes.term_taxonomy_id
    INNER JOIN wp_terms AS terms
    ON taxes.term_id=terms.term_id
    WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type=’product’)

    Result is:

    Output from SQL command DELETE relations.*, taxes.*, terms.* FROM wp_term_relationships AS relations INNER JOIN wp_term_taxonomy AS taxes ON relations.term_taxonomy_id=taxes.term_taxonomy_id INNER JOIN wp_terms AS terms ON taxes.term_id=terms.term_id WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type=’product’) ..
    No data returned

    https://ww.wp.xz.cn/plugins/woocommerce-remove-all-products/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Gabriel Reguly

    (@gabriel-reguly)

    Sorry, but I can’t help you with this query.

    The plugin code uses the WordPress function ‘wp_delete_post’, maybe you can learn from it.

    Cheers,
    Gabriel

    Thread Starter molden

    (@molden)

    I did learn from WP All Import coders that any items imported by their product can also be 100% removed upon selecting deletion from the job list then choosing to remove all inventory imported by it. You can keep the job, but you are able to wipe the inventory it imported including images, if any.

    That saved a ton of time otherwise.

    Plugin Author Gabriel Reguly

    (@gabriel-reguly)

    Fantastic, thanks for sharing your solution.

    Cheers,
    Gabriel

    I have got the same isssue and it force me to delete the products one by one..
    I skipped this trouble using another plugin: “Woo Product Remover” it works well to me.

    • This reply was modified 9 years, 4 months ago by matteo raggi.
Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Stopped processing due to imminent timeout’ is closed to new replies.