Page tree
Skip to end of metadata
Go to start of metadata


Delivery Method

Message Format

WSDL

Web service

XML

Refer to OpenTools Web Services Locations for information.

File

XML

N/A

APIJSONSee SyncInventoryBalance

The Synchronize Inventory Balance message contains inventory status information and enables the WMS to send inventory counts to EDGE OMS.

Note:

This message supports multiple SKUs. Each message may contain up to 5,000 SKUs.

Two scenarios are possible for this message.

  1. The Synchronize Inventory Balance message may be sent as a response to the Inventory Balance Request message.

    The following activities take place after an Inventory Balance Request message is issued:

    Step

    Event Description

    1.

    External WMS system receives an Inventory Balance Request message from OpenTools. Any of three processes will generate an Inventory Balance Request from EDGE:

    1. A request can be scheduled to generate at a specific time via EDGE.
    2. A request can be made manually from EDGE.
    3. A request is made automatically from EDGE if an Allocation Failure occurs.


    FYI

    WMS system may send an unsolicited Synchronize Inventory Balance message to OpenTools without first receiving an Inventory Balance Request

    2.

    WMS system responds by delivering the Synchronize Inventory Balance message to OpenTools.

    3.

    EDGE OMS inventory is compared against WMS inventory and logged to the EDGE Synchronize Inventory report.

    4.

    Optionally, EDGE OMS inventory can be updated with supplied values where discrepancies are found.

    .

  1. The diagram below illustrates the process described in Synchronize Inventory Balance Workflow Narrative
     

The following message type settings apply to Synchronize Inventory Balance messages:

Message Type Setting

Description

Field Type

Allowed Options

Inventory Not Available

Inventory for this provider will not be made available.

Radio Button

Yes, No

Generate Amazon Inventory Item Message

Specifies whether an Amazon Inventory Management (AIM) /Marketplace Web Service (MWS) message should be generated.

Radio Button

Yes, No

The data dictionary below defines the Synchronize Inventory Balance character fields:

XML Element

Data Type

Field
Length

XML File
Comment

EDGE Field

Value/Description

XPATH: /Message/Head

MessageID

int




Unique message identifier

Date

varchar

64



yyyy-mm-dd or mm-dd-yyyy

MessageType

varchar

64

Required


SyncInventory

XPATH: /Message/Head/Sender

SystemID

varchar

50

Required

MessageDestination.providerCode

System initiating message

CompanyID

varchar

50



(Reserved for future use)

ReplyToQ

varchar

128



URL for message reply

XPATH: /Message/Head/Recipient

SystemID

varchar

50



(Reserved for future use)

CompanyID

varchar

32

Required

MessageDestination.xRefMerchantId

Company identifier

ReplyToQ

varchar

128



URL for message reply

XPATH: /Message/Body/SYNCINVENTORY
(Multiples allowed; should be at least one set per message)

XREFMERCHANTID

varchar

50

Required

MessageDestination.xRefMerchantId

EDGE merchant identifier

SKU

nvarchar

128

Required

SKU

SKU associated with catalog item

QTY

int



Inventory_Provider_Xref.qtyOnHand

QTYONHOLD

int



Inventory_Provider_Xref.qtyOnHold

QTYALLOCATED

int



inventory_sync_history.warehouseQtyReserved

LASTRECORDchar1

Use to indicate that this message/SKU is the last one within the batch
Valid values = Y, N

FYI . . .

A value of “Y” triggers an Inventory Sync Report communication event

Click here for an example of a Synchronize Inventory Balance XML message:

  

Click here to access the XSD for the Synchronize Inventory Balance XML message:

    




  • No labels

1 Comment

  1. What is the optimal batch size for this message assuming 50k skus for merchant and 3 providers?

    On review of some details from Gemni (https://gemini.jaggedpeak.com/workspace/0/item/28528), found:

     Amany Moussa 1/20/2016 3:24:34 PM

    As discussed with Philip;

    For local Dev Server 95K SKUs in batches of 10K were processed in 2minutes.

    Need to run same test case in QA and measure processing time for same number of SKUs and Batches taking into consideration the server physical configuration to be able to present these number as baseline for Sync Inventory task performance. 

     Processing Time can be measured as follows:

    1.Process Sync Inventory messages alone. 
    2. Use SQL to query OT db for processing metrics volume, time elapsed 
    (or) 
    use OT log entry to do the same


    References: