Products and orders
How a product draws on the stock register, and what happens to stock as its orders move. This page is part of Inventory; for adding and counting the items themselves, see Stock items.
Made to order, or sold from stock
The Stock card of the product editor starts with how the product is sold:
| Choice | What it means | Good for |
|---|---|---|
| Made to order (the default) | Built when an order comes in. Stock never limits how many can be ordered. | Anything cut, configured or assembled to suit. |
| Sold from stock | Comes off a shelf. Customers cannot order more than is available. | Finished goods you keep, spares, bought-in items. |
To sell something from stock:
- On the Stock page, click New item, and enter what is on the shelf as
Opening stock:
BRACKET-A, opening stock 20. - In the product's Stock card, choose Sold from stock and pick it under Stock item. Each one sold takes one.
Receiving, counting and reordering then work as they do for any other item, and the customer sees what the register says:
| Available | What the customer sees |
|---|---|
| As many as one order can take, or more | In stock. The quantity goes up to the order's limit. |
| Fewer, say 3 | Only 3 left, and the quantity stops at 3. |
| None | Out of stock in this configuration, with Add to cart withdrawn. |
If each configuration has its own shelf - shirts by size - write the parts formula
instead, and have it name the item: return [{ sku: 'SHIRT-' + gui.size, qty: 1 }];.
A formula that takes several items sells as many as the scarcest one allows.
A product sold from stock whose item is archived, whose SKU is not in the register, or whose formula fails shows Out of stock rather than selling without limit. It cannot be saved with no stock item at all.
Stock is checked when checkout opens and again when payment starts, but it is only held once the order is placed, so two people paying at the same moment can both get through. Both orders stand, because both have paid. The later one shows Sold more than was in stock in its Stock panel: contact that customer, to wait or be refunded.
Maximum per order
Maximum per order, in the same card, limits how many of a product one order can take, however it is sold. It counts every configuration together: with a maximum of 10, five red and five blue fill it. Customers see Maximum 10 per order, the quantity stops there, and checkout refuses more.
Left empty, each cart line can hold up to 20, as a guard against typing mistakes. The maximum can also be higher than 20, for something sold by the hundred.
Connecting a product to stock
A product draws on stock through its parts formula, in the Stock card of
the product editor. The formula says what one unit takes, as configured, and
returns a list of SKUs and quantities. For a table with width and depth
controls in millimetres:
var area = gui.width * gui.depth / 1000000; // mm² to m²
return [
{ sku: 'OAK-25', qty: area },
{ sku: 'LEG', qty: 4 },
];
A product that uses no stock has no parts formula.
For a product made to order, When materials are short decides what a customer is told when the register cannot cover their configuration:
| Setting | What the customer sees |
|---|---|
| Take the order, quote a longer lead time (the default) | They can buy it, and are told Materials on order: allow about 7 extra days - the slowest short item's restock days. |
| Say nothing | Nothing. Stock is still reserved and used behind the scenes. |
Before saving, type a configuration into Try with - width=1800&depth=900 -
and press Try it. Each part is listed with the stock item it names and what
is available. A SKU marked Not in the stock register is a typo or a missing
item: fix it now, or every order for the product will report it as a problem.
What an order does to stock
Nothing here is done by hand: stock follows the order's fulfilment state.
🖱️ Ctrl/⌘ + scrollen of knijpen om te zoomen · slepen om te verschuiven · dubbelklikken om te herstellen
| When the order is... | Stock | For one table taking 1.62 m² of oak |
|---|---|---|
| Placed | Reserved | Reserved +1.62, available -1.62. On hand does not change. |
| In manufacture, or any later state | Used | On hand -1.62 and reserved -1.62. |
| Cancelled before manufacture | Released | Reserved -1.62: available again. |
| Cancelled after manufacture started | Nothing | The wood is cut. If it really goes back on the shelf, record it with Receive or Adjust. |
| On hold | Nothing | Stays reserved. |
Each of these appears in the item's movements as Reserved, Used or Released, linked to the order. The order's own page has a Stock panel: what it reserved, where that stands, and a Not reserved list of anything that could not be - a SKU the register does not have, an archived item, a formula that failed.
A customer who has paid always gets their order, even if the last of something went in the meantime. If an order uses stock the records say is not there, on hand goes below zero - the signal to count that item.