How to create a content type with associated products and customized attributes?

Question

I am creating a little CRM at work and I have two content types:

1. Offers - with some text fields and references to users and companies.
2. Products - very simple with SKU, Title, Price

Now I want to attached some products to Offers and then alter their attributes like price, add quantity and then display all this as a view with the total amount of all prices sum together.

The final goal is to have multiple offers referencing products but with own price and quantity.

I hope this is not to confusing? I tried already entity reference but then I cannot at a custom price or quantity to those products.

Answer 1

You can use the Field collection module

Provides a field-collection field, to which any number of fields can be attached.

And create a Field collection field (in your Offer Content Type) with a reference to Product and a field named quantity and other named custom price.

So in your Offer you can have many Products with theirs quantities and custom prices.

Answer 2

I have a similar set up, using Businesses and Events. Events have a Entity Reference Field which links it to whichever business is selected. On the View for this display, I added a Relationship using the Entity Reference field:Content and the Contextual Filter:Content ID this will get any "items" directly related to the Business associated with it.

Not sure this answers what you're looking for. But hope it helps a little bit.