Site maintenance: Sun 15 Nov, from 12:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / Setting Up Categories, Products, Attributes / Ability to get a list of "option value" by "customer"?

Ability to get a list of "option value" by "customer"?

Locked

Started by banhi on 22 Jan 2008, 5:16 AM · Views: 2,584

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
22 Jan 2008, 5:16 AM
#1
banhi avatar

banhi

New Zenner

Join Date:
Jan 2008
Posts:
7
Plugin Contributions:
0

Ability to get a list of "option value" by "customer"?

I tried a search for this but the proper search phrases seem to elude me and I've been at this a while. So I turn to you all for help.
puppy dog eyes

The product in question is a package deal for a 3-day workshop, where the "Option Value" is the individual classes, listed by date and time ("Option Name"), that they want to choose for the entire event.

What we would like is to have the ability to get a list of participants ("Customers") by their class choices ("Option Value") to figure out when those individual classes have sold out, and to set our list of participants for the weekend for check-in purposes.

I know it's a complete shot in the dark since product options generally aren't tracked in this way, but is there currently ANY way to do this? I did see the "Super Orders" Mod, but I was unable to tell if it had this capability...?

Thanks so much for your time.

22 Jan 2008, 8:28 PM
#2
banhi avatar

banhi

New Zenner

Join Date:
Jan 2008
Posts:
7
Plugin Contributions:
0

Re: Ability to get a list of "option value" by "customer"?

Okay, I found the stock_by_attributes mod (which is very nice, btw) but it's still not quite right because we have several products that contain these workshops, meaning we need to control the stock by the "option value" specifically, so that the stock will be applied across all the products that include that "option value".

Any ideas here would be very much appreciated.
If we need to pay to have this option available we might go that route depending on price, we'd even share the mod if we can get it working...

22 Jan 2008, 9:25 PM
#3
banhi avatar

banhi

New Zenner

Join Date:
Jan 2008
Posts:
7
Plugin Contributions:
0

Re: Ability to get a list of "option value" by "customer"?

The more I look into this the more I realize that what I was asking for above is not possible the way we have our products set up now. Sorry, I misunderstood some fundamental definitions of what Option Values and Names actually are.

BUT, we'd still like to see if there's a way to obtain a list of the attributes sold, instead of having to cross-reference every order. For example, in Reports where you can see the products purchased, is there a way to go a step further and have each product purchased list the attributes available and how many of each were "sold"?

23 Jan 2008, 5:44 AM
#4
banhi avatar

banhi

New Zenner

Join Date:
Jan 2008
Posts:
7
Plugin Contributions:
0

Re: Ability to get a list of "option value" by "customer"?

I am happy!
Consider this question answered. Whew!

For anyone who wanders in and is curious...
I downloaded the mod "Orders Exporter" and it does exactly what we needed. We can use it to download a text file that includes the option names and values, which can then be opened in Excel and be formated any way we need at that point. Yay.

26 Jan 2008, 6:57 PM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Ability to get a list of "option value" by "customer"?

Thankks for the update of what works for you ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!