uplandsdynamic / simple-stock-management Goto Github PK

hi Anistance
thanks for your system
but i got this eror Unable to configure handler 'file'

i think there some of directories not found

Disable form submission when stock quantity field is empty.

Previous behaviour was that a zero stock quantity was submitted in that case.

• "Lowlight" data table rows where the product line is out of stock (i.e. different font colour).
• Change presentation of "0" stock to "Out of Stock".

When the request quantity exceeds the current remaining stock, this error message is currently displayed:

Ensure this value is greater than or equal to 0.

Amend this to display a dedicated and more accurate descriptive message for this case.

Fix a bug where multiple users updating the database at same time could cause discrepancy between quantity requested and quantity actually deducted ("transferred") from the database.

An update regression resulted in the greying out of form fields for adding new stock.

Add feature to allow xfer of stock between stores.

#2 must have been completed first.

Number of units successfully transferred is not included in the JSON API response. Fix that.

Integration with the ShopWired e-commerce service.

Implement a full transaction log & expose it to end user administrators.

Useful for being able to retrospectively interrogate full details of stock transfer requests (dates, times, quantities etc) in the event notification emails are not delivered to the warehouse store admins, for whatever reason.

Notification emails are not being sent when stock is transferred.

• Add a mandatory wait time of n seconds in between stock transfer requests, to prevent duplicate transfer requests being actioned in the event of web browser issues and double button clicks.

• Rather than send an email every time to the admin user(s) every time a transfer is requested, batch requests and delivery in a single email.

#Preliminary scope

Backend

Add database for each 'store manager' user. Change stock xfer process to add units to store database, rather than simply delete from warehouse database (as currently the case). Add a 'stocktake' process to calculate a report, as detailed below.

Database schema

Duplication of warehouse database schema, with exception of:

+ 'opening_stock' column
+ 'closing_stock' column
+ 'xfer_price' column (unit price of stock as xferred)
+ 'selling_price' column (current unit price of stock as sold in the shop)
- 'unit_price' column

Report generation

Recorded data

• Opening stock (opening_stock as of datetime of last stocktake)
• Closing stock (closing_stock as of datetime 'now' at current stocktake process)

Processed data

Values for each line

a) Differential for all sales & loss (opening_stock - closing_stock)
b) Xfer price value for all units lost or sold ((opening_stock - closing_stock) * xfer_price)
c) Selling price value for all units lost or sold ((opening_stock - closing_stock) * selling_price)
d) Differential between total xfer price & total selling price, for a line ( (c) - (b) ) *See note (1)

Values for total store

e) Total xfer price value of all stock lines sold or lost since last stocktake process (Σ(b))
f) Total selling price value of all stock lines sold or lost since last stocktake process (Σ(c))
g) Total differential for all stock lines, between xfer price & selling price (Σ(d)) *See note (1)

Database maintenance processes

• Following completion of stocktake process, closing_stock data is copied to opening_stock, then emptied.

UI

Build a dedicated UI for store databases, to allow store managers to:

• View their own store's stock holding record
• Submit a stock count (closing_stock) & trigger the generation of stocktake reports

Notes

1. Whilst the differential may be indicative of a store's sales performance, it cannot be considered "profit", because actual sales, shrinkage and loss (both known and unknown) are not recorded. Therefore, the differential is not synonymous with sales and profit in this model. It may merely suggest that, had the differential consisted entirely of sales at the selling price - with no units being subject to loss or shrinkage - the differential would have been representative of "store profit" under those improbable circumstances.

Clicking on the 'back' and 'forward' pagination buttons (chevrons) results in "network error".

The pagination indicator on the UI correctly updates, however the actual data does not, with the table retaining the data of the original page.

Both of the other options for changing page (entering the new page number in the input field, or clicking on the new page number in on the numbers list) do work correctly.

Clean up presentation, such as partially rendered input field border.

• Upload spreadsheet file from the UI
• Parse the spreadsheet for stock data for an account
• Insert the stock data into the account's database

The width of the stock management modal for the store accounts appears too narrow on certain OS/browsers/displays. Further investigation & fix required.

Reported affected: Windows/Firefox (display information as yet unknown).

When an administrator attempts to edit the stock quantity field, they are unable to use 'backspace' to delete the existing entry entirely (the increment/decrement buttons do work, as does highlighting the existing quantity before over-typing).

Fix this to allow backspace to delete the existing quantity, as is the case on the manager's transfer form.

If there are multiple administrators on the system, the admins receive unrequited notification email following an inventory update by another admin. Fix that.