Inventory Reports

ShippingEasy REPORTS include a number of preconfigured reports. These reports accommodate the reporting needs of most shipping operations. They can also be scheduled to be emailed to you on a recurring basis. Though the columns cannot be edited or rearranged, they make for easy access to your inventory data. [Learn more about REPORTS.]

To generate an Inventory Report, navigate to the PRODUCTS tab from anywhere in ShippingEasy by hovering and then selecting REPORTS.

Product Reports

ShippingEasy offers a number of Inventory Reports to help track stock. The following Inventory Reports can be found on the INVENTORY MANAGEMENT page. Click through the following sections to learn what data is included in each report.

Available to Existing Inventory Management Subscribers

This feature is only available to existing Inventory Management subscribers. Non-Inventory Management subscribers can learn more about using the ShippingEasy Product Catalog.

At this time, we are not currently developing new features or functionality for our Inventory solution. This means that at this time we cannot address the issues you have with the current system. However, we do expect that in 2022, we will be introducing a new and improved Inventory experience.

Inventory Status report

The Inventory Status report provides inventory data on active products with Inventory Tracking enabled. A use case example for this report would be to help determine the value of shrinkage, the difference between book inventory and physical inventory due to counting or recording errors, or loss resulting from spoilage or theft.

Inventory Status reports are sorted alpha-numerically by SKU.

Products Included:

  • Active SKUs

  • Bundled SKUs

  • Variant SKUs

Inventory Data included:

  • SKU

  • Item Name

  • Unit Wholesale Price

  • Stock

  • Committed

  • Available (Available minus Committed)

  • Total Inventory Value (This is based on the SKU's Unit Wholesale Price and Stock quantity)

  • Category

  • Warehouse Bin (displays the current Warehouse Bin from the Product Catalog)

Inventory Data excluded:

In some cases, data may be excluded.

  • No data is reported for SKUs that are inactive.

  • No inventory value is reported for bundle SKUs since the inventory value is already accounted for the SKUs that make up the bundles.

  • If the Until Wholesale Price of a SKU is $0.00 then the Inventory Value will be default also be $0.00.

  • No category value is reported for SKUs that do not have a product category assigned to them in the Product Catalog.

  • All data is current, no historical data for inventory is reported.

Inventory Low Stock report

The Inventory Low Stock report provides inventory data on all active products that have a Shortage of zero or greater. This is the best tool for determining which products need to be ordered each week when you are contacting your supplier. The report works best if you have specified a low stock threshold. [Learn more about stock thresholds.]

If a low stock threshold has not been specified, we will default to 0 for all merchant fulfilled stock and one for FBA products as low stock thresholds.

Low Stock reports are sort alpha-numerically by SKU.

Products Included:

  • Active SKUs

  • Bundled SKUs

  • Variant SKUs

Inventory Data included:

  • SKU

  • Item Name

  • Stock

  • Committed

  • Available

  • Threshold

  • Shortage

  • Awaiting

  • Category

Date Excluded:

In some cases, data may be excluded:

  • All data is current, no historical data for inventory is reported.

  • No data is reported for SKUs that are inactive.

  • No data is reported for SKUs that do not have a low stock.

  • No category value is reported for SKUs that do not have a product category assigned to them in the Product Catalog.

Linked Stores by Product Report

This report provides data on all active products that have at least one linked store. A linked store means that there is a connection between the product SKU in ShippingEasy and the product SKU on the store. This connection allows for updates when there are changes in the stock levels.

Linked Stores by Products reports are sorted alpha-numerically by SKU.

Products include:

  • Active SKUs

  • Bundled SKUs

  • Variant SKUs

Inventory Data included:

  • SKU: SKU of the product

  • Master SKU: This column will have a value when the SKU is an alias, otherwise the cell will be blank

  • Name: Name of the product

  • Store: Store Name of the store that is linked to the product

  • Store Type: Store Type (or platform) of the store that is linked to the product

  • Link Status: Indicator of the link status, this column will display one of the following values:

    • Active: Product is linked to the store

    • Inactive: There is an issue with the product link to the store

    • Unlinked: ShippingEasy is unable to find the SKU in the current product catalog on your store

Note

If you see "Inactivate" or "Unlinked", this could mean that the product was changed on the store and it needs to be re-linked to ShippingEasy. Please reach out to ShippingEasy Customer Success for assistance.

Data Excluded:

In some cases, data may be excluded:

  • No data is reported for SKUs that do not have at least one store linked.

  • No data is reported in the Master SKU column for products that are not aliases. [Learn more about SKU Aliases here.]

Products Committed by Date report

The Products Committed by Date report provides inventory data on all active products based on a specified date range. This is the best tool for estimating inventory needs when preparing for a busy season to make sure you have enough stock on hand to keep up with projected volume.

All data is current, no historical data for inventory is reported.

Products Committed by Date reports are sorted alpha-numerically by SKU.

Products Include:

  • Active SKUs

  • Bundled SKUs

  • Variant SKUs

Inventory Data included:

  • SKU

  • Item Name

  • Current Stock

  • Committed by Date (This is the Committed amount based on the specific date range)

  • Available by Date (Current stock minus Committed by Date)

  • Current Low Stock Threshold

  • Shortage by Date (Current Low Stock Threshold minus Available by Date)

  • Category

  • Warehouse Bin

Data Excluded:

In some cases, data may be excluded:

  • No data is reported for SKUs that are inactive.

  • No category value is reported for SKUs that do not have a product category assigned to them in the Product Catalog.

Comments

Add a Comment

Please sign in to leave a comment.

    Tags:
  • sku
  • inventory
  • stock
  • data
  • answerbot_article_public
  • comprehensive_reporting
  • create report
  • create_report
  • Download_report
  • inventory details
  • inventory info
  • inventory information
  • Products
  • data_report
  • data report