Any developers here? Do you know the logic of Ship Via import from BigCommerce in 23R1?
We have this weird scenario, where if an order has a shipping method in BC that is not mapped on the BigCommerce Stores > Shipping Methods screen, Acumatica will not throw an error on import, but will use a UPSGROUND shipping method.
We used to have a formula in Sales Orders entities screen for Ship Via, like this:
=iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Ground')<>-1,'UPSGROUND',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Standard')<>-1,'UPSSTD',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Early')<>-1,'UPSNDAAM',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], '2nd Day Air')<>-1,'UPS2Day',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Next Day Air')<>-1,'UPSNDA',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Express')<>-1,'UPSWWEXPR',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Wordldwide Sav')<>-1,'UPSWWSAV',iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Drop Ship')<>-1,null,iif(InStr([OrderData -> OrderShippingAddresses.ShippingMethod], 'Pickup')<>-1,'WILL CALL','UPSGROUND')))))))))
So, obviously, according to this formula, UPSGROUND is the fallback value, but we’re confused, because this mapping line is not active, and still all the orders with not explicitly mapped Ship Via come in with UPSGROUND.
Could it be that the connector still looks at the formula even though it’s not active?
We’re on 23.113.0042 (and also B2B customization is installed).