<?php

// Uncomment to enable debugging

// ini_set('display_errors', '1');

// ini_set('error_reporting', E_ALL);

// Increase memory limit

ini_set('memory_limit', '-1');

// Increase maximum execution time to 4 hours

//ini_set('max_execution_time', 14400);

define('MAGENTO', realpath(dirname(__FILE__)).'/..');

require_once MAGENTO . '/app/Mage.php';

// Set working directory to magento root folder

chdir(MAGENTO);

// Make files written by the profile world-writable/readable

umask(0);

if (!function_exists('prepareCsv')) {

function prepareCsv($attributesCollection, $filename = "import.csv", $delimiter = '|', $enclosure = '"')

}

}

if (!function_exists('convert')) {

function convert($size)

}

}

echo "MEMORY USED : ".convert(memory_get_usage(true)) . "\n\n";

// Initialize the admin application

Mage::app('admin');

$writeConnection = Mage::getSingleton('core/resource')->getConnection('core_write');

/*

|--------------------------------------------------------------------------

| Product Delete script

|--------------------------------------------------------------------------

*/

//$writeConnection->query("DELETE FROM `catalog_product_entity`");

//$writeConnection->query("TRUNCATE TABLE `catalog_product_entity`");

/*

|--------------------------------------------------------------------------

| Prepare for Product Import ( works with magmi)

|--------------------------------------------------------------------------

*/

echo "Creating Products files. \n";

if (!is_dir(MAGENTO.'/var/split/old')) {

mkdir(MAGENTO.'/var/split/old', 0777, true);

}

if (!is_dir(MAGENTO.'/var/split/new')) {

mkdir(MAGENTO.'/var/split/new', 0777, true);

}

/*

|--------------------------------------------------------------------------

| Slpitting the Product

|--------------------------------------------------------------------------

*/

$handle = fopen(MAGENTO . "/var/product.csv", 'r');

$maxRange = 500;

$count = 0;

$prefix = 1;

$line = 1;

while (($data = fgetcsv($handle)) !== false) {

if ($line == 1) {

$headers = $data;

}

if ($data[0] != null) {

$count++;

if ($count > $maxRange) {

$prefix++;

$count = 0;

if ($prefix != 1) {

$filename = MAGENTO.'/var/split/old/product-' . $prefix . '.csv';

$write = fopen($filename, 'a');

fputcsv($write, $headers);

fclose($write);

}

echo "Count prefix [" . $prefix . "]\n";

}

$filename = MAGENTO.'/var/split/old/product-'. $prefix . '.csv';

$write = fopen($filename, 'a');

fputcsv($write, $data);

fclose($write);

} else {

$filename = MAGENTO.'/var/split/old/product-' . $prefix . '.csv';

$write = fopen($filename, 'a');

fputcsv($write, $data);

fclose($write);

}

$line++;

}

echo "\nMEMORY USED : ".convert(memory_get_usage(true)) . "\n\n";

unset($handle, $write, $data);

//$writeConnection->query('TRUNCATE log_url; TRUNCATE log_url_info; TRUNCATE log_visitor; TRUNCATE log_visitor_info; TRUNCATE dataflow_batch_import; TRUNCATE dataflow_batch_export; TRUNCATE index_event; TRUNCATE report_event;');

function array_equal($a, $b)

{

return (is_array($a) && is_array($b) && array_diff($a, $b) === array_diff($b, $a));

}

for ($i=1; $i <=$prefix ; $i++) {

$fileName = 'product-'.$i.'.csv';

$importer = new PrepareProductImporter();

$importer->run($fileName);

unset($importer);

}

echo "\nMEMORY USED : ".convert(memory_get_usage(true)) . "\n\n";

class PrepareProductImporter

}