Update data via Import
      Back to home
      1. Knowledge base
      2. Export & Import
      3. Update data via Import

      Style Custom Field per Color update via import

       

      Custom Field per Color import will update custom fields that have the Per Color option enabled.


      See how to Import and where to select the type of Import: HERE


      DEFAULT COLUMNS IN THE EXCEL SHEET

      The following columns are the default ones - with a description of where to find the data.

      Headers in Excel Explanation Example of data
      BRAND: The Style Brand name in the Style Header  
      STYLE NAME:   Style Name in the Style Header  
      STYLE NO:    Style No in the Style Header  
      SEASON:   Is the Season name in the Style Header. If your company uses Project, make sure you do not include the Project name   
      SUPPLIER ID:  Supplier ID can be found in Admin->Supplier under the respective Supplier company      
      COLOR ID: This is the Color ID - can be found either on the Style Item List or in Admin->Colors. Please see the illustration below  
      COLOR ID2: This is the Color ID2 (if used) - can be found either on the Style Item List or in Admin->Colors. Please see the illustration below  

      How to find Color data on the Style Item List


      How to find Color data in Admin-Colors


      MANDATORY COLUMNS FOR DATA


      These columns are mandatory to enter data in - if you don't do this - the import can not work.

      • Brand
      • Style Name
      • Style No
      • Season
      • Supplier ID - if it is on your style it's mandatory
      • Color ID
      • Color ID2 (if used)

       

      FIELDS THAT CAN BE UPDATED


      With this update - it is only possible to update Style Custom Fields that are Per color.



      HOW TO UPDATE CUSTOM FIELDS

      You can update any kind of Custom Field via the Update functionality as long as it is Per Color.


      The syntax for updating Custom Fields depends on what kind of Custom Field you want to update and what kind of data you have available.


      For most Custom Fields you need to use the syntax CF:ID.


      From the illustration above your syntax would be "CF:4711" in the header.

      In the column, you will then enter the values you want for that Custom Field - say "11" since it is a Numeric one.



      For Allowed Value Custom Fields (and Hierarchy Custom Fields) you can use two types of syntax.

      The one just explained and one of type CFID:ID - let us look at two examples.


      • For the CF:ID your Column header would be "CF:12: and the value in the column would be "Yellow flag"
      • If instead you only have the Allowed ID to work with your syntax would be "CFID:12" in the header and in the column, you will then enter the ID - in this case, "3"


      UPDATING

      If you need to add multiple per color values for the same Custom Field - you will need to add one line for each color in your excel sheet.