inRiver Documentation

Appearance

Product Schema ​

Entity Type: Product
Purpose: Represents a product with associated items, resources, and relationships
Sample File: Product_19456_20260217073600.json

Structure ​

json
{
  "EntityId": number,
  "EntityTypeId": "Product",
  "FieldSetId": null,
  "Attributes": { ... },
  "Items": [ ... ],
  "Resources": [ ... ],
  "InboundLinks": [ ... ],
  "OutboundLinks": [ ... ]
}

Top-Level Properties ​

  • EntityId (number) - Unique product identifier
  • EntityTypeId (string) - Always "Product"
  • FieldSetId (null) - Optional fieldset reference
  • Attributes (object) - Product-level attributes
  • Items (array) - Associated Item entities (SKUs)
  • Resources (array) - Product-level media/documents
  • InboundLinks (array) - Entities linking to this product
  • OutboundLinks (array) - Entities this product links to

Items Array ​

Each product contains one or more Item entities representing SKUs:

json
{
  "EntityId": number,
  "EntityTypeId": "Item",
  "FieldSetId": null,
  "Attributes": { ... },
  "Resources": [ ... ],
  "InboundLinks": [ ... ],
  "OutboundLinks": [ ... ]
}

Key Item Attributes ​

Identification:

  • ItemLegacyPIMItemNo - Legacy PIM identifier
  • ItemManufacturerItemNo - Manufacturer part number
  • ItemWatscoItemNo - Watsco internal item number
  • ItemUPCCode - UPC barcode
  • ItemEANCode - EAN barcode
  • ItemGTINCode - GTIN code

Supplier Information:

  • ItemMainSupplier - Primary supplier name
  • ItemManufacturer - Manufacturer name
  • ItemSupplierShortDescriptionEN - Short description
  • ItemSupplierLongDescriptionEN - Long description

Physical Attributes:

  • ItemItemImperialHeightinInches
  • ItemItemImperialLengthinInches
  • ItemItemImperialWidthinInches
  • ItemItemImperialWeightinPounds
  • ItemItemImperialCubicMeasurement
  • ItemItemImperialDimensionalWeight

Packaging:

  • ItemPackagedImperialHeightinInches
  • ItemPackagedImperialLengthinInches
  • ItemPackagedImperialWidthinInches
  • ItemPackagedImperialWeightinPounds
  • ItemItemQuantity
  • ItemItemQuantityType (e.g., "EA")
  • ItemItemPackagedQuantity
  • ItemItemMastCartonQuantity

Inventory & Status:

  • ItemOnHandQtyInAllWatscoSubs - Total on-hand quantity
  • ItemSupplierDiscontinuedFlag - Discontinuation status
  • ItemCreatedOn - Creation timestamp
  • ItemLastChangedon - Last modified timestamp

Business Flags:

  • ItemHydrosItem - Hydros system flag
  • ItemSupplySyncItem - Supply sync flag
  • ItemRebateItem - Rebate eligibility
  • ItemRebateCategory - Rebate category
  • ItemOEMPart - OEM part flag

Origin:

  • ItemCountryofOrigin - Array of country codes (e.g., ["USA"])

Resources ​

Both Product and Item entities can have associated resources:

json
{
  "ResourceURL": "https://asset.productmarketingcloud.com/api/assetstorage/...",
  "Attributes": {
    "ResourceTitle": "string",
    "ResourcePublishedStatus": "NotPublished",
    "ResourceResourceType": "normal|cl|subs|...",
    "ResourceFileId": number,
    "ResourceFilename": "string",
    "ResourceMIMEType": "jpeg|pdf|...",
    "ResourceAcceptedFile": null,
    "ResourceImportProcessed": boolean,
    "ResourceSourceURL": null
  }
}

Resource Types ​

  • normal - Standard product image
  • cl - Cutsheet/catalog
  • subs - Submittal sheet
  • ii - Installation instructions
  • msdss - MSDS sheet
  • war - Warranty document

Entities that reference this product (e.g., ChannelNodes, other Products)

Entities this product references (e.g., related products, channel assignments)

Example Hierarchy ​

Product 19456
└── Item 3424
    ├── Resource (cl) - 1369225580515_en_cl.pdf
    ├── Resource (normal) - 1369225580515_en_normal.jpg
    └── Resource (subs) - 1369225580515_en_subs.pdf

Usage ​

Products are the primary entity for e-commerce integration:

  • Contains all SKU-level data via Items array
  • Links to media assets via Resources
  • Connects to categories via ChannelNode relationships
  • Provides complete product information for display and ordering