We accept two file types: .xlsx (Excel) and .xml (Auto Care's ACES and PIES transmission format).

Excel files are a great way to manage multiple but different data updates, which is why we have provided Excel (.xlsx) templates that you can use to upload data to PartsHub.

It’s important to use them properly so that your data gets updated correctly. This means not changing the order of the columns or tab names, and importing PIES first then ACES. Stick to those rules and the guidelines below, and your data will upload without a hitch.

For updating a list of Products, follow these guidelines:

  • Download and use the Items Loadsheet provided. https://pxm.partshub.com/assets/files/PH_Item_Loadsheet.xlsx
  • Part # is the unique identifier, and imported data will overwrite existing data. So, if a Part # exists, the information will be replaced by the new information in your loadsheet, including blank fields.
  • For items, use Codes/IDs, not labels.
  • The Part # column within the "PiesItem" tab MUST be filled in, but PIES Receiver, Part Type, Brand AAIA ID, and Brand Label can be ignored.
  • If you are adding pricing with a new price sheet, be sure to add the price sheet in your Global Catalog setting prior to upload.
  • You can use URI for your PAG asset type web links.

For updating a list of Fitments, follow these guidelines:

  • Download and use the Fitments Loadsheet provided. https://pxm.partshub.com/assets/files/PH_Fitment_Loadsheet.xlsx
  • For fitments, use labels, not Code/IDs.
  • The following fields are required:
    • Part #
    • Make, Model, Year
    • Vehicle Type, such as Car, Truck, Van, UTV, etc. (you will be able to obtain this information from the Gap/Coverage report)
    • When entering Position, the entry must match those designated for the Part Type. If not, the data will not be uploaded.
    • When entering text into the Notes field, use a semicolon (;) to create a line break. For example, a “5 pc. Kit; Incl. Floor/Sidewalls/Bulkhead/Tailgate” would be imported as:
      • 5 pc. Kit
      • Incl. Floor/Sidewalls/Bulkhead/Tailgate
For updating a list of Custom Fields, follow these guidelines:

Custom Fields are a way to send data that is needed to by a receiver or your website that is not part of the PIES industry standard fields. Examples could be special Part Number to SKU match, or ASIN number for Amazon.

Final steps of Uploading the file(s) and Importing your updates:

Every update has two steps, uploading the loadsheet (or XML), then importing the data in your uploaded file(s).

To upload a file:
  • Go to File Manager, toggle over to Import Manager, click on Actions and select Upload. Follow the guides in the upload modal. 

Once the file upload is completed, you will need to review and import your uploaded data. 

To import your updates:
  • Click on the "import to your catalog" link in the modal when it lets you know your file has uploaded successfully. Alternatively, you can click on the file name in the Import Manager index.
  • You can click on a part number to make sure your uploaded data is as expected.
  • If uploaded data is as expected, select a few or select all your part numbers, contextual action will appear below wherein you can import your selected parts.
  • Once done, you can click over to your Products index and review your updates.
Keep in mind, any part number in an update will be automatically moved back to Draft status.