Our blog

 

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

PLAIN TEXT
SQL:
  1. CREATE TABLE IF NOT EXISTS `prodid_d` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `part_number` varchar(255) NOT NULL,
  4.   `brand` varchar(255) NOT NULL,
  5.   `quality` varchar(255) NOT NULL,
  6.   `category` varchar(255) NOT NULL,
  7.   `model` varchar(255) NOT NULL,
  8.   `ean` varchar(255) NOT NULL,
  9.   `market_presence` varchar(255) NOT NULL,
  10.   PRIMARY KEY (`id`)
  11. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1

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

PLAIN TEXT
CODE:
  1. 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

More Reading:

 

Leave a Reply