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

A life saving extension
5 stars
2012-10-31
Working on a conversion site from an old CMS to Joomla, I needed a solution that would import the old users, plus, set them up with correct subscriptions within Akeeba Subscriptions.

A quick pre-sales email to Roland and he said he would be happy to add the features that I needed, but it might take a few weeks. All good, I can wait, it was ready the next day!!

A session with Roland in Skype and any minor issues were sorted and now I can easily import over 2000 users with active subscriptions, saving me who knows how much time in the process.

Roland is one of the true professionals of the extension community and if you are looking for a solution, then you have found it and more!!

Awesome stuff!

STAY INFORMED


Stay informed with the CSVI newsletter.