Import Supplier Data: Fill Your Supplier List Without Retyping
Every store that moves to Automan runs into the same question: the supplier list already lives in a tidy Excel sheet, so does it really need to be typed in again, one row at a time? For a store with dozens or hundreds of suppliers, retyping isn’t just slow — it’s also how phone number typos, duplicate names, and data that never quite matches the old records get in.
Automan closes that door with the exact same wizard used to import customers, adapted for suppliers. You upload the Excel or CSV file you already have, match its columns once, review the result before anything actually gets saved, then run it. No retyping, and no guessing which column is supposed to hold what.
What makes this flow safe even for someone who has never imported anything before is the order of the steps: match the columns first, then preview, then run. Problem rows get flagged before a single one lands in the real supplier list — so a formatting mistake in Excel can’t contaminate data that’s already clean.
Columns the system doesn’t recognize don’t break anything either. That means you can upload an export from an old system as-is, without scrubbing every foreign column first — Automan sorts out what’s relevant.
The end result: a supplier list that used to live in a separate Excel file is now part of Automan — ready to use immediately for purchase transactions, without a single name typed in from scratch.
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
- Your supplier list already cleaned up in Excel/CSV — one row per supplier, no duplicate names.
- Knowing which columns are required, so you don't bounce back and forth on the column-matching step.
Steps
-
Open "Mitra → Pemasok" and press "Impor"
The page that opens is titled "Impor Pemasok", with the flow spelled out right at the top: "Unggah berkas, cocokkan kolom, periksa pratinjau, lalu jalankan." ("Upload the file, match the columns, check the preview, then run.") That is exactly the order you are about to follow. Change your mind partway through, and the "Kembali ke Pemasok" ("Back to Suppliers") button always gets you out without touching anything.
-
First time doing this? Download the template first
Two buttons are available: "Unduh Template Ringkas" ("Download Short Template") and "Unduh Template Lengkap" ("Download Full Template"). The template already ships with a filled example row and an instructions sheet, so you just overwrite the example with your own supplier data. If your supplier data already lives in another file, skip this step — as long as you can match its column names manually in the next step.
-
Upload the file to the drop zone
The upload box reads "Letakkan berkas di sini, atau klik untuk memilih" ("Drop the file here, or click to choose"). Accepted formats are .xlsx, .xls, or .csv, capped at 10 MB and 20,000 rows per upload. If your supplier list is larger than that, split it into a few files first — forcing one giant file through only means waiting longer to find out a row failed.
-
Match the columns in Step 2
Automan shows a three-column table: Kolom di berkas Anda ("Column in your file"), Kolom Automan ("Automan Column", a dropdown), and the first five sample values. Guesses are usually filled in automatically when your column names resemble Automan's standard ones. Required columns are marked with an asterisk (*); columns in your file that the system does not recognize can be left unmatched — that will not fail the import, it just gets ignored.
-
Skip past the mid-wizard data step
On the customer import, this third step is used to group customers into customer types. Supplier data has no such grouping, so on the supplier variant of the wizard this step is little more than a brief confirmation pause before Pratinjau — there is no decision to make here.
-
Check Pratinjau before running anything
This is a dry run, not the real thing — nothing has landed in the actual supplier list at this stage. Automan separates rows that are ready from rows with problems, so you know exactly what is about to happen before pressing the button that cannot be undone.
-
Fix any row flagged as a problem first
If Pratinjau shows rows marked in red, do not force the run anyway. Go back to the Excel file, fix the row — usually a blank name or an unfilled required column — then repeat from the upload step. Fixing it here is far cheaper than fixing it after the supplier is already mixed in with your existing data.
-
Press Jalankan to finish the import
Once Pratinjau looks clean, the final step executes the valid rows into the real supplier list. Rows still flagged as problems do not go through, so running the import early will not damage data that is already good.
-
Check the result via "Kembali ke Pemasok"
The same button you used earlier to bail out now takes you to see the outcome. Open a handful of the newly imported suppliers at random — name, phone number, and any other column you filled — to confirm the column matching from Step 2 landed exactly where you meant it to.
What you end up with
Your supplier list moves from Excel into Automan through the same wizard used for customer import — upload, match columns, preview, run — with no manual retyping, and no problem row slipping through unnoticed.
If something goes wrong
A column in my file doesn't show up in the Kolom Automan dropdown
That's fine to leave as-is. Columns the system doesn't recognize are simply ignored and will not fail the import — the data in that column just doesn't come across.
Supplier phone numbers are formatted inconsistently (08xxx, +62, with spaces)
No need to clean them up in Excel first. Phone numbers can be written freely; the system tidies them up automatically during the import.
The file gets rejected right after upload
Check the two limits: 10 MB maximum size and 20,000 rows maximum. If either is exceeded, split the file into parts and import in batches.
The same supplier shows up twice after importing
The system does not automatically merge suppliers with matching names — one row in the file always becomes one new supplier. Clean up duplicates in Excel before uploading; merging two records after they are already in Automan is far more work.
Every row is flagged as a problem in Pratinjau
This usually means a required column (marked *) wasn't matched correctly in Step 2. Go back to that step and confirm every required column points to the right column in your file.
Related tutorials
- Tutorial
Import Customer Data: Fill Your Customer List Without Retyping
The exact same wizard, for customers — including the customer-type grouping step that the supplier variant skips.
- Tutorial
Importing Products and Stock from Excel
How to move your product catalog and opening stock from Excel — commonly used alongside supplier import when setting up a new store.
- Tutorial
Recording Parts Purchases
The natural next step once your supplier list is filled in: recording a purchase against one of those suppliers.