When sales orders are pushed into Acumatica and are in a status of Open but the Sales Order has not been approved in Acumatica, the BigCommerce Connector pushes back a status update to the order in BigCommerce and changes the order status to “Manual Verification Required”. Is there a way we can change that mapping and/or ignore that in the connector?
Best answer by smarenich
View original
+3
I think you can try export filtering by the order status.
+3
By the way, another way to block this is to set Order Sync Direction to Import Only. In this case change of order status Acumatica won’t cause anything in BigCommerce
+3
Please note that you have to type StatusId in the field, it wont give you selection. Field is case sensetive.
Formula:
=Switch(
[SalesOrder.Status]='Back Order', 3,
[SalesOrder.Status]='Cancelled', 5,
[SalesOrder.Status]='Completed', 2,
[SalesOrder.Status]='Credit Hold', 12,
[SalesOrder.Status]='Hold', 1,
[SalesOrder.Status]='Open', 11,
[SalesOrder.Status]='Pending Approval', 11,
[SalesOrder.Status]='Shipping', 9,
[SalesOrder.Status]='Rejected', 6,
[SalesOrder.Status]='Invoiced', 11,
11)
11 here means Awaiting Fulfilment Status
Thank you
There is an extra “,11” at the end of the string before the closed parenthesis. Is that necessary?
=Switch([SalesOrder.Status]='Back Order', 3,[SalesOrder.Status]='Cancelled', 5,[SalesOrder.Status]='Completed', 2,[SalesOrder.Status]='Credit Hold', 12,[SalesOrder.Status]='Hold', 1,[SalesOrder.Status]='Open', 11,[SalesOrder.Status]='Pending Approval', 11,[SalesOrder.Status]='Shipping', 9,[SalesOrder.Status]='Rejected', 6,[SalesOrder.Status]='Invoiced', 11,11)
I am getting occasional errors in the commerce sync of
“The system failed to convert value to type Int32 during the mapping processing. Please make sure that custom field mappings are correct.”
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
