Skip to main content

This is a bit of an odd one.  I’ve done searching and so far have only come up with partial answers.

Basically I have a spreadsheet with multiple columns, each comma separated, but all relating to the same row (in this case a row is a physical product, like a t-shirt).  Sample data:

Sizes: XS,S,M,L,XL,2XL,3XL,4XL

Prices: $31.40,$31.40,$31.40,$31.40,$31.40,$33.40,$35.40,$36.40

All of this data relates to one row, and creates an array of sizes & their relevant cost (e.g. XS is $31.40, 3XL is $35.40).  It’s not hard to get just the sizes (I’m using a loop) but the problem is I’m not sure how I can correlate the data with the prices.  The end goal is to be able to push the size and the price on the same step to a JSON endpoint (that part I have done).

Here’s what I have so far:

 

Hi @zapadap 

 

You need to click on the + sign under the Sizes line and add Prices there, this way it will collate the size with the relevant Price. 

 

Please let me know if this works :)

I’m an idiot. Sigh.  Thanks!

@zapadap Im sure it would have taken you one more second to figure it out 🙂 We all learn new stuff every day! Glad I was able to help 

Terms & Conditions