How do I map values from QB custom fields to my ordering solution?


QB allows you to make custom fields for customers and items. If you make a custom field for a customer, it will appear on its orders.

How do I know if I am using a custom field?

In QB, open an order. On top, click formatting and click customize data layout. Anything beneath the other field is a custom field. Click here for a diagram.

How do I make custom fields on sales receipts, sales orders, or invoices?

Here are the steps:

  1. In QB, go to the customer center.
  2. Double click a customer.
  3. Click additional info.
  4. On the right, click define fields.
  5. Make a custom field and mark its data type as all text:qb_custom_1.png

How do I map custom fields from QB to a field in my ordering solution?

In this example, we will map a QB custom field called Acct Number to the ShipStation custom field 3. Here are the steps:

  1. Login to Connex.
  2. Click configure at the my connections page.
  3. Expand the sync from QuickBooks section.
  4. Check sync QB custom fields.
  5. Click submit.
  6. Hover over the gear.
  7. Click rules engine.
  8. Click add new rule.
  9. Add a rule like this one: 

The rule says if QB contains a custom field called Acct Number, then map it to the ShipStation custom field 3.

How do I map to QB custom fields?

The same rule applies. The map to is the QB custom field name. Instead of CustomField3, enter Acct Number. The comparison should be map all. The field name can be any of these options:

  1. Order PO
  2. Order Number
  3. Order Tracking

If you need other fields, please contact us.

Have more questions? Submit a request
Powered by Zendesk