If you kept your sales team's numbers in a Google Sheet, go to Sales team, press Import from sheet, and either upload the whole downloaded file or paste one month. Each page's days come into the Sales team screen.
Where to find it
Admin › ERP › Sales Department › Sales team › Import from sheet. Only the owner and people with Sales team: every page see the button.
The layout the sheet needs
- One header row with a cell for each page, written as number, slash, person, dash, page code: 1/ Shapla-RF, 2/ Mitu-RFK.
- Under each page, three columns: messages, orders, taka.
- The first column holds the dates, one row per day.
- Total rows and repeated header rows are skipped by themselves. A page with all three cells empty on a day is left out for that day.
Step by step
- Go to Admin › ERP › Sales Department › Sales team and press Import from sheet.
- Option 1, the whole file: in Google Sheets press File › Download › Microsoft Excel (.xlsx), then choose that file. Every tab (month) is read at once. A .csv file works too.
- Option 2, one month: in the month's tab click the top-left corner to select everything, copy, and paste into the box.
- Tick Replace days that are already in the ERP only if you want the sheet to win over days already entered.
- Press Import. You land on that month in Sales team, with a message like "Imported — 30 new, 0 replaced, 0 already there and kept."
Good to know
- Pages are matched by their code. A code the store does not have yet becomes a new page, named after the person in the header.
- The person on each day is the name in the header, so old days keep who worked them.
- Dates: month/day/year (10/25/2026) and 2026-10-25 are read. If a sheet has a day above 12 in the first place (25/10/2026), the whole sheet is read day-first.
- Without the replace tick, days already in the panel are kept as they are and counted as "already there and kept".
- The file can be up to 10 MB.
Common problems
- "Nothing to import was found." The header row was not copied, or its cells are not written as "1/ Name-CODE". Copy the whole tab including the header.
- Dates landed in the wrong month. The sheet mixes date styles. Make the date column one style and import again. Remove the wrong days in Day by day: click the day's cell and press Remove this day.
- Parcels are not counted for a new page. Open Pages & people, edit the page and press Save once. Saving links its courier parcels.
Related
Still need help?
Ask in our Facebook group — the team and other shop owners answer there.
Ask the community →