base price + attributes = total

[jeffreydesign]

I sell Jewelry. I have many items where there are several attributes, each one contributing to the final price. Let's take wedding bands as a 'for instance'.

Attributes would be:

Size (5-12, sizes 6 and higher have an upcharge)

Width (2mm - 12mm, 3mm and up has an upcharge)

Metal (Stainless Steel, Titanium, 10K White, 10K Yellow, 14K White, 14K Yellow, 18K White, 18K Yellow, Platinum - each different metal type defines the BASE PRICE)

So, ideally I would like to have the customer select metal type, size and width and have a price displayed. When Gold or Silver or Platinum goes up or down (as it frequently does) I would like to be able to change the metal base price and then all the other attributes adjust (based on a percentage of the base) the final price. So it might go like this (example):

Milgrain Band base price (based on size 5, 2mm)
customer selects 14K Yellow Gold ($52.00 fixed price)
customer selects size 7 (2% upcharge) 1.04
customer selects 4mm width (40% upcharge) 20.80
Total price $73.84

As it is right now, I have fixed amounts in the attributes so when the price of a metal changes I have to update ALL the attributes, since the cost of the metal affects all levels of upcharges.

Since I only have a modest markup on Jewelry, I have to run a tight ship and could easily sell things for below my cost when Gold spikes.

On the other hand, if I only had to update the metals prices and the other attributes were fixed percentages (which they essentially are anyway) based upon the metal price it would save me a TON of time and hassle.

I thought I had this figured out, but it wasn't working out right. If this CAN be done, PLEASE give me a stupid-simple primer on just how to do it.

Thanks a bunch.

Jeff

www.jeffreydesign.com

[dbltoe]

You may want to investigate price factor in the attributes controller. That will allow you to set the base price and automatically upcharge a larger size by a percentage.

If you wanted an additional 20% for an option, add 0.2 to the factor and an offset of -1.

[jeffreydesign]

You may want to investigate price factor in the attributes controller. That will allow you to set the base price and automatically upcharge a larger size by a percentage.

If you wanted an additional 20% for an option, add 0.2 to the factor and an offset of -1.

Thanks for the response. I have tried that. The problem is that if I make the 'base price' a selectable attribute (in this case it's the metal type) the other attributes will not calculate based upon that initial selection.

What I have had to do is make a different product for each metal type, and then make the attributes for upcharges on each product. Instead of nine different products that all share one style (because of nine different metals, but one ring style) it seems to me more simple and efficient to have ONE product, with a "controlling" attribute that sets the 'base price'.

What I am wondering is if this is possible, or do-able.

Jeff

[jeffreydesign]

Oh and one more thing just to make this a bit more complicated;

What would be ideal is to be able to make an attribute's price factor dependant on the last calculation. For instance:

Product price: $0

Attribute 1: drop down list of different 'base prices'. Customer selects 14K Yellow Gold, so new base price is $59 (based on a 2mm band, size 5)

Attribute 2: drop down list for size. Size is a percentage of base price, so now the customer selects size 10 and the price factor is .7, so the new sum is $100.30

Attribute 3: drop down list for width. Width is a percentage of base price + size, and in this case, the customer selects a 6mm band. This choice has a price factor of 2.25, so now the ring costs $225.07

This is what I need to do.

Jeff