On this page
In short
- Export products with variants, barcodes, costs and counts, not only names and prices.
- Move customers with purchase history, gift card and store credit balances.
- Switch in a quiet week, not November or December.
- Run a full test sale of each kind before you cut over.
Why beauty stores put off switching
The old system is slow, the monthly fee keeps creeping up or the reports do not show what you need, but you keep it. The reason is usually fear of the catalog. A beauty store may have 2,000 items across a few hundred products and a dozen brands, with shades, sizes and minis. Rebuilding that by hand sounds like a month of evenings.
It does not have to be. Most of the work is an export and an import, followed by a check. The risk sits in a few specific places: shade variants that collapse into one line, barcodes that get dropped, gift card and store credit balances that vanish, and customer history that does not come across. If you know those four, you can check them one by one. Our general guide on switching POS systems without losing data covers the basics. This page covers the beauty details.
What to export and check in the catalog
Ask your old system for a full product export in a spreadsheet. A useful export has these columns for every variant: product name, brand, shade or size, SKU, barcode, price, cost, current count, supplier and category. If the export has only the product name and price, ask for more or pull the rest from your distributor invoices.
Look at the file before you import it. Shade names should appear as separate rows, not as text inside one product. Barcodes should be complete numbers, and watch out for a spreadsheet program that turns long barcodes into scientific notation and ruins them. Costs matter more than owners expect, because margin reports are only as good as the cost on each item. See SKU and variant.
Do a small cleanup pass while the data sits in a spreadsheet, because it is far easier to fix there than inside a register. Delete discontinued products that have no stock and no sales in two years. Merge duplicates, such as the same lipstick entered once as "Rouge Red" and once as "Red, Rouge". Give every active item a category you will actually report on, such as skincare, color, fragrance, hair and tools, so best-seller and margin reports mean something from the first day.
Gift sets and bundles are the usual trouble. Check how your old system recorded them, and decide whether the new one will sell them as one item or as a group of singles.
Customers, gift cards and store credit
Your regulars are your business. Export customer names, phone numbers, emails, purchase history and notes, such as skin type, favorite shade or allergy. A customer who has bought the same foundation six times should not be a stranger on day one. See client profile.
Take a few minutes to ask staff what they use the old notes field for. In beauty, it often holds the real value: a shade the client wears, an ingredient to avoid, a birthday. If the old system cannot export notes, copy the notes for your top 100 customers by hand. That small effort is what makes the first visit on the new system feel personal.
Then gift cards and store credit. Every outstanding balance is a promise to a customer, and also a liability on your books. Export every card number with its balance and every customer credit, and compare the total with the amount your old system reports as outstanding. If the totals differ by even a few dollars, find out why before you switch. The same goes for deposits on special orders: they should land on the customer's balance in the new system. See gift card.
Example: a one-store cutover
This is an example. A cosmetics shop has 540 products that expand into 2,310 variants, 1,900 customers, $4,180 in outstanding gift cards across 62 cards, and $715 in customer store credit.
On Monday, the owner exports the catalog and finds 2,310 rows. She imports into the new system and counts again: 2,310 variants, matching. A spot check of 25 random shades finds two with a wrong barcode, caused by the scientific notation problem. She fixes the two and re-imports the column. Gift cards: the import shows 62 cards and $4,180.00, matching the old report. Credit: 38 customers, $715.00. All match.
On Tuesday, after close, she does a full count of the 200 fastest sellers, so the opening stock is right. On Wednesday morning she runs one sale of each type: cash, card, split payment, gift card redemption and a return. Everything works. On Thursday she opens with the new system and keeps the old one read-only for 30 days in case she needs to look something up. The whole move cost her about 5 hours of checking, and zero days of closed doors.
Mistakes beauty stores make when switching
- Importing only name and price, then retyping shade names by hand.
- Switching in the holiday rush, when there is no time to fix problems.
- Forgetting that gift card and store credit balances are owed to customers.
- Cancelling the old system before the first month of reports is checked against it.
- Not training staff, so the first Saturday on the new register is slow and stressful.
A step-by-step plan
- Pick a quiet week: late January to April, or late summer, not the weeks before Mother's Day or the holidays.
- Export products, customers, gift cards, credits and the last 12 months of sales.
- Clean the catalog: fix shade names, barcodes and costs in the spreadsheet.
- Import, then compare counts of variants, customers and balance totals to the old system.
- Test five sales: cash, card, split, gift card and return.
- Train the team on practice sales before opening day.
- Open, keep the old system for reference, and compare the first week's totals.
If you also plan an online shop, set it up after the in-store cutover so you only learn one thing at a time. See selling online from a beauty store, and beauty store inventory for keeping the count right afterward.
How MazalPOS handles switching POS for beauty and cosmetics stores
MazalPOS offers a free data move from your old POS, and setup takes one day. You can try it with a 14-day trial with no card. The register runs on iPad and any web browser, keeps selling if the internet drops, and has a practice mode so new hires can learn before they serve a customer. Products with sizes and colors come across as variants, and customer profiles keep purchase history, balance and notes.
Common questions
The data move can happen in a day or two, but plan a few more days for checking counts, balances and test sales. Choose a slow week and keep the old system available for reference.
Not if each shade is its own row with a SKU and barcode in your export. Check a sample of shades after import to make sure none merged into a single line.
Export every card number and balance, import them, and compare the total with your old system's outstanding report. Do not close the old system until the totals match.
A quiet stretch, often late January through April or late summer. Avoid the weeks before Mother's Day, Valentine's Day and the holidays.
Yes. MazalPOS offers a free data move from your old POS, and setup takes one day. You can also start with a 14-day trial with no card.
Words on this page
VariantSKUGift cardClient profile
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.
