{"id":1866,"date":"2020-11-17T12:12:05","date_gmt":"2020-11-17T12:12:05","guid":{"rendered":"https:\/\/www-staging1.names.co.uk\/support\/?post_type=ht_kb&#038;p=1866"},"modified":"2021-11-10T12:42:17","modified_gmt":"2021-11-10T12:42:17","slug":"can-i-import-my-own-customer-product-data-from-excel","status":"publish","type":"ht_kb","link":"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/","title":{"rendered":"Can I import my own customer\/product data from Excel?"},"content":{"rendered":"\n<p>Yes, although the data needs to match the structure that the store is expecting.<\/p>\n\n\n\n<p>With this in mind, the easiest way to import is to do an export first of all so that you get a spreadsheet with all of the necessary columns in the right place. You can then enter the information into this sheet and then import when you are finished.<\/p>\n\n\n\n<p>To export the product sheet, you will need to click on Products and then Import and export. Click on Export to export the product list.<\/p>\n\n\n\n<p>Should you require any further assistance regarding our Ecommerce products, please click on the Help link from within the main Ecommerce Admin Panel<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yes, although the data needs to match the structure that the store is expecting. With this in mind, the easiest way to import is to do an export first of all so that you get a spreadsheet with all of the necessary columns in the right place. You can then enter the information into this [&hellip;]<\/p>\n","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[173,114],"ht-kb-tag":[113,200],"class_list":["post-1866","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-legacy","ht_kb_category-ecommerce-legacy","ht_kb_tag-ecommerce","ht_kb_tag-legacy"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Can I import my own customer\/product data from Excel? - Support Centre - names.co.uk<\/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:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Can I import my own customer\/product data from Excel? - Support Centre - names.co.uk\" \/>\n<meta property=\"og:description\" content=\"Yes, although the data needs to match the structure that the store is expecting. With this in mind, the easiest way to import is to do an export first of all so that you get a spreadsheet with all of the necessary columns in the right place. You can then enter the information into this [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Support Centre - names.co.uk\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/namesco\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-10T12:42:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2021\/02\/og-support-centre.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@namesco\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/\",\"url\":\"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/\",\"name\":\"Can I import my own customer\/product data from Excel? - Support Centre - names.co.uk\",\"isPartOf\":{\"@id\":\"https:\/\/www.names.co.uk\/support\/#website\"},\"datePublished\":\"2020-11-17T12:12:05+00:00\",\"dateModified\":\"2021-11-10T12:42:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.names.co.uk\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Can I import my own customer\/product data from Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.names.co.uk\/support\/#website\",\"url\":\"https:\/\/www.names.co.uk\/support\/\",\"name\":\"Support Centre - names.co.uk\",\"description\":\"names.co.uk Support Centre\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.names.co.uk\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Can I import my own customer\/product data from Excel? - Support Centre - names.co.uk","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:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/","og_locale":"en_GB","og_type":"article","og_title":"Can I import my own customer\/product data from Excel? - Support Centre - names.co.uk","og_description":"Yes, although the data needs to match the structure that the store is expecting. With this in mind, the easiest way to import is to do an export first of all so that you get a spreadsheet with all of the necessary columns in the right place. You can then enter the information into this [&hellip;]","og_url":"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/","og_site_name":"Support Centre - names.co.uk","article_publisher":"https:\/\/www.facebook.com\/namesco","article_modified_time":"2021-11-10T12:42:17+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.names.co.uk\/support\/wp-content\/uploads\/2021\/02\/og-support-centre.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@namesco","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/","url":"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/","name":"Can I import my own customer\/product data from Excel? - Support Centre - names.co.uk","isPartOf":{"@id":"https:\/\/www.names.co.uk\/support\/#website"},"datePublished":"2020-11-17T12:12:05+00:00","dateModified":"2021-11-10T12:42:17+00:00","breadcrumb":{"@id":"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.names.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.names.co.uk\/support\/"},{"@type":"ListItem","position":2,"name":"Can I import my own customer\/product data from Excel?"}]},{"@type":"WebSite","@id":"https:\/\/www.names.co.uk\/support\/#website","url":"https:\/\/www.names.co.uk\/support\/","name":"Support Centre - names.co.uk","description":"names.co.uk Support Centre","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.names.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb\/1866","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/comments?post=1866"}],"version-history":[{"count":1,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb\/1866\/revisions"}],"predecessor-version":[{"id":1867,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb\/1866\/revisions\/1867"}],"wp:attachment":[{"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/media?parent=1866"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb-category?post=1866"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.names.co.uk\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=1866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}