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

CSV Improved

Product price import

Requirements:

  • CSVI Pro 5.8+
  • CSVI Free 4.5.2+
  • VirtueMart 2.0.16+
  • Product import

Product prices

A unique product price is made up of several fields:

  • Shopper group
  • Price
  • Currency

All these fields are used by CSVI to identify a price.

Shopper group

The shopper group allows you to show prices to special customer groups. The shopper group field for prices is called shopper_group_name_price and can take the following values:

  • Show the price to a specific shopper group, give the name of the shopper group
    Example: -default-
  • Show the price to everybody
    The asterisk (*) must be used

Price

The price is the price excluding tax that you want to assign to the product

Currency

The currency is the currency for this price. If no currency is specified, CSVI will use the default shop currency.

Sample CSV

This example sets the shopper group to Gold Level and a price of 4.49.

product_sku;product_price;product_currency;shopper_group_name_price
G01;4.49;USD;Gold Level

Change shopper group

To change a shopper group assigned to a price you can use the field shopper_group_name_new. This field takes the same values as the shopper_group_name_price.

Sample CSV

This example changes the shopper group from Gold Level to everybody

product_sku;product_price;product_currency;shopper_group_name_price;shopper_group_name_new
G01;4.49;USD;Gold Level;*

TESTIMONIAL

Perfect order export tool for VirtueMart and more
5 stars
2014-07-31
My customer wanted a VirtueMart order export for Excel and after trying some other extensions, this one was the only one that did the job. I had to filter out some unnecessary Text in the fields, so I used the replacement function. Earlier I used the Free version for simple product import/export, that was fine. The Pro version really has so many functions, you can adjust everything according to your needs. Really excellent work.

STAY INFORMED


Stay informed with the CSVI newsletter.