Brokered Order Items Feed

Discover the Brokered Order Items feed, a JSON-formatted feed generated from HotWax Commerce OMS for streamlined order management.

Introduction

The Brokered Order Items feed is an order-wise JSON-formatted feed generated from HotWax Commerce OMS. This feed contains details about brokered order items, which can be brokered to either Warehouse or Store Type facilities. The feed can be used for integration with other external systems.

Use case

Communication with the External Order fulfillment system

The Brokered Order Items feed is useful for retailers who would like to do fulfillment outside OMS through an external system such as a Warehouse Management System (WMS). This feed provides the out-of-the-box data available from OMS, and retailers can use it as is or after transformation to ingest into external systems through file-based integration.

Customization

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

Parameter

Description

orderId

Allows to generate the feed for a specific order ID.

orderItemSeqId

Allows to generate the feed for a specific order item sequence ID within an order.

parentFacilityTypeIds

Specifies the type of facility from which the brokered order items are being fetched.

productStoreIds

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

systemMessageTypeId

The SFTP path where the feed will be stored.

systemMessageRemoteId

The SFTP credentials required to access the SFTP location.

Sample Brokered Order Items feed

[ {
  "productStoreId" : "SG_STORE",
  "orderId" : "SGSM10007",
  "orderName" : "#1068",
  "orderDate" : "2020-01-15T11:26:03-08:00",
  "orderStatusId" : "ORDER_APPROVED",
  "entryDate" : "2020-01-17T12:31:57-08:00",
  "orderExternalId" : null,
  "currency" : "USD",
  "grandTotal" : 104,
  "orderItemSeqId" : null,
  "itemStatusId" : null,
  "orderItemQuantity" : null,
  "reservedItemQuantity" : null,
  "reservedDatetime" : null,
  "unitPrice" : null,
  "orderItemExternalId" : null,
  "itemDescription" : null,
  "requestedDeliveryDate" : null,
  "requestedDeliveryTime" : null,
  "deliveryWindow" : null,
  "shipGroupSeqId" : null,
  "shipmentMethodTypeId" : null,
  "postalContactMechId" : null,
  "telecomContactMechId" : null,
  "orderFacilityId" : null,
  "carrierPartyId" : null,
  "externalFulfillmentOrderItemId" : null,
  "fulfillmentStatus" : null,
  "customerFirstName" : "Demo",
  "customerLastName" : "User",
  "facilityId" : null,
  "facilityExternalId" : null,
  "facilityTypeId" : null,
  "parentFacilityTypeId" : null,
  "statusDatetime" : null,
  "productId" : null,
  "productTypeId" : null,
  "internalName" : null,
  "salesChannel" : "WEB_CHANNEL",
  "customerPartyId" : "10004",
  "isShippingChargesSent" : "Y",
  "billTo" : {
    "countryGeoCode" : "US",
    "stateProvinceGeoCode" : "TN",
    "contactMechId" : "10802",
    "toName" : "demo user",
    "attnName" : null,
    "address1" : "11 U.S. 11",
    "address2" : null,
    "houseNumber" : null,
    "houseNumberExt" : null,
    "directions" : null,
    "city" : "Knoxville",
    "cityGeoId" : null,
    "postalCode" : "37010",
    "postalCodeExt" : null,
    "countryGeoId" : "USA",
    "stateProvinceGeoId" : "TN",
    "countyGeoId" : null,
    "municipalityGeoId" : null,
    "postalCodeGeoId" : null,
    "geoPointId" : null,
    "encodedAddressKey" : null,
    "latitude" : null,
    "longitude" : null,
    "isResidentialAddress" : "Y",
    "phone" : null
  },
  "orderIdentifications" : [ {
    "orderId" : "SGSM10007",
    "idValue" : "2035556286557",
    "fromDate" : "2020-01-17T12:31:58-08:00",
    "lastUpdatedStamp" : "2020-01-17T12:31:58-08:00",
    "orderIdentificationTypeId" : "SHOPIFY_ORD_ID",
    "thruDate" : null
  }, {
    "orderId" : "SGSM10007",
    "fromDate" : "2020-01-17T12:31:58-08:00",
    "orderIdentificationTypeId" : "SHOPIFY_ORD_NAME",
    "lastUpdatedStamp" : "2020-01-17T12:31:58-08:00",
    "idValue" : "#1068",
    "thruDate" : null
  }, {
    "orderId" : "SGSM10007",
    "fromDate" : "2020-01-17T12:31:58-08:00",
    "idValue" : "68",
    "orderIdentificationTypeId" : "SHOPIFY_ORD_NO",
    "lastUpdatedStamp" : "2020-01-17T12:31:58-08:00",
    "thruDate" : null
  } ],
  "customerPartyIdentifications" : [ ],
  "payments" : [ {
    "orderId" : "SGSM10007",
    "paymentMethodCode" : null,
    "paymentMethodDescription" : "Shopify Payment",
    "createdDate" : "2020-01-17T12:31:57-08:00",
    "statusId" : "PAYMENT_SETTLED",
    "returnId" : null,
    "amount" : 104,
    "paymentMethodTypeId" : "EXT_SHOPIFY"
  } ],
  "orderAdjustments" : [ {
    "customerReferenceId" : null,
    "correspondingProductId" : null,
    "orderItemSeqId" : "_NA_",
    "includeInShipping" : null,
    "description" : null,
    "exemptAmount" : null,
    "productPromoId" : null,
    "orderId" : "SGSM10007",
    "taxAuthPartyId" : null,
    "lastModifiedByUserLogin" : null,
    "amount" : 15,
    "oldPercentage" : null,
    "primaryGeoId" : null,
    "taxAuthGeoId" : null,
    "originalAdjustmentId" : null,
    "secondaryGeoId" : null,
    "createdByUserLogin" : null,
    "orderAdjustmentId" : null,
    "amountAlreadyIncluded" : null,
    "lastUpdatedStamp" : null,
    "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" : "SHIPPING_CHARGES"
  } ],
  "orderAttributes" : [ ],
  "orderItems" : [ {
    "productStoreId" : "SG_STORE",
    "orderId" : "SGSM10007",
    "orderName" : "#1068",
    "orderDate" : "2020-01-15T11:26:03-08:00",
    "orderStatusId" : "ORDER_APPROVED",
    "entryDate" : "2020-01-17T12:31:57-08:00",
    "orderExternalId" : null,
    "currency" : "USD",
    "grandTotal" : 104,
    "orderItemSeqId" : "00001",
    "itemStatusId" : "ITEM_APPROVED",
    "orderItemQuantity" : 1,
    "reservedItemQuantity" : null,
    "reservedDatetime" : null,
    "unitPrice" : 89,
    "orderItemExternalId" : "4458969923677",
    "itemDescription" : "BLACK LEATHER / 37 / 17",
    "requestedDeliveryDate" : null,
    "requestedDeliveryTime" : null,
    "deliveryWindow" : null,
    "shipGroupSeqId" : "00001",
    "shipmentMethodTypeId" : "SECOND_DAY",
    "postalContactMechId" : "10800",
    "telecomContactMechId" : null,
    "orderFacilityId" : null,
    "carrierPartyId" : "_NA_",
    "externalFulfillmentOrderItemId" : null,
    "fulfillmentStatus" : null,
    "customerFirstName" : "Demo",
    "customerLastName" : "User",
    "facilityId" : "1",
    "facilityExternalId" : "1",
    "facilityTypeId" : "RETAIL_STORE",
    "parentFacilityTypeId" : "PHYSICAL_STORE",
    "statusDatetime" : "2020-03-19T11:50:29-07:00",
    "productId" : "10609",
    "productTypeId" : "FINISHED_GOOD",
    "internalName" : "14312158756979",
    "salesChannel" : "WEB_CHANNEL",
    "customerPartyId" : "10004",
    "shipTo" : {
      "countryGeoCode" : "US",
      "stateProvinceGeoCode" : "TN",
      "contactMechId" : "10800",
      "toName" : "demo user",
      "attnName" : null,
      "address1" : "11 U.S. 11",
      "address2" : null,
      "houseNumber" : null,
      "houseNumberExt" : null,
      "directions" : null,
      "city" : "Knoxville",
      "cityGeoId" : null,
      "postalCode" : "37010",
      "postalCodeExt" : null,
      "countryGeoId" : "USA",
      "stateProvinceGeoId" : "TN",
      "countyGeoId" : null,
      "municipalityGeoId" : null,
      "postalCodeGeoId" : null,
      "geoPointId" : null,
      "encodedAddressKey" : null,
      "latitude" : null,
      "longitude" : null,
      "isResidentialAddress" : "Y",
      "phone" : null
    },
    "goodIdentifications" : [ {
      "idValue" : "S00CG30",
      "productId" : "10609",
      "lastUpdatedStamp" : "2022-02-04T07:09:25-08:00",
      "fromDate" : "2020-06-01T12:02:00-07:00",
      "goodIdentificationTypeId" : "SHOPIFY_PROD_SKU",
      "thruDate" : null
    }, {
      "idValue" : "661812039147",
      "fromDate" : "2020-01-17T10:21:16-08:00",
      "goodIdentificationTypeId" : "UPCA",
      "lastUpdatedStamp" : "2022-02-04T07:09:25-08:00",
      "productId" : "10609",
      "thruDate" : null
    } ],
    "orderItemAdjustments" : [ ],
    "orderItemAttributes" : [ ],
    "facilityGroupMembers" : [ {
      "facilityId" : "1",
      "facilityGroupId" : "AUTO_SHIPPING_LABEL",
      "lastUpdatedStamp" : "2021-09-29T01:16:19-07:00",
      "sequenceNum" : 5,
      "fromDate" : "2020-06-25T12:41:21-07:00",
      "thruDate" : null
    }, {
      "facilityId" : "1",
      "facilityGroupId" : "DO_PICKING",
      "lastUpdatedStamp" : "2021-09-29T01:16:19-07:00",
      "fromDate" : "2020-06-25T12:41:21-07:00",
      "sequenceNum" : 5,
      "thruDate" : null
    }, {
      "facilityId" : "1",
      "fromDate" : "2020-06-25T12:41:21-07:00",
      "sequenceNum" : 5,
      "facilityGroupId" : "DO_RATE_SHOP",
      "lastUpdatedStamp" : "2021-09-29T01:16:19-07:00",
      "thruDate" : null
    }, {
      "facilityGroupId" : "OMS_FULFILLMENT",
      "facilityId" : "1",
      "sequenceNum" : 5,
      "fromDate" : "2020-06-25T12:41:21-07:00",
      "thruDate" : null,
      "lastUpdatedStamp" : "2021-09-29T01:16:19-07:00"
    }, {
      "facilityId" : "1",
      "sequenceNum" : null,
      "facilityGroupId" : "SMUS_BROKERING_GROUP",
      "fromDate" : "2023-10-19T08:18:04-07:00",
      "lastUpdatedStamp" : "2023-10-19T08:18:04-07:00",
      "thruDate" : null
    }, {
      "facilityId" : "1",
      "lastUpdatedStamp" : "2023-10-19T08:24:38-07:00",
      "sequenceNum" : null,
      "fromDate" : "2023-10-19T08:24:38-07:00",
      "facilityGroupId" : "SMUS_ST_BRK_GRP",
      "thruDate" : null
    }, {
      "facilityId" : "1",
      "sequenceNum" : null,
      "lastUpdatedStamp" : "2023-11-10T01:18:38-08:00",
      "fromDate" : "2023-11-10T01:18:33-08:00",
      "facilityGroupId" : "SUPERGA_FAC_GRP",
      "thruDate" : null
    }, {
      "facilityGroupId" : "WH_FAC_GROUP",
      "facilityId" : "1",
      "sequenceNum" : null,
      "fromDate" : "2024-01-01T00:00:00-08:00",
      "lastUpdatedStamp" : "2024-01-04T06:50:21-08:00",
      "thruDate" : null
    } ],
    "fromOrderItemAssocs" : [ ],
    "toOrderItemAssocs" : [ ],
    "productFeatures" : [ {
      "amount" : null,
      "productFeatureApplTypeId" : "STANDARD_FEATURE",
      "productFeatureId" : "10015",
      "sequenceNum" : null,
      "recurringAmount" : null,
      "fromDate" : "2020-01-17T10:21:16-08:00",
      "idCode" : null,
      "productFeatureCategoryId" : "10015",
      "contentId" : null,
      "numberSpecified" : null,
      "uomId" : null,
      "thruDate" : null,
      "defaultSequenceNum" : null,
      "description" : "37",
      "defaultAmount" : null,
      "imageUrl" : null,
      "abbrev" : null,
      "productId" : "10609",
      "productFeatureTypeId" : "SIZE"
    }, {
      "amount" : null,
      "productFeatureApplTypeId" : "STANDARD_FEATURE",
      "sequenceNum" : null,
      "recurringAmount" : null,
      "productFeatureId" : "10101",
      "fromDate" : "2020-01-17T10:21:16-08:00",
      "idCode" : null,
      "productFeatureCategoryId" : "10015",
      "contentId" : null,
      "numberSpecified" : null,
      "uomId" : null,
      "description" : "BLACK LEATHER",
      "productFeatureTypeId" : "COLOR",
      "thruDate" : null,
      "defaultSequenceNum" : null,
      "defaultAmount" : null,
      "imageUrl" : null,
      "abbrev" : null,
      "productId" : "10609"
    }, {
      "amount" : null,
      "productFeatureApplTypeId" : "STANDARD_FEATURE",
      "sequenceNum" : null,
      "recurringAmount" : null,
      "productFeatureId" : "10102",
      "fromDate" : "2020-01-17T10:21:16-08:00",
      "idCode" : null,
      "productFeatureCategoryId" : "10015",
      "contentId" : null,
      "numberSpecified" : null,
      "uomId" : null,
      "thruDate" : null,
      "defaultSequenceNum" : null,
      "productFeatureTypeId" : "CODE",
      "defaultAmount" : null,
      "description" : "17",
      "imageUrl" : null,
      "abbrev" : null,
      "productId" : "10609"
    } ]
  } ]
},{
    "productStoreId" : "STORE",
    "orderId" : "KRWE10188",
    "orderName" : "#KREWE37484",
    "orderDate" : "2023-12-07T01:47:49-08:00",
    "orderStatusId" : "ORDER_APPROVED",
    "entryDate" : "2023-12-07T02:09:35-08:00",
    "orderExternalId" : "5499245625544",
    "currency" : "USD",
    "grandTotal" : 390,
    "orderItemSeqId" : null,
    "itemStatusId" : null,
    "orderItemQuantity" : null,
    "reservedItemQuantity" : null,
    "reservedDatetime" : null,
    "unitPrice" : null,
    "orderItemExternalId" : null,
    "itemDescription" : null,
    "requestedDeliveryDate" : null,
    "requestedDeliveryTime" : null,
    "deliveryWindow" : null,
    "shipGroupSeqId" : null,
    "shipmentMethodTypeId" : null,
    "postalContactMechId" : null,
    "telecomContactMechId" : null,
    "orderFacilityId" : null,
    "carrierPartyId" : null,
    "externalFulfillmentOrderItemId" : null,
    "fulfillmentStatus" : null,
    "customerFirstName" : "Dhiraj",
    "customerLastName" : "Nagar",
    "facilityId" : null,
    "facilityExternalId" : null,
    "facilityTypeId" : null,
    "parentFacilityTypeId" : null,
    "statusDatetime" : null,
    "productId" : null,
    "productTypeId" : null,
    "internalName" : null,
    "salesChannel" : "1",
    "customerPartyId" : "10005",
    "isShippingChargesSent" : "N",
    "billTo" : {
      "countryGeoCode" : "US",
      "stateProvinceGeoCode" : "FL",
      "contactMechId" : "10948",
      "toName" : "Dhiraj Nagar",
      "attnName" : null,
      "address1" : "Main St Squre",
      "address2" : "Main St Squre",
      "houseNumber" : null,
      "houseNumberExt" : null,
      "directions" : null,
      "city" : "Miami",
      "cityGeoId" : null,
      "postalCode" : "33172",
      "postalCodeExt" : null,
      "countryGeoId" : "USA",
      "stateProvinceGeoId" : "FL",
      "countyGeoId" : null,
      "municipalityGeoId" : null,
      "postalCodeGeoId" : null,
      "geoPointId" : null,
      "encodedAddressKey" : null,
      "latitude" : null,
      "longitude" : null,
      "isResidentialAddress" : "Y",
      "phone" : {
        "contactMechId" : "10949",
        "countryCode" : null,
        "areaCode" : null,
        "contactNumber" : "08973575538",
        "askForName" : null,
        "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00"
      }
    },
    "orderIdentifications" : [ {
      "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00",
      "fromDate" : "2023-12-07T02:09:35-08:00",
      "orderId" : "KRWE10188",
      "idValue" : "5499245625544",
      "orderIdentificationTypeId" : "SHOPIFY_ORD_ID",
      "thruDate" : null
    }, {
      "fromDate" : "2023-12-07T02:09:35-08:00",
      "orderIdentificationTypeId" : "SHOPIFY_ORD_NAME",
      "orderId" : "KRWE10188",
      "idValue" : "#KREWE37484",
      "thruDate" : null,
      "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00"
    }, {
      "orderIdentificationTypeId" : "SHOPIFY_ORD_NO",
      "fromDate" : "2023-12-07T02:09:35-08:00",
      "idValue" : "36484",
      "orderId" : "KRWE10188",
      "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00",
      "thruDate" : null
    } ],
    "customerPartyIdentifications" : [ {
      "partyId" : "10005",
      "idValue" : "5320857",
      "partyIdentificationTypeId" : "NETSUITE_CUSTOMER_ID",
      "lastUpdatedStamp" : "2023-11-22T10:58:34-08:00"
    }, {
      "partyId" : "10005",
      "lastUpdatedStamp" : "2023-11-22T06:11:12-08:00",
      "partyIdentificationTypeId" : "SHOPIFY_CUST_ID",
      "idValue" : "6838392979656"
    } ],
    "payments" : [ {
      "paymentMethodCode" : null,
      "createdDate" : "2023-12-07T02:09:35-08:00",
      "statusId" : "PAYMENT_SETTLED",
      "paymentMethodTypeId" : "EXT_SHOP_MANUAL",
      "amount" : 390,
      "returnId" : null,
      "orderId" : "KRWE10188",
      "paymentMethodDescription" : "Ext manual"
    } ],
    "orderAdjustments" : [ {
      "customerReferenceId" : null,
      "correspondingProductId" : null,
      "orderItemSeqId" : "_NA_",
      "includeInShipping" : null,
      "description" : null,
      "exemptAmount" : null,
      "productPromoId" : null,
      "taxAuthPartyId" : null,
      "lastModifiedByUserLogin" : null,
      "oldPercentage" : null,
      "primaryGeoId" : null,
      "orderId" : "KRWE10188",
      "taxAuthGeoId" : null,
      "originalAdjustmentId" : null,
      "secondaryGeoId" : null,
      "createdByUserLogin" : null,
      "orderAdjustmentId" : null,
      "amountAlreadyIncluded" : null,
      "lastUpdatedStamp" : null,
      "comments" : null,
      "recurringAmount" : null,
      "lastModifiedDate" : null,
      "sourceReferenceId" : null,
      "productPromoRuleId" : null,
      "isManual" : null,
      "productFeatureId" : null,
      "taxAuthorityRateSeqId" : null,
      "overrideGlAccountId" : null,
      "oldAmountPerQuantity" : null,
      "shipGroupSeqId" : null,
      "amount" : 35,
      "includeInTax" : null,
      "createdDate" : null,
      "productPromoActionSeqId" : null,
      "sourcePercentage" : null,
      "orderAdjustmentTypeId" : "SHIPPING_CHARGES"
    } ],
    "orderAttributes" : [ {
      "attrDescription" : "Shopify User Id",
      "orderId" : "KRWE10188",
      "attrName" : "shopify_user_id",
      "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00",
      "attrValue" : "82607702216"
    } ],
    "orderItems" : [ {
      "productStoreId" : "STORE",
      "orderId" : "KRWE10188",
      "orderName" : "#KREWE37484",
      "orderDate" : "2023-12-07T01:47:49-08:00",
      "orderStatusId" : "ORDER_APPROVED",
      "entryDate" : "2023-12-07T02:09:35-08:00",
      "orderExternalId" : "5499245625544",
      "currency" : "USD",
      "grandTotal" : 390,
      "orderItemSeqId" : "00101",
      "itemStatusId" : "ITEM_APPROVED",
      "orderItemQuantity" : 1,
      "reservedItemQuantity" : null,
      "reservedDatetime" : null,
      "unitPrice" : 355,
      "orderItemExternalId" : "12980256866504",
      "itemDescription" : "COLEMAN | 18K + Matte Indigo Fade + Gravity + Custom Vanity Tint (KIT PRODUCT)",
      "requestedDeliveryDate" : null,
      "requestedDeliveryTime" : null,
      "deliveryWindow" : null,
      "shipGroupSeqId" : "00001",
      "shipmentMethodTypeId" : "OVR_SHP",
      "postalContactMechId" : "10945",
      "telecomContactMechId" : "10946",
      "orderFacilityId" : null,
      "carrierPartyId" : "FEDEX",
      "externalFulfillmentOrderItemId" : "100217",
      "fulfillmentStatus" : "Sent",
      "customerFirstName" : "Dhiraj",
      "customerLastName" : "Nagar",
      "facilityId" : "114",
      "facilityExternalId" : "114",
      "facilityTypeId" : "WAREHOUSE",
      "parentFacilityTypeId" : "DISTRIBUTION_CENTER",
      "statusDatetime" : "2023-12-07T02:09:50-08:00",
      "productId" : "10344",
      "productTypeId" : "MARKETING_PKG_PICK",
      "internalName" : "VANITYKIT-01",
      "salesChannel" : "1",
      "customerPartyId" : "10005",
      "shipTo" : {
        "countryGeoCode" : "US",
        "stateProvinceGeoCode" : "FL",
        "contactMechId" : "10945",
        "toName" : "Dhiraj Nagar",
        "attnName" : null,
        "address1" : "Main St Squre",
        "address2" : "Main St Squre",
        "houseNumber" : null,
        "houseNumberExt" : null,
        "directions" : null,
        "city" : "Miami",
        "cityGeoId" : null,
        "postalCode" : "33172",
        "postalCodeExt" : null,
        "countryGeoId" : "USA",
        "stateProvinceGeoId" : "FL",
        "countyGeoId" : null,
        "municipalityGeoId" : null,
        "postalCodeGeoId" : null,
        "geoPointId" : null,
        "encodedAddressKey" : null,
        "latitude" : null,
        "longitude" : null,
        "isResidentialAddress" : "Y",
        "phone" : {
          "contactMechId" : "10946",
          "countryCode" : null,
          "areaCode" : null,
          "contactNumber" : "08973575538",
          "askForName" : null,
          "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00"
        }
      },
      "goodIdentifications" : [ {
        "idValue" : "40675",
        "fromDate" : "2023-11-22T11:05:40-08:00",
        "goodIdentificationTypeId" : "NETSUITE_PRODUCT_ID",
        "productId" : "10344",
        "lastUpdatedStamp" : "2024-03-27T01:36:21-07:00",
        "thruDate" : null
      }, {
        "idValue" : "42870659088584",
        "lastUpdatedStamp" : "2023-11-22T06:05:00-08:00",
        "goodIdentificationTypeId" : "SHOPIFY_PROD_ID",
        "productId" : "10344",
        "fromDate" : "2023-11-22T06:05:00-08:00",
        "thruDate" : null
      }, {
        "lastUpdatedStamp" : "2023-11-22T06:05:00-08:00",
        "productId" : "10344",
        "idValue" : "VANITYKIT-01",
        "fromDate" : "2023-11-22T06:05:00-08:00",
        "goodIdentificationTypeId" : "SHOPIFY_PROD_SKU",
        "thruDate" : null
      }, {
        "goodIdentificationTypeId" : "SKU",
        "lastUpdatedStamp" : "2023-11-22T06:05:00-08:00",
        "productId" : "10344",
        "idValue" : "VANITYKIT-01",
        "fromDate" : "2023-11-22T06:05:00-08:00",
        "thruDate" : null
      } ],
      "orderItemAdjustments" : [ ],
      "orderItemAttributes" : [ ],
      "facilityGroupMembers" : [ {
        "sequenceNum" : null,
        "lastUpdatedStamp" : "2023-11-23T13:36:59-08:00",
        "fromDate" : "2023-11-23T13:36:55-08:00",
        "facilityGroupId" : "NETSUITE_FULFILLMENT",
        "facilityId" : "114",
        "thruDate" : null
      }, {
        "facilityGroupId" : "OMS_FULFILLMENT",
        "sequenceNum" : null,
        "fromDate" : "2023-12-07T01:58:42-08:00",
        "lastUpdatedStamp" : "2023-12-07T01:58:42-08:00",
        "facilityId" : "114",
        "thruDate" : null
      } ],
      "fromOrderItemAssocs" : [ ],
      "toOrderItemAssocs" : [ {
        "toOrderItemSeqId" : "00102",
        "quantity" : null,
        "toShipGroupSeqId" : "00001",
        "toOrderId" : "KRWE10188",
        "orderId" : "KRWE10188",
        "orderItemAssocTypeId" : "KIT_COMPONENT",
        "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00",
        "shipGroupSeqId" : "00001",
        "orderItemSeqId" : "00101"
      }, {
        "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00",
        "quantity" : null,
        "toShipGroupSeqId" : "00001",
        "toOrderId" : "KRWE10188",
        "orderId" : "KRWE10188",
        "orderItemAssocTypeId" : "KIT_COMPONENT",
        "shipGroupSeqId" : "00001",
        "orderItemSeqId" : "00101",
        "toOrderItemSeqId" : "00103"
      } ],
      "productFeatures" : [ {
        "productFeatureId" : "10000",
        "amount" : null,
        "productFeatureApplTypeId" : "STANDARD_FEATURE",
        "recurringAmount" : null,
        "description" : "Default Title",
        "idCode" : null,
        "sequenceNum" : 1,
        "contentId" : null,
        "productFeatureTypeId" : "10000",
        "numberSpecified" : null,
        "productId" : "10344",
        "productFeatureCategoryId" : null,
        "uomId" : null,
        "thruDate" : null,
        "defaultSequenceNum" : null,
        "defaultAmount" : null,
        "imageUrl" : null,
        "abbrev" : null,
        "fromDate" : "2023-11-22T06:05:00-08:00"
      } ]
    }, {
      "productStoreId" : "STORE",
      "orderId" : "KRWE10188",
      "orderName" : "#KREWE37484",
      "orderDate" : "2023-12-07T01:47:49-08:00",
      "orderStatusId" : "ORDER_APPROVED",
      "entryDate" : "2023-12-07T02:09:35-08:00",
      "orderExternalId" : "5499245625544",
      "currency" : "USD",
      "grandTotal" : 390,
      "orderItemSeqId" : "00102",
      "itemStatusId" : "ITEM_APPROVED",
      "orderItemQuantity" : 1,
      "reservedItemQuantity" : 1,
      "reservedDatetime" : "2023-12-14T00:15:52-08:00",
      "unitPrice" : 0,
      "orderItemExternalId" : null,
      "itemDescription" : "Default Title (COMPONENT PRODUCT)",
      "requestedDeliveryDate" : null,
      "requestedDeliveryTime" : null,
      "deliveryWindow" : null,
      "shipGroupSeqId" : "00001",
      "shipmentMethodTypeId" : "OVR_SHP",
      "postalContactMechId" : "10945",
      "telecomContactMechId" : "10946",
      "orderFacilityId" : null,
      "carrierPartyId" : "FEDEX",
      "externalFulfillmentOrderItemId" : "100218",
      "fulfillmentStatus" : "Sent",
      "customerFirstName" : "Dhiraj",
      "customerLastName" : "Nagar",
      "facilityId" : "114",
      "facilityExternalId" : "114",
      "facilityTypeId" : "WAREHOUSE",
      "parentFacilityTypeId" : "DISTRIBUTION_CENTER",
      "statusDatetime" : "2023-12-07T02:09:50-08:00",
      "productId" : "10342",
      "productTypeId" : "FINISHED_GOOD",
      "internalName" : "SCJ1-228G-21CS-222",
      "salesChannel" : "1",
      "customerPartyId" : "10005",
      "shipTo" : {
        "countryGeoCode" : "US",
        "stateProvinceGeoCode" : "FL",
        "contactMechId" : "10945",
        "toName" : "Dhiraj Nagar",
        "attnName" : null,
        "address1" : "Main St Squre",
        "address2" : "Main St Squre",
        "houseNumber" : null,
        "houseNumberExt" : null,
        "directions" : null,
        "city" : "Miami",
        "cityGeoId" : null,
        "postalCode" : "33172",
        "postalCodeExt" : null,
        "countryGeoId" : "USA",
        "stateProvinceGeoId" : "FL",
        "countyGeoId" : null,
        "municipalityGeoId" : null,
        "postalCodeGeoId" : null,
        "geoPointId" : null,
        "encodedAddressKey" : null,
        "latitude" : null,
        "longitude" : null,
        "isResidentialAddress" : "Y",
        "phone" : {
          "contactMechId" : "10946",
          "countryCode" : null,
          "areaCode" : null,
          "contactNumber" : "08973575538",
          "askForName" : null,
          "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00"
        }
      },
      "goodIdentifications" : [ {
        "idValue" : "31083",
        "fromDate" : "2023-11-22T11:05:38-08:00",
        "lastUpdatedStamp" : "2024-03-27T01:36:20-07:00",
        "goodIdentificationTypeId" : "NETSUITE_PRODUCT_ID",
        "productId" : "10342",
        "thruDate" : null
      }, {
        "fromDate" : "2023-11-22T06:04:59-08:00",
        "goodIdentificationTypeId" : "SHOPIFY_PROD_ID",
        "idValue" : "42389625733320",
        "productId" : "10342",
        "thruDate" : null,
        "lastUpdatedStamp" : "2023-11-22T06:04:59-08:00"
      }, {
        "idValue" : "SCJ1-228G-21CS-222",
        "fromDate" : "2023-11-22T06:04:59-08:00",
        "productId" : "10342",
        "lastUpdatedStamp" : "2023-11-22T06:04:59-08:00",
        "goodIdentificationTypeId" : "SHOPIFY_PROD_SKU",
        "thruDate" : null
      }, {
        "idValue" : "SCJ1-228G-21CS-222",
        "fromDate" : "2023-11-22T06:04:59-08:00",
        "goodIdentificationTypeId" : "SKU",
        "lastUpdatedStamp" : "2023-11-22T06:04:59-08:00",
        "productId" : "10342",
        "thruDate" : null
      }, {
        "fromDate" : "2023-11-22T06:04:59-08:00",
        "idValue" : "810062125869",
        "goodIdentificationTypeId" : "UPCA",
        "productId" : "10342",
        "lastUpdatedStamp" : "2023-11-22T06:04:59-08:00",
        "thruDate" : null
      } ],
      "orderItemAdjustments" : [ ],
      "orderItemAttributes" : [ ],
      "facilityGroupMembers" : [ {
        "sequenceNum" : null,
        "lastUpdatedStamp" : "2023-11-23T13:36:59-08:00",
        "fromDate" : "2023-11-23T13:36:55-08:00",
        "facilityGroupId" : "NETSUITE_FULFILLMENT",
        "facilityId" : "114",
        "thruDate" : null
      }, {
        "facilityGroupId" : "OMS_FULFILLMENT",
        "sequenceNum" : null,
        "fromDate" : "2023-12-07T01:58:42-08:00",
        "lastUpdatedStamp" : "2023-12-07T01:58:42-08:00",
        "facilityId" : "114",
        "thruDate" : null
      } ],
      "fromOrderItemAssocs" : [ {
        "toOrderItemSeqId" : "00102",
        "quantity" : null,
        "toShipGroupSeqId" : "00001",
        "toOrderId" : "KRWE10188",
        "orderId" : "KRWE10188",
        "orderItemAssocTypeId" : "KIT_COMPONENT",
        "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00",
        "shipGroupSeqId" : "00001",
        "orderItemSeqId" : "00101"
      } ],
      "toOrderItemAssocs" : [ ],
      "productFeatures" : [ {
        "productFeatureId" : "10000",
        "amount" : null,
        "productFeatureApplTypeId" : "STANDARD_FEATURE",
        "recurringAmount" : null,
        "description" : "Default Title",
        "idCode" : null,
        "sequenceNum" : 1,
        "contentId" : null,
        "productFeatureTypeId" : "10000",
        "numberSpecified" : null,
        "productFeatureCategoryId" : null,
        "uomId" : null,
        "productId" : "10342",
        "thruDate" : null,
        "fromDate" : "2023-11-22T06:04:59-08:00",
        "defaultSequenceNum" : null,
        "defaultAmount" : null,
        "imageUrl" : null,
        "abbrev" : null
      } ]
    }, {
      "productStoreId" : "STORE",
      "orderId" : "KRWE10188",
      "orderName" : "#KREWE37484",
      "orderDate" : "2023-12-07T01:47:49-08:00",
      "orderStatusId" : "ORDER_APPROVED",
      "entryDate" : "2023-12-07T02:09:35-08:00",
      "orderExternalId" : "5499245625544",
      "currency" : "USD",
      "grandTotal" : 390,
      "orderItemSeqId" : "00103",
      "itemStatusId" : "ITEM_APPROVED",
      "orderItemQuantity" : 1,
      "reservedItemQuantity" : 1,
      "reservedDatetime" : "2023-12-14T00:15:53-08:00",
      "unitPrice" : 0,
      "orderItemExternalId" : null,
      "itemDescription" : "Dark Blue Gradient / 4B (COMPONENT PRODUCT)",
      "requestedDeliveryDate" : null,
      "requestedDeliveryTime" : null,
      "deliveryWindow" : null,
      "shipGroupSeqId" : "00001",
      "shipmentMethodTypeId" : "OVR_SHP",
      "postalContactMechId" : "10945",
      "telecomContactMechId" : "10946",
      "orderFacilityId" : null,
      "carrierPartyId" : "FEDEX",
      "externalFulfillmentOrderItemId" : "100219",
      "fulfillmentStatus" : "Sent",
      "customerFirstName" : "Dhiraj",
      "customerLastName" : "Nagar",
      "facilityId" : "114",
      "facilityExternalId" : "114",
      "facilityTypeId" : "WAREHOUSE",
      "parentFacilityTypeId" : "DISTRIBUTION_CENTER",
      "statusDatetime" : "2023-12-07T02:09:50-08:00",
      "productId" : "11741",
      "productTypeId" : "FINISHED_GOOD",
      "internalName" : "VANITYLENS-06",
      "salesChannel" : "1",
      "customerPartyId" : "10005",
      "shipTo" : {
        "countryGeoCode" : "US",
        "stateProvinceGeoCode" : "FL",
        "contactMechId" : "10945",
        "toName" : "Dhiraj Nagar",
        "attnName" : null,
        "address1" : "Main St Squre",
        "address2" : "Main St Squre",
        "houseNumber" : null,
        "houseNumberExt" : null,
        "directions" : null,
        "city" : "Miami",
        "cityGeoId" : null,
        "postalCode" : "33172",
        "postalCodeExt" : null,
        "countryGeoId" : "USA",
        "stateProvinceGeoId" : "FL",
        "countyGeoId" : null,
        "municipalityGeoId" : null,
        "postalCodeGeoId" : null,
        "geoPointId" : null,
        "encodedAddressKey" : null,
        "latitude" : null,
        "longitude" : null,
        "isResidentialAddress" : "Y",
        "phone" : {
          "contactMechId" : "10946",
          "countryCode" : null,
          "areaCode" : null,
          "contactNumber" : "08973575538",
          "askForName" : null,
          "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00"
        }
      },
      "goodIdentifications" : [ {
        "fromDate" : "2023-11-22T11:05:40-08:00",
        "goodIdentificationTypeId" : "NETSUITE_PRODUCT_ID",
        "idValue" : "38040",
        "productId" : "11741",
        "lastUpdatedStamp" : "2024-03-27T01:36:21-07:00",
        "thruDate" : null
      }, {
        "goodIdentificationTypeId" : "SHOPIFY_PROD_ID",
        "productId" : "11741",
        "lastUpdatedStamp" : "2023-11-22T06:07:31-08:00",
        "fromDate" : "2023-11-22T06:07:30-08:00",
        "idValue" : "42870661480648",
        "thruDate" : null
      }, {
        "lastUpdatedStamp" : "2023-11-22T06:07:30-08:00",
        "idValue" : "VANITYLENS-06",
        "productId" : "11741",
        "fromDate" : "2023-11-22T06:07:30-08:00",
        "goodIdentificationTypeId" : "SHOPIFY_PROD_SKU",
        "thruDate" : null
      }, {
        "idValue" : "VANITYLENS-06",
        "lastUpdatedStamp" : "2023-11-22T06:07:31-08:00",
        "goodIdentificationTypeId" : "SKU",
        "productId" : "11741",
        "fromDate" : "2023-11-22T06:07:30-08:00",
        "thruDate" : null
      } ],
      "orderItemAdjustments" : [ ],
      "orderItemAttributes" : [ ],
      "facilityGroupMembers" : [ {
        "sequenceNum" : null,
        "lastUpdatedStamp" : "2023-11-23T13:36:59-08:00",
        "fromDate" : "2023-11-23T13:36:55-08:00",
        "facilityGroupId" : "NETSUITE_FULFILLMENT",
        "facilityId" : "114",
        "thruDate" : null
      }, {
        "facilityGroupId" : "OMS_FULFILLMENT",
        "sequenceNum" : null,
        "fromDate" : "2023-12-07T01:58:42-08:00",
        "lastUpdatedStamp" : "2023-12-07T01:58:42-08:00",
        "facilityId" : "114",
        "thruDate" : null
      } ],
      "fromOrderItemAssocs" : [ {
        "lastUpdatedStamp" : "2023-12-07T02:09:35-08:00",
        "quantity" : null,
        "toShipGroupSeqId" : "00001",
        "toOrderId" : "KRWE10188",
        "orderId" : "KRWE10188",
        "orderItemAssocTypeId" : "KIT_COMPONENT",
        "shipGroupSeqId" : "00001",
        "orderItemSeqId" : "00101",
        "toOrderItemSeqId" : "00103"
      } ],
      "toOrderItemAssocs" : [ ],
      "productFeatures" : [ {
        "amount" : null,
        "productFeatureApplTypeId" : "STANDARD_FEATURE",
        "productFeatureId" : "10169",
        "recurringAmount" : null,
        "sequenceNum" : 2,
        "idCode" : null,
        "contentId" : null,
        "numberSpecified" : null,
        "productId" : "11741",
        "productFeatureTypeId" : "10010",
        "productFeatureCategoryId" : null,
        "uomId" : null,
        "fromDate" : "2023-11-22T06:07:30-08:00",
        "thruDate" : null,
        "defaultSequenceNum" : null,
        "defaultAmount" : null,
        "imageUrl" : null,
        "abbrev" : null,
        "description" : "4B"
      }, {
        "amount" : null,
        "productFeatureId" : "10173",
        "productFeatureApplTypeId" : "STANDARD_FEATURE",
        "recurringAmount" : null,
        "idCode" : null,
        "sequenceNum" : 1,
        "description" : "Dark Blue Gradient",
        "contentId" : null,
        "numberSpecified" : null,
        "productId" : "11741",
        "productFeatureCategoryId" : null,
        "uomId" : null,
        "fromDate" : "2023-11-22T06:07:30-08:00",
        "productFeatureTypeId" : "COLOR",
        "thruDate" : null,
        "defaultSequenceNum" : null,
        "defaultAmount" : null,
        "imageUrl" : null,
        "abbrev" : null
      } ]
    } ]
  }
]

