Re-order the State/Zip code on order export [export orders pro module]

[Lindsayanng]

I have the export orders pro module and have yet to receive a response from the developer so I am hoping that someone can help me with this. I found this article about changing the order of State/Zipcode but I am sure that it does not change the export order for this module.

 

Is the answer as simple as changing the array list order??

 

$this->tables=array(
		'o'=>array(
			'n'=>'orders',
			'f'=>array(
				array(
					'n'=>'id_order',
					'l'=>$this->l('Order No')
				),
				array(
					'n'=>'payment',
					'l'=>$this->l('Payment')
				),
				array(
					'n'=>'recyclable',
					'l'=>$this->l('Recycled Packaging')
				),
				array(
					'n'=>'gift',
					'l'=>$this->l('Gift Wrapping')
				),
				array(
					'n'=>'gift_message',
					'l'=>$this->l('Gift Message')
				),
				array(
					'n'=>'shipping_number',
					'l'=>$this->l('Shipping Number')
				),
				array(
					'n'=>'total_discounts',
					'l'=>$this->l('Total Discounts')
				),
				array(
					'n'=>'total_paid',
					'l'=>$this->l('Total Paid')
				),
				array(
					'n'=>'total_paid_real',
					'l'=>$this->l('Total Paid Real')
				),
				array(
					'n'=>'total_products',
					'l'=>$this->l('Total Products')
				),
				array(
					'n'=>'total_shipping',
					'l'=>$this->l('Total Shipping')
				),
				array(
					'n'=>'total_wrapping',
					'l'=>$this->l('Total Wrapping')
				),
				array(
					'n'=>'invoice_number',
					'l'=>$this->l('Invoice No')
				),
				array(
					'n'=>'delivery_number',
					'l'=>$this->l('Delivery No')
				),
				array(
					'n'=>'invoice_date',
					'l'=>$this->l('Invoice Date')
				),
				array(
					'n'=>'delivery_date',
					'l'=>$this->l('Delivery Date')
				),
				array(
					'n'=>'date_add',
					'l'=>$this->l('Date Added')
				),
				array(
					'n'=>'date_upd',
					'l'=>$this->l('Date Updated')
				)
			)
		),
		'c'=>array(
			'n'=>'customer',
			'f'=>array(
				array(
					'n'=>'id_customer',
					'l'=>$this->l('Customer No')
				),
				array(
					'n'=>'firstname',
					'l'=>$this->l('First Name')
				),
				array(
					'n'=>'lastname',
					'l'=>$this->l('Last Name')
				),
				array(
					'n'=>'CONCAT(c.firstname, " ", c.lastname) AS fullname',
					'l'=>$this->l('Full Name'),
					'ni'=>true
				),
				array(
					'n'=>'email',
					'l'=>$this->l('Email')
				)
			),
			'w'=>'c.id_customer=o.id_customer'
		),
		'ad'=>array(
			'n'=>'address',
			'f'=>array(
				array(
					'n'=>'`firstname` AS deliveryfirstname',
					'l'=>$this->l('Delivery First Name')
				),
				array(
					'n'=>'`lastname` AS deliverylastname',
					'l'=>$this->l('Delivery Last Name')
				),
				array(
					'n'=>'CONCAT(ad.firstname, " ", ad.lastname) AS deliveryfullname',
					'l'=>$this->l('Delivery Full Name'),
					'ni'=>true
				),
				array(
					'n'=>'`company` AS deliverycompany',
					'l'=>$this->l('Delivery Company Name')
				),
				array(
					'n'=>'CONCAT(ad.`address1`, " ", ad.`address2`, " ", ad.`postcode`, " ", ad.`city`) AS adressdelivery',
					'l'=>$this->l('Delivery Address'),
					'ni'=>true
				),
				array(
					'n'=>'`address1` AS ad1',
					'l'=>$this->l('Delivery Address Line 1')
				),
				array(
					'n'=>'`address2` AS ad2',
					'l'=>$this->l('Delivery Address Line 2')
				),
				array(
					'n'=>'`postcode` AS adpostcode',
					'l'=>$this->l('Delivery Postcode')
				),
				array(
					'n'=>'`city` AS adcity',
					'l'=>$this->l('Delivery City')
				),
				array(
					'n'=>'`phone` AS adphone',
					'l'=>$this->l('Delivery Phone')
				),
				array(
					'n'=>'`phone_mobile` AS adphone_mobile',
					'l'=>$this->l('Delivery Phone (Mobile)')
				)
			),
			'w'=>'ad.id_address=o.id_address_delivery'
		),
		'ads'=>array(
			'n'=>'state',
			'f'=>array(
				array(
					'n'=>'COALESCE(ads.`iso_code`, "-") AS dstateiso',
					'l'=>$this->l('Delivery State ISO Code'),
					'ni'=>true
				),
				array(
					'n'=>'COALESCE(ads.`name`, "-") AS dstate',
					'l'=>$this->l('Delivery State'),
					'ni'=>true
				)
			),
			'w'=>'ads.id_state=ad.id_state',
			'j'=>true
		),
		'adc'=>array(
			'n'=>'country',
			'f'=>array(
				array(
					'n'=>'`iso_code` AS dcountryiso',
					'l'=>$this->l('Delivery Country ISO Code')
				)
			),
			'w'=>'adc.id_country=ad.id_country'
		),
		'adcl'=>array(
			'n'=>'country_lang',
			'f'=>array(
				array(
					'n'=>'`name` AS dcountry',
					'l'=>$this->l('Delivery Country')
				)
			),
			'w'=>'adcl.id_country=ad.id_country',
			'l'=>true
		),
		'ai'=>array(
			'n'=>'address',
			'f'=>array(
				array(
					'n'=>'`firstname` AS invoicefirstname',
					'l'=>$this->l('Invoice First Name')
				),
				array(
					'n'=>'`lastname` AS invoicelastname',
					'l'=>$this->l('Invoice Last Name')
				),
				array(
					'n'=>'CONCAT(ai.firstname, " ", ai.lastname) AS invoicefullname',
					'l'=>$this->l('Invoice Full Name'),
					'ni'=>true
				),
				array(
					'n'=>'`company` AS invoicecompany',
					'l'=>$this->l('Invoice Company Name')
				),
				array(
					'n'=>'CONCAT(ai.`address1`, " ", ai.`address2`, " ", ai.`postcode`, " ", ai.`city`) AS addressinvoice',
					'l'=>$this->l('Invoice Address'),
					'ni'=>true
				),
				array(
					'n'=>'`address1` AS ai1',
					'l'=>$this->l('Invoice Address Line 1')
				),
				array(
					'n'=>'`address2` AS ai2',
					'l'=>$this->l('Invoice Address Line 2')
				),
				array(
					'n'=>'`postcode` AS aipostcode',
					'l'=>$this->l('Invoice Postcode')
				),
				array(
					'n'=>'`city` AS aicity',
					'l'=>$this->l('Invoice City')
				),
				array(
					'n'=>'`phone` AS aiphone',
					'l'=>$this->l('Invoice Phone')
				),
				array(
					'n'=>'`phone_mobile` AS aiphone_mobile',
					'l'=>$this->l('Invoice Phone (Mobile)')
				)
			),
			'w'=>'ai.id_address=o.id_address_invoice'
		),
		'ais'=>array(
			'n'=>'state',
			'f'=>array(
				array(
					'n'=>'COALESCE(ais.`iso_code`, "-") AS istateiso',
					'l'=>$this->l('Invoice State ISO Code'),
					'ni'=>true
				),
				array(
					'n'=>'COALESCE(ais.`name`, "-") AS istate',
					'l'=>$this->l('Invoice State'),
					'ni'=>true
				)
			),
			'w'=>'ais.id_state=ai.id_state',
			'j'=>true
		),
		'aic'=>array(
			'n'=>'country',
			'f'=>array(
				array(
					'n'=>'`iso_code` AS icountryiso',
					'l'=>$this->l('Invoice Country ISO Code')
				)
			),
			'w'=>'aic.id_country=ad.id_country'
		),
		'aicl'=>array(
			'n'=>'country_lang',
			'f'=>array(
				array(
					'n'=>'`name` AS icountry',
					'l'=>$this->l('Invoice Country')
				)
			),
			'w'=>'aicl.id_country=ai.id_country',
			'l'=>true
		),
		'cr'=>array(
			'n'=>'currency',
			'f'=>array(
				array(
					'n'=>'iso_code',
					'l'=>$this->l('Currency')
				)
			),
			'w'=>'cr.id_currency=o.id_currency'
		),
		'od'=>array(
			'n'=>'order_detail',
			'f'=>array(
				array(
					'n'=>'product_id',
					'l'=>$this->l('Product Id')
				),
				array(
					'n'=>'product_attribute_id',
					'l'=>$this->l('Product Attribute Id')
				),
				array(
					'n'=>'product_name',
					'l'=>$this->l('Product Name')
				),
				array(
					'n'=>'product_quantity',
					'l'=>$this->l('Quantity')
				),
				array(
					'n'=>'product_price',
					'l'=>$this->l('Product Price')
				),
				array(
					'n'=>'product_ean13',
					'l'=>$this->l('Product EAN13')
				),
				array(
					'n'=>'product_reference',
					'l'=>$this->l('Product Reference')
				),
				array(
					'n'=>'product_weight',
					'l'=>$this->l('Product Weight')
				),
				array(
					'n'=>'tax_name',
					'l'=>$this->l('Tax Name')
				),
				array(
					'n'=>'tax_rate',
					'l'=>$this->l('Tax Rate')
				),
				array(
					'n'=>'ecotax',
					'l'=>$this->l('Eco Tax')
				)
			),
			'w'=>'od.id_order=o.id_order'
		)
	);