Feature request: publish up/down products on specified time

[sandomatyas]

There is a great feature in Joomla, where you can publish up/down an article on specified time.
I would appreciate this function in VirtueMart, too.
I would like to build a shop where is a new product on every day. There is a product_available_date field in the #__virtuemart_products talbe but if I set it to the future the product is published but customers can't buy it. It would be great an another datetime field to the publish down time and a flag which tells what would happen when we are out of this timeframe.
Option1: you can see the product but you can't buy it as now. Option2: You can't see the product at all.
Just an idea

[razor7]

There is a great feature in Joomla, where you can publish up/down an article on specified time.
I would appreciate this function in VirtueMart, too.
I would like to build a shop where is a new product on every day. There is a product_available_date field in the #__virtuemart_products talbe but if I set it to the future the product is published but customers can't buy it. It would be great an another datetime field to the publish down time and a flag which tells what would happen when we are out of this timeframe.
Option1: you can see the product but you can't buy it as now. Option2: You can't see the product at all.
Just an idea

Hey! I'm looking for the same feature since 2009, any chance to get this on VM?

Thanks!

[balai]

+1 for that from me

[AH]

Maybe you can use a combination of

Publish up product
and
Pricing dates

Along with additional wording for what to do when price is not available

[pinochico]

1. You can set end date for price
2. You can write custom cli cron and if find product with ended price, you can set product as discontinued
3. You can write custom code for this option for discontinued products:
- see product detail if click on google search link without add to cart and info - product is no more for buing - https://www.kolo-park.cz/obchod/kola-a-elektrokola/elektrokola/horska-elektrokola/celoodpruzena-horska-elektrokola/kellys-theos-f90-29-27-5-720wh-2021-detail
- hidden product from category view
- hidden product from search
- hidden product from virtuemart module
- hidden product from all extensions from Breakdesign (sorry balai
- hidden product from extensions catproducts


We did it ourselves and we can do it for you...

Happy New Year for all.

[Milbo]

It is not completly trivial to add it to the core code. First, what happens with the old publish? Should be only overwritten, if there are dates given? or not? I would say it should be overriden. Next problem, it increases the query time. checking for two dates takes more time, than just checking for a bool. Actually the increased query time is almost nothing using the ibm standard time. But that crashes with the nomal timestamp stuff, which we use anywhere.

so maybe a new option is also needed, so that people have to switch it on, in the vm config.

I think a silvermembership is a reasonable price for such a feature. https://extensions.virtuemart.net/support/virtuemart-supporter-membership-silver-detail

[pinochico]

Milbo,

my solution is perfect for 3d party extension or only one cli cron
is not sure change core VM and add new sql.
In VM are perfect all preparation for this feature
Howg