The sales order could not be imported because the combination of the United States store shipping zone and the FedEx (Ground Delivers: Fri, Dec 1) store shipping method is not mapped to a Ship Via or the mapping is inactive in the store settings.

Since the requested service would be different each day, I’m not sure the formula above would work.

I’d probably try an import scenario and pre-import the possible Ship Vias ahead of time.  Try a week or 2 to test.  

Then if that works out, I’d create a business event that runs daily or weekly to add new ones and remove old ones if you don’t want a really long list.  

Let me know if you need help with the Import Scenario or Business Event if this is the direction you want to go.  

@titus71 , I have the formula above working in live environment for a couple weeks now with no issues.  I have a much longer list of iff statements in my formula though, to account for all the different ship vias.  I’m on 23R1 though.  If I’m not mistaken though, Entity Mapping always overrides the store’s settings.  You can also try keeping the mapping active, and disabling all the Ship Via settings in the Stores screen, and see what result you get (although, I didn’t have to do it).

@bryanb39 , yes, I put that formula into the Sales Orders entity for the Ship Via field.  Thanks for clarifying.

@jib87 , how does the order look in BigCommerce? Can you send us a screenshot?  I’m particularly interested in how the Shipping Method is spelled out in BigCommerce.

The formula seems to be fine, and should default to ‘Flat Rate’, of course, provided that you have ‘Flat Rate’ and ‘Ship By’ set up as Ship Vias in Acumatica.