How to export product data from Hybris Apparel Store to csv?
Go to hybris admin console.
Select console tab>>> Impex Export
Paste the below impex in import content tab and click on "Import Content" button
$productCatalog=apparelProductCatalog $productCatalogName=Apparel Product Catalog $catalogVersion=catalogversion(catalog(id[default=$productCatalog]),version[default='Staged'])[unique=true,default=$productCatalog:Staged] $baseProduct=baseProduct(code, catalogVersion(catalog(id[default='$productCatalog']),version[default='Staged'])) $approved=approvalstatus(code)[default='approved'] $taxGroup=Europe1PriceFactory_PTG(code)[default=eu-vat-full] $lang=en
### Impex to export product code, name,catalog version,supercategories######## "#% impex.setTargetFile( ""ApparelProduct.csv"" , true );" INSERT_UPDATE ApparelProduct;code[unique=true];name[lang=$lang];$catalogVersion;unit(code);supercategories(code,$catalogVersion) "#% impex.exportItems( ""ApparelProduct"" , false );"
### Impex to export product code, catalog version, unit,approval status,supercategories######## "#% impex.setTargetFile( ""ApparelProduct.csv"" , true );" INSERT_UPDATE ApparelProduct;code[unique=true];$catalogVersion;unit(code);supercategories(code,$catalogVersion);varianttype(code);$approved;$taxGroup;ean;genders(code) "#% impex.exportItems( ""ApparelProduct"" , false );"
$productCatalog=apparelProductCatalog $productCatalogName=Apparel Product Catalog $catalogVersion=catalogversion(catalog(id[default=$productCatalog]),version[default='Staged'])[unique=true,default=$productCatalog:Staged] $baseProduct=baseProduct(code, catalogVersion(catalog(id[default='$productCatalog']),version[default='Staged'])) $approved=approvalstatus(code)[default='approved'] $taxGroup=Europe1PriceFactory_PTG(code)[default=eu-vat-full] $lang=en
### Impex to export product code, name,catalog version,supercategories######## "#% impex.setTargetFile( ""ApparelProduct.csv"" , true );" INSERT_UPDATE ApparelProduct;code[unique=true];name[lang=$lang];$catalogVersion;unit(code);supercategories(code,$catalogVersion) "#% impex.exportItems( ""ApparelProduct"" , false );"
### Impex to export product code, catalog version, unit,approval status,supercategories######## "#% impex.setTargetFile( ""ApparelProduct.csv"" , true );" INSERT_UPDATE ApparelProduct;code[unique=true];$catalogVersion;unit(code);supercategories(code,$catalogVersion);varianttype(code);$approved;$taxGroup;ean;genders(code) "#% impex.exportItems( ""ApparelProduct"" , false );"
Comments