Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 1 of 2
Tiered Pricing by Percentage
 
Isaac Joerger
Jr. Member
 
Total Posts:  5
Joined:  2007-09-05
 

For large stores with similar products and quantity discounts having an option to set tiered pricing as a percentage discount, rather than having to enter the new static price for each tier every time a price change goes into effect, would save a massive amount of time.  The store-front should then have the option to display the discounts available as a percentage off or to show the calculated the price for that tier.

 
Magento Community Magento Community
Magento Community
Magento Community
 
WisdOMbooks
Sr. Member
 
Avatar
Total Posts:  144
Joined:  2007-08-31
Kolkata (Calcutta) - INDIA
 

Adding to it some kind of mechanism to automatize a rounding of the result
to a choosable number (upto next decimal, upto next unit number, etc.).

Otherwise one may get a calculated percentage, resulting in such strange prices, as
$ 31.437689 or, worst, $ 0.9764032, which, of curse, would be prettier as
$ 31.5 (or even $31) and just $1.

 
Magento Community Magento Community
Magento Community
Magento Community
 
YoavKutner
Guru
 
Avatar
Total Posts:  491
Joined:  2007-08-08
 

cabz - We were actually considering it and might add percentage tire pricing in the near feature.

WisdOMbooks - Since we round to 2 decimal places for prices I don’t think it will look that bad (especially when it comes to discounts customers are not that picky grin).

 
Magento Community Magento Community
Magento Community
Magento Community
 
WisdOMbooks
Sr. Member
 
Avatar
Total Posts:  144
Joined:  2007-08-31
Kolkata (Calcutta) - INDIA
 
YoavKutner - 05 September 2007 05:03 PM

WisdOMbooks - Since we round to 2 decimal places for prices
I don’t think it will look that bad (especially when it comes to discounts customers are not that picky grin).


The criteria for rounding should be left to the final user, if possible.

2 decimals rounding may sound fine for *strong* currencies, like U$D, UKP or Euros
but people with *weaker* currencies may not need decimal rounding at all
and will definitvely prefer rounding upto the unit level:
ex.: no point to write INdian Rupees 548.73:
549.00 or, as they write here in India, 549/-, will do much better.

Also VERY important:
the choice to put the currency symbol at the left AND/OR at the right of the actual digits
should also be left to the final user, since different currencies have different requirements on this.

I say AND/OR because in certain currencies the need may arise to keep symbol in both the sides.
Again, as an ex.:  INdian RUpees want
on the left of the digits the symbol Rs. and
on the right the symbol /- to specify NO DECIMALs,
which are only bothersome in a currency with an equivalency of 41 Rs = 1 U$D !

Just some food for thought for the Magento *financial programmers* grin

 
Magento Community Magento Community
Magento Community
Magento Community
 
Tweakmag
Guru
 
Avatar
Total Posts:  307
Joined:  2007-08-31
London, UK
 

Hi WisdOMbooks - you can control the symbol location very easily in the database. smile

Adam

 
Magento Community Magento Community
Magento Community
Magento Community
 
WisdOMbooks
Sr. Member
 
Avatar
Total Posts:  144
Joined:  2007-08-31
Kolkata (Calcutta) - INDIA
 
Ajazza - 07 September 2007 01:39 PM

Hi WisdOMbooks - you can control the symbol location very easily in the database. smile

Forgive my ignorance, since I have not yet been able to install Magento on my localhost:
where exactly in the database?

The point of the user-side control of rounding of currencies still pending...

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brandon
Sr. Member
 
Avatar
Total Posts:  76
Joined:  2007-08-31
Web Developer
 

I nice way to do this would be the ability to list a couple quantities and their price points, and then have a wildcard character that sets the pattern for the rest.  I attached an example screen from a shipping module I use in another shopping cart.

To explain it, this is for a shipping module that allows me to specify price points for certain shipping methods.  The first column is the ceiling (maximum qualifying order total), the second column is the chard and the third column determines if it is a flat charge ($) or a percentage of the order (eg. 10%).
This could be adapted to our case by making the first column Max. Quantity, the second column would be the price/ea. and the third column could be used to determine if it’s a % based on the base item price/ea.

Image Attachments
Untitled-1.jpg
 
Magento Community Magento Community
Magento Community
Magento Community
 
Tweakmag
Guru
 
Avatar
Total Posts:  307
Joined:  2007-08-31
London, UK
 

@WisdOMbooks

The table you need to look at is ‘directory_currency_name’
and the field ‘output_format’ in particular

examples:

$%s USD
$USD%s

basically you can change it however you like, just make sure you leave %s there somewhere as that is where the numerical value will go.

Cheers
Adam

 
Magento Community Magento Community
Magento Community
Magento Community
 
WisdOMbooks
Sr. Member
 
Avatar
Total Posts:  144
Joined:  2007-08-31
Kolkata (Calcutta) - INDIA
 
Ajazza - 07 September 2007 04:15 PM

The table you need to look at is ‘directory_currency_name’ and the field ‘output_format’ in particular

Thank you, Adam/Ajazza, for the ‘address’.

This facility, though, should be available upfront,
without forcing a dig into the database,
which can be quite dangerous for most of the people,
apart those few who are more technically-enclined.

 
Magento Community Magento Community
Magento Community
Magento Community
 
vernlib
Jr. Member
 
Total Posts:  15
Joined:  2009-01-19
 

YoavKutner - any progress made on adding tiered pricing by percentage? Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
mweather
Member
 
Total Posts:  33
Joined:  2007-08-31
 

I also need this feature.  In our current cart we currently have several discount levels based on customer groups, but allow the lower discount customer groups to get the larger discount if they order over $X.

It doesn’t happen often (if they regularly ordered over $X, we’d permanently set their discount to the next higher tier), so I’ve just left that feature out of our Magento install and told our wholesale customers at that pricing tier to call in large orders, but I’d really like this feature to be in Magento.

 
Magento Community Magento Community
Magento Community
Magento Community
 
EmmaWells
Jr. Member
 
Avatar
Total Posts:  8
Joined:  2009-04-05
Belfast City
 

I really want this feature. If there is any extension has this function, please let me know.

 
Magento Community Magento Community
Magento Community
Magento Community
 
back2007
Member
 
Total Posts:  59
Joined:  2009-03-30
 

There is a nice mod by AdjustWare:  http://adjustware.com/2009/04/percent-tiered-pricing-extension-released/

 
Magento Community Magento Community
Magento Community
Magento Community
 
Anna Varmon
Jr. Member
 
Avatar
Total Posts:  27
Joined:  2009-04-15
 

Hi, AdjustWare.  Does your extension work well with multiple currencies?

 
Magento Community Magento Community
Magento Community
Magento Community
 
back2007
Member
 
Total Posts:  59
Joined:  2009-03-30
 

I wonder if it is possible to create tier pricing templates, so that I can use the same tier pricing pattern for several products

 
Magento Community Magento Community
Magento Community
Magento Community
 
pete_uk
Member
 
Total Posts:  33
Joined:  2009-02-10
 

Does it let you apply the tier prices in bulk, for example to all the products in your store without doing it manually?
Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 1 of 2