Module ProductExpiryIO - Revision history

Mikrosha2000 at 09:03, 6 September 2026

2026-09-06T09:03:15Z

← Older revision		Revision as of 09:03, 6 September 2026
Line 1:		Line 1:
	= Module ProductExpiryIO =		= Module ProductExpiryIO =

	[[File:ProductExpiryIO-3.20.0-cover.png\|center\|~~1000px~~\|ProductExpiryIO 3.20.0 - Product Expiry Import/Export Module for Dolibarr]]		[[File:ProductExpiryIO-3.20.0-cover.png\|center\|600px\|ProductExpiryIO 3.20.0 - Product Expiry Import/Export Module for Dolibarr]]

	== Introduction ==		== Introduction ==
Line 49:		Line 49:
	# Review the import result and audit history.		# Review the import result and audit history.

	[[File:ProductExpiryIO-3.20.0-import-simulation.png\|center\|~~1000px~~\|ProductExpiryIO CSV import and simulation mode]]		[[File:ProductExpiryIO-3.20.0-import-simulation.png\|center\|600px\|ProductExpiryIO CSV import and simulation mode]]

	During simulation, '''the database is not modified'''.		During simulation, '''the database is not modified'''.
Line 148:		Line 148:
	This allows the administrator to recover the state that existed immediately before the restore operation.		This allows the administrator to recover the state that existed immediately before the restore operation.

	[[File:ProductExpiryIO-3.20.0-backup-restore.png\|center\|~~1000px~~\|ProductExpiryIO automatic backups and safe restore]]		[[File:ProductExpiryIO-3.20.0-backup-restore.png\|center\|600px\|ProductExpiryIO automatic backups and safe restore]]

	The restore operation reports:		The restore operation reports:
Line 189:		Line 189:
	Archived logs can later be downloaded or deleted from the '''Log archives''' page.		Archived logs can later be downloaded or deleted from the '''Log archives''' page.

	[[File:ProductExpiryIO-3.20.0-audit-log-archives.png\|center\|~~1000px~~\|ProductExpiryIO import audit trail and log archives]]		[[File:ProductExpiryIO-3.20.0-audit-log-archives.png\|center\|600px\|ProductExpiryIO import audit trail and log archives]]

	== Simulation reports ==		== Simulation reports ==
Line 214:		Line 214:
	On mobile devices, wide tables such as backups, logs and report registers are transformed into readable cards.		On mobile devices, wide tables such as backups, logs and report registers are transformed into readable cards.

	[[File:ProductExpiryIO-3.20.0-responsive-mobile.png\|center\|~~1000px~~\|ProductExpiryIO responsive desktop and mobile interface]]		[[File:ProductExpiryIO-3.20.0-responsive-mobile.png\|center\|600px\|ProductExpiryIO responsive desktop and mobile interface]]

	Responsive pages include:		Responsive pages include:

Mikrosha2000: Updated documentation for ProductExpiryIO 3.20.0 Stable with new workflow, backup/restore, audit, reports and responsive UI.

2026-09-06T08:51:56Z

Updated documentation for ProductExpiryIO 3.20.0 Stable with new workflow, backup/restore, audit, reports and responsive UI.

Show changes

Mikrosha2000: Add DoliStore link

2026-07-05T14:58:06Z

Add DoliStore link

← Older revision		Revision as of 14:58, 5 July 2026
Line 180:		Line 180:

	ProductExpiryIO - Product Expiry Import/Export Module for Dolibarr		ProductExpiryIO - Product Expiry Import/Export Module for Dolibarr

			https://www.dolistore.com/product.php?id=3204&title=productexpiryio-product-expiry-import-export-module-for-dolibarr&l=en

	==Author==		==Author==

Mikrosha2000: /* Support */

2026-07-05T14:19:18Z

Support

Show changes

Mikrosha2000: Create ProductExpiryIO module documentation page

2026-07-05T14:17:10Z

Create ProductExpiryIO module documentation page

New page

= Module ProductExpiryIO =

[[Category:Complementary modules]]

== 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:

{| class="wikitable"
! 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 ==

{| class="wikitable"
! 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 ==

{| class="wikitable"
! 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:

{| class="wikitable"
! 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: vasile.panciuk@gmail.com

When requesting support, please include:

* Dolibarr version
* PHP version
* ProductExpiryIO version
* Screenshots
* Steps to reproduce the issue