Can I map the value of a custom field to a field in QuickBooks?

How to make a condition based on a custom field

Introduction

Shopify has many fields with no one to one mapping with QuickBooks. Connex stores these fields inside custom fields. You can use the rules engine to map them. In this example, we will say if any custom field equals Jacobson Salt Co., then map the QuickBooks inventory site field.

Get the field value

Here are the steps:
  1. On the left, click orders and go to the order previewer.
  2. Look up a sale.
  3. Click the custom fields tab.
  4. Note the field value: 
Screenshot 2023-09-14 at 4.16.14 PM

Rules

If any field has a value of Jacobsen Salt Co., then the QuickBooks inventory site will say Jacobsen. Here are the steps:

  1. Go to the rules engine.
  2. Click add new rule.
  3. As the action, choose map inventory site.
  4. In the rules, enter these values: custom field value, equals and Jacobsen Salt Co.
  5. In the map to, enter Jacobsen as the value.