Data flows:
- Shopify transaction to NetSuite customer deposit (add)
- Shopify order to NetSuite order (cash sale or sales order)
Issue
The Shopify-NetSuite integration app occasionally fails to create customer deposits in NetSuite for certain sales orders. Due to this issue, the cash deposit from customer payments is not being recorded to NetSuite. Despite billing the sales orders, the invoice in NetSuite still displays unpaid, even though the order was paid for on Shopify.
How customer deposits are created in NetSuite
The Shopify transaction to NetSuite customer deposit (add) flow creates the customer deposits. This flow is triggered automatically after completing the Shopify order to NetSuite order (cash sale or sales order) flow run, from Post Order to NetSuite import > Post submit hook.
During a flow run, the ‘shopifyOrderImportPostSubmitHook’ can have a maximum of “n” number of records, where n = the page size of the Get orders from Shopify export adapter.
Reason
integrator.io generates a new token for each hook execution, and the token expires after 10 minutes. All processing must complete within this timeframe.
Creating customer deposits in NetSuite can be slower than expected, averaging approximately one minute per customer deposit. With the default export page size of 20, processing can take longer than the token lifetime, causing the token to expire before all customer deposits are created.
As a result, customer deposit creation may fail intermittently.
Note: NetSuite processing times vary between accounts. As a result, some customers may experience this issue intermittently, while others may not.
Known limitation
Reducing the export page size shortens the amount of work performed during each post-submit hook execution and helps reduce integrator.io token expiration. However, depending on NetSuite performance and order volume, intermittent customer deposit failures may still occur.
Recommended workaround
- Go to integrator.io and navigate to the Shopify - NetSuite integration app tile.
- Go to Flows > Order.
- Click Shopify order to NetSuite order (cash sale or sales order) flow.
- Click Get orders from Shopify export.
- Expand the Advanced section. In the Pagesize field, enter 10 or less than 10 depending on your requirement.
- Click Save & close.
Note: Avoid setting the page size below 5 unless instructed by Celigo Support. Extremely small page sizes (for example, 3) may trigger connector validation errors such as: Integration is corrupted: the storemap is missing, or the Shopify connection on the storemap is missing.
Since this behavior originates from connector-managed scripts, customers cannot resolve it manually.
Expected outcome
Reducing the page size decreases the number of records processed in each batch, helping reduce NetSuite processing time and lowering the likelihood of integrator.io token expiration.
After updating the page size, re-run the flow and verify that customer deposits are created successfully in NetSuite.
If the issue persists
If customer deposits continue to fail after reducing the page size, especially in high-volume environments, contact Celigo Support for further investigation. Additional troubleshooting or engineering assistance may be required.