Stock per branch, by the carton or the piece, by the batch and its expiry date.

From Excel to Dashing

Save your sheet as a CSV file and upload it from the inventory page. Columns are recognised by their headers, in Arabic or English: "الرمز" or item_code, "الاسم" or item_name and "السعر" or sale_price are required; "التكلفة", "الكمية", "الحد الأدنى" and "الباركود" (cost, quantity, minimum stock, barcode) are optional. Before anything is saved you see how many items will be created and which rows fail. The import creates items and never edits existing ones: a code that already exists is skipped. A quantity column books opening stock to the main branch. Importing 500 items with their stock takes about 6 seconds.

The carton and the piece

One item can have several units, each with a conversion factor and its own barcode: a case of 12 bottles of water scans with its barcode and deducts 12, while a single bottle scans with its own and deducts 1; stock is always kept in the base unit. Each unit has its own price. Fractional quantities are accepted, such as 2.5 kilos of cheese or 3.5 metres of cable, with the weight typed in, since scales are not connected.

Batches and expiry dates

Every receipt is recorded as a batch with its expiry date. At the sale the cashier suggests the batch closest to expiry; an expired batch is flagged and can only be sold with an explicit confirmation, recorded under the name of whoever confirmed it. A home-screen card lists what expires within 30 days, and that window can be changed in Settings. Batches are switched on only for the items that need them.

Branches and transfers

• An independent quantity per branch, with cost of goods sold computed per branch
• Transfers between branches: created, then "in transit", then received or cancelled; the system suggests a transfer itself when an item runs out in one branch and sits unsold in another
• A minimum per item: when the quantity reaches it, the item appears on the low-stock list and on a home-screen card, and a draft purchase order is one tap away

Counts and adjustments

A cycle count records what is on hand item by item while selling continues, and the difference is posted as an accounting entry after approval. In the current version the count works on the item's total quantity, not per branch. A manual adjustment (damage, loss, correction, restock) posts an entry and is logged in the audit log with who made it and when. There is no screen listing a single item's movements; the audit log keeps adjustments, counts and transfers, and Dash answers "what moved this item?" in the chat.

Variants and serial numbers

A shirt in its sizes and colours: a parent product with variants entered one row at a time (name, code, price, opening quantity), and each variant sells at the cashier as its own item by its barcode or from the grid; there is no tool that generates variants from a size-and-colour table. Devices are tracked by serial number or IMEI from receipt through sale to return, once tracking is switched on in Settings. Photos appear on the cashier grid and the item page.