readeral / netoupdater Goto Github PK

A drag and drop Neto API integration for handling CSV files, and updating stock levels for Neto SKUs.

Live application can be found here: https://readeral.github.io/netoupdater/

Built with ReactJS

Dependencies: React Dropzone, React Radio Group, PapaParse

Both development and production builds utilise https://cors-anywhere.herokuapp.com/, due to the changing nature of the target API URL. As such, it is subject to usage limits and not recommended as a permanent solution. It is recommended that for regular use, you fork this project and deploy on your own server, resolving CORS issues that way.

My aim has been to create something that would enable warehouse staff to drag and drop a CSV when the stock arrives (typically a 'restock alert report' file), and assuming everything ordered is delivered, to submit for immediate updates of all stock in the file.

• The application accepts only CSV files, with at least two columns, one 'SKU' column, and another column with stock values (it can be labelled however you like, just update the parameters in app to look for your column header)
• Presently the CSV file requires the stock column to be the first column
• The CSV can include more than these two columns, and will be safely ignored by the App.

Currently there are a few limitations that need to be observed for use:

• The console currently does not 'track' with the updated data, meaning errors are not discoverable without scrolling first. This is my highest priority for fixing.
• The stock qty column must be the leftmost field of the CSV fix implemented - now it will traverse all columns to find target column.
• The stock qty field parameter must be set Case-Sensitively
• There is presently no support for drag and drop of multiple files at once - however there is support for adding multiple files if dragged one at a time.
• The application will allow resubmission of data if the 'Update Quantity' button is pressed a second time before resetting.
• There is no test/warning for lack of/partial parameters present fix implemented - now you get a console error when clicking Update/Get with incorrect parameters.

Please read the limitations above before use.

1. Click the 'parameters' button (below the console) and enter your Neto details (URL, API key, and CSV qty field name - defaults to 'Reorder Quantity'). These details are stored per session, and are not cleared when clicking 'reset'.
2. Set your update method for your next CSV upload (defaults to 'increment', default can be changed via parameter screen) - can be increment, set or decrement
3. Drag and drop your CSV file onto the drop field, and use the output on the right hand side of the screen to check all is well (adding files one after the other will display the preview reverse-chronologically, with the first added at the bottom)

• 3a. Drag and drop additional CSVs, setting update method per file

4. Optional - click 'get quantity' to see the current quantities for all SKUs listed in the submitted CSV
5. Optional - preview the API call to be sent to server
6. Click Update Quantity to send your new values to your database
7. Optional - click 'get quantity' to see the changed quantities
8. Click Reset to do clear submitted data and to do a new batch of updates.