Retail Data (Import to Loupe)
      Back to home
      1. Loupe - Help & Support
      2. Integration Documentation
      3. Retail Data (Import to Loupe)

      Retail Data - Merchandising Hierarchy (Class Attributes)

      This article will explain how to load your company's underlying data set for configuration of custom Merchandising Hierarchy fields and their contained drop-down values.

      Retailers need to join retail data to the product data provided by their suppliers in order to complete the required data set needed for SKU generation in their own systems. Merchandising Hierarchy is normally the most important and complex area of this data.

       

      📔  What is Merchandising Hierarchy?

      Typically the Merchandising Hierarchy is the primary mechanism used by a retailer to group products together, and drives window displays in stores, filters on websites, and management reporting related to sales, inventory, and profitability.

      This logic is unique to each retailer and demands custom field names and drop-down values. 

      Every Merchandising Hierarchy has dependencies between each 'level' or "tier' eg:

      Paper / Coloured Paper / Red

      Where value Red is only contained within Coloured Paper, it does not exist in White Paper for example.

       

      Example of typical Merchandising Hierarchy structure could be:

      • Level 1:  Department 
      • Level 2: Class
      • Level 3: Sub-Class

      Examples of a typical jewellery Merchandising Hierarchy string (contained values) could be:

      • Level 1:  Bridal
      • Level 2: Engagement Ring Sets
      • Level 3: Solitaires



      Step 1:       Download the template here


      Step 2:       Complete your Merchandising Hierarchy as per your commercial and system requirements:


      Data Input Guidance:

      Field value Alphanumeric inc Special Characters
      Maximum characters MH Label - 200
      Code - 25
      Parent - 500
      Maximum rows 5000

       

       




      📔 Special Characters:

      Special characters are defined as all non-alphanumeric characters.  For avoidance of doubt, the following special characters are accepted if Type = "alphanumeric inc SC" above:

      • Accepted SC for MH Label - space!"#$%&'()*+,-./:;<=>?@[\]^_`{|}~
      • Accepted SC for MH Code - space!"#$%&'()*+-./:;<=>?@[\]^_`{|}~



      Example file:

      MH CSV input




      Step 3:       Deliver your payload to the Merchandising Hierarchy API

      Endpoint URL: 

      https://enterprise.atelier.technology/api/FoundationalData/merchandising-hierarchy


      For example requests and to test this end-point here is the direct Swagger link: Import MH Data

       


      Step 4:       You can now see your company's Merchandising hierarchy populated in Atelier on:

      1. Linesheet Specification
      2. Linesheet Filters
      3. Integrations / Retail Data Mapping


      ⚠️ Warning for Uniqueness:
      Code should be unique value for all levels.