CREATE INDEX IDXK4K1X05SF4W59LIA0C819PV20 ON BLC_SKU_INVENTORY (SKU_CODE);
- v1.0.0-latest-prod
blc_sku_inventory.sku_codeThe introduction of Serialized Inventory in Inventory Service 1.7.13-GA saw the removal of several indices including one on sku_code (id IDXk4k1x05sf4w59lia0c819pv20).
Analysis since shows that the latter is an essential index to maintain for anyone not using Serialized Inventory.
Therefore, we have reintroduced it by default, and it will be present for all new projects on the 2.1.x and subsequent release trains.
We advise all users to verify that this index is in place.
If missing, we recommend adding it as it avoids table scans of the blc_sku_inventory table in typical usage.
CREATE INDEX IDXK4K1X05SF4W59LIA0C819PV20 ON BLC_SKU_INVENTORY (SKU_CODE);Updated the FulfillmentStatusChange listeners to read Order and OrderFulfillment by ids, to accommodate the new message payload that only contains IDs to avoid RecordTooLargeException for large fulfillments
The listeners will still check for the full Order and OrderFulfillment payload in the message for the sake of backward compatibility, but the logic is subject to removal in a future release
broadleaf.inventory.orderprovider.url
Description: The base url for an external order service
Default value: https://localhost:8470/order
broadleaf.inventory.orderprovider.order-uri
Description: The URI path for basic singular order retrieval
Default value: /orders
broadleaf.inventory.orderprovider.fulfillment-uri
Description: The URI path for basic singular fulfillment retrieval
Default value: /order-fulfillments
broadleaf.inventory.orderprovider.service-client
Description: The service client to use when calling order services
Default value: inventoryclient