Complex package product

[john_housser]

Hi everyone,

 

Thanks in advance for any help, and sorry if this topic has been covered before.

 

I'm working on a web site for a festival that will be selling clinics, competitions, and social tickets.

 

There will be multiple clinics on Friday, Saturday morning, Saturday afternoon, Sunday morning, and Sunday afternoon.

 

We will also have a package that includes one clinic Friday, Saturday morning, Saturday afternoon, Sunday morning, Sunday afternoon, as well as tickets to all the socials.

 

I'm not sure how to set up this packaged product. I will be able to classify all the clinics by their time, so the customer should be able to choose which clinic they want for each time period, and then also just get the socials tickets.

 

Cheers,

John

[burtonsnow8]

Hi everyone,

 

Thanks in advance for any help, and sorry if this topic has been covered before.

 

I'm working on a web site for a festival that will be selling clinics, competitions, and social tickets.

 

There will be multiple clinics on Friday, Saturday morning, Saturday afternoon, Sunday morning, and Sunday afternoon.

 

We will also have a package that includes one clinic Friday, Saturday morning, Saturday afternoon, Sunday morning, Sunday afternoon, as well as tickets to all the socials.

 

I'm not sure how to set up this packaged product. I will be able to classify all the clinics by their time, so the customer should be able to choose which clinic they want for each time period, and then also just get the socials tickets.

 

Cheers,

John

 

 

In your osC admin panel there is an option to add attributes. So you can create the product "Seminar 1 - 11/13 to 11/15". Then go create the attribute: Day. Then create the options for friday, saturday, sunday or all 3 days. Then create the attribute: socials only. Create the options for friday, saturday, and sunday. Now on the bottom of that page you can choose which product, which attribute, and which option. From there you can choose to add or subtract from the price based on what attribute/option combo you are choosing.

[john_housser]

In your osC admin panel there is an option to add attributes. So you can create the product "Seminar 1 - 11/13 to 11/15". Then go create the attribute: Day. Then create the options for friday, saturday, sunday or all 3 days. Then create the attribute: socials only. Create the options for friday, saturday, and sunday. Now on the bottom of that page you can choose which product, which attribute, and which option. From there you can choose to add or subtract from the price based on what attribute/option combo you are choosing.

 

That's fine, but the tough thing is we also sell the clinics individually. So we want to be able to link the inventory of an individual clinic to the number sold individually, plus the number sold as part of a package.

[burtonsnow8]

That's fine, but the tough thing is we also sell the clinics individually. So we want to be able to link the inventory of an individual clinic to the number sold individually, plus the number sold as part of a package.

 

Ok let me get this straight. You have X amount of spots for friday, sat, and sun. If someone orders just a friday ticket, you don't want them to take up a spot for all weekend in your database?

 

 

So let me ask, how are those numbers added to your database? Do you not want to over-sell a certain day and so you want it to automatically update if that option is not available?

[john_housser]

Ok let me get this straight. You have X amount of spots for friday, sat, and sun. If someone orders just a friday ticket, you don't want them to take up a spot for all weekend in your database?

 

 

So let me ask, how are those numbers added to your database? Do you not want to over-sell a certain day and so you want it to automatically update if that option is not available?

 

Sorry it's a fairly odd situation.

 

So on Friday there are 4 different clinics. Saturday morning there are 5, Saturday afternoon there are 6.

 

Customers can buy any 1 clinic they want one at a time. Or they can buy a package that includes their choice of any 1 Friday clinic, any 1 Saturday morning, and any 1 Saturday afternoon.

 

But any clinic can only have 10 participants, regardless of whether they bought that clinic on its own or as part of a package.

 

The way I would conceptually think to set it up would be to set up the individual clinics (A,B,C,D, E,F,G,H,I, J,K,L,M,N,O), then a package would include 1 of A/B/C/D, plus 1 of E/F/G/H/I, and one of J,K,L,M,N,O. And if a person bought a package of B/H/K, it would decrement the inventories of those individual clinics. When the clinics get filled up they should not be able to be purchased individually, and should no longer be an option for the package.

[burtonsnow8]

ok ok, i get exactly what you are trying.

 

I'm trying to think of a way that is easy for you to complete and for the end user to select their clinics. This is what I have so far:

 

 

I'm assuming your different clinics are different categories at this point (meaning on your categories box you will have: Clinic 1, Clinic 2, Clinic 3). Those will be the options in the left menu bar.

 

The next step would to add a description page for your categories. I use this one: http://addons.oscommerce.com/info/6250

 

Now, manually create the page which will contain the info about your clinic. What I would suggest is having the bottom part of the page contain radio buttons to let users choose their prefered clinic. This might require some additional coding work or another add on. Below all the options is an add to cart button, which will add their selected clinic to the event. You will then have to set up some sort of discount for choosing all 3 (if that is the perk to buying 3 tickets worth). There are also add-ons or built-ins that can help you with that.

 

 

At the end of the day it will look something like this:

 

 

if you think this will work for you I'll try to help get together the necessary things to get this completed.

[john_housser]

Hm, I'm not quite sure if this is what we need.

 

