Technical task:
Updating prices and integrating analytics on the website
1. Problem
The website displays outdated prices (last update — 4 years ago), which misleads customers. It is necessary to implement a price update mechanism or replace the price display functionality with a request form. Also, Google Analytics should be integrated to track website effectiveness.
________________________________________
2. Goals
• Ensure current prices on the website or implement a price request mechanism.
• Provide a convenient and secure feedback form instead of displaying prices.
• Add Google Analytics code for analytics.
________________________________________
3. Option 1: Price update based on Excel document
Functionality:
• Import Excel file with current prices into the admin panel.
• Match products by article number.
• Automatically update prices on the website according to the file.
Requirements:
• Excel must contain columns: Article Number, Price.
• If the article number is not found in the database – display a message or ignore.
• Develop a user-friendly interface for uploading the Excel file in the admin panel.
________________________________________
4. Option 2: Hide prices + Request form
Functionality:
• Add a toggle switch in the admin panel: "Show prices" / "Request prices".
• If the switch is off:
o Display a "Request price" button instead of the price.
o Clicking opens a modal window or a new page with a form.
The request form should include:
• Name – required field.
• Phone number – validation (only Ukrainian number or international format, e.g., +380...).
• Email – validation via regular expression (valid email address).
• Product (auto-filled) – hidden field with product name or article number.
After submission:
• Data is stored in the database or sent to the administrator's email.
• Display message: “Thank you! The manager will contact you shortly.”
________________________________________
5. Additional: Google Analytics
Task:
• Install Google Analytics (GA4) code in <head> of all website pages.
• Verify correct event tracking:
o Opening product page.
o Clicking the “Request price” button.
o Submitting the form.
________________________________________
6. Security and UX requirements
• All form fields must be validated on both client and server sides.
• Spam protection (add Google reCAPTCHA v2 or v3).
• Error messages in the form should be understandable to the user.
________________________________________
7. Deadline
• Approximate term: after approval of the technical task.
________________________________________
8. Additional
• Create a backup of the website before making changes.
• Test the new functionality on a test server or website copy.