Unfulfillable Sideline Implementation

What is the purpose of this article?

The purpose of this article is to keep a check on unfulfillable orders and save their reasons and remarks as to why they were unfulfillable. This will keep our clients updated about unfulfillable orders. And they can send inventory for only those items which are unfulfillable.
In this article, we will thoroughly discuss what reasons and remarks will be saved for unfulfillable orders on which basis and its infrastructure diagram.

To understand the Auperator flow for Unfulfillable orders, kindly go throgh the below link.

Auperator Flow for Unfulfillable Orders

What is the approach to achieve this task ?

We have taken two different approaches to achieve this task.

When the Product is out of stock, in this case, the orders will be fetched from DB and according to their status, reason, remarks etc. will be saved.
When Shipment is Rejected due to tech/inventory physically not found, in this case, the events will be listened and according to their status, reason, remarks, etc. will be saved.

Sequence diagram for the approach taken when product is out of stock

Sequence diagram for the approach taken when Shipment is Rejected due to tech/inventory physically not found

What are the steps to achieve the above task ?

When the Product is out of stock,

In POST Api orders/algolia/sync/update, Fetch those orders from database which were created in last two minutes.
When the orders are fetched, check if "order_items.shipment_id = 0"
AND "order_items.lineOrderItemstatus = failure"
AND "order_items.status = UNFULFILLABLE"

In this case, set these details in OrderReturnAlgoliaModel and OrderReturnTags model
Unfulfillable reason: Product is out of stock
Unfulfillable remark: Review inventory logs to check last update sent on channel
wasUnfulfillable = true (in Algolia), 1 (in DB in order_return_tags table)
orderUnfulfillableTimestamp
orderStatus = Unfulfillable
expectedShipdate = orders_unfulfillable.expectedShipDate
warehouseLocation= orders_unfulfillable.warehouseId

3. check if "order_items.shipment_id = 0"
AND "order_items.lineOrderItemstatus = success"
AND "order_items.status = FULFILLABLE"

In this case, set these details in OrderReturnAlgoliaModel and OrderReturnTags model
Unfulfillable reason: Other roduct is out of stock
Unfulfillable remark: Review inventory logs to check last update sent on channel
wasUnfulfillable = true (in OrderReturnAlgoliaModel ), 1 (in OrderReturnTags model)
orderUnfulfillableTimestamp
orderStatus = Unfulfillable
expectedShipdate = orders_unfulfillable.expectedShipDate
warehouseLocation= orders_unfulfillable.warehouseId

4. check if "order_items.shipment_id = 0"

AND "order_items.lineOrderItemstatus = not_found"
AND "order_items.status = UNFULFILLABLE"

In this case, set these details in OrderReturnAlgoliaModel and OrderReturnTags model
Unfulfillable reason: Product is out of stock.
Unfulfillable remark: Contact Eshopbox support.
wasUnfulfillable = true (in OrderReturnAlgoliaModel ), 1 (in OrderReturnTags model)
orderUnfulfillableTimestamp
orderStatus = Unfulfillable
expectedShipdate = orders_unfulfillable.expectedShipDate
warehouseLocation= orders_unfulfillable.warehouseId

5. check if "order_items.shipment_id = 0"

AND "order_items.lineOrderItemstatus = not_found"
AND "order_items.status = FULFILLABLE"

In this case, set these details in OrderReturnAlgoliaModel and OrderReturnTags model
Unfulfillable reason: Other product is out of stock.
Unfulfillable remark: Contact Eshopbox support.
wasUnfulfillable = true (in OrderReturnAlgoliaModel ), 1 (in OrderReturnTags model)
orderUnfulfillableTimestamp
orderStatus = Unfulfillable
expectedShipdate = orders_unfulfillable.expectedShipDate
warehouseLocation= orders_unfulfillable.warehouseId

6. check if "order_items.shipment_id = 0"

AND "order_items.lineOrderItemstatus = not_found"
AND "order_items.status = Rejected"

In this case, set these details in OrderReturnAlgoliaModel and OrderReturnTags model
Unfulfillable reason: Item not found at the location.
Unfulfillable remark: Inventory under investigation
wasUnfulfillable = true (in OrderReturnAlgoliaModel ), 1 (in OrderReturnTags model)
orderUnfulfillableTimestamp
orderStatus = Unfulfillable
expectedShipdate = orders_unfulfillable.expectedShipDate
warehouseLocation= orders_unfulfillable.warehouseId

7. check if "order_items.shipment_id = 0"

AND "order_items.lineOrderItemstatus = not_found"
AND "order_items.status = PARTIALLY_FULFILLABLE"

In this case, set these details in OrderReturnAlgoliaModel and OrderReturnTags model
Unfulfillable reason: Other item not found at the location.
Unfulfillable remark: Inventory under investigation.
wasUnfulfillable = true (in OrderReturnAlgoliaModel ), 1 (in OrderReturnTags model)
orderUnfulfillableTimestamp
orderStatus = Unfulfillable
expectedShipdate = orders_unfulfillable.expectedShipDate
warehouseLocation= orders_unfulfillable.warehouseId

8. Save the details set in OrderReturnAlgoliaModel in Algolia.

9. Save the details set in OrderReturnTags in order_return_tags table of DB.

When Shipment is Rejected due to tech/inventory physically not found,

Listen events whose "resource" : "shipment"
and "eventSubType" : "rejected"
If the event contains "cancelledDueToNotFound" : "YES"

In this case, set these details in OrderReturnAlgoliaModel and OrderReturnTags model
Unfulfillable reason: Item not found at the location.
Unfulfillable remark: Inventory under investigation.
wasUnfulfillable = true (in OrderReturnAlgoliaModel ), 1 (in OrderReturnTags model)
orderUnfulfillableTimestamp
orderStatus = Unfulfillable

3. If the event contains "cancelledDueToNotFound" : null or key not present

In this case, set these details in OrderReturnAlgoliaModel and OrderReturnTags model
Unfulfillable reason: Product is out of stock
Unfulfillable remark: Contact Eshopbox support
wasUnfulfillable = true (in OrderReturnAlgoliaModel ), 1 (in OrderReturnTags model)
orderUnfulfillableTimestamp
orderStatus = Unfulfillable

4. Listen events whose "resource" : "order_item"

5. if lineItemOrderStatus = not_found, status = PARTIALLY_FULFILLABLE

In this case, set these details in OrderReturnAlgoliaModel and OrderReturnTags model
Unfulfillable reason: Other product is out of stock.
Unfulfillable remark: Contact Eshopbox support..
wasUnfulfillable = true (in OrderReturnAlgoliaModel ), 1 (in OrderReturnTags model)
orderUnfulfillableTimestamp
orderStatus = Unfulfillable

6. if "lineOrderItemstatus = not_found", "status = FULFILLABLE"

In this case, set these details in OrderReturnAlgoliaModel and OrderReturnTags model
Unfulfillable reason: Other product is out of stock.
Unfulfillable remark: Contact Eshopbox support.
wasUnfulfillable = true (in OrderReturnAlgoliaModel ), 1 (in OrderReturnTags model)
orderUnfulfillableTimestamp
orderStatus = Unfulfillable

7. Save the details set in OrderReturnAlgoliaModel in Algolia.

8. Save the details set in OrderReturnTags in order_return_tags table of DB.

Orders and Shipping Engine