Order list and purchase orders

The order list

Inventory → Orders → Order list. Add things to buy from:

  • the Suggested section: items at or below their reorder point, pre-filled with enough to get back above it (untick a row or set its quantity to 0 to leave it off),
  • the item page,
  • the scanner's Reorder mode.

Each entry shows the item, the quantity and an estimated cost; open the item for the rest of its details. Tick entries and press Remove selected to take them off the list. Print and CSV give whoever is buying a list to take along.

Entries on an order appear under Ordered, not yet received with a link to their purchase order. Deliveries are recorded from the order, not the list.

Purchase orders

Tick entries on the order list and press Create a purchase order from selected. Enter the supplier's PO number: it fills in every item. Check the quantities and the unit costs quoted (the items total below the list updates as you type), then pick the supplier from your vendors, the order date, fees (shipping, tax...) and notes, and save. The entries are marked ordered under that number and the order shows an expected total.

Some items coming from a different supplier, or on a separate order? Type a different PO number on those items. Each number becomes its own purchase order with its own supplier, date, fees and notes, and they are all saved together: if one cannot be saved (say the number already exists), none is.

Tracking numbers

An order that ships in several boxes has a tracking number per box. Keep them all on the order: the Tracking card on the order page lists each number with its carrier and a link that opens the carrier's tracking page in a new tab.

Type a number in Tracking number, or press the barcode button beside it to scan the shipping label with your phone or tablet camera, then Add tracking. Spaces, dashes and capitals do not matter: 1z 999 aa1 0123 4567 84 is stored as 1Z999AA10123456784. The carrier is worked out from the number's format:

  • UPS: 1Z followed by 16 letters and digits,
  • FedEx: 12 or 15 digits, or 22 digits starting with 96,
  • USPS: 20 or 22 digits (22-digit numbers start with 91 to 95), or two letters, 9 digits and US,
  • DHL: 10 digits, or numbers starting with JD, JJD or GM.

All-digit numbers must also pass the carrier's check digit, so a mistyped digit usually shows up as Other. If the guess is wrong, pick the carrier in Carrier when you add the number, or later with Edit carrier or note under the number (choose Detect from the number to go back to the guess); the link follows the carrier. Other numbers are kept without a link. Add a note (Box 1 of 2) if it helps. The number itself cannot be edited: remove it and add the right one.

A tracking number can be on only one order in your company: adding one that is already used says which order has it. Remove takes a number off. You can also enter tracking numbers, one per line, when you create the order and on Edit order (where you can remove them too). Adding, editing and removing tracking numbers needs the same access as recording a delivery, and each change is kept in the company's history (an edit shows the carrier and note before and after).

On Inventory → Orders, an open order with tracking shows a truck icon, and the search box finds orders by order number or by tracking number, typed as it appears on the label or just part of it.

