Megaventory Blog - Online Inventory Management Software, Order fulfillment and Control System
This is the company blog for megaventory, an online software that helps small businesses that buy, sell and manufacture physical products to manage sales, purchasing, manufacturing and inventory. We blog about new features and updates but also about enterprise software, small businesses, cloud computing and the industry in general.

Wednesday, February 29, 2012

New Feature: Import of Bills of Materials from Excel

For those of our users who are into manufacturing and are utilizing the Works module of megaventory, we are excited to announce that we have introduced the feature to import Bills of Materials from an Excel template.

When the Data Import page loads up, the Bills of Materials icon is now visible as shown below:
The new Bill of Materials Import tool Screen

After choosing the Bill of materials option, the user gets prompted to download an excel template. This is how the simple Excel Template looks like.
Excel Template for Importing Bills of Materials

Just fill in the data and you're good to go!

Note that the Bill of Materials import tool may be used both for inserting new Bills of Materials and for updating existing Bills of Materials. However, a BOM update is possible when certain conditions are met; for example, when no Work Order exists for the Finished Good SKU of which we intend to update its BOM.

So here you go! We hope you will enjoy the new feature and please do send us your feedback and suggestions if you think there is room for improvement.