Product card generator for promo

Hello! I have thoroughly analyzed your supplier database file and have great news for you.

You will NOT need to manually create thousands of combinations or overpay Prom.ua for listing 40,000 individual products. Your database (judging by the articles "NF-...", this is a classic export from 1C/BAS brands like Cyclone/Nextone) already contains ready-made final assemblies with fixed prices from the supplier.

For example, you already have a separate bare display for 4499 UAH ("NF-00009673") and a ready-made factory radio for Chevrolet Lacetti for 6000 UAH ("NF-00004238"), where the supplier has included the cost of the frame and wiring.

The main problem with your file right now is the "mash" where universal cameras, frames, and factory radios for different cars are all in one list. If you upload this to Prom as it is, buyers will find nothing, and Prom will block the account for duplicates.

What technical solution do I propose:
…
I will write an automated parser-structurer (script) that will do all the routine work for you:

1. Intelligent parsing of names: The script will automatically scan product names. Seeing the line "Factory radio Chevrolet Lacetti 2004-2013...", it will understand that Brand = "Chevrolet", Model = "Lacetti", and Years = "2004-2013".
2. Automatic category tree construction: The script will create the perfect structure on the site: "Auto goods -> Factory radios -> Chevrolet -> Lacetti".
3. Generation of correct XML for Prom.ua (Variations): The script will group products by car model. On Prom, this will look like one beautiful, neat card: "Factory radio for Chevrolet Lacetti (2004-2013)", and inside, the buyer will be able to choose the configuration (different screen models: Nextone, Cyclone, etc.).

What you get as a result:
Budget savings: You pay Prom for one product card (car model), not for 20 separate screens for it.
Automation: No manual work. The script will process supplier files in a matter of minutes.
Perfect UX: It will be extremely easy for the buyer to find the radio specifically for their car.

Please let me know in what format the supplier provides you with this price list (is it a permanent link to XML/Excel, or do they send it to you as a file)?

I am ready to implement this algorithm and set up the correct export "turnkey".

Show original

Translate

Good day! I reviewed the XLS example. The file contains a product database and an example of the logic for forming sets, but for a stable result, it is better to solve the task through automation rather than manually. I can prepare a Python script/Excel processing that will generate set cards: name, product code, price, availability, description, image, link, and a file for further import to Prom without duplicates. We can also separately consider the structure of categories/XML tree so that products are conveniently displayed on the website. Before the final assessment, it is necessary to clarify which specific files with frames/entries and the supplier's XML will be used. After that, I will be able to propose a stable solution for generating a large number of cards.

Show original

Translate

Good day! 🧡
I am ready to start working and would be happy to help with minimal deadlines 😉
I have experience working on similar projects. 🌼 (I have reviews on this topic and work in my portfolio)
I will do it in the best way, starting now! 🚀🛸✈️

Feel free to write, we will discuss. I respond instantly!

Show original

Translate

Good day!

I reviewed the file — I understood the data structure. The Excel already has ready-made combined positions (Nextone N1002 × specific frame + car) with code, name, description, price, photo. The task is to automate the generation of these combinations (50 displays × 2000 frames) and export them in Prom format without duplicates.

Technically, this is solved through a Python script that takes two Excel files (displays + frames), generates all combinations, and outputs Excel/CSV in Prom format. In the end, you get a file for import with unique IDs and groups from the supplier's XML tree.

Before estimating, a few questions need to be clarified:
- How are the Excel files with frames and wires structured (ID, name, price, list of cars)?
- Is the XML from the supplier a single file or multiple sources?
… - In the finished Excel (as in the attachment), is the product code formed as: display code + frame code + car ID or differently?

The answers will be sufficient for an accurate estimate.

Show original

Translate

Hello!

I am ready to write a script in Python that will perform the assigned task.

I suggest we discuss the details in private messages.

Show original

Translate

Good day! I am ready to start collaborating! I have experience in similar projects. *Details in private*

Attention! If I indicated the amount "1111" or "777", it means that I need more information to assess the project (also, deadlines may vary depending on the scope).

Show original

Translate

Good day, such software can be made. But is it necessary? 40000 only for the head units, Prom charges for the number of products in the store, right? Or did I misunderstand the task?

Show original

Translate

I had to work with the promo, we need to look at the structure in the supplier's file in advance, and agree with your store on the promo. After that, we can create all product variants - it's a matter of technique. A script in Python and a bit of patience. If there's a need to update prices, this should be taken into account at the planning stage. Feel free to reach out, and we can discuss in more detail.

Show original

Translate

Good day, Serhiy!

I am ready to create a product matrix generator + automation of the catalog structure for Prom / eCommerce with a large number of combinations (display × car × frame), plus duplication control and stable generation results.

I have experience in similar tasks: automation of product feeds, generation of SEO content, working with large catalogs (10k–100k SKUs), structuring category trees from XML/CSV sources.

How I see the implementation:
1. Desktop or web tool (Windows / macOS)

… We will create a separate tool where you:

upload XML/CSV from suppliers
set combination rules (display / car / frame)
receive ready SKUs without duplicates

2. Product generator

The system automatically generates:

Product name (standard template for Prom)
SKU / product code (deterministic, without duplication)
Price (logic: display + frame + markups)
Availability (depends on components)
Description (template + AI processing if needed)
Photos (linked by components)
Category (from XML tree or custom tree)

3. Duplicate protection

Key part:

hash combination (auto parts fingerprint)
check existing SKUs
stable generation (the same combination = the same result every time)

4. Category tree
import XML structure from the supplier
normalization of categories (to avoid chaos between different sources)
the ability to manually edit the tree

5. Export
Prom-ready CSV/XLSX format
structure for Prom / Rozetka import (if needed)
bulk update of products without duplication
Optionally (AI part)

Can add:

automatic product description (uniqueness for SEO)
generation of title for Prom keywords
normalization of car names (Chevrolet / Lacetti, etc.)

MVP version:
14 working days
~60–80 hours
$900

What I need from you to start:
a sample XML from the supplier
a sample of the correct result (1–2 ready cards)
rules for price formation
how the "ideal category tree" looks (if available)

Show original

Translate

Hello! I am ready to implement an automated generator for creating 40,000+ product variations, which excludes duplicates and clearly distributes them across the category tree based on the XML from your supplier.

Show original

Translate

Ready to complete your task, I have done a similar task before, I can describe how I did it, it might suit you, write to discuss.

Show original

Translate

Greetings! The task is clear: classic combinatorics and data feed generation. I will write a performant Python script that will iterate through all 40,000 variations (car compatibility + display + frame), calculate the final prices, generate unique SKUs (to avoid duplicates), and categorize the products correctly, using the structure from your XML file. In the end, you will receive a ready, clean import file that will upload to Prom without errors. I will complete this in 1-2 days. Let's discuss the details regarding the image format!

Show original

Translate

Hello!

I have reviewed the task.

I can offer a solution in the form of an automated script/service that will generate product cards based on the provided data (displays, frames, cars, images, descriptions, and prices).

What I can implement:

• Generation of all product combinations;
… • Formation of unique names;
• Generation of article numbers and product codes;
• Automatic price calculation;
• Duplicate control between runs;
• Formation of category structure;
• Data import from multiple suppliers;
• Export in Prom.ua XML format;
• Ability to rerun with the same result.

I can also offer a solution that will allow for future updates of the assortment without manually generating thousands of cards.

Preliminary cost: 7000 UAH

Deadline: 5–10 days (after reviewing the source files and data structure).

For an accurate estimate, I would like to review examples of supplier files and the current catalog structure.

Show original

Translate