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
- Sales & InventoryYour sales, stock, purchasing and machines in one section of the left menu, whether your numbers live in Lightspeed or in TicketStacker.
- InventoryTrack warehouse stock, order packs and bundles from vendors, turn receipts into orders, restock machines from a pick list, and count stock. An add-on.
- Retail tools for LightspeedConnect Lightspeed Retail and your sales, items and shops come into TicketStacker every minute, with sales reports by shop, brand, vendor and more.
- Shopify as your store systemNo Lightspeed? Connect Shopify and the Retail tools work on your Shopify products, stock and orders, sending prices, tags, images and stock back to Shopify.
- Vending salesSandStar sales by product, machine and day, reconciled the way SandStar's own reports are, with profit from your own product costs.
- Analytics across shops and machinesOne view of the money from every source: shop sales, machine sales and ATM earnings, by month, by Location and by item.
- LocationsAdd your stores, offices or sites with a shared email and a manager, then route tickets and emails to them.
Still stuck? Email hello@ticketstacker.com. A real person reads every message.
