Automating Daily Updates of Marketing Assets for Over 700 Pharmaceutical Products
What was the project about?
An international pharmaceutical group needed to keep snapshots and product booklets current across several e-commerce systems. SoftwareHut developed an unattended Python robot that checks more than 700 products every night and uploads updated files, reducing the time required for major updates from seven days to one.
Who was the client?
The client was an international pharmaceutical group managing a portfolio of more than 700 products. Product snapshots and booklets were published across several external e-commerce systems.
What challenge did the client face?
Marketing assets changed over time, but identifying outdated files across the full product portfolio was difficult. Employees updated the assets manually and usually only when a specific request appeared.
As a result, the process was performed irregularly. Some e-commerce platforms continued to display outdated snapshots or booklets, which affected product sales.
How was the solution delivered?
SoftwareHut developed an unattended software robot using Python.
Every night, the robot:
- Uses an API to check whether new assets are available for any of the client’s 700-plus products.
- Compares each available file with the version used previously.
- Treats a difference in file size, measured in bytes, as an indication that a newer version is available.
- Opens a web browser and logs into the relevant e-commerce systems.
- Uploads the updated snapshot or booklet for the corresponding product.
- Continues until it has checked the entire product list.
The process runs without requiring an employee to start or supervise each execution.
What changed after implementation?
The robot checks marketing assets for the entire product portfolio every day. Previously, employees performed updates manually and only when required.
For major updates, the time needed to refresh the assets was reduced from seven days to one day. This represents an 85% reduction in process execution time.
The automated process also allows the client to keep product snapshots and booklets current across its e-commerce channels.
Do you have any questions or ideas?
Drops us a line and we'll contact you about your project.
