KatanaPIM Mappings
Updated
by
Niek Ressing
With OrderChief product-information from KatanaPIM can be passed on to other systems to make sure your product-information is stored in one place and updated in all your systems. Here are the base-mapping for a product.
Important focuses
- We don't inherit data from grant-parent to parent or parent to child (specifications, images etc.)
- Grandparent/parent/child isn't possible for all marketplaces.
Settings
Value | Description |
KatanaPIM store ID (optional) | Only the products which are limited to this store ID will be exported |
Default language | The default language of the KatanaPIM environment |
Decimal separator (default: dot) | What is used to separate the inter-part from the fractional-part (example: 19.99) |
Integer delimiter (default: comma) | Used for easy reading of large numbers (example: 1,000,000) |
Price including VAT | Indicates if all standard prices are incl. or excl. VAT |
General
KatanaPIM | OrderChief |
ID | Key |
GTIN | EAN |
SKU | Code |
Name (including translations) Can be overwritten by a specification with code [Name] | Name |
Specification with code [LongTitle] | Long name |
Full description (including translations) Can be overwritten by a specification with code [FullDescription] | Description |
Short description (including translations) Can be overwritten by a specification with code [ShortDescription] | Short description |
Specification with code [ProductType] | Product type |
Default the names of the categories Can be overwritten by the ID's of the categories | Categories |
Default the name of a manufacturer Can be overwritten by the ID of a manufacturer | Brand |
If product type is [Parent] ✅ Else ❌ | Is parent |
If product type is [Child] then we add information about the parent (ID, GTIN, SKU) | Parent (ID, GTIN, SKU) |
If product type is [Child] then add specification(s)/attribute(s) with code [variant_{Name}] (including translations) with the value of option (including translations). Examples
| Options |
Specification with [SupplierName] | Supplier |
Manufacturer part number | Supplier code |
Published | Published |
Available start date | Start date |
Available end date | End date |
Specification with code [Handle] | Handle |
Specification with code [Sorting] | Sorting |
Specification with code [HarmonizedSystemCode] | Harmonized system code |
Tags | Tags |
Prices
We have a setting were we can configure if all KatanaPIM prices are incl. or excl.
If the prices are in a specification they can be multilingual and the vat-percentage will then also be multilingual.
KatanaPIM | OrderChief |
Specification with code [VatPercentage] | Vat-percentage |
Prices > Current price book item > Price (if all prices are excl. then N/A) Can be overwritten by a specification with a configurabel code (advised = [PriceIncluding]) | Selling price incl. |
Prices > Current price book item > Price (if all prices are incl. then N/A) Can be overwritten by a specification with a configurabel code (advised =[PriceExcluding]) | Selling price excl. |
Prices > Cost price (incl. or excl. depends on setting) | Cost price |
Prices > Old price (if all prices are excl. then N/A) Can be overwritten by a specification with code [PreviousPriceIncluding] | Previous selling price incl. |
Prices > Old price (if all prices are incl. then N/A) Can be overwritten by a specification with code [PreviousPriceExcluding] | Previous selling price excl. |
Prices > Special price (if all prices are excl. then N/A) Can be overwritten by a specification with code [SpecialPriceIncluding] | Special price incl. |
Prices > Special price (if all prices are incl. then N/A) Can be overwritten by a specification with code [SpecialPriceExcluding] | Special price excl. |
Item info
KatanaPIM | OrderChief |
Specification with code [Weight_Unit]
| Weight unit |
Specification with code [Weight_Net] | Net weight |
Specification with code [Weight_Gross] | Gross weight |
Specification with code [Size_Unit]
| Size unit |
Specification with code [Size_X_Value] | Width |
Specification with code [Size_Y_Value] | Height |
Specification with code [Size_Z_Value] | Length |
Specification with code [Volume_Unit]
| Volume unit |
Specification with code [Volume_Value] | Volume |
Images
KatanaPIM | OrderChief |
ID | Key |
Only the first image | Is main |
Display order | Sort order |
URL | URL |
Alt tag | Alt tag |
Mime type | Content type |
Updated on | Modified |
SEO
KatanaPIM | OrderChief |
Meta title (including translations) Can be overwritten by a specification with code [SeoMetaTitle] | Meta title |
Meta description (including translations) Can be overwritten by a specification with code [SeoMetaDescription] | Meta description |
Specifications/Attributes
KatanaPIM | OrderChief |
Code | Key |
Name (including translations) | Name |
Description (including translations) | Description |
Value(s) (including translations) | Value(s) |
Connector specific
KatanaPIM | Shopify |
Specification with code [shopify_metafield_{Namespace}_{Key}] | Meta fields |
Specification with code [shopify_tags] | Tags |
KatanaPIM | Lightspeed |
Specification group with name [lightspeed_filters] Lightspeed limits
| Filters + filter values |
Specification group with name [lightspeed_attributen_{Product type}] for each product type. We will chose which attribute group to chose based on the product type. | Attribute group + attributes |
