How to move from a notebook to an inventory app without losing a day's sales
To move from a notebook to an inventory app, list your products, upload them in bulk from a CSV file, count your opening stock, then record every sale in the app while you keep the notebook for one week as a check.
Do not switch on your busiest day
Pick a quiet day. The goal is that on day one, your app shows the same stock as your shelves. Everything after that is just recording sales.
Step 1: List your products
Write each product with its name, cost price, selling price and quantity. If you sell sizes or colours, list each as a variant. If your products are already in Excel or Google Sheets, you are most of the way there.
Step 2: Upload them in bulk
Typing hundreds of products by hand is where most people give up. Invoicer lets you upload products from a CSV file and gives you a template to follow. Save your sheet as `.csv`, upload it, and check the preview before confirming.
Step 3: Count your opening stock
Count the shelves once, carefully. The count you enter now is the base for every figure later. Our stock count guide shows a quick method that works for a small shop.
Step 4: Record debts you are owed
Add customers who owe you, with the amounts, so they are tracked from day one. See how to track customers who owe you money.
Step 5: Run both for a week
Keep the notebook for seven days and compare the end-of-day totals. Differences show you what you forgot to record. After a week with no gaps, retire the notebook.
Frequently asked questions
Can I upload my products from Excel?
Save the sheet as a CSV file and upload it. Invoicer gives you a template so the columns match.
Do I need to enter every product before I start selling?
No. Start with your best sellers and add the rest as you go, but your stock figures are only accurate for products you have counted.
How long does the switch take?
Many shops finish setup in an afternoon: list, upload, count, then start recording sales.