Shopify IMPORT Products from CSV Spreadsheet - MOST Efficient Overview - Get UNFAIR Headstart!

Shopify IMPORT Products from CSV Spreadsheet - MOST Efficient Overview - Get UNFAIR Headstart!

Ryan @ Web Eminence

6 лет назад

81,617 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@itsnobel8867
@itsnobel8867 - 05.12.2023 17:12

How do you get those picture urls?

Ответить
@billardbenjamin6164
@billardbenjamin6164 - 12.09.2023 11:07

I absolutely hate the way shopify csv files are structured!

Ответить
@user-il9zh4oz4d
@user-il9zh4oz4d - 07.09.2023 22:15

Do I need a different SKU for each variant or can I use the same SKU?

Ответить
@ericmalmstrom4840
@ericmalmstrom4840 - 03.06.2023 01:03

Great video... Thank you!

Ответить
@siranisfashion9779
@siranisfashion9779 - 20.01.2023 07:48

I just need to add barcodes. How do I do that easily

Ответить
@nancycaralde3892
@nancycaralde3892 - 09.10.2022 15:01

i like this, very greatful content, hello ryan, very nice

Ответить
@e-scraper.com-Data-Extraction
@e-scraper.com-Data-Extraction - 05.09.2022 17:11

Nice tips & tricks with importing products to Shopify via a spreadsheet. Thank you. It is realy great way to get thousands of products in store more quicker than entering them manually. Bravo!

Ответить
@SamuelGuerrier
@SamuelGuerrier - 08.07.2022 16:47

Is this still the easiest / fastest way to upload product data?

Ответить
@z-man7883
@z-man7883 - 08.07.2022 11:25

Great video. I tried formatting my data in a SQL server database to export into Shopify’s format as a CSV however the programming is difficult when many variants and images are involved. Would you know of a better tool that’s better suited for the kind of programming needed here? Thanks.

Ответить
@aswdwad
@aswdwad - 01.06.2022 22:00

how to export shipping zones from Shopify to woocommerce please give me a name or link how can do date

Ответить
@Nemises318
@Nemises318 - 20.05.2022 16:21

Not very user friendly is it...

Ответить
@sales1607
@sales1607 - 09.05.2022 12:45

Hi, I tried to change some inventory values in csv and import it back but why the values not change at all. How to solve it?

Ответить
@henniebotha
@henniebotha - 04.02.2022 23:05

I was hoping that you would say something about images. I have no issues uploading products but the images are getting me down. I upload the images separately in Settings > Files, then copy the path to my CSV. I then upload the CSV and the products are created with images - happy days. The next day I first export the product CSV from the store so it includes the handles that were generated in the first column. I then add more products to the CSV, add the image paths and upload. Then it fails, saying that the paths of the images that I uploaded yesterday are invalid. When I look in the path I can see that e.g. "file/" would be replaced by "product/" and so on. This makes no sense to me. I tried placing the images in a folder on an external site, but although the image does exist if I paste the URL into my browser, Shopify says it doesn't when I import. Any thoughts?

Ответить
@classyliving3548
@classyliving3548 - 29.01.2022 21:09

Hi Ryan, excellent video! Just one question - do you know how to fix the "Body (html)" column for it to keep it's format? After importing csv all my break lines disappeared and test shows as one continuous line. I tried to use "SEO description" column instead for items description as shown in the sample file, but after uploading the description is blank. I'd be really grateful for any tips. Thanks!

Ответить
@johnmendez3771
@johnmendez3771 - 08.12.2021 00:02

Super helpful! Thanks!

Ответить
@dirtyali69
@dirtyali69 - 06.11.2021 20:22

Thanks!

Ответить
@aquanaturetools2125
@aquanaturetools2125 - 24.09.2021 16:20

Hi, I have a list of products with me, tried multiple times to create the CSV file but not happening and getting error, is it possible for you to help me out ?

Ответить
@gsg3912
@gsg3912 - 22.09.2021 01:49

Great value! Thanks Ryan - for this video! Although it's from 2017, it indeed provided me some very helpful information and cleared my doubts. Great job, keep it up! Thanks again! 😊

Ответить
@erinjohnson3239
@erinjohnson3239 - 01.09.2021 08:53

Are you able to add new variants on the spreadsheet, and what if you reach the limit... will you get an error? Also, if you are adding designs to say apparel... do you have to do this first for each product, or after the fact? Is this meant to go directly into Shopify or other apps like Printful?

Ответить
@avilang1952
@avilang1952 - 04.08.2021 20:24

Hi question i see you put handle more then once down below but not title or handle but i see with color you did why? when do i copy and paise in more then one cell and when do i dont?

Ответить
@m.saadiqbal7671
@m.saadiqbal7671 - 13.07.2021 13:18

Whenever i import products on shopify few products automatically drop like if i upload a csv of 80 products its upload 74 or 76 its dropped 4 to 6 products so please can you tell me which column is important to upload all products as a bulk without dropping any product
Regards

Ответить
@ramdasambala5702
@ramdasambala5702 - 18.06.2021 19:33

Thank you for this detailed video. Can you explain where to add product descriptions & details. I have 6 to 10 points on each item under detailed description & similar number of bullets for details, such as measurements, leather type, colour, lining, packaging, etc.

Ответить
@jackbird5839
@jackbird5839 - 26.05.2021 15:11

