Product

Product is used to export Products

Column Destinations

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

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

Column destination

Explanation

Picture

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 Product Picture entity.

Picture Alt attribute

Only one (main) picture will be included in this column. If you need to export all pictures, use Product Picture entity.

Picture Title attribute

Only one (main) picture will be included in this column. If you need to export all pictures, use Product Picture entity.

Picture Display Order

Only one (main) picture will be included in this column. If you need to export all pictures, use Product Picture entity.

Category Name or ID

If product exists in multiple categories, they will be included in one cell, | (vertical bar) symbol will be used to separate them. Example, Laptops|Macbook if product is in Laptops and Macbook category at the same time.

If you are exporting category name, it will be full category path. For example Laptops>>Macbooks.

Manufacturer Name or ID

If product exists in multiple manufacturers, they will be included in one cell, | (vertical bar) symbol will be used to separate them. Example, Apple|Dell if product is in Dell and Apple manufacturers at the same time.

Discount Name or ID

If your product has multiple discounts they will be saved using | (vertical bar) symbol. Example, 20% off|30% off if product has 20% off and 30% off discounts.

Specification Attribute '<Attribute Name>'

If your product has multiple options of the same attribute they will be saved using | (vertical bar) symbol.

Below you would find some constants that represent different values for some Column Mappings. These values will be used in cells during exports.

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

Column Destination

Constants

Product type

For Simple Product use value 5 For Grouped Product use value 10

Backorders

For No Backorders use value 0 For Allow Qty Below 0 use value 1 For Allow Qty Below 0 And Notify Customer use value 2

Download activation type

For When Order Is Paid use value 0 For Manualy use value 10

Gift card type

For Virtual use value 0 For Physical use value 1

Low stock activity

For Nothing use value 0 For Disable Buy Button use value 1 For Unpublish use value 2

Inventory method

For Dont Manage Stock use value 0 For Manage Stock use value 1 For Manage Stock By Attributes use value 2

Cycle Period

For Days use value 0 For Weeks use value 10 For Months use value 20 For Years use value 30

Rental period length

For Days use value 0 For Weeks use value 10 For Months use value 20 For Years use value 30

Example Table

Key (SKU)	Name	Picture	Category
001_A	IPhone 12	https://example.com/iphone12.png	Phone>>IPhone
002_A	IPhone 13	https://example.com/iphone13.png	Phone>>IPhone
003_A	IPhone 14	https://example.com/iphone14.png	Phone>>IPhone\|New Products
004_M	Macbook Air	https://example.com/macbookair.png	Laptops>>Apple
005_M	Macbook Pro	https://example.com/macbookpro.png	Laptops>>Apple \| Laptops>>High end

Key (SKU)

Name

Picture