CoolR Group Inc

Appearance

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

User (Full Data Dump) ​

Fields Removed:

  • EmployerName - Removed employer name

Changes:

  • Employer is no longer maintained on user records

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