When the boxes arrive, scan a label's tracking barcode on the Scan page to jump straight to that order's delivery form, already filled in. Recording the delivery from there marks that tracking number Received. Scanning a label into Tracking number keeps the tracking number the barcode carries (a USPS barcode's 420 and ZIP code prefix is dropped).

Vendors

Inventory → Orders → Vendors is the list of suppliers you buy from: name, contact, email, phone, website, your account number with them and notes. Everyone can see it and search it; administrators add, edit, archive and restore vendors. Each vendor shows how many orders it has, what was paid on the ones that took a delivery and when it was last ordered from, with a link to those orders (at the sites you are looking at).

Every supplier box (new order, Edit order, the order page and the orders import) is a picker: type a few letters and choose a vendor with the mouse or the arrow keys and Enter. A name that is not on the list yet shows Add "name" as a new vendor; it is added when you save the order, no separate step. Names are unique in the company and capitals do not count, so "Staples" and "STAPLES" are the same vendor.

Archiving a vendor keeps it on its old orders but stops offering it on new ones; restore it to use it again. Adding, editing, archiving and restoring vendors is kept in the company's history.

Receiving a delivery

When the delivery comes, open the order (Inventory → Orders) and Record a delivery. Set Received to when it arrived (date and time, in 15-minute steps; it starts at the current time). For each line enter how many good units arrived and what you actually paid per unit. Those units go into stock as a receive movement at that price, dated when it was received and referenced PO <number>, and the price becomes the item's unit cost (a price of $0 leaves the unit cost as it was: enter units you got for nothing as free units, below).

Count anything damaged in transit and anything you returned (with a reason) on the same line: neither enters stock. You pay for received and damaged units; returned ones are credited, and the order's Paid total reflects that plus the fees.

A short delivery leaves the order Partially received for the next one.

Free units

Suppliers sometimes ship units at no charge: buy 10 get 1 free, a free case with a big order, a goodwill replacement. Enter them in Free units next to the quantity when you create the order (the items total leaves them out and says how many there are and what they are worth), or later with Edit order.

Free units are worth the line's unit cost, or the item's unit cost when the line costs nothing, but they cost $0: the order's expected and paid totals leave them out and the order page shows their value separately. On Record a delivery, count them in Free (into stock) and Free damaged (not stocked); they are never returned for credit. Free units go into stock as their own receive movement at $0, marked Comp in the ledger with the value they were worth, referenced PO <number>. They do not change the item's unit cost. More free units than promised need Accept more than ordered, like any extra. Close without the rest writes off what never came; if it turns up after all, Reopen order puts the order back to taking deliveries.

Correcting an order

Account holders and administrators can fix an order at any point, whether it is open, partly received, received or closed: press Edit order on the order. You can change the supplier, the order date, the received date and time, the notes and the fees, and on each line the quantity ordered, the expected price, how many were received, damaged and returned, what was paid per unit, and the free units promised, received and damaged.

Changing Received moves stock on hand by the difference, referenced PO <number>: more received is a receive movement at the price paid, fewer an adjustment, dated the order's received time. Changing the received date and time moves the delivery that completed the order (and corrections to it) in the ledger too; earlier deliveries keep their own times. A corrected price paid becomes the item's unit cost, unless it is $0. Changing Free received moves stock the same way, with free units at $0. To take an item off the order, set its counts to 0 and tick Remove; it goes back on the order list. Every change is kept in the company's history.

Exporting and importing orders

Inventory → Orders → Export CSV downloads every purchase order and the order list in one file: a row per order line (order_line), with the order's number, supplier, status, dates, notes, fees (as Shipping=9.99; Tax=1.20) and tracking numbers (as 1Z999AA10123456784; 9400111201080805483016) repeated on each of its lines, with each number's carrier, Received time and note in tracking_details, and a row per order list entry that is not on an order (order_list). Each row also carries the item's name, SKU, UPC, unit, quantity on hand and unit cost.

Administrators bring that file back in with Orders → Import CSV, after importing the items:

  • Each row finds its item at the site by SKU, else UPC, else name. Columns the import does not use are ignored.
  • Orders keep their lines, fees, status and received, damaged and returned counts, free units included (comp, comp_received, comp_damaged). No stock is recorded: quantities come from the items import, so nothing is counted twice.
  • Tracking numbers in the tracking column, separated by semicolons, commas or spaces, are added to their order with the carrier worked out from each number. The tracking_details column keeps the rest, one line per number: number|carrier|received|note, for example 1Z999AA10123456784|fedex|2026-11-10 09:15|left at dock. Leave the carrier empty to have it worked out; received is a date, optionally with a time, in your time zone; the note is the rest of the line. A number listed only in tracking_details is added too. A number already on one of your orders, or on two orders in the file, is a problem the preview shows.
  • An order whose number already exists is skipped, so importing the same file twice changes nothing. Open and ordered list entries are added; received or dismissed ones, and items already on the list, are skipped.
  • Each supplier in the file is linked to a vendor: one of yours with the same name (capitals do not count), or a new vendor added on import. The preview lists them, and you can pick a different vendor for any name.
  • The preview shows every order and entry before anything is written, and a file with any problem is refused whole.

Purchases report

Reports → Purchases lists the orders placed in a date range with supplier, expected, fees and paid totals and the value of free units received (Comp value, never part of what was paid), with totals per vendor, a vendor filter and a CSV export. Export CSV on the orders list of one vendor (follow a vendor's order count) exports only that vendor's orders. See Reports.

Updated · View as Markdown · Question not answered?