• This report displays the stock flow of products against multiple actions such as GRN, Stock Movement, Stock Adjustment, Order, Picklist, Return, Cancel, etc… by date wise and helps in tracking a product/stock.

  • You can generate the report through various options such as location, SKU/Variant SKU, from date and to date.

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

How do I generate the SKU transactions report at my web store?


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

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


 SKU Transactions Report

  • You will be navigated to the Dashboard page.


 SKU Transactions Report

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


 SKU Transactions Report

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


 SKU Transactions Report

  • Select the location for which you want generate SKU transactions report from the Select Location. This is a Mandatory selection.
  • Enter the SKU of product that you want to generate SKU transactions report in the SKU/Variant SKU text box. In the case of a 'variant product', enter 'Variant SKU' here. This is a Mandatory filed.
  • Select the 'from date' from which you want the SKU transactions report from the From Date date picker. This is a Mandatory selection.
  • Select the 'to date' to which you want the SKU transactions report from the To Date date picker. This is a Mandatory selection.
  • Select the type of booking the stock from the Booking Type drop-down. This is an Optional selection.
  • For your easy understanding, the information about available options under the Booking Type drop-down are mentioned in the following table:



Booking TypeWhat does it it mean
Stock Mvmt-Different Location Shelf/Bin Stock DecreaseStock from Shelf/Bin decreased upon stock movement to different location
Stock Mvmt-Different Location Sellable IncreaseSellable stock (i.e. stock of the location) increased upon stock movement (i.e. stock received) from different location
Stock Mvmt-Different Location Sellable DecreaseSellable stock (i.e. stock of the location) decreased upon stock movement (i.e. stock sent) to different location
Stock Mvmt-Shelf/Bins Stock IncreaseStock of a shelf/bin will be increased upon the stock movement within the location
Stock Mvmt-Shelf/Bins Stock DecreaseStock from a shelf/bin will be decreased upon the stock movement within the location
Stock Mvmt-Sellable IncreaseSellable stock (i.e. stock of the location) will be increased upon the stock movement within the location
Stock Mvmt-Sellable DecreaseSellable stock (i.e. stock of the location) will be decreased upon the stock movement within the location
Stock AdJ-Shelf/Bin Stock IncreaseStock of a shelf/bin will be increased upon the stock adjustment within the location
Stock AdJ-Shelf/Bin Stock DecreaseStock from a shelf/bin will be decreased upon the stock adjustment within the location
Stock AdJ-Sellable IncreaseSellable stock (i.e. stock of the location) will be increased upon the stock adjustment within the location
Stock AdJ-Sellable DecreaseSellable stock (i.e. stock of the location) will be decreased upon the stock adjustment within the location
Stock Mvmt-RTV Shelf/Bin Stock DecreaseStock from a shelf/bin will be decreased upon the stock movement to a vendor
Stock Mvmt-RTV Sellable IncreaseSellable stock (i.e. stock of the location) will be increased upon the stock movement (i.e. stock received) from a vendor
Stock Mvmt-RTV Sellable DecreaseSellable stock (i.e. stock of the location) will be decreased upon the stock movement (i.e. stock sent) to a vendor
Order Cancel-Sellable IncreaseSellable stock (i.e. stock of the location) will be increased upon an order cancellation
Order-Sellable DecreaseSellable stock (i.e. stock of the location) will be decreased upon an order creation
Order-Sellable to AllocatedSellable stock (i.e. stock of the location) will be moved to allocated stock upon an order creation
Order Cancel-Allocated to SellableAllocated stock will be moved to the sellable stock upon an order cancellation
Cancel Picklist-Increase AllocatedAllocated stock will be increased upon a Picklist cancellation
Create Picklist-Allocated DecreaseAllocated stock will be decreased upon a Picklist creation
Cancel Picklist-Increase Shelf StockShelf stock will be increased upon a Picklist cancellation
Create Picklist-Shelf Stock DecreaseShelf stock will be decreased upon a Picklist creation
Create Picklist-Inpicking IncreaseIn-picking stock will be increased upon a Picklist creation
Confirm Picklist - Stock PickedStock will be picked upon a Picklist confirmation
Return Order-Shelf Stock IncreaseShelf stock will be increased upon an order return
Return Order-Sellable IncreaseSellable stock (i.e. stock of the location) will be increased upon an order return
GRN-Add Shelf StockShelf stock increased upon GRN creation
GRN-Sellable IncreaseSellable stock (i.e. stock of the location) will be increased upon a GRN creation
  • Click Search. The respective 'SKU transactions list' will be displayed as per your search criteria.


 SKU Transactions Report

  • You can export this report in an Excel or a Pdf format. To do so, click Download, and select Export to Excel or Export to Pdf for downloading the report in an Excel or a Pdf format respectively.