update product_parents set vendorinventorywhen = now() where parentid = '2349'checking inventory...
Opening connection to Tony Lama...
Automatically checking vendor inventory...
1: 6 - 4e = 2
1: 6.5 - 4e = 2
1: 7 - 4e = 0
1: 7.5 - 4e = 2
1: 8 - 4e = 2
1: 8.5 - 4e = 3
1: 9 - 4e = 1
1: 9.5 - 4e = 2
1: 10 - 4e = 4
1: 10.5 - 4e = 1
1: 11 - 4e = 3
1: 11.5 - 4e = 1
1: 12 - 4e = 2
1: 13 - 4e = 0
1: 9 - b = 1
1: 9.5 - b = 1
1: 10 - b = 2
1: 10.5 - b = 4
1: 11 - b = 4
1: 11.5 - b = 4
1: 12 - b = 3
1: 13 - b = 1
1: 6 - d = 2
1: 6.5 - d = 2
1: 7 - d = 16
1: 7.5 - d = 18
1: 8 - d = 38
1: 8.5 - d = 63
1: 9 - d = 99
1: 9.5 - d = 99
1: 10 - d = 99
1: 10.5 - d = 98
1: 11 - d = 89
1: 11.5 - d = 44
1: 12 - d = 79
1: 13 - d = 56
1: 14 - d = 0
1: 15 - d = 8
1: 6 - ee = 2
1: 6.5 - ee = 0
1: 7 - ee = 5
1: 7.5 - ee = 2
1: 8 - ee = 14
1: 8.5 - ee = 18
1: 9 - ee = 34
1: 9.5 - ee = 48
1: 10 - ee = 56
1: 10.5 - ee = 47
1: 11 - ee = 40
1: 11.5 - ee = 14
1: 12 - ee = 25
1: 13 - ee = 10
1: 7 - eee = 3
1: 7.5 - eee = 1
1: 8 - eee = 2
1: 8.5 - eee = 2
1: 9 - eee = 0
1: 9.5 - eee = 0
1: 10 - eee = 1
1: 10.5 - eee = 0
1: 11 - eee = 0
1: 11.5 - eee = 0
1: 12 - eee = 0
1: 13 - eee = 3
Importing...
2: 6 - 4e = 2
2: 6 - d = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '72262'
2: 6 - ee = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '29347'
2: 6.5 - 4e = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '77253'
2: 6.5 - d = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '44051'
2: 6.5 - ee = 0
2: 7 - 4e = 0
2: 7 - d = 16
update products set vendorinventory = '16', vendorinventorywhen=now() where prodid = '44052'
2: 7 - ee = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '55414'
2: 7 - eee = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '59764'
2: 7.5 - 4e = 2
2: 7.5 - d = 18
update products set vendorinventory = '18', vendorinventorywhen=now() where prodid = '44053'
2: 7.5 - ee = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '81975'
2: 7.5 - eee = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '54006'
2: 8 - 4e = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '44055'
2: 8 - d = 38
update products set vendorinventory = '38', vendorinventorywhen=now() where prodid = '44054'
2: 8 - ee = 14
update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '54007'
2: 8 - eee = 2
2: 8.5 - 4e = 3
insert into products set internalid='854e1368941733', size = '8.5', int_size2 = '8.5',
altsize='4e',
int_altsize='4e',
vendorinventory = '3', vendorinventorywhen=now(), parentprodid = '0',
parentid = '2349',
autocreated = 'y',
color='black', singlepriceamt = '169.95'
2: 8.5 - d = 63
update products set vendorinventory = '63', vendorinventorywhen=now() where prodid = '44056'
2: 8.5 - ee = 18
update products set vendorinventory = '18', vendorinventorywhen=now() where prodid = '44057'
2: 8.5 - eee = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '70787'
2: 9 - 4e = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '73965'
2: 9 - b = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '55757'
2: 9 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '44034'
2: 9 - ee = 34
update products set vendorinventory = '34', vendorinventorywhen=now() where prodid = '44035'
2: 9 - eee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '76311'
2: 9.5 - 4e = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '44037'
2: 9.5 - b = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '56259'
2: 9.5 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '44036'
2: 9.5 - ee = 48
update products set vendorinventory = '48', vendorinventorywhen=now() where prodid = '34894'
2: 9.5 - eee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '55758'
2: 10 - 4e = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '55760'
2: 10 - b = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '55759'
2: 10 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '44038'
2: 10 - ee = 56
update products set vendorinventory = '56', vendorinventorywhen=now() where prodid = '44039'
2: 10 - eee = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '44040'
2: 10.5 - 4e = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '44042'
2: 10.5 - b = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '55761'
2: 10.5 - d = 98
update products set vendorinventory = '98', vendorinventorywhen=now() where prodid = '44041'
2: 10.5 - ee = 47
update products set vendorinventory = '47', vendorinventorywhen=now() where prodid = '34893'
2: 10.5 - eee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '76688'
2: 11 - 4e = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '83011'
2: 11 - b = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '55724'
2: 11 - d = 89
update products set vendorinventory = '89', vendorinventorywhen=now() where prodid = '44043'
2: 11 - ee = 40
update products set vendorinventory = '40', vendorinventorywhen=now() where prodid = '44044'
2: 11 - eee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '56424'
2: 11.5 - 4e = 1
2: 11.5 - b = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '44045'
2: 11.5 - d = 44
update products set vendorinventory = '44', vendorinventorywhen=now() where prodid = '44046'
2: 11.5 - ee = 14
update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '44047'
2: 11.5 - eee = 0
2: 12 - 4e = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '82044'
2: 12 - b = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '56260'
2: 12 - d = 79
update products set vendorinventory = '79', vendorinventorywhen=now() where prodid = '44048'
2: 12 - ee = 25
update products set vendorinventory = '25', vendorinventorywhen=now() where prodid = '56261'
2: 12 - eee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '44049'
2: 13 - 4e = 0
2: 13 - b = 1
2: 13 - d = 56
update products set vendorinventory = '56', vendorinventorywhen=now() where prodid = '44050'
2: 13 - ee = 10
update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '54005'
2: 13 - eee = 3
not inserting to prevent dup key 13 = 13
2: 14 - d = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '44058'
2: 15 - d = 8
update products set vendorinventory = '8', vendorinventorywhen=now() where prodid = '44059'
TIQ 1171
update product_parents set vendorinventorywhen = now() where parentid = '2349'
