Prices by User Role CSV import: overview

With Prices by User Role import products feature you can import Simple, Virtual, Downloadable, External and Variable products from CSV. You can import CSV files with free structure, without header or with dummy columns names, and custom separators. Plugin will automatically determine appropriate WooCommerce product fields to map CSV columns or you will be able to do this manually.

Prices by User Role import CSV hasn’t strict requirements to import file fields. When creating new products, you definitely will include the fields to maximally describe them: name, description, category, feature image, price, SKU, stock, product type, visibility, etc. You will get product created having minimum details in the file, though you should always care about informative product catalog and enrich it with all necessary specifications.

When your Prices by User Role import is dedicated to product renewing, you do not need to import all the related details, only product identifier and fields to be updated, for example SKU (identifier), price and description.

The file uploads the next data:

• Images via a URL (Requires allow_url_fopen or cURL on your server)

• Featured Image

• Attributes, categories and tags with hierarchical (Add new one if they don’t exist)

• Import Custom Fields

• Map any CSV column to any Product field

• If you include a header row, the plugin will attempt to map column values to product fields automatically.

• Validationfor 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.

• If SKU already exists and importing images, will skip duplicate image imports.

• Locale settings are supported to better handle importing files with special characters and other alphabets.

Note if you are importing variable products: 

• Make sure you include Parent SKU in CSV file, otherwise, products will be added as simple products and attribute won’t be created;
• Map the column with attribute variations to Custom Field and enter the name of attribute if there is no Header in your file;
• Check Use for variations under Custom Field to create product variations automatically

Also please view samples of CSV file (attached) 

You may be interested in:

How to export WooCommerce products

CSV Import: Step by Step Tutorial