Discount on Qty Based on Unique Item

I need help creating a discount on based qty entered or updated on cart. And I only want to target certain items with a type of category. I have tried following instructions that are in forum but i don't think that would work for me.

Can you give me more specifics about the discount. I feel like you want specific instructions on how to implement it, so I need a really specific description of what you are trying to do.

Thanks for your prompt response, here is the link of beta page I'm working with (private area). Please don't go through checkout process i just have the add to card and update functions working.

You will notice when you add the product to cart it will bring up some add-on options.

Now if i add an item that is not an add-on option I would like the discount to show only on products not add-on items.

The discounts will be given on qty 25, 50,75, 100 so if the client adds or updates a qty of a specific product if they reach the qty stated a discount will be applied.

Is it a standard % based discount, or a new fixed price based on the quantity?

There are basically two ways to do this. You can either update the cart to store all of the information to do the discounting and do complex calculations in the cart to figure out the correct price... or you can use a recordset to store quantity discounts and calculate and update the price column as it is in the eCart.

The technique I suggest usually depends on the complexity and consistency of the discounts. If products have different discounts, different breakpoints for discounts, different number of breakpoints, etc. then the Recordset method is easier because it is more flexible. If you are doing regular % based discounts based on fixed break points, then doing a calculation in the cart is easier so you don't have to create recordsets and update the shopping cart from it manually on the cart page when someone updates a quantity.

Ray,

I am using recordset discount, how should i approach this?

You would add the recordset to the page with the add to cart button that filters based on the product and quantity and use the filtered recordset to set the price.

The easiest fix is to then not allow quantity update on the add to cart page so that they would have to remove and add again from the add to cart page to change quantity.

In order to allow quantity update you would have to manually code a loop when the cart is updated that would check the database and update the quantity when necessary. We could help with this in a premier ticket if you have trouble with the hand coding.

will do.

Jay,

I just found out from my client that the discount will be a global discount for all products. what would be the way to approach this. And i still don't want the discount applied to any of the add-on item. Please advise.

Is it % based? What are the specifics?

Yes its percentage based