Portal | Homepage | Blog

PAM spreadsheet importation tutorial


The most recent version of PAM (RMS & RMH only) gives us ability to import data from xls files and match it to existing items. This way you can quickly add a new attribute and populate its values.

This tutorial allows you to work on large datasets so please be very careful and, as always, having backups is strongly recommended.

To do so, we need to create a spreadsheet that contains a column with Item Lookup Codes that we use for matching. In our example we will be adding brand names to our items.

As you can see, I named the columns in the first row. PAM has an option to read the first row as a column name what makes matching the spreadsheet columns to the attributes even easier.

Once we have the spreadsheet ready, we can proceed to the Product Attribute Manager and open the spreadsheet importation tool.

The first step is to select the file. You need to close your spreadsheet editor for this to work. The checkbox allows you to use the first row as a column name

If you named the first row ‘ItemLookupCode’ PAM will pick up on that and match the columns automatically. Other columns will have to be selected manually. Please be extra careful while doing that as this might lead to data corruption. In our case, I picked the Brand Name attribute.

Next screen presents us with a preview. It allows us to review the changes before accepting. At this stage we can still go back and reassign the columns.

When we accept the preview, the data is updated and we are presented with a result screen. Please remember, that during the process data is committed automatically, so when it finishes you won’t have an option to discard the changes.

You will need to restart PAM to see the results

Please let us know if you have any questions or contact support if you need assistance using this feature.




Is there a way to export the list from PAM in the first place?


Hi Janie,

No, we don’t have such feature currently available. This has been created with supplementing existing information with external sources such as spreadsheets coming from manufacturers.




Is there a way to match on something other than itemlookupcode? Product data from suppliers is increasingly available in spreadsheet form but for an import to work it would need to match on a suppliers identifier for a product not ours - an MPN or GTIN in other words. We have both of these available as PAM columns.


Hi Emma,

Not currently. As usual, we can go with a feature suggestion, or a (relatively small) custom dev. Let us know if you’re interested.