update product_parents set vendorinventorywhen = now() where parentid = '7242'checking inventory...
Opening connection to Tony Lama...
Automatically checking vendor inventory...
1: 7 - d = 0
1: 7.5 - d = 9
1: 8 - d = 39
1: 8.5 - d = 49
1: 9 - d = 92
1: 9.5 - d = 86
1: 10 - d = 99
1: 10.5 - d = 99
1: 11 - d = 99
1: 11.5 - d = 15
1: 12 - d = 61
1: 13 - d = 23
1: 14 - d = 19
1: 15 - d = 5
1: 6 - ee = 0
1: 6.5 - ee = 6
1: 7 - ee = 0
1: 7.5 - ee = 2
1: 8 - ee = 10
1: 8.5 - ee = 12
1: 9 - ee = 22
1: 9.5 - ee = 8
1: 10 - ee = 39
1: 10.5 - ee = 25
1: 11 - ee = 43
1: 11.5 - ee = 9
1: 12 - ee = 18
1: 13 - ee = 20
1: 14 - ee = 1
1: 15 - ee = 1
Importing...
2: 7 - d = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '55078'
2: 7 - ee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '55079'
2: 7.5 - d = 9
update products set vendorinventory = '9', vendorinventorywhen=now() where prodid = '55080'
2: 7.5 - ee = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '55081'
2: 8 - d = 39
update products set vendorinventory = '39', vendorinventorywhen=now() where prodid = '55082'
2: 8 - ee = 10
update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '55083'
2: 8.5 - d = 49
update products set vendorinventory = '49', vendorinventorywhen=now() where prodid = '55084'
2: 8.5 - ee = 12
update products set vendorinventory = '12', vendorinventorywhen=now() where prodid = '55085'
2: 9 - d = 92
update products set vendorinventory = '92', vendorinventorywhen=now() where prodid = '55086'
2: 9 - ee = 22
update products set vendorinventory = '22', vendorinventorywhen=now() where prodid = '55087'
2: 9.5 - d = 86
update products set vendorinventory = '86', vendorinventorywhen=now() where prodid = '55088'
2: 9.5 - ee = 8
update products set vendorinventory = '8', vendorinventorywhen=now() where prodid = '55089'
2: 10 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55090'
2: 10 - ee = 39
update products set vendorinventory = '39', vendorinventorywhen=now() where prodid = '55091'
2: 10.5 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55092'
2: 10.5 - ee = 25
update products set vendorinventory = '25', vendorinventorywhen=now() where prodid = '55093'
2: 11 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55094'
2: 11 - ee = 43
update products set vendorinventory = '43', vendorinventorywhen=now() where prodid = '55095'
2: 11.5 - d = 15
update products set vendorinventory = '15', vendorinventorywhen=now() where prodid = '55096'
2: 11.5 - ee = 9
update products set vendorinventory = '9', vendorinventorywhen=now() where prodid = '55097'
2: 12 - d = 61
update products set vendorinventory = '61', vendorinventorywhen=now() where prodid = '55098'
2: 12 - ee = 18
update products set vendorinventory = '18', vendorinventorywhen=now() where prodid = '55099'
2: 13 - d = 23
update products set vendorinventory = '23', vendorinventorywhen=now() where prodid = '55100'
2: 13 - ee = 20
update products set vendorinventory = '20', vendorinventorywhen=now() where prodid = '55101'
2: 14 - d = 19
update products set vendorinventory = '19', vendorinventorywhen=now() where prodid = '66525'
2: 14 - ee = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '55102'
2: 15 - d = 5
not inserting to prevent dup key 15 = 15
2: 15 - ee = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '55103'
2: 6 - ee = 0
2: 6.5 - ee = 6
update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '55104'
TIQ 906
update product_parents set vendorinventorywhen = now() where parentid = '7242'