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
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