Overview

With your supplier information populated in Veeqo, you can raise and track purchase orders in one place.

In this section:


Add a supplier

From the Purchasing > Suppliers screen, click + New Supplier, then complete the details for this supplier.


Import suppliers in bulk with CSV

  1. On Purchasing > Suppliers, click the "Import" button and download the Sample CSV file

  2. Open the file with a CSV editor (e.g. Microsoft Excel or Google Docs). To create a new supplier, leave the supplier_id column blank. Fill in the rest of the columns using a single row for each supplier. See CSV column definitions below.

  3. Import the completed CSV into Veeqo. Your suppliers will be uploaded to your Veeqo account.


Edit suppliers in bulk with CSV

  1. On Purchasing > Suppliers, export your supplier CSV file

  2. DO NOT change the supplier_id field. Update other supplier details such as address

  3. Import the saved CSV file on Purchasing > Suppliers. Your supplier details will be edited


Supplier CSV field definition

Field

Description

Valid values

supplier_id

The unique number used by Veeqo to differentiate between suppliers.

Leave this blank if you want to create a new supplier.

When editing existing suppliers, do not delete this value.

Do not enter your own ID. This is automatically created by Veeqo once the supplier has been created

numerical "34" (automatically generated by Veeqo)

supplier_name

The unique company name of the supplier. This is used when selecting a supplier during purchase order creation

alphanumeric "Nike"

supplier_address_1

supplier_address_2 (optional)

The first/second line of the supplier's postal address. This is used for the documents sent to the supplier

alphanumeric "Warehouse 24B"

supplier_state (optional)

supplier_town (optional)

The state or town/city of the supplier. This is used for documents sent to the supplier

text "New York"

supplier_zipcode

The zip/postcode of the supplier. This is used for the documents sent to the supplier

alphanumeric "10001"

supplier_country

The country code for the supplier. This is used for the documents sent to the supplier

List of accepted country codes ("US" or "GB")

supplier_currency

The currency code for the supplier. This is used to calculate the exchange rate when creating a new purchase order

List of accepted country codes ("US" or "GB")

supplier_sales_contact_name (optional)

Optional. The full name of the person whom purchase orders should be addressed to

alphanumeric "John Smith"

supplier_sales_email

The email address that the supplier's purchase order is sent to

alphanumeric "john@nike.com"

supplier_phone (optional)

Optional. The supplier's phone number. This can be used on the document sent to the supplier

numeric "929 234 1234"

supplier_bank_account (optional)

The supplier's bank details used for your own reference when paying outside of Veeqo

numeric "212324"

supplier_sort_code (optional)

The supplier's bank details used for your own reference when paying outside of Veeqo

numeric "00-22-11"

supplier_accounts_contact_name (optional)

If the supplier has a separate accounting contact, you can enter the full name here

text "Mary Brown"

supplier_accounts_email (optional)

The email address of the supplier's accountant. A copy of the purchase order will be automatically sent to this email, along with the supplier email

alphanumeric "mary@nike.com"

supplier_accounts_phone_number (optional)

Contact phone number of the accountant. This is for your internal records

numeric "929 111 2222"

Did this answer your question?