update product_parents set vendorinventorywhen = now() where parentid = '7263'checking inventory...
Opening connection to Tony Lama...
Automatically checking vendor inventory...
1: 9 - b = 2
1: 9.5 - b = 1
1: 10 - b = 0
1: 10.5 - b = 3
1: 11 - b = 2
1: 11.5 - b = 2
1: 12 - b = 3
1: 13 - b = 1
1: 6 - d = 0
1: 6.5 - d = 1
1: 7 - d = 3
1: 7.5 - d = 6
1: 8 - d = 14
1: 8.5 - d = 17
1: 9 - d = 42
1: 9.5 - d = 32
1: 10 - d = 40
1: 10.5 - d = 29
1: 11 - d = 43
1: 11.5 - d = 11
1: 12 - d = 22
1: 13 - d = 21
1: 14 - d = 5
1: 15 - d = 3
1: 6 - ee = 0
1: 6.5 - ee = 1
1: 7 - ee = 2
1: 7.5 - ee = 1
1: 8 - ee = 3
1: 8.5 - ee = 6
1: 9 - ee = 9
1: 9.5 - ee = 15
1: 10 - ee = 15
1: 10.5 - ee = 11
1: 11 - ee = 15
1: 11.5 - ee = 4
1: 12 - ee = 9
1: 13 - ee = 4
Importing...
2: 9 - b = 2
2: 9 - d = 42
update products set vendorinventory = '42', vendorinventorywhen=now() where prodid = '55244'
2: 9 - ee = 9
update products set vendorinventory = '9', vendorinventorywhen=now() where prodid = '55663'
2: 9.5 - b = 1
2: 9.5 - d = 32
update products set vendorinventory = '32', vendorinventorywhen=now() where prodid = '55245'
2: 9.5 - ee = 15
update products set vendorinventory = '15', vendorinventorywhen=now() where prodid = '55246'
2: 10 - b = 0
2: 10 - d = 40
update products set vendorinventory = '40', vendorinventorywhen=now() where prodid = '55247'
2: 10 - ee = 15
update products set vendorinventory = '15', vendorinventorywhen=now() where prodid = '55248'
2: 10.5 - b = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '71111'
2: 10.5 - d = 29
update products set vendorinventory = '29', vendorinventorywhen=now() where prodid = '55249'
2: 10.5 - ee = 11
update products set vendorinventory = '11', vendorinventorywhen=now() where prodid = '55250'
2: 11 - b = 2
2: 11 - d = 43
update products set vendorinventory = '43', vendorinventorywhen=now() where prodid = '55251'
2: 11 - ee = 15
update products set vendorinventory = '15', vendorinventorywhen=now() where prodid = '56485'
2: 11.5 - b = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '66741'
2: 11.5 - d = 11
update products set vendorinventory = '11', vendorinventorywhen=now() where prodid = '55252'
2: 11.5 - ee = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '55253'
2: 12 - b = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '79888'
2: 12 - d = 22
update products set vendorinventory = '22', vendorinventorywhen=now() where prodid = '55254'
2: 12 - ee = 9
update products set vendorinventory = '9', vendorinventorywhen=now() where prodid = '57237'
2: 13 - b = 1
2: 13 - d = 21
update products set vendorinventory = '21', vendorinventorywhen=now() where prodid = '55255'
2: 13 - ee = 4
not inserting to prevent dup key 13 = 13
2: 6 - d = 0
2: 6 - ee = 0
2: 6.5 - d = 1
2: 6.5 - ee = 1
2: 7 - d = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '72198'
2: 7 - ee = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '72406'
2: 7.5 - d = 6
update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '57667'
2: 7.5 - ee = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '60853'
2: 8 - d = 14
update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '56486'
2: 8 - ee = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '66417'
2: 8.5 - d = 17
update products set vendorinventory = '17', vendorinventorywhen=now() where prodid = '55256'
2: 8.5 - ee = 6
update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '57668'
2: 14 - d = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '66418'
2: 15 - d = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '55257'
TIQ 386
update product_parents set vendorinventorywhen = now() where parentid = '7263'