Odoo Mapping

10 Sanitary SKUs from cottolife → Odoo

Mapping of SKUs from toilet-and-bath.html (cat=103) onto Odoo product.template / product.product with plant 🇮🇩 Jakarta, mrp.workcenter per line, and active work orders.

res.company / mrp.warehouseID-JKT · 🇮🇩 Jakarta

product.categoryAll / Saleable / Sanitary ware

source.urlcottolife.com/th/toilet-and-bath.html?cat=103

C13507-SIMPLY-MODISHOne-piece toilet

COTTO Simply Modish One-Piece 3/4.5L SMARTFLUSH

680×395×740 mm · ฿21,900/pc

product.template #18149

product.product #18150

default_code C13507-SIMPLY-MODISH

Plant & lines

mrp.warehouse🇮🇩 ID-JKT — Jakarta

ID-JKT-L1Line 1 — CastingWC-CAST-I1

ID-JKT-L2Line 2 — FiringWC-FIR-I2

Targets / scrap

monthly target2,600 pc

monthly actual2,520 pc

scrap pct3.4%

quality score96%

Active work ordersmrp.workorder · [('product_id','=',18150)]

WO	MO	Line	Shift	Plan	Produced	Scrap	State
WO/2026/06010	MO/2026/03101	Line 1 — Casting	Day	180	175	6 (3.4%)	in progress

C13447-SPACE-SOLUTIONOne-piece toiletHYG

COTTO Space Solution One-Piece 3L

660×380×735 mm · ฿18,900/pc

product.template #11595

product.product #11596

default_code C13447-SPACE-SOLUTION

Plant & lines

mrp.warehouse🇮🇩 ID-JKT — Jakarta

ID-JKT-L1Line 1 — CastingWC-CAST-I1

Targets / scrap

monthly target2,200 pc

monthly actual2,110 pc

scrap pct3.3%

quality score96%

Active work ordersmrp.workorder · [('product_id','=',11596)]

WO	MO	Line	Shift	Plan	Produced	Scrap	State
WO/2026/06014	MO/2026/03104	Line 1 — Casting	Day	150	146	5 (3.4%)	in progress

C1340-NOVATwo-piece toilet

COTTO Nova Two-Piece Toilet 4.5L

700×360×760 mm · ฿9,890/pc

product.template #15648

product.product #15649

default_code C1340-NOVA

Plant & lines

mrp.warehouse🇮🇩 ID-JKT — Jakarta

ID-JKT-L1Line 1 — CastingWC-CAST-I1

Targets / scrap

monthly target4,200 pc

monthly actual4,080 pc

scrap pct3.8%

quality score95%

Active work ordersmrp.workorder · [('product_id','=',15649)]

WO	MO	Line	Shift	Plan	Produced	Scrap	State
WO/2026/06018	MO/2026/03108	Line 1 — Casting	Day	260	248	12 (4.8%)	in progress

C13270-LAMODETwo-piece toilet

COTTO Lamode Two-Piece Dual Flush 3/6L

720×380×770 mm · ฿12,500/pc

product.template #11023

product.product #11024

default_code C13270-LAMODE

Plant & lines

mrp.warehouse🇮🇩 ID-JKT — Jakarta

ID-JKT-L1Line 1 — CastingWC-CAST-I1

Targets / scrap

monthly target3,400 pc

monthly actual3,280 pc

scrap pct3.7%

quality score95%

Active work ordersmrp.workorder · [('product_id','=',11024)]

WO	MO	Line	Shift	Plan	Produced	Scrap	State
WO/2026/06022	MO/2026/03112	Line 1 — Casting	Night	210	200	9 (4.5%)	in progress

C014107-SPACE-WALLHUNGWall-hung toilet

COTTO Space Wall-Hung Toilet

540×360×370 mm · ฿24,900/pc

product.template #10764

product.product #10765

default_code C014107-SPACE-WALLHUNG

Plant & lines

mrp.warehouse🇮🇩 ID-JKT — Jakarta

ID-JKT-L2Line 2 — FiringWC-FIR-I2

