Suivant la m\u00eame m\u00e9thodologie que l’import export des commentaires clients, nous allons voir \u00e0 pr\u00e9sent comment importer\/ exporter les produits compl\u00e9mentaires.<\/p>\n
Nous partons du postulat que nous cr\u00e9ons un nouveau module \u00ab\u00a0Module_Dataflow\u00a0\u00bb
\n( les \u00e9tapes de cr\u00e9ation du module ne seront pas d\u00e9taill\u00e9es )<\/p>\n
Cette m\u00e9thode fonctionne pour les \u00e9l\u00e9ments suivants :<\/p>\n
<\/p>\n
Voici le xml pour l’export des produits compl\u00e9mentaires<\/p>\n
<action type=\"mymodule_dataflow\/convert_parser_LinkedProducts\" method=\"unparse\">\r\n<!-- Filtrage par produit <var name=\"product_id\" >157<\/var> -->\r\n<!-- Filtrage par type export ( upsell|crossel|related) defaut : upsell ) <var name=\"type\">upsell<\/var> -->\r\n<\/action>\r\n<action type=\"dataflow\/convert_mapper_column\" method=\"map\">\r\n<\/action>\r\n<action type=\"dataflow\/convert_parser_csv\" method=\"unparse\">\r\n<var name=\"delimiter\"><![CDATA[;]]><\/var>\r\n<var name=\"enclose\"><![CDATA[\"]]><\/var>\r\n<var name=\"fieldnames\">true<\/var>\r\n<\/action>\r\n<action type=\"dataflow\/convert_adapter_io\" method=\"save\">\r\n<var name=\"type\">file<\/var>\r\n<var name=\"path\">var\/export<\/var>\r\n<var name=\"filename\"><![CDATA[exports-produits-complementaires.csv]]><\/var>\r\n<\/action>\r\n<\/pre>\nVoici le xml d’import des produits ( Le type d’import est d\u00e9termin\u00e9 par le nom des colonnes du fichier )<\/p>\n
<action type=\"dataflow\/convert_adapter_io\" method=\"load\">\r\n<var name=\"type\">file<\/var>\r\n<var name=\"path\">var\/import<\/var>\r\n<var name=\"filename\"><![CDATA[produits complementaires.csv]]><\/var>\r\n<var name=\"format\"><![CDATA[csv]]><\/var>\r\n<\/action>\r\n<action type=\"dataflow\/convert_parser_csv\" method=\"parse\">\r\n<var name=\"delimiter\"><![CDATA[;]]><\/var>\r\n<var name=\"enclose\"><![CDATA[\"]]><\/var>\r\n<var name=\"fieldnames\">true<\/var>\r\n<var name=\"number_of_records\">1<\/var>\r\n<var name=\"decimal_separator\"><![CDATA[.]]><\/var>\r\n<var name=\"adapter\">mymodule_dataflow\/convert_parser_LinkedProducts<\/var>\r\n<var name=\"method\">parse<\/var>\r\n<\/action>\r\n<\/pre>\nVoici le code qui g\u00e8re l’import<\/p>\n
\r\n<?php\r\n\r\n\/**\r\n* Import des produits apparent\u00e9s\r\n* Import des ventes incitatives\r\n* Import des ventes crois\u00e9es\r\n*\r\n*\/\r\nclass MyModule_DataFlow_Model_Convert_Parser_LinkedProducts extends Mage_Eav_Model_Convert_Parser_Abstract {\r\n\r\n\r\n\r\npublic function parse() {\r\n\r\n$batchModel = Mage::getSingleton('dataflow\/batch');\r\n\r\n$batchImportModel = $batchModel->getBatchImportModel();\r\n$importIds = $batchImportModel->getIdCollection();\r\n\r\nforeach ($importIds as $importId) {\r\n$batchImportModel->load($importId);\r\n$importData = $batchImportModel->getBatchData();\r\n$this->saveRow($importData);\r\n}\r\n}\r\n\r\n\/**\r\n* Import des donn\u00e9es\r\n* @param type $importData\r\n*\/\r\npublic function saveRow($importData) {\r\n\r\n\/\/En fonction du nom de la colonne\u00a0 ( upsell_1 | related_1 | crossel_1 ) on d\u00e9termine quel import doit \u00eatre ex\u00e9cut\u00e9\r\nif (array_key_exists('related_1', $importData)){\r\n$mode = 'related';\r\n$method = 'setRelatedLinkData';\r\n}\r\nelse if (array_key_exists('crossel_1', $importData)) {\r\n$mode = 'crossel';\r\n$method = 'setCrossSellLinkData';\r\n}\r\nelse {\r\n$mode = 'upsell';\r\n$method = 'setUpSellLinkData';\r\n}\r\n\r\n\/\/Chargement du produit\r\n$productId = Mage::getModel('catalog\/product')->getIdBySku($importData['sku']);\r\n\r\nif (!$productId)\r\nreturn false;\r\n\r\n$product = Mage::getModel('catalog\/product')->load($productId);\r\n$complementaryProducts = array();\r\n\r\n$i = 1;\r\nforeach ($importData as $key => $data ) {\r\n\r\nif (preg_match('#^' . $mode . '#', $key) && $data != '') {\r\n\r\n$complementaryProductId = Mage::getModel('catalog\/product')->getIdBySku($data);\r\nif ( !$complementaryProductId ) {\r\n\/\/echo 'Produit '.$data.'n\\'existe pas';\r\ncontinue;\r\n}\r\n\r\n$complementaryProducts[$complementaryProductId] = array('position' => $i);\r\n$i++;\r\n}\r\n}\r\n$product->{$method}($complementaryProducts);\r\n$product->save();\r\n}\r\n\r\n\r\n\r\n\r\n\/**\r\n* Export des donn\u00e9es\r\n*\/\r\npublic function unparse() {\r\n\r\n$productId = $this->getVar('product_id'); \/\/Filtrage par produit\r\n$exportType = $this->getVar('type'); \/\/Mode d'export\r\n\r\n$products = Mage::getModel('catalog\/product')->getCollection();\r\n\r\nif ($productId)\r\n$products->addFieldToFilter('entity_id', $productId);\r\n\r\nforeach ($products as $product) {\r\n\r\n$product->load($product->getEntityId());\r\n\r\nif ($exportType == 'related') \/\/Produit li\u00e9\r\n$complementaryProducts = $product->getRelatedProducts();\r\nelse if ($exportType == 'crossel')\r\n$complementaryProducts = $product->getCrossSellProducts();\r\nelse {\r\n$complementaryProducts = $product->getUpSellProducts();\r\n$exportType = 'upsell';\r\n}\r\n\r\n\r\nif (sizeof($complementaryProducts)) {\r\n$rowData = array();\r\n$rowData['sku'] = $product->getSku();\r\n$rowData['product_name'] = $product->getName(); \/\/Cl\u00e9 volontairement chang\u00e9e pour ne pas \u00eatre import\u00e9e\r\n$i = 1;\r\nforeach ($complementaryProducts as $complementaryProduct) {\r\n$rowData[$exportType . '_' . $i] = $complementaryProduct->getSku();\r\n$i++;\r\n}\r\n\r\n$batchExport = $this->getBatchExportModel()\r\n->setId(null)\r\n->setBatchId($this->getBatchModel()->getId())\r\n->setBatchData($rowData)\r\n->setStatus(1)\r\n->save();\r\n}\r\n}\r\n}\r\n\r\n}\r\n\r\n?>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Suivant la m\u00eame m\u00e9thodologie que l’import export des commentaires clients, nous allons voir \u00e0 pr\u00e9sent comment importer\/ exporter les produits compl\u00e9mentaires. Nous partons du postulat que nous cr\u00e9ons un nouveau module \u00ab\u00a0Module_Dataflow\u00a0\u00bb ( les \u00e9tapes de cr\u00e9ation du module ne seront pas d\u00e9taill\u00e9es ) Cette m\u00e9thode fonctionne pour les \u00e9l\u00e9ments suivants : Produits apparent\u00e9s Ventes […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[246,6],"tags":[],"class_list":["post-687","post","type-post","status-publish","format-standard","hentry","category-magento-2","category-trucs-et-astuces"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/687","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/comments?post=687"}],"version-history":[{"count":1,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/687\/revisions"}],"predecessor-version":[{"id":688,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/687\/revisions\/688"}],"wp:attachment":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/media?parent=687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/categories?post=687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/tags?post=687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}