Stocks instead of state [#1800894]

Hi,
First of all, thanks you for this wonderful module.
I'm thinking about the right way to create a real booking system for Drupal commerce module.
Should it be possible to have the option to define stocks on selected date?
for exemple, we could have 4 cars available 1 day, but only 3 another day. Istead of having a select list with availability states, we could just have a quantity text field.
This features would be a great improvement to create a real commerce booking system.

Comments

Comment #1

camdarley CreditAttribution: camdarley commented 2 October 2012 at 10:38

Here's my proposal:
http://www.drupalcommerce.org/discussions/4323/propositions-commerce-boo...

Comment #2

fietserwin

Le Mont-Dore

CreditAttribution: fietserwin commented 3 October 2012 at 14:09

I guess this is better done in the Rooms module which already allows to define the number of available rooms (of the same type and price) and that integrates with Commerce.

Though Rooms in its current state is fairly specific for hotels, I guess that it could be used for other items as well that are rented/allocated on a per day/night basis.

What do you think?

Comment #3

camdarley CreditAttribution: camdarley commented 6 October 2012 at 16:14

I understand, and I agree, this issue should belong to rooms module. But here's what I love in Availability Calendar:
- Calendars are field items, they can be attached to any entity, and it's possible to attach multiple calendar to one entity.
- Calendars look great to front user, days can be clickable, and the booking formlet is very intuitive
- The way Availability Calendar store data in database is, in my opinion, much better. There is just one entry by date, not by month, so SQL queries can be done on a date, in an easier way.

Maybe I'm wrong but Rooms doesn't allow to define the number of available rooms, only the number of sleeps/rooms. I don't think it could be a good solution for seats booking with hundreds of seats if you have to create each one by one.
I already made a module that use Rooms availability management to set stock availability on products: http://drupal.org/sandbox/camdarley/1762222, but i'm not fully satisfied for the reasons above.

I need this functionality for a site I'm making, and I need to find a quick solution, that's why I can't wait for the Rooms module to become more versatile. I'm ready to develop this feature myself but I would like to discuss before for the right way to do it... or not ;)

Comment #4

fietserwin

Le Mont-Dore

CreditAttribution: fietserwin commented 8 October 2012 at 19:48

I agree with you regarding the differences between Rooms an this module. There is an issue somewhere in this issue queue (and a correlated one in the Rooms modules' issue queue) about merging these 2 modules and these will be points that will have to be discussed.

I'm not sure either about ho to create separate objects in Rooms. I thought, that as they are able to search on availability and list only the types of rooms of which at least one instance is available that it would be easy to create a set of instances at once (if not, it should be reported as a feature request over there).

You should also have a look at AG reservations, although it uses Ubercart instead of Commerce.

Concluding: I have no plans to further integrate the booking process into this module. If I would have plans to do so (and yes, I do get this request quite often) I would prefer to cooperate with Rooms, But I'm also waiting for some progress over there.