Checking Product Coverage with the ICEcat system.

Oct 21, 2009 · 1 minute read
Category: icecat

This is post is now quite old and the the information it contains may be out of date or innacurate.

If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub

If you want to check coverage against ICEcat, the best thing to do is to import their dump file available here into a MySQL database.

The file format is a bit unusual, but here is a nice command you can run. You need to have created a database in it with a table called prodid_d

CREATE TABLE IF NOT EXISTS `prodid_d` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `part_number` varchar(255) NOT NULL,
  `brand` varchar(255) NOT NULL,
  `quality` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `model` varchar(255) NOT NULL,
  `ean` varchar(255) NOT NULL,
  `market_presence` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1

then in the command line (linux) run the follwing command:


mysqlimport --user=DBUSER --password=DBPASSWORD --columns=part_number,brand,quality,category,model,ean,market_presence --fields-terminated-by='\t\t\t' --replace  DBTABLE /ABSOLUTE/PATH/TO/prodid_d.txt