This interface helps in generating the product stock report by a location, product title, SKU, category, brand, or shelf wise.

You can also download the generated product stock report in the 'Excel' or 'PDF' formats for further usage.

You can generate the report by Product wise or Shelf/Bin wise by selecting the suitable option from the Search By drop-down.
  • The Product wise stock report consists of the following information: SKU/Variant SKU, location, total stock, sellable stock (i.e. stock kept in Good Shelves), stock under picking process (i.e. stock segregated against the Authorized Orders), allocated stock, stock in the inward process, stock under Good/Bad QC, and return quantity.

  • Whereas, the Shelf/Bin wise report consists of the following information: SKU/Variant SKU, Category, Location, Zone, Shelf/Bin, and Total Stock.

How do I generate the stock report at my web store?


To generate the stock report at your web store, do the following:

  • Log in to the 'MartJack Control Panel' by using your User Name (Email Address) and Password.


 Product Stock Report

  • You will be navigated to the Dashboard page.


 Product Stock Report

  • Click the  Product Stock Report icon. The Products section will be displayed as shown in the figure.


 Product Stock Report

  • Click Stock Management, and select Product Stock Report. You will be navigated to the Stock Management > Product Stock Report page.


 Product Stock Report

  • Here you can generate product stock report by location, product title, SKU, category, brand, or shelf wise.
  • To generate the product stock report of any stock location, select the location from the Select Location drop-down.
  • To generate the product stock report based on the product title, enter the product title in the Product Title text box.
  • To generate the product stock report based on the SKU/Variant SKU, enter the SKU/Variant SKU in the SKU/Variant SKU text box.
  • To generate the product stock report of a category, select the respective category from the Category drop-down.
  • To generate the product stock report of a brand, select the respective brand from the Brand drop-down.
  • To generate the product stock report of a shelf, click the Select link of Shelf/Bin. A Select Shelf dialog box will be displayed.


 Product Stock Report

  • Select a suitable shelf and click Submit. The Select Shelf dialog box will be closed and the name of the selected shelf will be displayed beside the Select link.
  • Now, you have two options for generating the product stock report i.e. by Product wise or by Shelf/Bin wise.
  • To generate the product stock report by 'Product wise', select the Product option from the Search By drop-down.
  • To generate the product stock report by 'Shelf/Bin wise', select the Shelf/Bin option from the Search By drop-down.
  • To generate the product stock report as per the selected criteria as mentioned above, click Search.
  • The respective products will be listed as per your search criteria under the Product Stock List section.
  • If you have opted for 'Product wise' stock report, the report will be generated as shown in the figure under the Product Stock List section.


 Product Stock Report

  • To download the product stock report in Excel, click Export to Excel in the Download drop-down under the Product Stock List section.


 Product Stock Report

  • The productstocklist.xlsx file will be downloaded with relevant data.
  • To download the product stock report in the PDF, click Export to Pdf in the Download drop-down under the Product Stock List section.


 Product Stock Report

  • The productstocklist.pdf file will be downloaded with the recent data.


OR

  • If you have opted for the 'Shelf/Bin wise' stock report, the report will be generated as shown in the figure under the Product Stock List section.


 Product Stock Report

  • Similarly, download the product stock report in an Excel form or in the PDF form by clicking Export to Excel or Export to Pdf link under the Product Stock List section.