Attributes

The following attributes have been prepared in the feed:

Field Name

Description

Sample value

productStoreId

The ID of the product store

STORE

orderId

The HotWax Commerce unique identifier for the order

12082

orderName

The eCommerce order identifier

9000004032

orderDate

The date and time the order was placed on eCommerce

2024-02-23T03:43:23+09:00

orderStatusId

Order status

ORDER_APPROVED

entryDate

The date and time the order was imported in HotWax Commerce OMS

2024-02-23T03:50:12+09:00

orderExternalId

The external ID of the order

5384320450749

currency

The payment currency used for the order

JPY

grandTotal

The total sum of all costs associated with an order

1870

customerFirstName

The first name of the customer

jhon

customerLastName

The last name of the customer

deo

salesChannel

The sales channel

WEB_CHANNEL

customerPartyId

The customer party ID

10290

isShippingChargesSent

Indicates if shipping charges are sent

billTo

The billing information

See below

orderIdentifications

The order identifications

See below

customerPartyIdentifications

The customer party identifications

See below

payments

The payments

See below

orderAdjustments

The order adjustments

See below

orderAttributes

The order attributes

See below

orderItems

The order items

See below

This object contains the following attributes, each of which has internal nesting:

Field Name

Description

Sample value

billTo

The billing information

