WooCommerce Variable Product CSV Import Tutorial (or XML) - WP All Import
Vložit
- čas přidán 11. 11. 2014
- Get the WooCommerce add-on for WP All Import at www.wpallimport.com/woocommerc...
In this tutorial you'll learn how easily import variable products from CSV or XML files into WooCommerce. Importing variations to WooCommerce from CSV or XML files is a complex process, but WP All Import takes much of the pain away.
When using WP All Import, your file can have almost any format - the only thing you need is something that is common for all variations that allows WP All Import to link all the variations together into a single variable product. You can use any element names if you are importing variable products from an XML file to WooCommerce, and you can use any column names in an Excel/CSV file if you are importing your variations from a CSV or Excel file to WooCommerce. This is a big advantage over the WooCommerce Product CSV Import Suite, which requires variable products to be stored in a very specific format.
WooCommerce variable product imports from CSV or XML files has never been easier than now, and when using the WooCommerce add-on for WP All Import you also get all the power of WP All Import such as the ability to easily update your imports later, merge stock levels from a different file in, schedule the import on a cron job to always keep your site up to date, and much more.
Learn more about WP All Import Pro at www.wpallimport.com/
Go to www.wpallimport.com/documentation and look for the WooCommerce section for more tutorials on importing variable products with WP All Import.
Special thanks to www.chillstylestore.com/ for the example data file used at the beginning of the video.
E-mail support@wpallimport.com for help. We have 5 support reps who work 7 days a week doing nothing but helping you get your imports working, but they aren't on CZcams.
Extremely helpful information, thank you so much!
Thank you so much! That's really a great explanation!
For my case it works fine! And the support is professional and immediate. Worth the money~
Glad we can help!
This plugin is awesome. Thanks!
Glad to know you liked it!
Would you happen to still have these example import files? I'm struggling to import a product that has multiple variations. For example, I have products that have a color variation but another variation that need to be available 2 times for one color. In other words I have a yes/no selection that I need to import as a variation and give it pricing. When I do this using all import it will only import yes or no but not both. I need each color variation to also be linked to the yes/no attribute for pricing.
Hey, we have these examples: www.wpallimport.com/documentation/example-files/. If those don't work, message us over at www.wpallimport.com/support/ and we'll assist further.
Thank you so much!
HI, what can i do with the images?, they disapper when i create the csv file and dosent upload
Reach to us via support and we'll investigate: www.wpallimport.com/support/
Is it possible to use variations based on attributes with different prices in the import? when I select "link all variations" the variation tab disappears and then when I import no prices populate over.
Yes, but you need to map them via the "Variations" tab. See: www.wpallimport.com/documentation/import-variable-products-woocommerce/
Verry verry verry thank you !!!
What happens when your csv file has one image per variation? Yours seems to have multiple images for all the variations on file, but mine has one image per variation. And each variable image I drag into the relevant section turns into the same image across the board. I hope that made sense and can you help?
Message us over at www.wpallimport.com/support/ and we can help.
Extrelpful information, thank you so much!
Can we set-up a few products on the site and then export the file as template to edit it offline and import later as shown here? That would be great help to manage inventory.
That sounds like a great idea that should work.
Sure, as explained in our bulk edit docs: www.wpallimport.com/documentation/bulk-edit-woocommerce-wordpress-data/
The CSV feed we’ve received has both simple and also variation items. Variations are formatted as below;
parent/child
parent-child
parent-child-child
parent-child-child-child
Your CZcams tutorials cover CSV variations but they above structure is not covered in any of your videos. Please advise. Thank you!
Reach out to our support and we'll help further: www.wpallimport.com/support/
Your videos for WP Import are great. Iam planing to purchase this plugin but i have a question, i have my suppliers URL from his database and i want to import this products in my site, i want to up the prices of a category for 10% as a profit and i want to up the prices of other category for 15% as a profit. Can i do it with this plugin? Hope you can help me, thank you!!!
You can use a PHP function for that: www.wpallimport.com/documentation/inline-php/. Message us over at www.wpallimport.com/support/ if you need help.
well done.
Not sure why the plugin has only those options to import a variable product. My variations don't have SKUs. How do I import it then?
You can use other of the options explained here: www.wpallimport.com/documentation/import-variable-products-woocommerce/. If that doesn't help, reach out to our support and we'll help: www.wpallimport.com/support/
Thanks!
How to do for manage different prices?
Reach out to us via support and we'll advise further: www.wpallimport.com/support/
Thank you for this video, do you have a video or tool on how to create the CSV file
Please see this video: czcams.com/video/OsDnkx18PYY/video.html
Does WP Imports allow us to add the supplier's information and SEO? Great video
Yes, it does!
Can anybody help? how to import all images for variable product? if i import variable product it imports all images for the first product, and only one (first) picture for the other variations of the product. Thanks!
We're sorry we're so late, but if you still need assistance, please reach out: www.wpallimport.com/support/
I have toys with different colors but each toy product has their own title and its own sku- the only thing that changes is that the title xml file has the color added to the title. Its difficult to put the same toy product with different colors, how do I fix this would.
DID you ever get this solved?
We can help, reach out via our support and provide a copy of your import file so we can assist: www.wpallimport.com/support/
is it possible to import variable posts instead of woocomerece products? I created ACF for posts for my listings, and i have variable listings. How can i do that if i dont have the option when uploading " posts" thank you
Message us over at support and we'll advise further: www.wpallimport.com/support/
Images don't work on mine.
Each variation in the import file has just one image.
It uploads to the media manager, but doesn't actually get set to the variation. It doesn't get set to the featured image of the parent either for that matter.
If I turn on the "add variation image to gallery" option, then the gallery gets filled with the images, but they don't get attached to the actual variation.
In my case, the CSV uses the "variations use the same title, no parent" style.
We need to see the problem firsthand to help. Message us over at www.wpallimport.com/support/ and we'll continue there.
Hello, what option i have to use , if i had a sku and parentsku, but i sell music, so i need to put a demo audio and after payment the option of download the file , what should i do?
Message us over at www.wpallimport.com/support/ if you still need help and we'll assist!
My variations have different prices, but I can't get the import to reflect that. Help!
were you able to solve this?
We'll need to see this issue firsthand to help. Message us via support and we'll advise further: www.wpallimport.com/support/
04 1_4 Inch Sockets Ratchets & Attachments\1-4 Drive Sets\200.tif
How do you make images with url like this show
Please see this: www.wpallimport.com/documentation/import-images-from-urls/#import-images-from-computer
When i choose variable product no variation field appear same as the video? why i already purchased the pro version! thx
Message us over at www.wpallimport.com/support/ and we'll help further.
I couldn't quite understand the images of the variations... Is it all manual? After all, there are more than 100 products..
No, it's done as all other images. If you need help, message us over at www.wpallimport.com/support/
tks bro
its not free anymore.. when i put it as Variable products it says :((
Upgrade to the Pro edition of WP All Import and the WooCommerce Add-On to Import to Variable, Affiliate, and Grouped Products
That's right! You'll be able to import variable products using the WooCommerce Import Add-On Pro
Can this be done on normal posts or can this only be done on WooCommerce?
+Stan Tan Also on normal posts. But u don't need the WooCommerce extension for the WP All Import for posts as far as I know.
If you still need assistance, message us via support over at www.wpallimport.com/support/
Hi, Where can I download the CSV file as an example?
drive.google.com/file/d/1FttIODkrapEzZX9n8voc7EDaB2z7tlcu/view
We have some example CSVs here: www.wpallimport.com/documentation/example-files/
Do the images need to be from url?
They can also be imported from the Media Library: www.wpallimport.com/documentation/import-images-from-media-library/ or from uploaded files: www.wpallimport.com/documentation/importing-images-from-your-server/
how i can convert currency USD to mexican pesos in the options
Click "Adjust Prices (mark up, mark down, convert currency)" inside the General tab of the WooCommerce add-on to convert from USD to pesos.
How add taxonomy brand name, admin?
Thanks
Version simple free has taxnomy different,
Version pro has not taxonomy, only taxonomy category product
can you import normal products and variation products together?
Yes. Any products that don't have variations included in your file will automatically be imported as simple products.
+Soflyy you the best
also, when selecting catogories and with child categories, is the title of the category case sensitive from excel to wordpress? it seems like its creating new categories and not putting them into the existing ones.. thanks!!!!
Reproduce the import at www.wpallimport.com/try and e-mail support@wpallimport.com and we'll take a look and see why they're not getting put in the existing categories.
Can I get your CSV sample file?
We don't have this same file, but we have some example files here: www.wpallimport.com/documentation/example-files/
My variables are missing pricing. Now all my products are showing out of stock!
That's odd. Message us via support and we'll help: www.wpallimport.com/support/
@@soflyyplugins I fix it 5 years ago. But thanks.
How to setup variable products with this type of csv
Product name 22 cm
Product name 24 cm
Diffrent product ids.
Please help
We have written documentation here: www.wpallimport.com/documentation/import-variable-products-woocommerce/
A good product but nothing happened since i bought it first time in 2012 so a suggestion to be more compatible with export from other systems would be to be able to map variable products. I have an export where Sizes are S,M,L,XL;PRICE;STOCK all made as simple product i have tried to import as variable product but still created as simple product because WP-ALL import cant figure out that the SIZE:STOCK has to be seperated in two columns when it's not in the import file. And no i can't just change the file it it's 20000 products and also has to be translated in the process. So a simple solution would be to be able to map it into two different columns in the import process.
And thats just one example that would be simple to solve but probably many others where it could be helpfull.
Hey janus, I've come across the same problem I have a t shirt for example with the sizes as you say and I've made it a variable how do I go about fixing this as I am yet to even work on this . I have the plug in when making the variables it just goes back to simple product when I have listed all attributes aka sizes. Is there something I have to do on the csv for it to be recognised? How have you overcome this issue? Kind regards
Hey, reach out to our support and we'll assist further with this: www.wpallimport.com/support/
I have a product with 2 colors and 4 sizes, but no matter how I upload it, it fails. It is obviously a variant product, but after uploading, it always turns into many simple products. What is the reason? Can anyone help me? I want to help demonstrate remotely
Did you manage to fix it? I have a similar issue where it doesnt show the variants :(
Send us a message via www.wpallimport.com/support/ and we'll help.
This video is not showing true variations. All the plugin is doing in this video is creating loads of 'Simple Products' not variations? How do I get this plugin to create VAriations within the product??? Why don't you show us that in this video?
This video explains better: czcams.com/video/Y2Q8apRDxMg/video.html. We also have documentation: www.wpallimport.com/documentation/import-variable-products-woocommerce/
Do you offer services?
Hey, we have support over at www.wpallimport.com/support/
No mention of any categories either...
We're making videos about this next.
You know real life is not that simple - variations color - two or three kinds of sizes - mispelling and or translations for colors name etc. there is still lot's of work in that plugin.
We invite you to give it a try over at www.wpallimport.com/try/
Not really helpful. Most people I think will have sizes and colours listed in the one product as a column say Sizes, and the Size contents for the product will be say 8,9,10,11
We would not have a different product code for every different size of the same product.
You can import these products by using this option: www.wpallimport.com/documentation/import-variable-products-woocommerce/#link-all-variations
This cost a fortune. To expensive if you have product variations
Hope you gave it a try over at www.wpallimport.com/try/