Парсинг 30000 товарів і імпорт в Horoshop

Platforms: Horoshop

Niche: Furniture
Task: Parse products from supplier websites and import them into the Horoshop site in two languages, where products, templates, and directories already exist.

Type of Work: Parsing, Content Management

What has been done:

- Parsed 30,000 products, 1,390 characteristics, 1,050 categories
- Collected links to instructions and video materials on the products
- Cleared the parsing of unnecessary links and URLs to other resources
- Descriptions and names transformed into the site's style and prepared for import
- Replaced names and values of characteristics according to existing records and content management on the client's site
- Created 20 product templates
- Distributed 1,390 among 20 templates, with the selection of characteristic types and the creation of directories for characteristics of the 'Choice from list' type
- Assigned templates to 1,050 categories, set characteristics for filtering and display in product cards
- Formed 20 import files, pre-transformed through reference values
- Imported 30,000 products into the Horoshop site

Resources and Technologies: PowerQuery, ExcelVBA, GoogleSheets
Results:

- Created 20 product templates
- Imported 30,000 products

Timeframe: 14 days