HomeЛюди и блогиRelated VideosMore From: Soflyy

WooCommerce Excel Import / Upload - Create & Import Variable Products from Excel to WooCommerce

338 ratings | 130452 views
WooCommerce Excel import tutorial - learn how to upload product data from Microsoft Excel spreadsheets to WooCommerce using WP All Import and the WooCommerce add-on. Learn more about WP All Import's WooCommerce import capabilities at http://www.wpallimport.com/woocommerce-product-import In this video, you'll specifically learn how to structure an Excel file to group product variations together into variable products and import them to WooCommerce. If you aren't importing variable products, the WooCommerce add-on can import ANY Excel file to WordPress/WooCommerce. Just watch this video to learn how to export your Excel file to a CSV. Then upload your CSV file to WP All Import and import it. You can map the columns in your Excel file to any "end point" in WordPress or WooCommerce. You don't need to use special column names. Try the free version of the WooCommerce add-on for WP All Import and see how easy it is to import Excel or CSV files to WooCommerce products: https://wordpress.org/plugins/woocommerce-xml-csv-product-import/ Download example Excel/CSV fields from our website - click Documentation, then WooCommerce, then "Example XML/CSV Files". Open the CSV files in Excel and edit them as per your needs. But why do you need to import your Excel file to WooCommerce anyway? Don't you have an inventory management system for your products that automatically exports all your stock to XML or CSV? If so, don't go through the hassle of manually creating an Excel file - just use WP All Import to import your XML or CSV file to WooCommerce directly.
Html code for embedding videos on your blog
Text Comments (44)
Meysam aliannejadi (1 month ago)
perfect!
Sam rohn (3 months ago)
check out this free alternative https://github.com/mithunmanohar/woocommerce-orders-google-sheets-integration
Super Kuat (3 months ago)
What if you have several view images for each products?
Yulia Zubova (3 months ago)
Please, how to add new variations to existing parent product? When I try to add variations new parent is created .
Ilan Salomon (3 months ago)
Hi Softlyy, Nice plugin! Can you please let me know how to create the uploadable excel file but that it will include, 2 products with different attributes, example: one product has color and the other has size, I'm a bit confused with this because you are using attributes as column heather. Please let me know as well how to structure the excel uploadable file, to include simple products as well. Thanks
mangomar.com (4 months ago)
Thanks men you are a life
Hifzur Rahman (5 months ago)
Hi! I am Bulbul Al Hasan. I am Professional Data Entry Assistant. I have many Years Experience with products Listing and Data entry in WordPress, E-commerce, Woocommerce Sites. Check it out! I will do wordpress data entry for $5 on #Fiverr https://www.fiverr.com/s2/3100bceb67
how can we eliminate the price range?
anas hidayat (8 months ago)
Saya bisa buat botnya. Autoupload product dan images langsung dari PC via chrome exttension. Hanya bisa bekerja di Windows. Cek channel saya. Gratis softwarenya.
Mark Nolan (8 months ago)
I agree with the comment below that this isn't close to a real import and that you have to do a lot of work, but I guess that is down to the fact that Wordpress wasn't designed to be an Ecommerce CMS. Personally, I wouldn't recommed using WP for an ecommerce website unless you only have a few products which do not need regular wholesale changes. The tutorial was fine though.
Jessie Rojas (8 months ago)
Do simple products need to be separated from variable products or do they share the same Csv file?
Flip Back (8 months ago)
How do you create the product Taxonomies in excel. Categories and Tags. how do you separate the categories and tags in the excel worksheet? Pipe symbol does not work for that.
Haris Aslam (10 months ago)
What is Ad-on in all-import ???? i cant import until i have this ad-on... This VDO is Only For Sale, I request everyone please try first before use this software on your site
theloveemovement (1 year ago)
Nice one mate thank you!
Kevin Morrison (1 year ago)
hi, can i use wpallimport to EXPORT a set of variable products to excel?
Ron T (1 year ago)
That's not even close to real import. you have to do a lot of work, almost everything. Unlike Shopify where you simply upload the file and that's it.
Mach (1 year ago)
GUys what i undserstand is that if you have many products in your csv you just manually upload and set up one product and it will do others automatically?? second i HOW TO IMport products from other stores to csv or xml file?? if im dropp shipper fror example. do you have some tool where i can import hundreds of products by clicking few buttons. ?? because it doesnt make sense if i first must add products nmanually to excell and then to the store. would be cool if i can import products from ebay amazon aliexpress (scraping crawling or parsing idk)
Pruthvi Raj (1 year ago)
Hi, I have over 1000 Variable products, each product is in single row and it is in "Size 38, 40, 42, 44" format how can I set up CSV file to upload and create variable products. is there any way that I can create 4 rows for each product in excel?
Serendipity (1 year ago)
Any solution to this problem?
DetRonIX (1 year ago)
I have exactly the same problem. Did you find a solution? Please let me know.
Tamara Batta (1 year ago)
Can my images be a dropbox link?
Soflyy (1 year ago)
Yes.
Ryan Shannon (1 year ago)
soflyy i have tried upload a csv with only 1 row filled in to test your product, however the woo add on is upload 83 rows which are blank rows and should only upload 1 row
Patrick Schönberger (1 year ago)
Hi, according to what has been presented I can upload one single csv file for parent and variation products? All I have to do is leave parent empty where variations have their data?
Soflyy (1 year ago)
E-mail [email protected] and we're happy to help you.
Patrick Schönberger (1 year ago)
Great, lovely solution! One more question, because I am a rookie, and I don't want to mess this up, I hope it's okay if I ask it here as this might help others as well in the future. I've lost all my products in woocommerce, my bad, should've made a back up. However, fortunately I have exported a csv not too long ago, but it has some messed up structure half being english half being my language so I will be having a hard time importing all nearly 2000 products. To make it a bit easier, I am wondering: what if I upload some products manually with all the details I will need with my imports, (backorders, stock, sale price, regular price, description, name, variatons, images etc.) then export these products. Will I get the perfectly suited template for my csv, and all I have to do is to add my data accordingly then import it all? Thank you very much for your time.
Soflyy (1 year ago)
Yep! :)
Maricor Muring (2 years ago)
when i install it on my wordpress 4.6.1, i cannot see the "All Import tab", but the plugin is activated (WP All Import - WooCommerce Add-On), please help i want to try the plugin first before purchasing it, thanks
Soflyy (1 year ago)
We're always happy to provide support to free version users, so just e-mail [email protected] and we can help you get it working.
boxer.tgfs (2 years ago)
Can we use this same method to update a description on several existing products?
Gur Telem (2 years ago)
Can I do something like this: Create an option which add a constant amount to the final price? No matter what variation? I need something which instead of choosing a price for each individual variation will increase/decrease the final price and that I wouldn't need to calculate the price manually for each variation.
abdullah aptech (2 years ago)
i like the way of your teaching thank you sir
Rasha BD (2 years ago)
wow
Shivam VLogs (3 years ago)
hi, i want to customize my theme basically i want to add 1. my wordpress theme already have registration option or sign up option. but i want those who register into my website, i want to increase my form fields name like name, DOB, location, part 2. i have some products .... and i want to list at the back of my website and only and only registered user can view those products. and i don't the cart system, i just want to simply add to cart and i will get the message that one product in added in the cart and one message goes to registered user. can i able to do in this ?
wolfenburg1 Asd (3 years ago)
Hello , I was wondering how you put certain products in specific categories ? Thanks
Geoff L (3 years ago)
You state "... images are already on the server ..."  Ah: (a) WHERE on the server?  (b) How did you upload them? (and was that one by one or all at once?) (c) What if they are NOT on the server?  How do you reference them / point to another location? (d) etc
Ruturaj Patki (2 years ago)
+Geoff L Import Images to Wordpress Media Library seems to be a Pro feature, available in only Paid version. Soflyy has already posted link to video demonstrating how to use that feature. But as I understood, it's NOT available in Free version.
Soflyy (3 years ago)
Watch this video on importing images for more info on that: https://www.youtube.com/watch?v=wAPGfWd13-w
Soflyy (3 years ago)
+HikariXRyo just add another column in Excel called "SKU" and put the SKUs in that column.
Soflyy (3 years ago)
+Shawn White At the top of the "General" tab inside the WooCommerce add-on there is a field called SKU. Simply drag & drop the field containing the SKU from your file into the box called SKU. Or e-mail [email protected] and we can help you in more detail.
Shawn White (3 years ago)
+Soflyy Do you think you could be more specific on how to add SKU's to variation sets? For example I have a shoe store that has color/size variations. Although there is a field for variable_sku on each variation set in WooCommerce I do not have the option with the Soflyy WooCommerce add-on to populate that field.
HikariXRyo (3 years ago)
How would you add SKU for each item and variable item? 
Whelplayed (6 months ago)
just add a new column called SKU and add the numbers to each one corresponding to each item
Ownage Zizou (6 months ago)
did you find out?

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.