See below

orderIdentifications

The order identifications

See below

customerPartyIdentifications

The customer party identifications

See below

payments

The payments

See below

orderAdjustments

The order adjustments

See below

orderAttributes

The order attributes

See below

orderItems

The order items

See below

billTo

Field Name

Description

Sample value

countryGeoCode

The country geo code

stateProvinceGeoCode

The state province geo code

null

contactMechId

The contact mechanism ID

18227

toName

The name of the recipient

jhon deo

address1

The first line of the address

足立

address2

The second line of the address

null

city

The city

足立区

postalCode

The postal code

120-0015

countryGeoId

The country geo ID

JPN

stateProvinceGeoId

The state province geo ID

null

isResidentialAddress

Indicates if the address is residential

phone

The phone information

See below

billTo.phone

Field Name

Description

Sample value

contactMechId

The contact mechanism ID

18228

countryCode

The country code

areaCode

The area code

null

contactNumber

The contact number

0593785656

orderIdentifications

Field Name

Description

Sample value

idValue

The ID value

5384320450749

orderId

The order ID

12082

fromDate

The from date

2024-02-23T03:50:12+09:00

thruDate

The thru date

null

customerPartyIdentifications

Field Name

Description

Sample value

partyIdentificationTypeId

The party identification type ID

SHOPIFY_CUST_ID

