WP Ultimate CSV Importer is an importer and exporter tool, allowing you to import your WooCommerce data into WordPress in CSV/ XML with effortless ease. It allows you to schedule your import, update, and export process. Ultimate importer enables you to import the WooCommerce fields along with a few WooCommerce add-ons. The add-ons are:
- WooCommerce Variations
- Woocommerce Subscriptions Product
- WooCommerce Orders
- WooCommerce Coupons
- WooCommerce Chained Products
- WooCommerce Product Retailers
- WooCommerce Product Add-ons
- WooCommerce Returns and Warranty Request
- WooCommerce Pre Orders.
The importer supports product gallery images, multivalue attributes, and custom attributes.
Product Gallery
- Specify image url path or existing image id in pipeline (|) separation.
- Image gets duplicated when the already specified image URL is mentioned for the second time. To avoid, mention image id if already uploaded instead of URL.
Multivalue Attribute
- Multiple attributes are separated by comma (,) and attributes are separated by pipeline (|) symbol.
- For example, consider the attribute as car, alto, figo, ikon | truck | van. car, truck, van are attributes and alto, figo, ikon are multiple values of car attribute.
Custom attributes
The custom attributes can be imported along with WooCommerce Variations.
- Multiple values for each attribute are separated by pipeline (|) and attributes are separated by comma (,)
- Eg: Attribute1|value1, Attribute2|value1
Product shipping class
Shipping classes are generally used for categorizing related product types to ship them together.
Examples of shipping classes in WooCommerce are,
- Bulky items
- Lightweight items
- Fragile items
- Specific packaging
To add a shipping class inside WooCommerce,
- Visit the WordPress dashboard, and move to WooCommerce > Settings > Shipping tab> Shipping Classes.
- On the page, select Add shipping class button.
- If you have shipping classes already, then you can see a row below the table to insert a new shipping class.
- Provide a Shipping Class Name(eg: bulky, discount, lightweight, poster pack) and add a description. Add a slug if you want otherwise leave it to let the slug fill automatically.
- Click Save shipping classes
How to assign shipping class to WooCommerce Products manually:
- Move to Products > Add New or select your existing Product
- In the product data meta box, go and click the Shipping tab.
- Choose any one class from the dropdown of the Shipping class field.
- Once done, click Save to add your new product or click Update to update the already existing product.
To import shipping classes to bulk products,
- Add a field product_shipping_class in your CSV/XML and provide the class name as value.
- You can import and export the shipping class field along with your WooCommerce products just by following the same CSV importer import and export steps.
Supported Modules #
| WooCommerce Products | WooCommerce Attribute and Variations | WooCommerce Orders |
| Coupon | Refund |
To know how to import, update and Schedule your import please refer the link. You can get your WooCommerce Products Import Sample CSV Sample CSV here and the complete detail about your WooCommerce field values below.
CSV Samples of distinct fields #
| WooCommerce Fields | Description & CSV Values | CSV Sample Value |
|---|---|---|
| visibility | Specify the product visibility 1 – visible 2 – catalog 3 – search 4 – hidden | 1 |
| tax_status | Specify the tax status value 1 – taxable 2 – shipping 3 – none | 1 |
| tax_class | Specify the tax class value 1 – standard 2 – reduced rate 3 – zero rate | 1 |
| product_attribute_name | Specify product attribute name. Multiple values are separated by pipeline ( | ) | Red|Blue |
| product_attribute_value | Specify the values for attributes. Multiple values for each attribute are separated by comma (|) and multiple attributes are separated by pipeline (,) | 1|2,6|9,4|8 |
| product_attribute_visible | Specify whether the product attribute to be visible or not 1 – visible 0 – not visible Multiple values are separated by pipeline (|) | 1|0 |
| stock_status | Specify the status of stock quantity 1 – In stock 2 – Out of stock | 1 |
| virtual | Specify whether the product to be virtual yes – enable no – disable | yes no |
| backorders | Specify the value for backorders 1 – No 2 – Notify 3 – Yes | 1 |
| Upsell_ids crosssell_ids | Specify the product id that you want to upsell or crosssell. Multiple are separated by comma ( , ) | 45,15,23 |
| product_shipping_class | Enter the name of the shipping class to assign for your product | bulky |
| product_type | Provide the value, 1- simple 2- grouped 3- external 4- variable 5- subscription 6- variable-subscription 7- bundle | 1 |
| stock_qty | Enter the quantity of the stock in numeric values. | 12 |
| downloadable_files | Mention the downloadable file URL here. Provide multiple urls in pipeline separator. | https://www.clickdimensions.com/links/TestPDFfile.pdf|https://www.africau.edu/images/default/sample.pdf |
WooCommerce Taxonomies Import
Assign taxonomies to WooCommerce and import values to it. You can assign default taxonomies or custom taxonomies created with plugins like JetEngine, ACF, Pods, Meta Box, Toolset Types, and CCTM to WooCommerce Products, Attributes, and Orders.
Prepare a CSV/XML including taxonomy fields. If you assigned meta fields for custom taxonomy (for an illustration, you have created custom taxonomies in JetEngine with meta fields, then include the taxonomy fields and meta fields in CSV/XML. Refer to our CSV Importer JetEngine documentation to add values to meta fields).
| WP Fields | Description & CSV Values | CSV Sample Value |
|---|---|---|
| taxonomies | enter the category name or id and provide multiple category values in comma or pipeline separator | 167,category1 |
How to Import Taxonomies in WooCommerce
- Create a CSV/XML for WooCommerce Products/Attributes/Orders including taxonomy field(also add taxonomy meta fields if needed).
- Visit Ultimate CSV Importer and upload the file.
- Choose the post type. For an illustration: WooCommerce Products or WooCommerce Orders.
- Click continue and map the CSV field headers with related WordPress fields.
- Make sure to map the taxonomy field.
- Provide a name for the mapping in the ‘save this mapping as’ textbox.
- Click continue and leave the media handling enabled to import external URL images.
- Then click Import on the next page to instantly import the Taxonomies to WooCommerce Products/Orders.
Add-ons 1: WooCommerce Variations #
WordPress Ultimate CSV Importer allows you to import multiple variations for a single product. The variations are imported by specifying the parent SKU of the product.
Get your Sample CSV file
| WP Fields | Description & CSV Values | CSV Sample Value |
|---|---|---|
| manage_stock | Specify the values Whether to manage the stock or not yes – enable no – disable | yes no |
| sold_individually | Specify the value whether the product to be sold individually or not yes – enable no – disable | yes no |
| product_tag | Specify the product tag Multiple tags are separated by comma(,) | Tag1, Tag2 |
| Product_attribute_variation | Specify the product attribute variation. Multiple values are separated by pipeline ( | ) 1 – enable 0 – disable | 1|1 |
| downloadable | Specify whether the product to be downloadable or not yes – enable no – disable | yes no |
| custom_attributes | Specify the attribute value in text format. Multiple values for each attribute are separated by pipeline (|) and multiple attributes are separated by comma (,) | Attribute1|value1, Attribute2|value1 |
| default_attributes | Specify the default value of the attribute. Used only by variable products | value1 |
| regular_price sale_price | Specify the price of your variation in floating point values. Multiple values are separated by comma | 10.02,9.95,7.99 |
Add-ons 2: WooCommerce Subscriptions Product #
WordPress Ultimate CSV importer allows you to upload various subscription details. Prepare a CSV file in the below table format to upload it on the Ultimate CSV Importer plugin or edit data in this Sample CSV
| WP Fields | Description & CSV values | CSV Sample Value |
|---|---|---|
| subscription_price | Specify the price for subscription renewal in numerical form | 99 |
| subscription_signup_fee | Specify the sign up fee for subscription in numerical form | 999 |
| subscription_period | Specify the time interval for subscription day / week / month / year | week |
| subscription_period_interval | Specify the no. of intervals between each renewal payment in numerical form | 2 |
| subscription_trial_period | Specify the time interval for the subscription trial day / week / month / year | day |
| subscription_trial_length | Specify the no. of time interval for the subscription trial in numerical form | 5 |
| subscription_length | Specify the no. of times the subscriptions renewed in numerical form 0 – For subscriptions that do not expire | 0 |
| subscription_payment_sync_date | Specify the synchronised subscriptions for day of the month as 1-27 (day) in numerical form | 3 |
| subscription_one_time_shipping | Specify the charge for the shipping once on the initial order yes – enable no – disable | yes no |
Add-ons 3: WooCommerce Orders #
The order add-ons include order status field and total order fields. Create a CSV file based on the table and upload it on the WP Ultimate CSV Importer. Click here to get your Sample CSV
| WP Fields | Description & CSV Values | CSV Sample Value |
|---|---|---|
| order_status | Specify the status for each order completed cancelled refunded on hold awaiting payment Processing pending | pending |
| order_total | Specify the order total which includes Cart & Order discount, Shipping tax | 365 |
Addons 4: WooCommerce Coupons #
The CSV import Woocommerce Coupons add-ons help you to import coupon details using the Ultimate CSV Importer plugin. Create your coupon CSV file by referring the table below. Click here for sample CSV.
| WP Fields | Description & CSV Values | CSV Sample Value |
|---|---|---|
| individual_use | Specify that the coupon is used in conjunction with other coupons or not yes – not used in conjunction with other coupons no – Used in conjunction with other coupons | yes no |
| exclude_sale_items | Specify whether the coupons apply to items on sale or not yes – coupons should not apply to items on sale no – coupons apply to items on sale | yes no |
| coupon_amount | Specify the coupon amount in decimal form without thousand separators and currency symbols | 34.896 |
| discount_type | Mention the discount type Cart Discount Cart % Discount Product Discount Product % Discount | Cart Discount |
Addons 5: WooCommerce For Chained Products #
Chained product add-ons help you to create combo products with the main products. You can create and upload these products as a CSV file. Get your sample CSV file in a single click
| WP Fields | Description & CSV Values | CSV Sample Value |
|---|---|---|
| chained_product_detail | Specify the existing product id that you want to be chained in this product and also specify the quantity. Id values are separated by comma (,). Multiple values are separated by pipeline( | ) | 12,10 (12 is the existing product id and 10 is the quantity) 15,8|17,9 |
| chained_product_manage_stock | Specify the value to manage stock for chained products yes – enable no – disable | yes no |
Addons 6: WooCommerce Product Bundles #
WP Ultimate CSV/XML Importer supercharges your ability to import CSV/XML data to Product Bundle meta fields. Using the Product Bundles addon, you can group simple, variable, subscription products and sell them as a bundle. Ultimate CSV Importer lets you easily add bundle products in bulk to your WooCommerce store within some minutes. To know how to import CSV/XML data to WooCommerce Product bundles meta fields, watch the below video.
To add values in the CSV file, check the below table.
| Product Bundle WP Fields | Description & CSV Values | CSV Sample Value |
|---|---|---|
| product_bundle_items | Mention the ids of each product to be bundled. Separate each product ids with the pipeline separator. | 6950|6946 |
| layout | Mention the value of the layout.Eg: Standard (or) Tabular (or) Grid. | Tabular |
| form_location | Use form locations to align each product in a bundle. You can add either value ‘Default’ or ‘Before Tabs’. | Before Tabs |
| item_grouping | Mention the text value for item grouping. You can add values like Grouped, or Flat, or None. | Flat |
| edit_in_cart | Enable edit in cart option to reconfigure the bundle if needed. To enable the option, mention yes in your CSV, otherwise, specify No. | Yes |
| pb_regular_price | Specify the actual price of the product bundle in numbers. | 70 |
| pb_sale_price | Specify the sale price of the product bundle in numbers. | 60 |
| optional | Mention the value ‘Yes’ for the Optional field to include the bundled product in the bundle. Mention the value ‘No’ to disable the Optional field. You can add multiple values and separate them with a comma separator. | Yes|Yes |
| quantity_min | Specify the minimum quantity for the bundled product. You can separate multiple values in the pipeline separator. | 1|1 |
| quantity_max | Specify the maximum quantity for the bundled product. Separate multiple values with pipeline separator. | 3|4 |
| priced_individually | Mention the value Yes to enable this field, otherwise, specify No. You can add values for each product in the bundle. Add multiple values with a pipeline separator. | Yes|Yes |
| discount | Mention the discount value for each product in the bundle. Separate multiple values with pipeline separator. | 5|10 |
| single_product_visibility | Specify the value ‘Yes’ to control the visibility of the bundled product in the single product page of the bundle. Specify the value ‘No’ to turn off the Product details of the bundled product. Mention multiple values in the pipeline symbol. | Yes|Yes |
| cart_visibility | Specify the value ‘Yes’ to control the visibility of bundled products in cart/checkout pages. Otherwise mention ‘No’ to keep it turned off as default. Separate multiple values in the pipeline symbol. | Yes|Yes |
| order_visibility | Specify the value ‘Yes’ to make the bundled product display in order details. Otherwise, mention the value ‘No’. For specifying multiple values, separate them with a pipeline. | Yes|Yes |
| single_product_price_visibility | Mention ‘Yes’ to display bundled product price on the product details page. Or mention the value ‘No’. | Yes|Yes |
| cart_price_visibility | Specify the value ‘Yes’ in CSV to display the price of the bundled product on the cart/checkout page. Use a pipeline separator to separate multiple values. | Yes|Yes |
| order_price_visibility | Provide the value ‘Yes’ in CSV to make the price of the bundled product visible in order details. | Yes|Yes |
| override_title | Provide value Yes – to override the title of bundled products. | Yes|Yes |
| override_title_value | Specify the text value for override title | T-shirt Blue|T-shirt Black |
| override_description | Give ‘Yes’ if you want to override the description of bundled products | Yes|Yes |
| override_description_value | Provide the text values. | Give a new description to override|Give a new description to override |
| hide_thumbnail | Mention ‘Yes’ to hide the bundled product thumbnails or mention the value ‘No’ in CSV. | Yes|Yes |
| wc_pb_virtual_bundle | Mention ‘Yes’ in CSV to enable virtual for the Product Bundle | Yes |
| wcpb_min_qty_limit | Set the minimum quantity of products that must be chosen for each product to purchase the product bundle | 1 |
| wcpb_max_qty_limit | Set the maximum quantity of products that must be chosen for each product to purchase the product bundle | 3 |
Other Links #
WP Ultimate CSV Importer Pro #
Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.
