Skip to content
Bitbit edited this page Aug 11, 2020 · 4 revisions

Welcome to the StockTake wiki!

Simple GUI interface for small retail format using excel for their inventory.

This python app can be used for taking physical stocktake with electronic scanner.

StockTake GUI

Requirements :

  • Python 3.6 and above
  • Openpyxl (a python library - _install using PIP_)
  • Tkinter for GUI

Usage is very simple

  1. Load excel sheet on startup
  2. Map columns to be searched in excel
  3. Create heading for Found,Excess and short status
  4. Map system quantity column in excel
  5. Start Scanning
  6. Save and exit app.
  7. Review stocktake in excel.

Happy Scanning!