Tri-color sue heavy brushed cotton cap
CH38
•
Shiny
•
Baseball Caps
>
Tri-color sue heavy brushed cotton cap
Active
meta_id
15365
A cap featuring tri-colour design in blue, navy, and white with a logo on the front.
A cap featuring tri-colour design in blue, white, and navy, with an adjustable strap at the back and a logo.
A cap in black, red, and yellow with a logo. Features a structured design and curved peak.
A cap featuring a black body with contrasting red and yellow accents around the brim and sides, including a logo.
A black cap with green accents and a white strip along the brim, featuring a logo on the front.
A cap featuring a black body with contrasting orange and white details. Includes a logo.
A cap featuring red fabric with blue and yellow accents, and a logo on the front.
A red cap with contrasting white and black accents. It features a logo on the front.
A blue and black cap with white trim and a logo on the front.
Product Identity
product_code
CH38
product_name
Tri-color sue heavy brushed cotton cap
supplier
Shiny
supplier_brand
WINNING SPIRIT
slug
tri-color-sue-heavy-brushed-cotton-cap-ch38
Classification
category_group
Headwear
category_type
Baseball Caps
breadcrumb
Headwear > Baseball Caps
group_id
G
type_id
G-01
appa_type
Headwear > Baseball Caps
supplier_tags
—
Status
meta_discontinued
0 — active
product_discontinued
0 — active
meta_can_check_stock
1 — real-time via API
overview_min_qty
0 (no stated minimum)
meta_price_currencies
AUD
internal_ids — database keys
id
15365
meta_id
25386 ← foreign key to images file
supplier_supplier_id
53
category_id
162
promodata_category_id
163
timestamps
meta_first_listed_at
2022-02-10 12:10:50
UTC
meta_last_changed_at
2026-08-06 11:00:36
UTC
meta_prices_changed_at
2026-03-08 09:38:20
UTC
meta_source_data_changed
2026-08-04 10:46:47 UTC
created_at
2026-08-07 07:04:29
updated_at
2026-08-07 07:04:29
discontinued_at
—
changed_comparison_timestamp
2026-08-06
11:00:36 UTC
supplier_appa
appa_member_number
S3270
supplier_country
Australia (AU)