Work in progress, we are currently filling in the help enviroment.
Collect
Updated on:
October 8, 2024

Feed Mapping

Feed Mapping is an essential tool for linking product data from your files (feeds) to specific data fields in KatanaPIM.

on this page:

The Feed Mapper's primary role is to enable you to create templates for importing products. This powerful feature allows you to bring in new products or update existing product information by connecting specific columns or nodes from your local feed files (like Excel or CSV) or from an FTP server to the corresponding fields in KatanaPIM.

Creating a Feed Mapping from a local file - content enrichment

This documentation provides step-by-step guidance on creating a feed mapping directly from a local file, to import new products or enrich/edit data of products that are already in your KatanaPIM environment.

  • Accessing Feed Mappings: on the Import Page, navigate to the 'Feed Mappings' tab and select 'Add New'. This is where you define a new mapping template.
  • File source selection: click on "upload file". To give it a try, consider using the sample file provided.
  • Uploading the feed file: upload your feed file by dragging it into the designated area or selecting it via file explorer.
    The supported formats are: XLSX, CSV, XML and JSON.
    Please note: when importing XML and JSON, make sure to also select the right NODE in the appearing "Product node" field. When importing CSV, ensure that any CSV file you import includes at least three columns.
  • In the 'Approve new template' window, click on 'Apply'.
  • Select your import goal: Content Enrichment allows you to import new products (with the related content) or enrich products that are already in the system.
  • Select the appropriate product type (simple product, or variations).
  • Selecting Feed Import level: choose an appropriate level of feed import, like 'Full Selective'. This choice impacts how the imported data will interact with existing data in KatanaPIM.
  • Name your feed mapping and include a descriptive summary for future reference. This allows for easy identification and enhances organization.

Next, you'll need to map your file fields to those in KatanaPIM. This can be done either manually or by utilizing the Automap function for a quicker setup process.

Manual content enrichment

  • Field mapping: under the 'Content enrichment' tab, proceed to map your fields. This is the step where you define how each column in your feed correlates to data fields in KatanaPIM.
  • Multi-language and overwrite options: these options allow further customization of how data is imported. Multi-Language supports importing data in various languages, while Overwrite determines whether new data will replace existing data in KatanaPIM.
  • Add specifications: Click on 'add specifications' to link specification values from your file, to the corresponding spec in KatanaPIM.
  • Add images: click on 'add image'. Your local file will have to contain public urls for each image.
  • Saving the configuration: after mapping the fields and setting preferences, save your configuration. This finalizes the Feed Mapping and makes it ready for use in import tasks.

Auto map function

  • Usage of auto mapping: auto mapping simplifies the mapping process by automatically linking fields based on similarities in their names or structures. It utilizes a percentage-based accuracy system to determine matches between 'Internal Name' and 'Import Name'.
  • Configuration options in Auto map: you can choose to include base fields, image fields, and additional specifications in the auto-mapping process. Additionally, you can decide whether to apply the Overwrite setting to all fields already having an active mapping.

Creating a Feed Mapping from a local file - variant relationships

This documentation provides step-by-step guidance on creating a feed mapping directly from a local file, to import variant products or update/edit your product variants relationships.

  • Accessing Feed Mappings: on the Import Page, navigate to the 'Feed Mappings' tab and select 'Add New'. This is where you define a new mapping template.
  • File source selection: click on "upload file". To give it a try, consider using the sample file provided.
  • Uploading the feed file: upload your feed file by dragging it into the designated area or selecting it via file explorer.
    The supported formats are: XLSX, CSV, XML and JSON.
    Please note: when importing XML and JSON, make sure to also select the right NODE in the appearing "Product node" field. When importing CSV, ensure that any CSV file you import includes at least three columns.
  • In the 'Approve new template' window, click on 'Apply'.
  • Select your import goal: 'Variant relationships' allows you to update or add product variations relationships.
  • Name your feed mapping and include a descriptive summary for future reference. This allows for easy identification and enhances organization.

Manual content enrichment

  • Field mapping: under the 'Variant Relationship' tab, proceed to map your fields. This is the step where you define how each column in your feed correlates to data fields in KatanaPIM.
  • Saving the configuration: after mapping the fields and setting preferences, save your configuration. This finalizes the Feed Mapping and makes it ready for use in import tasks.

Auto map function

To understand the Auto map function, refer to this page.

Feed Mapping fields explained

Configuration

This is the main section where you configure how to import data into the PIM system.

  1. File source: There are two options here:
    • External file: If this option is selected, it would allow you to specify a URL or some external source from where the file can be fetched.
    • Upload file: This is the selected option, which means you'll be uploading a file directly from your computer or network.
  2. Upload file area: This is a drag-and-drop interface or a browsing option to select a file from your local computer to upload.
  3. Goal: Here, you can define the purpose of the import:
    • Content Enrichment: by selecting this option, the import will be used to add or update products in the PIM system.
    • Variant Relationships: If selected, the import is meant to define or update the relationships between product variants.
  4. Product type: This lets you specify the type of products in the import file.
    • Simple product: A standalone product without any variants.
    • Child product: A product that is a variant of another product, which would be the 'Parent product'.
    • Parent product: A product that has variants, referred to as 'Child products'.
    • Grandparent product: product line or category that includes several 'Parent products'.
  5. Import level: This section lets you choose how the import process should handle the data. There are three options:
    • Full Selective: This option will add new data from the import file to the PIM system. If existing data is found in the PIM that matches the import file, it will be updated with the information from the file. This option will also remove data in the PIM system if it's no longer in the import file.
    • Insert & Update: This option will add new data from the import file to the PIM systemdating existing data. This will overwrite existing entries with new data from the import file
    • Update: This option is strictly for updating purposes.
  1. Name: This is the name of your feed mapping. It will be pre-filled with your file's name, but you can also change it.
  2. Description (optional): This field allows you to add any relevant description or notes about the feed mapping.

Content Enrichment

This is the section where link your file fields to the fields into KatanaPIM.

  1. Automap: This button, typically found at the top-right corner, would be used to automatically map import names to internal names based on matching text, simplifying the mapping process.
  2. Internal name: The names of fields as recognized within the PIM system. These are the fields that will be enriched or updated with the imported data.
  3. Import name: The corresponding column headers in the import file. These should match or be mapped to the internal names in the PIM system for successful data import.
  4. Multi-language: indicates the ability to import and manage different language versions for that particular field. You can check this box if you are importing multilingual data.
  5. Overwrite: Checkboxes in this column would allow you to overwrite existing data for the respective field in the PIM system. When checked, the imported data will replace any existing data in the PIM system for that field.
  6. Example: This column provides an example of the data that could be in each field, helping to illustrate what kind of content is expected.

Blue dots: The presence of blue dots next to an internal name indicates that there are unsaved edits in that row. These changes need to be saved for the mapping to be applied during the import process.
Fields marked with an asterisk (*) & in bold
: These fields are required. The import process cannot be successfully completed unless these fields are mapped and contain data in the import file.

© 2024 KatanaPIM
DisclaimerSitemap