idValue

The ID value

7053008306365

partyId

The party ID

10290

payments

Field Name

Description

Sample value

paymentMethodCode

The payment method code

null

amount

The amount

1870

paymentMethodTypeId

The payment method type ID

EXT_SHOP_OTHR_GTWAY

paymentMethodDescription

The payment method description

Ext Other Gateways

orderId

The order ID

12082

statusId

The status ID

PAYMENT_AUTHORIZED

returnId

The return ID

null

createdDate

The date and time of creation

2024-02-23T03:50:12+09:00

orderAdjustments

Field Name

Description

Sample value

orderAdjustmentTypeId

The order adjustment type ID

SHIPPING_SALES_TAX

amount

The amount

orderAdjustmentId

The order adjustment ID

null

orderId

The order ID

12082

orderAttributes

Field Name

Description

Sample value

orderId

The order ID

12082

attrDescription

The attribute description

null

attrName

The attribute name

COD_FEE_ADJ_CREATED

attrValue

The attribute value

true

orderItems

Field Name

Description

Sample value

productStoreId

The ID of the product store

STORE

orderId

The unique identifier for the order

12082

orderName

The name of the order

9000004032

orderDate

The date and time the order was placed

2024-02-23T03:43:23+09:00

orderStatusId

The status of the order

ORDER_APPROVED

