Subproduct Challenge

[Sue G]

Hello,

So here's the situation: I have a client that offers multiple Seminars a year and for each Seminar a person can attend as an option: Saturday & Sunday, Saturday Only or Sunday Only. So within ShopSite I created the following products:
Seminar A with a cost of $0
Seminar B with a cost of $0
Saturday & Sunday with a cost of $200
Saturday Only with a cost of $125
Sunday Only with a cost of $125

Added Saturday & Sunday, Saturday Only and Sunday Only as subproducts to Seminar A and Seminar B. This works fine except for the fact that when an order is created the SKU assigned to the order item is naturally one of the subproducts and not Seminar A or Seminar B.

This is where problems exist:
An Attendance Report for the Seminar is necessary but I believe I've lost association between the Seminar and the attendance option, have I? Since there are 30'ish Seminar's a year I wasn't looking forward to adding 1 main Seminar product and 3 unique Attendance Day products for each Seminar.

Ultimately, I need a report that looks like:

Seminar A
Attendee Name Attending Day(s)
Joe LastName: Saturday & Sunday
Jane LastName: Saturday Only

Thanks in Advance for any additional solution ideas,
Sue

[Jim]

If you have a Pro store you could use order option pricing instead of subproducts.

Seminar A
Please select sessions you will attend;n
Saturday & Sunday with a cost of $200;+200
Saturday Only with a cost of $125;+125
Sunday Only with a cost of $125;+125

Seminar B
Please select sessions you will attend;n
Saturday & Sunday with a cost of $200;+200
Saturday Only with a cost of $125;+125
Sunday Only with a cost of $125;+125

When the item is added to the cart it will show as Seminar A or B with the date showing as the order option selected.

You can use a text box with each product to have the person's name entered for each seminar.

Note that if you are requiring SKU to keep track of things this wouldn't work since you don't get a separate sku for each option but at least you would know which days and the seminar that is being requested.


By the way when you use subproducts the product name in the cart by default will contain the parent products name too. There will be a separator between them. I don't remember which comes first parent or supproduct but it would look something like
Seminar A: Saturday only
or
Saturday Only : Seminar A.
You could see what order they are in by looking at an item in your cart the way you currently have it configured.