DATABASELIVESupabase connected
SA
Sonani AdminAdmin
PRICING DATA FOUNDATION

Pricing

Maintain rate masters and pricing rules. Calculation engine will be connected separately.

Data setup only Metal, labour, diamond, stone, markups, other charges and buyback policies are stored here. No final jewellery-price formula is applied in this version.

Metal Rates

Country-wise 24KT price and buyback rate per gram.

All prices are maintained as 24KT base rates. KT conversion belongs to the future pricing engine.
MetalPrice (24 KT)Buy Back Price (24 KT)Record Ref
Select a country.

Labour Pricing

Country + Labour Category + Metal wise channel rates.

Metal TypeTypeBase Labour PriceWebsite Selling PriceMarketplace PriceWholesale PriceHO PriceFranchise Store PriceShop in Shop PriceIndividual Seller PriceRecord Ref
Select Country and Labour Category.

Diamond Rates

Country + Shape + Color + Clarity + Size wise base diamond rate.

Select Country and Shape.

Stone Rates

Stone base rates by country, stone markup category, stone type, shape, color and size.

Rate Type: —
ColorSizeValueRecord Ref
Select pricing context.

Price Markup

Price and carat slabs with channel-wise markup percentages.

ActionRecord RefStatusFrom PriceTo PriceFrom CaratTo CaratWebsite %Marketplace %Wholesale %Own Store %Franchise %Shop in Shop %Individual Seller %Updated ByUpdated At

Stone Price Markup

Stone clarity/size rules with channel-wise markup percentages.

ActionRecord RefStatusStone ClarityStone SizeWebsite %Marketplace %Wholesale %Own Store %Franchise %Shop in Shop %Individual Seller %Updated ByUpdated At

Other Charges

Category-wise Base Diamond Amount slabs and channel-specific charge values.

ActionRecord RefStatusFrom Base Dia. Amt.To Base Dia. Amt.RemarkUpdated ByUpdated At

Buyback & Exchange

Global policy percentages and discount-deduction switches.

Reference screen does not show Country here, so v36 stores Buyback & Exchange as global policies. The pricing engine can be extended later if country-wise policy is required.
ActionRecord RefStatusPolicy TypeMetal %Labour %Diamond %Stone %Other Charge %Deduct Diamond DiscountDeduct Stone DiscountDeduct Labour DiscountDeduct Flat DiscountUpdated ByUpdated At