VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product pricing => Topic started by: sirius on October 05, 2020, 12:19:12 PM

Title: Extend the tax rules we create from month to month
Post by: sirius on October 05, 2020, 12:19:12 PM
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 ?
Title: Re: Extend the tax rules we create from month to month
Post by: pinochico on October 05, 2020, 12:58:57 PM
Simply solutions:

1. Use: https://adidac.github.io/jmm/
2. Save your sql as template
3. Every month call your sql from admin.
Title: Re: Extend the tax rules we create from month to month
Post by: sirius on October 05, 2020, 15:24:32 PM
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
Title: Re: Extend the tax rules we create from month to month
Post by: jenkinhill on October 05, 2020, 16:10:50 PM
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.
Title: Re: Extend the tax rules we create from month to month
Post by: sirius on October 07, 2020, 19:40:58 PM
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.
Title: Re: Extend the tax rules we create from month to month
Post by: jenkinhill on October 08, 2020, 12:05:58 PM
Data can be added directly into the ###_virtuemart_product_prices table in the database if necessary
Title: Re: Extend the tax rules we create from month to month
Post by: pinochico on October 08, 2020, 12:14:44 PM
QuoteData can be added directly into the ###_virtuemart_product_prices table in the database if necessary

of course with jmm definitelly :)
Title: Re: Extend the tax rules we create from month to month
Post by: sirius on January 13, 2021, 21:10:17 PM
Finally, the component I was looking for does exist.  ;D

VM Scheduled Discounts (https://extensions.joomla.org/extension/extension-specific/virtuemart-extensions/vm-scheduled-discounts/)

QuoteVM 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
Title: Re: Extend the tax rules we create from month to month
Post by: pinochico on January 13, 2021, 22:15:19 PM
Only for all products without exceptions?
Title: Re: Extend the tax rules we create from month to month
Post by: sirius on January 13, 2021, 22:26:50 PM
Quote from: pinochico on January 13, 2021, 22:15:19 PM
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.
Title: Re: Extend the tax rules we create from month to month
Post by: pinochico on January 14, 2021, 08:42:47 AM
great :)