Multiple prices import is used for adding extra prices to a product. Multiple prices can be added for specific shopper groups or for certain quantities.

There are 7 fields that are dealing with multiple prices. These are:

• product_sku
• product_price
• product_currency
• price_quantity_start
• price_quantity_end
• shopper_group_name
• price_delete

The product SKU is used to identify the product for which the files are added. This field is always needed otherwise the system does not know to which product the files belong.

The product price is the price for the product without tax.

The currency used for this price.

Price quantity is used to sell a product at different rates depending on how many products a customer is buying. The price_quantity_start determines from which number of products this price is charged. The price_quantity_end determines when this price is no longer applicable.

Each shopper group can have their own prices. By specifying the shopper group name the price is assigned to this shopper group otherwise it is assigned to the default shopper group.

Using the multiple prices import it is also possible to delete prices. A price is deleted when the following fields in the CSV file match the data in the database:

• product_sku
• product_price
• product_currency
• price_quantity_start
• price_quantity_end

These fields and the price_delete column are required to delete a price. Prices get only deleted when the price_delete column is set to Y.

~product_sku~^~product_price~^~product_currency~^~price_quantity_start~^~price_quantity_end~^~shopper_group_name~^~price_delete~
~Wb1~^423^~USD~^10^20^~-default-~^~N~
~Wb2~^424^~USD~^10^20^~-default-~^~N~
~Wb3~^425^~USD~^10^20^~-default-~^~N~
~Wb1~^426^~USD~^21^30^~-default-~^~N~
~Wb2~^427^~USD~^21^30^~-default-~^~N~
~Wb3~^428^~USD~^21^30^~-default-~^~N~
~Wb1~^429^~USD~^31^40^~-default-~^~Y~
~Wb2~^430^~USD~^31^40^~-default-~^~Y~
~Wb3~^431^~USD~^31^40^~-default-~^~Y~