Each clinic will be a different topic. Where I was using the letters the letter would represent the name/topic of the clinic. A-D would be Friday clinics, E-I Saturday Morning, and J-0 Saturday afternoon. So when you were ordering the package you would have a dropdown (or radio buttons) for each time slot (Friday, Saturday morning, Saturday afternoon) that would list the clinic options for that period that were still in stock.

 

[burtonsnow8]

Hm, I'm not quite sure if this is what we need.

 

Each clinic will be a different topic. Where I was using the letters the letter would represent the name/topic of the clinic. A-D would be Friday clinics, E-I Saturday Morning, and J-0 Saturday afternoon. So when you were ordering the package you would have a dropdown (or radio buttons) for each time slot (Friday, Saturday morning, Saturday afternoon) that would list the clinic options for that period that were still in stock.

 

 

 

So for Friday, topic A is different from topic D?

 

This is how I was looking at setting up your category tree:

 

 

 

So basically this is a very custom job and is going to require tweaking the stock osC. I will try to be as thorough as possible to help explain this.

 

 

You will be creating your own product pages and not using the osC format. Download and install the category description add on. Category Descriptions Add-On.

 

Once that is installed, you are going to create a description for each Clinic in html. Here you will be able to tell users what events will be at each clinic and at the very bottom will give them the option to choose their desired event via the radio buttons. Imagine the first image with time options available to click under each day (see image below for example). The last step will be removing the osC structure so the only options the user sees is the one you have coded for them. If you look at my page below its kind of an example, the only difference is that at the very bottom there will be no products (which we will comment out later in the index.php, but one step at a time here).

 

 

 

 

www dot airflowresearch dot com/index.php?cPath=68_111

 

 

 

 

 

*edit*

 

I should have made that first image like this one....is this more what you are talking about:

http://i36.tinypic.com/2i2bz3c.gif

[john_housser]

Sorry that's not quite right, from the category tree.

 

It's more like:

 

Friday Clinics
-Topic A
-Topic B
-Topic C

Saturday Morning Clinics
-Topic D
-Topic E
-Topic F

Saturday Afternoon Clinics
-Topic G
-Topic H
-Topic I

 

A customer can buy any one clinic topic, or the package which include their choice of A/B/C, plus their choice of D/E/F, plus their choice of G/H/I

 

So I'm not sure if your idea still works, but that's how the structure works.

 

So for Friday, topic A is different from topic D?

 

This is how I was looking at setting up your category tree:

 

 

 

So basically this is a very custom job and is going to require tweaking the stock osC. I will try to be as thorough as possible to help explain this.

 

 

You will be creating your own product pages and not using the osC format. Download and install the category description add on. Category Descriptions Add-On.

 

Once that is installed, you are going to create a description for each Clinic in html. Here you will be able to tell users what events will be at each clinic and at the very bottom will give them the option to choose their desired event via the radio buttons. Imagine the first image with time options available to click under each day (see image below for example). The last step will be removing the osC structure so the only options the user sees is the one you have coded for them. If you look at my page below its kind of an example, the only difference is that at the very bottom there will be no products (which we will comment out later in the index.php, but one step at a time here).

 

 

 

 

www dot airflowresearch dot com/index.php?cPath=68_111

 

 

 

 

 

*edit*

 

I should have made that first image like this one....is this more what you are talking about:

http://i36.tinypic.com/2i2bz3c.gif

[john_housser]

Sorry that's not quite right, from the category tree.

 

It's more like:

 

Friday Clinics
-Topic A
-Topic B
-Topic C

Saturday Morning Clinics
-Topic D
-Topic E
-Topic F

Saturday Afternoon Clinics
-Topic G
-Topic H
-Topic I

 

A customer can buy any one clinic topic, or the package which include their choice of A/B/C, plus their choice of D/E/F, plus their choice of G/H/I

 

So I'm not sure if your idea still works, but that's how the structure works.

 

 

I think the easiest way to explain what we're trying to do would be to use the example of the demo store. osCommerce came with a bunch of computer parts in the example setup. So imagine we're a computer store, which sells both individual components, as well as computers.

 

So you could buy hard drive A, B, or C. Graphic card D, E, or F. Keyboard G, H, or I.

 

A customer can buy any of those components on their own. They all cost $100.

 

Or, they can buy a computer. When they're buying their computer they get to chose WHICH hard drive they want (any one of A/B/C), as well as which graphic card, and which keyboard. The computer costs $250 (50 less than buying them individually). When they buy a computer the inventory of the individual component should also decrease appropriately.

[john_housser]

I think the easiest way to explain what we're trying to do would be to use the example of the demo store. osCommerce came with a bunch of computer parts in the example setup. So imagine we're a computer store, which sells both individual components, as well as computers.

 

So you could buy hard drive A, B, or C. Graphic card D, E, or F. Keyboard G, H, or I.

 

A customer can buy any of those components on their own. They all cost $100.

 

Or, they can buy a computer. When they're buying their computer they get to chose WHICH hard drive they want (any one of A/B/C), as well as which graphic card, and which keyboard. The computer costs $250 (50 less than buying them individually). When they buy a computer the inventory of the individual component should also decrease appropriately.

 

So after thinking about this, I did a search for "Computer Creator", and there's a contribution specifically for this, that I should be able to modify for exactly our purposes.

 

http://www.oscommerce.com/community/contributions,3282