How to Export Your Marg ERP Stock to Nesayo in Under 5 Minutes

If you are running a retail pharmacy on Marg ERP and want to move to a cloud platform like Nesayo, the single biggest question is: will my stock data come across cleanly? This guide walks through the end-to-end export and import in under 5 minutes, with the exact column names Marg uses and what to check after import.

Step 1 — Export stock from Marg ERP

1. Open Marg ERP on your billing counter PC.
2. Go to Reports → Inventory Reports → Current Stock (Batchwise).
3. Choose Export to Excel (some Marg versions label this as "Send to Excel").
4. Save the file to a pen drive or email it to yourself.

The exported file typically has these column headers, in this order:

• Item Name — the medicine name
• Batch No — batch / lot number
• Expiry — usually in MM/YY format (for example 05/27)
• Qty — current stock quantity
• MRP — max retail price
• Purchase Rate — cost per pack
• HSN — HSN code (usually 3004)
• GST — GST percentage (5 for medicines)

Step 2 — Import to Nesayo

1. Log in at your pharmacy URL on Nesayo.
2. Go to Inventory → Import Stock.
3. Upload the Excel or CSV file from Step 1.
4. Nesayo auto-detects the column mapping. You will see a preview with the first 100 rows.
5. Verify that the preview shows:

- Medicine names match the originals (no truncation)

- Expiry dates are converted to YYYY-MM-DD format (this means 05/27 becomes 2027-05-28)

- Quantities and MRPs match what Marg showed

1. Click Confirm Import.

For pharmacies with more than 100 unique medicines, Nesayo currently imports 100 rows per upload. This is a safeguard against corrupted spreadsheets; you can run the import multiple times to cover your full stock.

Step 3 — Verify the import

Before you start billing from Nesayo, run these three checks:

1. Open the billing page and search for 3 medicines you sell daily. Each should show the batch, expiry, and MRP correctly.
2. Go to Dashboard → Money at Risk and confirm that medicines with expiry dates in the next 30 or 60 days are flagged.
3. Run the Expiry Guard agent manually. It should produce alerts matching what you already track manually.

If any of these three checks fail, contact support before making any bill in Nesayo, and keep using Marg in parallel until the issue is resolved.

Common issues and fixes

• Expiry dates show as text instead of dates. Your Marg export left the expiry as text. Nesayo parses MM/YY, MMM-YY, DD.MM.YYYY, and ISO formats — but if the format is something unusual like MAY2027, open the Excel file in Excel, reformat the column as MM/YY, and re-export.
• Batch numbers missing. Some Marg exports omit the batch column. Without a batch number, Nesayo assigns IMPORT-1, IMPORT-2, etc. You can edit these later by clicking each batch on the inventory page.
• Medicine names have garbage characters. This is usually an encoding issue. Save the exported file as UTF-8 CSV in Excel (File → Save As → CSV UTF-8). Nesayo will parse it cleanly.

What Nesayo does differently after import

Once your stock is in Nesayo:

• The Morning Briefing agent runs at 8 AM every day and summarises near-expiry batches, low stock, and yesterday's revenue.
• Expiry Guard scans every batch every 6 hours and flags 30-day and 60-day windows for return to distributor.
• Stock Sense tracks sales velocity per medicine and predicts stockouts 7 days in advance.
• Voice billing lets you bill in Hindi or any of 8 regional languages — no typing.

When to stop using Marg

We recommend running both Marg and Nesayo in parallel for one full billing week. Match daily totals at end of day to ensure GST calculations and sales reporting agree. After 7 days of identical results, stop billing in Marg.

If you would like a walk-through demo of the migration on your actual stock file, start your free account on Nesayo and send your exported CSV — we will confirm the parse will work before you import.