I gang

Products crawler into mySQL DB

We need products crawler into mySQL DB

Crawl the following 7 web sites

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

and save product data into mySQL Database with the following structure:

--

-- Create schema products_crawling

CREATE DATABASE IF NOT EXISTS products_crawling;

USE products_crawling;

-- Definition of table `products`

DROP TABLE IF EXISTS `products`;

CREATE TABLE `products` (

`website_product_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`website` varchar(80) NOT NULL,

`website_product_url` varchar(500) NOT NULL,

`product_category` varchar(250) NOT NULL,

`product_sku` varchar(40) NOT NULL,

`product_model` varchar(40) NOT NULL,

`product_features` text NOT NULL,

`product_name` varchar(200) NOT NULL,

`product_description` text NOT NULL,

`product_overview` text NOT NULL,

`product_specification_text` text NOT NULL,

`product_specification_html` text NOT NULL,

`product_manufacturer_warranty` varchar(40) NOT NULL,

`product_manufacturer_website_url` varchar(500) NOT NULL,

`product_manufacturer_website_support_url` varchar(500) NOT NULL,

`product_manufacturer_website_product_url` varchar(45) NOT NULL,

`product_brochure1` varchar(150) NOT NULL,

`product_brochure2` varchar(150) NOT NULL,

`product_brochure3` varchar(150) NOT NULL,

`product_brochure4` varchar(150) NOT NULL,

`product_video_url` varchar(250) NOT NULL,

`product_image_path1` varchar(150) NOT NULL,

`product_image_path2` varchar(150) NOT NULL,

`product_image_path3` varchar(150) NOT NULL,

`product_image_path4` varchar(150) NOT NULL,

`product_image_path5` varchar(150) NOT NULL,

`product_stock_level` varchar(20) NOT NULL,

`product_price` float NOT NULL,

`product_rrp` float NOT NULL,

`product_created_ts` datetime NOT NULL,

`product_updated_ts` datetime NOT NULL,

`product_status_cd` smallint(5) unsigned NOT NULL,

PRIMARY KEY (`website_product_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Product Categories must be saved on MySQL DB in the following format Category > SubCategory > SubSubCategory…

Product images must be downloaded into separate folders for each web site and image paths should be saved on MySQL DB.

Product video URLs must be saved on MySQL DB

Crawler must have 2 modes:

Full – each products details information crawled and stored on DB

List – all categories crawled and only stock level and price stored on DB for all existing products and for new products stored information only available from the List.

Færdigheder: MySQL, PHP

Se mere: product crawler definition, mysql database crawler, mysql db, key data structure, definition data structure, data structure definition, create products, create category subcategory php, mysql crawler, stock categories, website crawler, products video, price crawler, null, float, drop products, db, database crawler, data crawler, crawler, mysql estore, web data crawler, mysql create database engine, mysql structure, php save image database

Om arbejdsgiveren:
( 13 bedømmelser ) Lawnton, Australia

Projekt-ID: #1003779

Tildelt til:

topleaseu

Scraping talent. Pls check the PM. Thank you, Jin

$250 USD in 7 dage
(12 bedømmelser)
4.1

18 freelancere byder i gennemsnit $576 for dette job

SigmaVisual

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

$540 USD in 7 dage
(237 bedømmelser)
7.8
psenthilkumar

Expert Here , please check inbox!

$500 USD in 5 dage
(119 bedømmelser)
7.3
MAnkita

Hello,Please refer your PMB.Thank you.

$560 USD in 10 dage
(49 bedømmelser)
6.5
$750 USD in 7 dage
(48 bedømmelser)
6.3
wildlily980

I can do it.

$600 USD in 15 dage
(40 bedømmelser)
6.0
ITGynis

Please check PMB.

$700 USD in 10 dage
(19 bedømmelser)
5.7
aruhat

Hello Please see PM. Regards, Chandni

$1000 USD in 10 dage
(12 bedømmelser)
5.0
tamrakar81

Hi, Please check PM . Thanks , T

$550 USD in 10 dage
(30 bedømmelser)
4.9
cbssales

Hello, We will be keen in taking this up. We will provide you with single point of contact, who will be available on skype or any other IM's. Kindly check the PMB. Regards, Credent Team.

$900 USD in 30 dage
(4 bedømmelser)
4.3
waisol

Web scraping experts. Please check PMB for details.

$500 USD in 14 dage
(7 bedømmelser)
4.0
rajeev0507

I am interested in doing this job.....

$325 USD in 7 dage
(2 bedømmelser)
3.4
pherada

check your PMB

$600 USD in 5 dage
(1 bedømmelse)
1.0
captainbenno

Hey there, I am a web developer with 15 years experience and I can certainly do this particular job but please read my pm.

$700 USD in 5 dage
(0 bedømmelser)
0.0
yehia111111

hi sir,i can do this for you.

$300 USD in 5 dage
(0 bedømmelser)
1.7
softcoder05

Dear Buyer, We are the team of 15-20 People including developers and designers. Our team includes experienced persons in field of different technologies. Our Customer set belongs to Europe, USA , Australia and many oth Mere

$500 USD in 25 dage
(0 bedømmelser)
0.0
sshafiq

I have done similar work for departmental stores in us so i have an idea how to do it but timeline may vary depending on the complexity of the mentioned websites.

$600 USD in 20 dage
(0 bedømmelser)
0.0
phpexpertravi

Dear Sir Please Check ur PMB

$500 USD in 6 dage
(1 bedømmelse)
0.0