Free tool

A perfume price list: each scent with its size and concentration.

One scent is sold in several sizes, and the concentration changes both price and lasting power: eau de parfum is not eau de toilette. A customer asking the price means a particular size. So this template adds the bottle size in ml and the concentration, with each size on its own line. It has sample rows with descriptive names and no brands, and the prices are blank.

Sample rows: Perfume shops

Examples only; prices are blank for you to fill.

ItemSize (ml)ConcentrationCostSale price
Women's floral scent50Eau de parfum
Women's floral scent100Eau de parfum
Men's woody scent100Eau de toilette
Oriental scent50Parfum extract
Oud oil12Perfume oil
White musk12Perfume oil
Body mist250Light mist
Fresh citrus scent100Eau de cologne
Scented incense50Pieces

Download

Plain files with no macros; they work in Excel, Google Sheets and LibreOffice.

Common questions

Does each size get its own line?

Yes, because price does not scale evenly with size: the large bottle is usually cheaper per ml. With a line per size the customer sees the options and compares them himself.

Which concentrations should I list?

Write what is printed on the bottle: parfum extract, eau de parfum, eau de toilette, eau de cologne. A higher concentration usually lasts longer and costs more, which is what the customer is asking about.

Can I sell scent loose by ml?

Yes, enter size 1 ml and the price per ml, then work the total from the amount sold. Keep it on its own line so it does not mix with sealed bottle prices.

More free tools

Dashing does this for every item, automatically, in your shop.

Start freeAll features