Brisbane Transport Museum

QOCS - Brisbane Transport Museum

Operational data for admissions, cash, stock, and daily Square reporting.

Drinks & snacks tool

This is the local management tool for the snack range. It lists the full drinks and snacks catalog from Square, lets you review the snack range and includes the snack inventory analysis so restocking decisions live in one place. Expiry batch maintenance now has its own dedicated page inside this tool.

Refresh tool Download ordering PDF Open expiry management Open stock valuation

Tool Summary

Snack variations
58
Full drinks and snacks range matched from the Square catalog.
Tracked items
0
Snack items that already have at least one local expiry batch saved.
Local expiry batches
0
Expiry records saved in this app only. Manage them from the expiry page.

How This Tool Works

Use this page to review the full snack range and the rolling 12-month stock analysis. Expiry dates, quantities, and notes are still saved only in this app, but they are now managed from the dedicated expiry page.

The inventory analysis below still uses those local expiry batches, so expiry risk and restocking stay connected even though batch entry is on its own page.

Current storage file: /home2/qocsorg/public_html/sdap.qocs.org.au/storage/data/inventory-expiry.json

Open expiry management

Entire Snack Range

Range Category Item Variation SKU Stock on hand Local expiry batches Nearest expiry Nearest batch qty Nearest batch note
Chips Chips / Snacks Pringles Original Regular V847323 0 0 Not tracked Not tracked None
Chips Chips / Snacks Red Rock Deli Chips Honey Soy 8181376 0 0 Not tracked Not tracked None
Chips Chips / Snacks Smiths Chips Cheese and Onion 853239E 0 0 Not tracked Not tracked None
Chips Chips / Snacks Smiths Chips Chicken 859935E 0 0 Not tracked Not tracked None
Chips Chips / Snacks Smiths Chips Original 138809V 0 0 Not tracked Not tracked None
Chips Chips / Snacks Smiths Chips Salt & Vinegar 1128607 0 0 Not tracked Not tracked None
Chips Chips / Snacks Twisties Cheese T912058 0 0 Not tracked Not tracked None
Chips Chips / Snacks Twisties Chicken F878348 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Cadbury Dream 50Gram Regular 6411909 3 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Cadbury Flake Regular None 1 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Cadbury Peanut Caramal 48 gram Regular 9048992 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Cadbury Picnic Regular None 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Caramilk Bar Regular Z407728 1 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Cherry Ripe , Double Dipped 40Grsm Regular None 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Chocolate Bar - Unlisted Regular None 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Chomp Bar Default Q094432 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Crunchie 50 Gram Regular None 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Curly Wurly Default 802126W 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Dairy Milk Chocolate Regular 3052207 5 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks KitKat Chunky F037176 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks KitKat Chunky with Biscoff 6154655 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks KitKat Gold 254824G 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks KitKat Original 485467B 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks M&M Minis 35Gram Regular None 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Mars 47Gram Regular None 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Nestle Mint Pattie 20Gram Regular 317355W 1 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Reese's Nutrageous Bar, 1.66 oz 18 Count 2146277 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Reeses Peanut Butter Cup 42g Default 4939923 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Snickers Original 626892R 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Snickers Peanut Brownie K462960 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks Twirl Bar Regular M224507 0 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks cherry ripe 44gram Default None 2 0 Not tracked Not tracked None
Chocolates Chocolates / Snacks dairy milk slices Peanut Caramel Default None 1 0 Not tracked Not tracked None
Drinks Drinks Coke Can 375ml Regular A107049 25 0 Not tracked Not tracked None
Drinks Drinks Coke No Sugar 375ml Regular M273089 24 0 Not tracked Not tracked None
Drinks Drinks Coke Vanilla 375ml Regular Y143512 0 0 Not tracked Not tracked None
Drinks Drinks Fanta Can 375ml Regular B280976 12 0 Not tracked Not tracked None
Drinks Drinks Frantelle Water 600ml Regular 787428P 13 0 Not tracked Not tracked None
Drinks Drinks Kirks Creaming Soda 375ml Regular M500567 12 0 Not tracked Not tracked None
Drinks Drinks Kirks Ginger Ale 375ml Regular 2158126 0 0 Not tracked Not tracked None
Drinks Drinks Kirks Ginger Beer 375ml Regular G118598 0 0 Not tracked Not tracked None
Drinks Drinks Kirks Lemon Squash 375ml Regular 623994M 0 0 Not tracked Not tracked None
Drinks Drinks Kirks Lemonade 375ml Regular S642053 13 0 Not tracked Not tracked None
Drinks Drinks Kirks Pasito 375ml Regular 2742700 7 0 Not tracked Not tracked None
Drinks Drinks Kirks Pasito Sugar Free 375ml Regular 574685D 0 0 Not tracked Not tracked None
Drinks Drinks Kirks Sugar Free Lemonade 375Ml Regular N913269 0 0 Not tracked Not tracked None
Drinks Drinks Kirks orange 375ml Regular 7561262 2 0 Not tracked Not tracked None
Drinks Drinks NU Springwater 600ML Regular None -1 0 Not tracked Not tracked None
Drinks Drinks Pepsi Max 375ml Regular Q298781 11 0 Not tracked Not tracked None
Drinks Drinks Q Cola Regular S591103 0 0 Not tracked Not tracked None
Drinks Drinks Q Diet Cola Regular 6444137 0 0 Not tracked Not tracked None
Drinks Drinks Q Pineapple Regular 1488615 0 0 Not tracked Not tracked None
Drinks Drinks Schweppes Lemonade 375ml Regular P139088 0 0 Not tracked Not tracked None
Drinks Drinks Solo 375ml Regular None 21 0 Not tracked Not tracked None
Drinks Drinks Sprite 375ML Regular 711662B 19 0 Not tracked Not tracked None
Drinks Drinks Sunkist Orange 375ML Regular None 28 0 Not tracked Not tracked None
Snacks Snacks Category sale : SNACKS Regular 148921G 0 0 Not tracked Not tracked None
Snacks Snacks Sausage Sizzle Regular K311041 0 0 Not tracked Not tracked None

