Easier work with wide tables: scrollbars within reach, pinned header and names, column picker
The restock table has twenty columns and its horizontal scrollbar sat under the fiftieth row – awkward with a mouse. Every table is now its own scroll panel the height of the screen: both scrollbars are always visible (also on a Mac, where they otherwise hide), the header stays on top and the product code and name stay on the left even when you scroll to the last columns. You can also grab the table with the mouse and drag it sideways. And a new “Columns” button next to the export: untick what you don’t need, the choice is remembered per table in your browser. The Excel export always includes every column.
Where: Restock recommendations
Seasonal order: sold-out seasonal products no longer disappear
In Seasonal order mode, products with last year's sales in the target months are always listed – even with no sale in the last 30 days. The “no sales in 30 days” switch used to hide them, so sold-out seasonal goods (winter range in October, say) were missing. The switch now only governs items without a seasonal baseline.
Where: Restock recommendations
Stockout forecast without noise: only products sold in the last 90 days, Active / Top / All switch
Days to stockout are computed from 30/60/90-day sales only. A product last sold a year ago used to get a “forecast” from its whole history (e.g. 1,200 days) and flooded the report – it is no longer in Forecast (see Dead stock). Clearance sets are excluded from Forecast like discontinued products. New switches above the table: Active (sold in 30 days, default), Top (≥ 10 pcs in 30 days) and All (sold in 90 days); the export follows the selected view.
Where: Stockout forecast
Restock by supplier: pallets, delivery cycle, target stock and goods on the way
Supplier settings (button in Restock recommendations) now take, next to the lead time, a delivery cycle, target stock in weeks, pack multiple and a “spiky demand” mode (planning with the 80th percentile of weekly sales). Multiples / pallets can also be pasted per product. New “On the way” column: record what is already ordered (in the table or by pasting code;units;date lines) – it is subtracted from the recommendation and fully covered items leave the table and the export. The same figures show in Favorites.
Where: Restock recommendations
Restock: items without sales in the last 30 days are hidden
A product with no sales in 30 days got its pace from longer windows and, with stock 0, came out as “urgent”. Such items are now hidden in Restock recommendations (and the export); a checkbox above the table shows them.
Where: Restock recommendations
Stock and coverage in weeks too
Next to “Stock (days)” there is a new “Stock (weeks)” column, and “Coverage (weeks)” in Restock recommendations – for suppliers that quote lead times in weeks. Same figure as in days, ÷ 7 to one decimal; exported too.
Where: Stockout forecast
New column Sales last week
Next to the rolling windows (Sales 7d = the last 7 × 24 hours up to the moment of loading) there is a new column with sales for the previous calendar week (Monday–Sunday). It is in Forecast, Top sales, OOS online, Favorites and Full inventory and is exported.
Where: Full inventory
“What now?” buttons open the forecast pre-filtered
Clicking “Runs out within 7 days”, “7–14 days” or “14–30 days” in the What now? panel switches to the Stockout forecast tab, scrolls to the table and shows only that group. Previously nothing visible happened.
Where: Stockout forecast
A clear message when a synchronisation takes longer
When a manual refresh takes longer than the browser waits for a reply (Shoptet sometimes processes exports slowly), the app no longer reports a generic error. It shows the last loaded data and explains that the synchronisation continues on the server and the new data will appear after a page refresh in a few minutes.
Stock value counts only stock actually held
Products with negative stock (oversold, made to order) no longer reduce the total stock value or unit count in the overview cards and the category and brand tables. The negative figure stays visible in the stock column and the forecast.
Where: Full inventory
“Sold today” is now distinct from “no sales”
A product sold today used to show as “no sales”. It now shows “sold today” and is counted correctly in the Dead stock and OOS stores tabs.
An expired login no longer shows a loading error
If your login expires while you work, the app now takes you straight to the sign-in screen. Previously it showed a generic loading error and Retry did not help.
Restock recommendations: no noise from rare sales, negative stock ignored
Target stock is now rounded mathematically (up to 0.49 pcs = 0), so a product sold only a few times long ago no longer gets an “order 1” recommendation. Negative stock (oversold, made to order) counts as zero on the shelf – oversold pieces are not added to the recommended quantity, we assume you have them sorted with the supplier.
Where: Restock recommendations
The OOS stores tab works again
The tab lists sold-out products with no online sales that sold in a store within the last 90 days. On API-connected shops it was empty because of a calculation bug. Online sales now come from orders and store sales from stock movements.
Where: Out of stock (stores)
Faster repeated opening of the app
The browser keeps the loaded data in a local cache. When nothing has changed since your last visit, the app no longer downloads it again and opens in a moment — even for shops with hundreds of thousands of orders. Changing the average margin in Settings is also recalculated without a new download. The Refresh button still always fetches fresh data.
14 months of sales history, complete months only
Orders are now kept for 14 months instead of 12, so seasonal planning always finds the complete same month of last year. Only complete months are written to the monthly history; previously a month at the edge of the window could be truncated and the year-over-year comparison was only partly right.
Where: Restock recommendations
New Favorites tab
Paste the codes (or EANs) of the products you want to watch and the Favorites tab shows their 7–90-day sales, stock per warehouse, value, margin and stockout forecast. The list is saved with the shop so the whole team sees it, and the table filters and exports like any other.
Where: Favorites
Favorites: coverage, order quantity and urgency
The Favorites tab now also shows the Restock recommendation columns: coverage in days, how many pieces to order and urgency (Urgent / Soon / OK). Computed exactly as in the recommendations, with the default 14-day lead time or the supplier's own.
Where: Favorites
Faster search and filters for large catalogues
Table search and filters now respond instantly even in shops with tens of thousands of products. A filter with thousands of values (typically the supplier code) no longer opens an endless dropdown: start typing part of the value and pick from the suggested matches with product counts.
Where: Full inventory
Cancelled orders are recognised by all common status names
Previously only orders with the status “Stornována” or “Storno” were excluded. Statuses such as “Stornováno”, “Zrušená” or “Zrušená objednávka” are now recognised too, so they do not count towards sales, forecasts or revenue.
ABC analysis: the bestseller is always class A
The product that completes the 80 % revenue block belongs to class A (it used to fall into B). Shops with one dominant product no longer see an empty class A.
Where: Full inventory
More accurate stock levels and stock value
Shoptet does not mark a product as changed when only its stock changes, so some stock levels could lag behind. The app now reloads all products in full once a week, which corrects stale stock and removes products deleted in the shop.
Where: Full inventory
Correct margin for VAT-inclusive purchase prices and sale prices
If your Shoptet purchase prices are entered including VAT, the app now converts them to ex-VAT before calculating margin and stock value at cost. Previously the margin came out too low and stock value too high. Running sale prices now count towards price and margin.
Where: Full inventory
Lead times per supplier
In Restock recommendations you can give each supplier its own lead time (button “Supplier lead times”). Suppliers without one use the default. Coverage, urgency and order quantity follow the supplier’s lead time.
Where: Restock recommendations
Seasonal planning for a range of months
Seasonal planning now takes a month range (e.g. October through December) and sums forecasts and order quantities over the whole period. A notice above the table reminds you that it is a forecast from last year’s sales, to be checked before ordering.
Where: Restock recommendations
Margin and stock value from the ex-VAT price
The cost estimate from the average margin and the Margin column now use the ex-VAT selling price, so a 30 % margin gives a stock value at cost exactly 30 % below the ex-VAT selling value. Products without a purchase price show the estimate as “~30 %”.
Where: Full inventory
EAN in every table and export
The EAN column is now in every view, including To produce, Month comparison and Trends, and goes into every Excel export.
Where: Full inventory
“Check demand” badge
A product whose last-7-day sales run far ahead of its long-term pace gets a badge with a hint: action price (likely clearance), regular price (likely real demand) or bulk movement. The switch “Including Check demand products” in Forecast and Restock decides whether such products plan from the recent or the long-term pace.
Where: Stockout forecast
New Dead stock tab
Stock on hand with no sale for 30, 60, 90 or 180 days, with units and the value tied up at cost and at selling prices. The last sale is taken from stock movements and orders alike.
Where: Dead stock
Seasonal order planning and month comparison
Restock recommendations gain a By month (season) mode: pick a target month and the proposal is built from the same month last year, scaled by year-on-year growth. Stock trends gain a Month comparison: any two months side by side per product, with export.
Where: Restock recommendations
Filters above every table and custom exports
Every table has a filter bar: supplier, supplier code, category, brand, ABC class and search by name or code. “Only visible on the e-shop” drops hidden products. Exports let you pick columns (remembered per table), always include the product code and now the main image link. The product name links to the e-shop.
Where: Full inventory
ABC class on every product
ABC analysis used to be a summary only. The ABC class is now a column in every table and export, filterable, and clicking the A, B or C card in the ABC panel opens the inventory filtered to that class.
Where: Full inventory
To produce tab: what to make from open orders
Making, sewing or assembling to order? The To produce tab scans open orders, finds made-to-order products and sums them: units ordered, units still to make after stock, number of orders and the oldest one. Pick once which availabilities mean “made to order” and which order statuses are open (pre-filled for you). Per-order detail, “Only short” filter, exported lines are remembered, two-sheet Excel export.
Where: To produce
Stock value even without purchase prices
Missing purchase prices on some products? Enter your shop’s average margin in Settings and StockSense estimates the cost and stock value for products without one. Products with a real purchase price are untouched. Saved for your shop.