I want to ensure that 100% of our orders are imported from WooCommerce to Google Sheets.
What is the problem & what have you tried?
Approximately 5% of orders are missing from Google Sheets. This has persisted for 2 years.
Triggers: we watch both “Completed” and “Processing” orders (digital products). In both cases payment is already made.
Sorting: we sort by Date Paid because WooCommerce analytics also uses date paid to measure revenue.
Volume: Limit is set to 200 but we never have more than 10 order in 30min timeframe.
My Question:
How could we improve scenario or how could we find the issue why some orders are not being imported? is there a way to leg these skipped orders?
It looks like your error might be related to an issue when processing the billing Country code field. When that field is empty, null, or does not quite fit the 2-3 character ISO code an error is likely generated. The reason you are not seeing an error is because you have an Ignore path setup as an error handler which may be necessary but it is causing the scenario to just skip those errored results and move on with the correct ones.
This is fixable in one of two ways. You could add an error handler on the ISO module to capture these failing orders and process them separately. Or you can add a filter before the ISO module to check that the Billing Country is not empty and then decide how you want to route those instances in the event that they are empty.
Thank you for the suggestion. I have now replaced the “Ignore” handler on the Woo module with a Break and retry directive, and added a Resume directive to the ISO module to handle issue in country name. I’ll monitor the scenario from today to ensure all orders are captured. Thanks again for the help
What is your goal?
What is the problem & what have you tried?
Error messages or input/output bundles
Create public scenario page
Screenshots (scenario flow, module settings, errors)
