2 Macro VBA in Excel

it is necessary to organize a way to collect newly created individual entrepreneurs and, if possible, limited liability companies. whether it's parsing or something else - you tell me what this method should be

Good morning,I will commission the creation of a stable and reliable solution for automatically monitoring prices and availability of products from a specific large Polish online store in the RTV/AGD sector.Project goal: The system must regularly check selected product links and, in case of a price change or availability status, send a notification (preferably via Telegram, Discord, or email – to be determined).Challenge: The store's website has very aggressive anti-bot systems (Akamai/Cloudflare). Ordinary scripts that fetch the page code are immediately detected and blocked. The solution must effectively bypass these protections, mask bot traffic, and operate stably over the long term, without constantly throwing "Access Denied" errors.What I expect from the contractor: Proposing a complete architecture and technology (I do not impose a programming language or specific tools). Delivering a ready-made solution that I can easily launch and manage. Suggestions regarding infrastructure (e.g., what proxies will be necessary for the system to operate smoothly).In response to the announcement, please briefly describe: What approach/technology do you propose to effectively and sustainably bypass the store's protections? How do you see the issue of sending notifications? What is the estimated cost of execution and time of completion?I invite you to submit your offers.

About the Company Trading company. We work with a product group of more than 2000 items across different categories.Current Situation Currently, the nomenclature is maintained in Google Sheets — data is consolidated by tabs (categories). Tab Structure: Product name Price groups: cost price, wholesale, retail Characteristics: weight, quantity per package, etc. Important: the number of columns varies for different product categories, as they have different characteristics.Why the Current Solution is Inadequate Google Sheets does not allow setting access rights at the level of individual columns. We need to: Grant users rights to view certain columns (for example, only cost prices) Grant rights to edit certain columns (for example, retail prices) While restricting access to other columns in the same tabWhat Needs to Be DoneMain Requirements Flexible Rights Management System Access at the level of individual columns (read/write) Assignment of rights by roles or users Management of rights without the involvement of programmers Support for Different Data Structures Different product categories have different sets of characteristics Adding new columns/characteristics without programming Independence from Developers Administration by internal staff Adding categories, columns, users — through the interface Integration with ERP Exporting current prices to our ERP system Export or automatic integration via API Data Analysis Using AI (preferably) Ability to analyze the entire nomenclature list Enrichment, verification, recommendations — if you have ideas, please describeExpected Result A working solution in which: The nomenclature is structured by categories with different sets of characteristics Column rights are flexibly configured (view/edit) Data is exported to ERP The team can manage the system independentlyWhat We Need from You When Responding Describe in general terms how you envision the solution: What tool/platform do you propose

Good evening, there is a task: you need to check the availability and relevance of the prices of products added to the website (the website is on the prom.ua platform) from the supplier's site 1-2 times a day. Can you calculate the price and how it will look?

Set up automatic daily updates of product availability on our website on prom.ua. We have a supplier who sends a price list of products in Excel format to our email every day. The items on our website and in the supplier's price list are the same. The values in the "stock" column are either out of stock, a number, or more than a box - these need to be updated on the site to either Ready for shipment or Out of stock. Items that are not in the supplier's price list should remain unchanged. Please propose a solution, timeline, and budget. Thank you in advance for your response, I look forward to collaborating with a specialist.