It is necessary to develop a tool for parsing products from the Come-For website:
https://come-for.com/ua/
The first priority is the Come-For website. In the future, the tool should be extensible to add other manufacturers' or competitors' websites.
All products need to be collected and exported to Google Sheets.
Important: the export must be done strictly in the structure of our working Google Sheets file:
https://docs.google.com/spreadsheets/d/1NaEaFHfMIVW_YUg7JOYbm4SuMcIcxd7xIdkaZZ-UHZg/edit?gid=2050477948#gid=2050477948
This structure is mandatory because the data from this file will be processed using AI, and a description will be generated for each product, after which the products will be uploaded to websites that operate on the Khoroshop platform.
It is necessary to collect:
- serial number;
- product name;
- modification name, if there are sizes or options;
- all product photos, each photo as a separate link;
- price;
- prices for all sizes;
- characteristics;
- original description from the manufacturer’s website;
- category on the manufacturer’s website;
- category for uploading to Khoroshop;
- link to the product;
- processing status.
Article number does not need to be generated.
If the product has different sizes, they need to be exported as product modifications so that they can later be imported into Khoroshop.
After parsing, the data must go into Google Sheets in the required columns. Then, AI processing will be launched in this file. AI will rewrite the product description based on a ready prompt that is already in the file. The brand name and model name must be used in the description.
The final task of the project:
- parsing products from the manufacturer’s website;
- recording in Google Sheets;
- processing descriptions through AI;
- preparing the file for Khoroshop;
- uploading products to the website;
- placing products in the required categories;
- uploading photos;
- adding prices, characteristics, and descriptions;
- repeating the same logic for another website on Khoroshop.
Mandatory requirements:
- working with the Come-For website;
- export strictly in the structure of our Google Sheets file;
- collecting all products;
- collecting all photos;
- collecting all sizes and prices by sizes;
- collecting characteristics;
- collecting the original description;
- determining the product category;
- preparing the category for Khoroshop;
- forming product modifications;
- excluding duplicates;
- error logging;
- ability to restart;
- price update mode;
- source code;
- launch instructions.
It would be a plus:
- price change history;
- automatic updates on a schedule;
- automatic processing through AI;
- preparation of a separate sheet for import to Khoroshop;
- uploading photos to Google Drive;
- integration with Khoroshop API;
- automatic publication of products on multiple Khoroshop websites;
- report after each run.
In the response, please indicate:
- what stack you will use;
- whether you have experience parsing online stores;
- whether you have experience preparing imports for Khoroshop;
- whether you have experience working with Google Sheets API;
- how the structure for product modifications will be implemented;
- how prices by sizes will be collected;
- how all photos will be collected;
- how AI processing of descriptions or preparation for it will work;
- how price updates will be implemented;
- whether it will be possible to add other competitor websites;
- the timeline and cost of developing the first version for Come-For;
- the timeline and cost of adapting for the next website;
- whether further uploading of products to Khoroshop is possible.
Work results:
- working parser;
- export to Google Sheets in our structure;
- prepared data for AI processing;
- prepared data for import to Khoroshop;
- source code;
- launch instructions;
- error log;
- description of the logic for adding new websites.