Upload Format
Format
The system supports CSV (.csv) and Excel (.xlsx, .xls) files. The header row must contain keywords that map to the following required fields.
Columns
| Column | Description | Rules & Validation |
|---|---|---|
| mpob_id | The MPOB license number of the supplier. | • Must be exactly 12 digits (e.g., 500012345678) OR exactly 0 (for foreign/unregistered entities).• Must not match the buyer's MPOB ID (no self-trading). |
| entity_type | The type of the supplier entity. | • Allowed values (case-insensitive):estate, smallholder, dealer, ffb_dealer, mill, crusher, refinery, oleochemical, biodiesel.• Defaults to smallholder if left blank.• Logic Check: The supplier type must be able to sell to the buyer type (e.g., an Estate cannot sell directly to a Refinery). |
| entity_name | The name of the supplier company or individual. | • Free text. • Used for display in the Network Panel. |
| quantity | The volume or percentage of supply. | • Must be a positive number. • Percentage symbols (e.g., 50%) are automatically stripped.• Header keywords: quantity, percentage, qty, quantity_percentage. |
Example (CSV/Excel)
mpob_id,entity_type,entity_name,quantity
500012345678,mill,Example Mill A,1000.50
500087654321,estate,Example Estate B,500
0,dealer,Foreign Supplier C,200
Common Errors
- INVALID_MPOB: The MPOB ID contains letters, spaces, or is not 12 digits (except "0").
- INVALID_ENTITY_TYPE: The value in
entity_typeis not one of the allowed values. - SELF_TRADING: The supplier's
mpob_idis the same as the logged-in user's (buyer's) ID. - INVALID_SUPPLY_CHAIN: The supplier type cannot logically sell to your entity type (e.g., Smallholders can only sell to Mills or Dealers).