In a SAP Business One and Shopify integration, match records using IDs you have stored from both systems, not SKU, email, or order number. Those values are easy to read and easy to edit, so they change over time. IDs don't.
Most duplicate orders and phantom customers come from one mistake: using a descriptive field as a matching key.
The Keys That Matter
Item: Match the Shopify variant ID with the SAP ItemCode. Don't match on product title.
Stock: Match the Shopify inventory item ID and location ID with the SAP ItemCode and warehouse code. Don't match on SKU alone.
Customer: Match the Shopify customer ID with the SAP CardCode. Don't match on email alone.
Order: Match the Shopify order ID with the SAP DocEntry. Don't match on the order number (like #1001).
5 Identity Rules
Map items at variant level. A Shopify product groups options like size and color. The variant is what the buyer actually purchases, so each variant maps to one SAP ItemCode. Shared descriptions stay at product level.
Treat SKU as a lookup, not a key. Shopify recommends unique SKUs but doesn't enforce them. Use SKU to find the first match, then store the variant ID and ItemCode pair. If two records match, reject it instead of guessing.
Email is contact data. Two Business Partners can share one inbox, and buyers change their email. Keep a cross-reference between the Shopify customer ID and the SAP CardCode, and send conflicts for review.
Store the order ID, not the order number. The order number the customer sees, the SAP DocNum, and the SAP DocEntry are three different things. Save the Shopify store and order ID against the DocEntry so a repeated webhook updates the existing document instead of creating a second one.
Check before you retry. If a write succeeds but the confirmation is lost, look up the record in the destination system using the stored reference before trying again. That check is what stops duplicates.
Why It Matters
Once a match is stored, later changes to a title, SKU, or email update the right record. Without it, every change risks creating a duplicate.
For the full field-by-field rules on prices, tax, discounts, and warehouse quantities, see the APPSeCONNECT SAP Business One Shopify data mapping guide: https://www.appseconnect.com/blog/sap-business-one-shopify-data-mapping-guide
Top comments (0)