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
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
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.
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
Log in to reply to this topic.