Website Building » Shopify » How do I import a CSV file into Shopify?

How do I import a CSV file into Shopify?

Last updated on January 4, 2023 @ 10:22 am

So you’ve got a CSV file of products you want to import into Shopify. Great! Here’s how you do it.

First, find the file in your computer’s filesystem. On a Mac, this might be in the “Documents” folder.

On a Windows machine, it might be in the “C:\Users\< username >\AppData\Roaming\Shopify\Uploads” folder.

Next, open Shopify’s “Uploads” folder in your web browser.

Next, open the CSV file in a text editor. (On a Mac, this might be TextEdit.On Windows, this might be Notepad.).

Next, find the line that says “name” and replace it with “Shopify_product_name.” (For example, if the file says “name” it would be “Shopify_product_name.”)

Next, find the line that says “quantity” and replace it with “1.” (For example, if the file says “quantity” it would be “1.”)

Next, find the line that says “price” and replace it with “200.” (For example, if the file says “price” it would be “200.”)

PRO TIP: When importing a CSV file into Shopify, please be aware that any existing products with the same handle will be overwritten with the new data from the CSV file. Make sure to create a backup of your Shopify store before importing any new data.

Next, find the line that says “shipping” and replace it with “0.” (For example, if the file says “shipping” it would be “0.”)

Finally, find the line that says “save” and hit the Enter key. This will save the file and close the text editor.

Now, open Shopify’s “Uploads” folder in your web browser.

Next, click on the “Add Product” button (it might be at the top or bottom of the page).

Next, click on the “Upload a CSV” button.

Next, choose the file you just saved from your computer.

Next, fill in the details about the product. (For example, you might enter the product’s name, description, quantity, and price.)

Finally, hit the “Save” button.

Congratulations! Your product has now been imported into Shopify.

Dale Leydon

Dale Leydon

Sysadmin turned Javascript developer. Owner of 20+ apps graveyard, and a couple of successful ones.