Sorry about the lack of data, I'll try to outline the clients requirement more clearly without too much unnecessary data.
There are 200 different medical drill bits of four different types.
Namely - Sterile Short, Sterile Long, Non-Sterile Short, Non-Sterile Long
Each type has 60 bits sized from 1mm to 6mm (1mm, 1.1mm, 1.2mm, 1.3mm, etc. )
The drills are priced by type, the four types have discount schedules based on the same quantity break point but with different discount prices per break point.
Quantity discounts are provided per individual drill bit order quantity, based on a particular drill bit size, quantity and type as added to the cart, not on the total order value or total items quantity in the cart.
e.g.
A typical order might be:
1.6mm diameter | Type 1: Sterile Short | Quantity 200 | Base Price $21.40 | Total $4280.00
1.8mm diameter | Type 1: Sterile Short | Quantity 800 | Base Price $21.40 | Total $17,120.00
1.2mm diameter | Type 2: Sterile Long | Quantity 90 | Base Price $23.00 | Total $2070.00
2.2mm diameter | Type 3: Non-Sterile Short | Quantity 2200 | Base Price $17.00 | Total $37,400.00
1.2mm diameter | Type 4: Non-Sterile Long | Quantity 600 | Base Price $17.00 | Total $10,200.00
Sub Total of Order $71,070.00
Schedule of Discounts and Quantity Break Points Per Drill:
Drill Type 1:
1 to <100 - $0.00, >=100 to <500 - $2.50, >=500 to <1000 - $3.90, >=1000 to <4000 - $5.00, etc.......
Drill Type 2:
1 to <100 - $0.00, >=100 to <500 - $3.30, >=500 to <1000 - $5.00, >=1000 to <4000 - $6.00, etc.......
Drill Type 3:
1 to <100 - $0.00, >=100 to <500 - $1.50, >=500 to <1000 - $2.50, >=1000 to <4000 - $3.00, etc.......
Drill Type 4:
1 to <100 - $0.00, >=100 to <500 - $1.50, >=500 to <1000 - $3.00, >=1000 to <4000 - $3.30, etc.......
So based on the discount schedule above, the discounts in the cart will be:
Type 1: 200 @ $2.50 = $500
Type 1: 800 @ $3.90 = $3120.00
Type 2: 90 @ $0.00 = $0.00
Type 3: 2200 @ $3.00 = $6600.00
Type 4: 600 @ $3.00 = $1800.00
Total Discounts $12,020.00
In the drill bit database (items), as well as diameter, name, base price, etc., I have placed a "type" integer for each drill so that the the correct discount can be applied based on quantity and type. Namely "PriceCategory" (see previous code example)
I can see that the existing system, as indicated earlier, works where the Drill Bit "ID" is specified in the discount and calculation formulas, however it is impractical to write a discount formula for each drill bit ID.
(See attached screen capture)
This is where I thought that perhaps the ID for the discount and calculation formula could be obtained from the Session data in cart.php, belonging to the individual cart addition, as I see by using "PHP show session data", that the "ID" and "PriceCategory" of each cart addition is there. (Session Data based on ID pasted below & attached cart image.)
I really appreciate your help on this, I can usually figure things out but this has me stumped. As you will have guessed, I am not trained coder.
I hope the above information is sufficient to ascertain if this can be achieved successfully with your eCart.
Session Data FYI:
Array ( [VisitorID] => 2 [VisitorFirstName] => Bob [VisitorLastName] => Smith [VisitorUserName] => Customer [VisitorPassword] => 3cust21 [userLevel] => 2 [CingleCart_Items] => 20|WAECART|Short AO Connect|WAECART|1.0mm x 50mm|WAECART||WAECART|0|WAECART|200|WAECART|21.4|WAECART|1|WAECART|10050455AOS|WAECART|Sterile|WAECART|1|WAECART|0|WAECART|4280|WAECART|200 Short AO Connect (20)|WAECART|500|WAECART|660�26|WAECART|Long AO Connect|WAECART|1.0mm x 110mm|WAECART||WAECART|0|WAECART|120|WAECART|23|WAECART|1|WAECART|10110455AOS|WAECART|Sterile|WAECART|2|WAECART|0|WAECART|2760|WAECART|120 Long AO Connect (26)|WAECART|300|WAECART|396 [WAEC_ContinueRedirect] => /CingleBit/order2.php?ItemCatID=4 )
