Categories
View Replies (3)

Resolved No "salesprice" field in import quickadd fields?

  1. konstantinos29
    konstantinos29
  2. RO CSVI
  3. Thursday, 17 November 2022
  4.  Subscribe via email
Hello,

I exported a collection of VM products into a CSV in order to change their prices.
I have the field "salesprice" in the exported file, which I use to set the new prices.

I now try to define an import template and use the quickadd fields dialog, but I do not find "salesprice" in the list.
Can you guess why?
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
salesprice is used only in export. It is not available with import and so you do not see in import template.

To update a price you should be using VirtueMart price import template with fields product_price and product_price_new fields. product_price field holds the old price and product_price_new holds the new price you want to update.
Kind regards,

Tharuna

=========================
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. # Permalink
Responses (3)
konstantinos29
konstantinos29
Accepted Answer Pending Moderation
Thanks!

For the import template, what is the use of product_price? A safety check? i.e. If the old price doesn't match the one in the database then the product will not be updated to the new price?
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
For the import template, what is the use of product_price? A safety check?

That is the actual field which holds the product price.

i.e. If the old price doesn't match the one in the database then the product will not be updated to the new price?

This field along with product_sku field is used to fetch the existing row in database and update the value with product_price_new field.
Kind regards,

Tharuna

=========================
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. # 2
  • Page :
  • 1


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