2022-04-24
63883
30
4186
1 minutes.


How to make prices end with 9

Psychological pricing is a marketing method based on the theory that certain prices have a psychological impact.

Schindler & Kibarian (1996) tested "odd" prices using three versions of a direct mail catalog for women's clothing. The catalogs were identical except for prices that ended in 00, 99, or 88. Using the version with prices ending in 99 resulted in an 8% increase in sales and more customers compared to the version with prices ending in 00. Using the catalog with price endings 88 resulted in sales and customer numbers similar to using the version with zero price endings.

Formula:
IF({Price list: Price}>0, CONCAT(LEFT(REPLACE({Price list: Price}, '. 00000000', ''), LENGTH(REPLACE({Price list: Price}, '. 00000000 ', '')) -1),'9'), 0)
elbuz etrade jumper pricelist formula
Check the order in which the transactions are applied so that the formulas are applied after the revaluation transaction
elbuz etrade jumper pricelist formula
Price before applying the formula

Price after applying the formula


Another option is to round prices to 90 at the end. For example prices
5200 > 5190
5250 > 5290

Formula:
IF(RIGHT(pp. price, LENGTH(pp. price)-2)='00', pp. price-10, if(ABS(90-RIGHT(pp. price, LENGTH(pp. price)-2)) < 50, TRUNCATE(pp. price, -2)+90, TRUNCATE(pp. price, -2)-10))

Prices in multiples
For example, you need all product prices to end with 5. Use this mathematical calculation with rounding
FLOOR(({Price list: RRP price} + 5 - 0. 01) / 5) * 5
where 5 is the multiplicity value


Online store platform


 

Copywriter ElbuzGroup


Save a link to this article


Next