Buyer Admin: How do I export a supplier catalogue?

AD team Updated by AD team

How do I export a supplier catalogue in full?

  1. From the marketplace homepage, go to Catalogue Updates
  2. Click Search for WDIs (right hand side)
  3. Using the 'Refine your search' box on the left hand side, use the supplier dropdown to locate the supplier you wish to review, and click Search (there is no requirement to input dates)
  4. From the results, select any of the uploads / WDI numbers
  5. Scroll to the bottom of the page to the Export Supplier Catalogue box
  6. In the 'Current' row select Create export. This will change the status to 'Request has been queued'
  7. Click the Refresh export status button (bottom left), and if ready the 'File available' status will show:
  8. Click Download
  9. The file will export as a .txt file. In order to review the contents of the file successfully you will need to complete the below steps:
Note that in theory, you can copy and paste the contents directly into an excel file but if a supplier has leading zeros in their catalogue numbers etc. then this may cause formatting issues / errors, resulting in data inaccuracies.
  1. Unzip the file:
    1. Locate the downloaded zipped folder that you want to unzip (extract) the files from
    2. Do one of the following:
      • To unzip a single file, open the zipped folder, then drag the file or folder from the zipped folder to a new location of your choosing.
      • To unzip all the contents of the zipped folder, press and hold (or right-click) the folder, select Extract All..., and then follow the instructions.
  2. Once complete, open Excel.
  3. In Excel click File, then Open, Browse
  4. In the pop-up window, go to the location of the unzipped file (e.g. Downloads) and if you cannot see your downloaded export change the files type dropdown box to 'All files' so as to see the zip file:
  5. Select the file and click Open
  6. The Text import wizard should now have opened:
    1. Page 1: Make sure ‘Delimited’ is checked, then click Next
    2. Page 2: If in the preview box the data is not organised into the correct columns, you may need to select the Tab delimiter tick-box. Click Next
    3. Page 3: On the final page you have the option to format columns. Simply select a column in the ‘Data Preview’ pane and choose General or Text from the Column Data Format options. To avoid errors, format all columns as ‘Text’, except those which have a large amount of characters, (e.g. long description/specifications etc.), leaving those as ‘General’.
    4. Click Finish

How did we do?

Buyer Admin: How do I connect with a supplier on my Purchasing marketplace?

Buyer Admin: Price Approval - How do I approve or reject a price file?

Contact