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
  • product_price
  • product_price_new

Only required if you use these fields:

  • shopper_group_name
    • This field can be left out or left blank, in this case CSVI will look for the default shopper group.
  • product_currency
    • This field can be left out or blank, CSVI will look for the currency assigned to the vendor.
  • price_quantity_start
    • This field will default to 0.
  • price_quantity_end
    • This field will default to 0.

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

Great component and support.
5 stars
2014-06-24
Component and well done with many configurations, it leaves a wide selection of management.
You can configure different Template Import and manage well many objects in ViertueMart.
Great support, clear and fast.
Compliments.

STAY INFORMED


Stay informed with the CSVI newsletter.