Implemented

Reorder Low Stock funtionality in .Net

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

Can it be replicated in .Net?


22 people like this idea

Thanks Fedor for your response and good news that this is in the pipeline. The only problem with this is that we will need to edit the tab view every time for each supplier. This is fine, but it would be easier to access the supplier on the drop down menu as well (please see attached) as you can already do for say "Extended Property", "Title", etc - we can then keep just one "running low" tab open. thanks for your help :) 


I cannot stress enough, and I have done on many occasions that filtering a view by supplier is of paramount importance, such as Andrew Briggs suggests.

When ordering from suppliers the typical workflow procedure is not to go through every supplier and think to yourself I will add that item to the purchase order and when I have enough items on the list I will send it to the suppler.


The typical workflow is usually to say today I am going to order from Acme Soap, lets see which items that Acme Soap supplies, are running low, from this list i can see that 10 items supplied by Acme Soap need reordering. Lets select all ten of those items and either add all to a purchase that exists or create a new one.

This is how the functionality works in desktop and with out filtering by supplier it makes the whole reorder point functionality hard work and is almost a step back in terms of  functionality rather than a step forward. I can understand why it may be difficult to implement a filter by supplier in the inventory view itself however I do think on this occasion a separate window like the reorder point functionality on desk top is required so you can either add a separate item from the inventory screen if you need to but be able to go to a (proposed) reorder screen to order items filtered by supplier.

I do welcome the new order point functionality and the work that has been put in but please do not belittle all of that hard work by missing one of the most key features of the desktop functionality.

On a second point on some other multi channel systems I have seen the option to select a target quantity on an inventory item as well as a minimum level. I think having both of these would give the user more options when it comes to reordering.

This is awesome Fed! 
My 2 cents is echoed above, a clear way to filter by a supplier in the 'my inventory' screen is something we are asked a lot :)


All the best,

Charlie McBroom

 

Fitted Commerce - Ecommerce Agency and Linnworks Specialists

The Linnworks User Hub - Facebook Group for Linnworks Users

I will confirm this tomorrow, however I believe the filter for default supplier will be available on the immediate level as well the view edit filter. 

Thanks for the update.

I do feel that there needs to be a reorder point button from within the purchase order itself alongside the add item button. Adding items direct from the inventory is very useful, but having a feature contained with the purchase order screen is also needed, this also allows for the inventory views to be less cluttered with excessive views. If you have already selected the supplier in the purchase order. Selecting a reorder button would automatically filter out items relating only to that supplier thus I presume being a lot faster as you are only selecting from maybe 100 products instead of possible 1000's. You already have the ideal solution with the reorder point in desktop with the exception of average daily consumption. Please replicate this window with the average consumption tagged on and the ability to filter.

Maybe when you clicked on add item in the purchase order screen you could have the option to see a view you have predefined in the inventory window with the ability to select more than one item at a time and add to the purchase order.

Hi Fedor. Can you explain how to select which mode is used to calculate the quantities on the PO?

I just want it to top up to the Minimum Stock Level but it seems to default to the "PO Mode" and calculates an amount based on the last 3 POs and when they were ordered.

Ok, I can confirm the dev team implements the drop down for Default Supplier selector. 


@Paul Kidd, its a very valid point - being able to see what else is up for reorder from supplier from PO. The PO screen as a whole is up for complete redesign. We are clearing some important stuff off the plate at the moment, and I am sure PO rework is pretty much the next thing to be done, and reorder suggestions will definitely be a part of it. 

@Richar Mayers, be default it will attempt do an average of last 3 POs, if they are not available or POs are two old to consider it will default to bringing this up to minimum level. 


Unfortunately there is no setting/option to force it to use Minimum Level at the moment. But the good news is the configuration option is already implemented and will be released very soon. Once its out I will update this tread and post a little video on how to use it.



That's great. Thanks Fedor. This functionality is the only reason we still use the desktop version so it'll be good news when we can fully switch.

