Skip to main content
Solved

How to map BigCommerce Order metafield in formula editor

  • Aug 19, 2024 3:40 PM UTC
  • 4 replies
  • 163 views
  • Translate All

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

     

View original

4 replies

gabrielpaz86
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • Answer
  • Aug 19, 2024 6:57 PM UTC

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

     

Translate

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

@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 :)

Translate

Forum|alt.badge.img
  • Author
  • Varsity I
  • Aug 29, 2024 3:14 PM UTC

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.

Translate

Forum|alt.badge.img
  • Author
  • Varsity I
  • Aug 29, 2024 5:22 PM UTC

Just to confirm that the solution worked! Thank you

Translate