Articles in this section

Inventory Overview

Avatar
InventoryLab Team
  • Updated
Follow

FBA & Merchant Overview

Unlisted Inventory Overview

Inventory Accounting for FBA or Merchant Inventory

Inventory Accounting - Unlisted Inventory

Fulfilled by Amazon (FBA), Merchant Fulfilled (Merchant), and your Unlisted Inventory each have their own page that can be navigated to from the Inventory tab in InventoryLab.

 

mceclip0.png

FBA & Merchant Overview

Inventory updates on the FBA and MFN pages approximately every 3 hours throughout the day by syncing your current inventory from Amazon. You can see the last time a sync was performed (in PDT) at the top of the page.

 

On the FBA or Merchant page, you can change the Status field to All, Active, Has Alert, or Out of Stock to change the view of the inventory status. 

 

 

Switch the view on the Inventory page between Accounting and Management by clicking on the View drop down and selecting your view choice.

 

 

The page is searchable by ASIN, MSKU, Title, or by scanning the UPC.

The default view is All units (both active and out of stock) for Status, and the Accounting View.

 

FBA & MFN Inventory - Accounting View

The following columns make up the main Inventory pages in Accounting View:

  • Title (also shows ASIN, FNSKU, and any Alerts for that item)
  • MSKU
  • On Hand
  • Replens (number of replenishments for that MSKU)
  • List Price
  • Active Cost/Unit
  • Active Supplier
  • Active Date Purchased

The Cost/Unit, Supplier, and Date Purchased of the item reflects the buy cost of the next to be sold unit.

The information cannot be manually edited from the main page, but clicking on any of the data under the following headers will take you to the Replenishments page:

  • MSKU
  • Replens
  • Active Cost/Unit
  • Active Supplier
  • Active Date Purchased

If you click on the Active Cost/Unit, Active Supplier, or the Active Date Purchased for an item you will be taken to the current Cost/Unit sequence InventoryLab is using. 

 

A bar graph at the bottom of the page displays when you have inventory in stock. By mousing over each colored section of the graph, this will display the supplier, total buy cost from that supplier and the percentage of the total buy cost for that supplier (as shown below). 

 

Total In-Stock Buy Cost - This is a calculation of the on hand totals multiplied by the buy cost of the sort sequence that the quantity belongs to. Each total is added up for each MSKU to create the sum of the Total In-Stock Buy Cost.


Total In-Stock Sales Value - This is a calculation of the on hand totals multiplied by the list price of an MSKU. Each total is added up for each MSKU to create the sum of the Total In-Stock Sales Value. 

 

The Alert Icon indicates that there may be an issue with your replenishments for that particular item, and that what Amazon (plus your inbound inventory) is showing for your inventory levels isn't matching the total that Stratify indicates. The link is clickable, and will take you to the Replenishments page and display the information that caused the alert. 

 

To get to the Replenishments Page, click on the Alert Icon, MSKU, Replens number, or the Active Cost/Unit, Supplier, or Date Purchased.

 

 

The Replenishments Page shows the following:

Status - This displays when the sort sequence is Depleted (all quantities used), Active (the current sequence information being used), or In Queue (the sequence is still waiting to be used).

Replenishments - This displays which sequence the replenishment is in. There is the Initial or First Purchase, then the Replenishments are numbered in order by Purchased Date.

Origin - This displays the day in which the sequence was listed or last edited.

Cost/Unit - The cost/unit of the sequence.

Supplier - The supplier of the sequence.

Date Purchased - The purchase date of the sequence.

Initial Quantity - The total quantity of items within the sequence.

Remaining - The remaining quantity of the sequence that has yet to be used. You can click this number to view all of the orders, refunds, and reimbursements that used up the quantities within the sequence.

 

InventoryLab_-_FBA_Inventory.png

 

Actions: Split - This allows you to split quantities of a sort sequence.

Actions: Delete - This allows you to delete an entire sort sequence.

 


 

The Replenishments Page also shows information if there are any alerts for that item, displayed in the upper right corner of the page. This box will be red in color if there is an alert, and grey if there are no alerts regarding your inventory quantities. 

 

When you mouse over the alert box, an informational drop down details the reason for the alert:

This will also display if you click on the Alert Icon from the main inventory pages. 

 

For more information on what could cause an alert, our Replenishment Quantity Totals Are Different From Amazon article gives you more information.  

 

FBA & MFN Inventory - Management View

