Import supplier data from Excel
This feature imports supplier data from an Excel file into the app. You do not need to type wholesale names, addresses, and contacts one by one.
When to use it: Use this feature when you switch to Automan or want to add many new suppliers at once.
Good to know:
- Files must be in .xlsx, .xls, or .csv format, up to 10 MB or 20,000 rows.
- Suppliers with the same name are not merged into one automatically.
- Unmatched file columns are ignored automatically by the app.
Note
UI screenshots for this tutorial are on their way. You can still follow the guide through the menu, button, and field names given in each step.
Before you start
- An Excel or CSV file with your supplier list, one row per supplier.
- File size up to 10 MB and a maximum of 20,000 rows.
Steps
-
Open Mitra → Pemasok and click Impor
Go to Mitra → Pemasok on the main menu. Click the Impor button to open the Impor Pemasok page.
-
Download a template if you need column formats
Click Unduh Template Ringkas or Unduh Template Lengkap if you need an example. Skip this step if your file is already set up.
-
Upload your file to the box
Drag your file into the upload box, or click to choose it. Make sure the file is under 10 MB and has no more than 20,000 rows.
-
Match your file columns with app columns
Select matching column names in the Kolom Automan dropdown. Required columns have an asterisk. You can leave unrecognized columns empty.
-
Check the Data induk step, then continue
The third step, Data induk, matches your category and bank columns with store data. If it says nothing needs deciding, click next to go to Pratinjau.
-
Check test results in Pratinjau
This stage is only a test and does not save data yet. Check ready rows. If any red rows show errors, fix your file in Excel.
-
Click Jalankan to process your data
Click the Jalankan button to process supplier data into the app. The system only adds valid rows to the Pemasok list.
-
Click Kembali ke Pemasok to check results
Click Kembali ke Pemasok to see the result. Open a few suppliers at random to check that names and contact numbers are correct.
What you end up with
Valid supplier data is now saved in the Pemasok list without problem rows, and is ready to use for recording purchases.
If something goes wrong
A file column is missing in Kolom Automan
Leave that column unmatched. Unrecognized columns are ignored automatically and will not stop the import process.
Supplier phone numbers have inconsistent formats
You do not need to clean phone numbers in Excel. The system tidies them automatically during the import process.
The file is rejected during upload
Make sure the file is 10 MB or less and has at most 20,000 rows. If it exceeds limits, split the file into smaller parts and import in batches.
The same supplier appears twice
The system does not merge matching supplier names automatically. Delete duplicate rows in Excel before you upload the file.
All rows are marked red in Pratinjau
Check the matching for required columns with an asterisk. Make sure required app columns point to the correct columns in your file.
Related tutorials
- Tutorial
Import customer data from Excel
How to import multiple customers at once from an Excel file.
- Tutorial
Import products and stock from Excel
How to import products and opening stock from an Excel file.
- Tutorial
Enter parts purchases from a supplier
How to record incoming purchase orders from suppliers to your shop.