Mass inventory transfer from one store to another (via HQ?)

if you use the worksheet 330, you will need to add the items and quantities manually with a sql script in hq that would look something like this:

insert into worksheet_inventorytransfer (worksheetid,itemid,quantitytotransfer) select

where you would need to supply the worksheetid and transfer-from storeid

you would still need the computer > I just closed one store and need to transfer all the inventory back to the

primary store. I thought I would do this via HQ WS-330 (just transfer all qty>0)but I'm not given that option. What's the best way to do this? Transfer or combine databases?