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. 

QuickBooks Online Custom Fields

QuickBooks Online allows users to create up to 10 custom fields.  Connex can only map to the first three custom fields at this time.  This is a limitation of QuickBooks.

Connex has an order previewer that shows a list of custom fields to map.

Add Custom Fields QuickBooks Online

Here are the steps:

  1. Login to QuickBooks Online.
  2. Click the gear box on top.
  3. Click account and settings.
  4. Click sales.
  5. Under sales form content, enable custom fields.

Here is a screenshot of the QuickBooks Online custom fields:

If your screen looks different, add the field names. we can only map to the first three custom fields that you see.

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. From the templates menu, choose map custom field.
  4. In the conditions area, enter the name of the field:
  5. On the next step, enter PO as the map to value.

    ShipStation

    ShipStation has three custom fields: CustomField1, CustomField2, and CustomField3. In the map from field, enter one of those values.

    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 and 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 > sync manually 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, and from the template, select Start from scratch

    3. For the Rule Action, select Map Order Sales Rep from the drop-down.

    4. Under Conditions, the Field should be Sales Rep, the Comparison Is Not, the Conjunction should be OR, and the Map From value should be the value that you do want mapped (Meaning if you want to hard-code "ST" to the sales rep field in QuickBooks, you would enter "ST").

    5. Under Map To, 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).

    6. Finish the Rule Creation wizard.

     

    Then, perform the following steps:

    1. Click Add New Rule, and from the template, select Start from scratch

    2. For the Rule Action, select Map Custom Field from the drop-down.

    3. Under Conditions, the Field should be Sales Rep, the Comparison Map All, the Conjunction should be OR, and the Map From value should be the custom field name that you do want mapped (Meaning if you want to map to the custom field in QuickBooks called "Sales Rep", you would enter "Sales Rep").

    4. Under Map To, enter the custom field name to which you want the hard-coded value placed (Meaning if you want to map to the custom field in QuickBooks called "Sales Rep", you would enter "Sales Rep").

    5. Finish the Wizard.