entryDate

The date and time the order was entered

2024-02-23T03:50:12+09:00

orderExternalId

The external ID of the order

5384320450749

currency

The currency used for the order

JPY

grandTotal

The total amount of the order

1870

orderItemSeqId

The sequence ID of the order item

00101

itemStatusId

The status of the item

ITEM_APPROVED

orderItemQuantity

The quantity of the order item

reservedItemQuantity

The quantity of reserved items

unitPrice

The unit price of the item

1200

orderItemExternalId

The external ID of the order item

12915436126397

itemDescription

The description of the item

ソックスクルー 3ペアホワイト

shipGroupSeqId

The sequence ID of the ship group

00001

shipmentMethodTypeId

The shipment method type ID

STANDARD

postalContactMechId

The postal contact mechanism ID

18224

telecomContactMechId

The telecom contact mechanism ID

18225

carrierPartyId

The carrier party ID

externalFulfillmentOrderItemId

The external fulfillment order item ID

null

fulfillmentStatus

The fulfillment status

null

customerFirstName

The first name of the customer

jhon

customerLastName

The last name of the customer

deo

facilityId

The facility ID

WH0615

facilityExternalId

The external ID of the facility

facilityTypeId

This attribute contains the facility Type Id.

WAREHOUSE

parentFacilityTypeId

