Skip to content
Nabeeh Nabeeh Help Center Open the app

Import vendors and vendor categories

Add your account's vendor categories and vendors from Excel files — categories first, then vendors — or update them from the exported files: names, category, contact details and status.

Use these two imports to add many vendors at once, or to update your existing vendors and their categories from the exported files. They come in an order: Vendor Categories first, then Vendors, because every vendor belongs to one of your account's categories.

Both imports are available while the inventory module is on for your account (Enable Inventory Module in Account settings), like the Vendors list itself. When it is turned off, the list, its Import and Export buttons and the Center's Vendor Categories and Vendors rows are hidden.

Where to start

  • Vendor Categories have no list of their own: open the Import & Export Center and select Import on the Vendor Categories row.
  • Vendors: on Vendors, select Import next to the page title, or select Import on the Center's Vendors row.

Import shows for anyone with the Import Vendor Categories or Import Vendors permission; the account admin always has both, and gives them to other roles under Users › Roles. Updating existing records also needs Update Vendors. The import then follows the steps in Import your data.

Step 1: vendor categories

Select Download template on the Vendor Categories import. The Vendor Categories sheet has one row per category, with three columns: Name (Arabic), Name (English) and Name (Urdu).

  • Give at least one name. On a new row, a language left empty first shows the name entered in another one, then is translated automatically shortly after the import.
  • Two categories of your account never share a name, in any language: a row whose name another category already has is not added. When exactly one category has it, the review offers Switch to update (if you can update vendors) so the row updates that category instead. When two older categories share the name, the row is excluded — rename one of them first.
  • When two rows of the file give the same name, the second one is excluded.
  • Categories cannot be renamed from the vendor form, so this import is the place to rename them: export the categories, edit the names, then import the file.
  • To swap the names of two categories (A takes B's name and B takes A's), one import is not enough: both rows are excluded, because each new name still belongs to the other category. Do it in two imports: first give both categories a temporary name, then import their new names.
  • The import never deletes a category.

Step 2: vendors

Select Download template on the Vendors import. The Vendors sheet has one row per vendor, with the Add Vendor form's fields:

Column What to enter
Category Required on a new row. Choose it from the list, which holds your account's vendor categories only. The import never creates a category: a name that is not one of yours is a row error, and the review's Unknown values panel lets you pick the right one. When two categories share a name, the list leaves that name out and a row that has it is excluded until you choose one of them — we never pick for you.
Name (Arabic), Name (English) and Name (Urdu) At least one name, up to 255 characters; on a new row an empty language takes the name given in another. Vendor names are company names, so they are not translated.
Status Active or Inactive, as on the vendors list; left empty on a new row, the vendor is active.
Contact Name, Phone, Email, Address and Notes Optional, with the form's limits: phone up to 30 characters, a valid email, address up to 1000 and notes up to 2000 characters.

When your account has no vendor category yet, the Category list is empty and every row says to import the vendor categories first — the Center's Vendors row also shows Needs Vendor Categories first until you do.

Vendor names may repeat, as on the form: a new row named like another new row of the same category, or like a vendor already in that category, shows a warning and is still added. Delete the row if it is the same vendor.

New, updated or unchanged

  • A row with the ID from the exported file (Vendor category ID (do not edit) or Vendor ID (do not edit)) updates that record; every row without an ID adds a new one.
  • On an update row an empty cell keeps the current value. For vendors, [CLEAR] empties the contact name, phone, email, address or notes; a name and the category cannot be cleared.
  • A row that changes nothing shows as No change.
  • An ID that is not one of your account's records (another account's, or a deleted one) is refused.

Edit everything in Excel

On Vendors, select Export to get the vendors shown in the list, or all of them, in the same columns, starting with Vendor ID (do not edit). The vendor categories file is exported from the Center's Vendor Categories row. Edit a file, then import it to update the records; a file you did not change reads back as No change. See Export your data.

Then: inventory items

An inventory item can name its Default vendor: import your vendors before your inventory items when the items' file names them. The vendor stays optional on an item.

What's next