Hey everyone!
I’m working on an e-commerce site for artwork. Some pieces - like photography - can be printed to different sizes (at different prices), so I want the artist to be able to specify different size options (height, width, depth, weight, price) for a single piece so a buyer can choose the size that’s best for them. Something like this:
10 (h) 20 (w) 0 (d) 0.3 (wt) $50 (price) Primary size
5 (h) 10 (w) 0 (d) 0.2 (wt) $30 (price) Alternate size option 1
20 (h) 40 (w) 0 (d) 0.6 (wt) $120 (price) Alternate size option 2
But I’m having trouble achieving this / making it work. Below is how I’ve tried to approach this. I’d appreciate the community’s help in working this out!
When artists upload pieces of art, they specify the different size/price details they can make available (these dimensions are completely up to them, I can’t create a pre-specified list). I’ve currently set it up in the database as:
H1 W1 D1 WT1 P1 Primary size
H2 W2 D2 WT2 P2 Alternate size option 1
H3 W3 D3 WT3 P3 Alternate size option 2
This seemed like the most intuitive way to collect all this data this because I need the information to achieve a few things:
a) When a buyer wants to buy a piece of art, they can select from a dropdown which size they want. Something like:
But I’m having issues getting this to work (can’t do repeating groups, can’t set dynamic data, etc):
b) When a buyer specifies a particular size from the dropdown, I hope to show that piece of art on a stock image of a room (to give buyers a sense for the size). For example:
The default image will show the Primary option’s size but, if a buyer picks Option 2 above, I want to be able to resize the image so it shows up bigger on the stock image. That’s why I thought saving h1, w1, d1 and h2, w2, d2 etc. separately would be the way to go.
c) In filtering the artwork on the site, I’m trying to give potential buyers the opportunity to filter the sizes they are looking for. Something like:
I’ve got it to work with H1, W1, P1… but haven’t been able to figure out how to incorporate Options 2 and 3’s data in the filters.
Thanks for the help, all!
