I am looking to hire someone to help set up a more efficient way to update item prices from a website wholesaler into a program like excel (doesn't have to be excel but something very user-friendly). Currently we are using a custom built bid program that uses prices we enter into it for our job bidding, but as the prices change monthly, we are trying to find a better way of updating these prices vs. doing them manually. I have been advised that one of the best ways to do this might be to set up a web query function/command in excel that will search the wholesaler's website ([url removed, login to view]) and update/retrieve an updated price for the items.
The good thing is that I have all the ~3,000 item names and codes in excel already so if there is a universal/easily modified function to update the prices, it should be not very hard to complete. The hard part might be to use the web query on a password protected site like the wholesalers, see more here ([url removed, login to view]). I am also emailing the wholesaler for an "API" for their online store, but I am unsure if they will provide it even to us as I do not know if that incurs a security risk to their company.
I have attached a sample picture of what we would need. The main thing in the picture that we would want to update is the Price column. The historic price chart was just an idea I had to make the charts more user friendly and able to be analyzed. If these are possible too, it would be a plus to any bid (but not required).
If you feel this project possible, please contact us/place a bid on the project. If you know of a better way to go about things in an easier way, please don't hesitate to give me your input. We are looking to hire immediately. Please have experience in the relative field of web querying and test a few from the site on your own prior to bidding. We will pay in increments through the freelancer site.
Thanks very much for your time
-----Here is a bit more background that I posted on a web help forums prior to this listing-----
I am trying to help out my Dad, who is a contractor, update bid prices of items he buys from a wholesale supplier. The way this is currently being done, and has been done for quite a many years, is by hand and manually searching the online website of the supplier ([url removed, login to view]) then updating items priced differently into his bid program. In essence, just making sure that the numbers he uses to bid with are accurate.
The problem is that my grandfather is usually the one in charge of this (he likes to do it and it gives him something to do), but his health and age are making it hard for him to do it much longer. There are also over 3,000 items in his bid program that my dad regularly bids with, so updating these are also becoming rather time consuming and inefficient.
The good thing is that the website has a very good database for prices and product codes, so finding items is not terribly hard and the product codes do not change. I have been giving it some thought and was wondering if there was any way to source the prices from the online database to an excel document or another program. Something that can make it automatically update/track the prices by command and not be such a burden to do by hand.
EDIT: I am nearly finished compiling a list of all the parts and codes into an excel sheet for the project needs. We were hoping to just have a way to source the price into the final column in an user-friendly way. If you are interested in the project, please take a look at the excel sheet to get a better idea at what we would want. You can also trial a few of the codes at (http://www.ferguson.com/FergusonSearch/RecordList.action). Unfortunately, these prices are not the same as for what we get them for so trying to setup a login password with the wholesaler now (keep in mind this website has a login/password for it)
Thanks again everyone and message me with any inquiries into the project and if you know for certain the project is possible.
9 freelanceria on tarjonnut keskimäärin 356 $ tähän työhön
We are experts of similar data entry projects. Please view PMB for details. Thanks, The MQC - The Administrator removed this message for containing contact details which breaches our Terms of Service
I am very much interested to work with your concern and assure you that if given an opportunity, I will prove my efficiency, reliable, IN TIME WORK DELIVERY and 100% accuracy