selling products with 2 sizes (length & width) ??

[disko]

I want to be able to sell made-to-measure fabric with different price bands.

 

The fabric is sold by the centimetre.

 

Width price per centimetre

up to 36" = ?0.07

37" - 40" = ?0.07

41" - 45" = ?0.08

46" - 48" = ?0.08

49" - 54" = ?0.09

55" - 60" = ?0.09

61" - 63" = ?0.10

64" - 72" = ?0.11

73" - 81" = ?0.12

82" - 90" = ?0.13

91" - 108" = ?0.14

 

so if i want some fabric measuring 47" by 180 cm...

i look down the chart to see 46"- 48" width = ?0.08 and multiply this by the number of centimetres (x 180) = ?14.40

 

i want the user to be able to enter two measurements (width & lenght) and have it calculate the price.

 

the width measurement ranges are consistant for all products.

 

i'm basically looking at doing this:

http://www.web-blinds.com/ourProducts/prod...?product_id=120

[disko]

or... is this over complicating a simple process...

 

this is what my client has asked for.... should we be trying to find out the cost of 1cm square of fabric then doing a simpler X x Y x 1cm square price??

[nwatko]

or... is this over complicating a simple process...

 

this is what my client has asked for.... should we be trying to find out the cost of 1cm square of fabric then doing a simpler X x Y x 1cm square price??

 

Have you tried setting this up in your Products Attributes with OsCommerce Admin? I'm not positive it will work but in there you can set Product Option as Size, and then set Option Value of Size to the different Sizes you offer, and then under Products Attributes you would select your fabric and assign it the different sizes and the new price for each size.

 

That way when a customer pics the fabric it will give a drop down list of sizes and change the price according to the size they pick.

 

this doesn't do exactly what you wanted but it's the only way I can think of you doing this without a coded contribution.

[bernarde]

I'm also looking for a sq.ft. price calculation solution.