WooCommerce Product CSV Import Suite or Product CSV Import Suite WooCommerce extension lets you import and export products to and from WooCommerce. You can import hundreds, even thousands, of products using one file.
Product CSV Import Suite lets you import thousands of products and supports complex products and custom data from Bookings, Product Vendors, Brands, Google Product Feed and more.
Also, get WooCommerce Product Bundles
Manage and sync your catalog, including bookable products and more
The bread and butter of WooCommerce is allowing you to sell anything, and that includes appointments, reservations or services with WooCommerce Bookings. It can be time consuming updating products (for example, adjusting prices), especially if you have a lot of products or many changes.
Save yourself the hassle of making changes one-by-one with Product CSV Import Suite.
Create, upload or update thousands of products at once, including complex products. Mass update standard items like price and description, along with custom data like appointment availability, resources and more.
This documentation is for the premium Product CSV Import Suite extension. If you’re looking for documentation about the product importer built-in in WooCommerce 3.0+
How does WooCommerce Product CSV work?
The plugin takes your CSV and maps the columns to the fields that you would normally complete through the WordPress Admin Screens. So, for example, the post_title column is mapped to your product name, which uses the post title field; the price field is mapped to the price you set for your product. For the plugin to work correctly, all of the column headers must be correct, and all of the fields you fill in must be in the correct format. If there are any deviations your import may fail.
Notes on Formatting CSVs
When you create your CSV, there are some rules you need to follow. This will ensure that your text file has the correct structure for uploading:
- Each Product must be on a new row.
- The first row must include the column headers. This enables to plugin to map the fields correctly.
- Taxonomies, Attributes and Images support multiple items. Separate these with a pipe “|” character.