The price file is sent as a downloadable file through email. Select an email address from the dropdown menu, and click Generate Price File Download.
Importing the Price File
To import the price file, download and extract the CSV file to your desktop. Open Excel, and start a new workbook.
Do not open the CSV file directly as this may improperly format data. Instead, import the data through Excel's Import Wizard to ensure correct formatting.
On the Data tab, click From Text/CSV under the Get & Transform Data section.
Depending on your version, Excel may apply a change that removes the leading zeros from part numbers. If this is the case, click Transform Data to adjust the changes applied to the data. This opens an editor showing the changes made.
On Step 3, select all the columns in the data preview by pressing the Shift key while clicking the first column and then the last column. Select Text as the data format to ensure the leading zeros are retained.
This adds a dropdown button next to each column header. If you want to filter for only items that are covered by the LeMans Ad Policy, for example, you can click the dropdown button next to the Ad Policy header, and check Y, as in Yes - the item is covered.
