Import from Excel (data and images)

Owned by Morten Lindequist Køhler
Feb 14, 2024
1 min read

This Action Map imports data and referenced images from a custom formatted Excel-file.

This Action map example is provided as inspiration only. It must be adapted to your Perfion environment to work. Perfion Support does not assist with such adaptations. Please contact your Perfion Partner or your Perfion consultant if you need assistance.

Action Map

  • All lines containing a Command are created as virtuals. This is a recommended best practice

  • The empty From-field in the Category mapping sets a default Category for all imported items via the script

Sample Excel-file

This Excel-file is used in the Action Map example:

Sample data for building Action Map

Action Map - From

To

Command

Action

Script

Note

C:\Perfion Data\ActionSources\Import\Sample Mapping - New Products.xlsx

ImportData

SELECT.EXCEL

 

 

 

Sheet1/B:E/1:1/0

@CONTEXT

 

 

 

 

SKU No

_Value

 

 

 

 

Title (english)

ItemName_EN

 

 

 

 

 

Category_EN

 

 

Value = "Coffee & Tea|Coffee Machines";

 

Product picture

Image

 

 

 

 

ImportData

Product

IMPORT