Author Topic: Extend the tax rules we create from month to month  (Read 2653 times)

sirius

  • Jr. Member
  • **
  • Posts: 132
    • OCTeam
  • VirtueMart Version: 3.8.6
Extend the tax rules we create from month to month
« 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 ?
J3.10.2 | PHP 7.4.24 + APC + Opcode
VM Prod : 3.8.6 | VM Test : 3.8.9

pinochico

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 1243
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: Extend the tax rules we create from month to month
« Reply #1 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.
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates

sirius

  • Jr. Member
  • **
  • Posts: 132
    • OCTeam
  • VirtueMart Version: 3.8.6
Re: Extend the tax rules we create from month to month
« Reply #2 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
J3.10.2 | PHP 7.4.24 + APC + Opcode
VM Prod : 3.8.6 | VM Test : 3.8.9

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28224
  • Always on vacation
    • Jenkin Hill Internet
Re: Extend the tax rules we create from month to month
« Reply #3 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.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 3.8.9.10473 on Joomla 3.9.28 PHP 7.4.14

sirius

  • Jr. Member
  • **
  • Posts: 132
    • OCTeam
  • VirtueMart Version: 3.8.6
Re: Extend the tax rules we create from month to month
« Reply #4 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.
J3.10.2 | PHP 7.4.24 + APC + Opcode
VM Prod : 3.8.6 | VM Test : 3.8.9

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28224
  • Always on vacation
    • Jenkin Hill Internet
Re: Extend the tax rules we create from month to month
« Reply #5 on: October 08, 2020, 12:05:58 pm »
Data can be added directly into the ###_virtuemart_product_prices table in the database if necessary
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 3.8.9.10473 on Joomla 3.9.28 PHP 7.4.14

pinochico

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 1243
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: Extend the tax rules we create from month to month
« Reply #6 on: October 08, 2020, 12:14:44 pm »
Quote
Data can be added directly into the ###_virtuemart_product_prices table in the database if necessary

of course with jmm definitelly :)
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates

sirius

  • Jr. Member
  • **
  • Posts: 132
    • OCTeam
  • VirtueMart Version: 3.8.6
Re: Extend the tax rules we create from month to month
« Reply #7 on: January 13, 2021, 21:10:17 pm »
Finally, the component I was looking for does exist.  ;D

VM Scheduled Discounts

Quote
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
J3.10.2 | PHP 7.4.24 + APC + Opcode
VM Prod : 3.8.6 | VM Test : 3.8.9

pinochico

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 1243
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: Extend the tax rules we create from month to month
« Reply #8 on: January 13, 2021, 22:15:19 pm »
Only for all products without exceptions?
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates

sirius

  • Jr. Member
  • **
  • Posts: 132
    • OCTeam
  • VirtueMart Version: 3.8.6
Re: Extend the tax rules we create from month to month
« Reply #9 on: January 13, 2021, 22:26:50 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.
J3.10.2 | PHP 7.4.24 + APC + Opcode
VM Prod : 3.8.6 | VM Test : 3.8.9

pinochico

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 1243
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: Extend the tax rules we create from month to month
« Reply #10 on: January 14, 2021, 08:42:47 am »
great :)
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates