COMMERCE QUERY

Query API 3.0

SupplierProductSku

Query (v1)

Download OpenAPI description

openapi.json

openapi.yaml

Servers

https://norcecommerce.api-se.norce.tech/commerce/query/3.0/

Schemas

SupplierProductSkuOnHand

partNostring or null[ 0 .. 50 ] characters

The supplier part number.

supplierIdinteger(int32)

The supplier identifier.

warehouseIdinteger(int32)

The supplier warehouse identifier.

locationIdinteger(int32)

The supplier location identifier.

onHandValuenumber(decimal)

The on hand value.

onHandLastCheckedstring or null(date-time)

The on hand last checked.

onHandLastUpdatedstring or null(date-time)

The on hand last updated.

onHandLastUpdatedByinteger or null(int32)

The on hand last updated by.

incomingValuenumber or null(decimal)

The incoming value. Optional field that can be used together with next delivery date to give a more complete picture of the stock situation.

incomingLastCheckedstring or null(date-time)

The incoming last checked.

incomingLastUpdatedstring or null(date-time)

The incoming last updated.

incomingLastUpdatedByinteger or null(int32)

The incoming last updated by.

nextDeliveryDatestring or null(date-time)

The next delivery date. Optional field that can be used together with incoming value to give a more complete picture of the stock situation.

nextDeliveryLastCheckedstring or null(date-time)

The next delivery last checked.

nextDeliveryLastUpdatedstring or null(date-time)

The next delivery last updated.

nextDeliveryLastUpdatedByinteger or null(int32)

The next delivery last updated by.

isReturnableboolean or null

Indicates whether the supplier product sku on hand is returnable. Not commonly used.

leadTimeDayCountinteger or null(int32)

The lead time day count. Indicates the number of days it takes for the end-customer to get goods delivered from this supplier.

isActiveboolean

Indicates whether the supplier product sku on hand is active.

stoppedDatestring or null(date-time)

The stopped date. Not commonly used.

createdstring(date-time)

The date and time the record was created.

createdByinteger(int32)

The identifier of the user who created the record.

updatedstring or null(date-time)

The date and time the record was last updated.

updatedByinteger or null(int32)

The identifier of the user who last updated the record.

externalStockValuenumber or null(decimal)

The external stock value. Not commonly used.

packageValuenumber(decimal)

The package value. Not commonly used.

minimumOrderValuenumber(decimal)

The minimum order value. Not commonly used.

clientIdinteger or null(int32)

The client identifier.

locations(WarehouseLocation (object or null))

One of:

supplierProductSku(SupplierProductSku (object or null))

One of:

warehouse(Warehouse (object or null))

One of:

{
  "partNo": "string",
  "supplierId": 0,
  "warehouseId": 0,
  "locationId": 0,
  "onHandValue": 0,
  "onHandLastChecked": "2019-08-24T14:15:22Z",
  "onHandLastUpdated": "2019-08-24T14:15:22Z",
  "onHandLastUpdatedBy": 0,
  "incomingValue": 0,
  "incomingLastChecked": "2019-08-24T14:15:22Z",
  "incomingLastUpdated": "2019-08-24T14:15:22Z",
  "incomingLastUpdatedBy": 0,
  "nextDeliveryDate": "2019-08-24T14:15:22Z",
  "nextDeliveryLastChecked": "2019-08-24T14:15:22Z",
  "nextDeliveryLastUpdated": "2019-08-24T14:15:22Z",
  "nextDeliveryLastUpdatedBy": 0,
  "isReturnable": true,
  "leadTimeDayCount": 0,
  "isActive": true,
  "stoppedDate": "2019-08-24T14:15:22Z",
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "externalStockValue": 0,
  "packageValue": 0,
  "minimumOrderValue": 0,
  "clientId": 0,
  "locations": {
    "id": 0,
    "defaultName": "string",
    "isActive": true,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "clientWarehouseLocation": [ … ],
    "supplierProductSkuOnHand": [ … ]
  },
  "supplierProductSku": {
    "partNo": "string",
    "supplierId": 0,
    "name": "string",
    "manufacturerId": 0,
    "manufacturerCode": "string",
    "manufacturerPartNo": "string",
    "categoryId": 0,
    "categoryCode": "string",
    "commodityCode": "string",
    "eanCode": "string",
    "grossWeight": 0,
    "netWeight": 0,
    "vatCodeId": 0,
    "unitOfMeasurementId": 0,
    "unitOfMeasurementCount": 0,
    "url": "string",
    "imagePath": "string",
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "imagePathLastUpdated": "2019-08-24T14:15:22Z",
    "isUsed": true,
    "logisticWidth": 0,
    "logisticHeight": 0,
    "logisticDepth": 0,
    "clientId": 0,
    "productId": 0,
    "supplierProductSkuClient": [ … ],
    "onHands": [ … ],
    "priceLists": [ … ]
  },
  "warehouse": {
    "id": 0,
    "defaultName": "string",
    "isActive": true,
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "clientProductSkuOnHand": [ … ],
    "clientWarehouse": [ … ],
    "clientWarehouseLocation": [ … ],
    "supplierProductSkuOnHand": [ … ]
  }
}

