eCart Fixed Price Quantity Discount

My online store sells products categorized into 3 item types. The prices for particular items varies within each of those 3 item types.

I would like to offer a discount that would be:

When someone orders a total of 10 different products of item type 1, they get those 10 products for $50 – in essecnce discounting each product (prices vary) down to $5

I would also be OK if it applied the fixed $5 price to > 10 products of item type 1.

Would really appreciate some help on this.

Thanks,
David

hi,

is the type of the item a column in the cart?
if so, i think you can just do a discount like:
- number of items with a specific column value
if the total number of items where "product type column"
has a value of "type 1" (whatever type 1 from your description)
and you want it to be > 9.

then at the bottom, the calculation would be
"based on items with a specific value"
total of "product type column" where the "product type column" has a value of "type 1" times (the discount amount per item).

describing better:
if i have product-type column, and the type=shirts, price is 10 with a discount of $2 per shirt if they buy 10, this would read as:
number of items with a specific column value
if the total number of items where "product-type"
has a value of "shirts" is > 9

at the bottom
"based on items with a specific value"
total of "product-type" where the "product-type" has a value of "shirts" times 2.


hope that this works for you.

just re-read your post, and realized the prices vary, so the discount would vary. oops.

how about this for the bottom of the discount rule:
based on items with specific value
total of PRICE where PRODUCT-TYPE has a vlaue of TYPE1 minus 50.

so - it the total of the price column for the 10 items that are TYPE1 is $96, then minus $50 would make the discount $46 - thus leaving the customer payng the $50.

problem is this will only work for 10 items.
11 items would cause chaos because they would get 11 for $50 too.

Another idea would be to make the shirts FREE and then adding a CHARGE.
so the bottom rule would be
based on items with specific value
Total of PRICE where PRODUCT-TYPE has a value of TYPE1, times 1.
(this is giving the total price of TYPE1 products as a discount)

then add a charge rule that is
based on the nubmer of items with a specific column value
if the total number of items where PRODUCT-TYPE has a value of TYPE1 is > 9
and the bottom:
based on items with a specific value
total of QUANTITY where PRODUCT-TYPE has a value of TYPE1 times 5.

this idea will give any quantity 10+ for $5 each.
but its too bad it would have to show up as a discount and a charge.

LAST IDEA
you could hand code some of this. the only PITA is that if you hand code it, it could get overwritten anytime you open up your ecart editor wizard. i have handcoded a variety of the coupons that i couldnt get the wizard to create.

Hi Sam,

I understand what you're describing but that's based on every item type having the same price and then giving a discount off that price if the order hits the quantity.

What I'm trying to do though is a little different.

The store has 3 item category types:
Type1
Type2
Type3

There are multiple products within each of those types at varying prices. For instance:
Type1 - Cool T-shirt Design 1 - Price 14.95
Type1 - Cool T-shirt Design 2 - Price 12.95
Type2 - Beans - Price 1.99
Type2 - Bread - Price 1.79
Type3 - Paperweight - Price 5.99
Type3 - Brick - Price 3.99

I want to run a discount where if someone buys x number of Type3 items, they are 8.00 each.

So deducting a set amount (2 in your example) is not going to work.

Appreciate the input though!
Thanks,
David

did you read the 2nd message i posted?
there are 2 ideas in there, OR, i can help you hand code it.

Hi Sam,

No, didn't see your 2nd post. Maybe we were both posting at the same time. I think I have it figured out though by adding some Calculations on the Calculations Tab. With this, an order of 10 or more items with an itemType of 1 will discount them to where each item costs only $10.

Name - Forumla - Type
---------------------
//this is the amount each item will cost for the promo
FixedPrice - 10 - Number

//The amount to be deducted from each item
FPDiscount - [Price] - [FixedPrice] - Number

//The total discount for each line item
TotalDiscount - [FPDiscount] * [Quantity] - Number

Then on the Discount Tab:
Trigger:
Number of items with itemType of 1 >= 10

Calculation (my options are between the pipes:
|Based on items with a specific value|
Total of |TotalDiscount| where |itemType| has a value of |1| |Times| |1|

Initial testing seems to work. Now I need to make sure it doesn't break. It does give the discount on a quantity of 10 or more which will work for me.

If anyone has a better idea, would love to hear it.

Thanks Sam!

-David