Import simple products

To import products you need a CSV file containing you products. You should have checked the settings and created a header in advance. Below you can find a comprehensive list of fields you can import. The titles are build like this: Title – post_title which mean name in backend – name in the importer

Product body

product body
ID
This is the unique identifier of your product in the database. If the ID is present it will be used when merging is enabled to update! If you are not sure, DO NOT USE IT!

Permalink – post_name
This is the permalink of your product. Be careful to set this your self. Only use this if you know what you are doing. If you use this wrong, your product might not in search results or on the archive page. If you fill in the post_title, a post name will be created for you.

Title – post_title
The title of your product. It is mandatory in many cases.

Description – post_content
The description of your product

Product short description – post_excerpt
The short description of your product

Status – post_status
The status of your product. Values are: publish, pending, draft, private, trash

Catalog visibility – visibility
Determines if your product is visible or not and where. Values: visible, catalog, search, hidden

Product data – general

product data - general

SKU – sku
This is the unique identifier of your product. If a SKU is present it will be used to update!

Regular price – regular_price
The regular price of your product.

Sale price – sale_price
The sale price of your product. If you have a regular and a sale price filled in. You get a strike through and a badge on your product that it is for sale.

Sale price dates
Sale price dates gives you a date range when the product is on sale.
From date field: sale_price_dates_from ( format YYYYMMDD)
To date field: sale_price_dates_to ( format YYYYMMDD)
To import sale price dates, you need this add-on Import downloadable, external, grouped products

Tax status – tax_status
If your products are taxable and whether tax is applied to the shipping amount or not.taxable, shipping, none.

Tax class – tax_class
Tax Classes are assigned to your products. In most cases you will want to use the default “standard” class. If however you sell goods which require a different tax class (for example Tax except zero-rated products) you can add the classes here. Predefined values by woocommerce: zero-rate, reduced-rate, or leave it empty to use the standard class or use the slug of your own created ones. In some cases you want to have “same as parent” this can be accomplished with the value parent

Virtual
A product is virtual if it is not shipped. Values: yes, no
To import this field, you need this add-on Import downloadable, external, grouped products

Downloadable
Downloadable products are products that give you access to a file. Values: yes, no
To import downloadble products, you need this add-on Import downloadable, external, grouped products

Product data – inventory

product data - inventory

Manage stock – manage_stock
To enable or disable stock management. Values: yes, no

Stock quantity – stock
The amount of stock you have.

Allowed Backorders – backorders
If backorders are allowed, stock can be go negative. If notify is selected, the customer will also be notified of this. Values: yes, no, notify

Stock status – stock_status
The stock status of your product in the frontend. You have to set it yourself if you want this. Values: instock, outofstock

Sold Individually – sold_individually
Enable this to only allow one of this item to be bought in a single order. Values: yes, no
To import this field, you need this add-on Import downloadable, external, grouped products

Product data – Shipping

product data - shipping

Weight (kg) – weight
The weight of the product.

Dimensions (cm) – length,width,height
The dimensions of the product.

Shipping Class – shipping_class
The shipping classes are used by certain shipping methodes to group products. If the shipping class does not exists, it will be created for you. If you use existing and it fails to link, use the slug of your shipping class.

Product data – linked products

product data - linked products

Upsells – upsell_ids
Up-sells are products which you recommend instead of the currently viewed product. You can add them as a pipe separated list of sku’s. Example: sku1|sku2|sku3
To import this field, you need this add-on Import downloadable, external, grouped products

Crossells – crossell_ids
Cross-sells are products which you promote in the cart, based on the current product. You can add them as a pipe separated list of sku’s. Example: sku1|sku2|sku3
To import this field, you need this add-on Import downloadable, external, grouped products

Product data – Attributes

product data - attributes
Attributes can be divided in 2 kinds. One that is used for variations and one that is used for regular use. They can not be both. Variations are products like t-shirts, they come in different sizes and colors. The size and color are variation attributes. To import regular attributes you can use the import attributes add-on. If you want to import variable products ( and there attributes ) you need the import variable products add-on.

Product data – Advanced

product data - advanced

Purchase note – purchase_note
an optional note to send the customer after purchase.

Menu order – menu_order
Custom ordering position for this item.

Enable Reviews
Enable/Disable customers reviews for this item. Values: yes,no