We need to create a simple stock take module to integrate with our inventory system; our inventory is very large (100k) and therefore we need to be able to look up products live.
The software has API hence we can use the API to upload products into the database (this can also be done via excel) and the output can be in Excel (CSV).
The module can be done to run a live server or off line (laptop).
Essentially these are the steps:
Scan product and check if it is in the database. If yes then add to the csv list (along with some parameters) if not then create product ( we will create a template for imputing the correct data).
The graphic layout can be very simple black/white as it is just for internal use.
We will provide a flow chart and excel templates. Please feel free to contact us for further discussion.