If your price list is already in Excel, a Khata book app or an old system, import it. A kirana shop with two thousand products should not be typing.
Where to go
Restaurants: Menu then Dishes then Import. Grocery and retail: Products then Import. Both accept CSV and Excel files.
Preparing the file
One row per item, one header row at the top. Include at least a name and a price. Add a category so items land in the right place instead of all in one heap, and a barcode if you scan at the counter. Download the sample file from the import screen and match its columns, which is faster than guessing and fixing afterwards.
- One item per row. Do not merge cells, and do not leave a blank row between sections.
- Prices as plain numbers. No "Rs", no commas in the thousands.
- Keep barcodes as text, or Excel will turn a long number into scientific notation and break every scan.
- Delete the decorative title rows a price list usually starts with.
After the upload
The import screen reports what went in and what it could not read. Fix the rejected rows in the spreadsheet and upload only those again, rather than the whole file.
Then check a handful by hand: open three items, confirm the price and the category, and scan one barcode at the counter. Five minutes of checking is cheaper than a week of wrong prices.
Stock levels
Import sets up what you sell. Opening quantities are a separate job, and the honest way to do it is a physical count. See physical stock counts.