@Jacqui Connor, Confirmed that Minimum supplier reorder quantity is taken into consideration when we are adding to PO. It adds the item to the list but with warning, you then have to acknowledge it before adding to PO. This is done to prevent user you accidentally placing a PO purely off the data in the supplier info for more than you actually need. 

https://screencast-o-matic.com/watch/cq1tjvT9LR


Oh no a warning for each product won't work - that is simply too long winded and a horrific thought when you are ordering hundreds of items.  We don't need a warning in desktop it just does it automatically and has never been a problem.  


Please remove the warning function - it is basically pointless as if the supplier only supplies a minimum quantity they are just going to reject your order or just send the minimum anyway - so your PO will be wrong.  


You appear to be creating this as if people are only placing occasional orders and have all the time in the world on their hands.  Not the case, this is done at the very least twice a day with us and needs to be a very quick action, like it is in desktop.  Swift and easy, create PO for low stock, tick fulfill paid orders, tick or untick a pending option as required, a quick add to order function for any extra items, save, email to supplier.  No messing about.  Bish bash bosh.


Also you don't have the 'Fulfill paid orders' option - mainly buy to order on a daily basis and top up on current popular items - not everyone is buying stock for the future!  And FYI, optimum levels looking at the past 3 POs are pretty useless with seasonal businesses, just because you needed 1000 witches brooms in October it doesn't mean you need them in November!  Same thing with trends/fashion - optimum levels don't take account of changing trends, they just look at previous orders and can't replace the human element.  It's nice that you have all spent so much time on the analytical data side but real life isn't that simple and for many of your customers whose inventory and seasons change constantly I don't think it's of much use.


Please make this a quicker function and include 'fulfill paid orders'.


Thank you



@Jacqui Connor,
1) We can't remove this warning all together as this is place for a good reason, to prevent serious mistakes in re-ordering. We could create one click acknowledgement of all warnings to speed things up. Or put an config option in settings to ignore the check and always default to minimum supplier quantity. 


2) Placing Purchase Order for out-of-stock items in Open Orders, see the following video: https://screencast-o-matic.com/watch/cq1t6BTRcc

We essentially changed the workflow from desktop to now link Purchase Order item directly to open order - in effect when you get the items in from supplier you will now know which orders need to be shipped out to the customer. It also allows you to inform the customer as to when they can expect their order to be fulfilled based on the link to the purchase order. 


3) Reorder amount is worked out based on a very basic logic - To Min level (taking supplier min order into account) - everything that is actually due, or amount based on previous 3 Purchase Orders. We do however have very comprehensive stock forecasting model which works very well for seasonal and variable demand products, long and variable lead time. This functionality only available on Business plan. Forecasting will determin the exact amount you need to reorder from supplier with very high degree of accuracy as it runs quite clever forecasting model dynamically everytime stock changes (consumed or delivered). Without forecasting automation the best bet is to set Min Level to what you need at this point in time. Many customers do this using their own formulas in excel and then simply importing the file into Linnworks on periodic bases. 


Re: 


1) You definately need to implement both of those methods to make it manageable


2) That function already exists in desktop!  However the Fulfill Paid Orders option is much better, you just chose one supplier at a time to create an order for rather than all at once, less complicated, it's a smoother transaction, leads to less errors.

 

3) Seasonal forecasting would only work if the exact same items were for sale year in year out and there was never anything new - imagine how boring the world would be if that were the case, although of course wouldn't our jobs be so much easier, I could retire and let robots do it all for me.  I don't know what 'business plan' relates to these days, we have been with LW since about year dot and are on a legacy plan.

1) we will look into it

2) the trouble with Reorder to fulfill all open orders in desktop is that it didn't link purchase orders to open orders, therefore if you placed a PO and then received more backorders, the system wouldn't quite know which orders to include into the reorder amount. Now we have direct link which makes everything flow smoothly. It is also much easier to place multiple POs for all orders that need stock reordered by simply selecting all orders and hitting Add to PO for all out-of-stock



Login to post a comment