update product_parents set vendorinventorywhen = now() where parentid = '7115'checking inventory...
Opening connection to Tony Lama...
Automatically checking vendor inventory...
1: 7 - d = 0
1: 7.5 - d = 13
1: 8 - d = 24
1: 8.5 - d = 25
1: 9 - d = 39
1: 9.5 - d = 58
1: 10 - d = 44
1: 10.5 - d = 72
1: 11 - d = 58
1: 11.5 - d = 20
1: 12 - d = 31
1: 13 - d = 21
1: 6 - ee = 3
1: 6.5 - ee = 3
1: 7 - ee = 0
1: 7.5 - ee = 2
1: 8 - ee = 0
1: 8.5 - ee = 5
1: 9 - ee = 16
1: 9.5 - ee = 24
1: 10 - ee = 2
1: 10.5 - ee = 16
1: 11 - ee = 4
1: 11.5 - ee = 8
1: 12 - ee = 10
1: 13 - ee = 3
Importing...
2: 7 - d = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '66454'
2: 7 - ee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '75921'
2: 7.5 - d = 13
update products set vendorinventory = '13', vendorinventorywhen=now() where prodid = '66455'
2: 7.5 - ee = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '56573'
2: 8 - d = 24
update products set vendorinventory = '24', vendorinventorywhen=now() where prodid = '56574'
2: 8 - ee = 0
update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '75922'
2: 8.5 - d = 25
update products set vendorinventory = '25', vendorinventorywhen=now() where prodid = '54008'
2: 8.5 - ee = 5
update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '56575'
2: 9 - d = 39
update products set vendorinventory = '39', vendorinventorywhen=now() where prodid = '54009'
2: 9 - ee = 16
update products set vendorinventory = '16', vendorinventorywhen=now() where prodid = '56576'
2: 9.5 - d = 58
update products set vendorinventory = '58', vendorinventorywhen=now() where prodid = '54010'
2: 9.5 - ee = 24
update products set vendorinventory = '24', vendorinventorywhen=now() where prodid = '54011'
2: 10 - d = 44
update products set vendorinventory = '44', vendorinventorywhen=now() where prodid = '56577'
2: 10 - ee = 2
update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '56578'
2: 10.5 - d = 72
update products set vendorinventory = '72', vendorinventorywhen=now() where prodid = '54012'
2: 10.5 - ee = 16
update products set vendorinventory = '16', vendorinventorywhen=now() where prodid = '54013'
2: 11 - d = 58
update products set vendorinventory = '58', vendorinventorywhen=now() where prodid = '54014'
2: 11 - ee = 4
update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '60850'
2: 11.5 - d = 20
update products set vendorinventory = '20', vendorinventorywhen=now() where prodid = '56579'
2: 11.5 - ee = 8
update products set vendorinventory = '8', vendorinventorywhen=now() where prodid = '60488'
2: 12 - d = 31
update products set vendorinventory = '31', vendorinventorywhen=now() where prodid = '54015'
2: 12 - ee = 10
update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '66456'
2: 13 - d = 21
update products set vendorinventory = '21', vendorinventorywhen=now() where prodid = '56580'
2: 13 - ee = 3
not inserting to prevent dup key 13 = 13
2: 6 - ee = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '54016'
2: 6.5 - ee = 3
update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '79120'
TIQ 498
update product_parents set vendorinventorywhen = now() where parentid = '7115'
