Purchases
      Back to home
      1. Help Center | Sumtracker
      2. Purchases

      How to create and use Suppliers

      In This Article

      Supplier Fields Explained

      Company name

      Name of your supplier’s company.

      Supplier code

      A unique code or nickname to identify each supplier. It is a mandatory field.

      Contact Person

      The first name and last name of the contact person for your supplier.

      Contact Number

      Contact number of the supplier or the contact person.

      Email

      The contact email for the supplier. Emailed Purchase orders are sent to this address.

      Currency

      The currency that your supplier operates in. This is the currency used for the Purchase order of this supplier.

      Payment Terms

      Your payment terms with your supplier. This is also copied to purchase orders.

      Notes

      You can add any other information about the supplier here. This is also copied to purchase orders.

      Address

      Your supplier’s address. This is printed on the Purchase order.

      How to create a Supplier

      To create a new supplier, follow the steps:

      1. Go to the suppliers list page and click on “Add Supplier”

      2. Enter all the fields and click on save.

      supplier1

      How to import Suppliers List (in bulk) 

      Download the Sample file with all column headers from here.

      1. You may export the existing Supplier list to get the same file or download the sample file from above.
      2. Once downloaded, fill in the details. All fields except code are optional to fill.
      3. Import the file from Supplier list table.

      When importing currency, you have to enter the 3-letter currency codes as per the ISO 4217 standards. Check currency codes from here: https://www.iban.com/currency-codes

      While importing country, you have to enter the 2-letter country codes as per the ISO standard. You can find the 2-letter country codes here: https://www.iban.com/country-codes

      supplier2

       Move to Top

      Editing Suppliers in Bulk

      1. Export the existing Supplier list.

        supplier3

      2. Edit the supplier data in the downloaded sheet.

        It is highly recommended to use google drive for editing the exported supplier CSV file.

        supplier4

        You can change the following fields - Supplier Code, Currency, Company Name, First and last name of contact person, Payment terms, Notes, Email, Phone, Address (Address lines, city, state, country and pincode).

      3. Save the file in CSV format and Import the file.

      Please note - Do not change or delete the id column for editing existing suppliers.

      Move to Top

      How to link Suppliers and Products?

      You can link suppliers and products through purchase prices. Each product can have multiple purchase prices associated with it. Purchase prices enable you to specify the supplier offering the price and include other information such as the Supplier SKU. You may leave all other fields blank or 0 except supplier and product.

      Detailed information on purchase prices: How to use and create purchase prices?

      Move to Top

      Importing Suppliers via Shopify

      Vendors in Products on Shopify can be synced to Sumtracker automatically through the Save Vendor Information setting.

      If you have added vendors to your products in Shopify, they can be imported as Suppliers to Sumtracker.

      1. Vendors in Products gets synced to Sumtracker as Suppliers.

        supplier5

      2. The Suppliers are automatically linked to Products in Sumtracker through Purchase prices. By default, a purchase price of 0 is added in the purchase prices. They are created primarily to link supplier and products. Purchase prices can be edited later on.