Aller au contenu principal

Marketplace Smartscale Reports

Smartscale Usage

Report Type - SMARTSCALE_USAGE

Description

This report outputs a daily summary of Smartscale usage

Example Report

Column NameData TypeDefinitionExampleSince Report Version
merchant_store_idnumberMerchant store id12341
local_datedateLocal store date6/30/251
daypartvarcharStore daypartDaypart 1: Open - 6 am1
store_namevarcharStore nameMetro Pizza Main Street1
total_ordersnumberTotal orders placed on the day141
total_weighednumberTotal number of orders weighed101
percent_orders_weighedvarcharPercent of orders weighed72.51
missing_items_ignoredvarcharMissing items not caught01
estimated_caughtvarcharEstimated missing items caught21
estimated_savingsnumberEstimated savings from missing items caught8.161
unweighed_missingvarcharUnweighed orders with missing items01
currencyvarcharThe currency used for transactions in this storeUSD1

Smartscale Order Level

Report Type - SMARTSCALE_ORDER

Description

This report outputs order level information of smartscale usage

Example Report

Column NameData TypeDefinitionExampleSince Report Version
Delivery IDvarcharThe unique identifier of the order1847860522621
Business IdnumberThe unique identifier for the business1851
Store IdnumberThe unique identifier for the store247251
Order ChannelvarcharThe source of the orderORDER_CHANNEL_DRIVE1
First Weighed UTCtimestampThe date and time the order first registered a weight on the SmartScale in UTC2024-06-08 12:02:57 AM1
First Weighed Time LocaltimestampThe date and time the order first registered a weight on the SmartScale in local timezone2024-06-08 12:02:57 AM1
Was WeighedbooleanIf the order was weighedTRUE1
FlaggedbooleanIf the order was flaggedTRUE1
Flagged and FixedbooleanIf the order was flagged and fixedTRUE1
Is Doordash OrderbooleanIf the order was a DoorDash orderTRUE1