Multi-warehouse implementations

You can define multiple inventory locations in the system. These are any place with inventory you want to track, whether a warehouse is used for shipping, individual stores, a factory, or whatever meets your needs. You can even include trucks that are delivering orders.

By default, Commerce Connect supports shipping from one central warehouse location. You can still track overall inventory if you have multiple shipping sources but do not want to edit Optimizely Commerce Connect. You must figure out shipment fulfillment logistics from individual shipment locations, outside of Commerce Connect.

In-store pickup from any store location is provided, which can handle any locations defined as places for pickup (but not for fulfillment). In Commerce Connect, these are Fulfillment Centers from which you can ship and Pickup Locations at which a customer can pick up an order. Without customizing, you can have only one Fulfillment Center but any number of Pickup Locations.

These limitations exist because no one knows your business like you. Sample code provides some business logic to support fulfillment from multiple locations. However, each business has its own approach to fulfillment practices, and no logic supports more than a few situations at a time.

The changes to support multiple locations across infrastructural code are hidden in the assemblies, new services, and the logic visible in the workflows. The infrastructural changes do not matter to most customers, although they may affect existing customized installations. Implement your needs directly in the workflows or by replacing the services.

The core business logic for inventory and shipping is implemented in the workflows. The key places to look for these are:

No default implementation supports multiple fulfillment centers. To have multiple fulfillment centers, you need to:

The following sections detail the required modifications.

The default installation is designed to raise an exception for certain operations when multiple warehouses are flagged as fulfillment centers. This exception is raised in the OrderGroupActivities\OrderGroupActivityBase workflow in the CheckMultiWarehouse() method. The method is called from multiple locations (for example,  AdjustInventoryActivity.cs, AdjustInstoreInventoryActivity.cs at the time of this writing), so it is easier to clear the contents rather than removing all references. To allow multiple fulfillment warehouses, replace the existing method with the following:

protected virtual void CheckMultiWarehouse(){}

You can also add consistency checks to meet your needs.

The second part is the major piece of the implementation and cannot be described in depth because the actual logic depends on the needs of a particular business. This guide only covers where an implementation must override the default logic.

The main piece of business logic to replace is in the GetFulfillmentWarehouseForLineItem() method in this workflow. In the default implementation, it does little more than find the default warehouse (see line 87). Replace this with custom logic.

As workflow inherits from OrderGroupActivity, you already have an OrderGroup and its data available for all calculations and logic. To determine your list of warehouses and information about their available inventory, access two new service interfaces that were added for release 10. These are the IWarehouseRepository and IInventoryService. These can be instanced in code via the following:

ServiceLocator.Current.GetInstance<IWarehouseRepository>() ServiceLocator.Current.GetInstance<IInventoryService>()

See Warehouse/Inventory Services for details. The current interfaces should be straightforward to use, although you may need to expand their functionality if you need additional information (for example, geolocation) to determine your fulfillment warehouse selection.

ShipmentSplitActivity also has a reference to warehouses that may be of interest. When a new split shipment is created, it is marked as sourcing from the same warehouse as its first line item. This works for a single fulfillment warehouse and in-store pickup but may not function as desired for a more complicated multi-warehouse solution. Determine if the SplitForm() method works for your custom solution. Adjust it if not.

The existing workflows can manage the inventory in your warehouses out of the box as long as your custom warehouse selection logic assigns the correct warehouse for each line item. However, suppose you need to change the processing logic for inventory, such as changing how backorders and preorders are handled or triggering external processes to balance inventories between warehouses as inventories get low. In that case, you need to change the logic in AdjustInventoryActivity to suit your needs. The main method with which to do that is AdjustStockItemQuantity().

The default implementation of the in-store pickup feature handles the store inventories out of the box. You may also want to consider additional inventory handling here, such as resupplying store inventory. The handling for in-store pickup inventories is found in AdjustInstoreInventoryActivity and CheckInstoreInventoryActivity. The former is probably the correct place to modify this for most implementations, but you can consider adjusting the latter instead.

Many functions for accessing warehouse and inventory data were moved into services, which you can replace in your implementation. However, the default implementations work with the existing Commerce Connect controls and database as-is. This could be useful if you want to encapsulate the current implementation to provide more methods (such as to support geolocation-based fulfillment logic), or if you wish to replace them entirely to manage your inventory with a new or external system.

If you want to implement a custom inventory integration, there are two main services to consider:

Review the interfaces for the required properties and methods documented in the method signatures. They should be self-explanatory in terms of the expected input and output values. What you need to do depends on the scope of your changes. It needs to be considered on a case-by-case basis.

The recommended model for managing inventory data across separate ERP and Optimizely Commerce Connect systems is to update Commerce regularly and allow Commerce Connect to track inventory internally between updates. Allowing Commerce to manage its own inventory provides the best performance in almost all situations. The main issue from a business standpoint is whether inventory is being sold (or otherwise removed) independently of Commerce Connect. In this case, find a way to reconcile orders, by updating Commerce Connect on-the-fly or by an appropriate backorder process.

You need to consider carefully the pros and cons of the various approaches (for instance, development costs for integrations and whether it is worth incurring the higher latency costs of communicating with your ERP directly to have perfectly accurate numbers at all times). When reviewing these interfaces, remember that some interfaces may be switched to use business objects instead of ID fields.