Importing Shopify Products with Spreadsheet (CSV)

Video walks you through the method of exporting your catalog and importing new and existing edits to products via Excel Spreadsheet or Google Drive Sheets CSV.

Note that inventory updates are using a different spreadsheet which we will link to once video is created.

#shopify #tutorials #products #ecommerce #import #csv

[BlackPlusRich]

Excellent video!!!! For years, I have been trying to figure this out.

[elegantkulsum]

you are so good. you explain briefly. thank you so much

[alejandrohernandez-contrer]

Gosh i loved this video - you demystified so much -- you are amazing and thanks a bunch.

[deemm]

You are amazing you know how to explain for beginners the best vedio i have seen thank you so much
Please keep going 👍🏻

[ciddrummond]

thank you very much. Does the image link you upload from your website url will turn an shopify cdn link after been uploaded or will continue as an external link?

[dawnstansfield]

Hi there, oh my word where has this info been for the last 3 years! Thank you so much for your video. Just one question, I uploaded my file to Shopify and the products are only showing in my inventory and not in products. Can you tell me what I need to do to be able to see them in my shop?

[MedoHamdani]

Do you have any tool to scrape data from Supplier website?

[elainefarris]

Thank you for this video. I am switching from Woocommerce to Shopify and I can't wait to start. Therefor, I stumbled upon your video. I do have a question though, in regular cart software we usually have SKU number column but I couldn't find it on the Shopify product template, except for the "variant sku". Do you know where is the regular SKU column on the spreadsheet? I can't seem to find in on google search. Thank you in advance!

[David-puvs]

Do you by any chance how to upload multiple images per variant or product? I am trying since 2 days now and do not manage it e.g. having variant color:red and then having 5 images of the red variant.
OR having 5 Generel pictures of the product that are always there, and only change the main one as variant.

[ANAS]

Thanks for the video, So you would recommend to download the template from Shopify and then edit it?

[craigrosa]

I appreciate your explanation but this doesn't make it any easier if you have thousands of products!Is there no file converter that can automatically convert a CSV product catalogue into the Shopify template???

[Nickfdz]

why does <p> appear? everytime i download the file it appears in my description of the product. I don't want it to appear when the customer is seeing the product.

[tammyphelan]

Thank you so much! Exactly what I needed! One question... on the screen that shows the list price what exactly would I use the compare price for (the box right next to list price)? Is that for similar products you've found and the price that the seller has listed? Or is it for list price (what I'm charging) and compare price (what I paid for the product)?

[bambi]

quick question- in the Published column can I mark "FALSE" and have these new products land as a draft instead of available on the store?

[ANAS]

Can i know the difference between the normal import and matrixify ?

[spunkybear]

Hi! I am in desperate need of help with an existing spreadsheet to I can upload. I don't know if debugging is correct term or not. How can I contact you? Thanks!

[malith]

I have csv file it not like tabs, they are separated from comas like plane text. How can I separate them into tags easily ?

[adomolis]

Hi. Great video., thanks. One question. How does one actually add different color as a second option? Let's say, you have Adidas shoes there with sizes 5, 6, 7 etc. and they are all white. Now if I add BLACK option, do I have to write Black for every single available size as well, so like, you have 7 rows with sizes that are all WHITE. I will add another 7 rows with BLACK all listed with same sizes?

[Nehayadav-nhzy]

How we can apply discounts to the products? Suppose we want 25% off on the MRP so that we can get 25% off and it should reflect on the front end page also ?

[hasnainhayat]

where should i send you csv file so you can debug and check it for me, will be thankful