SKU Data Get

GET{{api_url}}/shop/products/sku_data/{{sku}}

Returns every SKU Data entry stored on one SKU, one row per data name. SKU Data is the per-SKU key/value store behind the SKU Data tool in the OMS: a generic bucket where any name can be stored, plus reserved names that InfiPlex connections read when they interact with that SKU. thehomedepot_sku is the value sent to Home Depot for the SKU, costco_sku the value sent to Costco, autozone_item_num the AutoZone item number, and so on. In the OMS the reserved names appear under their connection's tab and everything else under the Sku Data tab; this endpoint returns both together as a flat list.

Reserved names fall into a few groups:

Connection identifiers and listing data: thehomedepot_sku, costco_sku, autozone_item_num, buildcom_item_num, channel_gate_sku, channel_gate_upc, channel_gate_product_name, hd_supply_merchant_sku, hd_supply_unit_cost, hd_supply_merchant_sku_description, bluestem_merchant_sku, bluestem_description, ruelala_merchant_sku, rtg_sku, rtg_upc, rtg_product_name, sams_club_item_id, sams_club_upc, zoro_tools_upc, zoro_tools_buyers_part_number, method_qb_item_name, phonehousespain_ean, blue_yonder_price, blue_yonder_product_name, walmart_wholesale_price, walmart_dsv_wholesale_price, bmb_bmid, bmb_title, bmb_brand, bmb_color, bmb_capacity, bmb_grade, bmb_price, bmb_country.
Connection state flags: best_buy_product_state, darty_state, ruedu_state, phonehousespain_state, tire_shop_order_push_enabled, wayfair_itemNextAvailabilityDate, wayfair_quantityOnOrder.
Amazon Business pricing: amazon_business_pricing_enabled, amazon_business_pricing_base_price, amazon_business_pricing_qty_discount_enabled, amazon_business_pricing_qty_discount_remove, amazon_business_pricing_qty_discount_type, amazon_business_pricing_qty_discount_1_min_qty through _5_min_qty, the matching _value_off and _percent_off names, and amazon_business_pricing_last_sync_time, which InfiPlex writes after each sync.
Amazon Vendor Central Retail auto confirm: avcr_auto_confirm_enabled, avcr_auto_confirm_rule_price, avcr_auto_confirm_rule_inventory. The two rule values hold a JSON object as a string.
InfiPlex predefined fields with a dynamic suffix, prefixed ipx_skd_: ipx_skd_amazon_lead_time_{warehouse_id} is the Amazon lead time for that warehouse, one entry per warehouse.

Any other name is one the account created in the generic bucket.

Values come back exactly as stored, always as strings. A value that holds JSON is returned as that JSON string, not decoded.

Path variables

Variable	Type	Description
`sku`	string	The SKU to read.

Example

{{api_url}}/shop/products/sku_data/abc

Response

A JSON array, one object per stored data name:

[
    {
        "shop_product_sku_custom_data_id": "4359",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_base_price",
        "data_value": "100",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4421",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "thehomedepot_sku",
        "data_value": "1004567890",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4440",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "ipx_skd_amazon_lead_time_3",
        "data_value": "2",
        "date_modified": "2025-10-23 09:47:27"
    }
]

Field	Type	Description
`shop_product_sku_custom_data_id`	string	The row id.
`shop_product_sku_custom_data_siteareaid`	string	The InfiPlex site area the row belongs to.
`sku`	string	The SKU.
`data_name`	string	The data name, reserved or custom.
`data_value`	string	The stored value. Empty string when the name exists on the SKU with no value.
`date_modified`	string	When this entry was last saved, in the account time zone.

An empty array means the SKU has no SKU Data entries. To read one name across many SKUs, or to find which SKU carries a given value, use SKU Data Search.

Authorization

Bearer token, sent in the Authorization header. Inherited from the collection.

Example Request

curl --location --request GET '{{api_url}}/shop/products/sku_data/{{sku}}' \
--header 'Authorization: Bearer {{auth_token}}'

Example Responses

