update product_parents set vendorinventorywhen = now() where parentid = '7276'checking inventory...
Opening connection to Tony Lama...
Automatically checking vendor inventory...
1: 7 - d = 0
1: 7.5 - d = 1
1: 8 - d = 6
1: 8.5 - d = 5
1: 9 - d = 8
1: 9.5 - d = 7
1: 10 - d = 7
1: 10.5 - d = 5
1: 11 - d = 8
1: 11.5 - d = 4
1: 12 - d = 4
1: 13 - d = 4
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 = 5
1: 9 - ee = 7
1: 9.5 - ee = 9
1: 10 - ee = 4
1: 10.5 - ee = 5
1: 11 - ee = 3
1: 11.5 - ee = 3
1: 12 - ee = 3
1: 13 - ee = 0
Importing...
2: 7 - d = 0
2: 7 - ee = 1
2: 7.5 - d = 1
2: 7.5 - ee = 2
2: 8 - d = 6
update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '74751'
2: 8 - ee = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '73188'
2: 8.5 - d = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '76286'
2: 8.5 - ee = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '75702'
2: 9 - d = 8
update products set vendorinventory = '8', vendorinventorywhen=now() where prodid = '75703'
2: 9 - ee = 7
update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '75704'
2: 9.5 - d = 7
update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '72763'
2: 9.5 - ee = 9
update products set vendorinventory = '9', vendorinventorywhen=now() where prodid = '74752'
2: 10 - d = 7
update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '72606'
2: 10 - ee = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '73009'
2: 10.5 - d = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '75705'
2: 10.5 - ee = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '72297'
2: 11 - d = 8
update products set vendorinventory = '8', vendorinventorywhen=now() where prodid = '72764'
2: 11 - ee = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '75923'
2: 11.5 - d = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '72298'
2: 11.5 - ee = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '75924'
2: 12 - d = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '75706'
2: 12 - ee = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '73010'
2: 13 - d = 4
not inserting to prevent dup key 13 = 13
2: 13 - ee = 0
2: 6 - ee = 0
2: 6.5 - ee = 0
TIQ 94
update product_parents set vendorinventorywhen = now() where parentid = '7276'