How to Import Products to WooCommerce

[@frankpurcell2173]

Am I your 50 000th viewer? Thanks for the video! Awesome stuff, was super helpful.

[@LearnWoo]

Awesome! Thank you!

[@idyetymbuk6625]

Thank you for the video, but I am using Ubuntu. I have Libra and not Excel. Please any suggestions for me?

[@Bcbcbcbcbc61]

Hi there! First of all thx, great video. For those who has problems, try to open it with google drive , use google docs. This will fix automatically you document, it work for so far i can see at my store.

[@LearnWoo]

Hey Bilal, thanks for your feedback.

[@meethilarahman9454]

how long does it usually take to import products using the built-in feature? also does my laptop need to stay on during the whole time or will it continue to import?

[@LearnWoo]

Hi Meethila Rahman, The time taken for importing products depends on your server speed. Also, imports may fail if server speed is very slow and server time outs configured are lower end. Normally, in a decent server, importing hundered products takes a couple of mins max. You should stay on the page until imports gets completed. Using WooCommerce default import functionality, you’ll be provided with a real-time view of what is successfully imported. If you find our channel useful, please like, subscribe 🙂

[@migratingeagles]

Does these plugin support WCFM multivendor

[@LearnWoo]

You can try this add-on for WCFM - wclovers.com/product/woocommerce-frontend-manager-ultimate/

[@ελενηπαλαντζα-ι8ν]

Hey i use woocommerce in Greek, can i use your template despite being in english? I mean will it automatically import it despite being in English?

[@LearnWoo]

Hi, It should be possible using one of these plugins listed here - learnwoo.com/woocommerce-multilingual-plugins/ You may contact their support for more information. If you find our channel useful, please like, subscribe 🙂

[@JErock25]

