Prepare Supplier Excel File
The spreadsheet from the Supplier will normally need to be edited before it can be uploaded to the Utility.
The File must contain the following columns.
| Column | Description | Required |
|---|---|---|
| Part Number | Part Number from the Supplier (To match to the Supplier Code on the Alternate Supplier in Exo). | Yes |
| Description | Suppliers Description of the product. (Used to help match products to Exo when the Part Numbers don’t Match). | Yes |
| List Price | Price from the Supplier. | Yes |
| Discount | Discount from the Supplier (If no discount then needs to be 0). | Yes |
| Per | Number of Exo Sell units for the Supplier List Price | Yes |
| Minimum Quantity | Minimum Order Quantity from the Supplier to receive this Price. | Yes |
| Barcode | Supplier Barcode of the Product | No |
| Old Supplier Code | If the Supplier has changed some codes (And Provided a conversion list) enter the Old Supplier Code and the Utility will Update Exo to the New Code (Supplier Code on Alternate Supplier) | No |
| Is Discontinued | If Anything is in this Column then the Product will be marked as Discontinued in Exo (And In-Active if no Stock) | No |
Validate Spreadsheet
Check the Spreadsheet does not have.
- Extra rows at the Top
- Extra Rows at the Bottom
- Extra Columns
- Merged Cells
Original Spreadsheet
Final Spreadsheet Ready to Upload
