Rules Engine Mapping Order Data
  1. Help Center
  2. Rules Engine Guide
  3. Rules Engine Mapping Order Data

How do I map custom fields to QuickBooks Online?

Although QuickBooks allows you to map custom fields, you cannot map them by name. Instead, you must map the field name in the order it appears in QuickBooks. 

Can I map all ten Custom Fields in QuickBooks Online?

QuickBooks Online allows users to create up to ten custom fields.  Connex can only map to the first three custom fields at this time.  (This is a limitation of QuickBooks, as it only allows users to set values for the first three).

Tip: use the Connex Order Previewer on a test order, as the preview will show how those custom fields will be mapped when syncing the order to your QBO.

How do I use the Rules Engine to map Custom Fields in QuickBooks Online?

Phase One: Enable Custom Fields in QuickBooks Online

Here are the steps:

  1. Login to QuickBooks Online.
  2. Click the gear box on the top right of the screen (settings).
  3. Choose Account and Settings.
  4. Click Sales.
  5. Under Sales Form Content, enable custom fields.

Here is an example of the QuickBooks Online custom fields:

 

View a list of custom fields to map

Connex's order previewer tool will show a list of sales. If you use WooCommerce, you must check sync custom fields under the transaction tab of the Connex configure page.

To use the tool, follow these steps:

  1. Login to Connex.
  2. On the left, click orders and click order previewer.
  3. Fill out the search form to view your sale. If you use Shopify or WooCommerce and the order number fails to return the proper sale, use the date range search.
  4. Expand the sale.

You will see two tabs. The first tab shows a list of custom fields that can be mapped. Without mapping, these fields remain unused. The second tab shows a list of custom fields that will sync to QuickBooks.

Add Mappings

Your rules must specify the QuickBooks field name, which in this case is PO, and the field name from your website:

  1. Go to the Connex rules engine.
  2. Click Add New Rule.
  3. Choose 'Map custom field to another custom field'. Click Advance.
  4. Create rule, click Finish.
    QBO Custom Field Rule

ShipStation: How are the fields displayed?

ShipStation has three custom fields, all of which we can map successfully.

When making rules in Connex, remove all spaces between the words and letters (Custom Field 1 -> CustomField1):

 

How they are displayed in ShipStation, via Order Notes

When Mapping in Connex, these would be the names of the Custom Fields:

  1. CustomField1
  2. CustomField2
  3. CustomField3

To map the ShipStation CustomField1 to the QuickBooks Online PO field, create this rule:

ShipStation QBO CustomField1

Infusionsoft by Keap

Here are the steps:

  1. Login to Infusionsoft.
  2. On the top nav, click the arrow icon down.
  3. Under admin on the right, click settings.
  4. On the right, select order under set up custom fields for.
  5. Click go.
  6. Create a field and click view API names. In this example, the field is PurchaseOrder.
  7. Follow the steps to add custom field mappings, as shown above. Enter the API name in the map from.

Can I hard-code values?

Our rules engine is designed to map one field to another. Unless the field exists on the order, we will fail to map it. This is the recommended approach.

As a workaround, you can use the QuickBooks class or location fields. There are many benefits:

  1. You can easily set these fields without a rule. Log into Connex. Click manage. Expand Orders > Sync Orders to QuickBooks > Transaction. Adjust the drop downs.
  2. QuickBooks has sales by class and location. Go to reports and look up the proper report.

 

If the above suggestion is not applicable for your account, the following is another alternative that can be pursued, particularly for hard-coding Sales Rep values:

1. Login to Connex, go to Rules Engine >My Rules

2. Click Add New Rule. 

3. For 'Type of Rule', choose 'Map field, based on a condition'. Click Advance:

Screen Shot 2022-01-26 at 11.36.16 AM

4. Give your rule a name, and for step 2, choose 'Map Order Sales Rep' from the drop-down:

Screen Shot 2022-01-26 at 11.54.01 AM

5. For step 3, 'What conditions need to be met for this rule to execute?', click Add. Enter your conditions. Then, click Update. 
  • The 'Field To Check' > Sales Rep
  • The Comparison > Is Not
  • The Conjunction > OR
  • Initial Value > The value you want mapped (Meaning if you want to hard-code "ST" to the Sales Rep field in QuickBooks, you would enter "ST"):

    Screen Shot 2022-01-26 at 11.58.26 AM

6. For step 4, 'What should the value be?', enter the value you want hard-coded (Meaning if you want to hard-code "ST" to the Sales Rep field in QuickBooks, you would enter "ST" here as well):

Screen Shot 2022-01-26 at 12.06.31 PM

7. Finish the Rule Creation wizard.