export order information

I only need a few, such as order number, customer, date, product and quantity, order status, total, and order id (basically the same column as you see in the screenshot) so the CSV file will only export the information I need, instead of all the information.

$new_row = array();

foreach ($row as $key => $value) 
 {
           if(in_array($key,array('order_number','name','order_created','order_full_price','order_product_name')))  
           $new_row[$key] = $value;

}

 if($maxProd && !empty($productFields)){
			for($i=1;$i<=$maxProd;$i++)
			{
				$prod =& $row->products[$i-1];
				foreach($productFields as $field)
				{
					if(in_array($field,array('order_product_quantity','order_product_name')))
					$n = 'item_'.$i.'_'.$field;
					$new_row->$n = @$prod->$field;
				}
			}
		}


$export->writeLine($new_row);

Hi,

What about the mass actions ?
Via System > Mass action you will be able to export only the desired fields in the csv file
hikashop.com/support/support/documentati...massaction-form.html

Thanks, that works too.

but the export button under the order tab is easier to use, just one click.


I end up fixing the code myself heres what I have :

foreach($this->orders as $row)
	{
		//format date
		if(!empty($row->user_created)) $row->user_created = hikashop_getDate($row->user_created,'%Y-%m-%d %H:%M:%S');
		if(!empty($row->order_created)) $row->order_created = hikashop_getDate($row->order_created,'%Y-%m-%d %H:%M:%S');
		if(!empty($row->order_modified)) $row->order_modified = hikashop_getDate($row->order_modified,'%Y-%m-%d %H:%M:%S');

		
		//info 
		$new_row = array();
		foreach ($row as $key => $value)  
		{
			if(in_array($key,array('order_number','name','order_created','order_full_price','order_product_name')))  
			$new_row[$key] = $value;
		}
		
		
		
		
		//info for item
		if($maxProd && !empty($productFields))
		{
			for($i=1;$i<=$maxProd;$i++)
			{
				$prod =& $row->products[$i-1];
				foreach($productFields as $field)
				{
					if(in_array($field,array('order_product_quantity','order_product_name')))
					{
					$new_row[] = @$prod->$field;
					}
				}
			}
		}
		
		
		$export->writeLine($new_row);
		
		

Hi, I tried using the plugin you gave me.

but theres a glitch.

No matter what I changed there will always be a title "product" on row 1 column 1.

<?php
/**
 * @package    HikaShop Vendor Zip Filter
 * @version    1.0.0
 * @author     Obsidev S.A.R.L.
 * @copyright  (C) 2012-2013 OBSIDEV. All rights reserved.
 * @license    GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
 */
defined('_JEXEC') or die('Restricted access');
?><?php
class plgHikaShopQuickbooksexport extends JPlugin {

	/**
	 *
	 */
	function __construct(&$subject, $config) {
		parent::__construct($subject, $config);
	}

	/**
	 *
	 */
	function onBeforeOrderExport(&$rows, &$obj) {
		// Load options
		//
		$activated = false;
		$pluginsClass = hikashop_get('class.plugins');
		$plugin = $pluginsClass->getByName('hikashop','quickbooksexport');
		if(!empty($plugin) ) {
			if(!empty($plugin->params['opt_activated'])) { 
				$activated = ($plugin->params['opt_activated'] == '1');
			}
		}
		if(!$activated)
			return;
		
		// Do export
		//
		$this->exportOrders($rows, $obj);
	}

	/**
	 *
	 */
	function onOrderExportList(&$exports) {
		$exports[] = 'quickbooksexport';
	}

	/**
	 *
	 */
	function exportOrders(&$rows, &$obj) {
		$fields = array(
			'order_full_price',
			'order_number',
			'name',
			'item_order_product_quantity',
			'item_order_product_name',
			'order_created'

		);
		$stripFields = array(
			'order_full_price',
			'order_number',
			'name',
			'item_order_product_quantity',
			'item_order_product_name',
			'order_created'
		);


		$newRows = array();
		foreach($rows as $k => $order) 
		{
			$data = new stdClass();
			$data->products = array();
			if(empty($order))
				continue;
			foreach($order as $k => $v) 
			{
				if(in_array($k, $fields)) 
				{
					$data->$k = $v;
				}
			}
			if(!empty($order->products)) {
				foreach($order->products as $product) 
				{
					foreach($product as $k => $v) 
					{
						$ik = 'item_'.$k;
						if(in_array($ik, $fields)) 
						{
							$data->$ik = $v;
						}
						if(in_array($ik, $stripFields)) 
						{
							$data->$ik = strip_tags($data->$ik);
						}
					}



					$newRows[] = (PHP_VERSION < 5) ? $data : clone($data);
				}
			} else {
				$newRows[] = $data;
			}
			unset($order);
			$rows[$k] = null;
		}
		$rows = $newRows;
	}
}

Hikashop 2.5.0
Joomla 3.4.4
Latest exportplugin version

The export function works fine.
But I have one problem.
I have customers that have only ordered one time.
But some order get listed multiple times after one another, and some only one time.
Even tough they have only created one order.

se image:

Hi I am having the same issue as above I am using this plugin and it is adding a "products column" in the first column of the csv which is throwing the formatting off so everything is off one column to the left because of this.

It would be really good for this to be fixed with first column not being "products" because I need this extension to be working by Monday. I have a presentation with a client to show them how to export orders and without this working I cannot do this.

Hi, thank you so much that fixed it. However, I have another issue. It appears that when using this override for the products it does not show custom fields that are attached to the product which is a problem. How do I get it to export the custom fields to this?

Thanks,

Josh

I forgot to mention when you use the normal export this is not an issue, however when you use the quickbooks override the custom fields do not show.

Hi, I figured it out now, but I have another question. I attached my plugin files which are working fine.. I added to the plugin pretty substantially based off the clients needs.

I basically have 3 options, a shipping export, order export and export individual columns.

if ( $plugin->params == '1' || $plugin->params == '2'){

However, when I select if $plugin->params == '0' I would like it to remove duplicate rows with the same order id. The problem is the customer has a sheet that they export that only has shipping information and because of that they only want the following exported which works fine with my code. However, it still shows multiple rows with the same order id. They do not want multiple rows because they are updated the tracking information and status. Is there a way to strip the duplicate rows before the file export with the same order id and inforatmion when the person selects the parameter if $plugin->params == '0'
$order_id
$order_status
$tracking_number
$shipping_address_firstname
$shipping_address_lastname
$shipping_address_street
$shipping_address_post_code
$shipping_address_city
$shipping_address_telephone
$shipping_address_state
$shipping_address_country

Thanks,

Josh

nicolas wrote: Hi,

Turn off the plugin and you'll get one row per order.
And if you want to choose which fields to included or not, I would recommend to actually use a mass action with an action "CSV export" on the order data. It will also allow you to export a CSV of the orders with one row per order and to choose which columns to export.

Hi,

I believe the Quickbooksexport plugin would just do what I need. Only I do not want to manually start the export. Is there a way to combine this with the mass actions? Or maybe by using cron-function?

Problem with the mass actions is that in the export of the orders, the order-rows are displayed in columns and I need it in rows like the Quickbooksexport.

Thanks!