WooCommerce CSV Import

WP Ultimate CSV Importer is an importer and exporter tool, allowing you to import your WooCommerce data into WordPress in CSV/ XML. 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:

  1. WooCommerce Variations
  2. Woocommerce Subscriptions Product
  3. WooCommerce Orders
  4. WooCommerce Coupons
  5. WooCommerce Chained Products
  6. WooCommerce Product Retailers
  7. WooCommerce Product Add-ons
  8. WooCommerce Returns and Warranty Request
  9. 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 taxonomies (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 lets you 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