SupplierProductSku

partNostring or null[ 0 .. 50 ] characters

The supplier part number.

supplierIdinteger(int32)

The supplier identifier.

namestring or null[ 0 .. 500 ] characters

The name of the supplier product sku.

manufacturerIdinteger or null(int32)

The manufacturer identifier.

manufacturerCodestring or null[ 0 .. 50 ] characters

The manufacturer code.

manufacturerPartNostring or null[ 0 .. 50 ] characters

The manufacturer part number.

categoryIdinteger or null(int32)

The category identifier.

categoryCodestring or null[ 0 .. 255 ] characters

The category code.

commodityCodestring or null[ 0 .. 50 ] characters

The commodity code.

eanCodestring or null[ 0 .. 50 ] characters

The EAN code.

grossWeightnumber or null(decimal)

The gross weight.

netWeightnumber or null(decimal)

The net weight.

vatCodeIdinteger or null(int32)

The vat code identifier.

unitOfMeasurementIdinteger(int32)

The unit of measurement identifier.

unitOfMeasurementCountnumber(decimal)

The unit of measurement count.

urlstring or null[ 0 .. 255 ] characters

The URL. Not commonly used.

imagePathstring or null[ 0 .. 255 ] characters

The image path. Not used anymore.

createdstring(date-time)

The date and time the record was created.

createdByinteger(int32)

The identifier of the user who created the record.

updatedstring or null(date-time)

The date and time the record was last updated.

updatedByinteger or null(int32)

The identifier of the user who last updated the record.

imagePathLastUpdatedstring or null(date-time)

The image path last updated. Not used anymore.

isUsedboolean

Indicates whether the supplier product sku is refurbished. Not commonly used.

logisticWidthnumber or null(decimal)

The logistic width.

logisticHeightnumber or null(decimal)

The logistic height.

logisticDepthnumber or null(decimal)

The logistic depth.

clientIdinteger or null(int32)

The client identifier.

productIdinteger or null(int32)

The product identifier.

supplierProductSkuClientArray of objects or null(SupplierProductSkuClient)

onHandsArray of objects or null(SupplierProductSkuOnHand)

priceListsArray of objects or null(SupplierProductSkuPriceList)

{
  "partNo": "string",
  "supplierId": 0,
  "name": "string",
  "manufacturerId": 0,
  "manufacturerCode": "string",
  "manufacturerPartNo": "string",
  "categoryId": 0,
  "categoryCode": "string",
  "commodityCode": "string",
  "eanCode": "string",
  "grossWeight": 0,
  "netWeight": 0,
  "vatCodeId": 0,
  "unitOfMeasurementId": 0,
  "unitOfMeasurementCount": 0,
  "url": "string",
  "imagePath": "string",
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "imagePathLastUpdated": "2019-08-24T14:15:22Z",
  "isUsed": true,
  "logisticWidth": 0,
  "logisticHeight": 0,
  "logisticDepth": 0,
  "clientId": 0,
  "productId": 0,
  "supplierProductSkuClient": [
    { … }
  ],
  "onHands": [
    { … }
  ],
  "priceLists": [
    { … }
  ]
}

SupplierProductSkuClient

partNostring or null[ 0 .. 50 ] characters

The supplier part number.

