Add support for uc_attributes

subscribing...

Would be nice to see stocks for attributes aswell (as with the module on ubercart.org)! Just adding, having it both as filter and as field (based on images?) would really make a nice addition.

subscribing.

much needed functionality.

For what I just read on ubercart's contrib it seems that the guy (Josh) that was trying to help kind of switched to the idea of contributing to this module, is there any work at all going on with uc_attributes?

Hi madsph,

I wanted to check something with you. I have a requirement for a client that needs two things for now:

- product report in CSV (including uc_attribute information) and some other stuff
- sales report in CSV (one sale per line, with all the line items).

I kind of need this a bit fast so I am tempted in code it quick and dirty, but what I'd really like to do is expose whatever is that's not exposed yet to views and create both reports with Views and views_bonus (CSV).

I checked the CVS messages and there seems to be some work going on in the 3.x branch with uc_attributes so wondering what have been done in that front and how stable that branch is in order to use it on production and test it/help improving it. And what are your thoughts on doing what I need with your modue.

Thanks,
a.=

After almost three full days I have something to share. It's the first approach, it might need work, but I can say it's functional. Would like some feedback in terms of the possibility of this be included in the code, and if not, I might just end up creating a module for myself. I tried to do this as usable as possible for my particular use case as well as others.

A summary of the difficulties I found working with this:

- uc_product_adjustments is the unfriendliest table I've ever seen. Not only it stores serialized data, but it has a mixed combination of keys. What I mean with this, is that the adjustments are related to the node itself, but they are also related to the stock table, although the relationship is not mandatory, it will depend on the configuration and what modules you have enabled.
- It's impossible to avoid duplicate data if both tables are available (stock and adjustments), I really struggled with this, but eventually I understood that with relationships, you might tweak up the views to whatever you needs might be. By using relationship, you can work around the duplication of data. You can eventually loose to see a few adjustments, but if you want stock information to control the report (as I do) you can live with it. If not you can create the the relationships the other way or have one report for stock and one for adjustments or have the data duplicated and work it on your own.
- Because of the use of relationship, you can end up with empty combinations field. I added logic to the field (according to a configuration entry) so the field handler can fetch all other combinations that were not really related to the stock table but are available to the node. This would only makes sense if you use the stock->adjustments relationship which is also defined in the patch.

I also left an entry for an immediate improvement that I might need (or anybody else) for an option to group combinations together in a single row, something close to what CCK multiple field does.

I learned a lot of views in this process so that's one thing I am very happy with.

Now that I went through the code, I'd also suggest a bit of cleanup. Maybe group views data according to specific table/functions in subfunctions or maybe use custom module include files? I tried the first approach in the patch, so you can look if you like it.

And worth saying that I did this in the 3.x-dev branch

Already a quick fix!

Was using a protected keyword for a function and I found out that's only PHP5, so removed it for now.

Already a quick fix!

Was using a protected keyword for a function and I found out that's only PHP5, so removed it for now.

Already a quick fix!

Was using a protected keyword for a function and I found out that's only PHP5, so removed it for now.

I apologize for the triple post above :s.. all three patches are the same.

Hi hanoii,

Thanks for tackling this much-needed feature. I ran the patch against the 3.x-dev branch and it is working great. I am running it with views calculations and it really a much needed step forward with reporting.

Thanks to you, with exposed filters, we can now select a product, an attribute and then see a total number of products ordered. This is important to us because we bulk order products after they have been ordered. For example, we sell shirts and jackets as fundraiser for our local public school. We have to total the color, size, cut, etc.

What would totally kick up the level of awesomeness would be if we could have attributes output as fields. If you added attributes as fields then we could output a list of all orders by customer name, product and match them up to the selected attribute (size, color) for delivery. Otherwise we have to print each order separately to see that data. Hope you would consider that feature request.

Thanks again,
ezraw

thank you very much!

Hope to see working with separate fields: option-images, prices and stock.

great work guys!

Just one thing that I can't get to work...

I have a product with one set of attributes and a unique SKU for each product+attribute combination.

When adding the attribute as a field in views the results list the unique SKU for each product+attribute combination multiple times, once for each attribute, when really it should list each unique SKU once because that SKU only has the one attribute.

Is it possible I've configured views incorrectly? or have I stumbled onto a bug?

Thanks

sure.

the export is attached along with two screen shots, one with and one without attributes.

