How to Automate Product Setup and Price Updates

There's a task almost no owner sees as a problem until they measure it: setting up products and keeping prices current. The new supplier list comes in, someone enters it into the inventory system, then updates it on the online store, then fixes the list the sales team uses, and if there's time left, updates the catalog sent over WhatsApp. Four versions of the same data, entered by hand, that stop matching the day one of them gets skipped.

The real cost isn't the time, it's the mistakes

Having someone spend two hours entering prices is expensive, but it's the smaller cost. The big cost shows up when a salesperson quotes off the old list and you sell below your margin, or when the online store shows a price that no longer exists and the customer rightfully complains. That's not just losing money on that one sale — you lose credibility, and getting it back costs far more than the time saved by not updating.

Where it usually breaks down

• The supplier sends the list as a PDF or an Excel file with a different format every time.
• Each system wants the data in a different order, so it has to be rearranged.
• Nobody knows for sure which list is the correct one at any given moment.
• Urgent changes get announced over WhatsApp and never get recorded anywhere.
• When the person who handles it goes on vacation, the whole process stops.

Notice that none of these are advanced-technology problems. They're problems of the same data living in several places and being maintained by hand in each one.

If your price list lives in four places, you don't actually have a price list — you have four versions that contradict each other.

The rule that solves most of it

One single place is the source of truth, and everything else reads from it. That means deciding which is your official price source — usually the inventory or point-of-sale system — and making everything else pull from there instead of being entered separately. Once that's settled, updating a price stops being four tasks and becomes one: you change it at the source, and everything else finds out on its own.

What can actually be automated

You can read the supplier's list and convert it to your system's format without typing it in by hand, even when it arrives as a PDF. You can apply your margin rule automatically to calculate the selling price from the cost. You can sync the catalog to the online store and to the sales team's list. And you can keep a record of what changed, when, and why. When the process doesn't fit any off-the-shelf tool because your operation has its own rules, custom software usually costs less than the annual salary that today goes into keeping manual entry running.

Where to start without stopping the operation

You don't have to solve the entire catalog at once. Start with your fastest-moving products, which are usually a small slice of the total but most of the sales. Automate updating those and watch for a week. If prices stop disagreeing between systems and nobody had to enter anything twice, extend it to the rest. The measure is concrete: how many hours a month went into entering prices, and how many quoting errors happened, before and after.

This is one of the least glamorous projects a business can take on, and one of the fastest to pay for itself. It doesn't generate new sales, but it stops you from losing the ones you already have to a badly entered number. And it frees up someone who's currently spending hours doing work no machine should be leaving to a person.