The Restock Inventory Report gives users an overview of their inventory levels, recent sales data, and restock recommendations. We obtain the inventory data from Amazon's restock report and calculate restock needs based on recent sales data and user settings.

What criteria does ConnectBooks use to suggest reordering?

ConnectBooks generates this report using recent sales data and the information you entered in the inventory settings on the product page.

User Input:

Reorder Days: The number of days' worth of stock you aim to have before placing a new order.
Safety Stock: The additional amount of stock you want to keep on hand as a buffer to prevent stockouts.
Lead Time: The time it takes for you to receive new stock from your supplier.

Sales Calculation:

Additionally, ConnectBooks analyzes your sales data to calculate your average daily sales, excluding any days when you were out of stock. By combining these inventory settings and sales metrics, ConnectBooks can provide an accurate and comprehensive inventory report.

Understanding Default Report columns

Item name	The FNSKU of the item
SKU	The product SKU
Total	The total quantity of the item (Its calculated by taking the Available + Inbound + Reserved)
Inbound	The quantity of the product that is currently being shipped to Amazon's fulfillment centers.
Available	The quantity of the product that is currently available for sale on Amazon
Reserved	The total qty reserved. When you hover over reserved you see 3 categories
	Reserved FC transfer- The quantity of products that are between fulfillment centers
	Reserved FC processing - The quantity of products that are processing to enter fulfillment centers.
	Reserved customer order - The quantity of the product reserved for unshipped orders.
Days Of supply	An estimate of how many days your current inventory will last based on recent sales data.
Reorder date	The suggested date to reorder the product to avoid running out of stock (This is a combination of sales data and user input)
Reorder Qty	The recommended quantity to reorder based on current sales and inventory levels. (This is a combination of sales data and user input)
Asset value	The asset value of the inventory
% of asset	The percentage of the total inventory asset value represented by this product.
Gross sales	The total sales revenue generated by the product over a specified period.
Average daily sales	The average sales revenue per day for the product.
Sales Qty	The total number of units sold over a specified period.
Average daily quantity	The average number of units sold per day.
Profit	The total profit generated from the sales of the product.
Cost	Cost of the product (data will only be displayed if the item has sales).
ROI	The Return on Investment, calculated as the ratio of profit to cost.
Inventory turnover rate	The rate at which your inventory on Amazon is sold and replaced over a specified period (FBA only)

Customization options

Column chooser:

Select and deselect any data you want to include or exclude from your report.

Customize Report:

Click on "Customize Report" to tailor the report to your business needs with the following options.

Select how you want to display item names
Group items by ASIN, Parent ASIN, Categories, Buyers, and Seasons.
Select order date or posted date transaction type.

Days of sales data:

Enter the number of days ConnectBooks should analyze to provide you with an accurate average daily sales recommendation.

Choose the cost type; Quickbooks latest cost, Quickbooks average cost, or ConnectBooks cost.
Option to ignore prep cost from the asset value calculation.
Option to exclude inbound shipments from the total and asset value calculation.