Skip to main content
Solved

How to map BigCommerce Order metafield in formula editor


Forum|alt.badge.img
  • Jr Varsity III
  • 37 replies

Hello everyone,

How to effectively map meta fields of BigCommerce order in the Entities mapping of BigCommerce connector under Formula editor?

This doesn’t work. (order is the namespace and orderType is the key)

 

Best answer by gabrielpaz86

Hi @jib87, Could you please elaborate why it doesn’t work?

Despite being displayed that the formula is invalid, the logic should work.

Please check my example:

  1. I created the order metafield.
  2. Mapped and synced the order. In images we have two ways of mapping. 
    Remark: It doesn’t matter if you use “orderType” or “ordertype” in formula.
  3. In both scenarios it works.
  4. Added some logic and resync order. Since the expected result was ‘OL’. 

     

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

4 replies

gabrielpaz86
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • 22 replies
  • Answer
  • August 19, 2024

Hi @jib87, Could you please elaborate why it doesn’t work?

Despite being displayed that the formula is invalid, the logic should work.

Please check my example:

  1. I created the order metafield.
  2. Mapped and synced the order. In images we have two ways of mapping. 
    Remark: It doesn’t matter if you use “orderType” or “ordertype” in formula.
  3. In both scenarios it works.
  4. Added some logic and resync order. Since the expected result was ‘OL’. 

     


Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@gabrielpaz86 , I’m going to be testing this very soon. Hope it works.

P.S. I have nothing to do with the original request above :)


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 37 replies
  • August 29, 2024

Thank you for your answers and apologies. I haven’t got the chance last week to test the solution. I’ll try it and will keep you updated.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 37 replies
  • August 29, 2024

Just to confirm that the solution worked! Thank you


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