Track sales of every item in your store

Tracking average sales volume at the individual item level is probably the most valuable piece of inventory management data next to knowing how much of each item you have on hand. It is the key number that helps you determine how much inventory you really need to meet sales demand without guessing.

Real-Time Access to your Average Sales volume

As the screen shot from the main Search Results screen shows below, 'Avg Sales' is displayed in the spreadsheet-style table for every stock item, including those with attributes. This number is calculated by simply dividing the quantity of each item sold by the time period you determine to be most relevant for your individual store.

Take the Atomic Running Shoes product above for example. If you set your time period to 4 weeks and you sell 24 pairs of shoes in that window of time, your average sales will be 6 pairs per week. You can set the time period to whatever number you like. We recommend starting out with a very short window at first until you have logged enough sales data to establish longer term trends. Even after using the Kinetic Inventory Management software for a while, you may want to keep your time frame within a few weeks or months to keep your sales data up to date with current market conditions. This can be especially true if you sell products that are seasonal or cyclical in demand.

How does it work?

The average sales data is calculated automatically for every item in your store. Every time a customer successfully completes his or her order in osCommerce, the in-stock count is decreased by the number of items ordered and this new total is divided by your chosen time period to keep the 'Avg Sales' field up to date.

Also, because we use a familiar inventory spreadsheet layout style for displaying the data, you can easily sort the data by any of the columns you choose. This makes it very convenient for you to see at a glance what your top selling items are, to list all items in alphabetical order, or to see which items you have in the highest or lowest quantities. You can even sort by cost if you like.

Inventory management is an art as well as a science, but the more science you apply, the better the art will look. " -- PH