Snack Inventory Analysis

Inventory Summary

Snack items
32
Matched from drinks, chocolates, and chips in the Square catalog.
Stock on hand
200
Tracked units currently in stock across the snack range.
Sold last 12 months
375
Completed sales matched back to unique Square orders.
Restock now
13
Out of stock or holding under one month of average sales.
Restock soon
2
Holding between one and three months of average sales.
Excess cover
10
Items holding more than 6 months of average sales cover.
Expiry attention
0
Items tracked with expired or short-dated stock needing action.

Snapshot generated at 18 Aug 2026 12:54:32 PM in Australia/Brisbane. Scope: D8Q4ZVN5YVC2B across 1 location.

Restock logic: Out of stock means recent sales with no stock on hand. Restock now means less than 1 month of cover. Restock soon means between 1 and 3 months of cover. Excess cover means more than 6 months of cover. Suggested reorder aims to bring each item back to 3 months of average sales cover.

1 line item could not be matched to a tracked catalog variation because Square did not return a catalog object ID.

Range Breakdown

Range Items Stock on hand Sold 12 months Avg / month Restock now
Chocolates 15 14 36 3 8
Drinks 16 186 206 17.17 4
Snacks 1 0 133 11.08 1

Expiry Tracking

Tracked items
0
Rows in this report with at least one expiry record matched.
Expired
0
Expiry date is already past the selected as at date.
Discount now
0
Seven days or less remaining.
Discount soon
0
Inside the batch discount lead time.

Expiry tracking is optional and not configured yet. When you are ready, create /home2/qocsorg/public_html/sdap.qocs.org.au/storage/data/inventory-expiry.json using the example at /home2/qocsorg/public_html/sdap.qocs.org.au/storage/data/inventory-expiry.example.json.

