• This interface facilitates you to create new or update existing Catalog/Cart promotions in bulk quantity through an Excel sheet.

  • All you need to do is to download the bulk promotion Excel through the respective link provided here, update the data and upload the Excel.

  • Each upload will be listed under ‘Task History’ section with the upload status and other required information.

How do I bulk upload the promotions?

OR

How do I create the promotions in bulk?


To bulk upload the promotions, do the following:

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


 Bulk Promotion Upload

  • You will be navigated to the Dashboard page.


 Bulk Promotion Upload

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


  Bulk Promotion Upload

  • Click Manage Promotions and select Bulk Promotion Upload. You will be navigated to the Manage Promotions > Bulk Promotion Upload page.


  Bulk Promotion Upload

  • You need to download the default format for bulk promotion Excel. To download the default format, click the Click Here link. The BulkPromotionsTemplate.xlsx will be downloaded.
  • To open the Excel, double-click the same. The Excel will be opened and displayed as shown in the figure.


  Bulk Promotion Upload

  • For entering the relevant data in the Excel, you need to know the definition of each column. To know the definitions, click Definitions sheet. It will be displayed as shown in the figure.


  Bulk Promotion Upload

  • Definitions:
    • Sno: Enter the unique reference code for the rule/promotion here.
    • Stores: Enter the 'Store Id' to which the promotion is applicable. In the case of multiple store ids, separate them using '/' (Example: 01008/01009). Specify 'ALL' if the promotion is applicable to all stores.
    • DiscountName: Enter the title of the promotion here.
    • Promotion_Logic_Code: Enter the code for the promotion in short form. This will append in the 'Description' field of promotion.
      • Examples:
        1. BuyNofXforZ%off - As per this promotion type if the customer buys 'N' number of SKU1(X), the customer will get 'Z'% off on the total amount.
        2. BuyNorMoreofXforZ%off - As per this promotion type if the customer buys 'N' or > 'N' number of SKU1(X), the customer will get 'Z'% off on the total amount.
        3. BuyRsNofXforZ%off - As per this promotion type, if the customer buys 'N' Rupees worth of SKU1(X), the customer will get 'Z'% off.
        4. BuyNofXforZRsoff - As per this promotion type if the customer buys 'N' number of SKU1(X), the customer will get 'Z' Rupees off on the total amount.
        5. BuyNofXforZRs - As per this promotion type if the customer wants to buy 'N' number of SKU1(X), the customer will get all of them for 'Z' Rupees only.
        6. BuyNorMoreofXforZRsEach - As per this promotion type if the customer buys 'N' or > 'N' number of SKU1(X), the customer will get each of them for 'Z' Rupees only.
        7. BuyRsNofXforZRsoff - As per this promotion type, if the customer buys 'N' Rupees worth of SKU1(X), the customer will get 'Z' rupees off.
  • Discount Type: Select the required type of discount here. The 'product price discount' will only work when the 'condition group' is 'Any', and the 'promotion_logic_code' is 'BuyNofXforZ%off'.
    • Note: If it's blank, it will be treated as the 'cart sub-total discount'.
  • Up to Quantity: Enter the number of products that are eligible for the discount here.
    • Note: It will work only when the 'discount type' is 'Product price discount', the 'condition group' is 'Any', and the 'promotion_logic_code' is 'BuyNofXforZ%off'
  • StartDate: Enter the start date of promotion in DD/MM/YYYY format
  • EndDate: Enter the end date of promotion in DD/MM/YYYY format
  • Amt./PercentOff: Enter the product price discount in 'Amount' or 'Percentage'
  • Days: Enter the periodicity of the promotion here.
    • Example:
      • Monday/Wednesday/Saturday: In this scenario, the promotion will be applied on Monday, Wednesday, and Saturday and the promotion will be repeated every week on these days till the validity of promotion.
      • ALL: The promotion will be applied on all days till its validity.
  • Condition Group (Any/All/MM): Enter the condition group as 'ANY' or 'ALL' or 'MM' as per its applicability.
    • Example:
      • ANY: The promotion will be applied if the number of items as per the 'Condition group parameters' with defined qty. are satisfied.
        For example, Buy 1Coke OR 4Mirinda OR 2Pepsi OR 1Limca; if any two items are satisfied, you will get 20% off
      • ALL: The promotion will be applied if all of the conditions are satisfied.
        For example, Buy 1Coke, and 2Mirinda get 20% off on both
      • MM (Mix & Match): The promotion will be applied if the total quantity as per the 'Condition group parameters' is matched by mixing any of the specified products in flexible quantity.
        For example, Buy 3 qty. among the 5 products in any combination & get 20% off; Buy 6 qty. in any combination of Chocolates of 4 variants at Rs.100/-
  • Condition Group Parameters (Qty/Amt-Any/All/MM): Enter the total quantity or amount for satisfying the condition.
    • If 'Condition Group' is 'All', enter '0' here.
    • If 'Condition Group' is 'Any', enter the total number of items to be satisfied for applying the promotion
    • If 'Condition Group' is 'MM', enter the total quantity for satisfying the condition.
      • Note: If 'Condition Group' is 'MM', the value in the 'ItemQty/Amt' field becomes invalidsystem considers 'Qty/Amt' of 'Condition Group'
  • Item: Enter the value for 'Condition Type' here.
    • Example:
      • If the 'Condition Type' is 'SKU', enter the SKU here.
      • If the 'Condition Type' is 'BRAND', enter the Brand Id here. (Upcoming functionality)
      • If the 'Condition Type' is 'CATEGORY', enter the Category code here. (Upcoming functionality)
  • ItemQty/Amt: Enter the individual item quantity/amount for satisfying the condition. This value is considered when 'Condition Group' is 'ALL' or 'ANY'.
    • Note:
      • If 'Condition Group' is 'MM', the value in 'ItemQty/Amt' field becomes invalid, the system considers 'Qty/Amt' of 'Condition Group'.
      • If 'Condition Type' is 'SKU', enter the quantity of that SKU for satisfying the condition.
      • Based on the value given in the Item Qty/Amt column, the system decides whether it is a Catalog promotion or Cart promotion. If the value is '1' for all the items having same 'Sno', it's a Catalog promotion and if the value is '>1', it treats as Cart promotion.
  • Remark: Enter the promotion remarks here. This will be appended to the 'Message for Capping Conditions' field of the 'Catalog Promotion' and to the 'Message for Action Conditions' field of the 'Cart Promotions'.
  • Condition Type (SKU/Brand): Enter the type of condition here.
    • Example:
      • SKU: Enter the 'SKU' if the condition is based on the SKU
      • Brand: Enter the 'BRAND' if the condition is based on the Brand (Upcoming functionality
      • Category: Enter 'CATEGORY' if the condition is based on the Category (Upcoming functionality)
  • StartTime: Enter the start time of promotion in the HH/MM format
  • EndTime: Enter the end time of promotion in the HH/MM format
Is Repetitive: If the promotional benefits are to be repeated when the eligible criteria met again, select Yes at Is Repetitive column. Else, select No.
In other words, when the 'Is Repetitive' option is 'Yes' if the customers add the quantity in multiples of the base quantity, the promotions will be applied multiple times for every purchase of base quantity.
  • Note: Let the rule says, “Buy 'X' and get '10%' discount”. If the 'Is repetitive' is 'Yes', when the user buys X, the user can get 10% discount; similarly, when a user buys 2X, the user can get 10+10% discount.
Let's see how the 'Is Repetitive' flag works in 'All, Any, MM type of conditions for BuyNofXforZ%off type of promotions:


  Bulk Promotion Upload

  • Is Active: To activate the promotion, select Yes, else select No.
    • Note: If the 'IS Activate' option is 'Yes' the promotion will be applied on the storefront, and if the 'IS Activate' option is 'No' the promotion will not be applied on the storefront.
  • Allow Further Promotions: To allow further promotions after applying this promotion, select Yes. Else, select No
  • Save the Excel after entering the required data.
  • Click Browse to upload the Excel sheet. An Open dialog box will be displayed.


  Bulk Promotion Upload

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


  Bulk Promotion Upload

  • Click Upload. The file will be uploaded and the upload task will be updated under the Task History section in run-time.


  Bulk Promotion Upload

  • During each upload, you can find the upload status, total no. of rows, updated rows, failed no. of rows due to validations and exceptions are being updated in runtime under the ‘Task History’ section.
  • You can download the respective uploaded promotion data by clicking its   Bulk Promotion Upload  icon under the ‘Actions’ column.
  • You can delete any uploaded task (if required) by clicking its   Bulk Promotion Upload  icon under the ‘Actions’ column.
  • In the case of any failures in uploading, you can find   Bulk Promotion Upload  icon under the ‘Actions’ column against that upload. On clicking   Bulk Promotion Upload  icon, you will be navigated to Error Logs Summary page.


  Bulk Promotion Upload

  • Read the error messages and rectify the data. Upload the file again.