Skip to end of banner
Go to start of banner

Order Custom Attributes

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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

  • No labels