Commerce Feeds: Multiple values in one field or multiple fields? Goal
What I'm trying to ultimately accomplish is create tiered pricing based on quantities.
The client is selling different prices depending on quantity. I'm trying to figure out what is the simplest way to store, access and represent this data using fields. While at the same time i'm importing them through commerce feeds.
About my feed/data
I have a CSV table header with the columns &quot;P1 Price,&quot; &quot;P2 Price,&quot; and &quot;P3 Price.&quot; There are also &quot;P1 Qty,&quot; &quot;P2 Qty,&quot; and &quot;P3 Qty.&quot;
Thus, P1 Price corresponds to P1 Quantity, etc.
My question
Would it be simpler, in terms of less complex rules or views configuration, in the long run if i created separate fields to store each price/quantity, or if I combined them into one field that stores 6 different values?
My primary considerations include, scalability, maintainability, etc.
It sounds like what you need is commerce price table. There isn't a stable release for it yet, but I have seen it demoed where it worked great.