Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
Forum Search
Google Site Search
 All Forums
 Technical
 PHP (Unix / Linux / Apache) versions
 Quantity Discounts with ALT IDs
Author « Topic »  

Marshall
Ecommerce Template Guru

USA
1979 Posts

Posted - 02/19/2026 :  04:52:10  
Does the Quantity Discount work when you have ALT IDs for a product as each ALT ID would have its own discount table? And if so, would the discount table that is displayed change when different ALT IDs are selected?

Marshall
CENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com

Phil
ECT Moderator

United Kingdom
7824 Posts

Posted - 02/19/2026 :  07:26:22  
I've not tried it, but if you're using the ALT ID's with options, the quantity discounts should work, but the discount table only displays on the product that has quantity discounts assigned to it, and the ALT ID products are set to not display, so I would imagine you're not going to see the discount table



*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Edited by - Phil on 02/19/2026 07:26:49

Marshall
Ecommerce Template Guru

USA
1979 Posts

Posted - 02/19/2026 :  10:30:55  
They are products that come, mostly, in two sizes. The smaller size is the default setting when you open the page, but obviously you can choose the large size. The options menu uses Options/Alternates, not Options/Values or Dependent Options. That being the case, the price and image are in the ALT ID and so would be the quantity pricing. Guess I will have to test it.

Marshall
CENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com

Marshall
Ecommerce Template Guru

USA
1979 Posts

Posted - 02/21/2026 :  06:25:45  
Test results.

The Quantity Pricing does work with ALT IDs, but there is a catch.

The Test: a parent product with no pricing and ALT IDs with pricing, Option/Alternates in the options, and a percentage discount here is what happens.

If you put the Quantify Pricing in the parent, the discount will apply when you click Add To Cart. However, if you set the Quantity Pricing table to display, the Quantity Pricing will all read $0.00 since there is no price in the parent product.

If you put the Quantity Pricing in the ALT ID, in which case you can use dollars amounts instead of percentages, the Quantity Pricing table will not display, but the Quantity Pricing will be applied when you Add To Cart.

The work around for the missing Quantity Pricing table is use a custom field inserted above or below the price with text to the effect:
"Purchase 3-6, receive 5% off. Purchase 7+, receive 10% off." (or whatever is applicable)

If you are using a specific dollar Quantity Pricing, your text will have to be longer and your Quantity Pricing will have to be entered in the ALT IDs, e.g.
"Small Size: Purchase 3-6 receive $5.00 off. Purchase 7+ receive $10.00 off.
Large Size" Purchase 3-6 receive $15.00 off. Purchase 7+ receive $20.00 off." (again, whatever is applicable)

Using the custom field is not ideal if you have a lot of Quantity Pricing discounts, but it does work. And being a custom field, you can enter the information via a CSV upload.

I did not test this using Options/Values, but I suspect it probably would not work.

In time, I am sure Vince can come up with a solution

Hope this helps.

Marshall
CENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com

Vince
Administrator

43347 Posts

Posted - 02/23/2026 :  01:52:58  
Hi Marshall
This is quite a complicated issue for so early on a Monday morning. But how are you hoping this should work? For instance, it sounds a bit like what we need is for the quantity pricing to reflect what the pricing is for the product options rather than the parent product, and that would mean that it would have to change per option, no?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Phil
ECT Moderator

United Kingdom
7824 Posts

Posted - 02/23/2026 :  02:58:19  
I think the ultimate goal is for the quantity pricing table to display per option as well to reflect the pricing structure per Alt ID, which is quite a task



*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Marshall
Ecommerce Template Guru

USA
1979 Posts

Posted - 02/23/2026 :  05:05:48  
Hi Vince and Phil,

My thought is, when using ALT IDs, you would enter the Quantity Pricing pricing in the ALT ID, not the parent product, and when you select the different options, the table would appear and reflect the different discounts just like the price displayed changes when you select the different options. I know it seems like a herculean task, but what's life without a challenge

Honestly though, it is not that critical an issue, just something to think about as the Quantity Pricing does work the way I described, it would just be nice if the cart automatically displayed the changes rather than having to put up some announcement manually.

Marshall
CENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com

Phil
ECT Moderator

United Kingdom
7824 Posts

