Đã Đóng

Use excel URL list in PHP, Web Scraping, Add info to Excel File

I have an ecommerce website. I am using Cre_Loaded which I dont think is relevant here. Maybe though. My distributor releases an update of inventory only once every year. As a result products are bought on my site are out of stock frequently. When I called the company they said the only thing I can do now is currently check the website to see if the product is available. But I have around 2500 products so I can not do this for each one.

I have started a PHP script that will scrape content from the distributors and add the info to 2 different excels. If the product is out of stock. Add the product name, sku, Availability (Data "Out of Stock"), and URL to an excel file. If the product is in stock check to see if the product has multiple Pieces/Pkgs with it. If there are no Pieces/Pkgs, do nothing. If there are..ad the Sku, Product Name, # of Pieces, Price, and URL. I already have set up the file to actually scrape the info. Basically what I need is someone to...

Setup the array to take each URL from the excel list (or add the URLs to a mysql list. This may be easier, your choice. Then actually add what was requested above to the proper excel file.

As I said I have basically all the scraping done. Just need the code to add all info results to excel. and the array to do the process for every URL in the excel list. I started the code for adding to excel, but it does not edit the file, it creates a new one. You can create a new function or edit the one i already made, your choice.

I can def do this mysql, as you'll see from the code. But its finals time here at school and im short for time. But this project should not take long at all. Even adding the excel file to mysql for extraction should be quick (if you decide to do so). Please let me know how you plan use the URL list into the code...thanks.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

PHP Site

CRE Loaded v 6.2[08]

MySQL db

Need Excel 2003 files

Kĩ năng: Bất kì công việc gì, Kĩ thuật, MySQL, PHP, Kiến trúc phần mềm, Kiểm tra phần mềm, Web Hosting, Quản lý website, Thử nghiệm trang web

Xem nhiều hơn: website source code in php, website package price list, web scraping process, web scraping price, web scraping legal, web scraping hire, software in php, scraping web content, school website price, school 2007, project list in php, php script school, php school script, php my inventory, new hire check list, is php web scraping, how to set up an ecommerce site, how to hire a process server, how to check a php program, how long does it take to hire someone

Về Bên Thuê:
( 1 Nhận xét ) Ledgewood, United States

ID dự án: #3563676

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


See private message.

$63.75 USD trong 2 ngày
(7 Nhận xét)