The POS Software Blog

The POS Software Blog

News from Tower Systems about locally made POS software for specialty local retailers.

Tagsmall business tips

Retailers: Stop complaining about your data and fix it

R

Most retailers won’t read this. They’d rather not work on their data, probably because they’ve never seen what good business data can do for them. They have no idea what they’re missing.

Those retailers are easy to compete with.

Small business retailers get stuck in their heads about bad data. They decide it’s so bad that they spend months, sometimes years, talking about it and worrying about it. They don’t take a single step to fix it. Being time poor becomes the excuse, and complaining becomes the only action.

We hear it all the time. Product names nobody understands. Departments that made sense ten years ago. Suppliers who stopped trading years ago still sitting in the system. Stock levels nobody trusts, so nobody uses the reports. Then the business makes buying decisions on gut feel, because the numbers “can’t be right”.

In almost every business we’ve seen and worked with, the fix is a two-day job for two people. It needs clear, firm management behind it.

Throw it out and start again

The best way to fix bad data is to throw it out and build it again.

Most retailers try to clean their data one product at a time, in between serving customers. It never ends. A fresh, firm reset works far better than a slow tidy-up that drags on for a year.

What the two days look like

Step one: do the stocktake.

Count everything. Not a sample, not just the big categories. Everything. By the end of the day, the stock levels in your system should match what’s on your shelves and in your stockroom.

Step two: clear out what’s at zero.

Run a report of every item with zero stock on hand. Then ask one question: has it sold in the last six months?

  • If it hasn’t, delete it. Don’t mark it inactive or hide it. Remove it. You don’t stock it, you haven’t sold it, and keeping it only clutters every report you run.
  • If it has, keep it, and decide whether you’ll reorder it.

Next:

  • Remove suppliers you no longer buy from.
  • Rebuild your departments around how you trade today.
  • Check cost prices on your top sellers against recent invoices.
  • Write down three or four rules for adding new products, so the mess doesn’t come back.

Two people works best. One makes the decisions, the other does the data entry. Don’t let anyone talk you into keeping something “just in case”.

A reset for the business, not just the data

Throwing out old data does more than clean up your system. It resets the business.

Once the data is clean, you’re looking at the shop as it really is today. You can see what you actually stock, what actually sells and where your money actually sits. That’s a new foundation, and you can build on it.

Reports you stopped trusting become useful again. Reordering works. You can spot the lines that make money and the ones that only take up space. Clean data gives you commercially valuable insights that you can’t get while old data clouds every number.

Keep it clean

The data didn’t get bad on its own. It got bad because nobody owned it. After the reset, give one person responsibility for keeping it right. Check it monthly. If new products go in without following the rules, say so.

Our advice

Too many retailers spend too much time worrying. Worrying does nothing for you or your business. In fact, it makes things worse.

Complaining achieves nothing. Doing something does.

And if you’re a supplier to retailers who hears the same complaints over and over, what are you doing to turn those complaints into action?

If you’re a Tower customer and want help planning a reset, this is the advice we provide.

If you’re not with Tower and your current system makes this hard, we’d love to show you how Tower handles it. Call 1300 662 957 or email sales@towersystems.com.au.

Is your shop haunted?

I

Halloween has crept up on Australian retail. When we started out, 31 October was just another day. Now there are costumes in the shops, plastic skeletons in the garden centre and kids at the door expecting lollies.

The things that actually scare us in a shop don’t wear costumes, though. They hide in the stockroom and the supplier invoices, and some of them have been there for years.

Ghost stock

The system says you have four. The shelf says none. Nobody sold them, or at least nobody rang them up.

Ghost stock is sneaky because your POS won’t reorder something it thinks you still have. So the gap stays on the shelf, and a customer asks for it on a busy Saturday. Count your fast sellers every few weeks rather than waiting for the annual stocktake to give you a fright.

Zombie stock

Every shop has a few lines that won’t die. They’ve been on the shelf so long they’ve faded. You walk past them every day and stop seeing them.

Run a report of anything that hasn’t sold in 90 days. It’s rarely pleasant reading. Discount it, bundle it with something that sells, or send it back if the supplier will take it. That space and that cash are worth more doing something else.

Vampire costs

This one drains you slowly. A supplier puts a line up by 40 cents, then another goes up by a dollar. Nobody tells you, and the new price sits quietly on the invoice.

I’ve seen retailers absorb increases for six months without noticing. Check invoices against your cost prices when stock comes in, and adjust the sell price that day while you’re thinking about it.

The haunted till

The drawer opens and there’s no sale. A refund appears with no receipt. Usually there’s a boring explanation. Every so often there isn’t.

Your void, refund and no-sale reports will tell you who, when and how often. You don’t need to be suspicious of your team. You just need to look now and then.

The witching hour

It’s 6.15pm. The door is locked, your feet hurt, and you still need to balance the day. If that takes an hour with a calculator and a shoebox of dockets, your system is letting you down. It should take ten minutes.

Skeleton staff

Three people on a dead Tuesday morning and two on a flat-out Saturday afternoon. Most rosters are built on habit. Pull your sales by hour and day and roster to what the data shows, not to what you’ve always done.

While you’re at it, sell some Halloween stock

Halloween is now a real trading event for gift shops, newsagents, toy shops and garden centres. Put Halloween lines at the front of the shop for the last week of October, and put lollies at the counter. On 1 November, mark down whatever is left and clear it. Packing it away for next year just creates next year’s zombie stock.

Then look at what sold, so next year’s order is better than a guess.

If any of these sound familiar, we can show you how Tower’s reports bring us out of hiding. Call 1300 662 957 or email sales@towersystems.com.au.

The POS Software Blog

Categories

Categories

Categories

Recent Comments

Monthly Archives