update product_parents set vendorinventorywhen = now() where parentid = '7273'checking inventory...
Opening connection to Tony Lama...
Automatically checking vendor inventory...
1: 7 - d = 1
1: 7.5 - d = 3
1: 8 - d = 8
1: 8.5 - d = 14
1: 9 - d = 17
1: 9.5 - d = 23
1: 10 - d = 26
1: 10.5 - d = 23
1: 11 - d = 21
1: 11.5 - d = 12
1: 12 - d = 15
1: 13 - d = 12
1: 6 - ee = 0
1: 6.5 - ee = 0
1: 7 - ee = 1
1: 7.5 - ee = 2
1: 8 - ee = 1
1: 8.5 - ee = 4
1: 9 - ee = 7
1: 9.5 - ee = 12
1: 10 - ee = 11
1: 10.5 - ee = 10
1: 11 - ee = 3
1: 11.5 - ee = 5
1: 12 - ee = 4
1: 13 - ee = 6
Importing...
2: 7 - d = 1
2: 7 - ee = 1
2: 7.5 - d = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '82013'
2: 7.5 - ee = 2
2: 8 - d = 8
update products set vendorinventory = '8', vendorinventorywhen=now() where prodid = '75217'
2: 8 - ee = 1
2: 8.5 - d = 14
update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '55340'
2: 8.5 - ee = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '67197'
2: 9 - d = 17
update products set vendorinventory = '17', vendorinventorywhen=now() where prodid = '55594'
2: 9 - ee = 7
update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '67198'
2: 9.5 - d = 23
update products set vendorinventory = '23', vendorinventorywhen=now() where prodid = '55750'
2: 9.5 - ee = 12
update products set vendorinventory = '12', vendorinventorywhen=now() where prodid = '57782'
2: 10 - d = 26
update products set vendorinventory = '26', vendorinventorywhen=now() where prodid = '56657'
2: 10 - ee = 11
update products set vendorinventory = '11', vendorinventorywhen=now() where prodid = '55595'
2: 10.5 - d = 23
update products set vendorinventory = '23', vendorinventorywhen=now() where prodid = '55341'
2: 10.5 - ee = 10
update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '55342'
2: 11 - d = 21
update products set vendorinventory = '21', vendorinventorywhen=now() where prodid = '56658'
2: 11 - ee = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '55751'
2: 11.5 - d = 12
update products set vendorinventory = '12', vendorinventorywhen=now() where prodid = '55752'
2: 11.5 - ee = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '68345'
2: 12 - d = 15
update products set vendorinventory = '15', vendorinventorywhen=now() where prodid = '55596'
2: 12 - ee = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '55753'
2: 13 - d = 12
update products set vendorinventory = '12', vendorinventorywhen=now() where prodid = '57925'
2: 13 - ee = 6
not inserting to prevent dup key 13 = 13
2: 6 - ee = 0
2: 6.5 - ee = 0
TIQ 230
update product_parents set vendorinventorywhen = now() where parentid = '7273'