Posted - 02/23/2026 :  07:27:59  
quote:
The work around for the missing Quantity Pricing table is use a custom field inserted above or below the price with text to the effect:
"Purchase 3-6, receive 5% off. Purchase 7+, receive 10% off." (or whatever is applicable)


What about adding that information to the option mouse over info icon pop ups?



*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Marshall
Ecommerce Template Guru

USA
1979 Posts

Posted - 02/23/2026 :  07:59:39  
Good idea, but I think it is better if people to immediately see the available Quantity Pricing without having to put any effort into it. That said, for now the issue is somewhat moot as the site that brought up the issue of Quantity Pricing changed their mind, for now. Still, it is an interesting problem.

Marshall
CENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com

dbdave
ECT Moderator

USA
10683 Posts

Posted - 02/23/2026 :  15:10:06  
Are you talking about the quantity pricing changing with the selection of options, like this - iink removed ?
Try the link to add laser engraving and you will see the quantity pricing change.

David

Edited by - dbdave on 02/24/2026 07:48:20

Marshall
Ecommerce Template Guru

USA
1979 Posts

Posted - 02/24/2026 :  03:41:11  
Similar to that, but you would be switching from selecting between a small or large size, not adding an option to an item.

Marshall
CENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com

dbdave
ECT Moderator

USA
10683 Posts

Posted - 02/24/2026 :  11:48:13  
Hi Marshall, so it's still an option, but a drop down selection, or radio options?
Either way, I worked this out with javascript, and it works with all option types.
Although this is not alt-product ID options, but may still work.

Thanks,
David

Marshall
Ecommerce Template Guru

USA
1979 Posts

Posted - 02/25/2026 :  06:07:08  
The site in question uses radio buttons. But as I said, it is no longer a concern as the site owner decided against the Quantity Pricing. I would be curious to see the script, though, and play with it. That said, I appreciate all your time and effort.

Marshall
CENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com

dbdave
ECT Moderator

USA
10683 Posts

Posted - 02/25/2026 :  09:29:06  
Ok, I am doing a query to get the product price (in .asp) but this is not hard to do with .php... the part in red there is where the price would go.
I also had to add some code when I started using affirm as the message broke this.
Here you go. It's been a while since I wrote this and while I think it's complete, I have not tested on another ect site.
Insert into proddetail before the closing </body> tag.

<script>
//QTY PRICE CHANGER
if (document.getElementsByClassName("detailqpprice")[0]) {
window.addEventListener('load',ffqtprice,false);
if(window.attachEvent){
window.attachEvent('onload',ffqtprice);}
$(".detailoption").change(ffqtpriceonchng);
function ffqtpriceonchng() {
ffqtprice ('changed');
}
function strippricing(prcng) {return Number(prcng.replace(/[^0-9\.-]+/g,""));}
function ffqtprice(howtrigrd) {
if (howtrigrd = 'changed') {
var baseprice = strippricing(document.getElementsByClassName("detailqpprice")[0].innerText);
} else {
var baseprice = Number(<%=prodpriceorigis%>);
}
//added due to affirm message being part of the price message
function getTextBeforeCharacter(str,char) {
if (char.includes("4 interest")) {
var charz = "4 interest";
} else if (char.includes("Pay")) {
var charz = "Pay";
} else if (char.includes("0%")) {
var charz = "0%";
}
const index = str.indexOf(charz);
if (index !== -1) {
return str.substring(0, index); // Extracts from index 0 up to (but not including) the character's index
} else {
return str; // Returns the original string if the character is not found
}
}
const currpricetoclean = document.getElementsByClassName("detailprice")[0].innerText;
const character = currpricetoclean;
const currpriceresult = getTextBeforeCharacter(currpricetoclean,character);
var currprice = strippricing(currpriceresult);
var pricediff = (currprice - baseprice);
if (pricediff !== 0){
var pricecells = document.getElementsByClassName("detailqpprice")
for(k = 0; k < pricecells.length; k++) {
var prciinngg = (strippricing(pricecells[k].innerText));
amttoadjust = (prciinngg + pricediff).toFixed(2);
document.getElementsByClassName("detailqpprice")[k].innerText = '$'+ amttoadjust ;
}}}}
</script>
  « Topic »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.03 seconds. Snitz Forums 2000