{"id":14938,"date":"2020-10-27T22:56:07","date_gmt":"2020-10-27T22:56:07","guid":{"rendered":"https:\/\/synder.com\/help\/?p=14938"},"modified":"2026-07-01T18:51:37","modified_gmt":"2026-07-01T18:51:37","slug":"product-mapping-feature","status":"publish","type":"post","link":"https:\/\/synder.com\/help\/product-mapping-feature\/","title":{"rendered":"Synder Product Mapping Feature"},"content":{"rendered":"\n
This guide shows you how to use the product mapping feature in Synder. It applies to e-commerce businesses, accountants, and finance teams who sync transactions from payment platforms like Stripe, Shopify, or Amazon to their accounting system.<\/p>\n\n\n\n
Use this guide if:<\/p>\n\n\n\n
This article focuses only on product mapping. It does not cover:<\/p>\n\n\n\n
Synder recognizes existing product names in your accounting system. During sync, it looks for an exact match by product name or SKU. If it finds one, Synder applies that product to the transaction.<\/p>\n\n\n\n
If a product name does not exist in your accounting system, Synder can create it during sync. You can configure this behavior in the Products\/Services<\/strong> tab.<\/p>\n\n\n\n Sometimes product names differ between your payment platform and accounting system. In that case, you can map them in Synder. This ensures each transaction uses the correct product in your books.<\/p>\n\n\n\n Note:<\/strong> The product mapping feature is available on the Essential plan and higher.<\/p>\n\n\n\n To map product names from your payment platform to your accounting company:<\/p>\n\n\n\n <\/p>\n\n\n\n Result Overview<\/strong><\/p>\n\n\n\n After mapping the products, the system will eliminate duplicate entries in your accounting system. Transactions will be recorded and categorized according to the income accounts linked to each product in QuickBooks Online.<\/p>\n\n\n\n To control which items Synder records in your accounting, enable the Cancel Synchronization<\/strong> option.<\/p>\n\n\n\n When enabled, Synder automatically cancels any transaction that contains an item not present in your accounting records.<\/p>\n\n\n\n The Collect Items for Product Mapping<\/strong> option becomes available when \u201cIf the matching product is NOT found in accounting \u2013 Cancel synchronization\u201d is enabled in the settings. This option is disabled by default.<\/p>\n\n\n\n After synchronizing a transaction that contains products not yet in your accounting records, the transaction will be canceled. Products not present in Striep will appear on the Not Mapped<\/strong> page in the mapping settings. You can map these products to the appropriate items in the accounting system.<\/p>\n\n\n\n Managing large numbers of SKUs across multiple platforms requires efficient product mapping. Synder allows bulk uploading of product mappings using a CSV file. <\/p>\n\n\n\n Bulk product mapping enables matching integration products or SKUs (from platforms such as Amazon, Shopify, Stripe, etc.) with accounting products in QuickBooks Online, QuickBooks Desktop, or Xero through a CSV file upload. This process eliminates manual product mapping. Download the Template<\/strong><\/p>\n\n\n\n Fill Out the Template<\/strong><\/p>\n\n\n\n The file must include the following columns:<\/p>\n\n\n\n Requirements:<\/strong><\/p>\n\n\n\n Save the file in CSV format.<\/strong><\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\nProduct Mapping Flow in Synder<\/strong><\/h2>\n\n\n\n
\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
Important Notes<\/strong><\/p>\n\n\n\n\n
<\/figure>\n\n\n\nCollect Items for Product Mapping<\/strong><\/h2>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\nProduct Mapping: Import via file<\/strong><\/h2>\n\n\n\n
<\/p>\n\n\n\nHow to Prepare Your File<\/strong>
<\/strong><\/h3>\n\n\n\n\n
<\/figure>\n\n\n\n\n
<\/figure>\n\n\n\n\n
<\/figure>\n\n\n\n\n
<\/figure>\n\n\n\n\n
Uploading Your Product Mapping File<\/strong><\/h4>\n\n\n\n
\n
<\/figure>\n\n\n\nWhat Happens Next<\/strong><\/h4>\n\n\n\n
\n
Tips and Best Practices<\/strong><\/h2>\n\n\n\n
\n
Troubleshooting<\/strong><\/h2>\n\n\n\n
\n
<\/li>\n<\/ul>\n\n\n\n