How to Import WooCommerce CSV Products File?

Mass import hundreds, even thousands of Products into your WooCommerce store with the CSV Import suite. CSV Import suite lets you import all types of products, even product variations!

This user-friendly importer, with clear step-by-step instructions helps you import Categories, Tags, Products and other Product details into WooCommerce.

Simple Woocommerce CSV Loader:

• A simple, CSV product loader for WooCommerce.
• Supports importing hundreds or thousands of products at once. (The only limit is your patience!)
• Loads images via URL or local file path. (Now detects and skips duplicate images!)
• Loads hierarchical category structures (see Importing Hierarchical Categories below.)
• Lots of other great features suggested by plugin users (see Cool Stuff It/You Can Do and Full List of Importable Attributes below.)

Simple Woocommerce CSV Importer

 

Cool Stuff It/You Can Do

• AJAXy Importing (avoids timing out on large data sets)
• Load Images via a URL (Requires allow_url_fopen or cURL on your server)
• Set Featured Image
• Load Categories and Tags (Categories and Tags are created if they don’t exist)
• Add Categories and Tags to Products by Category/Tag Name or ID.
• Load Custom Fields
• Set Visibility on Custom Fields
• Map any CSV column to any Product field (No header row required, but if you happened to include one, I’ll use it to take a stab at what goes where)
• Map multiple CSV columns to one Product field (last non-empty column wins, good for merging columns)
• Basic validation for multiple-choice fields (fields with a limited set of valid values like yes/no, instock/outofstock, etc.)
• Dollar signs, commas, etc. are stripped out of number fields like prices, weight, length, width, height
• If SKU already exists, existing product is updated rather than inserting new product.

Loadable Product Types

• Simple Products
• Virtual Products
• Downloadable Products
• External Products

Full List of Loadable Attributes

• post_title (Name)
• post_content (Description)
• post_excerpt (Short Description)
• _price (Price)
• _sale_price (Sale Price)
• _tax_status (Tax Status)
• _tax_class (Tax Class)
• _visibility (Visibility)
• _featured (Featured)
• _weight (Weight)
• _length (Length)
• _width (Width)
• _height (Height)
• _sku (SKU)
• _downloadable (Downloadable)
• _virtual (Virtual)
• _stock (Stock)
• _stock_status (Stock Status)
• _backorders (Backorders)
• _manage_stock (Manage Stock)
• product_cat (Categories, by Name or ID)
• product_tag (Tags, by Name or ID)
• Custom Fields
• Product Images (By URL or Local File Path)
• _button_text (Button Text, for External Products)
• _product_url (Product URL, for External Products)
• _file_path (File Path, for Downloadable Product)
• _download_expiry (Download Expiration, in Days)
• _download_limit (Download Limit, an integer)

Download it from WordPress.org : Simple Woocommerce CSV Loader