Đã Đóng

Price update project that queries online databases for price changes

Hello,

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

Tony

-----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.

Tony

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Excel, Thiết lập Bản thảo, Tìm kiếm web

Xem thêm: www freelancer com online job, www freelancer com main, www freelancer com forum, www find job online, wholesalers online, wholesalers com, wholesalers c&a, who can help me with php online, what to do to be a freelancer, what to charge as a freelancer, what should i charge as a freelancer, what is bit freelancer, what i need to know to be a freelancer, what freelancer changes, what do we have to do in freelancer com, what are bids on freelancer com, we trying to function, website company that prices website, web freelancer for hire, ways to be freelancer, want to do freelancer project, user test freelancer, updating my picture on freelancer, update freelancer com, universal freelancer

Về Bên Thuê:
( 0 nhận xét ) United States

Mã Dự Án: #1718604

9 freelancer đang chào giá trung bình $356 cho công việc này

Innovative116

Hi. Thank you for the invitation. Please check private message for more details.

$250 USD trong 3 ngày
(161 Đánh Giá)
7.4
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$225 USD trong 7 ngày
(48 Đánh Giá)
6.4
mrbrave

I have understood your requirements and am available to start off.I will provide you a vb.net based application for this [url removed, login to view] can feed produce code to application and application will search database and bringup Thêm

$80 USD trong 3 ngày
(126 Đánh Giá)
5.9
srinichal

Bid subject to change after further details

$250 USD trong 5 ngày
(28 Đánh Giá)
5.7
codersam

We are a team of dedicated, serious and highly experienced developers, 24x7 available. After reviewing your project requirement we are highly interested in your project. Please check your Private Message for more detai Thêm

$150 USD trong 3 ngày
(6 Đánh Giá)
5.4
artsnlogic

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

$250 USD trong 5 ngày
(12 Đánh Giá)
4.2
kmittal

I have done a good number of data analysis projects on freelancer, and am very comfortable with yours as well. Please see pm.

$250 USD trong 7 ngày
(4 Đánh Giá)
3.7
anyaservices

Dear Sir, We have developed a custom web crawler that can extract any data/image/sound/document/text from web pages or documents. This crawler is highly configurable, and each data extraction done by it is done t Thêm

$250 USD trong 14 ngày
(1 Đánh Giá)
2.4
C1Vd4W2Ox

Custom software development - <b><i>Removed by Admin</i></b>

$1500 USD trong 1 ngày
(0 Đánh Giá)
0.0
ox2na

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

$150 USD trong 5 ngày
(0 Đánh Giá)
0.0
tonmoydavid

To apply for this job. Have Ecxellent typing skiil. Hope you'll consider me. Thank you.

$250 USD trong 8 ngày
(0 Đánh Giá)
0.0