Option to upload Promotion Assortment details via Excel Import

Option is required in Promotion Assortment Master to upload the Item details with the help of Excel Sheet. This will be required for Include & Exclude assortment defiblock 

  • Ritu Singh (SRS)
  • Dec 10 2015
  • Released
Released Version [For Internal use] 11.118.0-1.118.0
  • Apr 14, 2017

    Admin response

    Thanks for sharing your idea, your suggested feature has been released. Item criteria can now be specified in Promotion Assortment while defining the same using Import Excel option.
    Keep sharing your ideas.
  • Attach files
  • Guest commented
    30 Jun, 2016 08:00pm

    EXCEL IMPORT for Category is currently dependent on ARTICLE_NAME although if we enter from Front end it is not required, we have common CAT1 for different article and we want to create assortments with lesser line items, so this is not possible from front end.

    We have tried with the Barcode level promotion but it failed as of the following reasons (Please ensure a solution)

    1. We have around 6-8 Lakhs of items to be imported in different Assortments 

    2. In v10 the File creation time was quite huge hence we dropped back to Category Level Promotions

    3. As stated due to we are unable to import ONLY CAT without ARTICLE (the solution given is by Support Team from backend this backfires incase any CAT ID is not updated a BLANK Line is inserted in ASSORTMENT Table and then all Items starts resolving the Assortment Promotion.

    4. Usually Excel import takes too much of time, it should be faster.

  • Admin
    Product Team commented
    31 May, 2016 12:28pm

    We will be releasing the barcode import option using excel import in Q2-2016 itself. Refer to idea #GIN-I-799 for further information.

  • Asgar Ali commented
    4 Mar, 2016 06:18am

    While importing the data from excel sheet if any category or barcode is not found in master it should proceed with the matching records. Removing the Invalid data and again processing is cumbersome job.


    Practically the brands shares a common excel sheet which are to be included in Promotion. Out of it there are only specific items which are bought by us, thus this feature is required to process the assortment creation faster.

Note : Do not post a lengthy title for an Idea. Post your Idea clearly supported by Screenshots, Examples and Case Studies (if possible).