I need a inventory stock-take app where the user will scan barcode of a product and update the product quantity in database.

Inventory Stock-take App description


*** Android App ***
• Login form - This form user will login to the app. He must enter username, password and select branch from a dropdown
• Once logged in the next form will display the branch details and a scan button.
• When click on scan button to scan a barcode on product this will retrieve the product from the inventory table.
• Then user need to enter the quantity and click save
• If barcode is not found in table, user can add this manually to the database by enter the description and quantity then click save.
• If there is no bar code on product user can add item manually without barcode. So only rack code, product description and quantity


***Backend****
• Users
Page where you can create so they can login in the app and the admin panel
• Branch
-On This page user need to define the Branch Store

Branch Fields:
id
Branch Code
Branch Name
Address

-Each Branch will have its own inventory/products record.
-User must be able to load inventory into the database from a xls or csv file
-User must be able to add/edit/delete items manually.
-User must be able to export inventory to xls

-Inventory Table fields:
id
Item Code – product code
Barcode – scanned barcode
Description – description of the product
Location – Branch location Code
Rack – Rack location/code
Quantity – Product quantity
Price – Product price
Stocktake_date – Date/time the stock were taken/scanned
Stocktake_by – User that has take the stock
Last_ modified by – User and date-time the item was updated
added_manualy - Items added manually. So not imported items