Catalog

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.

How to manage it
  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

Live hygiene

Total items

586

Missing category

215

37% of catalog

Missing price

218

37% of catalog

Missing vendor

586

100% of catalog

By category

(none) · 215Other Material · 76Paint · 48vinyl · 46LED · 42Acrylic · 42Aluminium · 27MS · 27ACP · 17ink · 11wire · 10Stainless steel · 9plastic · 9PVC · 7

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
Clean up in Notion ↗