update product_parents set vendorinventorywhen = now() where parentid = '2361'checking inventory...
Opening connection to Tony Lama...
Automatically checking vendor inventory...
1: 5 - b = 2
1: 5.5 - b = 11
1: 6 - b = 25
1: 6.5 - b = 39
1: 7 - b = 66
1: 7.5 - b = 58
1: 8 - b = 50
1: 8.5 - b = 58
1: 9 - b = 56
1: 9.5 - b = 31
1: 10 - b = 25
1: 6 - c = 0
1: 6.5 - c = 3
1: 7 - c = 5
1: 7.5 - c = 3
1: 8 - c = 4
1: 8.5 - c = 7
1: 9 - c = 2
1: 9.5 - c = 4
1: 10 - c = 3
Importing...
2: 5 - b = 2
2: 5.5 - b = 11
update products set vendorinventory = '11', vendorinventorywhen=now() where prodid = '44120'
2: 6 - b = 25
update products set vendorinventory = '25', vendorinventorywhen=now() where prodid = '44121'
2: 6 - c = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '44122'
2: 6.5 - b = 39
update products set vendorinventory = '39', vendorinventorywhen=now() where prodid = '44123'
2: 6.5 - c = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '29360'
2: 7 - b = 66
update products set vendorinventory = '66', vendorinventorywhen=now() where prodid = '54286'
2: 7 - c = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '44124'
2: 7.5 - b = 58
update products set vendorinventory = '58', vendorinventorywhen=now() where prodid = '44125'
2: 7.5 - c = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '29361'
2: 8 - b = 50
update products set vendorinventory = '50', vendorinventorywhen=now() where prodid = '57689'
2: 8 - c = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '44126'
2: 8.5 - b = 58
update products set vendorinventory = '58', vendorinventorywhen=now() where prodid = '44127'
2: 8.5 - c = 7
update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '44128'
2: 9 - b = 56
update products set vendorinventory = '56', vendorinventorywhen=now() where prodid = '55756'
2: 9 - c = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '44129'
2: 9.5 - b = 31
update products set vendorinventory = '31', vendorinventorywhen=now() where prodid = '44130'
2: 9.5 - c = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '44131'
2: 10 - b = 25
update products set vendorinventory = '25', vendorinventorywhen=now() where prodid = '44132'
2: 10 - c = 3
not inserting to prevent dup key 10 = 10
TIQ 447
update product_parents set vendorinventorywhen = now() where parentid = '2361'