{"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-01-29T12:58:17","modified_gmt":"2021-01-29T12:58:17","slug":"can-i-import-my-own-customer-product-data-from-excel","status":"publish","type":"ht_kb","link":"https:\/\/www.websites-madesimple.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":[72,32],"ht-kb-tag":[17],"class_list":["post-1866","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-ecommerce-legacy","ht_kb_category-legacy","ht_kb_tag-ecommerce"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Can I import my own customer\/product data from Excel? - Support Centre - Websites MadeSimple\u2122<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\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 - Websites MadeSimple\u2122\" \/>\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.websites-madesimple.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Support Centre - Websites MadeSimple\u2122\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-29T12:58:17+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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.websites-madesimple.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/\",\"url\":\"https:\/\/www.websites-madesimple.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 - Websites MadeSimple\u2122\",\"isPartOf\":{\"@id\":\"https:\/\/www.websites-madesimple.co.uk\/support\/#website\"},\"datePublished\":\"2020-11-17T12:12:05+00:00\",\"dateModified\":\"2021-01-29T12:58:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.websites-madesimple.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.websites-madesimple.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.websites-madesimple.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.websites-madesimple.co.uk\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Can I import my own customer\/product data from Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.websites-madesimple.co.uk\/support\/#website\",\"url\":\"https:\/\/www.websites-madesimple.co.uk\/support\/\",\"name\":\"Support Centre - Websites MadeSimple\u2122\",\"description\":\"Websites MadeSimple\u2122 Support Centre\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.websites-madesimple.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 - Websites MadeSimple\u2122","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_GB","og_type":"article","og_title":"Can I import my own customer\/product data from Excel? - Support Centre - Websites MadeSimple\u2122","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.websites-madesimple.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/","og_site_name":"Support Centre - Websites MadeSimple\u2122","article_modified_time":"2021-01-29T12:58:17+00:00","twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websites-madesimple.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/","url":"https:\/\/www.websites-madesimple.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 - Websites MadeSimple\u2122","isPartOf":{"@id":"https:\/\/www.websites-madesimple.co.uk\/support\/#website"},"datePublished":"2020-11-17T12:12:05+00:00","dateModified":"2021-01-29T12:58:17+00:00","breadcrumb":{"@id":"https:\/\/www.websites-madesimple.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websites-madesimple.co.uk\/support\/articles\/can-i-import-my-own-customer-product-data-from-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.websites-madesimple.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.websites-madesimple.co.uk\/support\/"},{"@type":"ListItem","position":2,"name":"Can I import my own customer\/product data from Excel?"}]},{"@type":"WebSite","@id":"https:\/\/www.websites-madesimple.co.uk\/support\/#website","url":"https:\/\/www.websites-madesimple.co.uk\/support\/","name":"Support Centre - Websites MadeSimple\u2122","description":"Websites MadeSimple\u2122 Support Centre","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websites-madesimple.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.websites-madesimple.co.uk\/support\/wp-json\/wp\/v2\/ht-kb\/1866","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websites-madesimple.co.uk\/support\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websites-madesimple.co.uk\/support\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websites-madesimple.co.uk\/support\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.websites-madesimple.co.uk\/support\/wp-json\/wp\/v2\/comments?post=1866"}],"version-history":[{"count":1,"href":"https:\/\/www.websites-madesimple.co.uk\/support\/wp-json\/wp\/v2\/ht-kb\/1866\/revisions"}],"predecessor-version":[{"id":3165,"href":"https:\/\/www.websites-madesimple.co.uk\/support\/wp-json\/wp\/v2\/ht-kb\/1866\/revisions\/3165"}],"wp:attachment":[{"href":"https:\/\/www.websites-madesimple.co.uk\/support\/wp-json\/wp\/v2\/media?parent=1866"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websites-madesimple.co.uk\/support\/wp-json\/wp\/v2\/ht-kb-category?post=1866"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websites-madesimple.co.uk\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=1866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}