Skip to main content
Answer

How to map BigCommerce Order metafield in formula editor

  • August 19, 2024
  • 4 replies
  • 99 views

Forum|alt.badge.img

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’. 

     

4 replies

gabrielpaz86
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • 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
  • Varsity I
  • 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
  • Varsity I
  • August 29, 2024

Just to confirm that the solution worked! Thank you