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

[@MichaelShatravka]

Still works in 2022!!! worthy every penny ULTRA time saver! Incredible plugin thank you!!!

[@soflyyplugins]

Thank you!

[@Sergio-gr6ro]

OMG, finally I found exactly what I want among the useless tons of tutorials. "How to import CSV / WP All Import" - it turned out to be a challenge.

[@soflyyplugins]

Sorry about that!

[@yosifduce404]

Very Much Appreciated!! Worked thoroughly.

[@soflyyplugins]

We're glad to know it worked!

[@greenvalleyschoolkenjal.4423]

amazing technique! is there any way we set all atributes and create few variations, prices to create a template then download it in excel format and add more variations and their prices manually and then import that excel sheet right back?! Im asking because I already have everything set in excel file offline but its not in the proper format as a template and the variations are in few hundreds. thanks for reply.

[@soflyyplugins]

Sure, reach out to our support and we can advise on how to do this: www.wpallimport.com/support/

[@duncanphillips5728]

This was extremely helpful, thankyou!

[@chrisder1814]

hello and do you also use the function in Google sheet which allows you to synchronize with WordPress?

[@soflyyplugins]

I'm not sure what function you're referring to here, if you can provide more details over at out support (www.wpallimport.com/support/) we can advise.

[@chrisder1814]

@soflyyplugins I'm talking about the Google sheet import function could you explain to me what is the difference with the appscript function do you use APIs? in Google sheet or other Are appscript and appsheet two different things? but I don't know what the difference is I would like to use APIs in Google sheet I think it's done through appscript? Is Appsheet something else? is it for applications like glide? then could you explain to me why by creating an API I can only scrape the information (title no, number of views...) from my own videos I mean I don't understand why I can't retrieve public information, I'm not doing anything illegal? since it's public and also could you explain to me what is the difference between app script and Google sheet add on: API connector can you also explain to me how the import xml function of Google sheet works? I mean does it work with an API system? I don't think so since it doesn't require any API and finally I wanted to ask you if you know the Amazon SP API? I would like to retrieve information from my Amazon seller account using their API, could it work with the Google sheet API connector?

[@soflyyplugins]

If you still need assistance, please message us via support so we can help: www.wpallimport.com/support/

[@abdullahsiddiqui4453]

i like the way of your teaching thank you sir

[@markthered2007]

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.

[@soflyyplugins]

Thanks for sharing your insight!

[@ramban3488]

hi , thank you for your videos , i have one question , is there is a way to export all my variable products via this plugins and afterwards on a local host change the category of the same products from variable to simple (via the excel) & re upload it back to wordpress website to replace the all or some of old variable products ? objective -beside the backup and add new products- is to change the ready made drop-down menu in the variable products and have all displayed nicely in one page. thank you again

[@soflyyplugins]

Hey, sure this is doable. If you need help, message us at www.wpallimport.com/support/ and we'll assist.

[@eddiesho]

Great stuff right here

[@Ari-zp4dd]

whats the difference between that and the defult upload woocomerce option?

[@soflyyplugins]

Our plugin provides more options and further control over your data.

[@jessierojas2819]

Do simple products need to be separated from variable products or do they share the same Csv file?

[@soflyyplugins]

They can be imported in the same CSV file: www.wpallimport.com/documentation/import-variable-products-woocommerce/#simple-and-variable

[@fanl11]

Im getting a "Sorry, this product is unavailable. Please choose a different combination" when choosing any combination of variations on the shop, any idea why?

[@soflyyplugins]

It's because those variations don't exist.

[@kudzaishemadanhire]

Thanks men you are a life

[@WPAssistans]

Hi. do you have any idea how I do if I have around 30 colors an 30 lenghts for my products? Price is set by lenght, color doesnt affect the price. Is same for all products. it feels too wricked to make 900 lines per product. Any idea? 😛

[@soflyyplugins]

Hey, reach out to our support and we'll advise on the options available: www.wpallimport.com/support/

[@wolfenburg1asd623]

Hello , I was wondering how you put certain products in specific categories ? Thanks

[@drsygfq]

how to?)))

[@soflyyplugins]

You can define the categories when importing: www.wpallimport.com/documentation/taxonomies-overview/

[@theloveemovement]

Nice one mate thank you!

[@Ilkestonwebdesign]

