Getting Started
Import
Export
Meta Data
Bulk Edit
FTP Cron Schedules
Code Snippet
Advanced Topics
Troubleshooting
Third-Party Compatibility
FAQ
ChangelogProduct categories helps to sort and organize the products in an efficient manner. With Product Import Export Plugin For WooCommerce, you can export hierarchical category structures and multiple categories that are associated with a specific product. This enables you to export WooCommerce products to a CSV/XML file with both their categories and subcategories.
From the WooCommerce store, let us export the following products with categories.
Steps to Export
From the WordPress admin panel, navigate to the menu: WebToffee Import Export (Pro)>Export.
- Specify the post type as Product.
- In step 2, choose either Pre-saved template or Advanced export method as both of these facilitates data filtration during the export process.
- In step 3: Filter data, select the categories you want to export under Product categories.
- Click on Step 4 to map the export and reorder the columns.
- Click on Step 5 to finish the export.
For detailed export procedure, follow the steps in How to export products.
Sample view of exported file
On successful export, you can download the file.
In the exported file, ‘|’ is used to separate the multiple categories of a product. The ‘>’ symbol is used to add hierarchical structure of a product.
Download : Sample CSV.
Related article: How to import WooCommerce Product Categories.
- Was this article helpful?
- Yes, thanks!Not really
Comments (6)
James
August 29, 2022
Issues
Choosing to have your products in multiple categories and are hierarchical
Top|Middle|Bottom
Top>Middle>Bottom
The plugin can’t handle this; it would seem.
When you export, you get
Top > Middle|Top|Top> Middle > Bottom
So you can’t use this export, for example to change categories or even change pricing. What would it do when uploaded?
James
August 29, 2022
If you have product in for example three categories example – TopLevel and MidLevel and LowLevel it would look like this
rajib
December 19, 2019
Great plugin indeed. Very helpful for transferring Woo commerce products. Thanks
Mark
May 28, 2018
Hi,
Thank you for your high opinion.
tremaskinazhozefina
May 24, 2018
This is my first time pay a visit at here and i am truly impressed to read everthing at one place.
ron6
April 24, 2018
Post writing is also a fun, if you be familiar with after that you can write or else it is difficult to write.