eCommerce Guide
WooCommerce YMM Wheel & Tire Fitment Integration Guide
Learn how to load 12,902 verified passenger vehicles into WooCommerce using native product attributes (`pa_pcd`, `pa_center_bore`, `pa_offset`) and a lightweight YMM lookup table.
1. Store Fitment Specs in a Dedicated MySQL Table
Avoid storing 12,902 vehicle rows inside `wp_postmeta` — it destroys MySQL query performance. Instead, import the WheelFitmentDB CSV into a clean custom table indexed on `(year, make, model)` and join against your WooCommerce wheel SKU attributes:
SELECT p.ID, p.post_title
FROM wp_posts p
JOIN wp_postmeta pm_pcd ON p.ID = pm_pcd.post_id AND pm_pcd.meta_key = '_wheel_pcd'
JOIN wp_postmeta pm_cb ON p.ID = pm_cb.post_id AND pm_cb.meta_key = '_wheel_cb'
JOIN wf_vehicle_fitment v ON v.year = 2026 AND v.make = 'Ford' AND v.model = 'F-150'
WHERE pm_pcd.meta_value = v.pcd
AND CAST(pm_cb.meta_value AS DECIMAL(5,1)) >= CAST(v.center_bore AS DECIMAL(5,1)); Ready to put this blueprint into production?
Get Clean WooCommerce-Ready CSV ($47) →