How To Use PCFitment Excel Template

PCFitment Batch Upload allows you to upload multiple parts and fitments into your account at once. To begin, please make sure you are using the PCFitment Excel template.

Click on Batch Upload on the navigation like below:

You will get the below screen, where you can select “Upload Fitments“ from select process option and click on “Create Batch“ button.

Step 1:

• Click on “Batch Upload” on the navigation.
• Click on the “Download Excel Template” link, to download the Excel template.
• Open downloaded file.

Step 2:

• There are over 60 columns in the Excel template.
• Depending on the part type, additional information might be required.
• The one in red is the required information.
• Please make sure to add the year, make, model, vehicle types options such as car, truck, van, and SUV.
• PartNumberSKU should match your manufacturer part number on your listing.
• PartType is the type of auto parts you sell.
• Quantity is the number of parts needed per vehicle.
• Sheet title should be “Aces Template”

Note: Please make sure you don’t change any column  or sheet titles .

Step 3:

If you need to look up vehicle information to add to your fitment data, you can go to “Database Lookup” for your research.

Step 4:

It’s essential to have the correct terminology for your Part Type.

• Go to the Part Type Category Lookup. Here we are looking for the correct part type for Body.
• Start with Category Name, then Sub Category Name and then Part Terminology and click “Search”.
• Once you selected a Part Terminology, you will notice the position information is on the right.
• Depending on your Part Type, the position information can be crucial for your customer to find the correct auto part.

 Step 5:

 Vehicle data research:

• Go to Vehicle Data Lookup and use the dropdown to search for 2004-2007, Audi A3 Quattro.
• After clicking search, you will see four results, one for each year.

Step 6:

 To refine the search result by adding more attributes. In the “Select Additional Attribute” dropdown select the following: SubModel, Region, Liter, CC, Block Type, and BedLength and click on the “Add Attributes” button.

Now the search results have expanded into 13 vehicles with additional attributes.

To remove the attributes, uncheck the attributes and click on the “Remove Attributes” button.

 Step 7:

Adding fitment data to the Excel template. Starting with 2004, Audi, A3 Quattro, car for vehicle type, manufacturer part number, the part type will be Ground Effects Kit and quantity equal 2 like below.

Add the optional attributes to the correct columns, for example, Region, SubModel, Liter, CC and block type after that scroll over to the right to add N/R for bed length and front for the position.

Step 8:

Once added all the information for 2004, we can copy and paste for the rest of the year.

Continue this process to add all your data, once you are ready, go to Batch Upload on PCFitment to upload your Excel template.