Monitoring stock levels
To check availability for a product across locations in your business:
- Go to
- Type the product SKU or the name of the product, in the search bar
and press Enter. The
ATPcolumns display the stock levels across your stores and distribution centers.
Based on inventory transactions such as receiving inventory, transfers, adjustments, or customer returns, NewStore updates the ATP for such items in the store.
To sort the products in the search results by a column, click the column header. Specify additional criteria to sort by a size, color, location, price range, on hand stock, safety stock, ATP quantity, item reservations and allocations. Each header you click is added to the current filter as filter criterion.
The stock levels page does not differentiate the products based on stores and locales and displays data from the most recent import. It means that the stock levels can have data from different stores and locales.
Stock column descriptions
Product name: The name of the product.
Product ID: The product ID of the item. If the product ID is the same as the SKU in your business, you'll see the same identifier in both fields. This field is not displayed in the
Stock Levelspage and not included in the export, if it is not configured for display for your business.Technical configurationThe following section involves working with technical configurations and APIs. Contact your IT support team for more information.
To add the product ID to the export, see Displaying product ID .
SKU: The identifier of the product.
Size: The size of the product.
Color: The main color of the product.
Price: The price of the product.
Location: The ID of the
locationthat sells this product.
In Stock: The
stock. This is the quantity of the item that was available for sale at the location, on the date and time of the last inventory sync displayed in
Last Stock Import.
Reserved: The quantity of this item that is reserved for delivery, at the location.
Allocated: The number of
allocationson this item at the location. After a mispick, the quantity allocated to the mispicked items is reduced from the number of allocations displayed.
Safety Stock: The quantity of this item that is not included in the ATP and is set aside at the location as a buffer, to avoid overselling. After a mispick, values for both the
In Stockcolumn and the safety stock level that was set remain unchanged.
Current ATP: The real-time quantity that is available at the location, to be routed for fulfillment. This number is calculated by subtracting the sum of all
safety stockquantity from the stock. After a mispick, this is set to
0till the next stock update.
Future ATP: The quantity of this item that will be available at the location on a specified future date. The value of this column is based on
future inventoryfor the item at the fulfillment location. When setting up
pre-orders for your business, use future inventory to determine the number of products that can be sold as pre-orders before the product becomes available for sale. See Managing pre-orders .
Future Availability Date: The date when the quantity of items specified in
Future ATPwill be available for delivery at the fulfillment location.
Total ATP: The total quantity of items available, including both real-time (specified in
Current ATP) and in the future (specified in
In Stockvalue is greater than
0, then the fulfillment location is disabled for order fulfillment.
Last Stock Import: The date and time when the last stock import was performed.Important
If NewStore is
inventory masterin the store, this column displays
-. If the store switches from using an ERP as inventory master to using NewStore, the date and time is removed after ATP is updated for the product. For more information on how
stock on handand ATP are updated when NewStore is inventory master, see Choosing your inventory master .
Last Mispick: The last time this item was
mispicked. Provide a date range to see the products that were mispicked within the specified duration. The status of a mispick is updated and
-is displayed in the following cases:
cycle countinventory operation
When stock on hand for the product is updated in the storenote
When NewStore is inventory master, stock on hand is updated based on inventory operations in the store. When an ERP is inventory master, stock on hand is updated when stock is imported into the store or DC.
Monitoring stock for mispicked items
Mispicked Stock page displays products that were
mispicked via NewStore Fulfillment App. Provide a date range
to see if the product was mispicked within the specified duration.
After a mispick, values change in the following way:
In Stock: The values set for both these columns for the specified location remain unchanged.
ATP: Set to
0till the next stock update.
Stock updates like the following transactions in the store will update the ATP for the mispicked items:
- Receiving transactions, transfers, and adjustments in inventory
- Customer returns
Allocated: The quantity allocated to the mispicked items is reduced.
Managing safety stock
Stock Levels page displays
safety stock of
products across your stores and distribution centers.
When you update safety stock for a store, it affects the
stock on hand
ATP. You can check their latest values in the
Stock Levels page
after importing safety stock.
When you don't define store locations in the safety stock CSV file, upon import the safety stock is updated in the platform for across locations in your business.
Exporting safety stock
You can export a safety stock CSV file from NewStore Omnichannel Manager to view and update safety stock levels for a store.
To export safety stock:
Go to the
Catalog > Stock Levelspage.
Export Safety Stock.
safety-stock-export.csvfile is downloaded. You can make changes to this file and import the updated CSV file into NewStore Omnichannel Manager.
The CSV file contains stock-level information, which is displayed in the
Stock Levels page, such as product IDs, store locations, safety stock
quantity, and so on.
See this example CSV for more information. You can upload a new or updated CSV file with a maximum size of 10 MB.
Importing safety stock
You can update safety stock levels for products in a store by importing a CSV file into NewStore Omnichannel Manager.
To import safety stock:
Go to the
Catalog > Stock Levelspage.
Import Safety Stock.
Importdialog box that appears, select a CSV file for upload.
Refer to this example CSV to create or update CSV files for importing safety stock data.
Importto continue importing the safety stock in the NewStore platform.
The status of the import appears on the screen.
You can also use the Stock API to programmatically export or import safety stock, and check the status of a safety stock import.