Broadleaf Commerce Discussion Forums

I am trying to understand how to extend Broadleaf so that multiple Fulfilment locations (warehouses) can be added. I know that this is available in Commercial edition of Broadleaf, but I cannot afford it...

I am planning to add few tables like blc_ext_fulfilment_locations (location_id,location_name) and blc_ext_fulfilment_location_inventory (location_id,sku_id,quantity).

The question is which is the right object to extend - InventoryServiceImpl or InventoryServiceExtensionHandler or CheckAvailabilityActivity as mentioned in http://www.broadleafcommerce.com/docs/c ... /inventory

I am assuming I should extend InventoryServiceImpl, but I am not able to get how the DAOs are actually getting called from the proxy in this call extensionManager.getProxy().retrieveQuantitiesAvailable.

Which piece of code do I modify so that I can retrieve Inventory from my table blc_ext_fulfilment_location_inventory instead of blc_sku.

I guess , below is the relevant code:

I presume I have made some progress. I extended SkuImpl successfully and could use my customised table MY_SKU to hold inventory instead of BLC_SKU using the extended methods and . Though this seems to be a step in the right direction, it does not fulfill my use case of handling multiple inventory locations/warehouses.

MY_SKU table needs to have an additional column - LOCATION_ID (as part of its Primary Key). I should obviously first be retrieving a record using the additional Location_id field. My use case will determine Location_id based on customer logged in. So, is MY_SKU the right object to work on, or do I need to do something drastically different to achieve my objective.

Any help to achieve the solution will be highly appreciated.

InventoryServiceImpl is the right service to extend. You do not need to worry about the extension manager stuff if you are building it yourself.

I thought I finished implemented everything when this thing struck me suddenly and now I seem to have no other option than to ask you!

I extended Order and stored warehouseId (chosen from the site front-end via a new page I created). This warehouseId, I need to pass to MyInventoryServiceImpl so that I can query my extended table and use it in my decrementInventory method as given below.

If I try to set warehouse id from my warehouse selection controller, it says MyInventoryImpl is actually a proxy and it cannot be casted to my inventory service bean.

My method in MyInventoryServiceImpl is like this:

@Resource(name = "blWarehouseSkuDao")
protected WarehouseSkuDaoImpl w;

...

@Override
public void decrementInventory(Map<Sku, Integer> skuQuantities,
Map<String, Object> context) throws InventoryUnavailableException {

for (Map.Entry<Sku, Integer> entry : skuQuantities.entrySet()) {
Sku sku = entry.getKey();
Integer value = entry.getValue();

WarehouseSkuImpl ws = w.getStock(warehouseId,sku.getId().intValue());
ws.setInventory(ws.getInventory()-value.intValue());

w.save(ws);
}

super.decrementInventory(skuQuantities, context);
}

Ok. I fixed it. I was using MyInventoryServiceImpl instead of the interface MyInventoryService.

Hi, can you share the github gist of modification? thank you very much.

My country is not supported by broadleaf enterprise edition.