Manual collection of competitors prices

Theme – smartphones. There is a table of prices for 9 different cities. About 30 competitors. For each competitor, 200 positions. You need to go to the site, copy the price to the table. Keep in mind that collect not separately all 200 items, but about 45 variations, because for the same amount of memory, but different colors - the prices are the same. This task is needed permanently.