Products

Product Management

Your catalogue. Everything you sell has a product record, and the POS, sales orders, purchases and stock all read from it.

Last updated 2026-10-13

DigitalKey ERP — Docs · digital-key.co/docs/products

Requires subscriptionproduct.access4,000 IQD / month

Overview

Products are the centre of the system: the POS sells them, purchases restock them, warehouses hold them and reports measure them. A product belongs to one business and is never visible to another.

Products — Product list
Product list
Product list — The catalogue with search, category filter, stock levels, and the add-product button.

Finding a product

The search box matches on name, SKU and barcode at once, so you can type a few letters of the name or scan a barcode into the same field. The list can also be filtered by category.

NoteThe POS uses a separate, faster search endpoint tuned for the counter. It matches the same three fields, so a product you can find here can be found while selling.

What the list shows

Product record
ParameterTypeRequiredDescription
product_idintegerOptionalInternal identifier.
namestringRequiredProduct name, as it appears in the POS and on invoices.
category_namestringOptionalResolved category name, from category_id.
unit_namestringOptionalResolved unit name, from unit_id.
barcodestringOptionalBarcode, used by scanner search.
skustringOptionalYour own stock-keeping code.
purchase_pricedecimalOptionalWhat the item costs you — a weighted average of what you have bought. Hidden from staff without “See purchase price & profit”.
sell_price1decimalOptionalRetail price — the default selling price. Per piece for a product sold by the piece.
sell_price2decimalOptionalWholesale price — the second price level.
pack_pricedecimalOptionalCarton price, for a product sold by the piece.
sell_by_piecebooleanOptionalWhether stock, cost and price count single pieces. Shown as a “by piece” badge.
qty_in_stockdecimalOptionalCurrent quantity on hand.
qty_alertdecimalOptionalLow-stock threshold. At or below this, the item is flagged.
is_activebooleanOptionalInactive products are hidden from selling but keep their history.

The two price levels

Every product carries two selling prices. sell_price1 is retail and is used unless you say otherwise; sell_price2 is wholesale. Sales orders carry a price_level of 1 or 2 to pick between them per order.

TipIf you only ever sell at one price, fill in sell_price1 and leave sell_price2 at zero. Nothing forces you to use the second level.

Actions on a product

Row actions and what each needs
ParameterTypeRequiredDescription
EditAdd / edit productsOptionalOpen the product form.
Stock—OptionalQuantity per warehouse, with the alert level and status.
Purchases—OptionalEvery purchase this product was received on: number, date, supplier, quantity and cost.
Damageproduct.damageOptionalWrite off broken or expired stock as a loss.
Sell by the pieceAdd / edit productsOptionalSwitch between counting cartons and counting pieces.
On / OffSwitch products on/offOptionalDeactivate or reactivate the product.

Expiry alerts

The Expiry alerts button lists products in stock that are expired or about to expire, with the quantity and stock value at risk. The owner sets how many days ahead the warning starts.

Deleting products

WarningDeleting a product deactivates it rather than erasing it. Past invoices must keep referring to what was actually sold, so the record survives with is_active set to false and simply stops appearing in the POS. The owner can bring it back from the recycle bin.

In this section