Items Inventory Merging

Hello

I plan to items merging into one because some items have in common, transactions conducted is without journal entry only summation quantity items and average cost items.
in addition to table 0_stock_master and 0_stock_moves whether there are other table that must be considered.

Thanks and Best Regard

/Jujuk