Skip to main content

Retail Sales Detail

Report provides line item detail of all sales made within a Council. Data provided lists out Scout associated with sale, product sold, retail amount, and sale status

Updated this week

Audience: Council Leaders only

Fields in Report with definitions:

  • System_Sale_ID: Transaction ID from system of record

  • Scout_Username: Username scout uses to log in to app

  • Scout_Name: Scout name provided in app

  • Scout_Code: Online code scout uses to track sales

  • Unit_Name: Unit scout is associated with

  • District_Name: District scout is associated with

  • Council_Name: Council scout is associated with

  • SKU_Name: Name of product sold

  • SKU: SKU of product sold

  • Quantity: Containers sold on order

  • Total_Line_Item_Amount: Total retail amount on order

  • Payment_Type: Cash or credit card.

  • Sale_Type: What type of sale was completed(Options listed below)

    • Wagon – sales made in app that are not associated with a storefront shift

    • Storefront – sales made in app that are associated with a storefront shift

    • Online – sales made on trails-end.com

  • UTC_Sale_Timestamp: Unix Timestamp of transaction

  • Sale_Status: Current status of the line item(Options listed below))

    • Completed – Order transaction has been completed

    • Pending – Wagon order has been taken but not completed in app

    • Partial Refund – Part of order was refunded

    • Refunded – Order transaction has been refunded

Did this answer your question?