Is possible Rebuild reports data with WP-CLI?

Thanks for reaching out with this question – and that is an impressive amount of historical data! Currently we don’t have an option to enqueue reports to be processed via WP CLI, but we do have plans for more granular control over importing large amounts of historical data:

https://github.com/woocommerce/woocommerce-admin/issues/1851

I added a comment on that issue to include the ability to enqueue report re-generation via WP CLI.

We are hoping to being importing a large amount of historical data on WooCommerce.com too, so I anticipate we will build out better tooling for sites like yours in the near future.

Hi @timmydcrawford ,

Thank you for your interest.

Suggestions on the issue page that you added a comment also seem logical.(date-based import)

If the WP-CLI can remove this load, it is much more convenient to use a WP-CLI. But if WP-CLI can’t cope with it, developing a UI for history-based import can also be effective.

I hope that you will find solutions in the near future.

Hello @imhakanarslan,

The report data is processed using Action Scheduler. While you can’t use WP-CLI to enqueue the historical data processing, you can use WP-CLI to process the queue. See the WP-CLI documentation on the Action Scheduler site for information on how to set it up.

Please note that other important processing on your store might be using Action Scheduler (like webhooks), so make sure if you use WP-CLI to run the actions that it does happen on a recurring basis.

Thanks for using WooCommerce Admin!

@imhakanarslan I’m going to mark this thread as resolved, but please feel free to re-open if you have other issues.