I'm trying to get a listing the same as the screenshot without attributes, but with the attribute instead of the SKU...

thanks in advance

Hi awconstable,

Try adding a "Product attributes: Model" field instead of "Product: SKU" for the event_view_with_attributes

Quick Question - I am trying to use this for a jCarousel view for all the attributes for a certain product (in my case an art print with all of the framing options in a carousel). I got this going, but how would I include the price for the certain attribute?

Thanks for the idea dan.nsk, unfortunately I get the same results as before.

Hello guys!
really wonderful module and appriciate your work very much!!

now i'd like to ask if it's become possible to choose attributes for filter option in Views!

i read "handling for attribute options filter is not complete" in http://www.ubercart.org/contrib/3960
but you guys have been working hard now so there may be some progress of this matter.

and would you please tell me how to setup if anyone has achieved.

thanks in advance.

Hi shimodart, the patch above in #13 allows you to filter by attribute. It's been committed and moved to the submodule "uc_views_attributes." Once I applied the patch, my attributes just showed up as an option when I added a filter. I would assume the submodule works the same way.

Hi Hanoii & madsph

Thanks for putting in all this work, it works on the new activity registry i'm setting up for a local youth club!
I'm kinda wondering why you provide the possibility to 'filter' on attribute but why the 'field' doesn't show these.
I'd be very happy if you can provide me a pointer how to adjust uc_views_attribute_handler_field_combination to provide the 'attributes' to the field view as well.

Regards,

Tom

Hi ezraw!
oops i mistook the big comment by hanoii.
now the filters come out!!

but... i could only get only one node's thumnail.... i'll check a bit more.

THANKS anyway!

shimodart

Just to clarify, i'm not looking for a list/view/fields of the product attributes but for a view where i see the field of the ordered attributes.

So if someone ordered product a with a text-attribute of "aaaa" and someone else ordered product a with text attribute of "bbbbb" i'd like to see

Person Product Attributes
1 A aaa
2 A bbb
3 A ccc
3 B xxx

etcetera

Hi ezraw

I tested the latest dev ver. of uc_views but i could only see "Purchased products: attribute" filter,
not "Products: attribute" filter which I desire to see.
I want to filter all the products (not depend on purchased or not) by attributes.

Did you achieve filtering by using patch on #13?
I'm a bit afraid of using patch so I'd like to ask to ensure.

so to compa,
you can exactly do that by using latest dev version!!

thanks

shimodart

Hi shimodart,

I updated to the latest dev version and I still see a list of fields to filter on under "Order product." I assume you've created attributes already? I also have "Order product: SKU" in my fields list. Not sure if that matters or not.

Hi shimodart,

I'm running the latest dev tarball available from the uc_views module site (or do you refer to the CVS-Head version?).

When i'm adding a view (create new view, type "Order Products view") I can see my attributes in the filter but not in the view.

Attached the full output of add-filter and add-view (it's the "jeugdlid" things i'm looking for to display).

Hope you can help us out!

Cheers, CoMPa

Hi Madsph,

Hope you enjoyed the holiday and as for me, i'm not in that big of a hurry - just wondering how to get things organised on our website.

