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

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 Retailers

Ultimate CSV Importer plugin lets you to upload a CSV file containing product retailer’s details on your website. Prepare the CSV file in the table format listed below. Click here for a Sample CSV

WP Fields Description & CSV Values CSV Sample Value
wc_product_retailers_retailer_only_purchase Specify whether you want to allow the purchase from listed retailers or not
yes – enable
no – disable
yes
no
wc_product_retailers _use_buttons Specify whether you want to use buttons rather than drop down for multiple retailers or not
yes – enable
no – disable
yes
no
wc_product_retailers_product_ button_text Provide the purchase button text Add to cart
wc_product_retailers_catalog_button_text Provide the catalog button text Buy Now
wc_product_ retailers_id Specify the retailers id to add retailers to this product. Multiple retailers id can be separated by pipeline ( | ) 12
16|24
(existing retailer’s id)
wc_product_ retailers_price Specify the product price for retailers 2500
3400|5530
wc_product_retailers_url Specify the retailer’s url. Multiple url are separated by pipeline ( | ) https://www.smackcoders.com

Addons 7: WooCommerce Product Add-ons

Product add-ons allow you to create various products in different formats. Product details include radio buttons, check box, and so on. You can upload 1000’s product details as a CSV file and import it into WP ultimate CSV importer for easy updates. Click here to get the Sample CSV

WP Fields Description & CSV Values CSV Sample Value
product_addons_exclude_global Specify whether to exclude the product from global addons or not
1 – enable
0 – disable
1
product_addons_group_name Specify the group name in text form. Multiple groups are separated by pipeline (|) Product group1
Product group2|Product group3
product_addons_group_description Specify the description for each group This is first group
This is second group|This is third group
product_addons_type Specify addon type for each group
checkbox
radio button
select
custom_textarea
file_upload
custom_price
custom_multiplier
custom
radiobutton|custom_textarea
product_addons_position Specify the product addons position in numerical value. Multiple values are separated by pipeline( | ) 0
0|1
product_addons_required Specify whether the addon is required
1 – enable
0 – disable
1
0|1
product_addons_label_name Specify the label name for each group. Multiple label name are separated by pipeline ( | ) label1
label2|label3
product_addons_price Specify the price for each labelin numerical form Specify the price for each label
product_addons_minimum Specify the minimum price in your csv 5000

Addons 8: WooCommerce Returns & Warranty Requests

Ultimate CSV importer lets you import warranty requests and returns data. The CSV file data format includes the details that are listed below in the table. Click on Sample CSV to download Returns and warranty request CSV file.

WP Fields Description & CSV Values CSV Sample Value
warranty_label Specify the warranty label i.e. name for your warranty Product warranty
warranty_type Specify the warranty type. If you don’t provide warranty for your product, specify the value as no warranty in csv and left the below fields as blank.
no warranty
addon_warranty
included_warranty
addon_warranty
warranty_length Provide the warranty length, if your option is included warranty in warranty type else left bank
lifetime
limited
lifetime
warranty_value Specify the value of duration in numerical form, if your option is limited in warranty length 30
warranty_duration Specify the duration
days / weeks / months / years
days
warranty_addons_amount Provide the addons amount in numerical form, if your option is add on warranty in warranty type else left blank. Multiple values are separated by pipeline ( | ) 4567
8765|2659
warranty_addons_value Specify the addon value in numerical form 20
2|10
warranty_addons_duration Specify the duration
days / weeks months / years
weeks
warranty_addons_option Specify the value if you don’t want to provide warranty for addons
yes – enable
no – disable
yes
no

Addons 9: WooCommerce Pre Orders

The pre-order add-ons helps the customers to check their product details before purchase. Click here to get the Sample CSV file.

WP Fields Description & CSV Values CSV Sample Value
preorders_enabled Specify the pre orders for this product
yes – enable
no – disable
yes
no
preorders_fee Specify the fee to be charged when the pre-order is placed or left blank in numerical form 450
preorders_when_to_charge Specify when to add the pre-order charge
upon_release
upfront
upfront
preorders_availability_datetime Specify the available date and time of pre-order
mm/dd/yy
h:m
10/23/14
10:30

Other Links

  • How to Import WooCommerce Products into WP CSV Importer Read More
  • A-Z WooCommerce Data Import Read More
  • Importing Woocommerce Product with Variation, categories and More Read More
Cookies help us deliver our services. By using our services, you agree to our use of cookies.