Development of a web service for generating price lists for marketplaces in Ukraine
Project Description
A simple web service (personal account) needs to be developed that will automatically generate price lists for various marketplaces in Ukraine based on one main procurement price list.
The goal is to eliminate the need for me to manually create Excel files for each marketplace.
Input Data
There is one main Excel/CSV price list with procurement prices.
It contains approximately:
- Article
- Name
- Brand
- Category
- Procurement Price
- Availability
- Product Code
- Barcode (if available)
- Other fields
Required Functionality
1. Price List Upload
Button
Upload Price List
Supported formats:
After uploading, the system should save the data.
2. Price List Generator
There should be a list of marketplaces.
For example
- Rozetka
- Epicenter
- Prom
- Kasta
- Hotline
- Allo
- MAUDAU
- EVA
- Bigl.ua
(the list will expand)
Next to each, a button
Generate or better if it updates automatically via API every hour
3. For Each Marketplace
Separate rules with markups according to their commission tables
For example
Rozetka
- its own columns
- its own order
- its own field names
- its own price formula
Epicenter
- other fields
- other columns
Prom
that is, each marketplace has its own export template.
4. Price Formation
A rules editor needs to be created.
For example
Procurement × 1.15
or
Procurement + 800 UAH
or
Procurement × 1.18 + 200 UAH
or
if the price is up to 5000 UAH
then markup 20%
from 5000 to 15000
15%
over 15000
10%
that is, everything should be according to their tables
5. Additional Rules
Ability to:
- hide out-of-stock items
- hide certain brands
- hide categories
- exclude items
6. Result
The output should be a file
Excel
or CSV
that can be immediately uploaded to the marketplace, or better if it updates itself via a link
Interface
As simple as possible.
For example
Main Price List
[Upload]
---------------------
Rozetka
[Generate]
---------------------
Prom
[Generate]
---------------------
Epicenter
[Generate]
---------------------
Hotline
[Generate]
Desirable
That all templates can be edited.
For example
I want to change
Column A
Column B
add a new column
delete a column
change the name
without contacting a programmer.
Admin Panel
Needs:
- list of marketplaces
- templates
- markup rules
- generation log
- history of uploaded price lists
Stack
Not critical.
Can be:
- Laravel
- PHP
- Python (Django/FastAPI)
- Node.js
The main thing is that the code is understandable and can be expanded.
In the Future
In the future, it is planned to add:
- automatic price updates
- marketplace APIs
- stock synchronization
- XML generation
- YML generation
- automatic price list uploads
- support for dozens of marketplaces
- multiple suppliers
- different currencies
What is Required from the Performer
- Experience working with Excel/CSV.
- Understanding of marketplace price formats.
- Ability for further support and development of the project.
- Indicate the estimated cost, deadlines, and development technology.
I would also add one important requirement
To make the system as universal as possible, so that in the future it can support 100+ marketplaces and 100+ suppliers without changing the architecture. This will significantly simplify the scaling of the project and allow its development without a complete overhaul.
