The Vendor Item import allows users to batch import vendor-specific item information into C2W Inventory using an Excel template.
This is useful when vendors use their own product codes or prices for the items you purchase from them.
Vendor Item records help connect your internal item records with vendor-specific purchasing information.
Open the Import Data Screen
Fill in the Excel Template
The Customer import template may include the following fields:
- The yellow highlighted column is mandatory.
For the Vendor Item template, required fields include:
- VendorName
- ItemName
Item Information
- Vendor Name
- Item Name
- Vendor Product Code
- Vendor Price
- Quantity
Save and Upload the Template
Verify Imported Customers
After importing, users can verify vendor item information from the related vendor or item record.
Users can also review vendor item information when creating or managing Purchase Orders.
Best Practice
Before importing, check that:
- VendorName matches an existing vendor
- ItemName matches an existing item
- VendorProductCode is entered correctly if used
- VendorPrice is correct if used
- Qty is correct if used
- The Excel file is saved and closed before uploading
This helps prevent import errors and keeps vendor purchasing information accurate.