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

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

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 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 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. Click here for sample CSV.

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

Mention 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

Other Links

Cookies help us deliver our services. By using our services, you agree to our use of cookies.