DROP TABLE IF EXISTS iceleads_tmp.tmp_nvidia_tag;
CREATE TABLE iceleads_tmp.tmp_nvidia_tag (
  `id`                         INT(11) NOT NULL AUTO_INCREMENT,
  `core_product_repository_id` INT(11)     DEFAULT NULL,
  `icecat_product_id`          VARCHAR(45) DEFAULT NULL,
  `mpn`                        VARCHAR(45) DEFAULT NULL,
  `ean`                        VARCHAR(45) DEFAULT NULL,
  `vendor_name`                VARCHAR(45) DEFAULT NULL,
  `vendor_id`                  INT(11)     DEFAULT NULL,
  `category_name`              VARCHAR(45) DEFAULT NULL,
  `category_id`                INT(11)     DEFAULT NULL,
  `tag`                        VARCHAR(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
  ENGINE =InnoDB
  DEFAULT CHARSET =utf8;
LOAD DATA LOCAL INFILE '/home/gleb/Downloads/tags nvidia-insides.csv'
INTO TABLE iceleads_tmp.tmp_nvidia_tag
CHARACTER SET 'utf8'
FIELDS TERMINATED BY '\t'
ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES
(`icecat_product_id`, `mpn`, `ean`, `vendor_name`, `category_name`, `tag`);

UPDATE iceleads_tmp.tmp_nvidia_tag tmp
  LEFT JOIN
  iceleads.core_product_repository core ON core.icecat_product_id = tmp.icecat_product_id
SET
  tmp.core_product_repository_id = core.id;

UPDATE iceleads_tmp.tmp_nvidia_tag tmp
  LEFT JOIN
  iceleads.vendor v ON v.name = tmp.vendor_name
SET
  tmp.vendor_id = v.id;

UPDATE iceleads_tmp.tmp_nvidia_tag tmp
  LEFT JOIN
  iceleads.category c ON c.name = tmp.category_name
SET
  tmp.category_id = c.id;

UPDATE iceleads_tmp.tmp_nvidia_tag t JOIN iceleads.core_product_alternative a ON t.mpn = a.mpn_alternative
SET t.core_product_repository_id = a.core_product_repository_id
WHERE t.core_product_repository_id IS NULL;

UPDATE iceleads_tmp.tmp_nvidia_tag t JOIN iceleads.core_product_ean e ON t.ean = e.ean
SET t.core_product_repository_id = e.core_product_repository_id
WHERE t.core_product_repository_id IS NULL;

UPDATE iceleads_tmp.tmp_nvidia_tag tmp
  LEFT JOIN
  iceleads.core_product_alternative alt ON alt.mpn_alternative = tmp.mpn
  LEFT JOIN
  iceleads.core_product_repository core ON core.id = alt.core_product_repository_id
SET
  tmp.core_product_repository_id = core.id
WHERE
  tmp.core_product_repository_id IS NULL
  AND tmp.vendor_id = core.vendor_id;