I'm running UC "6.x-2.0-rc7" 23rd sept and "uc_views-6.x-3.x-dev" 7th oct
The filter order product: attrname works for me (see attachments in #33) it's just that they don't show in 'fields' (for display)

Cheers,

Hi madsph,

Updated from CVS and now the Order product: Product attributes is visible indeed.
For my personal liking i'd rather have it in 'seperate' fields (like with the filter where you can select individual attributes) but looking at the coding i'm not sure that would be feasible i guess. That would make up for seperation of the values in the table. Thanks for the quick solution though!

Cheers,

Works great. Thank you for this small but valuable piece of awesomeness!

Hello,

great module.

Can you help me, I have a shop which sell clothes.

My attribute is the size.

I try to do a view that display the clothes in stock for each size.

For the cloth 'Tunique Hippie', I have few sizes : 36, 38, 40, etc...

Each size have a stock reference:
Size 36, stock reference->Hippie36 :stock quantity 2
Size 38, stock reference->Hippie38 :stock quantity 0
Size 40, stock reference->Hippie40 :stock quantity 3
...etc

I want it display the quantity corresponding to the attribute size.

Cloth________| Size____|Ref stock| Quantity
---------------------------------------------
Tunique Hippie | Size:36 | Hippie36 | 2
Tunique Hippie | Size:38 | Hippie38 | 0
Tunique Hippie | Size:40 | Hippie40 | 3

If I display, it well works
Cloth________| Ref stock| Quantity
---------------------------------------------
Tunique Hippie | Hippie36 | 2
Tunique Hippie | Hippie38 | 0
Tunique Hippie | Hippie40 | 3

But doesn't with
Cloth________| Size____| Quantity
-----------------------------------
Tunique Hippie | Size:36 | 2
Tunique Hippie | Size:38 | 0
Tunique Hippie | Size:40 | 3

How correct it?

I will wish to display a select list in a block to display the clothes that are available for each size.

See the attached file to view my current display.

Thanks in advance.

no, I try to expose a select list with the available size (36, 38, 40...).

When you select the 38 size, for example, it displays in the content all clothes which are in stock for this size.

Sorry for my broken english

Thank you for your great work on this module.

I am new to Drupal but not new to MySQL and PHP, so I can usually find my way around code at a basic level, but Drupal is still only starting to become clearer to me.

I am trying to create a View (my first ever) that will show orders placed in Ubercart along with the attributes that were selected by the user at the time of purchase. But when I edit a clone of the "Orders" view at /admin/build/views, and add a field, the "Order Product: Product attributes" option is not one of the options that appears.

I also tried adding a new "Order Products" view and didn't get the "Order Product: Product attributes" option for a field in that view either.

The specific purpose is using Ubercart for a registration for a conference. Users registering pay a set fee for the conference and choose which workshops they want to attend, which are set up as attributes of the Registration product in Ubercart.

I am using Drupal 6.14, Ubercart 6.x-2.0, Ubercart Views 6.x-3.x-dev (2009-Nov-02).

I'm afraid I am not sure how to include more information with this post as others have done to show my problem more fully.

Thank you for any help.

@madsph

Thank you so much for your help and generosity with your time.

I tried importing the example you created and got the following errors:

* Field handler uc_order_products.attributes is not available.
* Unable to import view.

I looked in uc_views_attribute/views/ and found uc_views_attribute_handler_field_order_product_attribute.inc, which seems like a good candidate for the functionality I need, or at least part of it, but I can't find a "Field handler uc_order_products.attributes" (which makes sense since the error is that it is not available :-) )

As far as I can tell, the example you wrote doesn't specifically request that Field handler, so that's being requested by the Views module due to the way your example is constructed. (How off base am I here?)

Is there perhaps something wrong with my installation of the uc_views module that it doesn't include that field handler? Or is that field handler supposed to be elsewhere in the module or in another module (like UC itself)? I've looked around quite a bit and can't figure out where it is supposed to be, but imagine it must be defined within the views module (or uc_views) since it is a field handler. Again, I'm very new to Drupal but willing to learn.

Thank you for any further help you can provide.

I have tried to make a filter exposed in a block but it has no effect.

If I search a size out of stock it returns the reference of the same product in other sizes...

madsph

My sincere apologies. I had not turned on the uc_views_attributes module after installing uc_views 6.x-3.x-dev. I have now done that and can now add an Attributes Field.

And I imported the views example you wrote for me and it looks great. It is very helpful to me to see how this works and get started working with Views.

Thank you again for your coding and help to newbs like me.

I have :
- the 6.14 drupal version.
- ubercart 6.x-2.0-rc6
- ubercart views 6.x -3.x-dev
- uc_attribute_views found on http://www.ubercart.org/contrib/3960#comment-43532

Hello!

Firstly thank you very much for all the hard work on contribute modules!

@compa
sorry for replying late but glad you found the solution.

I posted some comments before but have been away for weeks and now come back to project.

I'm now in urgent need for uc_views_attribute help.

I think at the moment I can put the filter for "Order Product: Attribute: (attr name)",
but it's not possible that putting the filter by "Product: Attribute (attr_name)", is this right?

I'd like to let users choose products by attribute regarding stocks where they are purchased or not.
The functionality I'm going to achieve is the searching function like http://www.lafraise.com/ .
(please refer the attachment file)

Very appreciated if anyone can provide the patch for this.
Thanks!

@madsh

thanks for your work!
I'll move into the thread you created.

Shimoda

Hi,

Now that this is working, how can we get it to also filter products by attributes that are in stock?

Thanks!!