Targets / scrap

monthly target1,100 pc

monthly actual920 pc

scrap pct7.2%

quality score89%

Active work ordersmrp.workorder · [('product_id','=',10765)]

WO	MO	Line	Shift	Plan	Produced	Scrap	State
WO/2026/06028	MO/2026/03118	Line 2 — Firing	Day	80	64	11 (17.2%)	in progress

C0250-COUNTER-BASINWash basin

COTTO Counter-Top Basin Round

Ø 420×140 mm · ฿4,290/pc

product.template #15427

product.product #15428

default_code C0250-COUNTER-BASIN

Plant & lines

mrp.warehouse🇮🇩 ID-JKT — Jakarta

ID-JKT-L2Line 2 — FiringWC-FIR-I2

Targets / scrap

monthly target3,600 pc

monthly actual3,420 pc

scrap pct4.1%

quality score94%

Active work ordersmrp.workorder · [('product_id','=',15428)]

WO	MO	Line	Shift	Plan	Produced	Scrap	State
WO/2026/06030	MO/2026/03120	Line 2 — Firing	Night	220	205	14 (6.8%)	in progress

C0233-UNDER-BASINWash basin

COTTO Rectangular Under-Counter Basin

520×395×195 mm · ฿3,690/pc

product.template #10452

product.product #10453

default_code C0233-UNDER-BASIN

Plant & lines

mrp.warehouse🇮🇩 ID-JKT — Jakarta

ID-JKT-L2Line 2 — FiringWC-FIR-I2

Targets / scrap

monthly target2,800 pc

monthly actual2,710 pc

scrap pct3.5%

quality score95%

Active work ordersmrp.workorder · [('product_id','=',10453)]

WO	MO	Line	Shift	Plan	Produced	Scrap	State
WO/2026/06034	MO/2026/03124	Line 2 — Firing	Day	170	162	6 (3.7%)	in progress

C0150-PEDESTALPedestal basin

COTTO Pedestal Basin Classic

560×460×830 mm · ฿5,290/pc

product.template #15168

product.product #15169

default_code C0150-PEDESTAL

Plant & lines

mrp.warehouse🇮🇩 ID-JKT — Jakarta

ID-JKT-L2Line 2 — FiringWC-FIR-I2

Targets / scrap

monthly target1,800 pc

monthly actual1,720 pc

scrap pct3.9%

quality score94%

Active work ordersmrp.workorder · [('product_id','=',15169)]

No active work orders

C3120-URINALUrinal

COTTO Wall-Hung Urinal

340×290×525 mm · ฿4,890/pc

product.template #12187

product.product #12188

default_code C3120-URINAL

Plant & lines

mrp.warehouse🇮🇩 ID-JKT — Jakarta

ID-JKT-L1Line 1 — CastingWC-CAST-I1

Targets / scrap

monthly target1,400 pc

monthly actual1,350 pc

scrap pct3.2%

quality score96%

Active work ordersmrp.workorder · [('product_id','=',12188)]

WO	MO	Line	Shift	Plan	Produced	Scrap	State
WO/2026/06040	MO/2026/03130	Line 1 — Casting	Day	90	86	3 (3.5%)	in progress

C99027-SMART-BIDETBidet seatHYG

COTTO Smart Bidet Seat C99027

510×400×155 mm · ฿32,900/pc

product.template #14189

product.product #14190

default_code C99027-SMART-BIDET

Plant & lines

mrp.warehouse🇮🇩 ID-JKT — Jakarta

ID-JKT-L2Line 2 — FiringWC-FIR-I2

Targets / scrap

monthly target600 pc

monthly actual470 pc

scrap pct8.1%

quality score87%

Active work ordersmrp.workorder · [('product_id','=',14190)]

WO	MO	Line	Shift	Plan	Produced	Scrap	State
WO/2026/06045	MO/2026/03135	Line 2 — Firing	Day	45	36	6 (16.7%)	blocked

Note: product.template / product.product IDs are hashed from default_code to simulate Odoo IDs — real Odoo will assign actual IDs on sync.