Import Manager
  • Overview
  • Installation process
  • Updating plugin
  • Templates
  • Import Settings
  • What is ID?
  • Column mappings
    • ACL Mapping
    • Category
    • Cross-sell product
    • Localized Values
    • Manufacturer
    • Product
    • Product Attribute
    • Product Attribute Combinations
    • Product Attribute Mapping
    • Product Attribute Value
    • Product Category mapping
    • Predefined Product Attribute Values
    • Localized Predefined Product Attribute Values
    • Product Manufacturer mapping
    • Product Picture
    • Product Specification Attribute
    • Product Tag
    • Related Product
    • Specification Attribute
    • Specification Attribute Option
    • Store Mapping
    • Tier Price
  • File Sources
    • Upload a File
    • Upload a ZIP-file
    • URL
    • Server folder or file
    • FTP, SFTP, FTPS
  • Scheduling imports
  • Download plugin
  • Contact Us
Powered by GitBook
On this page
  • Possible Entity Keys
  • Column Destinations
  • Example Table
  1. Column mappings

Category

Category is used to import or update Categories

Possible Entity Keys

Category supprots ID or Name as entity key.

Your entity key must be unique. If you have two categories with same Name fields, you will not be able to use Name as entity key.

Column Destinations

Altohugh category has many different column destinations, we would describe only ones that have special functionality.

Column destination
Explanation

Key (Category Id)

The value that you selected as entity key for this template. If you selected Name as key, you can specify either full path, or most bottom category name. For example, Laptops>>Macbook or just Macbook. Note, if you are specifying full path, your parent category must exist, if category is newly created, it will be assigned to parent category automatically. If you are specifying most bottom category name, it should be unique.

Picture

File name of a picture (ex. phone.png), or URL to a picture, or full path on server.

Discount Name or ID

You can specify multiple discounts in one cell, you should use | (vertical bar) symbol for this. Example, 20% off|30% off would apply 20% off and 30% off discounts.

All other column destinations do not support inputing multiple values in one cell, and they don't support using multiple columns as well.

Example Table

Category Name
Picture
Show on home page

Laptops

laptops.png

TRUE

Laptops>>Macbook

https://example.com/macbook.png

FALSE

Laptops>>Gaming

C:\Pictures\gaming.png

TRUE

PreviousACL MappingNextCross-sell product

Last updated 1 year ago