# 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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://importmanager.docs.foxnetsoft.com/column-mappings/product.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.