Item Data Management Tool

Download Data from Database

Upload a template file (CSV, TXT, XLSX, or XLSM) to define the columns for your download. The system will match column names with the database and export the data. For large files, this process might take some time as the file is generated on the server.

**Requires Composer:** For XLSX/XLSM support, ensure you've run `composer require phpoffice/phpspreadsheet` in your project folder and uploaded the 'vendor' directory to your server.

Upload Data to Database

Upload a data file (CSV, TXT, XLSX, or XLSM) to insert or update item data. Columns in your file will be automatically added to the database if they don't exist. The system will try to auto-detect the unique identifier column (e.g., 'BARCODE', 'ITEM CODE', 'SKU', 'SERIAL').

**Requires Composer:** For XLSX/XLSM support, ensure you've run `composer require phpoffice/phpspreadsheet` in your project folder and uploaded the 'vendor' directory to your server.

Search Item Data by Barcode or Item Name

Upload History

File Name Original File Name IP Address Upload Time Download Uploaded File
upload_687f3a9383c38_products (3).csv products (3).csv 2405:201:5800:a0f4:79d6:69b8:8ff2:add8 2025-07-22 07:15:31.000000 Download
upload_687f3a2a03f40_123456.xlsx 123456.xlsx 2405:201:5800:a0f4:79d6:69b8:8ff2:add8 2025-07-22 07:13:46.000000 Download