update product_parents set vendorinventorywhen = now() where parentid = '7260'checking inventory...
Opening connection to Tony Lama...
Automatically checking vendor inventory...
1: 9 - b = 2
1: 9.5 - b = 3
1: 10 - b = 5
1: 10.5 - b = 3
1: 11 - b = 1
1: 11.5 - b = 4
1: 12 - b = 2
1: 13 - b = 1
1: 6 - d = 1
1: 6.5 - d = 0
1: 7 - d = 3
1: 7.5 - d = 0
1: 8 - d = 1
1: 8.5 - d = 6
1: 9 - d = 14
1: 9.5 - d = 20
1: 10 - d = 14
1: 10.5 - d = 10
1: 11 - d = 15
1: 11.5 - d = 2
1: 12 - d = 10
1: 13 - d = 10
1: 14 - d = 1
1: 15 - d = 2
1: 6 - ee = 2
1: 6.5 - ee = 1
1: 7 - ee = 1
1: 7.5 - ee = 0
1: 8 - ee = 2
1: 8.5 - ee = 8
1: 9 - ee = 4
1: 9.5 - ee = 7
1: 10 - ee = 6
1: 10.5 - ee = 9
1: 11 - ee = 4
1: 11.5 - ee = 1
1: 12 - ee = 6
1: 13 - ee = 4
Importing...
2: 9 - b = 2
2: 9 - d = 14
update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '55210'
2: 9 - ee = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '67833'
2: 9.5 - b = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '55211'
2: 9.5 - d = 20
update products set vendorinventory = '20', vendorinventorywhen=now() where prodid = '57691'
2: 9.5 - ee = 7
update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '67066'
2: 10 - b = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '69339'
2: 10 - d = 14
update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '66136'
2: 10 - ee = 6
update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '66137'
2: 10.5 - b = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '82299'
2: 10.5 - d = 10
update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '66138'
2: 10.5 - ee = 9
update products set vendorinventory = '9', vendorinventorywhen=now() where prodid = '66139'
2: 11 - b = 1
2: 11 - d = 15
update products set vendorinventory = '15', vendorinventorywhen=now() where prodid = '57692'
2: 11 - ee = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '66140'
2: 11.5 - b = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '69340'
2: 11.5 - d = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '55212'
2: 11.5 - ee = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '82553'
2: 12 - b = 2
2: 12 - d = 10
update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '69341'
2: 12 - ee = 6
update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '70914'
2: 13 - b = 1
2: 13 - d = 10
not inserting to prevent dup key 13 = 13
2: 13 - ee = 4
not inserting to prevent dup key 13 = 13
2: 6 - d = 1
2: 6 - ee = 2
2: 6.5 - d = 0
2: 6.5 - ee = 1
2: 7 - d = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '69342'
2: 7 - ee = 1
2: 7.5 - d = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '69343'
2: 7.5 - ee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '77270'
2: 8 - d = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '69344'
2: 8 - ee = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '71978'
2: 8.5 - d = 6
update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '66141'
2: 8.5 - ee = 8
update products set vendorinventory = '8', vendorinventorywhen=now() where prodid = '66142'
2: 14 - d = 1
update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '75918'
2: 15 - d = 2
TIQ 158
update product_parents set vendorinventorywhen = now() where parentid = '7260'
