How to import shops, products and old dues from Excel

Steps

1. 1

   Step 1: In the menu, click Import Data.

2. 2

   Step 2: Import in this order: shops, products, suppliers, purchase bills, old bills, and old dues.

3. 3

   Step 3: Click the kind of data, for example Shops and customers.

4. 4

   Step 4: No file yet? Click Download a blank template, fill it in Excel and come back.

5. 5

   Step 5: Click Choose file and pick your Excel or CSV file. Mulberry tells you how many rows it found.

6. 6

   Step 6: Check the column matching: shop name to shop name, phone to phone. If a column is wrong, click it and pick the right one.

7. 7

   Step 7: Click Check this file. Nothing is saved yet: it shows how many records are new, how many will be updated, and any mistakes.

8. 8

   Step 8: If it looks right, click Import.

9. 9

   Step 9: Do the same for products, suppliers, bills and old dues, or use Import everything at once to drop all files together.