Skip to main content

Import from Excel (data and images)

Zoltán Mikolás
  • Updated

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

The Excel file used in the Action Map example (Sample Mapping - New Products.xlsx) is attached at the bottom of the page.

 

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      

Related articles

Comments

0 comments

Please sign in to leave a comment.