The master catalog lives in Notion.
Edits, deduplication, vendor links — all happen there. This page is the operating manual and a live hygiene check so you know what's out of shape.
📦 Master Database
Open in Notion ↗
Catalog · pricing · units · vendors
🏷 Vendors
Open in Notion ↗
Supplier directory · GST · payment terms
- 01
One row, one priced SKU.
Don't make a new row when something already exists. Always search first. If the same item appears at multiple prices, keep the most recent and delete the rest.
- 02
Unit Price is per Unit. Sheet materials are per sq ft.
A 4'×8' ACP sheet is 32 sq ft, a 5'×10' is 50 sq ft. So ₹95/sq ft = ₹3,040 per 4'×8' sheet. Fill Sheet Area (sq ft) on every sheet row — the work order tool uses it to compute total cost correctly.
- 03
Variants go in their own properties, not the title.
Don't: “Acrylic Clear 5mm Blue”, “Acrylic Clear 3mm Blue” — separate rows.Do: Item Name = “Acrylic Clear”, set Thickness, Brand, color in a property. One row per Item × Brand × Thickness combination.
- 04
Every row needs Category + Unit + Price.
A row without all three doesn't show up in the work-order tool's catalog search. If you're unsure of price, leave a placeholder of 0 and flag in Notes — better than a phantom row.
- 05
Every row gets one Vendor.
Pick the primary supplier. Backup vendors go in Recommendation Notes on the Vendor page, not as a second relation here. This keeps the rollup on Material Orders clean.
- 06
LED rows always state Type + Colour in Item Name.
“LED Strip 6mm Cool White 6500K”, not “LED Strip”. Production reads this on the work order — wrong colour installed is a costly mistake.
- 07
Movement count is sheets, not sq ft.
The number tracks physical sheets consumed across all projects — separate from the sq ft you typed in. Don't reconcile them.
Total items
586
Missing category
215
37% of catalog
Missing price
218
37% of catalog
Missing vendor
586
100% of catalog
By category
Duplicate clusters
87 clusters · 328 rows
Items sharing the same first 2 words. Some are real variants (different colors, thicknesses) — fix by moving the variant into Brand, Thickness, or Size. Others are true duplicates — keep one, delete the rest.
“ms pipe”
14 rows- M/S pipe 3 x 3— · no price · no vendor
- MS PIPE— · no price · no vendor
- MS pipe 20 sq— · no price · no vendor
- m/s pipe 38SQ— · no price · no vendor
- MS pipe 72 x 72 mmMS · ₹62.88/feet · no vendor
- m/s pipe 72 x 72MS · ₹58.65/feet · no vendor
- M/S PipeMS · ₹18.07/Running feet · no vendor
- M/S PipeMS · ₹41.95/Running feet · no vendor
- m/s PipeMS · ₹16.7/Running feet · no vendor
- m/s pipe 12”MS · no price · no vendor
- M/S Pipe 2 x 1MS · ₹25.69/Running feet · no vendor
- M/S Pipe 2 x 2MS · ₹46.89/Running feet · no vendor
- m/s PipeMS · ₹25.31/Running feet · no vendor
- M/S PipeMS · ₹62.75/Running feet · no vendor
“eco blue”
13 rows- Eco blue matt 637C— · no price · no vendor
- Eco blue matt bs702— · no price · no vendor
- eco blue matt 5/450— · no price · no vendor
- eco blue matt 539C— · no price · no vendor
- eco blue matt 539c— · no price · no vendor
- eco blue matt 5/206— · no price · no vendor
- eco blue matt 7451C— · no price · no vendor
- eco blue matt BS 774— · no price · no vendor
- eco blue matt2188CPaint · ₹2712//Liter · no vendor
- eco blue matt 7455Paint · ₹2712//Liter · no vendor
- ECO Blue Matt (RAL 5008)Paint · ₹2712//Liter · no vendor
- ECO Blue Matt (2756C)Paint · ₹2712//Liter · no vendor
- ECO blue matt (280C) Paint · ₹2712//Liter · no vendor
“aluminium sheet”
12 rows- Aluminium Sheet 3mm 8×4Aluminium · ₹310/sq ft · no vendor
- Aluminium Sheet 2.5mm 8×5Aluminium · ₹248/sq ft · no vendor
- Aluminium Sheet 2mm 8×4Aluminium · ₹225/sq ft · no vendor
- Aluminium Sheet 1.5mm 8×4Aluminium · ₹170/sq ft · no vendor
- Aluminium sheet 1mm 4ft x 8ft— · no price · no vendor
- Aluminium sheet 3mmAluminium · ₹277.59/sq ft · no vendor
- Aluminium sheet 2mm, 10x 5Aluminium · ₹171.25/sq ft · no vendor
- Aluminium sheet 5x10Aluminium · ₹171.25/sq ft · no vendor
- Aluminium Sheet 2mmAluminium · ₹163.26/sq ft · no vendor
- Aluminium Sheet 2mmAluminium · ₹167.23/sq ft · no vendor
- Aluminium Sheet 1.5mmAluminium · ₹124.41/sq ft · no vendor
- Aluminium sheet 1.5mmAluminium · ₹116.25/sq ft · no vendor
“eco matt”
12 rows- Eco matt green gs 387— · no price · no vendor
- Eco matt dg kit233C pink— · no price · no vendor
- Eco matt blue dg kit 551C— · no price · no vendor
- Eco matt green dg kit7744C— · no price · no vendor
- Eco matt dg kit115C yellow— · no price · no vendor
- Eco matt dg kit 219C pink— · no price · no vendor
- Eco matt dg kit 032C red— · no price · no vendor
- Eco matt dg kit233C— · no price · no vendor
- eco matt pink 672C— · no price · no vendor
- eco matt pink 672C— · no price · no vendor
- eco matt brown DG kit pg178— · no price · no vendor
- Eco matt Brown (7519C)Paint · ₹2712//Liter · no vendor
“acrylic clear”
12 rows- Acrylic clear 2mm— · no price · no vendor
- Acrylic clear 10mmAcrylic · ₹270/sq ft · no vendor
- Acrylic Clear BlueAcrylic · ₹105/sq ft · no vendor
- Acrylic ClearAcrylic · ₹108/sq ft · no vendor
- Acrylic Clear AshAcrylic · ₹90/sq ft · no vendor
- Acrylic ClearAcrylic · ₹164/sq ft · no vendor
- Acrylic ClearAcrylic · ₹140/sq ft · no vendor
- Acrylic Clear BlueAcrylic · ₹115/sq ft · no vendor
- Acrylic ClearAcrylic · ₹240/sq ft · no vendor
- Acrylic Clear OrangeAcrylic · ₹115/sq ft · no vendor
- Acrylic ClearAcrylic · ₹82.5/sq ft · no vendor
- Acrylic ClearAcrylic · ₹83/sq ft · no vendor
“acrylic 040”
10 rows- Acrylic 040 2.5mm— · no price · no vendor
- Acrylic 040 2mm— · ₹73 · no vendor
- Acrylic 040 5mm 2 x 3 M— · no price · no vendor
- Acrylic 040 2.5Acrylic · ₹86/sq ft · no vendor
- Acrylic 040Acrylic · ₹174/sq ft · no vendor
- Acrylic 040Acrylic · ₹123/sq ft · no vendor
- Acrylic 040 3mmAcrylic · ₹87.5/sq ft · no vendor
- Acrylic 040 10mmAcrylic · ₹320/sq ft · no vendor
- Acrylic 040 5mmAcrylic · ₹160/sq ft · no vendor
- Acrylic 040 8mmAcrylic · ₹245/sq ft · no vendor
“eco green”
9 rows- Eco green matt 2290C— · no price · no vendor
- eco green matt 8321C— · no price · no vendor
- eco green matt bright pg 178— · no price · no vendor
- eco green matt 8321 C— · no price · no vendor
- eco green matt 323— · no price · no vendor
- eco green matt 336CPaint · ₹2712//Liter · no vendor
- eco green matt 4/534Paint · ₹3221//Liter · no vendor
- eco green matt 7717CPaint · ₹3221//Liter · no vendor
- eco green matt (4208c)Paint · ₹3221//Liter · no vendor
“ms base”
9 rows- MS Base plate 4ft x 1.5ft— · no price · no vendor
- MS Base plate 18" x 18"— · no price · no vendor
- m/s base plate 30" x 18"— · no price · no vendor
- m/s base plate 8x7MS · ₹331.1 · no vendor
- M/S Base PlateMS · ₹37/Qty ( units) · no vendor
- M/S Base Plate HRMS · ₹68/KG · no vendor
- M/S Base plate 12”x 12”MS · ₹435/Qty ( units) · no vendor
- M/S Base PlateMS · ₹50.42/Qty ( units) · no vendor
- M/S Base PlateMS · ₹425/Qty ( units) · no vendor
“paint eco”
9 rows- paint eco yellow matt 1235 CPaint · ₹3221//Liter · no vendor
- paint eco silver met dg kitPaint · ₹3221//Liter · no vendor
- Paint eco gray matt cool 8CPaint · ₹2119//Liter · no vendor
- Paint eco matt red 187CPaint · ₹3221//Liter · no vendor
- Paint eco blue matt 2708CPaint · ₹2712//Liter · no vendor
- Paint Eco blue matt 5/ 026Paint · ₹2712//Liter · no vendor
- Paint Eco blue matt 3005CPaint · ₹2712//Liter · no vendor
- paint Eco matt brown 7516CPaint · ₹3221//Liter · no vendor
- Paint ECO orange pg 175Paint · ₹3221//Liter · no vendor
“aluminium profile”
8 rows- ALuminium profile for Mbx 100mm 60" x 36"— · no price · no vendor
- Aluminium profile for MTP x 6ft A/C— · no price · no vendor
- Aluminium profile MEW 100mm x 15"— · no price · no vendor
- Aluminium profile MEW 80mm x 15"— · no price · no vendor
- Aluminium profile MB x100mm x2400mm( A)Aluminium · ₹3256/Qty ( units) · no vendor
- Aluminium profile MEWAluminium · ₹178/Qty ( units) · no vendor
- Aluminium Profile MPBAluminium · ₹117/Qty ( units) · no vendor
- Aluminium profile MPBAluminium · ₹91/Qty ( units) · no vendor
“acrylic black”
8 rows- Acrylic black 5mmAcrylic · ₹146/sq ft · no vendor
- Acrylic Black 4mmAcrylic · ₹123/sq ft · no vendor
- Acrylic Black 2mmAcrylic · ₹60/sq ft · no vendor
- ACrylic black 5mmAcrylic · no price · no vendor
- Acrylic Black 3mmAcrylic · ₹90/sq ft · no vendor
- Acrylic Black 10mmAcrylic · ₹300/sq ft · no vendor
- Acrylic BlackAcrylic · ₹820.31/sq ft · no vendor
- Acrylic BlackAcrylic · ₹252/sq ft · no vendor
“led strip”
7 rows- LED strip 6mm purple— · no price · no vendor
- LED STRIP 6mm zig zag 120 purpleLED · ₹95/meter · no vendor
- LED strip purpleLED · ₹55/meter · no vendor
- LED strip rubber 5mLED · ₹85/meter · no vendor
- LED Strip Warm WhiteLED · ₹55/meter · no vendor
- LED strip redLED · ₹40/meter · no vendor
- LED strip Cool WhiteLED · ₹55/meter · no vendor
“eco grey”
6 rows- Eco grey matt cool grey 10C— · no price · no vendor
- Eco grey Matt cool 7C— · no price · no vendor
- eco grey matt Ral7010— · no price · no vendor
- eco grey matt7544CPaint · ₹2119//Liter · no vendor
- Eco grey matt 425Paint · ₹2119//Liter · no vendor
- Eco Grey Matt (5C)Paint · ₹2119//Liter · no vendor
“power supply”
6 rows- Power Supply 300W— · no price · no vendor
- power supply 300W water prLED · ₹3500/Qty ( units) · no vendor
- Power Supply SMPSOther Material · ₹400/Qty ( units) · no vendor
- Power Supply BoxOther Material · ₹630/Qty ( units) · no vendor
- power supply 200 WLED · ₹565/Qty ( units) · no vendor
- Power Supply BoxOther Material · ₹1250/Qty ( units) · no vendor
“vinyl reflective”
6 rows- Vinyl reflective yellowvinyl · ₹55/sq ft · no vendor
- vinyl reflective redvinyl · ₹60/sq ft · no vendor
- Vinyl reflective green vinyl · ₹60/sq ft · no vendor
- Vinyl Reflective Bluevinyl · ₹55/sq ft · no vendor
- Vinyl Reflective Blackvinyl · ₹60/sq ft · no vendor
- Vinyl Reflective Whitevinyl · ₹55/sq ft · no vendor