Categories
View Replies (1)

Resolved Updating pricing only question

  1. anthony352
    anthony352
  2. RO CSVI
  3. Saturday, 05 March 2016
  4.  Subscribe via email
I have several hundred products in my virtuemart shop and just want to update pricing from an excel spreadsheet.
Would the steps be to create a pricing column in spreadsheet with proper template id header, and product sku or product name to show what item the price change is for?

I dont want the import to try and create all new products, but to simply update existing products in shop already.

Thank you for any confirmation on this.
0
Responses (1)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Assuming you are using one price per product you can use the product import to update prices. All you need is the product_sku and product_price field. These are the basics. If you do use more price settings you will need to add these fields as well to find the correct price. Such fields are price_quantity_start and price_quantity_end for example.

To not create any new products, in your template, set the option Skip new items to Yes. To find this option, click on the Advanced button first.

If you are unsure, it may be best to try with 1 product first.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!