The Character Validation improvement in product records aims to maintain the integrity and consistency of reference data in the Promob Prices system, ensuring that quotation processes occur correctly and without inconsistencies.
Improvement objective:
Automatically normalize product references by removing unnecessary spaces at the beginning or end of codes.
Prevent incorrect records by displaying clear messages to the user.
Preserve compatibility with integrated systems (Promob Start, Plus, among others).
Ensure data integrity between the front end, database, and quotation APIs.
Context of the improvement:
It was identified that product references containing blank spaces at the beginning or end — such as:
" Product" or "Product" — caused inconsistencies during the quotation process between Prices and the integrated systems.
These inconsistencies resulted in:
Products not recognized in quotations;
Incorrect price returns;
Duplicate or invalid records in the database;
Lack of clear feedback to the user about the situation.
Covered Features
Manual creation and updating of items
Action: Create or edit an item on the Prices website with a reference containing spaces at the beginning or end.
Expected Result: The system blocks saving and displays a message explaining the reason.
Importing a price file via CSV
Action: Import a CSV file containing references with unnecessary spaces.
Expected Result: The references are automatically adjusted (with extra spaces removed) during import, ensuring consistency and preventing future inconsistencies in quotations.
Displaying and validating data from the database
Action: View items that have already been recorded and try to save changes with unnecessary spaces.
Expected Result: The system displays the data as stored, but prevents incorrect changes from being saved, keeping the database standardized.
Check Inconsistencies button
Action: In a price table with recorded items, click Check Inconsistencies.
Expected result:
Displays a dialog listing invalid items, when applicable;
Displays an explanatory message when all items are valid.
Prices / Libraries Integrations
Product Quotation
The integration has been enhanced to tolerate incorrect typing, ensuring robustness and accuracy in price returns.
Even if the inconsistency is present in the Prices or library record, the system now performs the quotation correctly.
Promob Plus
Action: Change the quotation price in Promob Plus for products containing unnecessary spaces.
Expected Result:
The process proceeds normally, with validation applied only in Prices — without changing the original record in Plus or in Libraries.
After synchronization, quotations proceed correctly.