The Vendor import allows users to batch import vendor records into C2W Inventory using an Excel template.
This is useful when setting up the system for the first time or moving vendor data from another system.
Users can import vendor information such as contact details, billing addresses, shipping addresses, currency, tax information, payment terms, billing email, shipping email, and remarks.
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 template, Name is mandatory.
Template Fields
The Vendor import template may include the following fields:
Basic Information
- Name
- Contact Name
- Phone
- Fax
- Website
Billing Address
- AttentionB
- CountryB
- Address1B
- Address2B
- CityB
- StateB
- ZipB
Shipping Address
- AttentionS
- CountryS
- Address1S
- Address2S
- CityS
- StateS
- ZipS
Payment and Tax Information
- Currency
- Tax No
- Payment Terms
- Payment Method
- Tax Name
Other Information
- Remarks
- Billing Email
- Shipping Email
Save and Upload the Template
Verify Imported Customers
After importing, users can verify the imported vendor records from:
Purchasing > Manage Vendors
Users can search for the imported vendor and confirm that the vendor information was imported correctly.
Best Practice
Before importing, check that:
- Name is filled in
- Vendor names are spelled correctly
- Email addresses are entered correctly
- Billing and shipping addresses are accurate
- Currency is correct
- Tax information is correct
- Payment terms and payment method are correct
- Location is correct if used
- Billing email and shipping email are correct
- Remarks are entered correctly if used
- The Excel file is saved and closed before uploading
This helps prevent import errors and keeps vendor records clean.