Imonggo Enterprise Bulk Import Documentation
Imonggo Ent© supports bulk import of data. Data can be uploaded usually in CSV format to an ftp account provided by Imonggo technical support team. Imonggo scans the incoming folder every 10 minutes for incomings files and process them accordingly.
The file uploaded should strictly follow the file naming convention as described in this document. This will allow Imonggo to process the file correctly including deriving the account id from the file name, checking for duplicate batch, etc.
In case of error in the processing, the administrator will be notified via email with diagnostic detail. The administrator email must be setup from the Control Center -> Account Settings.
Upon completion of the processing, the CSV files whether successful or failed, will be archived. These files will automatically be removed in 30 days.
Imonggo Ent© currently supports the following bulk import.
- Products - product information
- Prices - price information
Bulk Product Import supports the following fields.
|Unique stock no
|Item name or short description
|A longer description of the product
|One or more barcodes separated by comma
|Either "" or "D", "" indicates active status, use "D" to mark a product as deleted
|Base Unit name
|1 - true, 0 - false, set to true if there is no need to track inventory
|1 - true, 0 - false, set to true if you want to allow decimal quantities
|1 - true, 0 - false, set to true to allow store to change price
Bulk Price Import supports the following fields.
|Unique stock no to identify the product
|Retail price of the item
The table below defines the convention used to name the data files. In general, the filename follows the format of prefix-batchno-YYYY-MM-DD_account.csv.
|must be products or prices
|date in YYYY-MM-DD
|tmp or csv
An example of the file products-101-2014-08-01_petron.csv
A designated ftp server, user and password will be provided to you to upload the bulk data. When uploading the data, you should follow this protocol:
- Use the extension .tmp while the file is being
- Upon completion of upload, change the file extension to .csv
Doing so will avoid the server processing an incomplete upload.