Solved

Shipping Method when Exporting to BigCommerce

  • 25 January 2022
  • 8 replies
  • 87 views

Userlevel 4
Badge +3

Hello community,

Is there a way to map Ship Via code from Acumatica to Shipping Method in BigCommerce when doing sales orders / shipment export? I’m specifically talking about uploading net new orders from Acumatica to BigCommerce.

The mapping on the BigCommerce Stores > ORDER SETTINGS tab seem to work only one way.

Thank you,

Yuriy Karpenko

icon

Best answer by smarenich 25 January 2022, 21:19

View original

8 replies

Userlevel 6
Badge +3

@yurik05 Currently Ship Via is not mapped for export of sales orders.

I think you can use EntitiesMapping window to map ShippingMethod and ShippingZone. If you have more complicated requirements, you can look at the customization capabilities.

I will also add your request for future considerations. 

Userlevel 4
Badge +3

@smarenich , the issue is that on the Entities Mapping screen, source field is empty:

Clicking that dropdown shows nothing to me (tried in a couple different instances. Even if they are there, I’m not sure it’s solving the issue.

Userlevel 6
Badge +3

@yurik05  you can type formula in the Source Field/Value, like in the import scenarios

For example: =’fedex’

Userlevel 4
Badge +3

@smarenich , right, but that would be static, no? Do you think this will work?

=switch([SOShipment.ShipVia]='UPSGROUND','UPS Ground',[SOShipment.ShipVia]='FEDEX','FedEx')

Thank you!

Userlevel 6
Badge +3

@yurik05 unfortunately, in BigCommerce it a know bug. This problem is fixed in Acumatica 2021r120 version.

Until this build I think I can offer you a customization. Similar to what is suggested by Vivek here - 

 

Userlevel 4
Badge +3

@smarenich , when are you planning to release 2021R120? Upgrade might be easier in this case (vs. customization). Thanks!

Userlevel 4
Badge +3

@smarenich , ideally, I think it would be nice if we could use the same SHIPPING OPTION MAPPING form on the ORDER SETTINGS tab of the BC201000 screen, so that the export mapping would not need to be re-configured on the Entity Mapping screen.

Userlevel 6
Badge +3

@yurik05 the 2021r120 will be released by the end of Feb.

I’ll see of what we can do with mapping, may be in the future versions we can bring the better mapping. Thanks for the suggestion.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved