Beauty Supply Store Inventory List

Run a beauty supply shop: products with margins and reorder alerts, suppliers, and restock orders in one place.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Salon

Tables

Products, Suppliers, Restock Orders

Fields

33

Views

grid, cards, dashboard, kanban, calendar

Tables, columns and sample rows

The 3 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Products

15 fields · 7 sample rows

  • All products (Grid)
  • Gallery (Cards)
  • Stock overview (Dashboard)
ProductTextSKUTextBrandTextCategorySingle selectSupplierLink to another tableUnit costCurrencyRetail priceCurrencyIn stockNumberReorder levelNumberMarginFormulaStock valueFormulaStock statusFormulaRestock ordersLink to another tableUnits on orderRollupPhotoAttachment
Argan Oil Hair Serum 100mlHC-1021Moroccan GoldHair careGlowSource Distributors₹320₹699421554%₹13,440OK0
Keratin Shampoo 1LHC-1045SalonProHair careGlowSource Distributors₹540₹1,15081053%₹4,320ReorderPO-204124
Vitamin C Face SerumSC-2210DermalabSkin careMumbai Cosmetics Co.₹410₹899271254%₹11,070OKPO-203830
Matte Lipstick – RubyMU-3302Velvet KissMakeupMumbai Cosmetics Co.₹180₹44902060%₹0Out of stockPO-204260
Gel Polish Set (12 shades)NL-4108NailArt StudioNailsSeoul Beauty Imports₹1,250₹2,49914550%₹17,500OKPO-204310
Ceramic Flat IronTL-5011StyleMaxToolsSeoul Beauty Imports₹1,800₹3,4996449%₹10,800OK0
Rose Oud Eau de ParfumFR-6003Attar HouseFragranceMumbai Cosmetics Co.₹950₹2,19911657%₹10,450OK0
Field details
Product · Text
SKU · Text
Brand · Text
Category · Single select
Hair care, Skin care, Makeup, Nails, Tools, Fragrance
Supplier · Link to another table
Links to Suppliers
Unit cost · Currency
INR
Retail price · Currency
INR
In stock · Number
Reorder level · Number
Margin · Formula
IF({Retail price} > 0, ({Retail price} - {Unit cost}) / {Retail price}, BLANK())
Stock value · Formula
{In stock} * {Unit cost}
Stock status · Formula
IF({In stock} = 0, 'Out of stock', IF({In stock} <= {Reorder level}, 'Reorder', 'OK'))
Restock orders · Link to another table
Links to Restock Orders
Units on order · Rollup
sum of Quantity via Restock orders
Photo · Attachment

Suppliers

10 fields · 3 sample rows

  • Suppliers (Grid)
SupplierTextContact personTextEmailEmailPhonePhoneCityTextLead time (days)NumberPayment termsSingle selectProductsLink to another tableProduct countCountNotesLong text
GlowSource DistributorsRohit Malhotra[email protected]+91 98110 45231Delhi5Net 30Argan Oil Hair Serum 100ml, Keratin Shampoo 1L2
Mumbai Cosmetics Co.Fatima Shaikh[email protected]+91 99200 18764Mumbai3Net 15Vitamin C Face Serum, Matte Lipstick – Ruby, Rose Oud Eau de Parfum3
Seoul Beauty ImportsJi-woo Park[email protected]+82 2 555 0142Seoul21AdvanceGel Polish Set (12 shades), Ceramic Flat Iron2Minimum order ₹50,000. Ships via Chennai port.
Field details
Supplier · Text
Contact person · Text
Email · Email
Phone · Phone
City · Text
Lead time (days) · Number
Payment terms · Single select
Advance, Net 15, Net 30, Net 45
Products · Link to another table
Links to Products
Product count · Count
Notes · Long text

Restock Orders

8 fields · 4 sample rows

  • Orders (Grid)
  • Pipeline (Kanban)
  • Deliveries (Calendar)
PO numberTextProductLink to another tableQuantityNumberUnit costCurrencyOrder totalFormulaOrdered onDateExpected onDateStatusSingle select
PO-2041Keratin Shampoo 1L24₹540₹12,96017 Nov 202622 Nov 2026Ordered
PO-2042Matte Lipstick – Ruby60₹175₹10,50015 Nov 202620 Nov 2026Shipped
PO-2038Vitamin C Face Serum30₹410₹12,3007 Nov 202610 Nov 2026Received
PO-2043Gel Polish Set (12 shades)10₹1,250₹12,50014 Dec 2026Draft
Field details
PO number · Text
Product · Link to another table
Links to Products
Quantity · Number
Unit cost · Currency
INR
Order total · Formula
{Quantity} * {Unit cost}
Ordered on · Date
Expected on · Date
Status · Single select
Draft, Ordered, Shipped, Received, Cancelled

Beauty Supply Store Inventory List: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates