Skip to main content
Solved

BigCommerce 2020R2 - How to Restrict Shipping Option Mapping


vivekm
Varsity I
Forum|alt.badge.img

Hi Team,

We are working with 20.221.0021 build and we have a requirement to use a default Ship Via on importing order from BigCommerce to Acumatica instead of using the Shipping Option Mapping grid. Can you please confirm if is it possible through Entities Mapping screen or the best possible way to do it.

And if there is a way we can stop populating the Shipping Option Mapping grid.

 

Thank you!

Best answer by smarenich

@vivekm if you map ShipVia in the entities mapping, it should have higher priority than grid mapping, so it should work. I encourage you to test it.

 

View original
Did this topic help you find an answer to your question?

9 replies

smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • Answer
  • December 8, 2022

@vivekm if you map ShipVia in the entities mapping, it should have higher priority than grid mapping, so it should work. I encourage you to test it.

 


vivekm
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 78 replies
  • December 9, 2022

Hi @smarenich, Thank you for the details.

I tried to work with that but in that case, we have to provide Source Object and Source Field/Value as those are required fields but when we do that then that mapping will be taken into consideration.

Can you please suggest how we can handle that.

 


smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • December 9, 2022

@vivekm source object you can choose anything

And in the source field you should write formula with needed ship via code.


vivekm
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 78 replies
  • December 12, 2022

Hi @smarenich I have tried but still getting shipping option mapping validation. Can you please review below steps and suggest what I am missing here:

  • Declared Import Mapping condition.
  • Tried to import the Order.
  • One new row added to shipping option mapping grid.
  • And Order import failed due to missing shipping option mapping.

 


smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • December 12, 2022

@vivekm would it be possible for you to put any ship via in the mapping table?

The validation for the ship via happens before the mapping, but mapping will still override the configuration provided in the table.


vivekm
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 78 replies
  • December 12, 2022

Hi @smarenich  yes, we can use any ship via to the mapping table but the issue remains same as the validation happens before the import mapping and is the reason initially every order fails because under shipping option mapping grid, store mapping method in not mapped to any Acumatica ship via.

Is there any way to achieve it, can you please suggest.

  • Also, I have tried below Import Mapping.
  • Initially order import fails.
  • Then have provided value to shipping option mapping grid.
  • And imported the order.
  • But at order level the ship via updated from shipping option mapping grid, instead of Entities Import Mapping.

 


KseniaBurtseva61
Acumatica Employee
Forum|alt.badge.img

Hi @vivekm We reproduced the issue. Unfortunately, Ship Via from Entity Import Mapping does not populate or override store's ship via mapping as it should be. Please, create a support case.  


KseniaBurtseva61
Acumatica Employee
Forum|alt.badge.img
KseniaBurtseva61 wrote:

Hi @vivekm We reproduced the issue. Unfortunately, Ship Via from Entity Import Mapping does not populate or override store's ship via mapping as it should be. Please, create a support case.  

@vivekm Also tested with 22R2 - Import Mapping works well with this build. 


vivekm
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 78 replies
  • December 13, 2022

Hi @KseniaBurtseva61 Thank you for the details.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings