Version 13.0

• Fixed ingredients CSV redeclarations
• Replaced alert box with toast message when copying AI response
• Added a real-time advisory count badge
• Cosmetic changes for formulas labels
• Added BS5 floating elements for formula properties
• Extend formulas search in labels
• Rename tags to labels
• Added ingredient replacement suggestion in formula making using Perfumers AI
• Added full date in AI chat response
• Added CAS in ingredient suggestions
• Updated AI formula generation to include dilution and solvent
• Fixed js error when searching in PV library
• Replaced odor with labels for ingredients
• Fixed defaultMessage error in AI Chat
• Replaced Odor column with label in ingredients page
• Deprecated colorKey
• Added makeformula API
• Improved Perfumers AI Chat

Version 12.9

• Introduced Google Gemini integration.
• Introduced OpenAI integration.
• Enabled AI-powered formula creation.
• Localized date formatting across the application.
• Removed time from "created" and "updated" fields for a cleaner display.
• Eliminated "created" and "updated" timestamps from ingredient suppliers, bottles, customers, and formula documents.
• Removed "updated" timestamp from HTML templates.
• Added support for Windows and macOS executors.
• Introduced a formula advisor feature.
• Ensured random IDs are assigned during first-time user creation.
• Moved database schema creation check to PV startup instead of the login page.
• Redesigned the login screen with a template-based approach.
• Prevented archiving of protected formulas during deletion attempts.
• Added a check for material existence when generating batch PDFs.
• Included an explanation for formula archiving.
• Assigned new random IDs to archived formulas.
• Updated documentation links for better accessibility.
• Enhanced session monitor to log to a file if specified.
• Improved CSV formula import functionality.
• Introduced an AI-powered chat box.
• Added tab icons to the settings page for better navigation.

Version 12.8

• Added links for PV apps
• Fix ingredient import compounds failing to import
• Fix AromaTrack app api
• Fix JSON export from within the formula page
• Minor cosmetic changes
• Remove user session on logout even if the session delete query fails
• Backwards compatibility db schema fix

Version 12.7

• Improved security for fetching ingredient providers
• FPDF lib update to 1.86
• Fix backup process failing in some cases with invalid data
• Add supplier form improvements
• Add default IFRA cat for ingredients
• Dropping public formula view summary
• Adding backend support for AromaTrack app
• Error page update
• Logout better error handling
• Currencies json has been moved under db/
• Added currency support for suppliers
• Added API enable/disable option for system settings
• Fix session handler timestamp compare
• Mariadb Server updated to version 11
• Fix incorrect percentage calculation for formulas
• Fix google backups page not loading if invalid date set
• Added user data export as sql
• Fixed incorrect created field for batch history
• Added functionality to embed ingredient's sub ingredients into the formula
• Force ingredient size to return 10 (ml) by default if size not set in suppliers before version 12.7
• Prevent setting size to 0 in ingredient supplier

Version 12.6

• Added metadata count (formulas, ingredients, etc.) for users in the admin dashboard
• Monitored user changes in the admin dashboard
• Added last login timestamp for users
• Improved formula making process
• Enhanced upload size validation function
• Added support for Google Analytics
• Improved API security
• Implemented a unique auto-generated 32-bit key for API access
• Fixed synonym search functionality
• Improved price scraper
• Handled suppliers during ingredients import
• Notified only active admin accounts about new/deleted users
• Added session and user clean-up daemon
• Added a column to indicate if users are online
• Fixed PV Library ingredient import issue for some users
• Disabled session monitor by default
• Removed inactive non-admin users after 30 days of inactivity
• Added audit functionality (manual configuration required)
• Filtered full names for illegal characters
• Applied security updates
• Fixed issue with users not loading all entries
• Fixed missing user ID when logging from session monitor agent
• Added an option to bypass strict ingredient check
• Ignored non-numeric values for sys_timeout
• Cleaned up IFRA HTML template (new install only)
• Improved logo handling for documents
• Fixed column alignment for finished product PDF export
• Updated PHP to version 8.3
• Updated nginx to version 1.26
• Added user option to exclude from emails
• Made API test URL non-clickable when the API key is not visible
• Added API key copy button
• Fixed IFRA category description not showing properly in formulas
• Updated select2 library to version 4.1.0-rc.0
• Added order tracking under inventory
• Split import formulas function from core.php
• Split export formulas function from core.php
• Rewrote formulas import/export functionality
• Updated wording when no formulas are available
• Fixed duplicate table ID for supply orders
• Prevented re-ordering if no items are available

Version 12.5

• Improved: Code clean-up, overall security, PubChem structure images fetch, file uploads, CSV imports, forgot password, session security, documents upload, formula analysis security, costs calculations function, multi-dimension formula calculation
• Updated: User profile backend, core backend for better security handling and error logging, ingredient duplication function, default primary key for safety data, policy when importing ingredients from JSON, ingredient data reload after import, count cart function, API key and status configuration per user, index.php, ingredients import, api.php for the new settings format, k8s templates to use the backup agent, Docker compose file for the backup agent
• Fixed: Update form for compounds, accessory type update, synonyms delete, redirection when adding ingredient if already exists with the same name, wording when no batches found, formula attachments created date display, ingredient replacements links, CAS update in IFRA library, text imported formula incorrect percentage handling
• Replaced: Mysqli queries with mysql statements (WIP), unknown defaults with '-' instead of 'N/A'
• Removed: Collation from db fields, id field from JSON exports, non-containerized installation support, installation wizard for non-container, DEMO support
• Refactored: JSON exports, user search preferences in db, index.php, ingredients import, backup integrations
• Added: Multi-user support, System Settings page for admins, users import/export, user impersonation, integrations/logs/maintenance pages for admins, settings per users, user profile self-delete, user email to session data, country in user profile, email validation before updating, user self-register, user announcement text, user settings reset, DB initialization in docker, SMTP email server support, password reset as a self-service, error screen for missing configuration, export options for ingredients (JSON Format only), parameterized memory and upload limit size (defaults to 500MB), ingredient group by physical state, users currently online, indexes for formulas and ingredients to improve speed, SSO authentication
• Renamed: General settings to My preferences, My Brand page to Branding
• Separated: System settings from user settings
• Moved: Search preferences reset to per user basis and globally for admins, session validity visibility to admins, Branding configuration per user, SDS settings to per user basis, PV Library API to system settings
• Deprecated: Old db update scripts
• Changed: Only admins can take/restore backups, environment variable from MAX_FILESIZE to UPLOAD_MAX_FILESIZE, user id to a string
• Prevented: IFRA document creation if formula isn't compatible with the IFRA library standards, re-activating a user if the account is locally inactive
• Dropped: Table settings, backup settings page (admin has to reconfigure)
• Enforced: Password complexity
• This release may include more changes, for full details please refer to the CHANGELOG

Version 12.4

• Add dilutant in API formulas
• API has been extended to provide IFRA library data
• Rewritten the core upgrade process
• Added update log history
• Renamed Measurement Unit to Purchase Unit for ingredients supplier for better clarity
• Restructure Index.php
• Update empty table for cart
• Update actions menu for cart
• Update ingredients datatable empty table function
• Various security updates across the app and user access management
• Better error handling for datatables
• Improve formula revisions
• Remove formulas export menu if no formulas
• Import formulas from a text
• Improve docker startup

Version 12.3

• Fix API log file
• PV Online has been renamed to PV Library

Version 12.2

Docker file update
Fixed document upload for ingredients returning incorrect results
Update login method
Fix API formula failing to return formulas
Added formulas upload via the API
Prevent user profile update if managed externally
API now allows upload for formulas, ingredients
User password is now using a stronger encryption algorithm
Forgot password modal update for BS5
Forgot password wording update
Check if user password is already encrypted when env user variables provided, encrypt if not
Added a stress test script to crate dummy formulas
Added available API calls endpoint table

Version 12.1

• Added summary of total amount required for pending materials
• Added list of materials per supplier
• Added kubernetes manifest for ephemeral db storage
• Renamed openshift folder to k8s
• Added create and update timestamps
• Added user_id to enable multi-user access (FOR SAAS ONLY)
• Update install page
• Fix Manage link in ingredients actions
• Make sure tmp file is created before try to generate a PDF for ingredient
• Wording update
• Code clean-up
• Formula notes summary re-write
• Added an error message next to misconfigured ingredients
• Include supplier data when duplicating an ingredient
• Added environment variables for user creation
• Added environment variable to disable updates
• Improve overall sys upgrade
• Make sure it retrieves the write tag when upgrading from github