1. WatchCasa
  2. RO CSVI
  3. Friday, 23 October 2015
  4.  Subscribe via email
Hello,

Is any way to update only the product_override_price without having the field product_price;

I have a template with this fields product_sku,product_override_price,published,product_in_stock but when i am uploading the file is creating new price with product_override_price and the product price is null.

In all products i have product_override_price

I am sending the log
Accepted Answer Pending Moderation
Hello,

Is any way to update only the product_override_price without having the field product_price;
This is not possible because CSVI won't have any idea which price to update.

The only way around it is to use the Custom table import routine. You would create a template for the virtuemart_product_prices table. You will have all the fields for this table available for import. Using the virtuemart_product_price_id field you can directly update the override price for that particular price. You can use the VirtueMart price export to get the info of this table such as product_sku so you know which virtuemart_product_price_id belongs to which product.
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
Accepted Answer Pending Moderation
I managed this by simply modifying the template for price export. These are the fields i set up for the template:
product_sku product_price product_override_price

After exporting with these fields, i filled the table product_override_price with "new" prices for an override price.

Finally i imported this CSV back into CSVI. And now the "new" override prices are shown.

See attached file for the fields and an example.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Thank you for reporting your solution.
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. # 3
  • Page :
  • 1


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