{"id":24840,"date":"2025-04-28T16:45:13","date_gmt":"2025-04-28T16:45:13","guid":{"rendered":"https:\/\/synder.com\/help\/?p=24840"},"modified":"2026-08-20T13:27:14","modified_gmt":"2026-08-20T13:27:14","slug":"product-mapping-import-via-file","status":"publish","type":"post","link":"https:\/\/synder.com\/help\/product-mapping-import-via-file\/","title":{"rendered":"Product Mapping: Import via file"},"content":{"rendered":"\n
Managing thousands of SKUs across multiple platforms can be challenging. To make product mapping faster and easier, Synder allows you to bulk upload<\/strong> your product mappings using a CSV file. This guide walks you through the process.<\/p>\n\n\n\n Bulk product mapping allows you to match your integration products\/SKUs<\/strong> (like from Amazon, Shopify, Stripe, etc.) with your accounting products<\/strong> (in QuickBooks Online, QuickBooks Desktop, or Xero) by uploading a CSV file. This feature saves you time by eliminating the need to map each product manually.<\/p>\n\n\n\n An ecommerce brand sells the same hoodie on Shopify and Amazon with different SKUs\/names:<\/p>\n\n\n\n Goal:<\/strong> In the Per Transaction mode, book every sale to one<\/em><\/strong> <\/em>accounting item \u201cHoodie Black M\u201d so revenue, COGS, and inventory stay accurate.<\/p>\n\n\n\n What they do:<\/strong> Download the CSV template and map both Shopify and Amazon identifiers to a single accounting item. Upload once. From now on, any order line with those SKUs\/names will be posted to \u201cHoodie Black M\u201d<\/strong> in the ledger without any manual fixes, clean reports.<\/p>\n\n\n\n <\/p>\n\n\n\n Important<\/strong>:<\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n For more information about Synder features, visit our Help Center or<\/em> reach out to Synder Team<\/em><\/a> <\/strong>via online support chat or email.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":" Managing thousands of SKUs across multiple platforms can be challenging. To make product mapping faster and easier, Synder allows you to bulk upload your product mappings using a CSV file. This guide walks you through the process. What is Bulk Product Mapping? Bulk product mapping allows you to match your integration products\/SKUs (like from Amazon, […]<\/p>\n","protected":false},"author":2299,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","footnotes":"","_ppma_block_editor_authors":""},"categories":[393,361],"tags":[],"ppma_author":[340],"class_list":["post-24840","post","type-post","status-publish","format-standard","hentry","category-products-inventory-cogs-per-transaction","category-products-inventory-cogs"],"yoast_head":"\nWhat is Bulk Product Mapping?<\/h2>\n\n\n\n
Typical Scenario<\/strong><\/h2>\n\n\n\n
\n
\n\n\n\nHow to Prepare Your File<\/strong><\/h2>\n\n\n\n
\n
\n
<\/figure>\n\n\n\n
\n
<\/figure>\n\n\n\n
\n
<\/strong>The file must include the following two columns<\/strong>:\n\n
<\/figure>\n\n\n\n\n
<\/ol>\n\n\n\n
\n\n\n\nUploading Your Product Mapping File<\/strong><\/h2>\n\n\n\n
\n
\n\n\n\nWhat Happens Next?<\/strong><\/h2>\n\n\n\n
\n
\n
\n\n\n\nTips & Best Practices<\/strong><\/h2>\n\n\n\n
\n
\n\n\n\nTroubleshooting<\/strong><\/h2>\n\n\n\n
\n