Product
Product is used to export Products
Last updated
Product is used to export Products
Last updated
Altohugh product has many different column destinations, we would describe only ones that have special functionality.
Column destination | Explanation |
---|---|
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 |
---|---|
Key (SKU) | Name | Picture | Category |
---|---|---|---|
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.
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
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