• This interface facilitates in adding the new shelves or updating the information against the existing shelves in a bulk quantity at a stretch.

  • All you need to do is to download the latest Excel format from the respective link provided here, update the data and upload that file here.

  • You can find the task history of latest uploads in the following table. During the upload, you can verify the number of updated rows, the number of rows failed due to validations and exceptions in the run-time i.e. dynamically under the Task History section.

How do I bulk upload the shelves against a store location or warehouse?


To bulk upload the shelves against a store location or warehouse, do the following:

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


 Bulk Shelf Upload

  • You will be navigated to the Dashboard page.


 Bulk Shelf Upload

  • Click the  Bulk Shelf Upload icon. The Products section will be displayed as shown in the figure.


 Bulk Shelf Upload

  • Click Stock Management, and select Bulk Shelf Upload. You will be navigated to the Stock Management > Bulk Shelve Upload page.


 Bulk Shelf Upload

  • Now you need to download the latest Excel format. To do so, click the Click Here link under the Bulk Shelf Upload section. Then the respective Excel, i.e. LocationShelfDefaultFormat.xlsx will be downloaded.
  • To open the Excel, double-click the same. The Excel will be displayed as shown in the figure.


 Bulk Shelf Upload

  • There are two sheets here, namely - Sheet1 and Definitions.
  • You need to fill the respective data in the Sheet1.
  • You can find the definitions of each field in the Definitions sheet. Click Definitions sheet and it will be displayed as mentioned below.


 Bulk Shelf Upload

  • Read the definitions carefully and navigate to the Sheet1 sheet again.
  • Enter the unique code for the shelf under the Shelf/Bin Code column. It's a MANDATORY field and it's a text field.
  • Enter the description of the shelf under the Shelf/Bin Description column.
  • Enter the unique code of zone for which you are creating the shelf under the Zone Code column. It's a MANDATORY field and it's a text field.
  • Enter the condition of shelf i.e. Good or Bad under the Shelf/Bin Condition column. It's a MANDATORY field.
  • Enter the type of shelf i.e. Good QC, Bad QC, Inward, Bulk, and Return under the Shelf/Bin Type column. It's a MANDATORY field.
  • Enter the status of the shelf i.e. Active or Inactive under the Shelf/Bin Status column.
  • Enter the aisle number, which is a passageway in a warehouse, under the AisleNo column. It's a text field.
  • Enter the unique sequence of the shelf under the Sequence No column. It's a text field.
  • Enter the maximum weight that can be sustainable by the shelf under the Weight Capacity. It's a numeric field.
  • Enter the capacity of the shelf in pieces or units under the Shelf/Bin Capacity column. It's a MANDATORY field and it's a numeric field.
  • Enter the width of the shelf under the Width column. It's a numeric field.
  • Enter the height of the shelf under the Height column. It's a numeric field.
  • Enter the length of the shelf under the Length column. It's a numeric field.
  • Enter the 'X' coordinate of the shelf under the Shelf/Bin X Coordinate column. It's a text field.
  • Enter the 'Y' coordinate of the shelf under the Shelf/Bin Y Coordinate column. It's a text field.
  • Enter the 'Z' coordinate of the shelf under the Shelf/Bin Z Coordinate column. It's a text field.
  • If you want to make the shelf as a default shelf for inbound, enter 'TRUE' under the Default Shelf/Bin for Inward Process column; else enter 'FALSE'There can be a single default shelf for inbound in any location.
  • If you want to make the shelf as a default shelf for return, enter 'TRUE' under the Default Shelf/Bin for Return column; else enter 'FALSE'There can be a single default shelf for return in any location.
  • Save the Excel in a suitable location.
  • Navigate to the Bulk Shelf Upload section in the Stock Management > Bulk Shelf Upload page.


 Bulk Shelf Upload

  • Select the location in which you are creating bulk shelves, from the Select Location drop-down.
  • Click Browse. An Open dialog box will be displayed.


 Bulk Shelf Upload

  • Select the updated LocationShelfDefaultFormat.xlsx file and click Open. The dialog box will be closed and the name of the selected file will be updated in the Upload Excel text box.


 Bulk Shelf Upload

  • Click Upload. The Excel file will be uploaded and you can verify the number of updated rows, the number of rows failed due to validations and exceptions in the run-time i.e. dynamically under the Task History section during upload.


 Bulk Shelf Upload

  • In case some rows are not updated due to some problems, you can find the  Bulk Shelf Upload icon under the Actions column, by clicking which you can be navigated to the Error Logs Summary page. By reading the error messages, you and find the respective fault. Rectify the data accordingly and upload the respective rows again.