Hi Everyone,
During the holiday shopping season several of our clients have received very large shopify payouts. These are causing errors when creating a bank deposit in NetSuite due to the large amount of transactions.
This is a suggestion to break up these large payouts into even smaller bank deposits in order to prevent the scrip time errors.
Fixing these errors manually is time consuming.
Thank you.
Hi David,
Thank you for the suggestion. We have a process to address these time out issues that is actually similar to your suggestion. What we normally do is to adjust the batch and/or page sizes in the Shopify Payout flow so that a large record can be broken down into more manageable pieces.
However, there is not set value that we can point to that is a guaranteed fix. It takes a bit of trial and error to hit the right value that will process the payout in a relatively fast pace while maintaining a continuous, error-free processing.
If you or your client needs help in resolving time out issues in your Shopify Payout add-on, please feel free to raise a ticket and we’ll be more than glad to help you out.
Hi Jay,
These flows have only one record in the page with thousands of detail lines that get applied to the the deposit.
I’d like to learn how the batch and page settings would apply in this case.
Can you explain?
Hi Jay,
You got me curious…
Is it the page size of the transaction lookup that determines how big the batches are?
Hi David,
Yes, that is the correct step where you can change the page size if you want to reduce the size of each deposit created for the payout record.
If your main goal is to prevent the script execution timeout errors on your payout flow, you can consider following this guide first before tweaking the page size:
Thanks. I’ll try setting that lookup down to 1000 instead of 2000. I don’t see what relevance the duration setting has to this topic. I typically only utilize that when setting up a new integration and there’s cutover period to manage. Can you explain?
Hi David,
The "Duration to reconcile transactions" setting enables you to optimize search operations and reduce script execution timeout errors.
You can set a number of days preceding the current date for which you want to reconcile transactions. This will optimize the search for transactions since only transactions created within the "n" number of days will be checked. (If you are not sure how many days, you can set a higher value (60 or higher) which is still better than leaving it empty)
If you leave it empty, all available transactions in NetSuite are retrieved for reconciliation. Most script execution timeout errors in the payout flow are caused by searching transactions in NetSuite for too long.
Thanks everyone for all the advise here. I’ll use this to help setup future clients for success.
