Are Sequential Products?

[palafirst]

Here's an interesting question that I haven't come across anywhere...

I have a client who want to start a site where people can "Adopt a Tree. We are thinking of doing it in ZenCart as a normal shopping cart. The problem is that they want to have a database of all the trees (with photos and numbers), but they do NOT want the customers to pick the tree...they want the NEXT tree in the list to be available and that is the one that can be adopted and paid for.

Is there a way to have Sequential Products so that after one product is sold that the customer sees just one product (the next one in the list) to be available for purchase?

If this isn't possible in ZenCart does anyone know how it could be done or what software would allow it?

Thanks,
Greg

[gjh42]

It's not something Zen Cart does by default, but ought to be achievable with a bit of custom coding. I think something hooking into th order class after payment is completed and just before the database is updated, to also update the next product id from inactive to active, would take care of it. You would want to make sure that whatever you did directly in the db covered all the actions that doing this in the regular admin page would do. It is probably only one field in one table that needs to be touched.