Running the proper commands in CLI

Hi @dbook1337, thanks for the note. Have you checked out this Wiki article? https://github.com/mailchimp/mc-woocommerce/wiki/Advanced-Queue-Setup-In-CLI-mode. Let us know if you need any additional help.

@khungate I am wondering the same thing. Been almost 12 hours and only 600 orders synced, so I thought I’d run cli. I tried the following, and as you see to no avail. What am I missing?

[core@site www]$ wp action-scheduler run --group="mc-woocommerce"
0 batches executed.
Success: 0 scheduled tasks completed.

Edit: and does it need WC 4.0 to work?

• This reply was modified 4 years, 8 months ago by romeon.
• This reply was modified 4 years, 8 months ago by romeon.

@romeon, thanks for reaching out. Do you happen to see any errors in the fatal logs of Woo? You can locate these under WooCommerce -> Status -> Logs (tab). If so, please share when you get a moment.

Also, 4.0 should work fine with v2.3.4. We’re scheduled to push up a new release shortly that has been tested with WC4.0.

@khungate Thank you for the swift reply, we’ve not upgraded yet, was just wondering if that could have the affect to why it’s not working. Maybe I need todo something prior before running the wp action scheduler? I just installed it, set my settings, then tried to run the command. No fatal errors.. It’s still syncing almost 47hrs later :S

Seem to be stuck. Can you somehow abort the sync from the admin panel?

@khungate

I have checked out the article. I tried to run commands but when trying to run:

/usr/bin/wp --url=https://DOMAINHERE.com --path=/wp-content/plugins/mailchimp-for-woocommerce action-scheduler run --group="mc-woocommerce"

I receive the error:

Warning: No WordPress installation found. If the command 'action-scheduler run' is in a plugin or theme, pass --path=path/to/wordpress`.
Error: ‘action-scheduler’ is not a registered wp command. See ‘wp help’ for available commands.`

So I tried to run something different, with a proper path and I see a result that says no batches have been executed:

0 batches executed.
Success: 0 scheduled tasks completed.

@dbook1337 please update the plugin to version 2.3.5. We just released that this morning. Then go to the plugin overview page – then add &resync=1 to the url and then reload the page.

You’ll see a button that says Force Resync. I would push that button now because you may have had a fatal error that went uncaught previously.

Since you’ve only synced 600 orders, this is perfectly fine to do now.

I would like to know what happens after you’ve done this if you could please report back. Thanks!

• This reply was modified 4 years, 8 months ago by ryanhungate.

I’ve went ahead and done that, and got the message:

Starting the sync process...

The plugin has started the initial sync with your store, and the process will work in the background automatically. Sometimes the sync can take a while, especially on sites with lots of orders and/or products. It is safe to navigate away from this screen while it is running.

Should I try the CLI commands again now, or see if things are sped up from this resync?

We were up to about 38k orders synced, after weeks of letting it run.

I also want to ask if it’s normal for the Abandoned Cart feature to not work during the sync?

We’ve had it set up for about a week, and haven’t seen one email go out from it.

@dbook1337 38k is a lot more than 600… ?? It’s fine though. If you’re running this in the CLI mode, is it on a cron schedule? Hopefully you have that running every minute? CLI should be running pretty fast, so weeks is way too long for that number of orders. Let’s touch base today to see what type of progress you’re making – and if you’re still having trouble with the speed, we can try a few tweaks together.

Oh – and also that’s correct – all automations are paused during syncing – so getting the store “finished” is a requirement for those to fire again.

@ryanhungate I’ve got the job scheduled, and things seem to be syncing quite quickly (almost a thousand an hour), which is great.

However, I now noticed that certain jobs are not working in WooCommerce.

For example, if I go to Analytics > Revenue, the revenue numbers are not being updated, even with orders coming in. While this isn’t a major issue, I am concerned there might be other more important jobs that aren’t being completed.

Also, when I go to the Scheduled actions, I see a notice:

Maximum simultaneous queues already in progress (1 queue). No additional queues will begin processing until the current queues are complete.

@dbook1337 just to be sure we’re talking about the same thing, when you’re referring to Revenue, are you referring to Mailchimp’s campaign revenue reporting, or something else like Google Analytics?

If you’re sending out campaigns and you know you’re getting traffic / sales from them, but not seeing results, something might be off with the campaign association during the order create process.

We would want to know if you’re using paypal or another service that makes use of an OAuth window during the purchase process. Can you please confirm your payment gateways?

Hi @dbook1337, we just wanted to check back with you to see if this was still a problem with our latest plugin (2.3.5 at the time of this post). Please let us know when you get a moment, we’ll be happy to help troubleshoot further if necessary.

Hi @dbook1337 we’re going to close out this ticket for now since it’s been a few weeks since we’ve been in touch.

Please let us know if you still need any help and we’ll be glad to reopen and troubleshoot further. Please note, the best way to reach us is over at the GitHub plugin page. From there, you can receive direct responses from the development team, log new issues, download the latest version and track existing support tickets.

@khungate so everything was working fine – including the revenue (reported revenue in WooCommerce), and we were syncing anywhere from 20 – 40k orders a day.

However, towards the end, with about 2,000 orders left to go, we’ve seen it slow to almost a halt. We’ve at around 598,000 of 600,000… and it’s syncing slower than we get orders.

Very frustrating as we’ve waited so long to get to this point.