Author Topic: Dynamic discounted category  (Read 753 times)

andorfy

  • Beginner
  • *
  • Posts: 5
Dynamic discounted category
« on: November 26, 2020, 00:30:42 am »
Hello,

Is there a way to set up a category where all discounted products automatically show up if they are discounted somehow?
In our shop, we use price override for some products, and sometimes rules in the Taxes & Calculation Rules menu, so it is a lot of work to always put in and get out the discounted products to/from a category.

Joomla: 3.9.23
Virtuemart: 3.8.6 10373
PHP: 7.3.6

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28154
  • Always on vacation
    • Jenkin Hill Internet
Re: Dynamic discounted category
« Reply #1 on: November 26, 2020, 11:17:55 am »
Set up a category "Discounted" or similar, but do not publish it. When setting discount on a product add that product to your new category (as well as it's existing category).  Then you can filter by discounted category in the backend to see those which have any type of discount.

If you want to show all discounted products in the frontend then publish that category.
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

andorfy

  • Beginner
  • *
  • Posts: 5
Re: Dynamic discounted category
« Reply #2 on: November 26, 2020, 12:01:27 pm »
That's the way we do it now if we set a price override directly in the product.
But if we set a rule in Taxes & Calculation Rules it is way more work to add every product which is affected, and this is what I would like to automatize. And if we set a time-limited discount it is easy with the rules, but it really a pain to add the products one-by-one to the category when the discounts start and remove them when it ended.

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28154
  • Always on vacation
    • Jenkin Hill Internet
Re: Dynamic discounted category
« Reply #3 on: November 26, 2020, 12:16:44 pm »
You can use tax rules per category for applying discounts, too. When setting up a new store most users don't think about what may be needed in the future to hopefully avoid an issue like you now have. Some smart person can probably write code to extract your required detail from the database.
I don't know of any simple way to do it.
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

andorfy

  • Beginner
  • *
  • Posts: 5
Re: Dynamic discounted category
« Reply #4 on: November 26, 2020, 18:02:12 pm »
Thank you jenkinhill. Hope someone has other advice or can suggest an extension.