My CSV sheet contains a mixture of Simple Products and Variable products, but they all imported as Simple products. Why would that be the case? Does the plugin not handle both at the same time? I already emailed support and I can make a video of my own showing the issue and what happens (unlisted video, of course)

[@soflyyplugins]

I hope we helped via support! If not, please email us again at www.wpallimport.com/support/ and we'll assist.

[@ayinnahking]

This website ain't working

[@pruthviraj8343]

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?

[@MAtrlIx]

I have exactly the same problem. Did you find a solution? Please let me know.

[@Somemzi]

Any solution to this problem?

[@soflyyplugins]

You need to enable this: www.wpallimport.com/documentation/import-variable-products-woocommerce/#link-all-variations

What about if we have stock for all variation and same price for all variation too?? I cant find example for this here !? Please ansvear ASAP. Thanks in advance !

[@soflyyplugins]

If you still need help, message us over at www.wpallimport.com/support/ and we'll assist.

[@PouyaBagheri-ul6oo]

Amazing

[@chrisder1814]

hello can I synchronize my excel product catalog with woo?

[@soflyyplugins]

Hey, yes, you can do that. If you run into issues, message us via support and we'll assist: www.wpallimport.com/support/

[@geoffl4957]

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

[@soflyyplugins]

Watch this video on importing images for more info on that: kzbin.info/www/bejne/rXKzeJmNmZZmY9k

[@RuturajPatki]

+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.

[@OliveVlog]

Does this import and export for bulk updates

[@soflyyplugins]

Yes, it works: www.wpallimport.com/documentation/bulk-edit-woocommerce-wordpress-data/

[@mohamedelabi6490]

is there any samples of the variable product CSV

[@soflyyplugins]

We have example files here: www.wpallimport.com/documentation/example-files/

[@fynxag]

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?

[@soflyyplugins]

Yep! :)

[@fynxag]

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.

[@soflyyplugins]

E-mail [e-mail] and we're happy to help you.

[@dmitryl5734]

Hello! I have big file with all products. In this file half products is variations, half is grouped and half products is simple products. What's the way to use plugin for situations like i have? I need to make new file only for variations products? Or you have the way to use one file with different kinds of product types? It's uncomfortable to divide my one work file for many files with simple products and variations. I am a little confused with the way to work with big types of products with different attributes and variations with plugin.. I think the way is to do many little files for variations with different attributes. But it is a very long story...

[@soflyyplugins]

You can import both simple and variable products at the same time: www.wpallimport.com/documentation/import-variable-products-woocommerce/#simple-and-variable

[@itstore3459]

When importing products in temporary offer, when I set start and end dates for offers they do not work, why?, thank you.

[@soflyyplugins]

Reach out to our support and we'll help: www.wpallimport.com/support/

[@boxertgfs]

Can we use this same method to update a description on several existing products?

[@soflyyplugins]

Yes, please see this: www.wpallimport.com/documentation/manual-record-matching/

[@ilansalomon]

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

[@soflyyplugins]

We have some examples here: www.wpallimport.com/documentation/example-files/

[@gurtelem3586]

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.

[@soflyyplugins]

Sure, you can use our "Adjust Prices" option when uploading your products.

[@brandonnater227]

I'm having an issue that I'm seeing showing up in this video as well. The order of the attributes gets changed around. In the spreadsheet on the kids T-shirt, yellow is listed before red but shows up with red first in the drop-down. Same thing happens for the size, with Large appearing in the front-end drop-down before Small. It appears that WP All Import automatically reorders or alphabetizes the attributes. It also affects numbers. In my setup, my length attribute includes 15 variations labeled 1 thru 15. However, upon import, the order changes to 1, 10, 15, 2, ... 9, 11, 12, etc... I believe this to be a plugin issue.

[@soflyyplugins]

Hey, contact us via support (www.wpallimport.com/support/) and we'll assist further.

[@davidsassov.1061]

Hi, would you tell me how can I upload all images to the server? so I can do the same on the video Thanks!

[@soflyyplugins]

You can upload the images to your server using FTP: www.wpallimport.com/documentation/importing-images-from-your-server/

[@dineshprajapat7513]

how can i upload my products on different pages in wordpress???

[@soflyyplugins]

Message us over at www.wpallimport.com/support/ and we'll help further.

[@yuliazubova5495]

Please, how to add new variations to existing parent product? When I try to add variations new parent is created .

[@soflyyplugins]

