Jewelry stores · Switching POS

Switching POS systems at a jewelry store without losing data

A jewelry POS holds more than prices. It holds twenty years of client anniversaries, open custom orders and costs per piece. Moving it takes a plan, not a weekend scramble.

By Mike Akop, founderUpdated 6 min read

On this page
  1. Why jewelers put off switching
  2. What data a jewelry store needs to bring over
  3. Example: a three-week move for a store with 1,800 pieces
  4. Mistakes that hurt during a POS switch
  5. A step-by-step switch plan
  6. What to expect after you switch
  7. How MazalPOS handles switching for jewelry stores
  8. Common questions

In short

  • List what must move: products with cost, customers with notes, open balances and open repairs.
  • Pick a go-live date in a quiet week, never the week before Valentine's Day, Mother's Day or Christmas.
  • Run the old and new systems side by side for a short time and compare totals.
  • Count the high-value cases against the new system on day one.

Why jewelers put off switching

Most jewelers who want to switch have been putting it off for years. The reasons are good ones. The old system knows every ring size the store ever sold. It holds the note that a customer's wife likes white gold, not yellow. It has the cost on 1,800 pieces, entered by hand. A mistake in a move could lose all of it.

The other reason is timing. Jewelry sells in bursts. A store may do a large share of its year between Thanksgiving and Christmas, and again around Valentine's Day. Nobody wants a new register on December 10.

Yet staying has costs: older systems that crash, no way to sell online from the same stock, reports that need a day to assemble, and fees that crept up. A planned move, done in a quiet stretch, solves those problems without putting a sale at risk.

One more worry deserves a direct answer: what happens if the internet drops on the day of the switch. A register that keeps selling offline and syncs later removes most of that fear, so ask any new vendor to show you how it behaves with the network unplugged before you sign. Do that test at your own counter, with your own router, during the trial rather than on the first busy Saturday.

What data a jewelry store needs to bring over

Start with a list. In a jewelry store it usually looks like this:

  • Products. Names, SKUs, retail price, cost, category, supplier, ring sizes as variants, and current quantities. Cost matters most: without it, margin reports go blank.
  • Customers. Names, phone numbers, emails, addresses, purchase history, and notes such as ring size, metal preference, anniversary and birthday dates.
  • Open balances. Deposits on custom orders, partly paid layaways and store credit or gift cards outstanding.
  • Open repairs. Customer-owned pieces in the shop: who, what, promised date, quoted price, amount paid.
  • Sales history. Past sales for reports and for returns of items bought last year.

Export each as a spreadsheet from the old system. Ask the old vendor now for a full export, in writing, and ask how long it takes. Some vendors drag their feet because they would rather you stay.

Example: a three-week move for a store with 1,800 pieces

This is an example with made-up numbers. A store has 1,800 products, 3,400 customers, 14 open custom orders with $18,600 in deposits, and 22 repairs in the safe. It plans a switch in the second week of March, after Valentine's Day, and before Mother's Day.

  • Week 1: export everything. Clean the data: merge duplicate customers (it is common to find 200 or more), fix product names, and check costs on the top 100 sellers.
  • Week 2: import into the new system. Spot check 50 products and 50 customers against the old records. Confirm the 14 custom orders' deposits total $18,600 on the new customer accounts. Train staff on practice sales.
  • Week 3: go live on a Tuesday. Keep the old system open for reference only. At close, compare the day's sales total in both. Count the diamond case and the watch case against the new system.

The deposit check alone is worth the effort. If the totals differ by even $500, find out why before a customer comes in for pickup and is told they owe the full price again.

Mistakes that hurt during a POS switch

  • Switching in the holiday season. A bad week in March is annoying. A bad week in December costs real money.
  • Importing without cleaning. Duplicate customers and misspelled products come along and keep causing trouble.
  • Forgetting open deposits and repairs. These are promises to customers, and they must carry over with the amounts.
  • Losing the notes. A customer note stored in a custom field the new system cannot read is often dropped. Ask where notes will land before you export.
  • Dropping the old system too soon. Keep access, or a full export, for at least a year for returns and for tax and audit questions.
  • Skipping staff practice. A new associate at the counter with a $4,000 ring and an unfamiliar screen is a bad moment for a first try.

A step-by-step switch plan

  1. Pick a go-live date at least five weeks from any major gifting holiday.
  2. Ask your current vendor for complete exports of products, customers, balances and sales history. Keep a copy somewhere safe.
  3. Clean the data: merge duplicates, fix names, and make sure cost is filled in for every piece over $200.
  4. Import, then check a sample by hand. Verify total stock value and total deposit balances against the old system.
  5. Set up payment methods, tax rate and receipts, then run practice sales with each associate, including a financed sale and a split payment.
  6. Go live. On the first day, compare totals against the old system and run a stock count of your highest-value case.
  7. At the end of the first week, review the end-of-day reports for any gaps.

What to expect after you switch

Expect a few small surprises. A product's category may be wrong, a customer's phone number may be missing, a tax setting may need a tweak. Fix them as they appear and keep a short list. The first month's reports are also a chance to see your store with new eyes: your real margins by category, which associates sell the most, and how slowly some pieces move.

Once the move settles, revisit the areas that were hard under the old system, such as commissions, inventory counts and financing, and change your routines to use what the new tool does better. Also take a look at what you pay: compare your new processing fees with the old ones on a sample month.

Tell your best clients about the change too. A short note at the counter or a text saying the store has a new receipt format avoids confusion, and it reminds them you are still the same shop with the same people behind it.

How MazalPOS handles switching for jewelry stores

MazalPOS moves your data from the old POS in a free data move, and setup takes one day. You can run a 14-day trial with no card before you commit. The register works on an iPad and in any web browser, and keeps selling if the internet drops, then syncs every sale when it is back. Practice mode lets new hires learn on mock sales. Customer profiles carry purchase history, balance and notes, and tax rate is set per location.

Common questions

Plan on about three weeks from export to go-live for a store with a couple thousand pieces: one to clean the data, one to import and test, one to go live. Setup itself can be done in a day.

In a quiet stretch, at least a month before a big gifting season. Right after Valentine's Day or in late spring or early fall are common choices.

Not if you plan for it. Ask the new vendor where notes will land, and check a sample after import.

They must move with the amounts paid. Check the total of deposits against the old system before go-live.

Yes. The data move from your old POS is a free data move, setup is done in one day, and there is a 14-day trial with no card.

Words on this page

SKUStock countEnd-of-day reportProcessing fee

Want the full guide? Read How to Switch POS Systems Without Losing Your Data.

Written by Mike Akop, founder of MazalPOS. We build and support the register, online store and staff app that stores from Las Vegas to Honolulu run on. Questions about this guide? Talk to a real person.

Not sure where to start?

Talk to a real
person today.

Tell us how your store works and we will show you MazalPOS with your own products.

14 days free. No card. Cancel anytime.