CSV Import by UPC

[xpokorkb]

I was about to necro-post this thread, but decided against it, as what I'm asking is slightly different!

I have a MySQL database that contains the following structure:

Code: [Select]

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `system` enum('PS1','PS2','XBOX','XBOX360','N64','Wii') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `UPC-A` varchar(20) NOT NULL,
  `price_level` enum('used_price','complete_price','new_price') NOT NULL,
  `own` bit(1) NOT NULL DEFAULT b'1',
  `item-count` tinyint(4) NOT NULL DEFAULT '1',
  `imguri` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `reprint` bit(1) NOT NULL DEFAULT b'0',
  `notes` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `paid-value` decimal(4,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
I've gone through great lengths to ensure the UPC-A is correct, and was wondering if you could bring back the import feature that matches against UPC-A as opposed to names.

[matt]

Hmm the only issue I'd see here is that our UPC data is far from complete. There is a good chance the import wouldn't be able to match up most of the games. Are you looking at this as a one time import or something to use over and over?

[xpokorkb]

For me personally, over and over, but I wouldn't have any issues bombing my catalog on the site, and then re-uploading it.

Now I see why title matching is so important; most video game api's use that for UPC lookups.