close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Discount on Quantity of Individual items

Thread began 5/17/2011 3:53 am by enquiry272230 | Last modified 5/20/2011 10:24 am by enquiry272230 | 1868 views | 10 replies


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.

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&#65533;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 )

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...