Knowledge Base

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 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:

  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 ProductsWooCommerce Attribute and VariationsWooCommerce Orders
CouponRefund 

To know how to import, update and Schedule your import please refer the link. You can get your WooCommerce Products Import Sample CSV here and the complete detail about your WooCommerce field values below.

CSV Samples of distinct fields #

WooCommerce FieldsDescription & CSV ValuesCSV Sample Value
visibilitySpecify the product visibility
1 – visible
2 – catalog
3 – search
4 – hidden
1
tax_statusSpecify the tax status value
1 – taxable
2 – shipping
3 – none
1
tax_classSpecify the tax class value
1 – standard
2 – reduced rate
3 – zero rate
1
product_attribute_nameSpecify product attribute name. Multiple values are separated by pipeline ( | )Red|Blue
product_attribute_valueSpecify 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_visibleSpecify whether the product attribute to be visible or not
1 – visible
0 – not visible
Multiple values are separated by pipeline (|)
1|0
stock_statusSpecify the status of stock quantity
1 – In stock
2 – Out of stock
1
virtualSpecify whether the product to be virtual
yes – enable
no – disable
yes
no
backordersSpecify the value for backorders
1 – No
2 – Notify
3 – Yes
1
Upsell_ids crosssell_idsSpecify the product id that you want to upsell or crosssell. Multiple are separated by comma ( , )45,15,23
product_shipping_classEnter the name of the shipping class to assign for your productbulky
product_typeProvide the value,
1- simple
2- grouped
3- external
4- variable
5- subscription
6- variable-subscription
7- bundle
1
stock_qtyEnter the quantity of the stock in numeric values.12
downloadable_filesMention 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 FieldsDescription & CSV ValuesCSV Sample Value
taxonomiesenter the category name or id and provide multiple category values in comma or pipeline separator167,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 FieldsDescription & CSV ValuesCSV Sample Value
manage_stockSpecify the values
Whether to manage the stock or not
yes – enable
no – disable
yes no
sold_individuallySpecify the value whether the product to be sold individually or not
yes – enable
no – disable
yes no
product_tagSpecify the product tag
Multiple tags are separated by comma(,)
Tag1, Tag2
Product_attribute_variationSpecify the product attribute variation. Multiple values are separated by pipeline ( | )
1 – enable
0 – disable
1|1
downloadableSpecify whether the product to be downloadable or not
yes – enable
no – disable
yes
no
custom_attributesSpecify 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_attributesSpecify the default value of the attribute. Used only by variable productsvalue1
regular_price sale_priceSpecify the price of your variation in floating point values. Multiple values are separated by comma10.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 FieldsDescription & CSV valuesCSV Sample Value
subscription_priceSpecify the price for subscription renewal in numerical form99
subscription_signup_feeSpecify the sign up fee for subscription in numerical form999
subscription_periodSpecify the time interval for subscription
day / week / month / year
week
subscription_period_intervalSpecify the no. of intervals between each renewal payment in numerical form2
subscription_trial_periodSpecify the time interval for the subscription trial
day / week / month / year
day
subscription_trial_lengthSpecify the no. of time interval for the  subscription trial in numerical form5
subscription_lengthSpecify the no. of times the subscriptions renewed in numerical form
0 –  For subscriptions that do not expire
0
subscription_payment_sync_dateSpecify the synchronised subscriptions for day of the month as 1-27 (day) in numerical form3
subscription_one_time_shippingSpecify 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 FieldsDescription & CSV ValuesCSV Sample Value
order_statusSpecify the status for each order
completed
cancelled refunded
on hold
awaiting payment
Processing
pending
pending
order_totalSpecify the order total which includes Cart & Order discount, Shipping tax365

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.

WP FieldsDescription & CSV ValuesCSV Sample Value
individual_useSpecify 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_itemsSpecify 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_amountSpecify the coupon amount in decimal form without thousand separators and currency symbols34.896
discount_typeMention 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 FieldsDescription & CSV ValuesCSV Sample Value
chained_product_detailSpecify 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_stockSpecify 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 FieldsDescription & CSV ValuesCSV Sample Value
product_bundle_itemsMention the ids of each product to be bundled. Separate each product ids with the pipeline separator.6950|6946
layoutMention the value of the layout.Eg: Standard (or) Tabular (or) Grid.Tabular
form_locationUse form locations to align each product in a bundle. You can add either value ‘Default’ or ‘Before Tabs’.Before Tabs
item_groupingMention the text value for item grouping. You can add values like Grouped, or Flat, or None.Flat
edit_in_cartEnable 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_priceSpecify the actual price of the product bundle in numbers.70
pb_sale_priceSpecify the sale price of the product bundle in numbers.60
optionalMention 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_minSpecify the minimum quantity for the bundled product. You can separate multiple values in the pipeline separator.1|1
quantity_maxSpecify the maximum quantity for the bundled product. Separate multiple values with pipeline separator.3|4
priced_individuallyMention 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
discountMention the discount value for each product in the bundle. Separate multiple values with pipeline separator.5|10
single_product_visibilitySpecify 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_visibilitySpecify 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_visibilitySpecify 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_visibilityMention ‘Yes’ to display bundled product price on the product details page. Or mention the value ‘No’.Yes|Yes
cart_price_visibilitySpecify 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_visibilityProvide the value ‘Yes’ in CSV to make the price of the bundled product visible in order details.Yes|Yes
override_titleProvide value Yes – to override the title of bundled products.Yes|Yes
override_title_valueSpecify the text value for override titleT-shirt Blue|T-shirt Black
override_descriptionGive ‘Yes’ if you want to override the description of bundled productsYes|Yes
override_description_valueProvide the text values.Give a new description to override|Give a new description to override
hide_thumbnailMention ‘Yes’ to hide the bundled product thumbnails or mention the value ‘No’ in CSV.Yes|Yes
wc_pb_virtual_bundleMention ‘Yes’ in CSV to enable virtual for the Product BundleYes
wcpb_min_qty_limitSet the minimum quantity of products that must be chosen for each product to purchase the product bundle1
wcpb_max_qty_limitSet the maximum quantity of products that must be chosen for each product to purchase the product bundle3
WP Ultimate CSV Importer Pro

WP Ultimate CSV Importer Pro #

Get Ultimate CSV/XML Importer to import data on WordPress faster, quicker and safer.