looped.shDocs
Looped Inventory

Items

What you buy and sell, with SKUs, tracked stock, categories, suppliers and prices by level

Items lists what you buy and sell. Tracked items keep a count and a cost; the rest, such as services and fees, just fill in invoice and supplier invoice lines.

The items list

Each row shows the item's SKU, Name, Category, Bin, what's On hand, on Sales orders, On order and Available, its Average cost and the Stock value. Items you don't track say Not tracked. Click a column's heading to sort by it, and again to reverse it. Hover or tab to the ⓘ beside a heading to see what it means.

Click a number to see what's behind it: On hand opens Stock movements for the item with its running balance, Sales orders its open sales orders and On order its open purchase orders.

  • Search matches the name, SKU or barcode. Every word you type has to match, in any order.
  • The first filter switches between All items, Low stock and Archived.
  • Filter by Category, or by Supplier to see only the items you've bought from that supplier. The supplier filter stays in the page's address, so you can bookmark it or share it.
  • Choose Show 25, Show 50 or Show 100 rows a page.
  • Print prints the list as filtered. Tick rows (or the box in the header for the whole page) to print only those.
  • With rows ticked you can also Print labels, Generate barcodes for the ones that have none, and Archive them (or Restore them in the Archived view).

Sales orders is stock on open sales orders in Invoices that hasn't been invoiced yet. Available is on hand less what's on sales orders, and low stock is worked out from available stock.

Adding an item

Click Add item. To copy another item's details, pick it under Start from another item: everything but its SKU, barcode and stock is copied. As you type the SKU and name, items with the same SKU or a similar name show under the field, so you don't add one twice. Then fill in:

FieldNotes
SKUYour code for the item, such as MUG-350. It shows first on document lines and in pickers
Name and DescriptionThe description is what shows on invoice lines
BarcodeThe code on the product, and its format: Code 128, EAN-13, EAN-8, UPC-A, Code 39, ITF-14, QR code, Data Matrix, GS1-128, GS1 DataMatrix or GS1 QR code. Scan reads it with the camera, or use a Bluetooth or USB scanner in the box; the format is worked out from what was read. Generate makes a new code. EAN and UPC check digits are checked, and added if you leave them off. If another item already has the code, it's named under the field
BinWhere it's kept, such as Shelf A3. Stock takes walk in bin order, and labels print it
CategoryGroups items in filters, reports and price lists
UnitEach, Box, Pair, Kilogram and so on
Selling price, excl. VATThe item's own price. Price levels can set others
VAT and VAT on purchasesStandard rate, zero-rated or exempt. VAT on purchases can be the same as sales
Track stockCount what's on hand and move its cost to Cost of Sales as it sells. Turn it off for services and fees
Reorder level, Reorder quantity, Maximum levelDrive the daily reorder digest, the reorder report and the dashboard
Minimum orderThe least the supplier sells. The reorder report rounds its suggestion up to it
Sales, Inventory and Cost of sales accountsWhere the item posts in Financials
On hand, Unit cost and As atOptional, for tracked items and people who see costs: what's on the shelf when you start on Looped, what each cost excluding VAT, and the date. It goes in as the item's opening stock. Stock bought after that comes in on a goods received note or supplier invoice

Once an item has stock movements it stays tracked. Archive it if you stop selling it; Restore brings it back.

Suppliers

An item's Suppliers list says who you buy it from, Their code for it and their Minimum order if it differs from the item's. Tick Usual on the supplier you normally order from: the reorder report and purchase orders use it. The list saves with the item.

Suppliers come from Financials. If Financials has none yet, add them there first.

Barcodes and labels

Generate (beside the barcode on an item, or Generate barcodes for ticked items on the list, which asks for the format) makes a new in-store number for your own labels, never the SKU: EAN-13 codes start with 04, UPC-A with 4 and EAN-8 with 2, the ranges GS1 keeps for a company's own use, so they never clash with a real product's code. GS1-128, GS1 DataMatrix, GS1 QR and ITF-14 carry a real GTIN, so Looped doesn't generate them: scan or type the code GS1 South Africa gave you. Codes for selling through other shops come from GS1 South Africa.

