Messages

1

Site Feedback / Re: CSV Import by UPC

« on: November 08, 2014, 04:34:56 pm »

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.

2

Site Feedback / CSV Import by UPC

« on: November 07, 2014, 03:32:38 pm »

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.