Operators on Product Attributes

[ScreaminWeasel]

Dear community,

 

I seem to have an issue with pricing on products and wonder if there is a contribution already made for what I need or if anyone can help me make this work.

 

First allow me to state I know very little php scripting/programming, so I can be little use trying to create a mod/contribution to help myself. My family owns a garage door and window sales/service business and is looking to expand to online parts sales as well. Since i do know html, css and javascript pretty well, the task has fallen to me to develope it. With osC, it seemed I was in for an easy task (even for a garage door serviceman), but as you will see, I was a bit off on that...

 

Secondly I am not sure if my description of what I need will make sense, so I will include an example of my specific need as well. With luck this can help with people trying to see what I need and (hopefully) steer me to an existing contribution.

 

What I need is to do is this:

• allow product attributes to use multiplication and division operators as well as addition and subtraction;
  
• round numbers after operations;
  
• apply attributes' values in a specific order;
  
• make certain attributes available only if specific others are chosen;
  
• adjust weight, quantity and price on items according to attributes chosen.
  

I think that's all...

 

Now here is an example to help clarify:

 

We sell springs for garage doors. Torsion springs are what I am focusing on here (those are the springs that wind and are mounted on a shaft above the door on the door opening's header (not that any of this description matters...)). Torsion springs have several variables that need to be known to accurately balance a door:

• wire guage;
  
• inside diameter (ID) (in inches);
  
• length (in inches);
  
• end type (different manufacturers shape the end of the last coil differently);
  
• and wind (lefthand, righthand or both).
  

Now here is the mathematical formula used to get the right price:

 

((wire guage*ID*length*base price)rounded to nearest whole dollar)+end type value = total price*wind value (1 for lefthand or righthand or 2 for pair)

 

So, a customer wants to buy a pair (lefthand and righthand) of .250 wire springs with an ID of 1-3/4" at 33" long with standard ends:

 

((.250*1.75*33*$2.70)rounded)+0=$39.00*2=$78.00

 

Now along with all this, the weight for shipping will change. The springs above weigh far less than a single .625 wire with 6" ID at 20-1/2" long with ends in ($210.73, if you were curious).

 

I hope I have made sense and someone can help me out. I thank everyone in advance for any and all help suggested.

 

Christopher

Edited December 23, 2005 by ScreaminWeasel