# Product

## Possible Entity Keys

Product supprots ID, SKU, GTIN, Manufacturer part number or Name as entity key.

{% hint style="warning" %}
Your entity key must be unique. If you have two products with same Name fields, you will not be able to use Name as entity key.
{% endhint %}

## Column Destinations

{% hint style="info" %}
Altohugh product has many different column destinations, we would describe only ones that have special functionality.
{% endhint %}

<table><thead><tr><th width="197">Column destination</th><th>Explanation</th></tr></thead><tbody><tr><td>Key (Product Key)</td><td>The value that you selected as entity key for this template.</td></tr><tr><td>Picture</td><td><p>File name of a picture (ex. phone.png), or URL to a picture, or full path on server.<br></p><p>If such <strong>file doesn't exist</strong> or cell is emply, a picture will not be added, and no errors will be issued. <br></p><p>You can use Picture <strong>several times</strong> in one feed file to add several pictures.</p></td></tr><tr><td>Picture Alt attribute</td><td>Picture Alt Attribute. If you import <strong>multiple pictures in one row</strong>, this attribute will be assigned to all of them. You can't use multiple columns of this attribute.</td></tr><tr><td>Picture Title attribute</td><td>Picture Title Attribute. If you import <strong>multiple pictures in one row</strong>, this attribute will be assigned to all of them. You can't use multiple columns of this attribute.</td></tr><tr><td>Picture Display Order</td><td>Picture Display Order. If you import <strong>multiple pictures in one row</strong>, this attribute will be assigned to all of them. You can't use multiple columns of this attribute.</td></tr><tr><td>Category Name or ID</td><td><p>You can specify <strong>multiple categories</strong> in one cell, you should use | (vertical bar) symbol for this. Example, <strong>Laptops|Macbook</strong> would assign to category Laptops and Macbook.<br></p><p>If you are inputing category name, it can be either <strong>full category path</strong>, or the <strong>most bottom level</strong> category name. So, you can enter either <em>Portable>>Phone>>Android</em> or just <em>Android</em>. Note, if you are entering just bottom level category name, it must be unique.</p></td></tr><tr><td>Manufacturer Name or ID</td><td>You can specify <strong>multiple manufacturers</strong> in one cell, you should use | (vertical bar) symbol for this. Example, <strong>Dell|Apple</strong> would assign to manufacturer Dell and Apple.</td></tr><tr><td>Discount Name or ID</td><td>You can specify <strong>multiple discounts</strong> in one cell, you should use | (vertical bar) symbol for this. Example, <strong>20% off|30% off</strong> would apply 20% off and 30% off discounts.</td></tr><tr><td>Specification Attribute '&#x3C;Attribute Name>'</td><td>You shuld specify Options for this specification attribute. You can specify <strong>multiple Options</strong> with | (vertical bar) symol.</td></tr></tbody></table>

{% hint style="warning" %}
Below you would find some constants that represent different values for some Column Mappings. Use *these* values in your cells during imports.
{% endhint %}

<table><thead><tr><th width="201">Column Destination</th><th>Constants</th></tr></thead><tbody><tr><td>Product type</td><td>For <strong>Simple Product</strong> use value <strong>5</strong><br>For <strong>Grouped Product</strong> use value <strong>10</strong></td></tr><tr><td>Backorders</td><td>For <strong>No Backorders</strong> use value <strong>0</strong><br>For <strong>Allow Qty Below 0</strong> use value <strong>1</strong><br>For <strong>Allow Qty Below 0 And Notify Customer</strong> use value <strong>2</strong></td></tr><tr><td>Download activation type</td><td>For <strong>When Order Is</strong> Paid use value <strong>0</strong><br>For <strong>Manualy</strong> use value <strong>10</strong></td></tr><tr><td>Gift card type</td><td>For <strong>Virtual</strong> use value <strong>0</strong><br>For <strong>Physical</strong> use value <strong>1</strong></td></tr><tr><td>Low stock activity</td><td>For <strong>Nothing</strong> use value <strong>0</strong><br>For <strong>Disable Buy Button</strong> use value <strong>1</strong><br>For <strong>Unpublish</strong> use value <strong>2</strong></td></tr><tr><td>Inventory method</td><td>For <strong>Dont Manage Stock</strong> use value <strong>0</strong><br>For <strong>Manage Stock</strong> use value <strong>1</strong><br>For <strong>Manage Stock</strong> By Attributes use value <strong>2</strong></td></tr><tr><td>Cycle Period</td><td>For <strong>Days</strong> use value <strong>0</strong><br>For <strong>Weeks</strong> use value <strong>10</strong><br>For <strong>Months</strong> use value <strong>20</strong><br>For <strong>Years</strong> use value <strong>30</strong></td></tr><tr><td>Rental period length</td><td>For <strong>Days</strong> use value <strong>0</strong><br>For <strong>Weeks</strong> use value <strong>10</strong><br>For <strong>Months</strong> use value <strong>20</strong><br>For <strong>Years</strong> use value <strong>30</strong></td></tr></tbody></table>

{% hint style="info" %}
All other column destinations do not support inputing multiple values in one cell, and they don't support using multiple columns as well.
{% endhint %}

## Example Table

<table><thead><tr><th width="134">Key (SKU)</th><th width="140">Name</th><th>Picture</th><th>Category</th></tr></thead><tbody><tr><td>001_A</td><td>IPhone 12</td><td>iphone12.png</td><td>Phone>>IPhone</td></tr><tr><td>002_A</td><td>IPhone 13</td><td>https://example.com/iphone13.png</td><td>IPhone</td></tr><tr><td>003_A</td><td>IPhone 14</td><td>C:\Pictures\iphone14.png</td><td>IPhone|New Products</td></tr><tr><td>004_M</td><td>Macbook Air</td><td>macbookair.png</td><td>Laptops>>Apple</td></tr><tr><td>005_M</td><td>Macbook Pro</td><td>macbookpro.png</td><td>Laptops>>Apple | Laptops>>High end</td></tr></tbody></table>