Start with products, because everything reads from them
Styles with their size and colour variants, HSN codes, costing and images are the base layer. Get them right and inventory, orders and catalogues all inherit correct structure. Get them wrong and every later module repeats the mistake.
- Clean the style and variant list before importing any quantity
- Then open stock by size, colour and lot
- Then suppliers, materials and open purchase orders
- Then live sales orders and outstanding balances
Run one order end to end before switching over
Take a single real order through enquiry, availability, materials, dispatch and invoice. It exposes the gaps in your own data faster than any checklist and gives the team a reference they trust.
Retire the sheet only when it stops being consulted
Keep the old sheet read-only for a few weeks. When nobody opens it to check a number, the migration is genuinely complete — not when the import finished.
Takeaway
Sequence the move: products, stock, purchasing, orders. One real order proves the system better than any demo.