Hi - I'm having some trouble trying to figure out how to create a view of my orders. This is for registration for a conference, and there are several CCK fields in the node, using node checkout (e.g. Friday lunch - vegetarian or non-vegetarian), and several attributes in the product (e.g. additional cost for a t-shirt). I'd like to provide a view for the conference planners that shows the CCK fields and attributes for each order.
I've tried creating a view of type "Ubercart orders". There are a number of things I would expect in such a view, but don't see them or can't figure it out:
1. Under filters, I can't choose the product id, to just show orders of a particular product. It seems I can only filter this by the product's node title.
2. Under filters, I see all of the product attributes listed separately, but I really want these available under fields. In fields, I only have one item that lumps all of the attributes together. I'd like these to be separate fields in my view.
3. I can't figure out how to get the CCK fields pulled in. I've tried adding a relationship, but the option to add a relationship to the node that is "checked out" doesn't seem to be available.
Can someone point me in the right direction? I'm sure this is possible (right?), but I just can't figure it out. Thanks!
Comments
Comment #1
epop commentedI also need this functionality. Subscribing.
Comment #2
jasonawantHi,
Your #1: I think you may be looking for Ubercart order product: Order product ID.
#2Unfortunately, uc_views_attributes allows us to use attributes as filters, but not as fields. Closing this issue as it's a duplicate of http://drupal.org/node/652308.
I need this functionality too.
#3 You may want to investigate this issue and the patches it includes to create views with both node checkout cck fields and ubercart order fields: http://drupal.org/node/430016.
Feel to re-open the issue if you wish.
jwant