This attribute contains ID of the parent facility for facilityId.

DISTRIBUTION_CENTER

statusDatetime

The date and time of the status

2024-02-23T04:05:15+09:00

productId

The product's unique identifier in HotWax Commerce

60757

productTypeId

The type of product identification

FINISHED_GOOD

internalName

String

salesChannel

The sales channel

WEB_CHANNEL

customerPartyId

The customer's unique identification in HotWax Commerce

10290

shipTo

The shipping information

See below

goodIdentifications

The product/good identifications

See below

orderItemAdjustments

The order item adjustments

See below

orderItemAttributes

The order item attributes

See below

facilityGroupMembers

The facility group members

See below

fromOrderItemAssocs

The from order item associations

See below

toOrderItemAssocs

The to order item associations

See below

productFeatures

The product features

See below

orderItems.shipTo

Field Name

Description

Sample value

countryGeoCode

The country geo code

stateProvinceGeoCode

The state province geo code

null

contactMechId

The contact mechanism ID

18224

toName

The name of the recipient

jhon deo

address1

The first line of the address

足立

address2

The second line of the address

null

city

The city

足立区

postalCode

The postal code

120-0015

countryGeoId

The country geo ID

JPN

stateProvinceGeoId

The state province geo ID

null

countyGeoId

The county geo ID

