Skip to main content
Question

How to change the Acumatica Sales Order type based on a mapped field in Shopify?

  • September 18, 2026
  • 1 reply
  • 10 views
dgodsill97
Varsity I
Forum|alt.badge.img+6

The client needs to have a different order type for orders passed thru Shopify from TikTok.  An Order Data field, Source Name, is populated with ‘TikTok’. A different Acumatica Sales Order Type is required because TikTok takes care of the reporting of sales taxes so Tax Calculation needs to be disabled.  The normal Shopify Orders are only taxed in two states and the client has Avalara.

The Expression Editor only can be used for the External fields.

    1 reply

    riglesias
    Acumatica Employee
    Forum|alt.badge.img+2
    • riglesias
    • Acumatica Employee
    • September 18, 2026

    Hello ​@dgodsill97 

    Have you tried using Shopify metafields? These fields can be used to map an if expression under entities screen. 
     

    Rodrigo ~ A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    Terms & ConditionsAccessibility statement
    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 — 2024  Acumatica, Inc. All rights reserved