products #935

id
INTEGER
935
category_id
INTEGER
1 → product_categories
name
TEXT
Freshwater Chlorinator
slug
TEXT
freshwater-chlorinator-de2290
price
NUMERIC
0.00
sku
TEXT
DE-2290
stock
INTEGER
1
image
TEXT
null
gallery
JSONB
[]
specs
JSONB
{"make": "Omnipure E-811-3654-S", "type": "Auxiliary", "source": "DrillEquip", "vessel": "SS OLINDA STAR - Semi Submersible Offshore Vessel", "quantity": 1, "part_type": "Auxiliary", "_documents": {"coc": {"url": null, "available": false}, "pms": {"url": null, "available": false}, "others": {"url": null, "available": false}, "manuals": {"url": null, "available": false}, "oem_certificate": {"url": null, "available": true}}, "_model_number": "", "_product_type": "", "vessel_company": "", "condition_grade": "", "iadc_section_id": "A.11.6", "is_iadc_sourced": true, "pipeline_status": "PUBLISHED", "iadc_subcategory": "A.11.6", "drillequip_material_id": 2290}
pricing_tiers
JSONB
{}
created_at
TIMESTAMP
2026-05-04T04:41:50.437301+00:00
updated_at
TIMESTAMP
2026-05-04T04:41:50.437301+00:00
description
TEXT
Make: Omnipure E-811-3654-S; Qty: 1
short_description
TEXT
null
brand
TEXT
Omnipure E-811-3654-S
cost_price
NUMERIC
null
compare_at_price
NUMERIC
null
low_stock_threshold
INTEGER
0
features
JSONB
[]
is_active
BOOLEAN
Active
is_featured
BOOLEAN
False
meta_title
TEXT
null
meta_description
TEXT
null
tags
JSONB
["Unit Specifications", "IADC", "DrillEquip", "RFQ"]
video_url
TEXT
null
rfq_only
BOOLEAN
True
additional_category_id
INTEGER
null
stock_total
INTEGER
0
stock_available
INTEGER
0
stock_reserved
INTEGER
0
warehouse_id
INTEGER
null
base_currency
TEXT
null
cross_reference_id
VARCHAR
DE-2290
sub_category_id
INTEGER
null
segment_id
INTEGER
null