Work on Excel VBA/Macros with file updates and web scraping
$250-750 USD
Betalt ved levering
Hello, this is my project:
I receive an Excel file with thousands of products from my distributor almost every week, updating the current products prices, and quantity in stock, as well as adding newer products sometimes. I need to create a better system to update my current stock and prices, so I can upload them to my eBay store.
My project has 4 parts:
1) Is to use my current Excel file and the new stocklist file and compare and update the quantities in stock and prices on my existing Excel file. If there are new products, bring the information from these new products to my current spreadsheet with all the information.
2) Use the newly updated excel file with all products, and look at each product and go to 3 websites of my competitors, to search for that product number, scrape the prices and the quantity in their stock, and bring them back to my Excel spreadsheet. If there is no data on any of the 3 website, return the value Zero or not available. Once all the data from all my products from the 3 websites are filled on my new spreadsheet, we will do some simple calculations by comparing the 3 prices and do a suggestive price for me to sell, like maybe 10% above the lowest of the 3 competitors, if the 10% is above my real cost.
3- This part is just data transfer from this master spreadsheet above to another simpler spreadsheet with some specific column headers for me to upload that CSV file to my eBay store, which i will do it using the eBay File Exchange.
4- More data comparison of my Excel CVS file from all my products already on eBay with prices and quantities with my newer updated and created file. I will explain more later.
Please let me know if you recommend this project to be done with just Excel using VBA or macros or another simple solution, that I could be able to change simple stuff on my own.
Attached is just a sample file that I receive every week from my distributor.
Please let me know when we can chat and do a maybe teamviewer session, so I can show you more details about the project. My S k y p e is - ronald-melo in Florida
We will use Freelancer as a way to pay and track the project.
Thank you
Ron
Projekt ID: #11953247
Om projektet
31 freelancere byder i gennemsnit $456 timen for dette job
Hi Ron, my name is Sevinc. I read your "Work on Excel VBA/Macros with file updates and web scraping" project descriptions carefully before bidding. I checked all your requirements as well... I got what you need and r Flere
Hi: I have read your requirements. I believe that the comparison and data transfer part can be done via VBA/Macro. However, scrapping data from competitors would be an issue for VBA. It has some scrapping functions but Flere
Hello Web search ,Web scraping and data mining expert is here .I have done many similar scraping projects similar as website which you mentioned on description.I am able to complete your project at lower rate and qual Flere
Hello! I am a professional programmer with many years of web scraping experience using Python. I have read your project description, and I can create the Excel based Distribution program you require. To do so, I will u Flere
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Flere
Hi there, I’d like to be considered for your position. For 6 years I’ve worked in Engineering and so I am accustomed to working with all sorts of products and services, and in a variety of industries. I have a dee Flere
Hi, I'm experienced freelancer. Please check my profile. I would like to check the 3 websites that you need to scrape the products, could you please send them to me? I'm using python scripts for these jobs. Tomas
hello Ron I am an excel professional I will do your project by making simple spreadsheet if needed will apply macros.,
hello sir, I'm very helpful to work with this. please give a chance to prove it. I won't let you down. thank you!
Hello I have read what you exactly need. I would like to ask you a few questions. Please feel free to contact me anytime so we can have a detailed discussion and finalize our budget and timeline. I will deliver in best Flere
Respected Client, I am the one that you are searching. I am committed to work on your project as per your instructions. Please share your fair budget and and time frame for this project.
You want something excellent? I am in. Would you please let me start immediately? Or shall i start to another work?