Stock FAQs
category>Products and Stock
Below are answers to the most common questions we get about stock, so you can trust the stock numbers GymMaster shows you, and fix them when they don’t match the shelf. Each section starts with a list of its questions, so you can jump straight to the answer you need. For setting up and selling products, see Products FAQs. If you can’t find what you need, contact our Support Team.
How Stock Works
Full Guide: Update Stock Levels
- What changes a product’s stock level?
- Does a refund or void put the product back in stock?
- Can staff sell a product that has run out?
- Do online shop sales use the same stock as the POS?
- Can we get a warning when stock is running low?
- What happens if we turn stock tracking on or off for a product that’s already selling?
What changes a product’s stock level?
GymMaster works out each product’s stock for each club. It starts from the last stocktake count, then adds and takes away every stock movement since.
| Stock goes up | Stock goes down |
|---|---|
| A stock delivery entered in Stock > Input Stock Delivery | A completed sale at the Point of Sale |
| A sale that is voided | A product bought in the Member Portal or app |
| A refund with Return products to stock ticked | Remove Stock in Manually Adjust |
| Add Stock in Manually Adjust | A stocktake with a lower count |
| A stocktake with a higher count |
Stock only goes down when the sale is completed. If a payment went through on the terminal but staff didn’t finish the sale in GymMaster, nothing is recorded. Make the sale again and complete it.
Note - If a product has Stock to Deduct per Purchase set above 1, each sale takes away that many.
Does a refund or void put the product back in stock?
It depends on how the sale is removed.
| What you do | What happens to stock |
|---|---|
| Void on the member’s account | The product goes back in stock automatically |
| Reverse (Void) on the member’s account | The product stays out of stock |
| Refund the payment with the line set to Refund and Return products to stock ticked | The product goes back in stock |
| Refund the payment with Return products to stock left unticked | The product stays out of stock |
| Partial Refund or Refund and Pay Later | The product stays out of stock |
GymMaster shows Reverse (Void) instead of Void when the sale can’t be changed directly. For example, the period is locked, the invoice was emailed or the sale was sent to Xero. If the item goes back on the shelf, add it back with Manually Adjust (see How do I correct our stock numbers or write off damaged stock?).
The box shows the number of items, e.g. Return 2 products to stock. Only tick it if the items can be sold again. Leave it unticked for opened or damaged items. For refund steps, see Refunding Payments.
Can staff sell a product that has run out?
At the Point of Sale, yes. A product with no stock shows a Sold Out label on its tile, but staff can still sell it. The stock level then goes below zero.
A negative stock level means you’ve sold more than GymMaster knows you had. The usual cause is a delivery that wasn’t entered. Enter the missing delivery, or do a stocktake to set the correct count.
In the Member Portal and app, no. Members see the product as sold out and can’t buy it. They also can’t buy more than the stock you have left.
Do online shop sales use the same stock as the POS?
Yes. A product bought in the Member Portal or app comes out of the same stock count as a Point of Sale sale, as soon as the purchase is completed. It also shows in the same product sales reports.
There are two differences:
- Online sales come out of the stock at the member’s home club
- Online sales stop at zero. Members can’t buy a sold-out product, or more than you have left. At the Point of Sale, staff can still sell when stock is at zero
To sell a product online, tick Sell Online on the product. See Products.
Can we get a warning when stock is running low?
Yes, by email and by report.
On each product, navigate to; Settings > Products and edit the product:
- Tick Track Stock
- Tick Receive Low Stock Email
- Enter the Minimum Stock Level Notification
- Save
Then tick Low stock notification on each staff member who should get the email. They need Point of Sale permissions at that club. See Staff Member Options.
The email is sent once a week, on Mondays. It lists products below their minimum, grouped by supplier, with the supplier’s email and website. If no products are below their minimum, no email is sent.
To check at any time, run the Products Below Their Minimum Stock Level report.
What happens if we turn stock tracking on or off for a product that’s already selling?
GymMaster records the quantity of every product sale, whether Track Stock is on or not. Your sales history and reports don’t change.
Turning it on - With no stocktake to start from, GymMaster counts every past sale against a starting level of zero. The stock level will usually show as a large negative number. Do a stocktake for the product straight away to set the real count.
Turning it off - The product no longer shows in View Stock, stocktakes or low stock emails. The online shop no longer stops sales at zero.
You can turn tracking back on at any time. Do a stocktake when you do.
Fixing Stock Counts
- Our stock count is wrong. How do I find out where the missing items went?
- How do I correct our stock numbers or write off damaged stock?
- Who can change stock numbers, and can I see who did?
Our stock count is wrong. How do I find out where the missing items went?
Check the product’s Stock Movements. They list every change to its stock.
- Navigate to; Settings > Products and edit the product
- Select Stock Movements
- Set the Date Range to start from your last stocktake, and select the Club
Each row shows the date, what happened and how many were Increased or Decreased. This includes sales, refunds, deliveries, manual adjustments and stocktake differences.
Look for:
- Sales made at another club
- Deliveries entered with the wrong quantity or club
- Sales that were voided
- Manual adjustments
You can also see totals in Stock > View Stock. These are Sold since last stocktake, Adjusted and Purchased.
If everything checks out, the difference is likely loss or theft. Record it with a stocktake and enter a Reason.
How do I correct our stock numbers or write off damaged stock?
There are two ways.
Stocktake - Best when you count several products.
- Navigate to; Stock > Stocktake > Add Stocktake
- Filter by supplier or product category if you’re counting one section
- Select Print Stocktake if you want a paper count sheet
- Enter each product’s count in Counted, and a Reason for any difference
- Save
You only need to fill in the products you counted. The others aren’t changed. A stocktake is for the club you’re logged in to. The stocktake time can’t be before the latest sale or delivery at that club.
Manually Adjust - Best for one product, such as expired or broken stock.
- Navigate to; Settings > Products, edit the product and select Stock Movements
- Select Manually Adjust
- Select the Club, then Remove Stock (or Add Stock) as the Movement Type
- Enter the Quantity and Notes, e.g. “Expired, thrown out”
- Save and close
For step-by-step help, see Stocktake.
Who can change stock numbers, and can I see who did?
What staff can do depends on their permissions.
| Task | Permission needed |
|---|---|
| View Stock, Stocktake and Input Stock Delivery | Point of Sale access at Intermediate or Admin level |
| Stock Movements and Manually Adjust | Settings access (Support Staff or Admin) |
| Turn Track Stock on or off, change Cost Price | Settings access (Support Staff or Admin) |
To see who made a change:
- Stock > Stocktake shows the staff member for each stocktake
- Stock Movements shows the staff member’s name on each manual adjustment
- The Log Details report shows staff activity, including changes to products
We recommend you only give staff you trust access to Manually Adjust. See Staff Access.
Reports and Value
- Do stock changes affect member accounts or financial reports?
- Which reports show product sales, stock on hand and stock value?
- How do I work out what our stock is worth?
Do stock changes affect member accounts or financial reports?
Sales and refunds do, in the usual way. Changes that only affect stock don’t.
- Sales, voids and refunds - These show on the member’s account and in your sales and payment reports
- Stock deliveries - These don’t show on any member account. They show in the Product Purchases For a Given Period report
- Stocktakes and manual adjustments - These change the quantity only, with no dollar amount. They don’t change revenue, payments or member balances
Record what you pay suppliers in your accounting system.
Which reports show product sales, stock on hand and stock value?
Run these from your reports.
| Report | What it shows |
|---|---|
| Product Sales For a Given Period | Quantity and amount sold for each product and club, with tax, cost and profit. Use it to find your best sellers |
| Product Sales By Staff Member | Product sales grouped by the staff member who made the sale |
| Inventory Stock Level | Stock of each tracked product at the end date, for one club or all clubs |
| All Products | All current products with their stock level now |
| Products Below Their Minimum Stock Level | Products with less stock than their Minimum Stock Level Notification |
| Product Purchases For a Given Period | Stock deliveries from suppliers |
For stock value, use Stock > View Stock. See How do I work out what our stock is worth?
Note - Refunds and credit notes don’t reduce the amounts in Product Sales For a Given Period. There’s no separate loss report. Use the Reason column in your stocktakes and the product’s Stock Movements.
How do I work out what our stock is worth?
Use View Stock.
- Navigate to; Stock > View Stock
- Select the Club (or All Clubs) and the Date
The page shows each product’s Quantity, Stock Value (Incl. Tax) and Stock Value (Excl. Tax), with totals.
Stock value is the stock level multiplied by the product’s Cost Price. It doesn’t use the sale price. It also doesn’t use the cost you entered on each delivery, only the product’s current Cost Price. Keep Cost Price up to date on each product. A product with no cost price has a value of zero.
Stock > Stocktake also shows a Total Value for each stocktake, based on the counted stock.
Multi-Site, Suppliers and Setup
- Is stock shared between our clubs, and can we move stock between them?
- How do I record suppliers, deliveries and what we paid for stock?
- Can we scan barcodes at the POS?
- How does stock work for cases, multipacks and different sizes?
- Can GymMaster track expiry dates on products?
- How do I add lots of products and their stock at once?
Is stock shared between our clubs, and can we move stock between them?
Stock is kept separately for each club. Each club’s sales, deliveries, stocktakes and adjustments only change that club’s stock. The clubs a product is sold at are set on its product category.
There’s no stock transfer feature. To move stock, use Manually Adjust on the product:
- Remove Stock at the club sending it
- Add Stock at the club receiving it
- Add a note to both, e.g. “Transfer to City club”
To see stock for all clubs together, select All Clubs in Stock > View Stock, or run the Inventory Stock Level report.
Note - The low stock email compares each product’s minimum with its stock at all your clubs combined.
How do I record suppliers, deliveries and what we paid for stock?
Add your suppliers, link them to products, then enter each delivery.
Add a supplier - Navigate to; Settings > Products > Suppliers and select Add Supplier. You can enter a Website, Email Address, Account and Notes.
Link products - On each product, select the Supplier and enter the Supplier’s Product Code and Cost Price.
Enter a delivery
- Navigate to; Stock > Input Stock Delivery > Add New Product Purchase
- Enter the Purchased at date, Purchased for Club, Invoice No, Supplier, Delivered At and Shipping
- Filter by Supplier to list only that supplier’s products
- Enter the quantity received for each product
- Save
GymMaster doesn’t create or send purchase orders. The weekly low stock email works well as a reorder list, because it groups products by supplier.
Can we scan barcodes at the POS?
Yes. Add each product’s barcode, then scan it at the Point of Sale.
- Navigate to; Settings > Products and edit the product
- Enter the Barcode under Advanced. Select + to add more than one
- Save
At the Point of Sale, scan the item into Search product by name or scan bar code. You can also scan a barcode in Stock > View Stock to find that product.
How does stock work for cases, multipacks and different sizes?
Each product has its own stock count. Two products can’t share one count.
Buy by the case, sell single items - Enter deliveries in single items. For example, two cases of 12 is a quantity of 24. Set the Cost Price for one item.
One sale uses several items - Use Stock to Deduct per Purchase. Each sale then takes that many from stock. The price doesn’t change. You set it when you add the product, after you tick Track Stock. To change it on an existing product, contact our Support Team.
Sizes and colours - Use product variations. Navigate to; Settings > Advanced Configuration and tick Allow product variants. Each variant, such as Small Red, is its own product with its own price and stock. The Point of Sale shows one product, then staff choose the variant. See Product Variations.
Can GymMaster track expiry dates on products?
No. Products don’t have an expiry date or batch number, and GymMaster can’t warn you before stock expires.
To manage stock that expires:
- Check use-by dates when you do a stocktake
- Remove expired items with Manually Adjust, and note “Expired”
- Use the Delivered At date on your stock deliveries to see when each batch arrived
How do I add lots of products and their stock at once?
There’s no self-serve import for products. If you’re moving to GymMaster, contact our Support Team. We can import your products from a spreadsheet, with their categories, sale prices, cost prices, suppliers, sizes and opening stock.
To add products yourself:
- Navigate to; Settings > Products and add the first product
- Select Save and Add New to go straight to the next one, or Duplicate to copy a similar product
- When all your products are added, enter all your starting quantities in one stocktake. Navigate to; Stock > Stocktake > Add Stocktake
A stocktake sets each product’s count exactly. Use Input Stock Delivery for stock that arrives after that.
Terminology
Input Stock Delivery
- The Stock page where you record stock received from a supplier, with the club, invoice number, supplier, delivery date, shipping and quantities. Each delivery adds to that club’s stock
- See Update Stock Levels
Manually Adjust
- A button on a product’s Stock Movements page that adds stock to, or removes stock from, one club, with a note. Use it for damaged or expired stock, or to move stock between clubs
- It changes the quantity only, with no dollar amount
Stock Movements
- A list of every change to one product’s stock: sales, refunds, deliveries, manual adjustments and stocktake differences, each marked Increased or Decreased
- Open it from the product in Settings > Products
Stock to Deduct per Purchase
- A product setting that takes more than one item from stock for each sale, without changing the price
Stock Value
- A product’s stock level multiplied by its current Cost Price, shown including and excluding tax in Stock > View Stock
Stocktake
- A count of the products on your shelves, entered in Stock > Stocktake. The Counted figure becomes the new stock level, and you can give a Reason for any difference
- See Stocktake
Track Stock
- A product setting that turns on stock levels, stocktakes, low stock emails and the online sold-out limit for that product