{"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-03-30T19:20:26","modified_gmt":"2026-03-30T19:20:26","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<p>Managing thousands of SKUs across multiple platforms can be challenging. To make product mapping faster and easier, Synder allows you to <strong>bulk upload<\/strong> your product mappings using a CSV file. This guide walks you through the process.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is Bulk Product Mapping?<\/h2>\n\n\n\n<p>Bulk product mapping allows you to match your <strong>integration products\/SKUs<\/strong> (like from Amazon, Shopify, Stripe, etc.) with your <strong>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<h2 class=\"wp-block-heading\"><strong>Typical Scenario<\/strong><\/h2>\n\n\n\n<p>An ecommerce brand sells the same hoodie on Shopify and Amazon with different SKUs\/names:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Shopify: HD-BLK-M, \u201cHoodie \u2013 Black \/ M\u201d<\/li>\n\n\n\n<li>Amazon: AMZ-HOOD-BLK-M, \u201cBlk Hoodie M\u201d<\/li>\n<\/ul>\n\n\n\n<p><strong>Goal:<\/strong> In the Per Transaction mode, book every sale to <strong><em>one<\/em><\/strong><em> <\/em>accounting item \u201cHoodie Black M\u201d so revenue, COGS, and inventory stay accurate.<\/p>\n\n\n\n<p><strong>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 <strong>\u201cHoodie Black M\u201d<\/strong> in the ledger without any manual fixes, clean reports.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Prepare Your File<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Download the Template<\/strong>\n<ul class=\"wp-block-list\">\n<li>Go to <strong>Settings \u2192 Product mapping<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXepB7aat_YoRWSx0pQtc-qWjV8RDq485YG6rdoAm1g1Htl6lzVqeF_J89jHD3KkDrT_5XQ5zlQnkhXdqp1vf54JgiZga8P22vL9X0dkUIVMb3mPWR_2ReEPiar23E20cvOYFwi5Zw?key=_vEKoi2pKrxCQnTAGTYysA\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click <strong>Upload a CSV file<\/strong> and download the <strong>CSV template<\/strong> provided.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfgQKZYLheKTnMhEdleB-Pn-hJ5NPtZTHrv_UTEwegsExXjleUHUwrzfyCC0nfos20cvAt69rtcw4-n4vG_mRBvNbwbtugJLZkGtLR7pTHpeCLD9m1htQFszsZ08UN4szezsJBrmQ?key=_vEKoi2pKrxCQnTAGTYysA\" alt=\"\"\/><\/figure>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Fill Out the Template<\/strong><strong><br><\/strong>The file must include the following <strong>two columns<\/strong>:\n<ul class=\"wp-block-list\">\n<li><strong>Accounting product name<\/strong>: the product name exactly as it appears in your accounting platform (QuickBooks Online, QuickBooks Desktop, Xero).<\/li>\n\n\n\n<li><strong>Integration product name\/SKU<\/strong>: the product name or\/and SKU as it appears in your integration.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Important<\/strong>:\n<ul class=\"wp-block-list\">\n<li>You can use <strong>commas<\/strong> to separate multiple integration product names and\/or SKUs if you want to map to the same accounting product.<\/li>\n\n\n\n<li>Only <strong>CSV (.csv)<\/strong> files are accepted.<\/li>\n\n\n\n<li>Ensure no special or unsupported characters are in the file.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Save the file<\/strong> in a CSV format<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Uploading Your Product Mapping File<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Navigate to <strong>Settings \u2192 Product mapping<\/strong>.<\/li>\n\n\n\n<li>Click <strong>upload a CSV file<\/strong>.<\/li>\n\n\n\n<li>Upload your completed CSV (max 10MB).<\/li>\n\n\n\n<li>Click <strong>Map products<\/strong> to start the import.<\/li>\n\n\n\n<li>You\u2019ll see a notification confirming the import has started.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What Happens Next?<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Processing time:<\/strong> Large files take longer.<\/li>\n\n\n\n<li><strong>API call limits:<\/strong> Synder fetches products from your accounting system first. Very large imports may hit API limits\u2014if you see a temporary failure, retry later.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Future syncs:<\/strong> New mappings apply to transactions synced <strong><em>after<\/em><\/strong><em> <\/em>the product mapping import.<\/li>\n\n\n\n<li><strong>Past data:<\/strong> Previously posted transactions remain unchanged. If you want the history corrected, re-sync the affected period after updating mappings (or contact support for options).<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tips &amp; Best Practices<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Overwrite behavior:<\/strong> If a mapping exists with the same <strong>accounting product name<\/strong>, your upload will overwrite it.<\/li>\n\n\n\n<li><strong>Many SKUs \u2192 one item:<\/strong> Use commas to map several integration SKUs\/names to a single accounting item.<\/li>\n\n\n\n<li><strong>Large catalogs:<\/strong> If needed, split very large catalogs into smaller files to avoid API limits.<\/li>\n\n\n\n<li><strong>Auto-match vs file:<\/strong> If your names already match, Synder auto-matches; use a file only to <strong>override<\/strong> or fix mismatches.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Troubleshooting<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u201cUnknown accounting product\u201d<\/strong> \u2192 Ensure the <strong>Accounting product name<\/strong> matches your ledger <strong>exactly <\/strong>(spelling\/case\/spacing).<\/li>\n\n\n\n<li><strong>\u201cInvalid file\/columns\u201d<\/strong> \u2192 Use the provided template and keep both required headers.<\/li>\n\n\n\n<li><strong>\u201cRate limit\/API error\u201d<\/strong> \u2192 Wait a bit and retry; large catalogs can temporarily hit your accounting platform\u2019s API limits.<\/li>\n\n\n\n<li><strong>Duplicates in CSV<\/strong> \u2192 The <strong><em>last<\/em><\/strong><em> <\/em>occurrence wins; keep one clean row per accounting product.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><em>For more information about Synder features, visit our Help Center or<\/em><a href=\"https:\/\/synder.com\/contact\/\"><em> reach out to Synder Team<\/em><\/a><strong> <\/strong><em>via online support chat or email.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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, [&hellip;]<\/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":""},"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":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Product Mapping: Import via file - Synder<\/title>\n<meta name=\"description\" content=\"Learn how to import product mapping via file in Synder. Map products from your sales platforms to QuickBooks or Xero items in bulk using a CSV upload.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/synder.com\/help\/product-mapping-import-via-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Product Mapping: Import via file - Synder\" \/>\n<meta property=\"og:description\" content=\"Learn how to import product mapping via file in Synder. Map products from your sales platforms to QuickBooks or Xero items in bulk using a CSV upload.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/synder.com\/help\/product-mapping-import-via-file\/\" \/>\n<meta property=\"og:site_name\" content=\"Synder\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-28T16:45:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-30T19:20:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXepB7aat_YoRWSx0pQtc-qWjV8RDq485YG6rdoAm1g1Htl6lzVqeF_J89jHD3KkDrT_5XQ5zlQnkhXdqp1vf54JgiZga8P22vL9X0dkUIVMb3mPWR_2ReEPiar23E20cvOYFwi5Zw?key=_vEKoi2pKrxCQnTAGTYysA\" \/>\n<meta name=\"author\" content=\"viacheslavtarabarov\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"viacheslavtarabarov\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Product Mapping: Import via file - Synder","description":"Learn how to import product mapping via file in Synder. Map products from your sales platforms to QuickBooks or Xero items in bulk using a CSV upload.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/synder.com\/help\/product-mapping-import-via-file\/","og_locale":"en_US","og_type":"article","og_title":"Product Mapping: Import via file - Synder","og_description":"Learn how to import product mapping via file in Synder. Map products from your sales platforms to QuickBooks or Xero items in bulk using a CSV upload.","og_url":"https:\/\/synder.com\/help\/product-mapping-import-via-file\/","og_site_name":"Synder","article_published_time":"2025-04-28T16:45:13+00:00","article_modified_time":"2026-03-30T19:20:26+00:00","og_image":[{"url":"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXepB7aat_YoRWSx0pQtc-qWjV8RDq485YG6rdoAm1g1Htl6lzVqeF_J89jHD3KkDrT_5XQ5zlQnkhXdqp1vf54JgiZga8P22vL9X0dkUIVMb3mPWR_2ReEPiar23E20cvOYFwi5Zw?key=_vEKoi2pKrxCQnTAGTYysA"}],"author":"viacheslavtarabarov","twitter_card":"summary_large_image","twitter_misc":{"Written by":"viacheslavtarabarov","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/synder.com\/help\/product-mapping-import-via-file\/","url":"https:\/\/synder.com\/help\/product-mapping-import-via-file\/","name":"Product Mapping: Import via file - Synder","isPartOf":{"@id":"https:\/\/synder.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/synder.com\/help\/product-mapping-import-via-file\/#primaryimage"},"image":{"@id":"https:\/\/synder.com\/help\/product-mapping-import-via-file\/#primaryimage"},"thumbnailUrl":"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXepB7aat_YoRWSx0pQtc-qWjV8RDq485YG6rdoAm1g1Htl6lzVqeF_J89jHD3KkDrT_5XQ5zlQnkhXdqp1vf54JgiZga8P22vL9X0dkUIVMb3mPWR_2ReEPiar23E20cvOYFwi5Zw?key=_vEKoi2pKrxCQnTAGTYysA","datePublished":"2025-04-28T16:45:13+00:00","dateModified":"2026-03-30T19:20:26+00:00","author":{"@id":"https:\/\/synder.com\/help\/#\/schema\/person\/4cabb5379fcb8374f44e6724b6d0bf8b"},"description":"Learn how to import product mapping via file in Synder. Map products from your sales platforms to QuickBooks or Xero items in bulk using a CSV upload.","breadcrumb":{"@id":"https:\/\/synder.com\/help\/product-mapping-import-via-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/synder.com\/help\/product-mapping-import-via-file\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/help\/product-mapping-import-via-file\/#primaryimage","url":"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXepB7aat_YoRWSx0pQtc-qWjV8RDq485YG6rdoAm1g1Htl6lzVqeF_J89jHD3KkDrT_5XQ5zlQnkhXdqp1vf54JgiZga8P22vL9X0dkUIVMb3mPWR_2ReEPiar23E20cvOYFwi5Zw?key=_vEKoi2pKrxCQnTAGTYysA","contentUrl":"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXepB7aat_YoRWSx0pQtc-qWjV8RDq485YG6rdoAm1g1Htl6lzVqeF_J89jHD3KkDrT_5XQ5zlQnkhXdqp1vf54JgiZga8P22vL9X0dkUIVMb3mPWR_2ReEPiar23E20cvOYFwi5Zw?key=_vEKoi2pKrxCQnTAGTYysA"},{"@type":"BreadcrumbList","@id":"https:\/\/synder.com\/help\/product-mapping-import-via-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/synder.com\/help\/"},{"@type":"ListItem","position":2,"name":"Product Mapping: Import via file"}]},{"@type":"WebSite","@id":"https:\/\/synder.com\/help\/#website","url":"https:\/\/synder.com\/help\/","name":"Synder","description":"Articles &amp; FAQ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/synder.com\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/synder.com\/help\/#\/schema\/person\/4cabb5379fcb8374f44e6724b6d0bf8b","name":"viacheslavtarabarov","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/help\/#\/schema\/person\/image\/b0a204657b8389bb6608e2d2cb5edfec","url":"https:\/\/secure.gravatar.com\/avatar\/01842a8f802da9e3ccebce99b82b4ed1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/01842a8f802da9e3ccebce99b82b4ed1?s=96&d=mm&r=g","caption":"viacheslavtarabarov"},"url":"https:\/\/synder.com\/help\/author\/viacheslavtarabarov\/"}]}},"author_meta":{"display_name":"viacheslavtarabarov","author_link":"https:\/\/synder.com\/help\/author\/viacheslavtarabarov\/"},"featured_img":null,"coauthors":[{"link":"https:\/\/synder.com\/help\/author\/viacheslavtarabarov\/","display_name":"viacheslavtarabarov"}],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/synder.com\/help\/category\/products-inventory-cogs\/products-inventory-cogs-per-transaction\/\" class=\"advgb-post-tax-term\">Per Transaction<\/a>","<a href=\"https:\/\/synder.com\/help\/category\/products-inventory-cogs\/\" class=\"advgb-post-tax-term\">Products, Inventory &amp; COGS<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Per Transaction<\/span>","<span class=\"advgb-post-tax-term\">Products, Inventory &amp; COGS<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 11 months ago","modified":"Updated 5 days ago"},"absolute_dates":{"created":"Posted on April 28, 2025","modified":"Updated on March 30, 2026"},"absolute_dates_time":{"created":"Posted on April 28, 2025 4:45 pm","modified":"Updated on March 30, 2026 7:20 pm"},"featured_img_caption":"","series_order":"","authors":[{"term_id":340,"user_id":2299,"is_guest":0,"slug":"viacheslavtarabarov","display_name":"viacheslavtarabarov","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/01842a8f802da9e3ccebce99b82b4ed1?s=96&d=mm&r=g","author_category":"","first_name":"","last_name":"","user_url":"","job_title":"","description":""}],"_links":{"self":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts\/24840"}],"collection":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/users\/2299"}],"replies":[{"embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/comments?post=24840"}],"version-history":[{"count":3,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts\/24840\/revisions"}],"predecessor-version":[{"id":25037,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts\/24840\/revisions\/25037"}],"wp:attachment":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/media?parent=24840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/categories?post=24840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/tags?post=24840"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/ppma_author?post=24840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}