Guest Posted April 22, 2003 Share Posted April 22, 2003 I've been thinking about all of the different ways to give customers discounts to determine how I want to do it and I've come up with something that may be worth discussing. If nothing else this thread may serve to give new people a starting point to decide which kinds of discounts they want to offer and how to achieve them. I know that there have been some mods that do one or more of the methodologies listed below but this might be an opportunity to identify which mods use which methodology. Of course, there are probably other methodologies that aren't listed here. Just add them to the thread. Especially if there's a mod that addresses it. BTW, I used the code tag to preserve the indents to make it easier to read. Hope this helps. Discount methodologies 1) Flat percentage discount on entire order Applied before calculation of taxes and shipping 2) Dollar value discount (such as a gift card) A specific dollar amount Applied before calculation of taxes and shipping 3) Dollar value discount at a specific sales level (such as a coupon code) A specific dollar amount if total reaches a given level Ex: $5 off $25 order, $25 off $75 order, etc. May or may not be "stackable" at admin's discretion Applied before calculation of taxes and shipping 4) Progressive percentage discount Based on value of sale Ex: Total mdse > $50 earns 5% discount, > $100 earns 10% discount, > $200 earns 15% discount Should be easy to turn on/off all or individual discounts Should be easy to change both levels and percentages. Applied before calculation of taxes and shipping 5) Progressive dollar value discount Based on value of sale Ex: Total mdse > $50 earns $5 discount, > $100 earns $15 discount, > $200 earns $25 discount Should be easy to turn on/off all or individual discounts Should be easy to change both levels and discount. Applied before calculation of taxes and shipping 6) Progressive quantity percentage discount Based on quantity of items sold (any product) Ex: Total items > 10 earns 5% discount, > 50 earns 7% discount, > 100 earns 10% discount Should be easy to turn on/off all or individual discounts Should be easy to change both levels and percentages. Applied before calculation of taxes and shipping 7) Progressive quantity percentage discount Based on quantity of items sold (single product) Ex: Total items of a specific product > 10 earns 5% discount, > 50 earns 7% discount, > 100 earns 10% discount Should be easy to turn on/off all or individual product discounts Should be easy to change both levels and percentages. Applied before calculation of taxes and shipping 8) Progressive quantity dollar value discount Based on quantity of items sold (single product) Ex: Total items of a specific product = (qty 1) $10, > 10 drops to $9.25 ea, > 20 drops to $8.50 ea, > 100 drops to $7.75 ea Should be easy to turn on/off all or individual product discounts Should be easy to change both levels and discount. Applied before calculation of taxes and shipping 9) Progressive quantity dollar value discount Based on quantity of items sold (single category of products) Ex: Total items of a specific kind of product (say, any T-Shirt) = (qty 1) $10, > 10 drops to $9.25 ea, > 20 drops to $8.50 ea, > 100 drops to $7.75 ea Would probably require that all products in category be the same base price. Should be easy to turn on/off all or individual discounts Should be easy to change both levels and percentages. Applied before calculation of taxes and shipping (may be combined with other discount types such as the coupon code example above which would require this discount to happen first, right?) 10) Members special pricing discount Members have a separate price sheet for all products Ex: Regular price = $17.99 Member price = $16.49 Member prices are not necessarily a uniform dollar value discount or uniform percentage discount. 11) Members uniform percentage discount Members get a uniform percentage for all products Ex: Regular price = $17.99 Member price (less 10%) = $16.19 Then there's also shipping discounts Ex: free shipping for orders over $75 which would require this discount to happen last or Ex: coupon code for free shipping And if that's not enough there's the idea of giving or not giving discounts on products on sale. Whew! So what has been done to address any of these methodologies? Link to comment Share on other sites More sharing options...
Guest Posted April 23, 2003 Share Posted April 23, 2003 This is a subject that has concerned me greatly, and is something I believe needs to be addressed in a future production release of OSC. I am new to PHP and in fact I only discoverd OSC recently. I like the concept, and I plan to use OSC for my own website. :idea: My experience is with dbase/foxbase/clipper, but that was 10 years ago and I'm a bit on the rusty side now. I used to write code using a macro variable function where I could write code into a field of a table that would execute whenever that product was accessed. This code could look up a table to find what sort of customer this was (eg trade or retail), shipping costs, cost, almost anything. At a very basic level you could have a case statement for qty=x1, discount=y1; qty=x2, discount=y2; qty=x3, discount=y3. The formula could be applied at the category level which would filter down to the sub-categories and products by default, but individual sub-categories and/or products could have their own formula to override the parent formula. One advantage of this approach is that the discount methods employed are up to the creativity of the store owner. Formulas could be written and distributed via the contributions posts and the storeowner only has to cut and paste the code into his table. No matter how discounts are coded into OSC, someone will want something different. I am trying to come up to speed with PHP (and surprised at how similar the code is), but I still haven't worked out if what I am talking about is even possible. Anybody out there want to offer an opinion :?: Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.