# Product

## 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>Picture</td><td>URL to a picture on your website. Only one (main) picture will be included in this column. If you need to export all pictures, use <a href="product-picture">Product Picture</a> entity.</td></tr><tr><td>Picture Alt attribute</td><td>Only one (main) picture will be included in this column. If you need to export all pictures, use <a href="product-picture">Product Picture</a> entity.</td></tr><tr><td>Picture Title attribute</td><td>Only one (main) picture will be included in this column. If you need to export all pictures, use <a href="product-picture">Product Picture</a> entity.</td></tr><tr><td>Picture Display Order</td><td>Only one (main) picture will be included in this column. If you need to export all pictures, use <a href="product-picture">Product Picture</a> entity.</td></tr><tr><td>Category Name or ID</td><td><p>If product exists in <strong>multiple categories,</strong> they will be included in one cell, | (vertical bar) symbol will be used to separate them. Example, <strong>Laptops|Macbook</strong> if product is in Laptops and Macbook category at the same time.<br></p><p>If you are exporting category name, it will be <strong>full category path</strong>. For example Laptops>>Macbooks.</p></td></tr><tr><td>Manufacturer Name or ID</td><td>If product exists in <strong>multiple manufacturers,</strong> they will be included in one cell, | (vertical bar) symbol will be used to separate them. Example, <strong>Apple|Dell</strong> if product is in Dell and Apple manufacturers at the same time.</td></tr><tr><td>Discount Name or ID</td><td>If your product has <strong>multiple discounts</strong> they will be saved using | (vertical bar) symbol. Example, <strong>20% off|30% off</strong> if product has 20% off and 30% off discounts.</td></tr><tr><td>Specification Attribute '&#x3C;Attribute Name>'</td><td>If your product has <strong>multiple options of the same attribute</strong> they will be saved using | (vertical bar) symbol.</td></tr></tbody></table>

{% hint style="warning" %}
Below you would find some constants that represent different values for some Column Mappings. These values will be used in cells during exports.
{% 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>

## 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>https://example.com/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>Phone>>IPhone</td></tr><tr><td>003_A</td><td>IPhone 14</td><td>https://example.com/iphone14.png</td><td>Phone>>IPhone|New Products</td></tr><tr><td>004_M</td><td>Macbook Air</td><td>https://example.com/macbookair.png</td><td>Laptops>>Apple</td></tr><tr><td>005_M</td><td>Macbook Pro</td><td>https://example.com/macbookpro.png</td><td>Laptops>>Apple | Laptops>>High end</td></tr></tbody></table>