Checking Product Coverage with the ICEcat system.

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 <code>prodid_d</code> (
  <code>id</code> int(11) NOT NULL AUTO_INCREMENT,
  <code>part_number</code> varchar(255) NOT NULL,
  <code>brand</code> varchar(255) NOT NULL,
  <code>quality</code> varchar(255) NOT NULL,
  <code>category</code> varchar(255) NOT NULL,
  <code>model</code> varchar(255) NOT NULL,
  <code>ean</code> varchar(255) NOT NULL,
  <code>market_presence</code> varchar(255) NOT NULL,
  PRIMARY KEY (<code>id</code>)
) 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