close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

eCart Fixed Price Quantity Discount

Thread began 11/14/2011 3:40 pm by mywebassist220499 | Last modified 11/14/2011 11:59 pm by mywebassist220499 | 647 views | 5 replies |

mywebassist220499

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

Sign in to reply to this post

sam308940

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.

Sign in to reply to this post

sam308940

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.

Sign in to reply to this post

mywebassist220499

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

Sign in to reply to this post

sam308940

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

Sign in to reply to this post

mywebassist220499

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

Sign in to reply to this post

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

Content

rating

Layout

rating

Ease of use

rating

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...