SKU Data Get

Request

curl --location --request GET '{{api_url}}/shop/products/sku_data/abc' \
--header 'Authorization: Bearer YOUR_API_KEY'

Response 200 OK

[
    {
        "shop_product_sku_custom_data_id": "4359",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_base_price",
        "data_value": "100",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4360",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_enabled",
        "data_value": "yes",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4425",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_last_sync_time",
        "data_value": "2025-10-23T09:47:30-05:00",
        "date_modified": "2025-10-23 09:47:30"
    },
    {
        "shop_product_sku_custom_data_id": "4362",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_1_min_qty",
        "data_value": "2",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4363",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_1_percent_off",
        "data_value": "10",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4364",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_1_value_off",
        "data_value": "90",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4365",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_2_min_qty",
        "data_value": "4",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4366",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_2_percent_off",
        "data_value": "12",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4367",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_2_value_off",
        "data_value": "61",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4368",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_3_min_qty",
        "data_value": "6",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4369",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_3_percent_off",
        "data_value": "15",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4370",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_3_value_off",
        "data_value": "60",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4371",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_4_min_qty",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4372",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_4_value_off",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4373",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_5_min_qty",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4374",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_5_value_off",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4375",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_enabled",
        "data_value": "yes",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4376",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_remove",
        "data_value": "no",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4377",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_qty_discount_type",
        "data_value": "fixed",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4378",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "amazon_business_pricing_remove_pricing",
        "data_value": "no",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4379",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "autozone_item_num",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4380",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "avcr_auto_confirm_enabled",
        "data_value": "yes",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4381",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "avcr_auto_confirm_rule_inventory",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4382",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "avcr_auto_confirm_rule_price",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4383",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "blue_yonder_price",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4384",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "blue_yonder_product_name",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4385",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "bluestem_description",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4386",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "bluestem_merchant_sku",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4387",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "bmb_bmid",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4388",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "bmb_brand",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4389",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "bmb_capacity",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4390",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "bmb_color",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4391",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "bmb_country",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4392",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "bmb_grade",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4393",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "bmb_price",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4394",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "bmb_title",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4395",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "buildcom_item_num",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4396",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "channel_gate_product_name",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4397",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "channel_gate_sku",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4398",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "channel_gate_upc",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4399",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "costco_sku",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4400",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "darty_state",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4401",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "hd_supply_merchant_sku",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4402",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "hd_supply_merchant_sku_description",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4403",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "hd_supply_unit_cost",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4404",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "ipx_skd_amazon_lead_time_3",
        "data_value": "n2",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4405",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "ipx_skd_amazon_lead_time_4",
        "data_value": "v3",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4406",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "ipx_skd_amazon_lead_time_7",
        "data_value": "c1",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4407",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "ipx_skd_amazon_lead_time_8",
        "data_value": "w4",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4408",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "method_qb_item_name",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4409",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "phonehousespain_ean",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4410",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "phonehousespain_state",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4411",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "rtg_product_name",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4412",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "rtg_sku",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4413",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "rtg_upc",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4414",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "ruedu_state",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4415",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "ruelala_merchant_sku",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4416",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "sams_club_item_id",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4417",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "sams_club_upc",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4418",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "thehomedepot_sku",
        "data_value": "hhhooome depot 2",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4419",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "tire_shop_order_push_enabled",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4420",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "walmart_dsv_wholesale_price",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4421",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "walmart_wholesale_price",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4422",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "zoro_tools_buyers_part_number",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4423",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "zoro_tools_upc",
        "data_value": "",
        "date_modified": "2025-10-23 09:47:27"
    },
    {
        "shop_product_sku_custom_data_id": "4424",
        "shop_product_sku_custom_data_siteareaid": "16",
        "sku": "abc",
        "data_name": "zzz",
        "data_value": "zzzup",
        "date_modified": "2025-10-23 09:47:27"
    }
]

SKU Data Get

Authorization

Example Request

Example Responses

SKU Data Get

Request

Response 200 OK

Latest Posts

Useful Links

Contact Us