Struct Docs
Struct.PIM 4
Struct.PIM 4
  • Struct PIM Documentation
  • API Reference
  • 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
    • Localization & segmentation
    • Revisions & changelog
    • Publications
    • Supplier onboarding portal
  • Tutorials
    • Helpful guides
      • How to search efficiently
      • 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 templates
    • Example projects
      • Working with the API
  • Integration
    • Integrate with Struct PIM
    • Web API
    • Webhooks
  • Media format
  • API Reference
    • Introduction
    • Endpoints
      • AssetFolders
      • Assets
      • AssetTypes
      • AttributeGroups
      • Attributes
      • AttributeScopes
      • Browse
      • BusinessUnits
      • Catalogues
      • Categories
      • Dimensions
      • Exports
      • EnrichmentInsightSetups
      • GlobalLists
      • Languages
      • Maintenance
      • Miscellaneous
      • Messaging
      • Permissions
      • Products
      • ProductStructures
      • Publications
      • Transactions
      • UserGroup
      • UserRoles
      • Users
      • VariantGroups
      • UserTasks
      • Variants
      • Webhooks
      • Workflows
      • Models
Powered by GitBook
On this page
  • Before importing
  • Starting the import
  • Mapping your data
  • The file contains new products
  • Approve changes
  1. Tutorials
  2. Helpful guides
  3. How to use Import

How to import products

Learn how to import products from beginning to end

PreviousHow to use ImportNextHow to import data into a list property on entities

Last updated 11 days ago

Before importing

A prerequisite to importing any entities is having an excel spreadsheet with the data organized in named columns. For this tutorial we have a made a simple spreadsheet containing information about clothing.

Starting the import

To start importing you choose the excel spreadsheet with the data you want to import, in this tutorial the spreadsheet is called "ClothingForImport.xlsx".

While it is possible to include media assets when importing, this will not be covered in this guide. For this reason we leave 'Upload assets' unticked and 'Select media folder' empty.

Having chosen the correct file and import type you can click the "Start upload"-button to start the import.

Mapping your data

Having clicked the "Start upload"-button you are presented with a new page. This is where you will map your excel columns to data fields on entities.

If you know you will be using this mapping often, you can save it by clicking 'Save mapping' and giving it a name. This way you can always load your mapping again when using a similar excel spreadsheet.

Having chosen one or more keys you can click "Next" in the right-bottom corner.

The file contains new products

Click the "Next"-button in the right-bottom corner to continue.

Approve changes

Having reviewed the changes you can choose to approve the changes you are satisfied with. Only approved records will be commited.

When you have approved the records you want to keep, click the "Commit Import"-button in the bottom-right corner to finalize the import.

Next you need to choose the correct Import type. When importing , , variant groups or the 'General Excel Import' type is used.

You will need to choose the correct Entity type; , , Variant groups or values.

In this guide we are importing , so we choose 'Products' in the 'Entity type' dropdown, but the process for all entities are almost entirely similar from here.

Next is mapping the actual data. The import function will try to automap the data from the file by matching the name of the excel column to the name of an in the PIM.

This is not always possible or what you want, in which case you can manually select the correct to map to in the 'Select field' dropdown in the 'Map to' column.

Having finished the mapping, you need to choose one or more keys. These key(s) will act as keys to match existing entities in the system. If the key(s) match a in the system, that will be updated with the data from the excel spreadsheet.

If the key does not exist, a new with the data from the excel spreadsheet will be created.

As mentioned in the last section, if a key does not already exist in the PIM, a new will be created. If the excel spreadsheet contains new you will be prompted to choose a to use for the new .

In this guide we are importing clothing, so the 'Clothing' is chosen.

At this point you are shown a 'Review changes'-page. This page will show you the amount of new and updated items. New items will be denoted by having a blue 'New'-tag in the key column whereas existing will show their current value.

that will be changed are colored green to easily distinguish between that will remain the same and that will change.

categories
products, variants
global lists
Categories
Products, Variants
Global list
products
attribute
attribute
product
product
product
product
products
Product structure
products
product structure
products
Attributes
attributes
attributes
Excel spreadsheet with headers and data
Import page
Data mapping
Data mapping
The file contains new products
Review changes