Export Product Information 

Export option helps export the product information and price attribute data from the product list in the .csv file.

Exporting products, filtered products, related products, price attribute data

Example of a product bulk export template

sku

attributeFamily.code

status

type

inventory_status.id

primaryUnitPrecision.unit.code

primaryUnitPrecision.precision

primaryUnitPrecision.conversionRate

primaryUnitPrecision.sell

additionalUnitPrecisions:0:unit:code

additionalUnitPrecisions:0:precision

additionalUnitPrecisions:0:conversionRate

additionalUnitPrecisions:0:sell

names.default.value

shortDescriptions.default.value

descriptions.default.value

featured

metaDescriptions.default.value

slugPrototypes.default.value

category.default.title

Kit Items

sku_001

default_family

enabled

simple

in_stock

item

3

1

1

item

0

5

1

Product Name

Product Short Description

system

1

defaultMetaDescription

lumen-item

Category Name

2EW02

default_family

enabled

kit

in_stock

set

3

1

1

set

0

5

1

Product Name

Product Short Description

system

1

defaultMetaDescription

touchscreen-pos-system

Category Name

id=1,label=“Base Unit”,optional=false,products=5TJ23|2RW93|1TB10,min_qty=1,max_qty=1,unit=set id=2,label=“Barcode Scanner”,optional=false,products=6VC22|4PJ19|7TY55,min_qty=1,max_qty=1,unit=item id=3,label=“Receipt Printer(s)”,optional=true,products=8DO33,min_qty=1,max_qty=,unit=item id=4,label=“Additional Card Reader(s)”,optional=true,products=1AB92|2LM04|2WE71,min_qty=1,max_qty=,unit=item

Example of a filtered products export template

attributeFamily.code

sku

status

type

primaryUnitPrecision.unit.code

inventory_status.id

primaryUnitPrecision.precision

primaryUnitPrecision.conversionRate

primaryUnitPrecision.sell

names.default.value

names.English.fallback

shortDescriptions.English.fallback

descriptions.English.fallback

featured

newArrival

backOrder.value

category.id

decrementQuantity.value

highlightLowInventory.value

inventoryThreshold.value

lowInventoryThreshold.value

manageInventory.value

maximumQuantityToOrder.value

metaDescriptions.English.fallback

metaKeywords.English.fallback

metaTitles.English.fallback

minimumQuantityToOrder.value

isUpcoming.value

slugPrototypes.default.value

slugPrototypes.English.fallback

category.default.title

default_family

M01

enabled

simple

item

in_stock

0

1

1

Decorative Pine Moulding (L)2.4m (W)32mm (T)12mm Decorative Pine Moulding (L)2.4m (W)32mm (T)12mm

system

system

system

0

0

category

1

category

category

category

category

category

category

system

system

system

category

category

decorative-pine-moulding-l24m-w32mm-t12mm-decorative-pine-moulding-l24m-w32mm-t12mm

system

All Products

Example of a related products export template

SKU

Related SKUs

PPR1

iT02,M01

Example of a product price attribute data export template

Product SKU

Price Attribute

Unit Code

Currency

Price

sku_001

MSRP/MAP

item

USD

20

To export the product information or price attribute data in a .csv format:

  1. In the main menu, navigate to Products > Products.

  2. Click Export Products, Export Filtered Products, Export Related Products, or Export Price Attribute Data on the top right.

Hint

Keep in mind that after clicking Export, you may receive the following warning message which notifies you about the limits for the number of columns that can be exported. Such warning can be displayed on the listing page of any exportable entity.

It appears that the number of fields stored as columns in the X table (the fields that are relations or that have ever been marked as “A”, “B”, “C”) has approached the limit after which it may no longer be possible to export Y with the standard X export.

Once 90% of the limit is reached, you will receive a flash message with the related warning.

Reaching 100% of the limit triggers a warning message on a potential inactive export when clicking the Export button.

  1. Once the export is complete, you will receive an email to download the .csv file.