Missing “Primary Brand” error while loading Trading Partner Brands

I’m trying to load the interchange relationship between my primary branded part numbers (which includes several primary brands) and Advance Auto. I have something like the following:

I set the “Primary Brand Part Number” to “Primary Part” and the “Part Number” to “AAP Part”, but then get the following error when running the import script:

"Missing source and/or column for required PIES element "Primary Brand" in
segment "Item". The segment will not be imported.

Resolution

The problem is that the script needs the IDs for each of those primary brands. There are two ways to meet this requirement (assuming you have different AAIA BrandIDs for each brand):

1. You could add a column to the source file that has the AAIABrandID for each of those brands and use that for the Primary Brand mapping, or

2. If you don’t want to change the source, you could create a user-defined Map column from your Brand column to the Brand table.

You would then set up a 1-1 mapping from each of your brand codes to the AAIA Brand codes. Use that user-defined column for the “Primary Brand” mapping.

This will allow you to have a single script for Advance that includes all of your primary brands.