Count

Inventory -> Physical Inventory -> Update Counts

Physical Inventory counts are store specific.

The bar-code of inventory SKUs entered in this form will be for the User's logged in store location. Bad read bar-codes or those of inventory that belongs to another store will result in a error message, so the user may set the item aside for a new price tag or for returning to correct store.

You can also scan the UPC for an inventory item if it's been entered into the QOH for a style.

The Update Count form contains a grid that holds the inventory items counted. The User may check the grid for accuracy of the bar-code read. It is also a great cross reference to check tag accuracy. The user may exit the form and return as often as needed. The count is automatically saved as the bar-code is entered with a default quantity of 1.

The user may enter/scan the same bar-code as many times as needed to match the actual count. For example you have have three pairs of the same style and size of shoe. The user could scan the bar-code three times.

Optionally a feature exists to manually change the count within the grid. Once the bar-code is entered, the user may click the Qty cell and enter any quantity as needed, in this example enter 3 for 3 pairs. The bar-code does not have to be read 3 times if the count is changed to the actual present number.

The count may be directly entered into the system in the Update Counts form OR imported via a file created with a portable smart scanner.

There are two upload formats supported, CSV file and Excel spreadsheet.

CSV Import File

A example template may be downloaded from the bottom of this form under CSV Import File for the user to see the format and possibly used for capturing the count.

Once the bar-codes are scanned, the data file of the scanner would be saved to the computer in this file format. Then Choose File, navigate and Select the file, then click Upload to pull the count data into the Count grid. Any existing data in the grid is not erased, but added to.

To use the CSV file, the uploaded file should be a CSV text file in this following format. Any portable scanner that can create this file may be utilized:

Barcode,Count
0000000059,1
0000000121
0000000225,3

The first line of the text file must be Barcode,Count

If you get this message "Cannot import due to incorrect column layout - please follow template" when uploading the CSV file, it usually means the first line: Barcode,Count is missing.

Excel Import File

Click Download Excel Count Table which contains all the inventory currently in EverywherBridal, with current quantity on hand counts. Update the QOH column in the spreadsheet with your actual QOH. Don't change any other data in the spreadsheet, only update the QOH column.

Once the spreadsheet is updated, click Choose File, navigate and Select the Excel file, then click Upload to pull the count data into the Count grid. Any existing data in the grid is not erased, but added to.

If an style bar-code is accidentally entered within the grid, it may be deleted from the count grid. The user would scroll the grid to the far right column where a DELETE button exists. Click DELETE to erase a row within the grid.