update product_parents set vendorinventorywhen = now() where parentid = '7228'checking inventory...
Opening connection to Tony Lama...
Automatically checking vendor inventory...
1: 7 - d = 5
1: 7.5 - d = 4
1: 8 - d = 9
1: 8.5 - d = 10
1: 9 - d = 15
1: 9.5 - d = 14
1: 10 - d = 23
1: 10.5 - d = 39
1: 11 - d = 44
1: 11.5 - d = 25
1: 12 - d = 29
1: 13 - d = 16
1: 6 - ee = 2
1: 6.5 - ee = 2
1: 7 - ee = 3
1: 7.5 - ee = 4
1: 8 - ee = 2
1: 8.5 - ee = 1
1: 9 - ee = 16
1: 9.5 - ee = 25
1: 10 - ee = 28
1: 10.5 - ee = 13
1: 11 - ee = 14
1: 11.5 - ee = 9
1: 12 - ee = 9
1: 13 - ee = 11
Importing...
2: 7 - d = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '54902'
2: 7 - ee = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '54903'
2: 7.5 - d = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '70959'
2: 7.5 - ee = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '54904'
2: 8 - d = 9
update products set vendorinventory = '9', vendorinventorywhen=now() where prodid = '70960'
2: 8 - ee = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '54905'
2: 8.5 - d = 10
update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '54906'
2: 8.5 - ee = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '54907'
2: 9 - d = 15
update products set vendorinventory = '15', vendorinventorywhen=now() where prodid = '66384'
2: 9 - ee = 16
update products set vendorinventory = '16', vendorinventorywhen=now() where prodid = '54908'
2: 9.5 - d = 14
update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '66385'
2: 9.5 - ee = 25
update products set vendorinventory = '25', vendorinventorywhen=now() where prodid = '54909'
2: 10 - d = 23
update products set vendorinventory = '23', vendorinventorywhen=now() where prodid = '66386'
2: 10 - ee = 28
update products set vendorinventory = '28', vendorinventorywhen=now() where prodid = '54910'
2: 10.5 - d = 39
update products set vendorinventory = '39', vendorinventorywhen=now() where prodid = '54911'
2: 10.5 - ee = 13
update products set vendorinventory = '13', vendorinventorywhen=now() where prodid = '54912'
2: 11 - d = 44
update products set vendorinventory = '44', vendorinventorywhen=now() where prodid = '54913'
2: 11 - ee = 14
update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '54914'
2: 11.5 - d = 25
update products set vendorinventory = '25', vendorinventorywhen=now() where prodid = '54915'
2: 11.5 - ee = 9
update products set vendorinventory = '9', vendorinventorywhen=now() where prodid = '66387'
2: 12 - d = 29
update products set vendorinventory = '29', vendorinventorywhen=now() where prodid = '54916'
2: 12 - ee = 9
update products set vendorinventory = '9', vendorinventorywhen=now() where prodid = '66388'
2: 13 - d = 16
not inserting to prevent dup key 13 = 13
2: 13 - ee = 11
update products set vendorinventory = '11', vendorinventorywhen=now() where prodid = '54917'
2: 6 - ee = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '54918'
2: 6.5 - ee = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '54919'
TIQ 356
update product_parents set vendorinventorywhen = now() where parentid = '7228'