GuideApp tutorials
Class 13: from any stock app to Wasoolo bulk stock importer
Class 13 of the Wasoolo course: bring your whole product list over from any other app in one file, with rates, stock and folders, in two ways.
What Class 13 covers, in order
- 1Open the importerProducts tab, the menu at the top right, then Import products.
- 2Pick your way inFill our sample sheet yourself, or let any AI build the file from your old app's list.
- 3Upload the fileBoth ways end at the same button — a file is the only thing this page takes.
- 4Read the previewThe count, the first five rows, the folders that will be made, and every warning in red.
- 5ImportNew products land on the shelf; anything you already have is skipped, not changed.
Your products are already written down somewhere: another app, a spreadsheet, a printed list from the wholesaler. You do not have to type them in again. Wasoolo's importer takes one file and puts the whole catalogue on your shelf, with rates, stock and folders. Class 13 does it end to end, both ways.
Where the importer lives
Open the Products tab, tap the ⋮ menu at the top right, and choose Import products.
Two things decide whether that row is there. You have to be in the main products view, not inside a folder, and your seat needs both the import key and the add-product key. An employee without them sees the page but not the button, and the page says so in one line instead of failing quietly.

Two ways in, and both end at the same button
The page holds two cards and nothing else. 1. Our sample file is the spreadsheet way. 2. Any AI makes the file is for the list you already have somewhere else.
They are not two different machines. Both end at the same Upload the file button, because a file is the only thing this page takes. There is no box to paste a table into, and that is deliberate: a table pasted into a chat window cannot carry your stock counts reliably, and a file can.
Under both cards sits the line that protects your shelf: A product you already have is skipped, not changed.

What Class 13 covers, in order
- 1Open the importerProducts tab, the menu at the top right, then Import products.
- 2Pick your way inFill our sample sheet yourself, or let any AI build the file from your old app's list.
- 3Upload the fileBoth ways end at the same button — a file is the only thing this page takes.
- 4Read the previewThe count, the first five rows, the folders that will be made, and every warning in red.
- 5ImportNew products land on the shelf; anything you already have is skipped, not changed.
Way 1: fill our sample file
Tap Download and a small CSV lands in your phone or computer. Open it in Excel, Google Sheets or any sheet app, fill your goods in under the headings, save, and come back to Upload the file.
The headings are plain words: name, price, buy_rate, unit, folder, opening_stock, barcode, product_no, low_stock_alert, pack_unit, pack_size, description, showcase.
Only name is compulsory. price is what you sell it for, buy_rate is what it cost you, and opening_stock is how many are on the shelf right now. Any heading Wasoolo does not know is kept as an extra field on the product instead of being thrown away, so an old app's "Company" or "Rack" column survives the move.
Way 2: let any AI build the file
This is the way most shopkeepers will use, because the list is already sitting in the old app.
Tap Copy, open any AI chat, paste the prompt, and attach the product file you exported from your old app. The assistant reads your file, arranges it under Wasoolo's headings, and hands back a file you can download. Then tap Upload the file and pick it.
The prompt itself is written in English on purpose, because the assistant reads it and you do not. It asks twice for a file you can download, so you do not end up with a table printed inside the chat that nothing can upload. Share sends the same prompt to WhatsApp or email if you would rather do this part on a computer.
Groups become folders
The folder column is the one that decides how your shelf looks afterwards, and Wasoolo is generous about what it is called: category, group, product_group, department and section all count, and the first one your file carries wins.
Write Grocery > Tea and you get a folder inside a folder. The arrow makes the nest, and any level that does not exist yet is created for you. A plain Grocery makes one folder. A slash is not a nest: Oil / Ghee is read as one folder with that whole name. A blank cell is allowed and simply means the product lands loose on the shelf, where you can move it later, exactly as in Class 11.
Check the preview before you tap Import
The moment your file is read, the page shows what will land. The count at the top, the first five products with their price, buy rate and stock, and under each name, the folder it is going into.
Below the table are the lines that catch a bad file before it touches your catalogue: how many folders came out and which heading they came from, how many of those folders will be made now, how many products carry no folder at all, and, in red, how many rows have a buy rate of zero. That last one matters, because zero does not mean "I forgot". Zero means the goods were free, and free goods count as pure profit. If you do not know what something cost you, leave the cell empty.
If the file came from a chat, one more line may appear: N lines were not read. That is the assistant's own closing sentence sitting inside the file, and it tells you the difference between "it read all 300 rows" and "it stopped at row 12".

What Import actually writes
Tap Import products and the page answers with two numbers: how many landed, and how many were skipped because you already had them.

Nothing is overwritten. If a product with that name is already in your shop, the row is skipped and your existing rate, stock and photo stay exactly as they were. That is what makes it safe to upload the same file twice when you are not sure the first one worked.
Go back to the Products tab and the shelf has grown: the item count at the top, the new folders in their own section, and every product ready to be picked on a bill or a stock-in.

Say your old app holds 300 products
Example numbers, not a claim about any shop. Put your own count in: 40 seconds a product is a fair pace once you include walking back to check a rate.
Start your digital khata today
Free to start. Works offline. English, Roman Urdu & Hinglish. Your customers get their app free, forever.
The one thing worth checking afterwards
Open two or three products and look at the buy rate. It is the number your real profit is built on, and it is the one an old app is most likely to have exported badly — as a selling rate, as a rate with tax already inside it, or as nothing at all.
Everything else on a product can be fixed in five seconds later. A wrong buy rate quietly makes every sale of that item look better than it was.
Common questions
My old app gives me an Excel file, not a CSV. Will it work?
Yes. The picker takes .csv and .xlsx, so an Excel file can be uploaded as it is. If your file is something else, open it in Excel and use Save as → CSV.
What happens if I upload the same file twice?
The second one imports nothing new. A product you already have is skipped, not changed, so nothing doubles and no rate gets overwritten.
How many products can I bring in at once?
As many as your plan holds. The free plan keeps 10 products, Pro Lite 100, and Pro is built for a whole catalogue. The import fills the room your plan has and stops there.
Can I bring my customers over the same way?
Not from this page — it is products only. Customers and guarantors have their own lanes on the shared import page: More → Import customers.
My products all landed with no folder. What went wrong?
Your file had no column Wasoolo recognised as a group. The preview says this in red before you import, so add a folder or category column and upload it again — the products already in will keep their place, and only the missing ones come in.
The stock numbers in my old app are out of date. Should I still import them?
Import the list without opening_stock and count the shelf yourself afterwards. A product with no stock number comes in at zero, which is honest, and a real count is worth more than a copied one.