{"id":1546,"date":"2015-01-06T19:12:41","date_gmt":"2015-01-06T19:12:41","guid":{"rendered":"http:\/\/documentation.common-services.com\/amazon\/?p=1546"},"modified":"2015-01-06T19:12:41","modified_gmt":"2015-01-06T19:12:41","slug":"references-and-products-codes-importexport-tool","status":"publish","type":"post","link":"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en","title":{"rendered":"References and products codes import\/export tool"},"content":{"rendered":"<p>Please go to <em>Modules &gt; Amazon &gt; Tools<\/em><\/p>\n<p>You have references or EAN\/UPC codes missing, this tool will allow you to update your products sheets in three steps:<\/p>\n<ul>\n<li>Export to a CSV file (Text format\/Excel)<\/li>\n<li>File edition, through Excel or OpenOffice<\/li>\n<li>Import from the file to the module<\/li>\n<\/ul>\n<p><span style=\"color: #ff0000;\">Notes:<\/span><\/p>\n<p><span style=\"color: #ff0000;\">You are responsible for your data. Please make a backup of your database before any file import.<\/span><\/p>\n<p><span style=\"color: #ff0000;\">This file cannot be used to send data to Amazon, this is an internal file.<\/span><\/p>\n<p><span style=\"color: #ff9900;\">This tool should be used before putting online the products on Amazon. If you use it after, it may create duplicates (SKU). It should be used by advanced users.<\/span><\/p>\n<h3>File export<\/h3>\n<p style=\"padding-left: 30px;\"><a href=\"http:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-55-12.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1511\" src=\"http:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-55-12.png\" alt=\"2014-12-04_20-55-12\" width=\"1151\" height=\"435\" srcset=\"https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-55-12.png 1151w, https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-55-12-300x113.png 300w, https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-55-12-1024x387.png 1024w, https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-55-12-624x235.png 624w\" sizes=\"auto, (max-width: 1151px) 100vw, 1151px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You will download the file to your desktop, and you will then open it with OpenOffice.<\/p>\n<h3>File Edition<\/h3>\n<p>When importing, you will choose UTF-8 and &#8220;;&#8221; as separator as below:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"http:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-59-33.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1512\" src=\"http:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-59-33.png\" alt=\"2014-12-04_20-59-33\" width=\"592\" height=\"498\" srcset=\"https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-59-33.png 592w, https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-59-33-300x252.png 300w\" sizes=\"auto, (max-width: 592px) 100vw, 592px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #008000;\">Once the file opened, you can edit the columns<\/span>:<\/p>\n<ul>\n<li>Reference (SKU)<\/li>\n<li>UPC<\/li>\n<li>EAN<\/li>\n<\/ul>\n<p><span style=\"color: #ff0000;\">You will not be able to edit the columns<\/span>:<\/p>\n<ul>\n<li>Product Id<\/li>\n<li>Product Name<\/li>\n<\/ul>\n<p>The product name column is here just for information to let you know which product you are editing.<\/p>\n<p>The Product ID is displayed as an identifier and combination number if you do not have combinations, it will be indicated 123_0 for example, if it is a combination for example 123_678.<\/p>\n<p>To prevent the display in scientific notation in your editor, UPC and EAN codes will be prefixed by a symbol &#8216; which will be deleted automatically by the module during the export.<\/p>\n<p>When finished editing, save the file without changing the format. Do not change the file format, do not alter the file.<\/p>\n<h3>File Import<\/h3>\n<p>You will send the file:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"http:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_21-10-38.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1513\" src=\"http:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_21-10-38.png\" alt=\"2014-12-04_21-10-38\" width=\"1042\" height=\"432\" srcset=\"https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_21-10-38.png 1042w, https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_21-10-38-300x124.png 300w, https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_21-10-38-1024x424.png 1024w, https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_21-10-38-624x258.png 624w\" sizes=\"auto, (max-width: 1042px) 100vw, 1042px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>The module will let you know the number of items updated:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"http:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_21-13-20.png\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1514\" src=\"http:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_21-13-20.png\" alt=\"2014-12-04_21-13-20\" width=\"736\" height=\"60\" srcset=\"https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_21-13-20.png 736w, https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_21-13-20-300x24.png 300w, https:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_21-13-20-624x50.png 624w\" sizes=\"auto, (max-width: 736px) 100vw, 736px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Please go to Modules &gt; Amazon &gt; Tools You have references or EAN\/UPC codes missing, this tool will allow you to update your products sheets in three steps: Export to a CSV file (Text format\/Excel) File edition, through Excel or OpenOffice Import from the file to the module Notes: You are responsible for your data. [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[93],"tags":[760],"class_list":["post-1546","post","type-post","status-publish","format-standard","hentry","category-documentation-en","tag-tool"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.11 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>References and products codes import\/export tool - Module Amazon Marketplace<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"References and products codes import\/export tool - Module Amazon Marketplace\" \/>\n<meta property=\"og:description\" content=\"Please go to Modules &gt; Amazon &gt; Tools You have references or EAN\/UPC codes missing, this tool will allow you to update your products sheets in three steps: Export to a CSV file (Text format\/Excel) File edition, through Excel or OpenOffice Import from the file to the module Notes: You are responsible for your data. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en\" \/>\n<meta property=\"og:site_name\" content=\"Module Amazon Marketplace\" \/>\n<meta property=\"article:published_time\" content=\"2015-01-06T19:12:41+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-55-12.png\" \/>\n<meta name=\"author\" content=\"Imen Rahal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Imen Rahal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en\",\"url\":\"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en\",\"name\":\"References and products codes import\/export tool - Module Amazon Marketplace\",\"isPartOf\":{\"@id\":\"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/#website\"},\"datePublished\":\"2015-01-06T19:12:41+00:00\",\"dateModified\":\"2015-01-06T19:12:41+00:00\",\"author\":{\"@id\":\"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/#\/schema\/person\/8f8bf9628260b9ca476655ec0c384c5f\"},\"breadcrumb\":{\"@id\":\"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/documentation.common-services.com\/amazon\/?lang=en\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"References and products codes import\/export tool\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/#website\",\"url\":\"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/\",\"name\":\"Module Amazon Marketplace\",\"description\":\"Amazon Marketplace pour Prestashop version 3.9\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/#\/schema\/person\/8f8bf9628260b9ca476655ec0c384c5f\",\"name\":\"Imen Rahal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/28e663cea1c982c804a994017bea4d57626f9093a3beb034ecf4a10de40ad937?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/28e663cea1c982c804a994017bea4d57626f9093a3beb034ecf4a10de40ad937?s=96&d=mm&r=g\",\"caption\":\"Imen Rahal\"},\"url\":\"https:\/\/documentation.common-services.com\/amazon\/author\/imen\/?lang=en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"References and products codes import\/export tool - Module Amazon Marketplace","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:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en","og_locale":"en_US","og_type":"article","og_title":"References and products codes import\/export tool - Module Amazon Marketplace","og_description":"Please go to Modules &gt; Amazon &gt; Tools You have references or EAN\/UPC codes missing, this tool will allow you to update your products sheets in three steps: Export to a CSV file (Text format\/Excel) File edition, through Excel or OpenOffice Import from the file to the module Notes: You are responsible for your data. [&hellip;]","og_url":"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en","og_site_name":"Module Amazon Marketplace","article_published_time":"2015-01-06T19:12:41+00:00","og_image":[{"url":"http:\/\/documentation.common-services.com\/amazon\/wp-content\/uploads\/2014\/12\/2014-12-04_20-55-12.png"}],"author":"Imen Rahal","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Imen Rahal","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en","url":"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en","name":"References and products codes import\/export tool - Module Amazon Marketplace","isPartOf":{"@id":"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/#website"},"datePublished":"2015-01-06T19:12:41+00:00","dateModified":"2015-01-06T19:12:41+00:00","author":{"@id":"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/#\/schema\/person\/8f8bf9628260b9ca476655ec0c384c5f"},"breadcrumb":{"@id":"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/documentation.common-services.com\/amazon\/references-and-products-codes-importexport-tool\/?lang=en#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/documentation.common-services.com\/amazon\/?lang=en"},{"@type":"ListItem","position":2,"name":"References and products codes import\/export tool"}]},{"@type":"WebSite","@id":"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/#website","url":"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/","name":"Module Amazon Marketplace","description":"Amazon Marketplace pour Prestashop version 3.9","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/#\/schema\/person\/8f8bf9628260b9ca476655ec0c384c5f","name":"Imen Rahal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/documentation.common-services.com\/amazon\/?lang=en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/28e663cea1c982c804a994017bea4d57626f9093a3beb034ecf4a10de40ad937?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/28e663cea1c982c804a994017bea4d57626f9093a3beb034ecf4a10de40ad937?s=96&d=mm&r=g","caption":"Imen Rahal"},"url":"https:\/\/documentation.common-services.com\/amazon\/author\/imen\/?lang=en"}]}},"_links":{"self":[{"href":"https:\/\/documentation.common-services.com\/amazon\/wp-json\/wp\/v2\/posts\/1546\/?lang=en"}],"collection":[{"href":"https:\/\/documentation.common-services.com\/amazon\/wp-json\/wp\/v2\/posts\/?lang=en"}],"about":[{"href":"https:\/\/documentation.common-services.com\/amazon\/wp-json\/wp\/v2\/types\/post\/?lang=en"}],"author":[{"embeddable":true,"href":"https:\/\/documentation.common-services.com\/amazon\/wp-json\/wp\/v2\/users\/3\/?lang=en"}],"replies":[{"embeddable":true,"href":"https:\/\/documentation.common-services.com\/amazon\/wp-json\/wp\/v2\/comments\/?lang=en&post=1546"}],"version-history":[{"count":1,"href":"https:\/\/documentation.common-services.com\/amazon\/wp-json\/wp\/v2\/posts\/1546\/revisions\/?lang=en"}],"predecessor-version":[{"id":1547,"href":"https:\/\/documentation.common-services.com\/amazon\/wp-json\/wp\/v2\/posts\/1546\/revisions\/1547\/?lang=en"}],"wp:attachment":[{"href":"https:\/\/documentation.common-services.com\/amazon\/wp-json\/wp\/v2\/media\/?lang=en&parent=1546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/documentation.common-services.com\/amazon\/wp-json\/wp\/v2\/categories\/?lang=en&post=1546"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/documentation.common-services.com\/amazon\/wp-json\/wp\/v2\/tags\/?lang=en&post=1546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}