TicketStacker

Help › Your company

One product list and one sales report

See every product and every sale in one place, whether it's sold in your shops through Lightspeed or Shopify or in your machines.

If you sell in shops (Lightspeed or Shopify) and in machines (SandStar, Nayax, Cantaloupe or your own imports), each source has its own numbers. Sales & Inventory puts them side by side: one Products list and one All sales report. If you have only one of them, you see only that one, and you still get the filters and downloads.

Products

Sales & Inventory → Products lists every product from every source you can see. Each row has its picture, name, brand, UPC, where it comes from, how many you have (in your shops under Stores, in your Warehouse and in your Machines), what sold in the last 30 days, and its price and cost.

  • One row per product. When a shop item and a machine product have the same barcode, they're one row with both badges, like Lightspeed and Inventory. Barcodes match even if one has an extra leading zero. If the shop and the machines charge different prices, or have different costs, you see both.
  • Find what you need. Search by name, UPC, System ID, brand, size or the details you added to products. Narrow the list by Source (your store system, Inventory, or In both), Brand or Location (a Location linked to a shop, warehouse or machine on the Locations map). Show Active, No picture, No sales in 30 days or Archived products, and Sort by name, sales, units, on hand or price.
  • Open a product. Click a machine product to open its page. A shop item opens on Prices, where you can change its price and cost. The badges take you to each source.
  • Download CSV downloads the list you're looking at, every row.
  • With Inventory, + Add product adds a machine product, and Find missing pictures looks up pictures by barcode.

The old Inventory products page now opens this list.

All sales

Sales & Inventory → Sales → All sales adds up every sale for the dates you pick, in your company's time zone. Choose Today, This month, Last month, Last 30 days or This year, or type a From and To date.

  • The totals show Net sales (before tax), Units, Profit with its margin, and Uncosted sales.
  • Group the table by Day, Week, Location, Source, Product or Brand. Places that aren't linked to a Location yet are listed by their own name and marked Not linked to a location; link them on the Locations map to add them up under the Location.
  • Shop sales are figured the same way as your shop's own report: returns and discounts come off, and cost is the item's cost your store system recorded at the sale. Machine sales use each product's share of the sale before tax and its landed cost.
  • TicketStacker never makes up a cost. A sale whose product has no cost yet still counts in net sales, but not in cost or profit, and it's listed under Sales with no cost so you know what to fix.
  • Download CSV downloads the table with the grouping you picked, every row.

Each source's own report is still there next to it (for example Shop sales and Machine sales), and Analytics shows months, ATMs and costs. See Analytics across shops and machines.

Related

Still stuck? Email hello@ticketstacker.com. A real person reads every message.