GS1 codes. GS1-128, GS1 DataMatrix and GS1 QR code hold a GS1 element string: each part's application identifier in brackets, then its value, such as (01)06001234567890(17)271231(10)ABC123. The product's GTIN-14 in (01) comes first and is required. After it you can add a batch or lot number (10), an expiry date (17), a best-before date (15), a production date (11) and a serial number (21); dates are YYMMDD and batch and serial numbers take up to 20 characters. Type a plain EAN-13, UPC-A or EAN-8 and it becomes (01) and the GTIN-14. Check digits and dates are checked. Generate makes an in-store GTIN (starting with 2). Scanning a GS1 code finds the item by its GTIN, so a GS1 code on a product finds an item saved with the EAN-13, and the other way round.

Labels (or Print labels on an item or the list) prints shelf and product labels:

  1. Add items, and choose One each, One per unit on hand or your own count per item.
  2. Choose the Label size: an A4 sheet of 24 (3 × 8) or 14 (2 × 7), or a 50 × 25 mm or 100 × 50 mm thermal roll, one label a page.
  3. Choose what each label Shows: name, SKU, price (excluding VAT) and bin. On a sheet you've used before, Skip labels leaves the used ones blank.
  4. Check the preview, then Print or Download PDF. Looped remembers the size and fields for next time.

Packs

The Packs tab on an item lists the boxes and cartons it comes in: a Name, how many of the item it Holds (a carton of 12 boxes of 12 holds 144), an optional Barcode, and whether it's the default when buying or selling. Stock is always kept in the item's own unit, so packs never change costs or the books.

  • Scanning a pack's barcode finds the item and counts the whole pack: in Adjust stock and Receive stock it adds that many, and on the stock take count screen it asks how many packs and adds them to the count.
  • Purchase order and goods received lines can be entered in a pack: pick it beside the quantity. The unit cost stays per unit, and the line remembers the pack as it was.
  • On hand shows the largest whole packs beside the quantity, such as 144 each · 12 boxes.
  • On Labels, choose a pack on a line to print its barcode instead of the item's.

Products with variants

Clothing and anything else sold in sizes and colours can be one product with variants. Choose Add product with variants on the items list, give it a Name, a Base SKU and up to three Options (such as Colour and Size), and type each value with a short Code. Every combination becomes its own item, with a SKU made of the base SKU and the codes joined with a dash: SW100-NAV-M.

  • Each variant keeps its own stock, price, barcode and reorder level, so reordering stays per variant and invoices pick the variant.
  • The items list shows a product as one row with its totals; open it to see the variants. A search or a filter such as Low stock shows the product with only the matching variants.
  • On the product's page, Edit all variants (or tick some first) changes the selling price, reorder level, reorder quantity or category on all of them at once.
  • Edit product renames it or adds values: adding XL makes the missing XL variants. Values can't be removed once variants use them; archive the variant instead.
  • Stock on hand shows each variant's product with the product's total, and Sales by product totals each product's variants.
  • Add existing items on the product's page groups items you already have into it: pick each and give it a value per option. They keep their SKUs. The link icon on a variant's row takes it out of the product again; it stays an ordinary item.
  • Click the picture beside the product's name to give the product its own picture. Variants keep theirs.

Each item has Earns commission, on by default, which the Commission by sales code report in Invoices uses.

Prices by level

If you use price levels, the item page shows Prices by level: the item's price on each level, excluding VAT. A price you set here wins over the level's rule. To price many items on one level at once, use Edit prices by level from Items.

The item page

Besides its details, an item shows:

  • On hand, Sales orders, On order, Available, Average cost and Stock value. Click a quantity to open what's behind it.
  • What's On open purchase orders, On open sales orders and On open quotes.
  • Stock movements: every movement, from opening stock, goods received notes, supplier invoices, invoices, returns, stock takes and adjustments. Years that have been archived load when you ask for them.
  • History: who added, edited, archived or restored the item, and each field they changed.

When more was sold than you had, the item says so: Inventory doesn't guess a purchase that was never recorded.

Pictures

An item can have a picture. On the item page, choose Add a picture to upload a JPEG or PNG of up to 5 MB, or take a photo on a phone. Change picture replaces it and Remove takes it off. A price list prints each item's picture in a small column beside it whenever any item on the list has one. To print pictures on quotes, sales orders and invoices too, turn on Show item pictures on documents under Invoices › Settings › General.

Are you an AI? Visit llms.txt — these docs as plain markdown.

On this page