brummett/couchstore

A CouchDB app for managing a small business store

couchstore's Issues

Add a "Need to Purchase" report

It should show non-obsolete items with 0 or less in inventory.

It should show items part of unshipped orders where there isn't enough to fill the order

It should show items where the current inventory count is less than how many were sold in the last month.

It should show items where the current inventory count is less than sold in the same month last year

Move tests

Move the tests up to the same level as "manager" and add more tests. Since changing to use update() handlers it should be more testable

Editing a shipment leads to wrong items

When editing a shipment, the item count gets changed for items that get manipulated in the form. For items you don't touch, even if they're in the "shipping items" table, they do not appear in the order doc after submitting the form

Notification box needs to be fixed to the top of the window

That way you can see it even if you're scrolled down to the bottom of the page

Interface with Amazon to get new orders and save confirmed orders

The old system could import new order reports and generate reports for confirmed orders

Item history report layout

"Date" needs to be filled it

Rename "Number" to "order number"

In the receive/sale order form, auto-highlite the first text entry box

The other forms should do this too

Make a "Popular Items" report

It should show a list of items sorted by how many were sold (descending - most popular on top) during some time period.

Also include a drop-down box to select order sources like "Amazon", "walk-in", etc, or "All"

Shipment summary report should show the shipping carrier

that is all

Link the "Shipments" lister with the confirm shipment page

For shipments with no tracking number - so the user can confirm the shipment there

Scan barcodes from the camera

The attached camera should be able to scan barcodes in the order widget

Make a common error() handler to show notifications

For all the ajax()y requests (list, show, view, etc), have a common error handler to show notifications to the user that can correctly parse the JSON response that validate_doc_update() and others return.

For example, instead of showing "Error: Forbidden" when submitting a change when they're not logged in, the should see "Error: You must be logged in to make changes"

Add "Carrier method" input to the confirm shipment form

under the Carrier drop-down.

Show it on the shipment summary report.

Error messages from DB update handlers aren't propagated to the user

Started after the switch to update() handlers for most DB alterations.

We'll need to change throw() in the update handlers to instead return a data structure like this:
{ code: 403,
json: { reason: "Broke!", message: "On fire!" }
}

Then the error callback can get ahold of it

shows/shipment.js does this already

Sale order page should validate the shipping charge input

cost/prices should be validated in general for all forms.

Proposed correction list should link to the item history report

Inventory->Show partial inventories

The item names in the proposed corrections list should be links that bring up the item history report for that item

"Make a Shipment" should also print a packing list

Include what's packed in this shipment, what's backordered and what was in prior shipments

Current inventory report: "Count" is not correct

Looks like it's always adding quantities - Sale orders should subtract quantities to keep things balanced

Shipment summary report items should also be sorted by order-source

They're already sorted by date. Make the search key [ date, source] instead of just date

Login widget doesn't update when the DB logs the user out

When the user has been idle, couchDB logs the user out, but the UI doesn't indicate that

Reduce output must shrink more rapidly

After adding 30 or 40 sold items, all views start failing during reindexing with the above error.

Seems the reduce for the popular items views (item-count-by-selldate and item-count-by-ordersource-selldate) keeps growing the result object, even though each pass through does reduce to a single value.

Shipment data lister should show shipment details

The "Order Number" should be a clickable ling to bring up a modal showing the shipment details including packed items, date, carrier, tracking number, etc

confirm shipment page should make sure you put in a tracking number

Import data from the old system

Make a program to import item data from the old system (https://github.com/amb43790/SimpleInventory)

Investigate importing customer and order data, too

Track "reference number" for shipments

Either the "make a shipment" or "confirm shipment" pages should have an additional input for "Reference number".

For example, when sending shipments to Amazon, they have an identifier they use while waiting for the shipment.

Shipment summary report: page has no title

Set a page title that includes the date range. When saving to PDF, the file name will default to the page title

"commit inventory" changes

The cancel button should go to the home page

When there aren't any partial inventories, it should say something so you don't think your counts are all way off

Refactor the form submissions to go right to the update functions

Instead of having a sammy handler for handling form POSTs that do a POST or PUT to the databases's update() handler, have the forms submit right to the update handler. Then the update handler would have to redirect to the proper next page

Editing a partial inventory doesn't save

You get an error message: Conflict

Error messages from DB update handlers aren't propagated to the user

Started after the switch to update() handlers for most DB alterations.

We'll need to change throw() in the update handlers to instead return a data structure like this:
{ code: 403,
json: { reason: "Broke!", message: "On fire!" }
}

Then the error callback can get ahold of it

shows/shipment.js does this already

Item pictures

Allow the user to upload pictures of items, and show those pictures in the item lister and order tables

Scanning an unknown item should unfocus the barcode scan

For sale/receive/etc form.

Also, scroll the window to the unknown item

Interface doesn't go back to the order list after editing

Go to data->orders
click to edit an order
Click "all done"

It should go back to the order list, not the usual default action for the sale/receive order page

Shipment Box number does not change when making a shipment

The first shipment is #1, but then all the other shipments are also #1. It should start at #1 for the first shipment of the day, and increment after that.

Shipment lister dosen't show multiple shipments for the same order

Probably related to the duplicate checking

"Make a sale" page should allow shipment details, too

Would make for easier walk-in orders

Change info in shipment chooser

The drop-down in "Make a shipment" should show the order source instead of the warehouse

barcode scan should regain focus after adding item

In the sale/receive/etc forms, scan an unknown barcode, click the button to provide details.

When the form gets control back, the barcode scanbox should get the focus automatically

Refactor the Order and Shipment widgets to display item rows differently

Move the template/rendering code into the DB as a _show handler for item docs

Make a readme

to show up on the github page

delete shipment modal buttons are labeled wrong

The "ok" button should be red and called "Delete" like the other modals

Make it easier to add items to a shipment

Make a shipment page:

Change the button that moves item to/from the shipment. The existing button should change its glyph to a + or an arrow or something else, but still move one item at a time. Add a new button that moves all the items in or out of the shipment.

Item listers should scroll only the data, not the headers

When there gets to be zillions of items/orders/customers, it'll look better

Add customer name to the shipment summary report

Also maybe the address?

Make an expired stock form

It would work just like the warehouse transfer form

Used to remove items from inventory but not count them toward sales numbers

Move shipment "size" and "weight" inputs

Move the inputs fro size and weight to the "Make a shipment" page, but still show them on the confirm shipment page.

Form values should be run through the URI sanitizer

Characters like " aren't accepted in item name, for example

Order forms should have 2 columns for inputs

So the form header is shorter, you can see more items on the screen at the bottom

Shipment summary report: everyone is taxed

Only is-taxable customers should have tax applied

Shipment summary report: start date has no default value

The start/end dates should default to today