i need a crawler to crawl these 4 websites
[login to view URL] = vendorId=1
[login to view URL] vendorId=2
[login to view URL] vendorId=3
[login to view URL] vendorId=4
i need to get category structure + product information and pictures - all the pictures of products
the data must be put into this mysql tables:
n_categories
n_products
CREATE TABLE `n_categories` (
`catId` int(11) NOT NULL auto_increment,
`categoryName` varchar(255) default NULL,
`parentId` int(11) NOT NULL default '0',
`vendorId` int(1) not null,
PRIMARY KEY (`catId`),
KEY `nc1` (`parentId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
REATE TABLE `n_products` (
`itemId` int(11) NOT NULL auto_increment,
`vendorItemSKU` varchar(255) default NULL,
`catId` int(11) NOT NULL default '0',
`accessoryName` text not null,
`accessoryDescription` text not null,
`linkURL` text not null,
`vendorId` int(1) not null,
`dateFound` date not null
) ENGINE=InnoDB DEFAULT CHARSET=utf8