Parsing and Import to Prom

Platforms: Prom
Niche: Auto parts
Task: add products to the online store, ready for sale and combined with item numbers from supplier price lists

Type of work: parsing and importing products to Prom store

What has been done:

- parsing of the source of 6 thousand products, taking into account the characteristics from the product cards and filter pages of categories
- filtered out products that are already on the site
- filtered out products by stop-brands
- filtered out products that are not in the supplier's price list
- the data has been converted to the format of the theme, the unnecessary text has been cleaned up
- search queries have been created for products
- donor characteristics have been converted to standard Prom characteristics (main)
- descriptions for products have been supplemented and generated
- the categories of the donor site have been matched with the categories of the site on Prom

Resources and technologies: Excel, Prom, parser, PowerQuery

Results: 6 thousand unique products adapted for Prom and ready for sale
Timeframe: 10 days

#парсеры #prom.ua. #PowerView #Parsing #migration #прайс-лист #контент-менеджмент #pim #преобразование #обработкаданных #vbaexcel #excel