Skip to content

How to use Wheel/Tire fitment data template

INTRODUCTION

This spreadsheet is designed to add or remove existing wheel and tire fitments and add new ones.

If you have DriveRightData or FitmentGroup, you can use this spreadsheet to add or remove data.

If you don’t have DriveRightData or FitmentGroup, you can use this spreadsheet to add fitment data. In this case, the spreadsheet will serve as the main source of fitment data.

https://docs.google.com/spreadsheets/d/19g4qMgXEKdpZd1hw6RJ15mzNAUPpVBF9sW-6M-njRyI/edit?gid=0#gid=0

COLUMNS

Year, Make, Model, Submodel

Enter the vehicle details for which the fitment applies.

There may be other columns specific to your store.

To find out which columns are required, check the output of the following expression in the browser’s developer tools console:

window.Convermax.templates.config.fitmentSearchConfig.fields

You can add wildcards to the end of the Make/Model name to select all Makes/Models starts with name. You can add the wildcard to the Year to select all Years for Make and Model

For example, Year: *, Make: Audi, Model: A3*. Meaning “Select all years Audi vehicles with models that start with A3”.

How wildcards work

YearMakeModelSubmodelResult
2014FordF-**2014 Ford F-150 Base, 2014 Ford F-250 Base, 2014 Ford F-350 Base, e.t.c
*FordF-150Base1975-2025 Ford F-150 Base
2012Ford**2012 Ford Focus Base, 2012 Ford Fusion Base, 2012 Ford F-150 Base, e.t.c

Notes

Add any relevant notes or additional information about the fitment.

SizeType

Specify the type of size being managed.

You can use the following values:

  • OE: For clients without DriveRightData or FitmentGroup, this value is required and used to distinguish OE sizes from plus/minus.
  • Plus/Minus

Action

Define the action to be taken for each entry.

For clients with DriveRightData or FitmentGroup:

  • Add: Add a new size option for the specified vehicle to existing DriveRightData/FitmentGroup sizes. Add new fitment data if you don’t have connected DriveRightData or FitmentGroup.
  • Remove: Remove an unnecessary DriveRightData/FitmentGroup size for the specified vehicle. For this type of action, you need to specify WheelSize to delete all sizes with the specified WheelSize, or specify TireSize to delete data only with specific TireSize. If you need to delete only specific data, it is better to use WheelSize + TireSize, then only data with the specified WheelSize and TireSize will be deleted.

Tables with explanations of Actions

Add:

WheelSizeTireSizeOffset⠀⠀Meaning⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀Result
19x8245/45R1925 to 35Add new option to vehicle with wheel size and tire size
19x8, 19x9245/45R1925 to 35Add new option to vehicle with all wheel sizes and tire size
19x8, 19x9245/45R19, 255/45/R1925 to 35Add new option to vehicle with all wheel sizes and all tire sizes

Remove:

WheelSizeTireSizeMeaningResult
19x8Remove vehicle options with that wheel size
19x8,19x9Remove vehicle options with that wheel sizes
245/45R19Remove vehicle option with only that tire size, and filter other options with that tire size
19x9245/45R19Remove vehicle options with only that wheel size and tire size

IMPORTANT INFORMATION

All changes in the table are applied after an index update. Usually, index updates run automatically twice a day. You can also manually initiate indexing from the Convermax administration panel or Convermax app in Shopify or BigCommerce.

WheelSize

Provide the size of the wheel in the format “DIAMETERxWIDTH”. First the diameter, then the width. You can write multiple sizes separated by ,

Offset

Specify the offset of the wheel in millimeters. For ranges use the pattern “38 to 50”.

TireSize

Enter the tire size associated with the fitment. You can write multiple sizes separated by ,

WheelSizeR, OffsetR, TireSizeR

These columns represent additional fields for a second set of wheel specifications if needed for comparison or alternate fitments.

INSTRUCTIONS

Adding New Fitments:

  1. Enter the vehicle’s Year, Make, Model, Submodel, and additional values if needed.
  2. Specify the SizeType. If this spreadsheet is used as the sole source, then the OE size must be specified for each vehicle.
  3. Fill in WheelSize, TireSize, Offset, BoltPattern, Hubbore if you do not have a FitmentGroup/DriveRightData data; the remaining fields are optional. If you have a FitmentGroup/DriveRightData data, fill in WheelSize, TireSize, Offset; the remaining fields are optional.
  4. Optionally, add Notes for specific fitment details.

Removing Unnecessary Fitments:

  1. Enter the vehicle’s Year, Make, Model, and optionally Submodel.
  2. Specify the WheelSize or TireSize or both.