There's a few ways to import XML and CSV files into WooCommerce in bulk without any fuss by using one of the best import methods I've come across called the WP-ALL-IMPORT plugin.
Chapters:
0:00 Intro & Video Explanation
2:26 Installing WP All Import Plugin & Installing the Add On Plugin
3:44 XML & CSV File Importing
15:16 Outro
LINKS:
Our Website: https://webdesignhub.co.za/best-way-of-importing-woocommerce-products/
Support our work on Patreon if you like what we're doing: https://www.patreon.com/webdesignhub
Blog Version of Video: https://webdesignhub.co.za/best-way-of-importing-woocommerce-products/
WP All Import Download Link for Manual Install: https://wordpress.org/plugins/wp-all-import/
WP All Import Add On Plugin to be installed in the WordPress Repository
One of the biggest problems with WordPress & Woocommerce is the vast amount of choices you have when choosing a plugin, specifically to this video, an Import Plugin. WordPress has multiple different developers creating similar plugins that basically does the same thing, but they're not all great plugins so you mostly end up with a plugin that does very little before you have to end up buying the pro version to do the next basic thing. That's the crazy world of open-source and makes filtering through the WordPress Repository a slight bit of a nightmare trying to find the right plugin for you.
Today I'm saving you the hassle, so look no further!
Sure we can use WooCommerce's built-in import function but I've found it to be clunky and very hard to use because the user has to adopt their WooCommerce product content in their CSV file specific to the fields that Woocommerce offers and all that without having any kind of preview of what you're importing. Aside from the previously noted drawback, you require an extra program on your computer that will allow you to edit CSV files, as opposed to logically adding your product content to an excel file and just upload it that way.
The plugin I'm using for this however, called WP All Import has a step-by-step Wizard and a click, drag and drop function which allows file types like XML, CSV or even Microsoft Excel's file extension to be easily uploaded, then assign relevant fields and edit your input content like pricing, brands, custom taxonomies and an endless list of fields before pressing that import button.
Users looking to create a dropshipping store with thousands of products, especially has a huge benefit to gain from this video and the plugin we're showcasing today.
source
Amazing tut. on how to how import XML and CSV file to Woocommerce. By the way additional product data you can get via web scraping. Thank you for your explanation. 😊
that f u c k i n g music in the background it was more s h i t that the video
my web developer has imported products Via a CSV file but many products inside the csv does not have any pictures so wordpress goes and adds it into trash. is there a work around for this? its very frustrating having to go look for photos somewhere else and adding it to each product in trash then moving it to my other active products. any faster solution?
@ Web Design Hub, this is really a great video👍👍👍. Please when you say you have "already prepared a CSV file", how exactly did you do it? That was the only part of the video that I did not understand.
Thanks for the video. I'd love to get a copy of your preped spreadsheet! It would really help! Thanks!
awesome tutorial, thank you for your video. it is very clear and easy. Also as newbie in WooCommerce eCommerce i am using ""e-scraper"" to scrape all product data from my supplier sites and other sources. It helps me a lot. maybe it helps somebody too.
Thank you for your input!!!
Great tutorial, music is a bit loud though. But still good nonetheless.
HI, great tutorial. I have problem with image 🙁 My code not is in table like you but in code. My image code is:
<Photos>
<Photo>
<IdType>1</IdType>
<Name/>
<RelativeFilePath>moxedo_Files/Foto/1_1617_usb_wifi_1.jpg</RelativeFilePath>
</Photo>
</Photos>
I set in IMAGE tab: <RelativeFilePath> but it don't find photo….why? Where i wrong?
Very helpfull and underrated video! Thank you alot 🙂
Keep up the great work!
Great video. Very useful. If you accept feedback, i would make the music a bit more quite and the more important thing is the name of the video. For more views i would suggest you to put "XML and CSV file" in the name of the video. I think this would help for sure.