If the order number in QuickBooks matches the order number coming in, Connex finds the duplicate and skips it.
Next Number from QuickBooks
Connex adds the original order number in the memo field.
- Connex inserts the original order number in the memo field.
- From the Connex advanced tab, there is a box with a negative number. Connex checks for modified orders by subtracting that number from the current day. -1 represents a day ago.
- If a modified order has the original order in the memo field, Connex finds the duplicate and skips it.
Order Number Longer than Eleven Characters (Amazon, eBay)
If the order is longer than eleven characters, here is a detailed description of our duplicate system:
- The QuickBooks order number field can only hold eleven characters. Since the order numbers are about nineteen characters, the first eleven are inserted into the QuickBooks order number field. If you use an order prefix, then the order prefix plus the first nine characters are inserted into that field.
- Connex cannot query orders directly by the memo field (Select all orders where the memo field is X.)
- Connex queries orders by the order number field using the first eleven characters of the order number. Since it is possible to have two orders with the first eleven characters being the same, Connex can get two orders from QB.
- Each order has the memo field. Connex enumerates through the orders, finding a match with the full order number and the memo field.
Here is a sample Amazon order.
I am performing a two-way sync of orders, but I use the next number from QuickBooks. How does Connex find a match?
Connex will try these combinations:
- Do the first 11 characters of the QuickBooks order number match the first 11 characters of the order number? If so, does the order date and QuickBooks date match?
- Is the original order number in the QuickBooks memo field?
In this example, either combination would work: