How do I create a view of a product with a table of variations?
For days and days I'm looking for a solution to create a productdisplay view where the product variations are listed in a table or a megarow table instead of the preformatted select lists.
The product display should look like this:
I cannot find the view which is used by Commerce Kickstart displaying this standard productdisplay so I can't modify it.
Or... do I need to create a complete new view?.
and If so, how do I fix it?
Many thanks in advance for your help and advice.
bEngel / Rotterdam Holland
Asked by: bEngel
on August 8, 2013
So many thanks for the explanation.
Its pretty fast but i can review it again step by step..
I'll keep you informed.
Thanks again mate.
I'm very sorry for the late reply, due to busy times.
But... I fixed it :-)
and it wasn't hard to do it at all.
I still have a question left.
Maybe i'm a little immodest, but is it also possible to make this work when creating a list of products, where every product has its variations as just explained by you?
If not, do you know how to fix this in another way?
Thanks in advance,
Dear Josh Miller, this was exactly what I was trying to achieve.. After a few days of searching and trying with page views, grouped fields and several modules I almost gave up. Then I found this post. Thank you so much! I didn't know it was that easy!! Thank you for sharing! Pip
Hi Josh, Thanks for the explanation. The example you show is a fairly simple table, I wonder how you recommend going about creating something more complex like this example http://www.rajapack.co.uk/stretch-film-palletising/stretch-film/blown-st... specifically the pricing options (with merged cells for discounts).
Try this module on for size: https://www.drupal.org/project/commerce_price_table
Hi Josh, thank you so much for this post.
Is anyone getting error once the views is set up? When I finish every step I get the following
Notice: Undefined index: node in views_handler_field_field->access() (line 127 of /Applications/XAMPP/xamppfiles/htdocs/drupal-commerce-sandbox/sites/all/modules/views/modules/field/views_handler_field_field.inc).
Notice: Undefined index: node in views_handler_field_field->query() (line 186 of /Applications/XAMPP/xamppfiles/htdocs/drupal-commerce-sandbox/sites/all/modules/views/modules/field/views_handler_field_field.inc).
Notice: Undefined index: entity keys in views_handler_field_field->query() (line 198 of /Applications/XAMPP/xamppfiles/htdocs/drupal-commerce-sandbox/sites/all/modules/views/modules/field/views_handler_field_field.inc).
When I go to views settings [show the SQL query] I get the following error when I put node/1 in the Preview with contextual filters
SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS node_, commerce_product_field_data_field_product_family.product_id AS commerc' at line 1
Any input is much appreciated.