Thank so much!!! This was exactly what I was looking for (hadn't managed to find it anywhere) and very clearly explained.

[@mohanroyal5352]

What about images? how to upload images of prodcuts?

[@stewartw.9151]

Can one use a CSV file of products, stock levels etc., which is available from a supplier online. The supplier updates the product data as required periodically and makes it available to his commercial vendors at a URL where the vendor must enter a unique code. The CSV can be manually downloaded in this way but then one still must manually upload it to the Wordpress/WooCommerce installation of the vendor. The main criteria we require to frequently update is stock levels and availability at the supplier so as to avoid disappointment to users of the store when ordering. My question is, can the data be dynamically accessed and automatically be made to carry out the updates needed, perhaps triggered using a Cron Job? I understand that the mechanism could be a SOAP or REST implementation but have no idea how that works. Any suggestions?

[@LearnWoo]

Hi @Stewart You can check the below link - learnwoo.com/refer/webtoffee-setting-up-cron-job

[@mortenbisgaard6104]

Hi, thank you for informative teachings. For CSV Import of the Product ID field, you suggest the following format: 100, SKU101 - would this format be used for every row in the CSV upload ID field?, or would the 2nd row be 100,SKU102 & 3rd row be 100, SKU103 etc? Also would this ID field format be restricted to 999 rows being only 3 characters?

[@LearnWoo]

Hi Morten, SKU is supposed to be unique for each item. Hope this article helps - learnwoo.com/importing-products-to-woocommerce-site/

[@MelissaMaiga]

Is it possible to upload variable products with the built in uploader? Also my products keep saying they are not in stock but I have the columns set up just like yours...

[@LearnWoo]

Hey Melissa, WooCommerce built-in uploader supports variable products - docs.woocommerce.com/document/product-csv-importer-exporter/

[@leanghour7394]

Hi, how to set a direct download document link the same as your 'Product CSV Template ' ? when I use google drive embed link it pops up to drive and download. I want the user to click and direct download on my website.

[@LearnWoo]

Do you want to create a direct download link with Google Drive?

[@leanghour7394]

@@LearnWoo Yes, I want users to click download link on my website directly it is not pop up to Google Drive when user click to download.

[@LearnWoo]

@@leanghour7394 Hi, we created the direct download link by compressing the download file into a zip. Then, upload the zip folder into WordPress' media library and copy its URL. This link is now a direct download link. It's not possible to create a direct download link from Google Drive.

[@leanghour7394]

@@LearnWooOh. I see. Thanks

[@ag.m.2280]

Great video thank you! on of the main issues that i have with the .csv is that there are many commas (,) and tabs in the data, and this mess up the whole process as a text like this "Good morning America, peace" would translate in 2 columns if there is the comma delimiter! How do you overcome this? Thank you !!

[@LearnWoo]

If the text is wrapped in double quotes, it would consider the comma as a delimiter ("Good morning America, peace ") - wordpress.org/support/topic/importing-a-csv-avoiding-that-commas-breaks-long-description/

[@workingtricks7583]

How to import bulk photos and products details?

[@LearnWoo]

2. This plugin helps to import product details and images in bulk - learnwoo.com/refer/webtoffee-product-import-export-woocommerce

[@TheSpynerd]

Thanks for the video. I have an existing store so I have downloaded the CSV spreadsheet directly from woocomerce. However when I make modifications and I try to save it, excel gives me the message where CSV is not compatible. Do you know why?

[@LearnWoo]

hey check the CSV guidelines docs.woocommerce.com/document/product-csv-importer-exporter/

[@TheSpynerd]

@@LearnWoo this has helped me a lot. Thank You!

[@mohanroyal5352]

What about images? how to upload images of prodcuts?

[@HeidiJansen]

Hi! how would I upload products and prices to specific user roles? One product has 4 different prices depending on who the user role is.

[@mohanroyal5352]

What about images? how to upload images of prodcuts?

[@moppyjm]

Thank you very much for this video and CVS template. I have a bookstore but I need to know how to map Author, Publisher, and Language using your template, so it can be displayed on the website. Please advise

[@LearnWoo]

Hey If you are using are using ACF for custom fields, can use this plugin for import - www.wpallimport.com/ This is a comprehensive article for reference - woocommerce.com/posts/from-day-1-to-successful-homeschool-bookstore-on-woocommerce/

[@chloeyazdani3060]

Hello! Thank you for the video and the template! Would you be able to explain the data field entries more in depth? There's some that I find confusing as someone who is creating an online store but not a web designer. Thanks

[@LearnWoo]

It depends on what tool you are using. Can check this documentation if using the default product data importer of WooCommerce - woocommerce.com/document/product-csv-importer-exporter/ For information about plugins, check this article - learnwoo.com/free-plugins-woocommerce-product-import-export/

[@matin6390]

i tried to import and stuck not yet finished and i close browser after that i can not open website , it say time out or took long response , how to solve it and does it crash my website?

[@LearnWoo]

Hey, These approaches could help with the timeout issue - www.webtoffee.com/memory-limitations-import-export-woocommerce-products/

[@mahmoudshalaby706]

Hi I have 1500 products (simple and variable) and I want to upload them to the WooCommerce store via the products upload form (CSV In Bulk) and I want to add product images in the sheet (meaning uploading products with their pictures through the product upload form) 1- I would like to know how to link product images to the sheet and how to upload all products at once? 2- What are the best free or paid plugins needed to build a large and professional store?

[@shoaiburrehman3196]

Use any online product image link builder website. Use those links to embed in your file in place of images.

[@LearnWoo]

Hey Check this pluginrepublic.com/woocommerce-composite-products/#:~:text=Conditional%20logic%20is%20an%20essential,choices%20the%20customer%20has%20made

[@FidelElvira]

My supplier offers several csv files but I'm not sure how to upload them

[@LearnWoo]

Hello Fidel, Can import CSV files to WooCommerce by following the process described in this video. For more advanced product import, can use this plugin as well. Refer to the documentation for more details - docs.woocommerce.com/document/product-csv-importer-exporter/

[@ninap.6159]

So incomplete ...What about importing gallery images and variations products and variation images

[@LearnWoo]

You can use this plugin for importing gallery images - learnwoo.com/refer/webtoffee-product-import-export-woocommerce Check this documentation for more information - www.webtoffee.com/woocommerce-import-products-with-images/ To add additional images for product variations, try this one - learnwoo.com/refer/woocommerce-additional-variation-images

[@mohanroyal5352]

What about images? how to upload images of prodcuts?

[@LearnWoo]

Hello Mohan, check this learnwoo.com/refer/webtoffee-product-import-export-woocommerce

[@steviedee1771]

How do you go about importing variable products? i have imported my variable products and they are showing as variables but the children have not been assigned to the parent. Do i need to alter the CSV file in a way to let the importer know what i want to use for variations? in this case it will be size and colour

[@LearnWoo]

Hey Stephen check the WooCommerce blog having similar issue is wordpress.org/support/topic/woocommerce-product-import-issue/

[@lorenzoo213]

doesnt work with bulk import up to 1000 products one time...

[@LearnWoo]

Hello Lawrence, Can you please tell us what you are using CSV or third party plugin? Meanwhile check this blog www.webtoffee.com/bulk-upload-products-woocommerce/

[@shoaiburrehman3196]

Can you provide any that list of products which you have?

[@rooskoedam9501]

When I export my already existing products I get a export CSV document where everything is together in one cel... how can I change that?

[@LearnWoo]

Hey Roos, Please explain in what format you want to change it.?

[@FidelElvira]

Do you offer support?

[@LearnWoo]

Yes, our team offer support. let us know in what way you need support?

[@FidelElvira]

@@LearnWoo I got cvs and text products files from my supplier but none has the order and titles as the ones you've explained and I'd like you to help me with

[@dimMx]

Hello. I read the woocommerce guidelines and saw your video here. I want to ask you : Can we use only some of the woocommerce demo csv file columns? I have only title, and barcode with numbers like: 000-123-4567 as columns. And image files saved as 000000.jpg. to match the same product title that I need to change it with someway. I don't have price, as an option, and nothing else to show and import. The only solution I am thinking to try is to export the current demo products of the template I am gonna use, so as to see it, and how it works and then adjust it with my products. What do you think is the best solution for me?

[@mohanroyal5352]

What about images? how to upload images of prodcuts?

[@2108rajkumar]

Hello, Thanks very help full, Can you help how to import products thru API

[@LearnWoo]

Hello Raj, check this stackoverflow.com/questions/42654014/how-to-import-products-via-api-to-woocommerce/48511433

[@TheSpynerd]

Can I import custom taxonomy

[@LearnWoo]

Check this link- katharinabrunner.de/2020/11/import-custom-taxonomy-to-woocommerce-by-csv-file/

[@AlAmin-lj5dp]

Hi! Thank you for making such a nice and useful video. Please make a video explaining the data validations for those fields on that .CSV document and how those work. And also show how to add variable products using that .CSV file

[@LearnWoo]

Hey Amin, Thanks for your suggestion we will pass it to our team.

[@mohanroyal5352]

What about images? how to upload images of prodcuts?

[@moniqueboshoff7684]

Hello LearnWoo, I am desperately looking for an import Woocommerce products csv file, where can I download one from? Thanks in advance!

[@LearnWoo]

Hello Monique, In the video description CSV template is given. You can check cdn.learnwoo.com/wp-content/uploads/2020/06/WooCommerce-Product-CSV-Template.zip

[@sikable801]

Thank you

[@alexanderpadalka5708]

💝