✕ Settings
Cin7 data
CSV exports from Cin7: Products (SKU, DefaultSupplier, AverageCost, SupplierProductCode…), Availability (SKU, Location, Available, OnOrder), Sales — best: a sale lines export with a Date column (SKU, Quantity, Date, Customer) → dated demand, stockout-adjusted velocity and large-order handling; otherwise Sales by product totals (SKU, Quantity) over the chosen period, Open purchase orders (SKU, Quantity, Supplier, Order number, Date), Suppliers (Name, Currency, PaymentTerm, TaxRule — from Cin7 → Suppliers → Export). Columns are detected automatically.
⬆ Products ⬆ Availability ⬆ Sales 30 days 60 days 90 days ⬆ Purchase orders ⬆ Suppliers
The Cin7 catalogue (active products: SKU, name, brand, category, supplier, supplier code, average cost, carton, minimum) is built into the tool. Products refreshes supplier, cost, supplier code and carton; Availability brings stock and on-order; Sales brings demand for the chosen period; Purchase orders brings open POs and the last PO per product.
Delivery locations
＋ Location
Defaults
Cin7 connection (live) Through api.alambikapro.ca (admin sign-in). The page never holds a Cin7 key: the API reads the nightly caches and the only write is “Create draft POs”.
Send code Sign in ⟳ Sync from Cin7 now Sign out
Suppliers ＋ Add Code = the supplier's exact name in Cin7 (the one in the CSV). The real name stays inside this tool (insiders only).