Failed to create customer deposits in NetSuite intermittently

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.

In a flow run, the ‘shopifyOrderImportPostSubmitHook’ can have a maximum of “n” number of records, where n = page size of the Get orders from Shopify export adapter.

Reason 

The integrator.io generates a new token for each of the hooks, and the token expiration time is 10 minutes. All the actions need to be completed within this 10-minute timeframe. The integrator.io token is expiring during the process of posting/creating customer deposits in NetSuite. This occurs due to NetSuite's slower processing time, averaging one minute to create a single customer deposit, and potentially taking up to 20 minutes for 20 records, which is longer than the expected timeframe of creating the records within a second.

Note: There's a chance that the slower processing time for creating customer deposits in NetSuite is not consistent across all accounts. This issue can arise in accounts where customers are facing it at times.

In the Get orders from Shopify export, by default, the page size is set to 20, and due to NetSuite’s slower processing time, the token expires and all 20 records will fail.

To resolve this issue:

1. Go to integrator.io and navigate to the Shopify - NetSuite integration app tile.
2. Go to Flows > Order.
3. Click Shopify order to NetSuite order (cash sale or sales order) flow.
4. Click Get orders from Shopify export.

5. Expand the Advanced section. In the Pagesize field, enter 10 or less than 10  depending on your requirement.
6. Click Save & close.

This action will reduce the number of records that need to be processed, which will result in a decrease in NetSuite's overall processing time. Now, re-running the flow will not miss the creation of customer deposits.