Menu

Mesh Sports

4058 Legend Life Baseball Caps > Mesh Sports
Active meta_id 35379
View on supplier
Product Image
Thumbnail
A white cap with a lion graphic and text, accompanied by black, navy, and another black cap in the background.
Thumbnail
A white mesh sports cap worn by a woman with long hair, featuring a logo on the front.
Thumbnail
A white cap with a mesh design featuring a lion graphic and branding.
Thumbnail
A white mesh cap with an adjustable strap at the back and a branding logo.
Thumbnail
A black cap with a textured mesh design and a curved brim, featuring a logo on the front.
Thumbnail
A navy blue cap with a mesh design and a branded logo on the front.
Thumbnail
A blue mesh cap with a curved brim, featuring ventilation panels and a logo.
Thumbnail
A white cap with a textured mesh design and a curved brim, featuring a logo on the front.

Product Identity

product_code
4058
product_name
Mesh Sports
supplier
Legend Life
supplier_brand
Legend
slug
mesh-sports-4058

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
Headwear · Caps · Sports Headwear

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
35379
meta_id
58310 ← foreign key to images file
supplier_supplier_id
57
category_id
162
promodata_category_id
163

timestamps

meta_first_listed_at
2024-01-23 07:49:43 UTC
meta_last_changed_at
2026-08-06 09:33:15 UTC
meta_prices_changed_at
2026-03-19 09:55:12 UTC
meta_source_data_changed
2026-06-05 09:29:03 UTC
created_at
2026-08-07 07:10:52
updated_at
2026-08-07 07:10:52
discontinued_at
changed_comparison_timestamp
2026-08-06 09:33:15 UTC

supplier_appa

appa_member_number
S005122
supplier_country
Australia (AU)