Import supplier data from Excel

Web Level Basic Role Owner, Admin Module Impor & Ekspor Data About 10 minutes
Updated

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

  1. Open Mitra → Pemasok and click Impor

    Go to Mitra → Pemasok on the main menu. Click the Impor button to open the Impor Pemasok page.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

  8. 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.