Academy
Back to Academy

Getting your items in

2 min read

This is the step where most people slow down, so it is worth reading before you start.

One thing needs to exist before your items do: your locations. Items land at a location by name, so add each office, room or fridge you count separately before you import.

Suppliers do not need to exist first. The import reads the Supplier column, creates any supplier you do not have yet, and attaches the item to it. Put the vendor's name on each row the way you want to see it, McKesson or Henry Schein, and the supplier list builds itself from the file.

Two ways to add items

One at a time, using the form at the top of the Items section on the Admin page. Fine for a handful of products, or for adding something new later.

From a spreadsheet, using the Import Items section further down the same page. This is the one to use for your initial setup. Most clinics can export a product list from whatever they use today, and importing forty items takes about as long as typing two.

What the spreadsheet needs

The importer reads your column headings, so name them plainly and it will find them. The ones that matter:

  • Name and SKU, so each item is identifiable
  • Supplier, matched by name to your suppliers, or created if it is new
  • Location, matched by name to a location you already added
  • Threshold, the count where you want an alert
  • Reorder Qty, how many you usually order
  • On Hand, what is on the shelf right now

Anything you leave out you can fill in later. Nothing has to be perfect on the first pass.

After the import

Check that your items came in with their suppliers attached. The result tells you how many suppliers the file created; open Suppliers on the Admin page and add an email and phone to each one you will order from. A supplier spelled two ways in the file becomes two suppliers, so fix the spelling and import again if that happens.

Then set your on hand counts, which is covered in Setting your counts.

A note on getting it wrong

You can edit or delete anything you import. If the first attempt comes in messy, fix the spreadsheet and import again rather than correcting rows by hand. Nothing is locked in.

Next
Setting your counts