A vendor that is registered in Vendor Self Service (VSS) can log into VSS and upload catalogs in Microsoft Excel format. The following steps should be followed to upload a catalog file in Microsoft Excel 2007/2010 format (.xlsx).
Registered VSS vendor logs into VSS.
The Vendor clicks the Catalog Management tab and then selects the Catalog Upload tab.
The Vendor selects Excel File as the Catalog File Type, specifies the Catalog File Name and Picture File Name and then clicks the Upload action button.
On successful completion, the system saves the file as an attachment to a record on the VSS Catalog Files (CATFILE) table and sends an automatic email notification to the vendor and the Catalog Administrator. The email notification displays the Email Notification Information entered on the Catalog Upload page prior to triggering the transformation process.
The Catalog Administrator runs the synchronization process (Export from VSS and Load to Advantage). After synchronization has completed the Catalog Administrator navigates to the Catalog Files (CATFILE) table in Financial.
The Catalog Administrator clicks the Attachments link on the CATFILE page to open the Reference Table Attachments page to verify that 2 files (that is, the excel file and the zip file that contains the images) are attached to the record.
The Catalog Administrator reviews the catalog file for completeness and accuracy. The Catalog Administrator then creates a Master Agreement with a Commodity Line Type of Catalog and uploads the catalog using the existing Advantage catalog upload process. Refer to the “Loading Catalog to a Master Agreement in Financial” section for more information.