Geek asks and answers

What is the best way to export Magento huge catalogs

I read a ton of documents about the Magento API, Magento models, and direct SQL calls. Since I read this, the first conclusion is that direct sql calls will be very fast, but I have to be especially careful in providing security, and using models makes development faster and easier, but on the other hand, it loses performance by manipulating huge catalogs.

I will have to deal with a store with about 50 thousand products and heavy traffic, and I have to export them to another server with a hierarchy of categories, sku, description, image, product_name, url_path once and after receiving only updated once per hour. A better approach would be with direct sql calls, but would it be suicide to do it with models? And you think that integrating it with the SOAP API will be another suicide, and I have to do it in a separate PHP for this?

Super thanks in advance, I am very lost in this, and I apologize for my poor English Vinicius

+5
source share
3 answers

. , . SQL magento store xml. , sql , , . . 15 , , 50k x 15 sql. , SQL-.

... API , magento. magento. . "US SPECIAL SHIPPING", API .

... sql xml. , .

magento connect, . . . script

<?php 

set_time_limit(3000);
ini_set('memory_limit', '-1');
include_once 'app/Mage.php';
umask(0);
Mage::app();
$products = Mage::getModel('catalog/product')->getCollection();
$products->addAttributeToSelect('*');
$products->load(); 
$baseUrl = Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB);                       
    $output = '<?xml version="1.0" encoding="utf-8"?>
    <products>';
if (count($products)): 

  foreach ($products as $id => $product):

  $url = $product->getProductUrl();
  $output .= '
  <product>
  <id>'. $product['entity_id'].'</id>
  <name><![CDATA['. $product['name'] .']]></name>
  <sku>'. $product['sku'] .'</sku>
  <description><![CDATA['. $product['description'] .']]></description>
  <shortdescription><![CDATA['. $product['short_description'] .']]></shortdescription>
  <price><![CDATA['. $product['price'] .']]></price>
  <minimalprice>'. $product['minimal_price'] .'</minimalprice>   
  <weight><![CDATA['. $product['weight'] .']]></weight>
  <categories><![CDATA['. $product['categories'] .']]></categories>
  <color><![CDATA['. $product['color'] .']]></color>
  <condition><![CDATA['. $product['condition'] .']]></condition>
  <availability><![CDATA['. $product['availability'] .']]></availability>
  <shipping><![CDATA['. $product['shipping'] .']]></shipping>
  <url><![CDATA['. $url.']]></url>
  <meta><![CDATA['. $product['meta_keyword'] .']]></meta>
  <metadescription><![CDATA['. $product['meta_description'] .']]></metadescription>
  <manufacturer><![CDATA['. $product['manufacturer'] .']]></manufacturer>
  <brand><![CDATA['. $product['brand'] .']]></brand>
  <upc><![CDATA['. $product['upc'] .']]></upc>
  <mpn><![CDATA['. $product['mpn'] .']]></mpn>
  <image><![CDATA['. $baseUrl ."media/catalog/product". $product['image'] .']]>        </image>';
  if (isset($attributes[$product['entity_id']])) {
  $output .= '
  <attributes>';  
  foreach ($attributes[$product['entity_id']] as $attribute => $values)
   $output .= '
    <attribute>
     <name>'. $attribute .'</name>
      <values>'.  join(', ', $values) . '</values>
     </attribute>';  
   $output .= '
 </attributes>';
  }

$output .= '
</product>';
endforeach;
endif;
header ("Content-Type: text/xml; charset=ISO-8859-1");
print $output .= '
 </products>'; 
?>
+1

1) api 50K .
2) sql - EAV
3), , , magento / . .

+1

Magento Google . (, - , ).

magento export, php.ini :

ini_set(’max_execution_time’,’1800’);
ini_set(’memory_limit’,’1024M’);

!

+1

More articles:


All Articles