Please see this: www.wpallimport.com/documentation/import-variable-products-woocommerce/#faq3

[@PswACC]

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.

[@soflyyplugins]

We create them manually. You can separate them as shown here: www.wpallimport.com/documentation/taxonomies-overview/. If you need help, message us over at support: www.wpallimport.com/support/

[@straduk]

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

[@soflyyplugins]

Reach out to us via support and we'll help: www.wpallimport.com/support/

[@Yanggingable]

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

[@soflyyplugins]

We're always happy to provide support to free version users, so just e-mail [e-mail] and we can help you get it working.

[@akashj.6154]

How can we import product feed from 2 or 5 websites for price comparison site?

[@soflyyplugins]

You can import multiple feeds by creating a new import process for each feed.

[@ayinnahking]

The issue is I can't upgrade to pro Somehow the plugin website doesn't open

[@soflyyplugins]

Hey, I'm not sure what's wrong! Please try again over at www.wpallimport.com/pricing/. If you still have issues, reach out over at www.wpallimport.com/support/ and we'll help.

[@ayinnahking]

This website isn't working

[@soflyyplugins]

Please email us to [e-mail] and we'll assist over there.

[@mohamedelabi6490]

How do you bulk export the images?

[@soflyyplugins]

Hey, see this: www.wpallimport.com/documentation/how-to-export-wordpress-csv-excel-xml/#faq3. If you need help, message us at www.wpallimport.com/support/

[@Gamesofmach]

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)

[@soflyyplugins]

You set up how to import the products in the template. This applies to all imports you create: www.wpallimport.com/documentation/importing-an-xml-or-csv-file/. If you need help, reach out to us over at www.wpallimport.com/support/

[@Gamesofmach]

@@soflyyplugins Thanks for the response after 7 Years😄

[@MrThresher7]

Pls make this video downloadable for offline viewing.... Thanks.

[@soflyyplugins]

Thanks, we'll consider this.

[@shivamvlogs5052]

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 ?

[@soflyyplugins]

If you still need assistance, message us via support: www.wpallimport.com/support/

[@maysle1]

how to import product gallery images please?

[@soflyyplugins]

It's imported as all other images: www.wpallimport.com/documentation/import-images-from-urls/

[@kevinmorrison7672]

hi, can i use wpallimport to EXPORT a set of variable products to excel?

[@soflyyplugins]

Yes, you can. Try it here: www.wpallimport.com/try/

[@mathbyruchi]

Good

[@WebGem]

Unfortunately The WooCommerce Add-On is Required to Import Products. And it costs 149$

[@soflyyplugins]

+HikariXRyo just add another column in Excel called "SKU" and put the SKUs in that column.

[@shawn50510]

+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.

[@soflyyplugins]

+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 [e-mail] and we can help you in more detail.

[@sagar3025]

Lol why are not including categories in every tutorial. Thats exactly i want to see

[@emretoraman2766]

and SKU

[@soflyyplugins]

Thanks for this recommendation! I'll pass it along to our content team

[@Alianezhad]

perfect!

[@susigan]

SAme work wirtth WP import to Real Estate ?

[@soflyyplugins]

Yes, see: wordpress.org/plugins/wp-pro-real-estate-7-xml-csv-property-listings-import/

[@HikariXRyo]

How would you add SKU for each item and variable item?

[@fernandoluis53]

did you find out?

[@Zhurak]

just add a new column called SKU and add the numbers to each one corresponding to each item

[@soflyyplugins]

We have some example files here: www.wpallimport.com/documentation/example-files/

[@afcoproassociationfrancais677]

how can we eliminate the price range?

[@soflyyplugins]

Reach out to our support and we'll assist further: www.wpallimport.com/support/

[@tamarabatta_]

Can my images be a dropbox link?

[@soflyyplugins]

Yes.

[@rashabd6214]

wow

[@segitterius]

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

[@soflyyplugins]

You can get the add-ons on our site: www.wpallimport.com/portal/upgrade/

[@rantg]

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.

[@soflyyplugins]

That sounds interesting!

[@king0vdarkness]

149???? for a cvs uploader!! Better off paying for a scrapper tool that uploads products instantly

[@soflyyplugins]

We're sorry you feel that way!

[@oujisan]

200$ damn

[@soflyyplugins]

Hope you gave it a try over at www.wpallimport.com/try/

[@sabadragon698]

150 dollars for one upload