Extend the tax rules we create from month to month

[sirius]

Hi all 

It would be really handy to have the option to extend the tax rules we create from month to month.
Indeed if I use a date range directly on the product to apply a discount, once the date has expired, the product changes to "Price on request", which does not suit me at all.

So I use the tax rules and apply the desired rule to the product concerned. That way once the date has expired, the price simply returns to normal.
But changing the dates of all the rules suddenly becomes very laborious when you manage a lot of promotions.

Even if I use phpmyadmin to go faster, it would be really useful to have an option which allows the dates to be carried over automatically to the next month, so on the rule setting page.
Something like "Repeat every month" or even with "Repeat X months" or "Repeat until month of: XX".

Thanks for advice, and what's your opinion on this ?
Perhaps some use other ways to do this ?

[pinochico]

Simply solutions:

1. Use: https://adidac.github.io/jmm/
2. Save your sql as template
3. Every month call your sql from admin.

[sirius]

Thanks a lot 

will try this.

But this apart the option that I'm talking about should be implemented in VM IMHO
(you can't even change the dates via a calendar in the list of taxes page, which means you have to enter each edition.)

regards

[jenkinhill]

I don't creae a tax rule. I add a new (second) price for a product and select the dates to start and finish at that price. Note that you do have to save the new price before you can set the date range.  The new price will be displayed between those dates and then will revert to the normal price once the expiry date is passed.

[sirius]

Thanks jenkinhill,

good point, I could try this method too, but would be a huge work to update all the dates with lots of products with such date ranges.

[jenkinhill]

Data can be added directly into the ###_virtuemart_product_prices table in the database if necessary

[pinochico]

Data can be added directly into the ###_virtuemart_product_prices table in the database if necessary

of course with jmm definitelly

[sirius]

Finally, the component I was looking for does exist. 

VM Scheduled Discounts

VM Scheduled Discounts is very easy to use. You can set how much you want to discount a product or a whole category, either by percentage, relative amount or exact final price and have the discount published exactly when you want it, with a scheduled that can be set either within specific dates and times, or repeatedly at a weekly, monthly or yearly schedule!
Above all that, VM Scheduled Discounts is the only tool that gives you discounts on a schedule

[pinochico]

Only for all products without exceptions?

[sirius]

Only for all products without exceptions?

Hi pinochico
You think of which products which would not be supported exactly, under which context?
This apart you choose any products from your store yes. Not yet finished all my tests but it's very fine for now.

[pinochico]

great