great solution and tips bro!! thank you for your video.
I have created my Shopify e-store!!!)) but also from time to time, a had some trouble with product photos from my supplier. Or they were too small or had only one product photo which is too bad for my conversions.
I have found way to scrap and extract all data i need to my Shopify via "ESCRAPER"
maybe it helps somebody too.

Ответить
@asadullahbaig5698
@asadullahbaig5698 - 22.05.2021 03:07

Inventory management is False, so fulfillment service must also be False
I am facing this issue how can i resolve it?
my csv file doesn't contain any fulfillment column

Ответить
@MassiveSwordAndCards
@MassiveSwordAndCards - 19.05.2021 01:48

As of today, there is no longer a sample file on shopify.

Ответить
@maxitv8242
@maxitv8242 - 08.03.2021 10:08

Hi mate. Thanks for your video. I have 2 questions. I am getting ready to launch my site. I will be using CSVs from a few suppliers. They send a new, full csv every day which I’m supposed to use to update inventory levels. However, they all provide “generic” csv files, in order to suit various platforms, including Shopify. So the layout is not exactly as Shopify wants it. So even if I adjust the initial csv to suit Shopify so I can do the initial import of the products, does this mean I will need to change the layout of each supplier’s csv all over again, every single day in order to update stock levels? And secondly, how do I prevent products that I don’t want from being imported all over again? (that is, if a supplier has 2000 products but I only want to sell 200 of them, how do I only import the ones I want, without having to spend hours every day deleting the other 1800 products?) Cheers Ryan. Best regards Steve

Ответить
@drainpr3172
@drainpr3172 - 10.02.2021 01:19

So what are the main points you need in your CSV file and then for the others you can do manually on your website?

Ответить
@blessangel8656
@blessangel8656 - 07.02.2021 18:33

Is the CSV file provided by the client?

Ответить
@CustomGardenSolutions
@CustomGardenSolutions - 13.12.2020 01:52

great job on this video. Thanks

Ответить
@grahamwalters7919
@grahamwalters7919 - 23.11.2020 11:12

The biggest issue with downloading the Shopify sample file is that it does include the "Collections" column, you have to add it manually in order to assign your products to collections

Ответить
@ozi14531
@ozi14531 - 17.10.2020 11:02

How to import product from shopfiy to amazon and magento . Best way solution

Ответить
@protagonist_UK
@protagonist_UK - 12.10.2020 14:37

A great video & instructions, many thanks Ryan.

Ответить
@internetking331
@internetking331 - 25.09.2020 21:36

Amazing info thanks a lot

Ответить
@duckyoupeople9365
@duckyoupeople9365 - 28.07.2020 11:50

HI! Thanks for the video, such a valuable input. I tried to import from CSV file but it said IMAGE SRC cant be blank

Ответить
@TheJc71693
@TheJc71693 - 11.06.2020 02:33

I have a print on demand website with SPOD, if I export the CSV to bulk change description of the products and then reimport, will it still connect with the SPOD app in which I created the products?

Ответить
@GDaShef
@GDaShef - 27.05.2020 22:17

Although this is great information, it does not seem like s short cut at all if your adding more than 20 products but ill give it a shot.

Ответить
@trendytree
@trendytree - 10.05.2020 16:25

But what about quantity of product? Doesn't that have to be uploaded separately, and how?

Ответить
@matthewisele9137
@matthewisele9137 - 18.04.2020 10:58

Thanks alot.....really helpful video

Ответить
@robertheritage3226
@robertheritage3226 - 19.02.2020 03:32

When you import the file can you choose what data is changed/uploaded? Basically the only data I what to change is the price.

Ответить
@vgrant7156
@vgrant7156 - 14.02.2020 22:26

Just gone through this vid, you are great! Brilliant pace and great demonstrations....Thank you .

Ответить
@lisamcintyre3354
@lisamcintyre3354 - 07.02.2020 19:09

I have a feed that the manufacturer will fulfill. Can I do this in Shopify

Ответить
@dwaynedibbley6124
@dwaynedibbley6124 - 07.02.2020 15:00

you've hurt my head

Ответить
@MMTaylor57
@MMTaylor57 - 13.01.2020 21:22

This is SO helpful! My hangup is that my Image links are all linked to Dropbox. I have thousands of images and have used Dropbox successfully with other sites but Shopify is not accepting them. Any suggestions?

Ответить
@tylinlilly3344
@tylinlilly3344 - 01.12.2019 18:02

Awesomenesss!!!!!!!!!!!!

Ответить
@Iyochan67
@Iyochan67 - 11.11.2019 02:23

Thank you very much. It was really helpful !

Ответить
@vissevolker955
@vissevolker955 - 08.11.2019 01:52

My products will not have a URL, they are old picture copies residing in my computer, scanned from originals. Is shopify the way to proceed? My database is Access...

Ответить
@mamasann7636
@mamasann7636 - 26.09.2019 05:21

Thank you! I didn't know about the export to get the format. Saved me a lot of time.

Ответить
@peace2560
@peace2560 - 04.09.2019 12:58

I thought if we import aliexpress/ebay products on shopfy will be added to our shopify store. I was wrong😱

Ответить
@Unicorndogs
@Unicorndogs - 07.08.2019 01:53

Thank you so so much! The most helpful video! I really appreciate you sharing your knowledge!!!

Ответить