null

isResidentialAddress

Indicates if the address is residential

phone

The phone information

See below

orderItems.phone.shipTo

Field Name

Description

Sample value

contactMechId

The contact mechanism ID

18228

countryCode

The country code

areaCode

The area code

null

contactNumber

The contact number

0593785656

orderItem.goodIdentification

Field Name

Description

Sample value

idValue

The good identifications ID value

37639003275453

fromDate

The identification creation date

2023-12-25T03:48:21+09:00

productId

The HotWax Commerce's product ID

60757

goodIdentificationTypeId

The type of good identification

SHOPIFY_PROD_ID

thruDate

The identification expiration date

null

orderItems.orderItemAdjustments:

Field Name

Description

Sample value

amount

The amount of order adjustment

120

orderAdjustmentTypeId

The order adjustment type ID

SALES_TAX

orderId

The order ID

12082

orderItemSeqId

The Order Item Seq ID.

0001

orderItemAttributes

Field Name

Description

Sample value

orderId

The order ID

12082

attrDescription

The attribute description

null

attrName

The attribute name

COD_FEE_ADJ_CREATED

attrValue

The attribute value

true

orderItemSeqId

the Order item sequence id.

00001

facilityGroupMembers

Field Name

Description

Sample value

facilityId

The facility ID

WH0615