supplierIdinteger(int32)

The supplier identifier.

clientIdinteger(int32)

The client identifier.

productIdinteger or null(int32)

The product identifier.

manufacturerIdinteger or null(int32)

The manufacturer identifier.

categoryIdinteger or null(int32)

The category identifier.

createdstring(date-time)

The date and time the record was created.

createdByinteger(int32)

The identifier of the user who created the record.

updatedstring or null(date-time)

The date and time the record was last updated.

updatedByinteger or null(int32)

The identifier of the user who last updated the record.

product(Product (object or null))

One of:

sku(SupplierProductSku (object or null))

One of:

{
  "partNo": "string",
  "supplierId": 0,
  "clientId": 0,
  "productId": 0,
  "manufacturerId": 0,
  "categoryId": 0,
  "created": "2019-08-24T14:15:22Z",
  "createdBy": 0,
  "updated": "2019-08-24T14:15:22Z",
  "updatedBy": 0,
  "product": {
    "id": 0,
    "clientId": 0,
    "manufacturerId": 0,
    "manufacturerPartNo": "string",
    "defaultName": "string",
    "defaultSubHeader": "string",
    "defaultSubDescription": "string",
    "defaultDescriptionHeader": "string",
    "defaultDescription": "string",
    "defaultImagePath": "string",
    "defaultThumbnailImagePath": "string",
    "defaultCampaignImagePath": "string",
    "defaultLargeImagePath": "string",
    "defaultSynonyms": "string",
    "sortOrderValue": 0,
    "assortmentId": 0,
    "assortmentLastUpdated": "2019-08-24T14:15:22Z",
    "assortmentLastUpdatedBy": 0,
    "isVariant": true,
    "variantId": 0,
    "alias": "string",
    "defaultTitle": "string",
    "defaultTags": "string",
    "defaultMetaTags": "string",
    "defaultMetaDescription": "string",
    "hideInTopList": true,
    "isActive": true,
    "stoppedDate": "2019-08-24T14:15:22Z",
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "insuranceCurrencyId": 0,
    "insuranceStartPrice": 0,
    "insuranceRunningPercentage": 0,
    "key": "string",
    "manufacturerPartNo2": "string",
    "imageKey": "string",
    "defaultUniqueUrlName": "string",
    "stockDisplayBreakPoint": 0,
    "isDangerousGoods": true,
    "code": "string",
    "isRecurringOrderable": true,
    "defaultExternalDescription": "string",
    "unspscCode": "string",
    "translationRequested": "2019-08-24T14:15:22Z",
    "translationRequestedBy": 0,
    "defaultImageAltText": "string",
    "flags": [ … ],
    "skus": [ … ],
    "categories": [ … ],
    "cultures": [ … ],
    "families": [ … ],
    "files": [ … ],
    "parametrics": [ … ],
    "parametricMultiple": [ … ],
    "productRelations": [ … ],
    "productRelationRelatedProduct": [ … ],
    "supplierSkus": [ … ],
    "variant": { … }
  },
  "sku": {
    "partNo": "string",
    "supplierId": 0,
    "name": "string",
    "manufacturerId": 0,
    "manufacturerCode": "string",
    "manufacturerPartNo": "string",
    "categoryId": 0,
    "categoryCode": "string",
    "commodityCode": "string",
    "eanCode": "string",
    "grossWeight": 0,
    "netWeight": 0,
    "vatCodeId": 0,
    "unitOfMeasurementId": 0,
    "unitOfMeasurementCount": 0,
    "url": "string",
    "imagePath": "string",
    "created": "2019-08-24T14:15:22Z",
    "createdBy": 0,
    "updated": "2019-08-24T14:15:22Z",
    "updatedBy": 0,
    "imagePathLastUpdated": "2019-08-24T14:15:22Z",
    "isUsed": true,
    "logisticWidth": 0,
    "logisticHeight": 0,
    "logisticDepth": 0,
    "clientId": 0,
    "productId": 0,
    "supplierProductSkuClient": [ … ],
    "onHands": [ … ],
    "priceLists": [ … ]
  }
}

Application

Operations

Core

Operations

Customers

Operations

Order

Operations

Products

Operations

Shopping

Operations

Metadata

Operations