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.
Use this guide if:
- You sell the same products across multiple platforms with different SKUs or naming conventions.
- You need consistent and accurate product records in your accounting system.
- You manage a large product catalog and want to streamline reconciliation and reporting.
This article focuses only on product mapping. It does not cover:
- Initial setup of Synder or integration connections
- Inventory management configuration in accounting platforms
- Advanced automation rules beyond product mapping
How Synder treats the products
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.
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 tab.
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.
Note: The product mapping feature is available on the Essential plan and higher.
Product Mapping Flow in Synder
To map product names from your payment platform to your accounting company:
- Navigate to Synder Settings → Product Mapping → Map Products.
- Click Add Mapping to create a new product mapping line.
- Enter the product name from your integration in the Integration field. Make sure the name exactly matches what appears on your payment platform. This includes colons, underscores, and other special characters. You can map multiple platform names to a single QuickBooks Online or Xero product.
- Select the matching product from QuickBooks Online or Xero using the dropdown on the right.
- Click Create to save the mapping.
- Go to the Transactions tab and sync a transaction to verify the mapping works correctly.
Important Notes
- If a mapped product changes, gets deleted, or becomes unavailable in your accounting software, Synder asks you to review and update the mapping. You must fix it before saving any other settings.
- Product mapping does not apply to tax or shipping items. These are recorded as separate line items.
Result Overview
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.
Collect Items for Product Mapping
To control which items Synder records in your accounting, enable the Cancel Synchronization option.
When enabled, Synder automatically cancels any transaction that contains an item not present in your accounting records.
The Collect Items for Product Mapping option becomes available when “If the matching product is NOT found in accounting – Cancel synchronization” is enabled in the settings. This option is disabled by default.
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 page in the mapping settings. You can map these products to the appropriate items in the accounting system.
Import Product Mappings in Bulk
Managing large numbers of SKUs across multiple platforms requires efficient product mapping. Synder allows bulk uploading of product mappings using a CSV file.
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.
See the guide for detailed instructions – Product Mapping: Import via file.
Reach out to the Synder Team via online support chat or email with any questions you have – we’re always happy to help you!
