Struct Docs
Struct.PIM v3
Struct.PIM v3
  • Struct PIM Documentation
  • API Reference
  • Changelog
  • Latest updates from Struct HQ
  • Latest updates in Documentation
  • Fundamental concepts
    • Get familiar with Struct PIM
    • Catalogues & categories
    • Products & variants
    • Attributes
    • Product structures
    • Identifiers
    • Global lists
    • Collections
    • Security management
    • Localization & segmentation
    • Revisions & changelog
    • Dashboard
    • Publications
    • Supplier onboarding portal
  • Tutorials
    • Helpful guides
      • How to use product models
      • How to use product catalogues
      • How to use enrichment insights
      • How to use Import
        • How to import products
        • How to import data into a list property on entities
        • How to import categories
        • How to import with media
        • How to use File mappings
        • How to use Validation rules during import
        • How to use Transformation during import
      • How to use Business rules
        • How to set up and edit a business rule
        • How to use conditions in a business rule
        • How to set up business rules to trigger other business rules
        • How to automatically set release status
        • How to automatically calculate the size of a variant
        • How to automate price conversion
        • How to assign documents to a product when it is created
        • How to manage product identifiers
    • Example projects
      • Working with the API
      • Product viewer
      • Publications 3.15
  • Integration
    • Integrate with Struct PIM
    • Web API
    • Webhooks
    • Media format
  • Reference
    • How to use Struct PIM
    • Search
      • Manage columns
      • Bulk actions
      • Search help
    • Tasks
      • Task details
    • Global lists
      • Global list details
    • Product catalogues
      • Product catalogue details
        • General settings
        • Data model
          • Tab types
            • Tab details
          • Section types
            • Section details
          • Property types
            • Property details
        • Workflow
        • Display settings
        • Identifiers
          • Identifier details
    • Collections
    • Background tasks
    • Publications
      • Prints
        • Print details
      • Templates
        • Edit template
          • Template settings details
          • Template design
            • Header/Footer elements
            • Template preview settings
    • Product model setup
      • Product structures
        • Product structure details
          • General settings
          • Data model
            • Tab types
              • Tab details
            • Section types
              • Section details
            • Property types
              • Property details
          • Variation definitions
            • Variation definition details
          • Product wizards
          • Variant group create wizard
          • Variant create wizard
          • Display settings
          • Identifiers
            • Identifier details
      • Attributes
        • Attribute details
          • Data type details
      • Attribute groups
        • Attribute group details
      • Attribute scopes
      • Dimensions
        • Dimension details
      • Enrichment Insights
        • Enrichment insight details
        • Insights setup
          • Insight details
      • Business rules
        • Business rule details
          • Triggers
            • Trigger details
              • Trigger configuration details
          • Conditions
            • Condition details
              • Condition configuration details
          • Actions
            • Action details
              • Action configuration details
      • Changelog
      • Workflows
        • Workflow details
        • Workflow states
          • Workflow state details
          • Workflow transitions
            • Workflow transition details
    • Settings
      • API configuration
        • API configuration details
          • API configuration basic settings
          • API configuration advanced settings
      • Webhooks
        • Webhook details
          • Webhook advanced details
      • Messaging
        • Messaging details
      • Security
        • User settings
        • User group permissions
      • Setup
        • General
        • Supplier portal email
        • Supplier portal
        • Archive reasons
        • Scheduled tasks
        • Attribute indexing
        • User settings
      • Permission Management
        • Permissions
        • Permission Groups
      • Languages
      • Maintenance
      • License
      • Extensions
        • Extensions details
        • URL details
      • File mappings
        • File Mapping details
      • AI assistant
        • Translation
        • Text generation
    • Dashboard
      • Saved searches
        • Saved searches details
      • Dashboard tabs
      • Widget details
        • Widget types
Powered by GitBook
On this page
  1. Tutorials
  2. Helpful guides
  3. How to use Import

How to use Transformation during import

By using Transformation during import you can easily manipulate data to your liking

PreviousHow to use Validation rules during importNextHow to use Business rules

Last updated 3 months ago

Prerequisite: This tutorial assumes you know the basics of the import feature. If this is not the case you can learn the basics in other guides here: The tools this tutorial goes through are all found on the data mapping page of import

Transformation

When importing Text or Number you can choose to do Transformation on the incoming values. This is done by clicking the 'Transform' text to the right of the data mapping.

Transformation for Text has the following options:

  • All caps

  • All non caps

  • Capitalize first letter in sentence

  • Capitalize first letter in word

  • Trim

  • Replace

  • Regex replace

These are all pretty selfexplanatory and require no other choices to be made, except Replace and Regex replace.

Regex replace is similar, however it takes a pattern instead of an 'Old value'. This pattern is in the form of a regular expression and all occurences that fits the pattern will be replaced with the new value.

Transformation for Numbers has the following options:

  • Divide

  • Minus

  • Multiply

  • Plus

And they do exactly what they say.

Whether you click 'Transformation' for a Text or Number determines the tranformations that are eligible.

Replace takes an 'Old value' and a 'New value'. In the example above all occurences of 'jacket' will be replaced with 'pillowcase' for the the Transformation was added to.

Having chosen your Transformation type simply input the Number for the operation and the operation will be executed on the that is imported.

attribute
attribute
attribute
attribute
How to use import
attributes
Replace for Text attribute
Transformation for Number attribute