May be you’re looking for best WooCommerce CSV importer plugin! Import products and variations to and from WooCommerce using Simple WooCommerce CSV Importer. Mass import hundreds, even thousands of Products into your WooCommerce store with the CSV Import suite. CSV Import suite lets you import all types of products, even product variations! This user-friendly importer, with clear step-by-step instructions helps you import Categories, Tags, Products and other Product details into WooCommerce.
WooCommerce is an open source e-commerce plugin for WordPress. It is designed for small to large-sized online merchants using WordPress. The world’s favorite eCommerce solution that gives you complete control to sell anything. Get started today for free.
Recommended: Best Selling WooCommerce WordPress Themes
Simple WooCommerce CSV Importer Features
- A simple, CSV product loader for WooCommerce.
- Supports importing hundreds or thousands of products at once. (The only limit is your patience!)
- Loads images via URL or local file path. (Now detects and skips duplicate images!)
- Loads hierarchical category structures (see Importing Hierarchical Categories below.)
- Lots of other great features suggested by plugin users (see Cool Stuff It/You Can Do and Full List of Importable Attributes below.)
Cool Stuff It/You Can Do:
- AJAXy Importing (avoids timing out on large data sets)
- Load Images via a URL (Requires allow_url_fopen or cURL on your server)
- Set Featured Image
- Load Categories and Tags (Categories and Tags are created if they don’t exist)
- Add Categories and Tags to Products by Category/Tag Name or ID.
- Load Custom Fields
- Set Visibility on Custom Fields
- Map any CSV column to any Product field (No header row required, but if you happened to include one, I’ll use it to take a stab at what goes where)
- Map multiple CSV columns to one Product field (last non-empty column wins, good for merging columns)
- Basic validation for multiple-choice fields (fields with a limited set of valid values like yes/no, instock/outofstock, etc.)
- Dollar signs, commas, etc. are stripped out of number fields like prices, weight, length, width, height
- If SKU already exists, existing product is updated rather than inserting new product.
Loadable Product Types:
- Simple Products
- Virtual Products
- Downloadable Products
- External Products
Free Download: Simple WooCommerce CSV Importer
Final Words
If you’ve any issue on using this plugin or installing this plugin then ask me here. Want to get safe installation support then should buy Pro Support. Thank You for using Simple WooCommerce CSV Importer. :)
What is the format for hierarchical categories?
I have 1000s of products that are going to be imported. Some of these products are in several categories. How do we add a simple product that are in different categories? I know some tools out there you can use a comma. Is this the same here.
Yeah!
Hello. I have a lot of categories and subcategories with images for uploading into woocommerce. Is it possible to do using your plugin? I found out how to import bulk categories to woocommerce but without images.
Hi. I am trying to update my variable products with a new price from a CSV. It has the current produce SKU in and I think I’ve mapped the columns correctly but it always comes back with “0 of 378 products have been uploaded”. SKUs all match and I’ve only chosen to sync the price in the hope it uses the SKU to match and update. Am I missing something?
Can you email on with website link? And temporary login of store?
Hi, What should I typ in in Multi-Cat when I’m using a lot of hierarchical categories? Which sign I have to use to separate? Thanks.
You can check sample csv file then it will be clear to you. Thank You! :)
Is there a way to download a csv file and use that as a template to upload products?
Actually i am little bit confused about your question but pretty sure that you’re asking about sample csv file to upload your own products. If that true then a sample csv file included with this plugin. If you unzip files then can see it. Thanks!
Hi,
How do I organise the csv file to import only categories with parent child relationship. I tried figuring out for past 3 days but I am unable to find a way. Please help.
Can you send me the sample of csv you’ve tried? Then i can fix it for you. :)
Can you share or post a Master CSV sample file to follow as an example of how to format my product data for successful import? Please include multi-variant products in the example.
Thanks!
I am looking to import Product Categories into Woo Commerce. I Have thousands of Hierarchical Categories. I have tried using this plugin. But the Parent-Child Categories import as one category no matter what separator symbol I use. Do you have an idea of how I can get my thousands of Parent and Child categories imported using a CSV file….. into Woocommerce (mySQL?) Thanks..for any help….
Hey Linda,
I’m sorry to late reply here. Actually was on tight schedule last few months. I think you have got a way to import it. If still facing this issue then let me know.
Thanks!
How could I do this?
What are you talking about? Please make it clear to me.
Thank you for your prompt response, Ataul.
I have a similar problem as Linda. I have hundreds of categories that mostly have 2-level subcategories. I want to import them to my woocommerce site. I’m wondering what’s the correct format to use to have all those categories and subcategories to be uploaded all at once.
Please email us to get an example or csv file. Thanks!
I like the Simple CSV Importer for WooCommerce a lot. Great project, and a much needed free WooCommerce addition! About those “clear step-by-step instructions” of yours though, where exactly are they — as I cannot find any documentation whatsoever for the Plugin (nor is there any other resource about it I can find on the web/thrid-party sites etc)…
Please do finish that excellent work of yours by adding that much-needed manual. It would also help you get rid of those low-star ratings on the WordPress Plugins site. As it stands now, the Plugin is not, at all, self explaining as the obvious functions fail to do anything; maybe you can give me a few pointers as to whether or not that is an error or “normal behaviour”? Again, I like your idea and project very much in general!
Hey marquix, Thanks for inspiring me. It’s really a great issue when someone say something about work. I always try to do my best work in my field. Sometime it’s difficult to manage lots of project at the same time. Last few months i was so busy with some different project. I will follow your great suggestion. Will make an documentation about this plugin. And also thinking to add more features on it. Thanks again! :)