Work on Excel VBA/Macros with file updates and web scraping
$250-750 USD
Awarded
Posted over 7 years ago
$250-750 USD
Paid on delivery
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
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 ready to go ahead as soon as we can clarify further project details. I will write a java code to exchange data btw websites & csv/excel; coupled with excel vba to reorganize data wthin excel...
I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating.
Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too...
I bid my best for you to start business, and ready to start once you give me a reply...regards.
Dear sir,
I am scraping expert, I have did too many scraping projects, please check my reviews then you will know.
Can you tell me more details? then I will provide example data/script for you.
Thanks,
Kimi
Hi there - My name is Paris.
I've read your brief and can see that you'd like to have a presentation. I have 7 years’ experience designing and developing PowerPoint and Prezi presentations. I would approach your project by creating 2-3 samples for you to choose. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
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 it is not very adept and prone to regular break-down. Hence, I would suggest Python for the scrapping part. Please note that I have 100% completion rate and 5-star feedback on projects. Please connect with me to discuss your requirements in detail.
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 quality result than other freelancers within short time.
Let me send you sample data in excel or csv file.
Best Regards
Hi,
I have more than 14 years of Excel/VBA exp and I am expert in this kind of work.
Please send me more details so that I can estimate cost and time better.
I have completed more than 290 projects.
Please look at the feedback left by my employers to know more about my work. Waiting for your positive response.
Thanks.
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 use the libraries Requests (for web automation tools), BeautifulSoup (for parsing html), and Selenium (for working with AJAX and Javascript). I have written very similar programs in the past, and I would be happy to show examples. Please contact me so we may speak further and so I can send files. Thank you for your consideration.
Hello
I'm interesting your project very well
I'm a Good C#, VBA, Excel, Scrap, Ebay API, Math, Algorithm expert.
I m quite well experienced in these jobs.
Let's go ahead with me
I want to service for you continously.
Thanks
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.
with thanks and regards
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 deep passion for research and guarantee that all of my work is 100% original.
I highly value professionalism and hold myself strictly accountable to represent my client’s brand.
I'm new at freelancer i need to strengthen my profile more importantly then the payment that's why i always bid the lowest.
Please, let me know what is needed to secure this bid!
Thank you for your consideration
Murad Eltaher
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 Sir/ Madam
Greetings,
My name is Mahdi. I know I am a new member here and maybe my profile is not very trustworthy at the first glance but I am really looking for a chance to prove that my work is worth buying. I am very hard worker and can work effectively as fast as I can. I have excellent skills in Data Entry, Web Research and Microsoft Office. Product upload to E-Commerce, Woo Commerce, Amazon, EBay. Please contact me if you are interested in my work. It is a pleasure if ever you will message me for an interview. I can work as soon as possible. Looking forward for your response.
Thank you!
Regards
Mahdi
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 possible way.
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.
My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. I can show you some examples of my work. Please contact me to discuss your project.