- Help Center
- Rules Engine Guide
- Common Rules
-
Connex for QuickBooks User Guide
- Connex for QuickBooks Product Overview
- Getting Started with Connex Desktop
- Connex Quickbooks Online
- Customers Matching
- Inventory Site
- Inventory Sync
- Orders
- Price Levels
- Products
- Purchase Orders
- Refunds
- Sales Tax
- Sales Orders
- Sync Orders from QuickBooks Desktop
- Unit of Measure
- Web Connector
- Multicurrency
-
Connex Reporting
-
Frequently Asked Questions
-
General Troubleshooting Guide
- Contact Support
- Deposit Match Troubleshooting
- QuickBooks Desktop Error Messages
- Inventory Troubleshooting
- Incorrect Orders Troubleshooting
- Sales Tax Troubleshooting
- Web Connector Troubleshooting
- QuickBooks Online Error Messages
- Login and Performance
- Match Deposit Tool Troubleshooting
- Product Matching Troubleshooting
- Customer Matching Troubleshooting
- Rules Engine
- Orders from QuickBooks
- Payments Troubleshooting
- Missing Orders Troubleshooting
- Update Shipping Details Troubleshooting
-
Integrations Help Guide
-
Rules Engine Guide
Can I add an order prefix to the order number?
Connex is programmed to check for duplicate order numbers in QuickBooks when it syncs a customer sale.
This particular feature can be useful when your order numbers are smaller digits or similar to that of another integration.
Here is an example:
You sync invoices from Shopify to QuickBooks. Shopify generates order number 1200. You already have an invoice in QuickBooks numbered 1200. Connex will skip syncing this Shopify order to QuickBooks because it already exists.
Solution or Workaround: Add an order prefix to the auto-generated order number from your integration when Connex creates the sales receipt/invoices/sales orders in QuickBooks.
How to set-up Connex to use an order prefix:
You can accomplish this by using our rules engine:
- Click Rules Engine -> My Rules on the left-hand navigation in Connex
- Click "Add New Rule"
- From the list of templates, choose "Map field, based on a condition" and advance
- What do you want to call this rule? Give your rule a good name so you can reference it later on.
- What actions would you like to take? choose "Add Order Prefix" as the action you would like to take
- What conditions need to be met for this rule to execute? Click "Add", and choose your criteria. (i.e. order prefix equals "AZ" only if the selling channel is equal to "Amazon")
- What should the value be? enter the desired prefix (i.e. "AZ")
- Click Submit.