Module ProductExpiryIO
Module ProductExpiryIO
Introduction
ProductExpiryIO is an external Dolibarr module designed to manage important product fields in bulk using CSV import/export.
The module is useful for companies that manage many products and need a safer way to update product settings without editing every product manually.
ProductExpiryIO supports simulation mode, automatic backups, backup restore, import logs, administrative audit, simulation reports and log archives.
Main features
- Export products to CSV
- Import products from CSV
- Download CSV import template
- Simulation mode before modifying product data
- Detected changes table during simulation
- Downloadable simulation report CSV
- Automatic backup before every real import
- Restore products from backup
- Automatic backup before restore
- Import log
- Administrative audit
- Log archive system
- Simulation reports management
- Dashboard with module statistics
- Separate user permissions
- Dolibarr menu integration
Supported product fields
ProductExpiryIO supports the following product fields:
- Product code
- Product label
- Sale status
- Purchase status
- Batch / serial number management
- Mandatory sell-by / expiry date setting
- Stock management
- Default warehouse
- Product nature
CSV columns
The module uses the following CSV columns:
| CSV column | Description |
|---|---|
| Code | Dolibarr product reference |
| Label | Product label |
| Sell | Product available for sale |
| Buy | Product available for purchase |
| BatchMode | Batch or serial number management |
| MandatoryExpiry | Mandatory sell-by / expiry date setting |
| StockManagement | Product managed in stock |
| Warehouse | Default warehouse code |
| Nature | Product nature |
Accepted values
| Field | Accepted values |
|---|---|
| Sell / Buy / StockManagement | Yes, No, 1, 0 |
| BatchMode | No, Batch, Serial, 0, 1, 2 |
| MandatoryExpiry | None, SellByDate, ExpiryDate, Both, 0, 1, 2, 3 |
| Nature | RawMaterial, FinishedProduct, Packaging, IntermediateProduct, 0, 1, 2, 3 |
Recommended workflow
- Export products to CSV.
- Edit the CSV file in Excel or LibreOffice.
- Run import in simulation mode.
- Review detected changes.
- Run the real import.
- Check the automatic backup and import log.
Backups and restore
Before every real import, ProductExpiryIO automatically creates a CSV backup of the previous product values.
Backups can be downloaded, restored or deleted from the module interface.
When restoring a backup, the module automatically creates a new backup before applying the restore.
Simulation reports
After an import simulation with detected changes, ProductExpiryIO can create a downloadable CSV report.
Simulation reports can be managed from the module interface.
Import log and audit
The module records simulations, real imports, backup restores and administrative actions in an import log.
Administrative actions such as backup deletion, report deletion and log archive deletion are also recorded.
Compatibility
| Item | Value |
|---|---|
| Dolibarr version | V23 |
| PHP version | 7.2+ |
| Module version | 3.18.0 |
| License | GPL-v3-or-later |
Installation
The module can be installed from DoliStore using the Dolibarr external module deployment feature:
- Download the ZIP package from DoliStore.
- In Dolibarr, go to Home → Setup → Modules → Deploy an external module.
- Upload the ZIP package.
- Enable the module from the module list.
- Assign the required user permissions.
Permissions
ProductExpiryIO uses separate permissions:
| Permission | Purpose |
|---|---|
| View Product Expiry IO | Access dashboard and export |
| Import products Product Expiry IO | Import, simulation and simulation reports |
| Manage backups and logs Product Expiry IO | Backups, logs, archives and administrative actions |
DoliStore
The module is available on DoliStore:
ProductExpiryIO - Product Expiry Import/Export Module for Dolibarr
Author
Vasile Panciuc
Support
Support by email: mikrosha2000@gmail.com
When requesting support, please include:
- Dolibarr version
- PHP version
- ProductExpiryIO version
- Screenshots
- Steps to reproduce the issue