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

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.