WooCommerce CSV Column Header Reference

Here is an description of column headers that you will use in your CSV for all product types in WooCommerce.

Main Product File Column Headers

Column Description Accepted values Example
id Assigned by WordPress. N/A N/A
tax:product_type Required. Whether your product is Simple, Grouped, External, or Variable. simple / variable / grouped / external simple
post_id Assigned by WordPress. N/A N/A
post_type By default, this is product. product product
menu_order Use this to sort your products. Numerical 5
post_status Choose whether your post should be published or not. draft / publish / pending / private draft
post_title Required. Name of the product. Text Killer Heels
post_date Date/time from your WordPress admin. You only need to add a date if you don’t want to use the current date. If you’re updating products, leave this as the exported value unless you want to make the product appear more/less recent. mm/dd/yyyy
dd-mm-yyyy
More accepted date formats
01/02/2015
02-01-2015*Both of these are January 2, 2015
post_content Post content, normally a description of the product. Text Super high heels are all the rage. Look beautiful this season with a gorgeous pair of killer heels. Available in 5 colors!
post_excerpt Short description of the product. Text This season’s latest heels!
post_parent Use for grouped products and variations. Enter the ID of the parent product. Note: Variables should be imported in a separate spreadsheet. Post ID 234
post_password If your post is private, include the password. Text !MyAwesomePassw!
visibility Choose visibility for your product.
Learn more about product visibility.
visible / catalog / search / hidden visible
sku Recommended. SKU of the product. Must be unique. Text SH99786
upsell_skus SKU(s) of the product to which you wish to upsell. Text – multiple skus separated by a “|” character. SKU1|SKU2
upsell_ids ID of the product to which you wish to upsell. post ID – multiple IDs separated by a “|” character. 236|569
crosssell_skus SKU(s) of the product with which you wish to crosssell. Text – multiple skus separated by a “|” character. SKU1|SKU2
crosssell_ids ID of the product that can be purchased with this product. post ID – multiple IDs separated by a “|” character. 236|569
featured Whether this product should be featured or not. yes/no yes
downloadable Whether your product is downloadable or not. yes/no no
virtual Whether your item is a non-physical object or not. yes/no no
regular_price Required for all products except variable products.
Normal price of your product.
Float (Decimal number) 99.99
sale_price Sale price of your product, if on sale. Float (Decimal number) 69.99
manage_stock Whether or not you are managing stock for the product. yes/no no
stock Number of this item you have in stock. Can be relative to the value currently configured in the product. Numerical 3
+10
-3
stock_status Whether you have any in stock or not. instock / outofstock instock
backorders Whether you’re accepting backorders. yes/no/ notify yes
weight Weight of your product. Complete if you’re using weight-based shipping rules or a shipping method that pulls rates from an external service.
Use the same measurement unit set for your site.
Numerical 0.73
length Length of your product. Use if you pull rates from an external service, such as USPS.
Use the same measurement unit set for your site.
Numerical 10.5
width Width of your product. Use if you pull rates from an external service, such as USPS.
Use the same measurement unit set for your site.
Numerical 15
height Height of your product. Use if you pull rates from an external service, such as USPS.
Use the same measurement unit setted in your site.
Numerical 8
tax_status Use to determine whether your product is taxable or not. taxable / shipping / none taxable
tax_class Tax class of your product. zero-rate, reduced-rate
Notice that you have to use the slug of the tax class.
Leave blank if the value should be Standard Rate.
reduced-rate
tax:product_shipping_class Product’s shipping class Allows you to set the Shipping Class when uploading a product to your store. Class 1
sale_price_dates_from Date from when your sale price is used. MM DD YYdd MM YY MM” / “DD” / “YYDD” / “MM” / “YY”
More accepted date formats
01/02/2013
sale_price_dates_to Date when your sale ends for this product. MM DD YYdd MM YY MM” / “DD” / “YYDD” / “MM” / “YY”
More accepted date formats
01/04/2013
images Import images. Use a pipe to separate multiple images. Enter the image URL or file name. The importer will look in wp-content/uploads/year/month where year/month are the year and month in which the import is run. The first image is the main product image and will be used for the featured image. Text image1.jpg | image2.jpg | image3.jpg
product_url Use if the product is sold on another site. Used by External/Affiliate products only. URL http://amazon.com/etc
button_text Text that will appear on your “Add to cart” button. Used by External/Affiliate products only. Text Buy on Amazon!
meta:_sold_individually Can the product only be sold on its own? yes/no no
meta:total_sales Total sales for this product. Numerical 56

Variable Product File Column Headers

Column Description Accepted values Example
post_parent Parent product of the variation. This should be that product’s ID. Numerical 273
parent_sku Parent product of the variation. This should be that product’s SKU. Text SH9988
post_status Choose whether the variation should be published or not. draft / publish / pending / private draft
sku Recommended. The SKU of the variation. Must be unique. Text SH99786
downloadable Whether the variation is a downloadable item or not. yes/no no
virtual Whether your item’s variation is a non-physical object or not. yes/no no
regular_price Required for all variations.
Normal price of your variation.
Float (Decimal number) 99.99
sale_price Sale price of your variation, if it’s on sale. Float (Decimal number) 69.99
stock Number of this item’s variation you have in stock. Numerical 3
weight Weight of your variation. Complete if you are using weight based shipping rules, or a shipping method that pulls rates from an external service.
Use the same measurement unit set for your site.
Numerical 0.73
length Length of your variation. Use if you pull rates from an external service, such as USPS.
Use the same measurement unit set for your site.
Numerical 10.5
width Width of your variation. Use if you get rates from an external service such as USPS.
Use the same measurement unit setted in your site.
Numerical 15
height Height of your variation. Use if you get rates from an external service such as USPS.
Use the same measurement unit setted in your site.
Numerical 8
tax_status Use to determine whether your variation is taxable or not. taxable/ shipping/none taxable
Phuket
More
Addresses
Contact Us
Intouch
newsletter
© 2019 Imarketingonly All rights reserved.
  • We will use the data you submit to fulfil your request. Privacy Policy.

Imarketingonly

The Great Oast, Steep Marsh Petersfield Hampshire GU32 2BN
125/5A Srisoonthorn Road. Cherngtalay District. Thalang Phuket 83110
+66 (0) 76 324184 +66(0) 898 740 040 +44 (0) 1730 895648 +44 (0) 208 1234 164 +44 (0) 7798 554540 Start Price 120 GBP