facilityGroupId

The facility group ID

thruDate

The thru date

null

fromDate

The from date

2024-02-23T03:50:12+09:00

sequenceNum

The sequence number for the member.

fromOrderItemAssocs:

Field Name

Description

Sample value

orderId

The order ID of kit product

12082

orderItemSeqId

The order items seq ID of the kit product.

00101

toOrderId

The order ID of the component product.

null

toOrderItemSeqId

The order items seq ID of the component product.

00001

shipGroupSeqId

The ship group seq ID of the kit product.

00002

toShipGroupSeqId

The ship group seq ID of the component product.

00003

orderItemAssocTypeId

The order item assoc type ID.

KIT_COMPONENT

toOrderItemAssocs:

Field Name

Description

Sample value

orderId

The order ID of kit product

12082

orderItemSeqId

The order items seq ID of the kit product.

00101

toOrderId

The order ID of the component product.

null

toOrderItemSeqId

The order items seq ID of the component product.

00001

shipGroupSeqId

The ship group seq ID of the kit product.

00002

toShipGroupSeqId

The ship group seq ID of the component product.

00003

orderItemAssocTypeId

The order item assoc type ID like.

KIT_COMPONENT

productFeatures:

Field Name

Description

Sample value

productFeatureApplTypeId

the feature Appl type like

STANDARD_FEATURE

productFeatureId

the unique feature ID.

10000

productFeatureCategoryId

the product feature category ID.

10015

description

the description of the feature.

Red, L

productId

the Product ID.

10000

productFeaturTypeId

the feature type like

COLOR