1. Anonymous User
  2. RO CSVI
  3. Tuesday, 15 June 2021
  4.  Subscribe via email
Hi,
I've tested the price import for Virtuemart, it works ok.
but I am a little bored by the principle of operation of the addition of the price because by default a new price is created but with "All Default Rules applied" on the price.

What I need is to choose is to have the "Tax(s) applied" rule set to "Apply default rules"
And for the "Applicable rule(s)" on the price (second drop-down) need to set it to "No rule"
Same for the customer group, I need only "Available for everything"

Is there a way to do that, wouldn't it be those options in the product_price template field ?

Actually I expected the price update to be done simply by a value update.
For example in the case of a single price I do it like this (as you already know for sure) :D :

UPDATE #__virtuemart_product_prices
LEFT JOIN #__virtuemart_products
ON #__virtuemart_product_prices.virtuemart_product_id =
#__virtuemart_products.virtuemart_product_id
SET product_price = 'THEPRICE'
WHERE #__virtuemart_products.product_sku = 'THEPRODUCTSKU';


So if you have an advice, thanks !
Regards
Accepted Answer Pending Moderation
Hello,
but I am a little bored by the principle of operation of the addition of the price because by default a new price is created but with "All Default Rules applied" on the price.

As you mentioned, that is the default value. When there is no value set in import file, RO CSVI sets new price to default values.

What I need is to choose is to have the "Tax(s) applied" rule set to "Apply default rules"
And for the "Applicable rule(s)" on the price (second drop-down) need to set it to "No rule"
Same for the customer group, I need only "Available for everything"

Is there a way to do that, wouldn't it be those options in the product_price template field ?

For setting "Apply default rules" you need to use product_tax_id field set to 0 and for "No rule" you need to set product_discount_id to value -1. For setting customer group to "Available for everything" set value to *. You can add these fields as template fields in VirtueMart price import template and set these values as Default value. Won't that be easier instead of having them as options?

Actually I expected the price update to be done simply by a value update.

That simple price update is still possible with one single price. Problem comes when RO CSVI has to update a price from multiple prices for a product. In this case, to select which price to update RO CSVI needs few fields to select the price from database. With these fields RO CSVI checks if the price exists so to update else inserts a new price.
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. # 1
Accepted Answer Pending Moderation
Thanks for reply

ok understood, I will set up all of this like you told.

And yes I suspected the answer regarding multiple prices.;)

Best regards
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
It's now fine thanks with prices update
Thanks
  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!