Change 100 order status at once

  • Resolved Majid

    (@majidempire)


    2 years, 4 months ago

    Hi,
    I have a WC shop that have more than 50K orders and when I try to change 100 or 200 order statuses at once it craches and take too long
    I have dedicated server with 18 core CPU and 60GB memory, My database is optimizes and it has 32G memory dedicated.

    I know the problem is wp_posts table and WC team are working on something amazing some called High-Performance order storage (COT)

    But what should I do now? do you have any advice?

Viewing 1 replies (of 1 total)

  • Hi there @majidempire ??

    But what should I do now? do you have any advice?

    Thanks for reaching out. Happy to help you with this!
    I understand that currently you are going ahead with using the core functionality of changing the order statuses as seen in the screenshot linked directly here. Correct?

    The site’s beefy server setup, begs the following question(s): what are the available payment methods on the site, how are they set up, and what is the workflow followed after an order is sent through?

    Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select Get system report and then Copy for support.?You can either paste it in your response here, or use https://pastebin.com/ for pasting it there and sharing it with us.

    Looking forward to hearing from you!

    • This reply was modified 2 years, 4 months ago by anastas10s. Reason: typo
Viewing 1 replies (of 1 total)
  • The topic ‘Change 100 order status at once’ is closed to new replies.

Tags