Restock Priority

Range Item Variation SKU Stock on hand Avg / month Cover Suggested reorder Status
Drinks NU Springwater 600ML Regular None -1 0.08 -12.0 months 2 Out of stock
Chocolates Cadbury Picnic Regular None 0 0.17 0.0 months 1 Out of stock
Chocolates Cherry Ripe , Double Dipped 40Grsm Regular None 0 0.08 0.0 months 1 Out of stock
Chocolates Crunchie 50 Gram Regular None 0 0.17 0.0 months 1 Out of stock
Chocolates M&M Minis 35Gram Regular None 0 0.17 0.0 months 1 Out of stock
Chocolates Mars 47Gram Regular None 0 0.08 0.0 months 1 Out of stock
Chocolates Snickers Peanut Brownie K462960 0 0.17 0.0 months 1 Out of stock
Chocolates Snickers Original 626892R 0 0.08 0.0 months 1 Out of stock
Chocolates Twirl Bar Regular M224507 0 0.17 0.0 months 1 Out of stock
Drinks Coke Vanilla 375ml Regular Y143512 0 0.08 0.0 months 1 Out of stock
Drinks Kirks Ginger Beer 375ml Regular G118598 0 0.25 0.0 months 1 Out of stock
Drinks Kirks Lemon Squash 375ml Regular 623994M 0 0.50 0.0 months 2 Out of stock
Snacks Sausage Sizzle Regular K311041 0 11.08 0.0 months 34 Out of stock
Chocolates Caramilk Bar Regular Z407728 1 0.42 2.4 months 1 Restock soon
Drinks Kirks orange 375ml Regular 7561262 2 0.75 2.7 months 1 Restock soon

Excessive Stock Cover

Range Item Variation SKU Stock on hand Sold 12 months Avg / month Cover Last sold Expiry status
Drinks Sprite 375ML Regular 711662B 19 1 0.08 228.0 months 05 Jul 2026 Not tracked
Drinks Sunkist Orange 375ML Regular None 28 2 0.17 168.0 months 04 Apr 2026 Not tracked
Drinks Fanta Can 375ml Regular B280976 12 4 0.33 36.0 months 02 Aug 2026 Not tracked
Drinks Solo 375ml Regular None 21 7 0.58 36.0 months 02 Aug 2026 Not tracked
Drinks Coke No Sugar 375ml Regular M273089 24 22 1.83 13.1 months 26 Jul 2026 Not tracked
Chocolates Dairy Milk Chocolate Regular 3052207 5 5 0.42 12.0 months 02 Aug 2026 Not tracked
Drinks Kirks Lemonade 375ml Regular S642053 13 14 1.17 11.1 months 05 Jul 2026 Not tracked
Drinks Kirks Creaming Soda 375ml Regular M500567 12 16 1.33 9.0 months 03 May 2026 Not tracked
Drinks Coke Can 375ml Regular A107049 25 34 2.83 8.8 months 02 Aug 2026 Not tracked
Drinks Kirks Pasito 375ml Regular 2742700 7 13 1.08 6.5 months 02 Aug 2026 Not tracked

Snack Range Detail

