Skip to main content

Version History

This page tracks all schema version changes across all Data Publisher exports. For details on individual exports, see Incremental Data Delta and Full Data Dump.

Version 01.01 (Current)​

Release Date: February 2026

Asset Purity (Incremental Data Delta)​

Fields Added:

  • StatusId - Status of the cooler
  • ImageStatus - Image status (e.g., "New", "Provisioned")
  • DoorOpenUtc - Door open time in UTC
  • CaseSuggested - Suggested order quantity in cases
  • ValueSuggested - Suggested order value
  • CompliantShelvesProductType - Compliant shelves by product type
  • CompliantShelvesPackageType - Compliant shelves by package type
  • OurProductFillLevel - Our product fill level
  • InStoreAndPlanogramOurProductCount - Our products both in-store and in planogram
  • OurProductCount - Total our product count
  • TotalProductFillLevel - Total product fill level
  • TotalProductCountInImage - Total products detected in image
  • PogOwnProductCount - Own products in planogram
  • AssortmentDepthCompliance, ShareOfShelf, TargetPortfolioOutOfStock, Occupancy, ShelfAvailability, OnShelfAvailability, TargetPortfolioCompliance
  • PlanogramFacings - Calculated facings (0 if SceneTypeId = 5, else Planogram.Facings)
  • ReplenishModelId - Calculated from Planogram.ReplenishModelId or Client.ReplenishModelId
  • LatestProcessedPurityId - Latest processed purity ID (from AssetAttribute)
  • IsRouteC - Whether camera type is Route C (from AssetAttribute)
  • SmartDeviceTypeId - Type identifier for the smart device

Fields Removed:

  • PurityStatus - Product IDs detected in the image (removed to simplify export)
  • TagStatus - Product tag status (removed to simplify export)
  • TagAndPurityStatusExists - Computed flag (removed with PurityStatus and TagStatus)
  • ClientReplenishModelId - Client replenishment model ID (removed)
  • IsStitched - Image stitching flag
  • StitchImageValue - Display value for IsStitched
  • UniqueGuid - Unique image identifier
  • ImageCount - Number of images in purity check
  • Image1size - Size of first image
  • Image2size - Size of second image
  • RawFileName - Raw image file name
  • FlashSequence - Flash sequence identifier
  • IsImageFromSurvey - Computed flag indicating survey source
  • ReplenishModelIdCalculated - Replaced with ReplenishModelId

Changes:

  • Added comprehensive KPI computed fields for business analytics
  • Added smart device and gateway tracking fields
  • Added planogram configuration flags for better business rule handling
  • Included asset type classification fields
  • Enhanced metadata with scene type, reject reasons, and image status
  • Removed product-level detection data (PurityStatus, TagStatus) to streamline export
  • Removed low-level image metadata fields to focus on business metrics

Asset Day KPI (Incremental Data Delta)​

Fields Added:

  • LatestAssetPurityId - ID of the latest asset purity record for this date
  • TotalGSMDuration - Total GSM duration for the day
  • GSMEventCount - Number of GSM events
  • GSMBatteryLevelMin - Minimum GSM battery level
  • GSMBatteryLevelMax - Maximum GSM battery level
  • GsmOnDurationMin - Minimum GSM on duration
  • GsmOnDurationMax - Maximum GSM on duration

AssetPurity KPI Fields Added (from latest purity check of the day):

All fields from the latest AssetPurity record are now included in AssetDayKPI for consolidated daily reporting:

  • Core purity metrics: EmptyFacings, TotalStock, ForeignProduct, TotalFacings, OurStock, CompliantFacings, PurityPercentage, StockPercentage, PlanogramCompliance
  • Percentage metrics: OOSPercentage, ForeignProductPercentage, EmptyProductPercentage
  • Order suggestions: CaseSuggested, ValueSuggested
  • Product counts: CompliantShelvesProductType, CompliantShelvesPackageType, OurProductFillLevel, InStoreAndPlanogramOurProductCount, OurProductCount, TotalProductFillLevel, TotalProductCountInImage, PogOwnProductCount
  • KPI computed fields: AssortmentDepthCompliance, ShareOfShelf, TargetPortfolioOutOfStock, Occupancy, ShelfAvailability, OnShelfAvailability, TargetPortfolioCompliance
  • Calculated fields: PlanogramFacings

Changes:

  • Added GSM health monitoring fields for battery and duration tracking
  • Integrated all AssetPurity KPI fields from the latest purity check for consolidated daily reporting
  • Enhanced daily KPI tracking with comprehensive purity metrics
  • Improved visibility into asset health and performance
  • Provides single export combining operational data (door opens, temperature, GSM) with purity analysis

Product (Full Data Dump)​

Fields Removed:

  • ProductType - Removed product type classification field

Changes:

  • Simplified product schema by removing redundant type classification

Outlet (Full Data Dump)​

Fields Removed:

  • AlertCount - Removed alert count aggregation
  • OutletNumber - Removed outlet number field

Changes:

  • Streamlined outlet schema by removing deprecated fields
  • Alert counts available through Alert export instead

Alert (Full Data Dump)​

Fields Removed:

  • ExternalDate - Removed external date tracking
  • CameraNotWorkingReasonId - Removed camera failure reason ID
  • CameraNotWorkingReason - Removed camera failure reason description

Changes:

  • Simplified alert schema by removing deprecated camera-specific fields
  • Camera health tracking consolidated in other exports

Channel (Full Data Dump)​

Changes:

  • Schema rename only, no field changes
  • Improved naming consistency

Version 01.00​

Release Date: Initial release (February 2026)

Initial release of all Data Publisher exports with baseline schema definitions.

Version History Notes​

  • Asset Purity & Asset Day KPI: Major enhancements in v01.01 with smart device tracking and comprehensive KPI integration
  • Full Data Dump: Minor cleanup in v01.01 removing deprecated/redundant fields
  • Incremental Data Delta: AssetPurityProduct, ConsumptionLog, and ScheduledOrderItem remain at v01.00