{"id":4789,"date":"2018-07-25T11:23:01","date_gmt":"2018-07-25T05:53:01","guid":{"rendered":"https:\/\/www.hiddentechies.com\/blog\/?p=4789"},"modified":"2020-03-13T16:00:20","modified_gmt":"2020-03-13T10:30:20","slug":"add-multiple-product-using-csv-file-shopify","status":"publish","type":"post","link":"https:\/\/www.hiddentechies.com\/blog\/shopify\/add-multiple-product-using-csv-file-shopify\/","title":{"rendered":"Add Multiple Product Using CSV File in Shopify"},"content":{"rendered":"<p>Shopify is one of the most powerful e-commerce platform for all business Scale. <a href=\"https:\/\/www.shopify.com\/?ref=hiddentechies\" target=\"_blank\" rel=\"noopener noreferrer\">Shopify<\/a> has amazing feature to import multiple product to store. There are two ways to add product to the store.<\/p>\n<ol>\n<li>Manually.<\/li>\n<li>Import Product.<\/li>\n<\/ol>\n<p>We already learn about how to add product manually. Now we learn how product import by CSV file.<\/p>\n<p>So here we learn<\/p>\n<ul>\n<li>What is CSV file?<\/li>\n<li>How to made CSV File?<\/li>\n<li>How product import by CSV file?<\/li>\n<li>How it is Useful?<\/li>\n<\/ul>\n<p class=\"ht-sub-heading\">What is CSV File?<\/p>\n<p>The <strong>CSV<\/strong> file stands for <strong>Comma Separated Values<\/strong>, and the file format is (.CSV) for spreadsheets.<\/p>\n<p>Shopify allowed to import and export of CSV file for the Product, Customers, Orders (export only), and Discounts (export only) of your store.<\/p>\n<p>CSV file useful for adding multiple product at a time to Shopify store.<\/p>\n<p>CSV files with UTF-8 encoding are the only file format that can be used to import to or export from Shopify.<\/p>\n<p>CSVs are useful for Shopify stores that:<\/p>\n<ul>\n<li>Bulk import product to the Shopify store.<\/li>\n<li>Switching to Shopify from another ecommerce platform.<\/li>\n<li>Have a list of Customer Accounts.<\/li>\n<li>Prefer to upload Products using a spreadsheet.<\/li>\n<li>Temporarily have limited internet connectivity.<\/li>\n<\/ul>\n<hr \/>\n<p class=\"ht-sub-heading\">How to made CSV File?<\/p>\n<p>Here we learn how to made CSV file for product import. Follow the step by step procedure to made CSV file.<\/p>\n<p class=\"ht-small-heading\">1. Go to Shopify Dashboard:<\/p>\n<p>The first step is go to Shopify Dashboard and then click on PRODUCT button. The below screen will be appeared.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4790\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product.png\" alt=\"Shopify banner\" width=\"1342\" height=\"565\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product.png 1342w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-300x126.png 300w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-768x323.png 768w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-1024x431.png 1024w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-800x337.png 800w\" sizes=\"(max-width: 1342px) 100vw, 1342px\" \/><\/p>\n<p>Just click on <strong>IMPORT<\/strong> button. The below screen will be appeared.<\/p>\n<div style=\"display: block; float: left; width: 100%; padding: 30px 0; background: #222c35; border-radius: 5px; margin: 0 0 25px 0;\">\n<p style=\"text-align: center;\"><a style=\"color: #fff; font-size: 28px; font-weight: 600;\" href=\"https:\/\/www.hiddentechies.com\/blog\/shopify\/shopify-keyboard-shortcuts-accelerate-productivity\/\" target=\"_blank\" rel=\"noopener noreferrer\"> Shopify Keyboard Shortcuts: Accelerate Productivity <\/a><\/p>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4792\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-import.png\" alt=\"Shopify product import\" width=\"632\" height=\"229\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-import.png 632w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-import-300x109.png 300w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/p>\n<p>Now click on <strong> sample CSV template <\/strong> button and download CSV file format.When the template is download open it.<\/p>\n<p>You will see the one <strong> Excel Sheet <\/strong> open. Below screen will be appeared.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4795\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-title.png\" alt=\"shopify csv\" width=\"759\" height=\"657\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-title.png 759w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-title-300x260.png 300w\" sizes=\"(max-width: 759px) 100vw, 759px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4796\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-variant.png\" alt=\"shopify csv\" width=\"961\" height=\"585\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-variant.png 961w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-variant-300x183.png 300w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-variant-768x468.png 768w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-variant-800x487.png 800w\" sizes=\"(max-width: 961px) 100vw, 961px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4797\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-shipping.png\" alt=\"shopify csv\" width=\"967\" height=\"557\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-shipping.png 967w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-shipping-300x173.png 300w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-shipping-768x442.png 768w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-shipping-800x461.png 800w\" sizes=\"(max-width: 967px) 100vw, 967px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4798\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-google.png\" alt=\"shopify csv\" width=\"985\" height=\"591\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-google.png 985w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-google-300x180.png 300w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-google-768x461.png 768w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-google-800x480.png 800w\" sizes=\"(max-width: 985px) 100vw, 985px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4799\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-weight.png\" alt=\"shopify csv\" width=\"977\" height=\"599\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-weight.png 977w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-weight-300x184.png 300w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-weight-768x471.png 768w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-weight-800x490.png 800w\" sizes=\"(max-width: 977px) 100vw, 977px\" \/><\/p>\n<p>This is the process of adding data to CSV file. You will add more product to your Shopify store like this. After adding all necessary data <strong> save file in .CSV format.<\/strong> The below screen will appeared.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4801\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-CSV-save.png\" alt=\"Shopify CSV save\" width=\"658\" height=\"137\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-CSV-save.png 658w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-CSV-save-300x62.png 300w\" sizes=\"(max-width: 658px) 100vw, 658px\" \/><\/p>\n<p>The product CSV file is ready to import at your Shopify store.<\/p>\n<hr \/>\n<p class=\"ht-sub-heading\">How product import by CSV file?<\/p>\n<p>Now you go to Shopify dashboard and click on Product button at left side navigation menu. Below screen will be appeared.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4802\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-1.png\" alt=\"Shopify dashboard\" width=\"1342\" height=\"565\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-1.png 1342w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-1-300x126.png 300w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-1-768x323.png 768w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-1-1024x431.png 1024w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-1-800x337.png 800w\" sizes=\"(max-width: 1342px) 100vw, 1342px\" \/><\/p>\n<p>Then click on <strong> IMPORT <\/strong>Button. Below screen will be appeared.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4803\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-import-1.png\" alt=\"Shopify product import\" width=\"632\" height=\"229\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-import-1.png 632w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-product-import-1-300x109.png 300w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/p>\n<p>Then click on <strong> Choose File <\/strong> button and choose the directory of CSV file that you saved recently. Then click on <strong> UPLOAD FILE <\/strong> button. Below screen will be appeared.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4804\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-upload.png\" alt=\"csv upload\" width=\"504\" height=\"547\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-upload.png 504w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/csv-upload-276x300.png 276w\" sizes=\"(max-width: 504px) 100vw, 504px\" \/><\/p>\n<p>Here you will see the details that you write in CSV file. Then click on <strong> Start Import <\/strong> button. Just Wait your file will imported to Shopify Store.<\/p>\n<p>Then you will see below screen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4806\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-add-product.png\" alt=\"Shopify csv\" width=\"1085\" height=\"391\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-add-product.png 1085w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-add-product-300x108.png 300w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-add-product-768x277.png 768w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-add-product-1024x369.png 1024w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2018\/07\/Shopify-add-product-800x288.png 800w\" sizes=\"(max-width: 1085px) 100vw, 1085px\" \/><\/p>\n<p>Here you will show your product is imported to shoplift store. You can add more product at a time to Shopify store.<\/p>\n<div style=\"display: block; float: left; width: 100%; padding: 30px 0; background: #222c35; border-radius: 5px; margin: 0 0 25px 0;\">\n<p style=\"text-align: center;\"><a style=\"color: #fff; font-size: 24px; font-weight: 600;\" href=\"https:\/\/www.hiddentechies.com\/blog\/shopify\/find-the-total-number-products-shopify-store\/\" target=\"_blank\" rel=\"noopener noreferrer\"> How to Find The Total Number of Products in a Shopify Store <\/a><\/p>\n<\/div>\n<hr \/>\n<p class=\"ht-sub-heading\">How it is Useful?<\/p>\n<p>CSV file is useful in following ways.<\/p>\n<ul>\n<li>Add multiple product at a time.<\/li>\n<li>CSV file can be edit easily by text-editors.<\/li>\n<li>CSV is safe and can clearly differentiate between the numeric values and text.<\/li>\n<li>Importing CSV files can be much faster, and it also consumes less memory.<\/li>\n<\/ul>\n<hr \/>\n<p class=\"ht-sub-heading\">Summary:<\/p>\n<p>That\u2019s all we hope this article helped you to make your .CSV Product file for <a href=\"https:\/\/www.shopify.com\/?ref=hiddentechies\" target=\"_blank\" rel=\"noopener noreferrer\">Shopify<\/a> Store. If you still have any doubts, feel free to ask in comments and we\u2019ll reply as soon as possible. \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Shopify is one of the most powerful e-commerce platform for all business Scale. Shopify has amazing feature to import multiple product to store. There are two ways to add product to the store. Manually. Import Product. We already learn about how to add product manually. Now we learn how product import by CSV file. So&#8230; <\/p>\n<div class=\"actions\"><a href=\"https:\/\/www.hiddentechies.com\/blog\/shopify\/add-multiple-product-using-csv-file-shopify\/\">Continue Reading<\/a><\/div>\n","protected":false},"author":1,"featured_media":4831,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,301,303,304,302,2],"tags":[352,438,441,442,439,353,354,351,307,308,311,310,309,440],"_links":{"self":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/4789"}],"collection":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/comments?post=4789"}],"version-history":[{"count":14,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/4789\/revisions"}],"predecessor-version":[{"id":10567,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/4789\/revisions\/10567"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/media\/4831"}],"wp:attachment":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/media?parent=4789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/categories?post=4789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/tags?post=4789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}