How can I achieve this - selling people ?

[Paul]

Hi there,

 

I am considering a new venture which in essence involves selling "people" and their time rather than a physical product. It's not quite a service either.

 

People will be paying to play a game with the people I am "selling".

There will be a number of "people" and a number of "locations". These "people" will be tied to a particular location.

 

These people are available on a numerous days throughout the year (decided by them in advance).

 

"Shoppers" should be able to select the location or person (probably location) and choose a date which they would like to play.

 

The only other complication is that up to 3 people can play with the one person (at up to 3 times the cost). However, once the person has been "bought" (in a quantity of 1-3) that person on that date is now unavailable (out of stock)

 

Can I fit this into the osCommerce model ? Any thought would be appreciated.

 

Regards

 

 

Paul

[Rumble]

Sorry i couldnt resist but i've not heard of a contribution for 'pimping' :D. People as products? Games? Booking them out? More than once a day? Very dubious! But hey if its legal and there money to be made why not!?

 

But saying that now to the serious bit! The person being sold could be set up as a 'product'.

 

The location can be set up as 'category'. With people in a particular location found as 'products' in their relevant 'category'.

 

You could create a table called 'calendar' with the following fields

 

order_id

customers_id

products_id

date

 

Then use a count query so that the 'product' can only be booked out 3 times for any one date.

 

You might need another table called 'availability' with the following fields

 

products_id

date

 

And a form in the admin side where 'products' can choose which days they are unavailable and this form would write to the 'availability' table.

 

Selecting the dates, multiple dates would require some sort of calendar function on the product info page where a customer can dynamically select dates. The calendar would show each 'available' day in four colours green (when nobody has booked the product out), yellow (when the product has been booked out once), orange (when two people have booked the product) and finally red for when the product is fully booked, 3 bookings, for that particular day). Unavailable days in grey. When available dates are slected clicked on they turn blue!? Then the buyer can add them to the cart in one click.

 

The checkout_process.php would then translate these dates to the 'calendar' table on order confirmation/final checkout.

 

Just an idea maybe someone could take it further!?

 

This looks like a complex site but heres a contribution that might have some starting point;

 

Events calendar http://www.oscommerce.com/community/contributions,1061

 

Good luck!!

[Paul]

Hi Rumble,

 

Thanks for your reply. Just to let you know .... it is legal ... and it's not pimping either .. and the games .. well it's probably not what you were thinking ! :lol:

 

Golf is the answer. It can be played with up to 4 players (ie the person being "sold" and up to 3 others at a time). The only difference to your understanding was that the person can only be "sold" once, but the price can be in multiples of up to 3. This can probably do away with the "count". Would this make it any easier ? Would the "multiples" be an attribute of product ?

 

I'm slowly getting my head around it.

 

 

Regards

 

 

Paul

[Rumble]

So one person being sold has 3 prices attached to them? eg Joe Bloggs can be bought at ?10, ?18 or ?26 depending on how many players (1, 2 or 3) wanna play with that person.

 

Once they are bought on a specific date eg 19 July 2003 they cant be bought by anyone else (or group)!?

 

If so im sure that simplifies it a bit!

[Paul]

Hi Rumble,

 

I think you've hit it on the head. That's absolutley correct.

 

Paul