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

Excellent Component, features & support
5 stars
2013-08-06
I have used the full/pro versions of CSVI for a few years now & I would recommend it to anybody with a virtuemart site or site where you may need to import anything else.
Not only does it work brilliantly for Virtuemart Stores, but there are also other standard templates for AWO EZ Reality, K2 AUP, Joomla Articles, Users and lots more.
If its not already set up, you can also use the custom field settings & the developer Roland is always on hand providing excellent support and solutions to your CSV related problems.

Roland has helped me out on many occasions with basic CSV stuff and more complicated bespoke CSVi templates.

It's awesome - Really & will save you hours manually inputting products, articles, coupons, etc.

Try the free version & if you like it buy the Pro version as it's easily worth the price you pay.

STAY INFORMED


Stay informed with the CSVI newsletter.