Range Category Item Variation SKU Stock on hand Sold 12 months Avg / month Cover Suggested reorder Last sold Expiry Expiry status Notes
Drinks Drinks NU Springwater 600ML Regular None -1 1 0.08 -12.0 months 2 02 Aug 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Chocolates Chocolates / Snacks Cadbury Picnic Regular None 0 2 0.17 0.0 months 1 07 Feb 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Chocolates Chocolates / Snacks Cherry Ripe , Double Dipped 40Grsm Regular None 0 1 0.08 0.0 months 1 07 Mar 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Chocolates Chocolates / Snacks Crunchie 50 Gram Regular None 0 2 0.17 0.0 months 1 07 Feb 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Chocolates Chocolates / Snacks M&M Minis 35Gram Regular None 0 2 0.17 0.0 months 1 11 Nov 2025
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Chocolates Chocolates / Snacks Mars 47Gram Regular None 0 1 0.08 0.0 months 1 04 Oct 2025
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Chocolates Chocolates / Snacks Snickers Peanut Brownie K462960 0 2 0.17 0.0 months 1 04 Oct 2025
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Chocolates Chocolates / Snacks Snickers Original 626892R 0 1 0.08 0.0 months 1 04 Oct 2025
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Chocolates Chocolates / Snacks Twirl Bar Regular M224507 0 2 0.17 0.0 months 1 16 Oct 2025
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Drinks Drinks Coke Vanilla 375ml Regular Y143512 0 1 0.08 0.0 months 1 25 Oct 2025
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Drinks Drinks Kirks Ginger Beer 375ml Regular G118598 0 3 0.25 0.0 months 1 02 Nov 2025
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Drinks Drinks Kirks Lemon Squash 375ml Regular 623994M 0 6 0.50 0.0 months 2 07 Mar 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Snacks Snacks Sausage Sizzle Regular K311041 0 133 11.08 0.0 months 34 02 Aug 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Out of stock
Expiry: None
Note: None
Chocolates Chocolates / Snacks Caramilk Bar Regular Z407728 1 5 0.42 2.4 months 1 02 Aug 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Restock soon
Expiry: None
Note: None
Drinks Drinks Kirks orange 375ml Regular 7561262 2 9 0.75 2.7 months 1 03 May 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Restock soon
Expiry: None
Note: None
Chocolates Chocolates / Snacks Nestle Mint Pattie 20Gram Regular 317355W 1 0 0 No recent sales 0 No recent sale
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: No recent sales
Expiry: None
Note: None
Chocolates Chocolates / Snacks dairy milk slices Peanut Caramel Default None 1 0 0 No recent sales 0 No recent sale
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: No recent sales
Expiry: None
Note: None
Drinks Drinks Frantelle Water 600ml Regular 787428P 13 42 3.50 3.7 months 0 10 Aug 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Drinks Drinks Pepsi Max 375ml Regular Q298781 11 31 2.58 4.3 months 0 02 Aug 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Chocolates Chocolates / Snacks Cadbury Dream 50Gram Regular 6411909 3 7 0.58 5.1 months 0 07 Jun 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Chocolates Chocolates / Snacks Cadbury Flake Regular None 1 2 0.17 6.0 months 0 07 Jun 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Chocolates Chocolates / Snacks cherry ripe 44gram Default None 2 4 0.33 6.0 months 0 03 May 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Drinks Drinks Kirks Pasito 375ml Regular 2742700 7 13 1.08 6.5 months 0 02 Aug 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Drinks Drinks Coke Can 375ml Regular A107049 25 34 2.83 8.8 months 0 02 Aug 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Drinks Drinks Kirks Creaming Soda 375ml Regular M500567 12 16 1.33 9.0 months 0 03 May 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Drinks Drinks Kirks Lemonade 375ml Regular S642053 13 14 1.17 11.1 months 0 05 Jul 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Chocolates Chocolates / Snacks Dairy Milk Chocolate Regular 3052207 5 5 0.42 12.0 months 0 02 Aug 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Drinks Drinks Coke No Sugar 375ml Regular M273089 24 22 1.83 13.1 months 0 26 Jul 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Drinks Drinks Fanta Can 375ml Regular B280976 12 4 0.33 36.0 months 0 02 Aug 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Drinks Drinks Solo 375ml Regular None 21 7 0.58 36.0 months 0 02 Aug 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Drinks Drinks Sunkist Orange 375ML Regular None 28 2 0.17 168.0 months 0 04 Apr 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None
Drinks Drinks Sprite 375ML Regular 711662B 19 1 0.08 228.0 months 0 05 Jul 2026
Date: Not tracked
Batch qty: Not tracked
 Not tracked
Restock: Healthy
Expiry: None
Note: None