We want to build a price/stock scraper capable to extract List Price, Discount Price and Avaliable Stock for sale from different webpages (around 25) based on a given product database. This database includes EAN Code, Manufacturer Code and SKU.
In case the information is not found by using the EAN Code, the scraper should try using the Manufacturer Code.
In case the information is not found by using the EAN Code and the EAN Code starts with "0", the scraper should try using the EAN Code without "0", if it still doesn't work, use Manufacturer Code.
The price scraper should be able to run from Excel or Google Sheets and managed by an user with intermediate Excel VBA experience. The user should be able to update the product database (add/eliminate products and update their information), webpages, and understand how to change the code in case new webpages were added.
The program should be runned manually by the user, who can choose to run the program for a single webpage, a group or all the webpages. The collected information, should be stored in a separate sheet on the same file and named like YYYYMMDD_HHMM (for example 20220927_1647), information should be registered in 3 separate columns for each analized webpage; List Price, Discount Price and Avaliable Stock.
The list of webpages will be sent by message/chat.