We will be keeping them at client level
Inward Order Attributes: Maximum of 10 Custom Order Attributes are allowed
displayable - max 5 attributes
highlighted - max 2 attributes
Only the first 5 Custom Order Attributes can be made Searchable
The existing inward order attribute keys can be updated. There is no restriction on order here.
Inward Order Line Item Attributes: Maximum of 10 Order Line Items Attributes are allowed
displayable - max 3 attributes
highlighted - max 2 attributes
searchable - 0
The existing inward order item attribute keys can be updated. There is no restriction on order/ order item here.
Order / Item Attribute creation during Inward Order creation:
UI Workflow:
Single order creation:
The user selects the order and order item custom attribute keys that are applicable for the current inward order.
Inward Order Item upload CSV will consist of the order / order item attribute fields.
User will provide the details and upload this.
On success,
Order attributes will be created for the inward order for the provided attribute keys.
Order Item attributes will be created for the inward order item for the provided attribute keys.
Multiple order creation:
No changes in the existing workflow
- User can add inward order / item attributes for multiple orders using Inward Order / Item Attribute bulk update workflow in UI
Order / Item Attribute update:
UI Workflow (Inward Order Attribute update):
Select the client.
Select the order attributes that needs to be added / updated for the orders.
Provide a CSV upload consisting of fields - channel order Id, attribute1, attribute2… (for multiple orders)
Keep a limit on number of rows in the CSV file .
The functionality of this API should be:
If the attribute value is already present in the order, then update it with the new value.
If a new attribute is provided (which is defined in the client), then add the new attribute value for the order / order item.
If an attribute value was populated for the order during order creation, but it is not provided during the update, don’t modify the attribute value.
UI Workflow (Inward Order Item Attribute update):
Select the client.
Select the order item attributes that needs to be added / updated for the orders.
Provide a CSV upload consisting of fields - channel order Id, client SKU, attribute1, attribute2… (for multiple orders)
Keep a limit on number of rows in the CSV file and also the number of distinct orders allowed in an upload.
Validate if all the SKUs provided in the CSV are present for the order.
The functionality of this API should be:
If the attribute value is already present in the order, then update it with the new value.
If a new attribute is provided (which is defined in the client), then add the new attribute value for the order / order item.
If an attribute value was populated for the order during order creation, but it is not provided during the update, don’t modify the attribute value.
Order attribute fetch/view
Inward Order Search Screen:
The order and order item attributes will be visible in the Inward order search screen. This will be loaded only when a particular order is viewed.
GRN / Stickering Item Screen:
Display the inward order item attribute for the particular SKU / order for which the item is being GRNed.
Inward Order Posting (Additional)
In case the order / order item attributes are present for the order, send them during inward order posting.
- Currently, we don’t have any restrictions on order / item attribute value update. In case the attributes gets updated even after the postings are sent it will not be handled at our end.
Outward order attributes:
User can configure at max 10 attributes at a client level for an outward order.
The following property is defined for the attributes:
displayable - max 5 attributes
highlighted - max 2 attributes
searchable - max 5 attributes
The existing outward order attribute keys can be updated. There is no restriction on order here.
Outward order item attributes:
User can configure at max 10 attributes at a client level for an outward order item.
The following property is defined for the attributes:
displayable - max 3 attributes
highlighted - max 2 attributes
searchable - 0
The existing outward order item attribute keys can be updated. There is no restriction on order/ order item here.
Outward Order / Item Attribute creation during Outward Order creation:
UI Workflow:
Single order creation:
The user selects the outward order and order item custom attribute keys that are applicable for the current outward order.
Outward Order Item upload CSV will consist of the order / order item attribute fields.
User will provide the details and upload this.
On success,
Outward Order attributes will be created for the inward order for the provided attribute keys.
Outward Order Item attributes will be created for the inward order item for the provided attribute keys.
Multiple order creation:
No changes in the existing workflow
- User can add inward order / item attributes for multiple orders using Outward Order / Item Attribute bulk update workflow in UI
Outward Order / Item Attribute update:
Customer Support Panel:
Provide a mechanism to update outward order / order item for the outwards orders which are visible in the CSP.
The functionality of this API should be:
If the attribute value is already present in the order, then update it with the new value.
If a new attribute is provided (which is defined in the client), then add the new attribute value for the order / order item.
If an attribute value was populated for the order during order creation, but it is not provided during the update, don’t modify the attribute value.
UI Workflow (Outward Order Attribute update):
Select the client.
Select the outward order attributes that needs to be added / updated for the orders.
Provide a CSV upload consisting of fields - channel order Id, attribute1, attribute2… (for multiple orders)
Keep a limit on number of rows in the CSV file .
The functionality of this API should be:
If the attribute value is already present in the order, then update it with the new value.
If a new attribute is provided (which is defined in the client), then add the new attribute value for the order / order item.
If an attribute value was populated for the order during order creation, but it is not provided during the update, don’t modify the attribute value.
UI Workflow (Outward Order Item Attribute update):
Select the client.
Select the outward order item attributes that needs to be added / updated for the orders.
Provide a CSV upload consisting of fields - channel order Id, client SKU, attribute1, attribute2… (for multiple orders)
Keep a limit on number of rows in the CSV file and also the number of distinct orders allowed in an upload.
Validate if all the SKUs provided in the CSV are present for the order.
The functionality of this API should be:
If the attribute value is already present in the order, then update it with the new value.
If a new attribute is provided (which is defined in the client), then add the new attribute value for the order / order item.
If an attribute value was populated for the order during order creation, but it is not provided during the update, don’t modify the attribute value.
utward / Sub Order attribute fetch/view
Outward Order Search Screen:
The order and order item attributes will be visible in the Outward order search screen. This will be loaded only when a particular order is viewed.
Sub Order Search Screen:
The order and order item attributes will be visible in the Sub order search screen. This will be loaded only when a particular order is viewed.
Packing screens:
Display the outward order item attribute for the particular SKU / order for which the item is being packed.
Pick Order Group Search
Select the client.
In case outward order attributes are configured for the client, provide a drop down for with all the searchable attributes keys.
The user can search based on order attributes, by selecting the required attribute key and providing the value that needs to be searched.
All the eligible B2B orders with the attribute value for the given attribute key will be displayed.
Sales Posting (Additional)
In case the order / order item attributes are present for the outward order, send the details for the corresponding sub orders in sales posting.
- Currently, we don’t have any restrictions on order / item attribute value update. In case the attributes gets updated even after the postings are sent it will not be handled at our end.
Packing (Additional)
In case the order / order item attributes are present for the outward order, send the details for the corresponding sub orders for all the SKUs which are present in the shipment.
OUTWARD_ORDER
total - 10, display - 5, highlight - 2, searchable - 5
OUTWARD_ORDER_ITEM
total - 10, display - 3, highlight - 2, searchable - 0
INWARD_ORDER
total - 10, display - 5, highlight - 2, searchable - 5
INWARD_ORDER_ITEM
total - 10, display - 3, highlight - 2, searchable - 0
Audits are captured client level when attribute key gets created / updated. There are no order level audits for attributes similar to sku master
Which screens will show these attributes and where not?
Order search screen in OMS, Order Manager screen in WMS, any other screen asked by client can be considered later.
Attribute Creation
Inward order attributes
Inward order item attributes
Outward order attributes
Outward order item attributes
Display of order & order-item level attributes
In OMS
Display the order and order line item level attributes in the following screens:
search inward order
search outward order (outward & sub order)
In WMS
In all the following WMS screens, UI should only display the attributes with isDisplayable = true and value != null
Screen | Order Attributes | Order Line Item Attributes | Virtual SKU | UOM SKU |
---|---|---|---|---|
GRN | yes (on scan of inward box id) | yes (on scan of barcode) | - | - |
GRN (Client SKU selection popup) | no | yes | - | - |
Stickering Item (Client SKU Selection popup) | no | yes | - | - |
Piece Pick Item | yes (collapsed) | yes (expanded) |
| yes |
Bulk Pick Item | yes (collapsed) | yes (expanded) |
| yes |
Guided Item Based Picking | yes (collapsed) | yes (expanded) | no | yes |
Pick Expired Items | no | no | - | - |
Bulk Break Pick Item | no | no | - | - |
Piece Packing | yes (expanded) | yes (collapsed) | yes | yes |
Bulk Packing | yes | no | - | - |
Bulk Break Pick Item | no | no | - | - |
Bulk Break Desk | no | no | - | - |
Cancel Bulk Break Pick List | no | no | - | - |
Order Manager | yes | yes | - | yes |
Return Order Processing | no | no | - | - |
Recycle Desk | yes | yes |
| yes |
Item Sorting | yes | yes |
| yes |
Search via Custom Order Attributes
User should be able to search via order attributes in Pick Order Group and Gate Pass creation screens
On selection of client, UI should fetch the list of order attributes and populate the attributes with isSearchable = true in a drop down
Currently Single attribute search is sufficient on UI, but in the future UI should support searching via multiple attributes.
UI Changes
Order and Line Item Attributes Configuration
Add a new screen in under Outward Orders section to configure Order and order item-level attributes
The user should be able to select a Client and Attribute type (Order / Order Item)
Below are the limits:
Property | Order Attributes | Order Line Item Attributes |
---|---|---|
Maximum number allowed | 10 | 10 |
isDisplayable | 5 | 3 |
isHighlighted | 2 | 2 |
isSearchable | 5 (first 5 attributes) | - |
The same should be done under Inward Orders section as well
Adding Order and Line Item Attributes
There should be 2 ways to add Order and Line Item Attributes to the orders
During Order Creation
This is applicable only for Single Orders
On selecting the client, UI should fetch the list of all custom order & order line item attributes configured for that client.
Add option on UI to select the attributes via check boxes
The attribute name should be present in the downloaded CSV template
The user should be able to upload the attribute values in order creation CSV
All the custom attribute fields should be non-mandatory in the CSV
Upload order attributes
This is applicable for both Single and Bulk Orders
Add a new tab in Create Orders screen to upload the order and order line item attributes
The user should be able to select the Client via drop down and select the Type as either Order Attributes / Order Line Item Attributes
The user should be able to select the attributes via check boxes
The sample CSV template should have the selected attribute names
All the custom attribute fields should be non-mandatory in the CSV
The CSV template should have the following fields:
order-level: channel order id, attributes (channel order id is unique)
order item-level: channel order id, sku, attributes (channel order id & sku combo is unique)
Updation of Order and Line Item Attributes
Outward order / line item attributes: can be updated via CSP
Inward order / line item attributes: can be updated by a user with oms.admin role (in search orders screen)
Inward Orders