Importing Products and Stock from Excel
You already have your product list in Excel. Hundreds of rows, years of work. And now a new application is asking you to retype it one line at a time.
You do not have to. The Excel import moves that list across as it is, provided the columns follow the template.
The principle that saves the most tears: clean in Excel, not after import. Duplicates, number formats, and inconsistent names are far easier to fix in a spreadsheet than to correct one by one after they’ve become master data. And since an import changes a lot of data at once — back up first, always.
Before you start
- The import template from the app.
- Product data already cleaned (no duplicate SKUs/names).
- A backup made before any big import.
Steps
-
Download the import template
Open Persediaan → Produk, choose Import on the product list, then download the latest template from the Impor Produk page. Never use an old file whose columns may have changed; the app UI is in Indonesian.
Always start from the app's latest template. -
Fill the data per the template's columns
SKU, product name, category, brand, unit, and opening stock. Fill only the columns the template asks for.
Fill only the columns the template asks for — never add your own. -
Clean duplicates and number formats
One product per row; SKUs/names must not repeat. Make sure number columns hold real numbers (not text with thousands separators).
One product per row; number columns must be real numbers. -
Upload the file
Return to Persediaan → Produk → Import and upload the cleaned file. The Store App does not provide a global Tools → Import & Export menu for this flow.
Upload the cleaned file. -
Read the validation result
The system lists the problematic rows with reasons — do not skip this part.
Read the validation result — do not skip this part. -
Fix errors if any
Correct them in the Excel file, then re-upload. Fixing before the data enters is far cheaper than correcting after it's mixed in.
Cheaper to fix before entry than to correct after mixing. -
Check products and stock cards after the import
Open a few products at random: names right, units right, opening stock landed as a batch on the stock card.
Check a few random products: name, unit, and opening stock correct.
What you end up with
Product data and opening stock moved from Excel into Automan with validated results — without retyping row by row.
If something goes wrong
Columns don't match on upload
Re-download the latest template and move your data into it; never add or rename columns yourself.
Duplicate products after the import
Clean duplicate SKUs/names in Excel before importing — dedup is much harder once the data is in.
Not sure the opening stock is right
Import the minimum first, then run a stock count to reconcile against the shelf.