New owners. Messy item records. One clean starting point.
When a Portland electrical supply shop changed hands and moved to a new system, Apex counted the whole building, rebuilt the item database, and handed the new team a clean file they could trust.
155,279
Manufacturer and distributor parts in the pre-count reference library
4,071
Clean items delivered — zero duplicates, zero blanks
26,127
Units counted across 8 rooms in 2 days
212
Obsolete items identified to purge (Step 1 of 5S: Sort)
The Situation
Conrey Electric is a Portland electrical supply and motor shop that has served the Pacific Northwest since 1945. Under new ownership, the business was moving off Lightspeed and into QuickBooks (Intuit Enterprise Suite). The problem was simple to describe and hard to fix: the item records they inherited weren’t trustworthy.
The Challenge
The records they inherited had duplicate item names, blank descriptions, and spreadsheet exports where part numbers had been silently converted into dates and barcodes into scientific notation. Loading that file into the new system would have carried every problem forward. The new owners needed one clean item list — accurate, deduped, and ready to import — and they needed it before the switch.
What Apex Did
- Built a 155,279-part reference library before anyone stepped on site. Apex pulled price lists from 10+ manufacturers and distributors Conrey buys from and loaded them into a lookup the count app could read. That meant a counter could scan a barcode or type a part number and get a match in a second — not guess.
- Counted every room, section by section, in two days. 6–7 counters with Bluetooth scanners worked a custom phone app Apex built for the job. Offline-first: if the signal dropped in a back warehouse, scans saved on the phone and synced the moment it came back. Eight rooms — shop areas, warehouses, rolling racks, sales floor, control rooms — all covered October 9–10, 2026.
- Captured the unknowns the right way. When counters hit an item that wasn’t in any catalog, the app walked them through two photos (part-number close-up and whole product) and read the tag into the record. Conrey’s own managers reviewed each of those items on a live review page and approved or flagged them — so the client, not the auditor, had the final say on anything new.
- Cleaned up the item file. Apex fixed the Excel-mangled part numbers and barcodes, resolved 94 duplicate item names, and more than doubled the number of items that had a real description — from about 1,900 to about 4,300.
- Consulted on a starting point for 5S. Apex didn’t run a 5S program for Conrey, but the purge list lines up with Sort — the first of the five steps. 212 obsolete items (about 1,200 units) were identified; Conrey’s own team tagged 196 of them during review. Apex delivered the purge list as photo pages in walking order so staff could clear them off the shelves without hunting.
The Result
A clean, QuickBooks-ready item file. 4,071 items. 26,127 units. Zero duplicate names. Zero blank names. Delivered with a full item list and a purge list the team could act on.
The new owners now have records they can trust, ready to load into the new system.
“The work that Apex did really helped guide our teams to rebuild the database on the products we carry, and sort through all of the products that are no longer in the database.”
— Operations Director & Sales Director, Conrey Electric
Download the one-page PDF
A single-page summary of the Conrey Electric engagement, built for sharing.
Is this you? New-owner signals
You probably need this if you just bought (or are about to close on) a business and any of the following are true:
- The current item list has duplicates, blanks, or names only the old owner understood.
- You’re switching POS or ERP systems and the export file looks wrong when you open it.
- Nobody has done a real wall-to-wall count in years.
- Your lender or accountant needs a clean opening inventory number.
- Staff can find things on the shelf but not in the system.
FAQ
What is an inventory baseline after a business is acquired?
It’s a one-time, wall-to-wall physical count done right after the sale closes, paired with a cleaned item database. It gives the new owner trustworthy opening numbers and a clean file to load into their new system.
Can Apex count inventory while we’re switching from Lightspeed to QuickBooks?
Yes. Apex counts the physical goods, cleans the item records, and delivers a QuickBooks-ready import file. Conrey Electric used Apex for exactly this — Lightspeed out, Intuit Enterprise Suite in.
What if a lot of our items aren’t in any catalog?
Apex’s phone count app lets counters capture unknown items with two photos and the printed tag information on the spot. Your managers then approve or flag each one on a live review page, so your team decides what enters the new item list.
How long does a count like this take?
Conrey Electric was counted in two days across eight rooms with a crew of 6–7. Timing depends on square footage, how many SKUs you carry, and how clean the starting records are.
Do you help us clean up the old product list, or just count what’s there?
Both. For Conrey, Apex resolved 94 duplicate item names, fixed part numbers and barcodes that spreadsheets had mangled, and more than doubled the items with a real description (about 1,900 to about 4,300).
Can you help us get rid of dead stock?
Yes. The count naturally brings dead stock to the surface, and Apex can consult on how to begin 5S in your warehouse. For Conrey, Apex identified 212 items to purge and delivered the list as photo pages in walking order so staff could pull them without hunting. That lines up with Sort, the first step of 5S.
Just bought a business? Start with records you can trust.
Apex counts, cleans, and hands you one clean item list — ready for whatever system you’re moving into.
Get a Free Quote →