nopSolutions / nopCommerce

ASP.NET Core eCommerce software. nopCommerce is a free and open-source shopping cart.
https://www.nopcommerce.com
Other
9.33k stars 5.34k forks source link

Inventory control using multiple warehouses #5719

Open SelectSystemsInternational opened 3 years ago

SelectSystemsInternational commented 3 years ago

nopCommerce version: v4.4 and All

Steps to reproduce the problem: Use two different warehouses to ship products for the same order or multiple orders

See attached document nopCommerce Inventory Control Issue.pdf

brakim commented 3 years ago

We actually made a plugin to handle this issue, when a customer places a order we add a GA to the PWI Record so we know which order the reservation is for.

If you ship from another location we move the reservation.

We also added a new feature that a Warehouse can have multiple bins and we make reservations against bins and not warehouses.

SelectSystemsInternational commented 3 years ago

These issues could also be considered https://github.com/login?return_to=%2FnopSolutions%2FnopCommerce

GetNearestWarehouse Logically selecting the warehouse in the same country and state makes sense but when there are multiple warehouses you can ship from and you ship to a state that does not have a warehouse then currently the nearest warehouse selected is the first one. In this case the nearest warehouse should be the cheapest option i.e. obtain cost for each warehouse compare an use the lowest cost option - "Least Cost Routing"

Comments in code to consider: //of course, we should use some better logic to find nearest warehouse

//multiple locations? //currently we just compare warehouses //but we should also consider cases when several warehouses are located in the same address
i.e. for 3PL