The following columns make up the main Inventory pages in Management View:

  • Title (also shows ASIN, FNSKU, and any Alerts for that item)
  • MSKU
  • On Hand
  • Replens
  • Reminder Date
  • Notes (associated with the Reminder Date)
  • Replenish Lead Time (an area to enter lead time to track an MSKU in your Velocity Report)
  • Print

There is also a bar graph at the bottom which functions the same as in the Accounting view.

 

Unlisted Inventory Overview

Main Unlisted Inventory Page

mceclip2.png

Items on the main page can be sorted by Item, MSKU, Avg Cost/Unit, Condition, And Available Quantity by clicking on the arrows to the right of each heading: 

mceclip6.png

The following columns make up the Unlisted Inventory page:

  • Item checkbox to select item
  • Item (also shows image, ASIN, and any Tags for that item)
  • MSKU
  • Avg Cost/Unit
  • Condition
  • Unlisted Quantity

mceclip0.png

The top right section contains the search field, which allows searching of your current Unlisted Inventory by:

  • Title
  • ISBN
  • ASIN
  • Tags with # 
  • Keywords

Clicking on the Advanced Search icon: 

mceclip4.png

Brings up the Advanced Search box that allows you to search by specific Keywords or Tags without the #: 

mceclip5.png

The Advanced Search is a simpler way to search for multiple tags since you don't have to use the # in front of the tag like you do in the main search field.

Adding or Deleting Unlisted Inventory

In the upper right corner of the page, the vertical ellipsis allow you to export the Unlisted Inventory page but also give you the option to add to the page via import: 

mceclip1.png 

For more information on using the Import Export tool, check out this article: 

Unlisted Inventory - Bulk Import Unlisted Inventory Using a .CSV

You can also add items manually via the bottom of the main Unlisted Inventory page using the Add Item button: 

mceclip7.png

For more information on Adding Items to your Unlisted Inventory manually via the Add Item button, check out our support article on that topic:

Unlisted Inventory - How to Add Items Manually

To Delete Items from Unlisted Inventory page, select the box to the left of the items you wish to delete: 

mceclip2.png

If you want to delete ALL of the items, select the check box in the top left corner, which will select all of your Unlisted Inventory: 

mceclip3.png

Once you have selected items on the page, the Delete button will appear in the bottom center of the page, along with a count of the number of items you have selected: 

mceclip4.png

Once you click on Delete, you will be asked to confirm this before the deletion takes place: 

mceclip7.png

Unlisted Inventory Item Detail Page

Clicking anywhere on the item line on the main Unlisted Inventory page (except for the ASIN, which opens up the Product Detail page for that item if an ASIN is entered) will open up the Item Detail Page: 

mceclip3.png

 The item detail page will display a header at the top with information about the item that includes: 

Below the product information, each purchase of the item is listed including:

  • Purchase Date
  • Expiration Date (if applicable)
  • Supplier
  • Cost per Unit
  • Purchased Quantity
  • Remaining Quantity 

Below this section is an Add Purchase button to add any further purchases of this item manually. Unlisted Inventory - How to Add Items Manually has more information on this topic.

At the bottom of the page is listed the: 

  • Average Cost per Unit
  • Total Remaining Quanity
  • Remaining Value (based on cost)

Inventory Accounting - FBA or Merchant

You can manually update your accounting details in your FBA or Merchant Inventory pages one-by-one, from the Replenishment page. For information on doing this, view the below article:

Adding Individual Cost per Unit, Supplier, or Date Purchased Manually

Updating your costs by import is also available, but you will only be able to do this if you do not have any Replens.

The import process will make changes to details such as buy cost, purchased date, and supplier. 

For information on bulk importing your accounting data to the Inventory page, view the below article:

How to - Bulk Import Accounting Details into Inventory via .csv

Inventory Accounting - Unlisted Inventory

At this time, you can only update the cost, purchase date, supplier, and other information manually on the Unlisted Inventory page. 
To modify the information for any item on your Unlisted Inventory page, click anywhere on the line for that item (except for the ASIN link, which will open the Amazon.com product detail page) to display the Item Detail page. 
mceclip8.png
You can then modify the fields listed here for: 
  • Purchase Date
  • Expiration Date (if applicable)
  • Supplier
  • Cost/Unit
  • Purchased Quantity
  • Remaining Quantity
Unlisted Inventory - Adding Multiple Buy Costs details how to add multiple costs to this page. 

0 comments

Article is closed for comments.