- Connex for QuickBooks User Guide
- Getting Started with Rules
-
Connex for QuickBooks User Guide
- Getting Started with Connex for QuickBooks
- Remote Desktop (RDP)
- Customers Matching
- Inventory Site
- Inventory Sync
- Multicurrency
- Orders
- Price Levels
- Products
- Refunds
- Sales Tax
- Sales Orders
- Unit of Measure
- Web Connector
- Getting Started with Rules
- Rules Engine Common Rules
- FAQ
- Deposit Match
- Cost of Goods Sold
- Troubleshooting
- Custom Store
-
Connex Ecommerce Analytics
-
Frequently Asked Questions
-
General Troubleshooting Guide
- Deposit Match Troubleshooting
- QuickBooks Desktop Error Messages
- Inventory Troubleshooting
- Incorrect Orders Troubleshooting
- Sales Tax Troubleshooting
- Web Connector Troubleshooting
- QuickBooks Online Error Messages
- Match Deposit Tool Troubleshooting
- Product Matching Troubleshooting
- Customer Matching Troubleshooting
- Rules Engine
- Orders from QuickBooks
- Payments Troubleshooting
- Company File
-
Connex for QuickBooks Integrations Guide
-
Rules Engine Guide
Getting Started with Rules: Comparing Custom Field Values
How to compare custom fields to map fields
How do I compare the field?
Many fields between selling channels and QuickBooks have no field mapping. Connex places these values into custom fields, which you can map later. Using our order previewer, here is an example:
In this example, we have a ShipStation order. It has a field called CustomField2 and its value is LOW RISK, VISA. We will map NET 30 to the QuickBooks invoice terms field, based on this condition.
- Go to the rules engine.
- Go to add new rule.
- Choose no template. Scroll down and check the box saying rule without order number.
- Click submit.
- Add a title for the rule.
- In conditions, enter these values: Custom Field Value, Equals, LOW RISK, VISA.
- In the box at the bottom, enter NET 30.
How does the rule work?
- The custom field value contains loops through all the custom fields and returns their value.
- The software makes the phase and comparison lower case. Does low risk, visa match any rules? Yes, it matches a rule.
Can I use contains?
Yes, you could say if the field contains low risk, then map NET 30 as the terms.