arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

Fulfilled Order Items Feed

Explore the Fulfilled Order Items Feed, containing items fulfilled from a specific facility in HotWax Commerce

hashtag
Introduction

The Fulfilled Order Items Feed is a JSON-formatted feed generated from HotWax Commerce OMS, organized by order. It includes order items that have been successfully fulfilled from a specific facility. This feed is crucial for updating inventory deltas to ensure accurate inventory levels in external systems like ERP. Notably, it only includes orders that have been fully fulfilled; orders with reserved items that have not yet shipped are excluded as they may still undergo rejection and re-brokering to another facility for fulfillment.

hashtag
Use case

hashtag
Synchronizing Inventory Changes with ERP Systems

The Fulfilled Order Items Feed helps retailers who use fulfill orders through external systems but require updates to inventory deltas for maintaining accurate inventory levels, particularly within their inventory management systems like ERPs. This feed provides essential raw data directly from OMS, enabling retailers to utilize it as is or after transformation for seamless integration into external systems via file-based methods. This ensures that inventory records remain precise and up-to-date across various platforms.

hashtag
Customization

The Appeasements Financial Feeed Order Items feed has certain out-of-the-box customizations that allow users to generate the feed as per the requirements.

chevron-rightSample Fulfilled Orders Items Feedhashtag

hashtag
Sample snippet from full JSON file to make inventory corrections

Parameter
Description

shippedQuantity

The quantity of items shipped from the ordered quantity.

goodIdentifications

All identifications of the product in HotWax Commerce used to identify the product in external systems

goodIdentificationTypeId

The type of the unique product Identifier in the external systems (e.g. Shopify product SKU)

IdValue

The value of the GoodIdentificationTypeId

Parameter

Description

productStoreId

Allows you to set the product store IDs to generate brand-specific feed.

itemQuantity

Ordered quantity

productId

The internal Id of the product in HotWax

facilityId

The internal Id of the facility in HotWax

facilityExternalId

The Id of the facility in the external systems

facilityTypeId

The type of the facility

ParentFacilityTypeId

The type of the parent facility, used to group various facility types.

