Follow

CSV Supplier Uploads: Column mapping - required fields & explanations

Created:   |   Updated:

ShippingEasy supports adding and updating your Suppliers via CSV file. This guide outlines which fields can be updated with a CSV file upload. For more help getting started, download a sample suppliers CSV file.

NOTE: fields marked in red are required.
ShippingEasy Column
Column Definition
*Supplier ID Unique identifier for the supplier set by ShippingEasy, for example: S12789. This column must be mapped for every Supplier upload. When adding new Suppliers, leave the ID blank. When updating existing Suppliers, enter the assigned ID. Learn how to find an assigned Supplier ID.
*Supplier Name The name of the supplier. The Supplier Name is required if the supplier does not exist in ShippingEasy. This field will auto-populate on purchase orders generated to the supplier.
Supplier Website The website of the supplier.
Supplier Email Email address of the Supplier where the purchase orders are sent to. 
Supplier Phone Phone number of the Supplier. 
Supplier Default Address Default address of the Supplier and will auto-populate on purchase orders generated to the supplier. This field is required if additional addresses are specified.
Supplier Additional Addresses Additional addresses of the Supplier.
Payment Terms The payment terms of the supplier. This field will auto-populate on purchase orders generated to the supplier.
Resale License The resale license of the supplier. 
Tax ID The tax ID of the supplier. 
Notes Comments or notes for the supplier.
Contact First Name First name of the Supplier contact. This field will auto-populate on purchase orders generated to the supplier.
Contact Last Name Last name of the Supplier contact. This field will auto-populate on purchase orders generated to the supplier.
Contact Job Title Job title of the Supplier contact. This field will auto-populate on purchase orders generated to the supplier.
Contact Department Department of the Supplier contact. This field will auto-populate on purchase orders generated to the supplier.
Contact Email Email address of Supplier contact. This field will auto-populate on purchase orders generated to the supplier.
Contact Phone Phone number of the Supplier contact. This field will auto-populate on purchase orders generated to the supplier.
Contact Fax Fax number of the Supplier contact. This field will auto-populate on purchase orders generated to the supplier.
 
Related articles:

How to: Add a Supplier
How to: Edit a Supplier
How to: Associate Suppliers with Product SKUs

Comments

Please sign in to leave a comment.




Community    browse  

COMMUNITY FORUMS
FEATURE REQUESTS

Questions & Answers

Issues & Bugs

Productivity

Partners

Shipping

Inventory

Marketing