update product_parents set vendorinventorywhen = now() where parentid = '7235'checking inventory...
Opening connection to Tony Lama...
Automatically checking vendor inventory...
1: 9 - b = 1
1: 9.5 - b = 5
1: 10 - b = 1
1: 10.5 - b = 4
1: 11 - b = 5
1: 11.5 - b = 2
1: 12 - b = 0
1: 13 - b = 0
1: 7 - d = 11
1: 7.5 - d = 15
1: 8 - d = 99
1: 8.5 - d = 99
1: 9 - d = 99
1: 9.5 - d = 99
1: 10 - d = 99
1: 10.5 - d = 99
1: 11 - d = 99
1: 11.5 - d = 99
1: 12 - d = 99
1: 13 - d = 99
1: 14 - d = 7
1: 15 - d = 2
1: 6 - ee = 0
1: 6.5 - ee = 0
1: 7 - ee = 18
1: 7.5 - ee = 25
1: 8 - ee = 73
1: 8.5 - ee = 99
1: 9 - ee = 99
1: 9.5 - ee = 99
1: 10 - ee = 99
1: 10.5 - ee = 99
1: 11 - ee = 99
1: 11.5 - ee = 99
1: 12 - ee = 99
1: 13 - ee = 77
1: 14 - ee = 0
1: 15 - ee = 0
Importing...
2: 9 - b = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '80162'
2: 9 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55649'
2: 9 - ee = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55017'
2: 9.5 - b = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '80163'
2: 9.5 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55650'
2: 9.5 - ee = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55018'
2: 10 - b = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '57310'
2: 10 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '60366'
2: 10 - ee = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55019'
2: 10.5 - b = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '71463'
2: 10.5 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '56499'
2: 10.5 - ee = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55020'
2: 11 - b = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '77250'
2: 11 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '60367'
2: 11 - ee = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55021'
2: 11.5 - b = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '57311'
2: 11.5 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55022'
2: 11.5 - ee = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55023'
2: 12 - b = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '80164'
2: 12 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55024'
2: 12 - ee = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55025'
2: 13 - b = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '80165'
2: 13 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55026'
2: 13 - ee = 77
update products set vendorinventory = '77', vendorinventorywhen=now() where prodid = '55027'
2: 7 - d = 11
update products set vendorinventory = '11', vendorinventorywhen=now() where prodid = '56091'
2: 7 - ee = 18
update products set vendorinventory = '18', vendorinventorywhen=now() where prodid = '56092'
2: 7.5 - d = 15
update products set vendorinventory = '15', vendorinventorywhen=now() where prodid = '55028'
2: 7.5 - ee = 25
update products set vendorinventory = '25', vendorinventorywhen=now() where prodid = '55029'
2: 8 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55030'
2: 8 - ee = 73
update products set vendorinventory = '73', vendorinventorywhen=now() where prodid = '55031'
2: 8.5 - d = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55032'
2: 8.5 - ee = 99
update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55033'
2: 14 - d = 7
update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '55034'
2: 14 - ee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '55035'
2: 15 - d = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '56093'
2: 15 - ee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '55036'
2: 6 - ee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '55037'
2: 6.5 - ee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '55038'
TIQ 2028
update product_parents set vendorinventorywhen = now() where parentid = '7235'