Store Fulfilled Order Items
Efficiently manage store-fulfilled order items with OMS integration, generating M3-compatible feeds through Moqui and Apache NiFi.
The order items brokered to warehouses are sent to M3 for fulfillment and so M3 has the information about the fulfilment of these orders.
The orders brokered to Stores are fulfilled using OMS fulfillment application. These orders need to be sent to M3, so that the orders could be reconciled and used for financial postings.
Implementation Flow
This feed flow uses below components in the integration layer
Moqui - This is used to generate the generic Fulfilled Order Items Feed JSON based on the configured parameters.
A Service Job will be set up with below parameters. This job will fetch the required fulfilled order items and put the OMS Store Fulfilled Order Items JSON feed file on a folder in SFTP.
parentFacilityTypeIds - PHYSICAL_STORE
productStoreIds -
sinceDate - <Add date if some historical fulfilled orders need to be skipped eg.2023-08-31 08:00:00>
Apache NiFi - This is used to generate the feed format required by M3.
List and Fetch the File from the input folder.
Transforms the OMS Store Fulfilled Order Items Feed format into the M3 format using Jolt transform capabilities in-built in NiFi.
Perform updates on some fields before keeping file for M3.
StartShip - this is set to current time as per the timezone configured in OMS
StopShip - this is set to current time as per the timezone configured in OMS
Convert the JSON into the final CSV to be share with M3
Generate the file name by appending the current time as per the timezone configured in OMS
This helps in identifying the time at which feed is being kept for M3
Put the CSV file on SFTP
Put the file in the folder for M3
Put the file in the folder for logging purpose in OMS
NOTE this file resides in SFTP for a fixed configured duration like 30 days
SFTP - This is used as the medium to put/read the feed files.
M3 Feed File details
FTP location
Sample Feed file Name format
M3 Store Fulfilled Order Items Feed Sample
Last updated