Lost password?    Lost username?    Create an account
OverviewDownloadsForumSupport
CSV Improved

CSV Improved

Import VirtueMart 2 prices

Requirements

  • CSVI Pro 5.8+
  • VirtueMart 2.0.10+
  • Price import

Required fields

To import multiple prices the following fields are required:

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

product_sku

This is the unique identifier for a product

shopper_group_name

Set the shopper group the price belongs to. Use * (asterisk) to assign a price to all shopper groups.

product_price

The product price excluding tax

product_currency

The product currency

price_quantity_start

The minimum number of products that need to be bought to apply for this price

price_quantity_end

The maximum number of products that need to be bought to apply for this price

Example

Price brackets

"product_sku";"shopper_group_name";"product_currency";"price_quantity_start";"price_quantity_end";"product_price"
"H01";"-default-";"EUR";"1";"10";"20"
"H01";"-default-";"EUR";"11";"21";"18"

Different shopper groups

"product_sku";"shopper_group_name";"product_currency";"price_quantity_start";"price_quantity_end";"product_price"
"H01";"-default-";"EUR";"0";"0";"20"
"H01";"Gold Level";"EUR";"0";"0";"18"

Change a shopper group

To change a shopper group for a price the following fields are required:

  • product_sku
  • shopper_group_name
  • shopper_group_name_new
  • product_price
  • product_currency
  • price_quantity_start
  • price_quantity_end

The fields are the same as when a price gets added but with the extra field shopper_group_name_new. The shopper_group_name_new is the name of the new shopper group, use * (asterisk) to assign a price to all shopper groups.

Example

Update a shopper group

"product_sku";"shopper_group_name";"shopper_group_name_new";"product_currency";"price_quantity_start";"price_quantity_end";"product_price"
"H01";"-default-";"Gold Level";"EUR";"1";"10";"20"
"H01";"-default-";"Gold Level";"EUR";"11";"21";"18"
"H01";"Gold Level";"*";"EUR";"0";"0";"18"

Change a price

To change a price the following fields are required:

  • product_sku
  • shopper_group_name
  • product_price
  • product_price_new
  • product_currency

Only required if you use these fields:

  • price_quantity_start
  • price_quantity_end

The fields are the same as when a price gets added but with the extra field product_price_new. The product_price_new is the new price.

Example

Update a price

"product_sku";"shopper_group_name";"product_currency";"price_quantity_start";"price_quantity_end";"product_price";"product_price_new"
"H01";"-default-";"EUR";"1";"10";"20";"22.50"
"H01";"-default-";"EUR";"11";"21";"18";"19,50"
"H01";"Gold Level";"EUR";"0";"0";"18";"19"

Delete a price

To delete a price the following fields are required:

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

The fields are the same as when a price gets added but with the extra field price_delete to indicate the price needs to be deleted.

Example

Delete a price

"product_sku";"shopper_group_name";"product_currency";"price_quantity_start";"price_quantity_end";"product_price";"price_delete"
"H01";"-default-";"EUR";"1";"10";"20";"Y"
"H01";"Gold Level";"EUR";"0";"0";"18";"Y"

TESTIMONIAL

Amaizing product
5 stars
2013-11-25
Using this product made my life better. Amazing product. Even greater support received on the product "issues". It has no issues as far as i am concerned, i just need some guidance and received it. With out this product i cannot even imagine my website existing right now. Thank you for this great product.

STAY INFORMED


Stay informed with the CSVI newsletter.