{"id":7564,"date":"2021-05-26T12:28:07","date_gmt":"2021-05-26T12:28:07","guid":{"rendered":"https:\/\/zvendo.com\/blog\/?post_type=docs&#038;p=7564"},"modified":"2021-09-10T22:20:04","modified_gmt":"2021-09-10T22:20:04","slug":"how-to-export-import-bulk-sheet","status":"publish","type":"docs","link":"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/","title":{"rendered":"How to Export &#038; Import Bulk Sheet"},"content":{"rendered":"<p>If you have a relatively large quantity of products, you preferably should upload the data in a bulk sheet. Follow the below steps to know how to import and export the extended template that you should fill in.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong>Steps to Export The Extended Sheet<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<ol>\n<li>From your store dashboard, click on <strong>&#8220;Product Catalog&#8221;<\/strong><\/li>\n<li>Now, click on &#8220;<strong>Products<\/strong>&#8220;<\/li>\n<li>Then, choose &#8220;<strong>Export<\/strong>&#8220;<\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7565\" src=\"https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/export.png\" alt=\"\" width=\"1350\" height=\"319\" \/><\/p>\n<p style=\"padding-left: 40px;\">4. Choose &#8220;<strong>Current Page<\/strong>&#8220;<\/p>\n<p style=\"padding-left: 40px;\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7528\" src=\"https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/Current-Page-Pop-up-window.png\" alt=\"\" width=\"739\" height=\"367\" \/><\/p>\n<p style=\"padding-left: 40px;\">5. Scroll down and click on the &#8220;<strong>Export<\/strong>&#8221; button.<\/p>\n<p style=\"padding-left: 40px;\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7529\" src=\"https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/Exprt-button.png\" alt=\"\" width=\"741\" height=\"368\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"padding-right: 40px;\"><strong>Steps To Fill In The Bulk Upload Sheet<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<p>After downloading the template sheet, you can check the detailed steps of <a href=\"https:\/\/zvendo.com\/blog\/docs\/how-to-fill-in-the-bulk-upload-sheet-of-my-products\/\">how to fill in the bulk upload sheet of your products.\u00a0<\/a><\/p>\n<p>Please note that you should delete the beta data, then start filling in the details of your products. <a href=\"https:\/\/zvendo.com\/blog\/docs\/how-to-fill-in-the-bulk-upload-sheet-of-my-products\/\">Click here<\/a> to learn more.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong>How To Upload or Import The Completed Bulk Upload Sheet<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<p>After filling in the sheet and saving it in <strong>CSV, UTF-8<\/strong>\u00a0formatting, follow the below steps to learn how to upload it:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-6265 aligncenter\" src=\"https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/CSV-UTF-8-Excel-Bulk-Upload.png\" alt=\"\" width=\"804\" height=\"513\" srcset=\"https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/CSV-UTF-8-Excel-Bulk-Upload.png 804w, https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/CSV-UTF-8-Excel-Bulk-Upload-300x191.png 300w, https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/CSV-UTF-8-Excel-Bulk-Upload-768x490.png 768w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/p>\n<ol>\n<li>From the &#8220;<strong>Products<\/strong>&#8221; page on your dashboard, click on &#8220;<strong>Import<\/strong>&#8220;<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7566\" src=\"https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/import.png\" alt=\"\" width=\"411\" height=\"88\" \/><\/li>\n<li>Click on &#8220;<strong>Choose File<\/strong>&#8221; and start uploading your product bulk sheet.<\/li>\n<li>Then, click on &#8220;<strong>Import<\/strong>&#8220;, <em>as shown in the below picture.<\/em><\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-7567\" src=\"https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/import-choose-file.png\" alt=\"\" width=\"659\" height=\"444\" \/><\/p>\n<p style=\"padding-left: 40px;\">4. After uploading the file, a confirmation <strong>email<\/strong> will be sent to you with accepting your data <em>as shown in the below example.<\/em><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-6266 aligncenter\" src=\"https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/Confirmation-Email-Bulk-Upload.png\" alt=\"\" width=\"683\" height=\"279\" srcset=\"https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/Confirmation-Email-Bulk-Upload.png 683w, https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/Confirmation-Email-Bulk-Upload-300x123.png 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><strong>Highlighted Notes:<\/strong><\/h4>\n<p>&nbsp;<\/p>\n<ul>\n<li>In case of occurring any errors when uploading the file, the sent <strong>email<\/strong> will clarify the parts with errors for you to edit and reupload.<\/li>\n<li>The images size should not exceed<strong> 200 kb<\/strong><\/li>\n<li>If you have to reupload the file, please make sure you delete the image URLs to avoid duplication.<\/li>\n<li><span data-contrast=\"auto\">*Make sure you save the excel sheet as a\u00a0<strong>CSV, UTF-8<\/strong><\/span><\/li>\n<li><span data-contrast=\"auto\">*If you can\u2019t save\u00a0the file in\u00a0CSV, UTF-8, you can copy the data in\u00a0<strong>Google spreadsheets<\/strong>\u00a0then download it and the\u00a0Arabic\u00a0formatting will be\u00a0automatically edited to the CSV formatting.<\/span><\/li>\n<\/ul>\n<p>Now, you&#8217;re all set.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have a relatively large quantity of products, you preferably should upload the data in a bulk sheet. Follow the below steps to know how to import and export the extended template that you should fill in. &nbsp; Steps to Export The Extended Sheet &nbsp; From your store dashboard, click on &#8220;Product Catalog&#8221; Now, click on &#8220;Products&#8220; Then, choose &#8220;Export&#8220; 4. Choose &#8220;Current Page&#8220; 5. Scroll down and click on the &#8220;Export&#8221; button. &nbsp; &nbsp; Steps To Fill In The Bulk Upload Sheet &nbsp; After downloading the template sheet, you can check the detailed steps of how to fill in the bulk upload sheet of your products.\u00a0 Please note that you should delete the beta data, then start filling in the details of your products. Click here to learn more. &nbsp; How To Upload or Import The Completed Bulk Upload Sheet &nbsp; After filling in the sheet and saving it in CSV, UTF-8\u00a0formatting, follow the below steps to learn how to upload it: From the &#8220;Products&#8221; page on your dashboard, click on &#8220;Import&#8220; Click on &#8220;Choose File&#8221; and start uploading your product bulk sheet. Then, click on &#8220;Import&#8220;, as shown in the below picture. 4. After uploading the file, [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"parent":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"doc_category":[32],"doc_tag":[333],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Export &amp; Import Bulk Sheet - zVendo<\/title>\n<meta name=\"description\" content=\"Learn how to upload the data of your products in bulk sheet on your zVendo back-end store. Follow the steps of how to import and export the extended sheet.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Export &amp; Import Bulk Sheet - zVendo\" \/>\n<meta property=\"og:description\" content=\"Learn how to upload the data of your products in bulk sheet on your zVendo back-end store. Follow the steps of how to import and export the extended sheet.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"zVendo\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-10T22:20:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/export.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/\",\"url\":\"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/\",\"name\":\"How to Export & Import Bulk Sheet - zVendo\",\"isPartOf\":{\"@id\":\"https:\/\/zvendo.com\/blog\/#website\"},\"datePublished\":\"2021-05-26T12:28:07+00:00\",\"dateModified\":\"2021-09-10T22:20:04+00:00\",\"description\":\"Learn how to upload the data of your products in bulk sheet on your zVendo back-end store. Follow the steps of how to import and export the extended sheet.\",\"breadcrumb\":{\"@id\":\"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zvendo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Export &#038; Import Bulk Sheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zvendo.com\/blog\/#website\",\"url\":\"https:\/\/zvendo.com\/blog\/\",\"name\":\"zVendo\",\"description\":\"Your e-commerce fingerprint\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zvendo.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Export & Import Bulk Sheet - zVendo","description":"Learn how to upload the data of your products in bulk sheet on your zVendo back-end store. Follow the steps of how to import and export the extended sheet.","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:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/","og_locale":"en_US","og_type":"article","og_title":"How to Export & Import Bulk Sheet - zVendo","og_description":"Learn how to upload the data of your products in bulk sheet on your zVendo back-end store. Follow the steps of how to import and export the extended sheet.","og_url":"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/","og_site_name":"zVendo","article_modified_time":"2021-09-10T22:20:04+00:00","og_image":[{"url":"https:\/\/zvendo.com\/blog\/wp-content\/uploads\/2021\/05\/export.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/","url":"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/","name":"How to Export & Import Bulk Sheet - zVendo","isPartOf":{"@id":"https:\/\/zvendo.com\/blog\/#website"},"datePublished":"2021-05-26T12:28:07+00:00","dateModified":"2021-09-10T22:20:04+00:00","description":"Learn how to upload the data of your products in bulk sheet on your zVendo back-end store. Follow the steps of how to import and export the extended sheet.","breadcrumb":{"@id":"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/zvendo.com\/blog\/docs\/how-to-export-import-bulk-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zvendo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Export &#038; Import Bulk Sheet"}]},{"@type":"WebSite","@id":"https:\/\/zvendo.com\/blog\/#website","url":"https:\/\/zvendo.com\/blog\/","name":"zVendo","description":"Your e-commerce fingerprint","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zvendo.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/zvendo.com\/blog\/wp-json\/wp\/v2\/docs\/7564"}],"collection":[{"href":"https:\/\/zvendo.com\/blog\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/zvendo.com\/blog\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/zvendo.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/zvendo.com\/blog\/wp-json\/wp\/v2\/comments?post=7564"}],"version-history":[{"count":4,"href":"https:\/\/zvendo.com\/blog\/wp-json\/wp\/v2\/docs\/7564\/revisions"}],"predecessor-version":[{"id":7571,"href":"https:\/\/zvendo.com\/blog\/wp-json\/wp\/v2\/docs\/7564\/revisions\/7571"}],"wp:attachment":[{"href":"https:\/\/zvendo.com\/blog\/wp-json\/wp\/v2\/media?parent=7564"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/zvendo.com\/blog\/wp-json\/wp\/v2\/doc_category?post=7564"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/zvendo.com\/blog\/wp-json\/wp\/v2\/doc_tag?post=7564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}