[ {
  "productStoreId" : "NN_STORE",
  "orderId" : "36421",
  "orderName" : "NNUS#10055",
  "orderDate" : "2022-06-17T07:24:32-04:00",
  "orderStatusId" : "ORDER_COMPLETED",
  "entryDate" : "2022-06-17T07:26:32-04:00",
  "currency" : "USD",
  "grandTotal" : 70,
  "orderItemSeqId" : null,
  "itemStatusId" : null,
  "itemQuantity" : null,
  "unitPrice" : null,
  "orderItemExternalId" : null,
  "shipGroupSeqId" : null,
  "slaShipmentMethodTypeId" : null,
  "postalContactMechId" : null,
  "telecomContactMechId" : null,
  "externalFulfillmentOrderItemId" : null,
  "fulfillmentStatus" : null,
  "customerFirstName" : "Ashish",
  "customerLastName" : "Sharma",
  "facilityId" : null,
  "facilityExternalId" : null,
  "facilityTypeId" : null,
  "parentFacilityTypeId" : null,
  "statusDatetime" : null,
  "productId" : null,
  "salesChannel" : "WEB_CHANNEL",
  "customerPartyId" : "36695",
  "shippedQuantity" : null,
  "shipmentId" : null,
  "shipmentItemSeqId" : null,
  "shippedProductId" : null,
  "statusId" : null,
  "destinationContactMechId" : null,
  "destinationTelecomNumberId" : null,
  "shipmentMethodTypeId" : null,
  "trackingIdNumber" : null,
  "carrierPartyId" : null,
  "orderIdentifications" : [ {
    "fromDate" : "2022-06-17T07:26:32-04:00",
    "orderId" : "36421",
    "lastUpdatedStamp" : "2022-06-17T07:26:32-04:00",
    "idValue" : "4449150697543",
    "orderIdentificationTypeId" : "SHOPIFY_ORD_ID",
    "thruDate" : null
  }, {
    "idValue" : "NNUS#10055",
    "orderIdentificationTypeId" : "SHOPIFY_ORD_NAME",
    "orderId" : "36421",
    "fromDate" : "2022-06-17T07:26:32-04:00",
    "lastUpdatedStamp" : "2022-06-17T07:26:32-04:00",
    "thruDate" : null
  }, {
    "orderIdentificationTypeId" : "SHOPIFY_ORD_NO",
    "idValue" : "9055",
    "orderId" : "36421",
    "fromDate" : "2022-06-17T07:26:32-04:00",
    "thruDate" : null,
    "lastUpdatedStamp" : "2022-06-17T07:26:32-04:00"
  } ],
  "customerPartyIdentifications" : [ {
    "lastUpdatedStamp" : "2021-12-28T06:09:33-05:00",
    "partyId" : "36695",
    "partyIdentificationTypeId" : "SHOPIFY_CUST_ID",
    "idValue" : "3304692285511"
  } ],
  "billTo" : null,
  "orderAdjustments" : [ {
    "customerReferenceId" : null,
    "correspondingProductId" : null,
    "orderItemSeqId" : "_NA_",
    "includeInShipping" : null,
    "description" : null,
    "exemptAmount" : null,
    "productPromoId" : null,
    "orderId" : "36421",
    "taxAuthPartyId" : null,
    "lastModifiedByUserLogin" : null,
    "oldPercentage" : null,
    "primaryGeoId" : null,
    "taxAuthGeoId" : null,
    "originalAdjustmentId" : null,
    "secondaryGeoId" : null,
    "createdByUserLogin" : null,
    "orderAdjustmentId" : null,
    "amountAlreadyIncluded" : null,
    "lastUpdatedStamp" : null,
    "amount" : 0,
    "comments" : null,
    "recurringAmount" : null,
    "lastModifiedDate" : null,
    "sourceReferenceId" : null,
    "productPromoRuleId" : null,
    "isManual" : null,
    "productFeatureId" : null,
    "taxAuthorityRateSeqId" : null,
    "overrideGlAccountId" : null,
    "oldAmountPerQuantity" : null,
    "shipGroupSeqId" : null,
    "includeInTax" : null,
    "createdDate" : null,
    "productPromoActionSeqId" : null,
    "sourcePercentage" : null,
    "orderAdjustmentTypeId" : "DONATION_ADJUSTMENT"
  } ],
  "shipments" : [ {
    "trackingNumber" : null,
    "carrierPartyId" : null,
    "shipmentMethodTypeId" : null,
    "shipTo" : null,
    "shipmentItems" : [ {
      "shipmentId" : null,
      "shipmentItemSeqId" : null,
      "orderId" : "36421",
      "orderItemSeqId" : "00101",
      "orderItemExternalId" : "11303349846087",
      "shipGroupSeqId" : "00001",
      "itemStatusId" : "ITEM_COMPLETED",
      "itemQuantity" : 1,
      "slaShipmentMethodTypeId" : "STANDARD",
      "statusDatetime" : "2022-06-17T07:26:32-04:00",
      "productId" : "119214",
      "unitPrice" : 10,
      "facilityId" : "_NA_",
      "facilityExternalId" : "_NA_",
      "facilityTypeId" : "NA",
      "parentFacilityTypeId" : "VIRTUAL_FACILITY",
      "shippedQuantity" : null,
      "goodIdentifications" : [ {
        "lastUpdatedStamp" : "2022-06-17T01:40:13-04:00",
        "goodIdentificationTypeId" : "UPCA",
        "idValue" : "gift1234567",
        "productId" : "119214",
        "fromDate" : "2022-06-17T01:40:13-04:00",
        "thruDate" : null
      } ],
      "itemAdjustments" : [ {
        "customerReferenceId" : null,
        "correspondingProductId" : null,
        "includeInShipping" : null,
        "description" : null,
        "exemptAmount" : null,
        "productPromoId" : null,
        "orderId" : "36421",
        "taxAuthPartyId" : null,
        "lastModifiedByUserLogin" : null,
        "oldPercentage" : null,
        "primaryGeoId" : null,
        "taxAuthGeoId" : null,
        "originalAdjustmentId" : null,
        "secondaryGeoId" : null,
        "createdByUserLogin" : null,
        "orderAdjustmentId" : null,
        "amountAlreadyIncluded" : null,
        "orderAdjustmentTypeId" : "SALES_TAX",
        "lastUpdatedStamp" : null,
        "amount" : 0,
        "comments" : null,
        "recurringAmount" : null,
        "lastModifiedDate" : null,
        "sourceReferenceId" : null,
        "productPromoRuleId" : null,
        "isManual" : null,
        "productFeatureId" : null,
        "taxAuthorityRateSeqId" : null,
        "overrideGlAccountId" : null,
        "oldAmountPerQuantity" : null,
        "shipGroupSeqId" : null,
        "includeInTax" : null,
        "createdDate" : null,
        "productPromoActionSeqId" : null,
        "sourcePercentage" : null,
        "orderItemSeqId" : "00101"
      }, {
        "customerReferenceId" : null,
        "correspondingProductId" : null,
        "includeInShipping" : null,
        "description" : null,
        "exemptAmount" : null,
        "productPromoId" : null,
        "orderId" : "36421",
        "taxAuthPartyId" : null,
        "lastModifiedByUserLogin" : null,
        "oldPercentage" : null,
        "primaryGeoId" : null,
        "taxAuthGeoId" : null,
        "originalAdjustmentId" : null,
        "secondaryGeoId" : null,
        "createdByUserLogin" : null,
        "orderAdjustmentId" : null,
        "amountAlreadyIncluded" : null,
        "orderAdjustmentTypeId" : "SALES_TAX",
        "lastUpdatedStamp" : null,
        "amount" : 0,