Customer Deposits not being Created Intermittently
Anyone else seeing intermittent issues where Customer Deposits are not being created by the Integration App?
We have 3 sites across 2 clients where the Create Sales Order Flow (scheduled) does not properly trigger the Create Customer Deposits Flow (real time) which means that the cash recorded from customer payments for Shopify orders does not get recorded in NetSuite. So when Sales Orders get shipped and Billed, the Invoice is NetSuite remains unpaid even though the order was paid for on Shopify.
For one client this has been happening since at least February 2022 and now a second client just found it happening since early April 2022.
I do have Support Tickets are open on this issue.
Martin, have you received any answers on this?0
I've had a few follow-ups with the support team but a resolution/fix has not been provided. We have however implemented an effective and reliable work around. We disabled the Create Customer Deposit Flow and added a User Event Script on the Creation of Sales Orders in NetSuite with the appropriate conditions and mappings to create the customer deposit. It is not ideal as it is not as easy manage as it is all in SuiteScript (code) but it has been 100% reliable.
I can understand why the Celigo product team separated the Sales Order Flow and Customer Deposit Flow so that each can be enabled independently since the flows are part of the Shopify Integration App and are therefore locked from any edits.0
We experienced this just recently for the first time. Curious if you're still using your script or if Celigo has made any progress. Have you noticed if this issue is on all payment types? Ours happened on an order with PayPal as the method of payment, although I'm not sure that would matter. It's just weird that it would be so intermittent -- wondering if there's a common thread with the errored orders.0
We ran into this recently and mostly resolved it; what's the error message on the Customer Deposit flow?0
James Hamilton where we have seen this issue occur, there are not any errors on the Customer Deposit Flow. The behavior we have seen is that the Sales Order Flow just fails to trigger the Customer Deposit Flow and unfortunately being a locked integration app, we cannot add any logging or additional step to verify the deposit was created.
Kala Tech we are still using a the User Event Script for one of our clients and have the Customer Deposit Flow disabled. I believe the logged ticket was closed as we were not willing to commit additional time chasing an intermittent issue for which there was not way for us to apply any logging (and were not going to try to break a production system to replicate the issue for the Celigo support team). It was more time effective on our side to develop the work around with the custom script.
On the other client, we only saw the problem one time so did not end up adding the User Event Script. However we have a Scheduled Saved Search setup in NetSuite to identify when any Sales Orders from Shopify end up being created without a Customer Deposit so we can catch the issue early when it happens.0
Please sign in to leave a comment.