The Reorder Low Stock feature in Linnworks Desktop is very helpful for creating POs.

Can it be replicated in .Net?

Any update on this feature?

This is pretty urgently needed, when can we expect to see this?

We are now paying double the amount we were last year with one less user, forced to migrate to .net as the 2D Royal Mail barcode tracking isn't incorporated into the desktop app because "new features are no longer being added to the desktop" and now to top it off we are still having to open the dektop app just to build POs for our suppliers using the reorder low stock system.

Its becoming more confusing as to why we are exactly meant to be keen on staying with linnworks

Can't believe some sort of usable Low Stock/Stock Reorder function wasn't implemented when Linnworks.net was launched. This is an absolutely basic function that something like Linnworks needs, it shouldn't be an "improvement" that takes months to release. We have just moved onto Linnworks (having never been on or used Desktop) and now find ourselves with no easy way to check what stock we need to order from any particular supplier, the Primary Dashboard shows low stock but isn't exportable, filterable or easily usable in any way, we'd have to look down every item in the list and manually copy the ones relevant to the supplier we are ordering from to a purchase order.

Just adding a report to the Query Data Dashboard would be a good temporary fix and presumably very quick/easy to implement, it would just need to be a report which only returns SKU's that are at or below minimum level, with columns showing the minimum/current stock levels, Supplier and Category for each SKU, possibly some other useful columns that I can't think of off the top of my head. At least then users could export this and sort it by supplier/category to see what needs ordering from a particular supplier and copy/export this info easily. There are similar reports to this already so you could even just add a couple of columns to the existing reports, there are just none that have all the relevant columns at present.

The below Custom Script might be useful to others struggling with this, it'll create a report showing only stock at or below Minimum Level sorted by CategoryID so you can use Categories to mark which supplier each SKU comes from if you aren't using Categories for anything else.

SELECT
si.ItemNumber, si.ItemTitle, sLoc.Location, sl.Quantity, sl.InOrderBook, sl.OnOrder, (sl.Quantity+sl.InOrderBook+sl.OnOrder) as TotalQty, sl.MinimumLevel, (sl.MinimumLevel-sl.Quantity+sl.InOrderBook+sl.OnOrder) as QtyToOrder, si.CategoryId, il.BinRackNumber
FROM
StockItem si
LEFT OUTER JOIN StockLevel sl on si.pkStockItemId = sl.fkStockItemId
LEFT OUTER JOIN StockLocation sLoc on sl.fkStockLocationid = sLoc.pkStockLocationId
LEFT OUTER JOIN ItemLocation il on il.fkStockItemId = si.pkStockItemID AND il.fkLocationId = sLoc.pkStockLocationId
WHERE
si.bLogicalDelete = 0
AND
sl.Quantity + sl.InOrderBook + sl.OnOrder <= sl.MinimumLevel
AND
sl.MinimumLevel > -1
ORDER BY
si.CategoryId, si.ItemNumber, sLoc.Location

Thank you David.

That is very good of you to offer this. However, Linnworks really have to look at priorities here. This is absolutely terrible that this does not exist. I think March is just too long. Even if it means the basic functions of what you are working on are available and the low stock per supplier option can be made available this would help.

Please advise.

Have to add my voice to the plethora of users who are absolutely astonished that a stock management system, which forms a part of the Linnworks offer, does not have a low stock reporting facility by Supplier. Having spent 30 years in the logistics business, I can't think of any of my previous employers who would have allowed their WMS designers not to include this - it's basic functionality, and you shouldn't have to pay for a custom script to be written for such fundamentals. Perhaps time to review our commitment to Linnworks as the solution to our needs.

Hello Klaas

Thanks for your input, but there's a slight flaw in your solution - we can't get Linnworks Desktop to downloa. We keep getting an error. I've tried installing with the help of the chat support team, but they are obsessed with it being related to a firewall, even though they can't tell me what firewall stops the download happening or why. It doesn't seem to be stopping the download anyway, that completes normally. The error message refers to a check current version number, and an inaccessible server. Any suggestions how we address this. Your solution may be good, but we can't implement it because of this.

John

I hope that also the ability to add item specific discount and invoice level discount - so we can account for early settlement on invoice rather than having to calculate each SKU of export, adjust and reimport. A needed function please.