We need to output a list of all products with all options. Example:

  • 5 models of bicycles -- The Product
  • Each model comes in three different wheel sizes (and wheel size option might vary by model) -- Wheel Size option type with specific options
  • Each model might also have other options, such as with or without basket

So the list might be:

  • Model A 26"
  • Model A 26" with basket
  • Model A 28"
  • Model A 28" with basket
  • Model A 30"
  • Model A 30" with basket
  • Model B 24"
  • Model B 26"

and so forth.

I figured that I could create an Commerce Option view, then add a relationship to the product so that I could add the title/name field from Product to generate the list. But Relationship doesn't have an option to create a relationship to the Commerce Product.

In reality, there are something like 9,000 various options for the entire product line so a method of automating the list is important. After the view is successfully set up, we'll be exporting once and never used again. Any help is appreciated!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.