The POS Software Blog

The POS Software Blog

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

Tagdata clean-up

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.

Too Much in “General”? How a Cleaner Department Structure Makes Small Business POS Data Work Harder

T

Open your Tower Systems Retailer POS and look at your departments and categories. If you see duplicates, vague names, or a “General” or “Miscellaneous” category holding hundreds of products, you’re not alone.

It happens in almost every business over time. A new supplier arrives and someone creates a category in a hurry. A staff member adds a department that already exists under another name. Products that don’t obviously fit anywhere end up in a catch-all.

None of it seems like a big problem on the day. But after a few years, your data becomes hard to trust and harder to use.

Why it matters

Your department and category structure is the backbone of your reporting. When it’s messy, the reports are messy too.

You can’t see which categories are growing if half the products sit in “General”. You can’t compare gross profit across departments if the same products are split between two of them. And staff waste time hunting for the right place to put a new item.

Clean data makes your business easier to manage. It helps you make better decisions about stock, space and buying, because the numbers reflect how your shop actually trades.

How our service works

Our Department and Category Restructure service is a careful, practical clean-up, tailored to each business. This is a small business focussed service that’s helping retailers achieve a clean dataset.

We start with an AI assisted review of your full product database. From that, we create a proposed department and category structure that suits the way you sell.

We then send you a spreadsheet showing the proposed structure. You review it and either approve it as supplied or tell us what you’d like changed. Nothing is updated in your POS until you’re happy.

Once approved, we rebuild the structure in your Tower Systems Retailer POS. Duplicates are merged. Vague categories are replaced with meaningful ones. Every product ends up in the right place.

What to know before you start

Two things sit outside the service.

If you use an accounting link, you may need to update its setup after the restructure. We’ll guide you through this, but the accounting changes themselves need to be made by you or your accountant.

If you have a website, menu links that point to departments or categories may need updating. We’ll help you identify what needs to change. If you’d like us to make the website menu changes for you, we can quote on that separately.

The result

You end up with clean departments, clear categories and a logical product hierarchy. Your staff find things faster. Your reports make sense. And you have a dataset you can actually use to manage your business.

The Department and Category Restructure is currently $499, down from $999.

Find out more and book at store.towersystems.com.au/products/department-and-category-restructure, or reach out to support.

The POS Software Blog

Categories

Categories

Categories

Recent Comments

Monthly Archives