Taxify_Sales_Tax_Rates_and_Filing - Version 0.1.2

Version Notes

Initial Public Release

Download this release

Release Info

Developer Vonnda Development
Extension Taxify_Sales_Tax_Rates_and_Filing
Version 0.1.2
Comparing to
See all releases


Code changes from version 0.1.1 to 0.1.2

app/code/local/Vonnda/Taxify/Model/.Observer.php.swp ADDED
Binary file
app/code/local/Vonnda/Taxify/Model/Export.php ADDED
@@ -0,0 +1,190 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Vonnda_Taxify_Model_Export extends Mage_Core_Model_Abstract
4
+ {
5
+
6
+ public $pageSize;
7
+ public $cursor;
8
+ public $orderStatuses = array();
9
+ public $from = '1980-01-01 00:00:00';
10
+ public $to = '2092-01-01 00:00:00';
11
+ public $helper;
12
+ public $taxClassMap = array();
13
+
14
+ public function __construct()
15
+ {
16
+ parent::__construct();
17
+
18
+ $this->resource = Mage::getSingleton('core/resource');
19
+ $this->readConnection = $this->resource->getConnection('core_read');
20
+ $this->salesFlatOrderTable = $this->resource->getTableName('sales/order');
21
+ $this->salesFlatOrderAddressTable = $this->resource->getTableName('sales/order_address');
22
+ $this->salesFlatOrderItemTable = $this->resource->getTableName('sales/order_item');
23
+ $this->helper = Mage::helper('taxify');
24
+
25
+ $this->cursor = 0;
26
+ $this->pageSize = 100;
27
+ }
28
+
29
+ public function fetch($page)
30
+ {
31
+ $this->cursor = $page * $this->pageSize;
32
+ $queryRows = $this->readConnection->fetchAll($this->buildQuery());
33
+ $queryRows = $this->addTaxClassId($queryRows);
34
+ $queryRows = $this->addTransactionType($queryRows);
35
+ $rows = array();
36
+ foreach ($queryRows as $queryRow) {
37
+ $exportRow = Mage::getModel('taxify/export_row');
38
+ $exportRow->in($queryRow);
39
+ $rows[] = $exportRow->out();
40
+ }
41
+
42
+ $shippinglineQueryRows = $this->readConnection->fetchAll($this->buildShippingLinesQuery());
43
+ foreach ($shippinglineQueryRows as $queryRow) {
44
+ $exportRow = Mage::getModel('taxify/export_row');
45
+ $exportRow->in($queryRow);
46
+ $rows[] = $exportRow->out();
47
+ }
48
+
49
+ return $rows;
50
+ }
51
+
52
+ public function buildQuery()
53
+ {
54
+
55
+ $query = "select
56
+ `increment_id`,
57
+ $this->salesFlatOrderTable.created_at,
58
+ $this->salesFlatOrderTable.customer_id,
59
+ $this->salesFlatOrderTable.customer_lastname,
60
+ $this->salesFlatOrderTable.customer_firstname,
61
+ $this->salesFlatOrderTable.customer_email,
62
+ street,
63
+ city,
64
+ region,
65
+ postcode,
66
+ sku,
67
+ $this->salesFlatOrderItemTable.product_id,
68
+ $this->salesFlatOrderItemTable.name,
69
+ $this->salesFlatOrderItemTable.price,
70
+ $this->salesFlatOrderItemTable.qty_ordered,
71
+ $this->salesFlatOrderItemTable.tax_amount,
72
+ $this->salesFlatOrderTable.customer_group_id
73
+ from
74
+ $this->salesFlatOrderItemTable
75
+ left join
76
+ $this->salesFlatOrderTable on $this->salesFlatOrderTable.entity_id = $this->salesFlatOrderItemTable.order_id
77
+ left join
78
+ $this->salesFlatOrderAddressTable on $this->salesFlatOrderTable.shipping_address_id = $this->salesFlatOrderAddressTable.entity_id
79
+ where
80
+ $this->salesFlatOrderTable.created_at >= '$this->from' and
81
+ $this->salesFlatOrderTable.created_at <= '$this->to'";
82
+
83
+ if ($this->orderStatuses) {
84
+ $query .= "\nand $this->salesFlatOrderTable.status in ('". implode("','", $this->orderStatuses). "')";
85
+ }
86
+
87
+ $query .= "\nORDER BY $this->salesFlatOrderTable.created_at asc";
88
+ $query .= "\nLIMIT $this->cursor,$this->pageSize";
89
+
90
+ return $query;
91
+ }
92
+
93
+ public function buildShippingLinesQuery()
94
+ {
95
+ $query = "select
96
+ `increment_id`,
97
+ $this->salesFlatOrderTable.created_at,
98
+ $this->salesFlatOrderTable.customer_id,
99
+ $this->salesFlatOrderTable.customer_lastname,
100
+ $this->salesFlatOrderTable.customer_firstname,
101
+ $this->salesFlatOrderTable.customer_email,
102
+ street,
103
+ city,
104
+ region,
105
+ postcode,
106
+ 'SHIPPING' as sku,
107
+ 0 as product_id,
108
+ 'Shipping' as name,
109
+ shipping_amount as price,
110
+ 1 as qty_invoiced,
111
+ 0 as tax_amount
112
+ from
113
+ $this->salesFlatOrderTable
114
+ left join
115
+ $this->salesFlatOrderAddressTable on $this->salesFlatOrderTable.shipping_address_id = $this->salesFlatOrderAddressTable.entity_id
116
+ where
117
+ $this->salesFlatOrderTable.created_at >= '$this->from' and
118
+ $this->salesFlatOrderTable.created_at <= '$this->to'";
119
+
120
+ if ($this->orderStatuses) {
121
+ $query .= "\nand $this->salesFlatOrderTable.status in ('". implode("','", $this->orderStatuses). "')";
122
+ }
123
+
124
+ $query .= "\nORDER BY $this->salesFlatOrderTable.created_at asc";
125
+ $query .= "\nLIMIT $this->cursor,$this->pageSize";
126
+
127
+ return $query;
128
+ }
129
+
130
+ public function addTaxClassId($queryRows)
131
+ {
132
+ $map = $this->getProductTaxClassMap();
133
+ $newRows = array();
134
+ foreach ($queryRows as $row) {
135
+ $row['tax_class_id'] = '';
136
+ if (isset($map[$row['product_id']])) {
137
+ $row['tax_class_id'] = $map[$row['product_id']];
138
+ }
139
+ $newRows[] = $row;
140
+ }
141
+
142
+ return $newRows;
143
+ }
144
+
145
+ public function addTransactionType($queryRows)
146
+ {
147
+ $newRows = array();
148
+ foreach ($queryRows as $row) {
149
+ $row['transaction_type'] = '';
150
+ if (isset($row['customer_group_id'])) {
151
+ $row['transaction_type'] = $this->getTaxifyCustomerTaxabilityFromGroup($row['customer_group_id']);
152
+ }
153
+ $newRows[] = $row;
154
+ }
155
+
156
+ return $newRows;
157
+ }
158
+
159
+ public function getProductTaxClassMap()
160
+ {
161
+ if (isset($this->productTaxClassMap)) {
162
+ return $this->productTaxClassMap;
163
+ }
164
+
165
+ $products = Mage::getModel('catalog/product')
166
+ ->getCollection()
167
+ ->addAttributeToSelect('tax_class_id');
168
+
169
+ $map = array();
170
+ foreach ($products as $product) {
171
+ $map[$product->getId()] = $product->getTaxClassId();
172
+ }
173
+ $this->productTaxClassMap = $map;
174
+
175
+ return $this->productTaxClassMap;
176
+ }
177
+
178
+ public function getTaxifyCustomerTaxabilityFromGroup($groupId)
179
+ {
180
+ if (array_key_exists($groupId, $this->taxClassMap)) {
181
+ return $this->taxClassMap[$groupId];
182
+ }
183
+
184
+ $taxClass = $this->helper->getTaxifyCustomerTaxabilityFromGroup($groupId);
185
+ $this->taxClassMap[$groupId] = $taxClass;
186
+
187
+ return $taxClass;
188
+ }
189
+
190
+ }
app/code/local/Vonnda/Taxify/Model/Export/Row.php ADDED
@@ -0,0 +1,100 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Vonnda_Taxify_Model_Export_Row extends Mage_Core_Model_Abstract
4
+ {
5
+ public $map = array();
6
+ public $queryRow = array();
7
+ public $row = array();
8
+
9
+ public function __construct()
10
+ {
11
+ parent::__construct();
12
+
13
+ $this->map = array(
14
+ 'increment_id' => 'transaction_number',
15
+ 'taxability_code' => 'transaction_type',
16
+ 'created_at' => 'transaction_date',
17
+ 'customer_id' => 'customer_number',
18
+ 'customer_lastname' => 'last_name',
19
+ 'customer_firstname' => 'first_name',
20
+ '' => 'company',
21
+ 'customer_email' => 'email',
22
+ '' => 'phone',
23
+ '' => 'address',
24
+ '' => 'address2',
25
+ 'city' => 'city',
26
+ 'region' => 'state',
27
+ 'postcode' => 'zip',
28
+ '' => 'item_type',
29
+ 'sku' => 'sku',
30
+ 'name' => 'description',
31
+ 'price' => 'unit_price',
32
+ 'qty_invoiced' => 'quantity',
33
+ 'tax_amount' => 'tax_collected',
34
+ );
35
+ }
36
+
37
+ public function splitStreet()
38
+ {
39
+ $parts = explode("\n", $this->queryRow['street']);
40
+ $this->row['address'] = $parts[0];
41
+ if (isset($parts[1])) {
42
+ $this->row['address2'] = $parts[1];
43
+ } else {
44
+ $this->row['address2'] = '';
45
+ }
46
+ unset($this->row['street']);
47
+ }
48
+
49
+ public function in($queryRow)
50
+ {
51
+ $this->queryRow = $queryRow;
52
+ $this->mapValues();
53
+ $this->splitStreet();
54
+ $this->mapItemTaxabilityCode();
55
+ $this->removeUnwantedColumns();
56
+ }
57
+
58
+ public function removeUnwantedColumns()
59
+ {
60
+ unset($this->row['tax_class_id']);
61
+ unset($this->row['product_id']);
62
+ }
63
+
64
+ public function mapValues()
65
+ {
66
+ $this->row = array();
67
+ foreach ($this->queryRow as $key => $value) {
68
+ $newKey = $key;
69
+ if (isset($this->map[$key])) {
70
+ $newKey = $this->map[$key];
71
+ }
72
+ $this->row[$newKey] = $value;
73
+ }
74
+ }
75
+
76
+ public function out()
77
+ {
78
+ return $this->row;
79
+ }
80
+
81
+ public function mapItemTaxabilityCode()
82
+ {
83
+ if (!isset($this->row['tax_class_id'])) {
84
+ $this->row['tax_collected_type'] = '';
85
+ return;
86
+ }
87
+
88
+ $taxClassId = $this->row['tax_class_id'];
89
+
90
+ $map = array('0' => 'NON', '6' => 'NON');
91
+
92
+ if (isset($map[$taxClassId])) {
93
+ $this->row['tax_collected_type'] = $map[$taxClassId];
94
+ return;
95
+ }
96
+
97
+ $this->row['tax_collected_type'] = '';
98
+ }
99
+
100
+ }
app/code/local/Vonnda/Taxify/Model/Request/.Calculate.php.swp DELETED
Binary file
app/code/local/Vonnda/Taxify/Model/Sales/Quote/Address/Total/.Tax.php.swp ADDED
Binary file
app/code/local/Vonnda/Taxify/Model/Sales/Quote/Address/Total/Tax.php CHANGED
@@ -61,6 +61,7 @@ class Vonnda_Taxify_Model_Sales_Quote_Address_Total_Tax extends Mage_Sales_Model
61
  $lineTax = $calculate->getTaxByLineNumber($item->getId());
62
  $item->setTaxPercent($lineTax['rate']);
63
  $item->setTaxAmount($lineTax['amount']);
 
64
  //$item->calcTaxAmount();
65
 
66
  if ($discountBefore != $item->getDiscountAmount()) {
61
  $lineTax = $calculate->getTaxByLineNumber($item->getId());
62
  $item->setTaxPercent($lineTax['rate']);
63
  $item->setTaxAmount($lineTax['amount']);
64
+ $item->setBaseTaxAmount($lineTax['amount']);
65
  //$item->calcTaxAmount();
66
 
67
  if ($discountBefore != $item->getDiscountAmount()) {
app/code/local/Vonnda/Taxify/controllers/ExportController.php ADDED
@@ -0,0 +1,51 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Vonnda_Taxify_ExportController extends Mage_Adminhtml_Controller_Action
4
+ {
5
+
6
+ public function indexAction()
7
+ {
8
+ $this->loadLayout();
9
+ $content = $this->getLayout()->createBlock('Mage_Core_Block_Template', 'taxify_export', array('template' => 'taxify/export.phtml'));
10
+ $this->getLayout()->getBlock('content')->insert($content);
11
+ $this->renderLayout();
12
+ }
13
+
14
+ public function exportAction()
15
+ {
16
+ $export = Mage::getModel('taxify/export');
17
+ $export->orderStatuses = $this->getRequest()->getParam('order_statuses', array());
18
+ $export->from = date('Y-m-d H:i:s', strtotime($this->getRequest()->getParam('from', '1980-01-01 00:00:00')));
19
+ $export->to = date('Y-m-d H:i:s', strtotime($this->getRequest()->getParam('to', '2092-01-01 00:00:00')));
20
+
21
+ $fileName = 'taxify-export.csv';
22
+
23
+ header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
24
+ header('Content-Description: File Transfer');
25
+ header('Content-type: text/csv');
26
+ header("Content-Disposition: attachment; filename={$fileName}");
27
+ header('Expires: 0');
28
+ header('Pragma: public');
29
+
30
+ $fh = @fopen('php://output', 'w');
31
+
32
+
33
+ $count = 0;
34
+ while ($count < 100000) {
35
+ $rows = $export->fetch($count);
36
+ if (count($rows) == 0) {
37
+ break;
38
+ }
39
+ // Add header
40
+ if ($count == 0) {
41
+ fputcsv($fh, array_keys($rows[0]));
42
+ }
43
+ foreach ($rows as $row) {
44
+ fputcsv($fh, $row);
45
+ }
46
+ $count = $count + 1;
47
+ }
48
+ fclose($fh);
49
+ exit;
50
+ }
51
+ }
app/code/local/Vonnda/Taxify/etc/adminhtml.xml ADDED
@@ -0,0 +1,39 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?xml version="1.0"?>
2
+ <config>
3
+ <acl>
4
+ <resources>
5
+ <admin>
6
+ <children>
7
+ <system>
8
+ <children>
9
+ <tools>
10
+ <children>
11
+ <taxify-export translate="title" module="taxify">
12
+ <title>Taxify Order Export</title>
13
+ <sort_order>0</sort_order>
14
+ </taxify-export>
15
+ </children>
16
+ </tools>
17
+ </children>
18
+ </system>
19
+ </children>
20
+ </admin>
21
+ </resources>
22
+ </acl>
23
+
24
+ <menu>
25
+ <system>
26
+ <children>
27
+ <tools>
28
+ <children>
29
+ <taxify-export translate="title" module="taxify">
30
+ <title>Taxify Order Export</title>
31
+ <sort_order>1000</sort_order>
32
+ <action>admintaxify/export/index</action>
33
+ </taxify-export>
34
+ </children>
35
+ </tools>
36
+ </children>
37
+ </system>
38
+ </menu>
39
+ </config>
app/code/local/Vonnda/Taxify/etc/config.xml CHANGED
@@ -2,7 +2,7 @@
2
  <config>
3
  <modules>
4
  <Vonnda_Taxify>
5
- <version>0.1.1</version>
6
  </Vonnda_Taxify>
7
  </modules>
8
  <global>
@@ -76,6 +76,17 @@
76
  </sales_order_payment_cancel>
77
  </events>
78
  </global>
 
 
 
 
 
 
 
 
 
 
 
79
  <adminhtml>
80
  <events>
81
  <controller_action_predispatch>
2
  <config>
3
  <modules>
4
  <Vonnda_Taxify>
5
+ <version>0.1.2</version>
6
  </Vonnda_Taxify>
7
  </modules>
8
  <global>
76
  </sales_order_payment_cancel>
77
  </events>
78
  </global>
79
+ <admin>
80
+ <routers>
81
+ <vonnda_taxify>
82
+ <use>admin</use>
83
+ <args>
84
+ <module>Vonnda_Taxify</module>
85
+ <frontName>admintaxify</frontName>
86
+ </args>
87
+ </vonnda_taxify>
88
+ </routers>
89
+ </admin>
90
  <adminhtml>
91
  <events>
92
  <controller_action_predispatch>
app/code/local/Vonnda/Taxify/tests/Model/Export/RowTest.php ADDED
@@ -0,0 +1,116 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ require_once '../../app/Mage.php'; umask(0); Mage::app('default');
4
+
5
+ class RowTest extends PHPUnit_Framework_TestCase
6
+ {
7
+ public function setUp()
8
+ {
9
+ $this->model = Mage::getModel('taxify/export_row');
10
+ }
11
+
12
+ public function testModelExists()
13
+ {
14
+ $this->assertEquals('object', gettype($this->model));
15
+ }
16
+
17
+ public function testModelHasMap()
18
+ {
19
+ $row = Mage::getModel('taxify/export_row');
20
+ $expected = array(
21
+ 'increment_id' => 'transaction_number',
22
+ 'taxability_code' => 'transaction_type',
23
+ 'created_at' => 'transaction_date',
24
+ 'customer_id' => 'customer_number',
25
+ 'customer_lastname' => 'last_name',
26
+ 'customer_firstname' => 'first_name',
27
+ '' => 'company',
28
+ 'customer_email' => 'email',
29
+ '' => 'phone',
30
+ '' => 'address',
31
+ '' => 'address2',
32
+ 'city' => 'city',
33
+ 'region' => 'state',
34
+ 'postcode' => 'zip',
35
+ '' => 'item_type',
36
+ 'sku' => 'sku',
37
+ 'name' => 'description',
38
+ 'price' => 'unit_price',
39
+ 'qty_invoiced' => 'quantity',
40
+ 'tax_amount' => 'tax_collected',
41
+ );
42
+
43
+ $this->assertEquals($expected, $row->map);
44
+ }
45
+
46
+ public function testIn()
47
+ {
48
+ $queryRow = array (
49
+ 'increment_id' => '100000049',
50
+ 'created_at' => '2013-03-14 17:01:34',
51
+ 'customer_id' => NULL,
52
+ 'customer_lastname' => 'Akizian',
53
+ 'customer_firstname' => 'Mosses',
54
+ 'customer_email' => 'mosses@ebay.com',
55
+ 'street' => '10441 Jefferson Blvd., Suite 200',
56
+ 'city' => 'Culver City',
57
+ 'region' => 'California',
58
+ 'postcode' => '90232',
59
+ 'sku' => 'abl007',
60
+ 'name' => 'Classic Hardshell Suitcase 29',
61
+ 'price' => '750.0000',
62
+ 'qty_invoiced' => '0.0000',
63
+ );
64
+
65
+ $expected = array (
66
+ 'transaction_number' => '100000049',
67
+ 'transaction_date' => '2013-03-14 17:01:34',
68
+ 'customer_number' => NULL,
69
+ 'last_name' => 'Akizian',
70
+ 'first_name' => 'Mosses',
71
+ 'email' => 'mosses@ebay.com',
72
+ 'city' => 'Culver City',
73
+ 'state' => 'California',
74
+ 'zip' => '90232',
75
+ 'sku' => 'abl007',
76
+ 'description' => 'Classic Hardshell Suitcase 29',
77
+ 'unit_price' => '750.0000',
78
+ 'quantity' => '0.0000',
79
+ 'address' => '10441 Jefferson Blvd., Suite 200',
80
+ 'address2' => '',
81
+ 'tax_collected_type' => '',
82
+ );
83
+
84
+ $this->model->in($queryRow);
85
+ $resp = $this->model->row;
86
+
87
+ $this->assertEquals($expected, $resp);
88
+ }
89
+
90
+ public function testMultipleAddressLines()
91
+ {
92
+ $queryRow = array (
93
+ 'increment_id' => '145000002',
94
+ 'created_at' => '2015-02-17 20:33:41',
95
+ 'customer_id' => '142',
96
+ 'customer_lastname' => 'Sanborn',
97
+ 'customer_firstname' => 'Mark',
98
+ 'customer_email' => 'mark.sanborn@vonnda.com',
99
+ 'street' => '660 York St
100
+ Suite 202',
101
+ 'city' => 'San Francisco',
102
+ 'region' => 'California',
103
+ 'postcode' => '94115',
104
+ 'sku' => 'msj003xs',
105
+ 'name' => 'Slim fit Dobby Oxford Shirt',
106
+ 'price' => '140.0000',
107
+ 'qty_invoiced' => '0.0000',
108
+ );
109
+
110
+ $this->model->in($queryRow);
111
+ $resp = $this->model->row;
112
+
113
+ $this->assertEquals('660 York St', $resp['address']);
114
+ $this->assertEquals('Suite 202', $resp['address2']);
115
+ }
116
+ }
app/code/local/Vonnda/Taxify/tests/Model/ExportTest.php ADDED
@@ -0,0 +1,146 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ require_once '../../app/Mage.php'; umask(0); Mage::app('default');
4
+
5
+ use \Mockery as m;
6
+
7
+ class ExportTest extends PHPUnit_Framework_TestCase
8
+ {
9
+ public function setUp()
10
+ {
11
+ $this->model = Mage::getModel('taxify/export');
12
+ $this->assertEquals('object', gettype($this->model));
13
+ $this->queryResult = unserialize(file_get_contents('code/tests/fixtures/exportQueryResult.txt'));
14
+ }
15
+
16
+ public function tearDown()
17
+ {
18
+ m::close();
19
+ }
20
+
21
+ public function testBuildQuery()
22
+ {
23
+ $this->model->cursor = 20;
24
+ $resp = $this->model->buildQuery();
25
+
26
+ $expected = 'select
27
+ `increment_id`,
28
+ sales_flat_order.created_at,
29
+ sales_flat_order.customer_id,
30
+ sales_flat_order.customer_lastname,
31
+ sales_flat_order.customer_firstname,
32
+ sales_flat_order.customer_email,
33
+ street,
34
+ city,
35
+ region,
36
+ postcode,
37
+ sku,
38
+ sales_flat_order_item.product_id,
39
+ sales_flat_order_item.name,
40
+ sales_flat_order_item.price,
41
+ sales_flat_order_item.qty_ordered,
42
+ sales_flat_order_item.tax_amount,
43
+ sales_flat_order.customer_group_id
44
+ from
45
+ sales_flat_order_item
46
+ left join
47
+ sales_flat_order on sales_flat_order.entity_id = sales_flat_order_item.order_id
48
+ left join
49
+ sales_flat_order_address on sales_flat_order.shipping_address_id = sales_flat_order_address.entity_id
50
+ where
51
+ sales_flat_order.created_at >= \'1980-01-01 00:00:00\' and
52
+ sales_flat_order.created_at <= \'2092-01-01 00:00:00\'
53
+ ORDER BY sales_flat_order.created_at asc
54
+ LIMIT 20,100';
55
+
56
+ $this->assertEquals($expected, $resp);
57
+ }
58
+
59
+ public function testBuildQueryAddsStatusFilters()
60
+ {
61
+ $this->model->orderStatuses = array('complete', 'pending');
62
+ $resp = $this->model->buildQuery();
63
+ $this->assertRegExp('/where/', $resp);
64
+ $this->assertRegExp('/pending/', $resp);
65
+ }
66
+
67
+ public function testBuildQueryAddsFromFilter()
68
+ {
69
+ $this->model->from = '2013-04-03 17:25:53';
70
+ $this->model->to = '2016-04-03 17:25:53';
71
+ $resp = $this->model->buildQuery();
72
+ $this->assertRegExp('/2013-04-03 17:25:53/', $resp);
73
+ $this->assertRegExp('/2016-04-03 17:25:53/', $resp);
74
+ }
75
+
76
+ public function testFetch()
77
+ {
78
+ $mock = m::mock('connection');
79
+ $mock->shouldReceive('fetchAll')->andReturn($this->queryResult);
80
+ $this->model->readConnection = $mock;
81
+ $resp = $this->model->fetch();
82
+
83
+ $this->assertTrue(is_array($resp));
84
+ }
85
+
86
+ // integration
87
+ public function testAddTaxClassId()
88
+ {
89
+ $model = Mage::getModel('taxify/export');
90
+ $mock = m::mock('connection');
91
+ $mock->shouldReceive('fetchAll')->andReturn(array(array()));
92
+ $model->readConnection = $mock;
93
+ $resp = $model->fetch();
94
+
95
+ $this->assertTrue(array_key_exists('tax_collected_type', $resp[0]), 'It should contain tax_collected_type');
96
+ }
97
+
98
+ public function testBuildShippingLinesQuery()
99
+ {
100
+ $this->model->cursor = 20;
101
+ $expected = "select
102
+ `increment_id`,
103
+ sales_flat_order.created_at,
104
+ sales_flat_order.customer_id,
105
+ sales_flat_order.customer_lastname,
106
+ sales_flat_order.customer_firstname,
107
+ sales_flat_order.customer_email,
108
+ street,
109
+ city,
110
+ region,
111
+ postcode,
112
+ 'SHIPPING' as sku,
113
+ 0 as product_id,
114
+ 'Shipping' as name,
115
+ shipping_amount as price,
116
+ 1 as qty_invoiced,
117
+ 0 as tax_amount
118
+ from
119
+ sales_flat_order
120
+ left join
121
+ sales_flat_order_address on sales_flat_order.shipping_address_id = sales_flat_order_address.entity_id
122
+ where
123
+ sales_flat_order.created_at >= '1980-01-01 00:00:00' and
124
+ sales_flat_order.created_at <= '2092-01-01 00:00:00'
125
+ ORDER BY sales_flat_order.created_at asc
126
+ LIMIT 20,100";
127
+
128
+ $resp = $this->model->buildShippingLinesQuery();
129
+
130
+ $this->assertFalse(is_null($resp));
131
+ $this->assertEquals($expected, $resp);
132
+ }
133
+
134
+ public function testGetTaxifyCustomerTaxibilityFromGroup()
135
+ {
136
+ $this->model->taxClassMap = array('1' => '', '4' => 'NON');
137
+ $resp = $this->model->getTaxifyCustomerTaxabilityFromGroup(1);
138
+
139
+ $this->assertEquals('', $resp);
140
+
141
+ $resp = $this->model->getTaxifyCustomerTaxabilityFromGroup(4);
142
+
143
+ $this->assertEquals('NON', $resp);
144
+ }
145
+
146
+ }
app/code/local/Vonnda/Taxify/tests/fixtures/exportQueryResult.txt ADDED
@@ -0,0 +1,5 @@
 
 
 
 
 
1
+ a:139:{i:0;a:14:{s:12:"increment_id";s:9:"100000049";s:10:"created_at";s:19:"2013-03-14 17:01:34";s:11:"customer_id";N;s:17:"customer_lastname";s:7:"Akizian";s:18:"customer_firstname";s:6:"Mosses";s:14:"customer_email";s:15:"mosses@ebay.com";s:6:"street";s:32:"10441 Jefferson Blvd., Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"abl007";s:4:"name";s:30:"Classic Hardshell Suitcase 29"";s:5:"price";s:8:"750.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:1;a:14:{s:12:"increment_id";s:9:"100000051";s:10:"created_at";s:19:"2013-03-28 12:45:53";s:11:"customer_id";s:2:"30";s:17:"customer_lastname";s:4:"Ngia";s:18:"customer_firstname";s:6:"Robert";s:14:"customer_email";s:16:"robert@gmail.com";s:6:"street";s:13:"1 Legends Way";s:4:"city";s:9:"Arlington";s:6:"region";s:5:"Texas";s:8:"postcode";s:5:"76011";s:3:"sku";s:6:"mtk004";s:4:"name";s:11:"Chelsea Tee";s:5:"price";s:7:"75.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:2;a:14:{s:12:"increment_id";s:9:"100000051";s:10:"created_at";s:19:"2013-03-28 12:45:53";s:11:"customer_id";s:2:"30";s:17:"customer_lastname";s:4:"Ngia";s:18:"customer_firstname";s:6:"Robert";s:14:"customer_email";s:16:"robert@gmail.com";s:6:"street";s:13:"1 Legends Way";s:4:"city";s:9:"Arlington";s:6:"region";s:5:"Texas";s:8:"postcode";s:5:"76011";s:3:"sku";s:6:"mtk004";s:4:"name";s:11:"Chelsea Tee";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:3;a:14:{s:12:"increment_id";s:9:"100000051";s:10:"created_at";s:19:"2013-03-28 12:45:53";s:11:"customer_id";s:2:"30";s:17:"customer_lastname";s:4:"Ngia";s:18:"customer_firstname";s:6:"Robert";s:14:"customer_email";s:16:"robert@gmail.com";s:6:"street";s:13:"1 Legends Way";s:4:"city";s:9:"Arlington";s:6:"region";s:5:"Texas";s:8:"postcode";s:5:"76011";s:3:"sku";s:6:"wbk012";s:4:"name";s:18:"Elizabeth Knit Top";s:5:"price";s:8:"210.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:4;a:14:{s:12:"increment_id";s:9:"100000051";s:10:"created_at";s:19:"2013-03-28 12:45:53";s:11:"customer_id";s:2:"30";s:17:"customer_lastname";s:4:"Ngia";s:18:"customer_firstname";s:6:"Robert";s:14:"customer_email";s:16:"robert@gmail.com";s:6:"street";s:13:"1 Legends Way";s:4:"city";s:9:"Arlington";s:6:"region";s:5:"Texas";s:8:"postcode";s:5:"76011";s:3:"sku";s:6:"wbk012";s:4:"name";s:18:"Elizabeth Knit Top";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:5;a:14:{s:12:"increment_id";s:9:"100000052";s:10:"created_at";s:19:"2013-03-28 12:58:37";s:11:"customer_id";s:2:"29";s:17:"customer_lastname";s:10:"Moorehouse";s:18:"customer_firstname";s:4:"Jill";s:14:"customer_email";s:14:"jill@gmail.com";s:6:"street";s:20:"1849 Geary Boulevard";s:4:"city";s:13:"San Francisco";s:6:"region";s:10:"California";s:8:"postcode";s:5:"94115";s:3:"sku";s:6:"abl004";s:4:"name";s:21:"Houston Travel Wallet";s:5:"price";s:8:"210.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:6;a:14:{s:12:"increment_id";s:9:"100000052";s:10:"created_at";s:19:"2013-03-28 12:58:37";s:11:"customer_id";s:2:"29";s:17:"customer_lastname";s:10:"Moorehouse";s:18:"customer_firstname";s:4:"Jill";s:14:"customer_email";s:14:"jill@gmail.com";s:6:"street";s:20:"1849 Geary Boulevard";s:4:"city";s:13:"San Francisco";s:6:"region";s:10:"California";s:8:"postcode";s:5:"94115";s:3:"sku";s:6:"wbk002";s:4:"name";s:11:"NoLIta Cami";s:5:"price";s:8:"120.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:7;a:14:{s:12:"increment_id";s:9:"100000052";s:10:"created_at";s:19:"2013-03-28 12:58:37";s:11:"customer_id";s:2:"29";s:17:"customer_lastname";s:10:"Moorehouse";s:18:"customer_firstname";s:4:"Jill";s:14:"customer_email";s:14:"jill@gmail.com";s:6:"street";s:20:"1849 Geary Boulevard";s:4:"city";s:13:"San Francisco";s:6:"region";s:10:"California";s:8:"postcode";s:5:"94115";s:3:"sku";s:6:"wbk002";s:4:"name";s:11:"NoLIta Cami";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:8;a:14:{s:12:"increment_id";s:9:"100000053";s:10:"created_at";s:19:"2013-03-28 13:01:06";s:11:"customer_id";s:2:"28";s:17:"customer_lastname";s:6:"Bangor";s:18:"customer_firstname";s:5:"Haven";s:14:"customer_email";s:15:"haven@yahoo.com";s:6:"street";s:17:"Massachusetts Ave";s:4:"city";s:9:"Cambridge";s:6:"region";s:13:"Massachusetts";s:8:"postcode";s:5:"01864";s:3:"sku";s:6:"hdd001";s:4:"name";s:26:"Modern Murray Ceramic Vase";s:5:"price";s:8:"135.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:9;a:14:{s:12:"increment_id";s:9:"100000053";s:10:"created_at";s:19:"2013-03-28 13:01:06";s:11:"customer_id";s:2:"28";s:17:"customer_lastname";s:6:"Bangor";s:18:"customer_firstname";s:5:"Haven";s:14:"customer_email";s:15:"haven@yahoo.com";s:6:"street";s:17:"Massachusetts Ave";s:4:"city";s:9:"Cambridge";s:6:"region";s:13:"Massachusetts";s:8:"postcode";s:5:"01864";s:3:"sku";s:6:"hdd002";s:4:"name";s:26:"Modern Murray Ceramic Vase";s:5:"price";s:8:"135.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:10;a:14:{s:12:"increment_id";s:9:"100000055";s:10:"created_at";s:19:"2013-03-28 13:11:59";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:14:"rack@gmail.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"aws006";s:4:"name";s:14:"Ann Ankle Boot";s:5:"price";s:8:"470.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:11;a:14:{s:12:"increment_id";s:9:"100000055";s:10:"created_at";s:19:"2013-03-28 13:11:59";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:14:"rack@gmail.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"aws006";s:4:"name";s:14:"Ann Ankle Boot";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:12;a:14:{s:12:"increment_id";s:9:"100000055";s:10:"created_at";s:19:"2013-03-28 13:11:59";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:14:"rack@gmail.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"hbm000";s:4:"name";s:20:"A Tale of Two Cities";s:5:"price";s:7:"20.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:13;a:14:{s:12:"increment_id";s:9:"100000055";s:10:"created_at";s:19:"2013-03-28 13:11:59";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:14:"rack@gmail.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"hde001";s:4:"name";s:14:"Madison LX2200";s:5:"price";s:8:"425.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:14;a:14:{s:12:"increment_id";s:9:"100000055";s:10:"created_at";s:19:"2013-03-28 13:11:59";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:14:"rack@gmail.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"hdd000";s:4:"name";s:17:"Herald Glass Vase";s:5:"price";s:8:"110.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:15;a:14:{s:12:"increment_id";s:9:"100000056";s:10:"created_at";s:19:"2013-03-28 13:15:12";s:11:"customer_id";s:2:"25";s:17:"customer_lastname";s:8:"Woodland";s:18:"customer_firstname";s:4:"Mark";s:14:"customer_email";s:14:"mark@yahoo.com";s:6:"street";s:13:"120 W 34th st";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10001";s:3:"sku";s:6:"abl001";s:4:"name";s:26:"Florentine Satchel Handbag";s:5:"price";s:8:"625.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:16;a:14:{s:12:"increment_id";s:9:"100000056";s:10:"created_at";s:19:"2013-03-28 13:15:12";s:11:"customer_id";s:2:"25";s:17:"customer_lastname";s:8:"Woodland";s:18:"customer_firstname";s:4:"Mark";s:14:"customer_email";s:14:"mark@yahoo.com";s:6:"street";s:13:"120 W 34th st";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10001";s:3:"sku";s:6:"hde013";s:4:"name";s:18:"Compact mp3 Player";s:5:"price";s:7:"40.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:17;a:14:{s:12:"increment_id";s:9:"100000057";s:10:"created_at";s:19:"2013-03-28 13:18:41";s:11:"customer_id";s:2:"31";s:17:"customer_lastname";s:6:"Butler";s:18:"customer_firstname";s:3:"Joe";s:14:"customer_email";s:13:"joe@gmail.com";s:6:"street";s:12:"Hazel Street";s:4:"city";s:10:"Morristown";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07960";s:3:"sku";s:8:"mpd00338";s:4:"name";s:24:"Khaki Bowery Chino Pants";s:5:"price";s:8:"140.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:18;a:14:{s:12:"increment_id";s:9:"100000057";s:10:"created_at";s:19:"2013-03-28 13:18:41";s:11:"customer_id";s:2:"31";s:17:"customer_lastname";s:6:"Butler";s:18:"customer_firstname";s:3:"Joe";s:14:"customer_email";s:13:"joe@gmail.com";s:6:"street";s:12:"Hazel Street";s:4:"city";s:10:"Morristown";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07960";s:3:"sku";s:8:"mpd00338";s:4:"name";s:18:"Bowery Chino Pants";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:19;a:14:{s:12:"increment_id";s:9:"100000058";s:10:"created_at";s:19:"2013-03-28 13:20:46";s:11:"customer_id";s:2:"24";s:17:"customer_lastname";s:4:"Fitz";s:18:"customer_firstname";s:4:"Jack";s:14:"customer_email";s:14:"jack@gmail.com";s:6:"street";s:13:"7 N Willow St";s:4:"city";s:9:"Montclair";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07042";s:3:"sku";s:6:"msj005";s:4:"name";s:27:"Slim fit Dobby Oxford Shirt";s:5:"price";s:8:"140.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:20;a:14:{s:12:"increment_id";s:9:"100000058";s:10:"created_at";s:19:"2013-03-28 13:20:46";s:11:"customer_id";s:2:"24";s:17:"customer_lastname";s:4:"Fitz";s:18:"customer_firstname";s:4:"Jack";s:14:"customer_email";s:14:"jack@gmail.com";s:6:"street";s:13:"7 N Willow St";s:4:"city";s:9:"Montclair";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07042";s:3:"sku";s:6:"msj005";s:4:"name";s:27:"Slim fit Dobby Oxford Shirt";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:21;a:14:{s:12:"increment_id";s:9:"100000058";s:10:"created_at";s:19:"2013-03-28 13:20:46";s:11:"customer_id";s:2:"24";s:17:"customer_lastname";s:4:"Fitz";s:18:"customer_firstname";s:4:"Jack";s:14:"customer_email";s:14:"jack@gmail.com";s:6:"street";s:13:"7 N Willow St";s:4:"city";s:9:"Montclair";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07042";s:3:"sku";s:6:"aws011";s:4:"name";s:19:"Hana Flat, Charcoal";s:5:"price";s:8:"210.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:22;a:14:{s:12:"increment_id";s:9:"100000058";s:10:"created_at";s:19:"2013-03-28 13:20:46";s:11:"customer_id";s:2:"24";s:17:"customer_lastname";s:4:"Fitz";s:18:"customer_firstname";s:4:"Jack";s:14:"customer_email";s:14:"jack@gmail.com";s:6:"street";s:13:"7 N Willow St";s:4:"city";s:9:"Montclair";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07042";s:3:"sku";s:6:"aws011";s:4:"name";s:19:"Hana Flat, Charcoal";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:23;a:14:{s:12:"increment_id";s:11:"100000057-1";s:10:"created_at";s:19:"2013-04-03 17:23:17";s:11:"customer_id";s:2:"31";s:17:"customer_lastname";s:6:"Butler";s:18:"customer_firstname";s:3:"Joe";s:14:"customer_email";s:15:"joe@example.com";s:6:"street";s:12:"Hazel Street";s:4:"city";s:10:"Morristown";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07960";s:3:"sku";s:8:"mpd00338";s:4:"name";s:24:"Khaki Bowery Chino Pants";s:5:"price";s:8:"140.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:24;a:14:{s:12:"increment_id";s:11:"100000057-1";s:10:"created_at";s:19:"2013-04-03 17:23:17";s:11:"customer_id";s:2:"31";s:17:"customer_lastname";s:6:"Butler";s:18:"customer_firstname";s:3:"Joe";s:14:"customer_email";s:15:"joe@example.com";s:6:"street";s:12:"Hazel Street";s:4:"city";s:10:"Morristown";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07960";s:3:"sku";s:8:"mpd00338";s:4:"name";s:18:"Bowery Chino Pants";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:25;a:14:{s:12:"increment_id";s:11:"100000051-1";s:10:"created_at";s:19:"2013-04-03 17:25:53";s:11:"customer_id";s:2:"30";s:17:"customer_lastname";s:4:"Ngia";s:18:"customer_firstname";s:6:"Robert";s:14:"customer_email";s:18:"robert@example.com";s:6:"street";s:13:"1 Legends Way";s:4:"city";s:9:"Arlington";s:6:"region";s:5:"Texas";s:8:"postcode";s:5:"76011";s:3:"sku";s:6:"mtk004";s:4:"name";s:11:"Chelsea Tee";s:5:"price";s:7:"75.0000";s:12:"qty_invoiced";s:6:"6.0000";}i:26;a:14:{s:12:"increment_id";s:11:"100000051-1";s:10:"created_at";s:19:"2013-04-03 17:25:53";s:11:"customer_id";s:2:"30";s:17:"customer_lastname";s:4:"Ngia";s:18:"customer_firstname";s:6:"Robert";s:14:"customer_email";s:18:"robert@example.com";s:6:"street";s:13:"1 Legends Way";s:4:"city";s:9:"Arlington";s:6:"region";s:5:"Texas";s:8:"postcode";s:5:"76011";s:3:"sku";s:6:"mtk004";s:4:"name";s:11:"Chelsea Tee";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"6.0000";}i:27;a:14:{s:12:"increment_id";s:11:"100000051-1";s:10:"created_at";s:19:"2013-04-03 17:25:53";s:11:"customer_id";s:2:"30";s:17:"customer_lastname";s:4:"Ngia";s:18:"customer_firstname";s:6:"Robert";s:14:"customer_email";s:18:"robert@example.com";s:6:"street";s:13:"1 Legends Way";s:4:"city";s:9:"Arlington";s:6:"region";s:5:"Texas";s:8:"postcode";s:5:"76011";s:3:"sku";s:6:"wbk012";s:4:"name";s:18:"Elizabeth Knit Top";s:5:"price";s:8:"210.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:28;a:14:{s:12:"increment_id";s:11:"100000051-1";s:10:"created_at";s:19:"2013-04-03 17:25:53";s:11:"customer_id";s:2:"30";s:17:"customer_lastname";s:4:"Ngia";s:18:"customer_firstname";s:6:"Robert";s:14:"customer_email";s:18:"robert@example.com";s:6:"street";s:13:"1 Legends Way";s:4:"city";s:9:"Arlington";s:6:"region";s:5:"Texas";s:8:"postcode";s:5:"76011";s:3:"sku";s:6:"wbk012";s:4:"name";s:18:"Elizabeth Knit Top";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:29;a:14:{s:12:"increment_id";s:11:"100000052-1";s:10:"created_at";s:19:"2013-04-03 17:34:48";s:11:"customer_id";s:2:"29";s:17:"customer_lastname";s:10:"Moorehouse";s:18:"customer_firstname";s:4:"Jill";s:14:"customer_email";s:16:"jill@example.com";s:6:"street";s:20:"1849 Geary Boulevard";s:4:"city";s:13:"San Francisco";s:6:"region";s:10:"California";s:8:"postcode";s:5:"94115";s:3:"sku";s:6:"abl004";s:4:"name";s:21:"Houston Travel Wallet";s:5:"price";s:8:"210.0000";s:12:"qty_invoiced";s:6:"4.0000";}i:30;a:14:{s:12:"increment_id";s:11:"100000052-1";s:10:"created_at";s:19:"2013-04-03 17:34:48";s:11:"customer_id";s:2:"29";s:17:"customer_lastname";s:10:"Moorehouse";s:18:"customer_firstname";s:4:"Jill";s:14:"customer_email";s:16:"jill@example.com";s:6:"street";s:20:"1849 Geary Boulevard";s:4:"city";s:13:"San Francisco";s:6:"region";s:10:"California";s:8:"postcode";s:5:"94115";s:3:"sku";s:6:"wbk002";s:4:"name";s:11:"NoLIta Cami";s:5:"price";s:8:"120.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:31;a:14:{s:12:"increment_id";s:11:"100000052-1";s:10:"created_at";s:19:"2013-04-03 17:34:48";s:11:"customer_id";s:2:"29";s:17:"customer_lastname";s:10:"Moorehouse";s:18:"customer_firstname";s:4:"Jill";s:14:"customer_email";s:16:"jill@example.com";s:6:"street";s:20:"1849 Geary Boulevard";s:4:"city";s:13:"San Francisco";s:6:"region";s:10:"California";s:8:"postcode";s:5:"94115";s:3:"sku";s:6:"wbk002";s:4:"name";s:11:"NoLIta Cami";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:32;a:14:{s:12:"increment_id";s:9:"100000063";s:10:"created_at";s:19:"2013-04-03 17:38:27";s:11:"customer_id";s:2:"28";s:17:"customer_lastname";s:6:"Bangor";s:18:"customer_firstname";s:5:"Haven";s:14:"customer_email";s:17:"haven@example.com";s:6:"street";s:17:"Massachusetts Ave";s:4:"city";s:9:"Cambridge";s:6:"region";s:13:"Massachusetts";s:8:"postcode";s:5:"01864";s:3:"sku";s:6:"hdd001";s:4:"name";s:26:"Modern Murray Ceramic Vase";s:5:"price";s:8:"135.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:33;a:14:{s:12:"increment_id";s:9:"100000063";s:10:"created_at";s:19:"2013-04-03 17:38:27";s:11:"customer_id";s:2:"28";s:17:"customer_lastname";s:6:"Bangor";s:18:"customer_firstname";s:5:"Haven";s:14:"customer_email";s:17:"haven@example.com";s:6:"street";s:17:"Massachusetts Ave";s:4:"city";s:9:"Cambridge";s:6:"region";s:13:"Massachusetts";s:8:"postcode";s:5:"01864";s:3:"sku";s:6:"hdd002";s:4:"name";s:26:"Modern Murray Ceramic Vase";s:5:"price";s:8:"135.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:34;a:14:{s:12:"increment_id";s:9:"100000065";s:10:"created_at";s:19:"2013-04-03 17:42:22";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:16:"rack@example.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"aws006";s:4:"name";s:14:"Ann Ankle Boot";s:5:"price";s:8:"470.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:35;a:14:{s:12:"increment_id";s:9:"100000065";s:10:"created_at";s:19:"2013-04-03 17:42:22";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:16:"rack@example.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"aws006";s:4:"name";s:14:"Ann Ankle Boot";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:36;a:14:{s:12:"increment_id";s:9:"100000065";s:10:"created_at";s:19:"2013-04-03 17:42:22";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:16:"rack@example.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"hbm000";s:4:"name";s:20:"A Tale of Two Cities";s:5:"price";s:7:"20.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:37;a:14:{s:12:"increment_id";s:9:"100000065";s:10:"created_at";s:19:"2013-04-03 17:42:22";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:16:"rack@example.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"hde001";s:4:"name";s:14:"Madison LX2200";s:5:"price";s:8:"425.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:38;a:14:{s:12:"increment_id";s:9:"100000065";s:10:"created_at";s:19:"2013-04-03 17:42:22";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:16:"rack@example.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"hdd000";s:4:"name";s:17:"Herald Glass Vase";s:5:"price";s:8:"110.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:39;a:14:{s:12:"increment_id";s:9:"100000066";s:10:"created_at";s:19:"2013-04-03 17:44:16";s:11:"customer_id";s:2:"25";s:17:"customer_lastname";s:8:"Woodland";s:18:"customer_firstname";s:4:"Mark";s:14:"customer_email";s:16:"mark@example.com";s:6:"street";s:13:"120 W 34th st";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10001";s:3:"sku";s:6:"abl001";s:4:"name";s:26:"Florentine Satchel Handbag";s:5:"price";s:8:"625.0000";s:12:"qty_invoiced";s:7:"20.0000";}i:40;a:14:{s:12:"increment_id";s:9:"100000066";s:10:"created_at";s:19:"2013-04-03 17:44:16";s:11:"customer_id";s:2:"25";s:17:"customer_lastname";s:8:"Woodland";s:18:"customer_firstname";s:4:"Mark";s:14:"customer_email";s:16:"mark@example.com";s:6:"street";s:13:"120 W 34th st";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10001";s:3:"sku";s:6:"hde013";s:4:"name";s:18:"Compact mp3 Player";s:5:"price";s:7:"40.0000";s:12:"qty_invoiced";s:7:"20.0000";}i:41;a:14:{s:12:"increment_id";s:9:"100000067";s:10:"created_at";s:19:"2013-04-03 17:46:06";s:11:"customer_id";s:2:"24";s:17:"customer_lastname";s:4:"Fitz";s:18:"customer_firstname";s:4:"Jack";s:14:"customer_email";s:16:"jack@example.com";s:6:"street";s:13:"7 N Willow St";s:4:"city";s:9:"Montclair";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07042";s:3:"sku";s:6:"msj005";s:4:"name";s:27:"Slim fit Dobby Oxford Shirt";s:5:"price";s:8:"140.0000";s:12:"qty_invoiced";s:6:"2.0000";}i:42;a:14:{s:12:"increment_id";s:9:"100000067";s:10:"created_at";s:19:"2013-04-03 17:46:06";s:11:"customer_id";s:2:"24";s:17:"customer_lastname";s:4:"Fitz";s:18:"customer_firstname";s:4:"Jack";s:14:"customer_email";s:16:"jack@example.com";s:6:"street";s:13:"7 N Willow St";s:4:"city";s:9:"Montclair";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07042";s:3:"sku";s:6:"msj005";s:4:"name";s:27:"Slim fit Dobby Oxford Shirt";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"2.0000";}i:43;a:14:{s:12:"increment_id";s:9:"100000067";s:10:"created_at";s:19:"2013-04-03 17:46:06";s:11:"customer_id";s:2:"24";s:17:"customer_lastname";s:4:"Fitz";s:18:"customer_firstname";s:4:"Jack";s:14:"customer_email";s:16:"jack@example.com";s:6:"street";s:13:"7 N Willow St";s:4:"city";s:9:"Montclair";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07042";s:3:"sku";s:6:"aws011";s:4:"name";s:19:"Hana Flat, Charcoal";s:5:"price";s:8:"210.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:44;a:14:{s:12:"increment_id";s:9:"100000067";s:10:"created_at";s:19:"2013-04-03 17:46:06";s:11:"customer_id";s:2:"24";s:17:"customer_lastname";s:4:"Fitz";s:18:"customer_firstname";s:4:"Jack";s:14:"customer_email";s:16:"jack@example.com";s:6:"street";s:13:"7 N Willow St";s:4:"city";s:9:"Montclair";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07042";s:3:"sku";s:6:"aws011";s:4:"name";s:19:"Hana Flat, Charcoal";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:45;a:14:{s:12:"increment_id";s:9:"100000081";s:10:"created_at";s:19:"2013-04-22 09:43:08";s:11:"customer_id";s:2:"59";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:5:"Chris";s:14:"customer_email";s:17:"chris@example.com";s:6:"street";s:11:"Disney land";s:4:"city";s:11:"Los Angeles";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90001";s:3:"sku";s:6:"hdb006";s:4:"name";s:19:"Shay Printed Pillow";s:5:"price";s:8:"210.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:46;a:14:{s:12:"increment_id";s:9:"100000081";s:10:"created_at";s:19:"2013-04-22 09:43:08";s:11:"customer_id";s:2:"59";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:5:"Chris";s:14:"customer_email";s:17:"chris@example.com";s:6:"street";s:11:"Disney land";s:4:"city";s:11:"Los Angeles";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90001";s:3:"sku";s:6:"hdb009";s:4:"name";s:14:"Gramercy Throw";s:5:"price";s:8:"275.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:47;a:14:{s:12:"increment_id";s:9:"100000082";s:10:"created_at";s:19:"2013-04-22 10:13:27";s:11:"customer_id";s:2:"64";s:17:"customer_lastname";s:4:"Watz";s:18:"customer_firstname";s:6:"Mickey";s:14:"customer_email";s:18:"mickey@example.com";s:6:"street";s:11:"Disney Land";s:4:"city";s:7:"Orlando";s:6:"region";s:7:"Florida";s:8:"postcode";s:5:"32801";s:3:"sku";s:6:"wbk002";s:4:"name";s:11:"NoLIta Cami";s:5:"price";s:8:"120.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:48;a:14:{s:12:"increment_id";s:9:"100000082";s:10:"created_at";s:19:"2013-04-22 10:13:27";s:11:"customer_id";s:2:"64";s:17:"customer_lastname";s:4:"Watz";s:18:"customer_firstname";s:6:"Mickey";s:14:"customer_email";s:18:"mickey@example.com";s:6:"street";s:11:"Disney Land";s:4:"city";s:7:"Orlando";s:6:"region";s:7:"Florida";s:8:"postcode";s:5:"32801";s:3:"sku";s:6:"wbk002";s:4:"name";s:11:"NoLIta Cami";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:49;a:14:{s:12:"increment_id";s:9:"100000082";s:10:"created_at";s:19:"2013-04-22 10:13:27";s:11:"customer_id";s:2:"64";s:17:"customer_lastname";s:4:"Watz";s:18:"customer_firstname";s:6:"Mickey";s:14:"customer_email";s:18:"mickey@example.com";s:6:"street";s:11:"Disney Land";s:4:"city";s:7:"Orlando";s:6:"region";s:7:"Florida";s:8:"postcode";s:5:"32801";s:3:"sku";s:6:"gif002";s:4:"name";s:24:"A $300 Virtual Gift Card";s:5:"price";s:8:"300.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:50;a:14:{s:12:"increment_id";s:9:"100000082";s:10:"created_at";s:19:"2013-04-22 10:13:27";s:11:"customer_id";s:2:"64";s:17:"customer_lastname";s:4:"Watz";s:18:"customer_firstname";s:6:"Mickey";s:14:"customer_email";s:18:"mickey@example.com";s:6:"street";s:11:"Disney Land";s:4:"city";s:7:"Orlando";s:6:"region";s:7:"Florida";s:8:"postcode";s:5:"32801";s:3:"sku";s:6:"ace000";s:4:"name";s:18:"Aviator Sunglasses";s:5:"price";s:8:"295.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:51;a:14:{s:12:"increment_id";s:9:"100000083";s:10:"created_at";s:19:"2013-04-22 10:48:29";s:11:"customer_id";s:2:"65";s:17:"customer_lastname";s:3:"Ray";s:18:"customer_firstname";s:3:"Tay";s:14:"customer_email";s:15:"tay@example.com";s:6:"street";s:12:"Canal Street";s:4:"city";s:8:"Michigan";s:6:"region";s:8:"Michigan";s:8:"postcode";s:5:"49036";s:3:"sku";s:6:"abl003";s:4:"name";s:28:"Broad St. Flapover Briefcase";s:5:"price";s:8:"400.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:52;a:14:{s:12:"increment_id";s:9:"100000083";s:10:"created_at";s:19:"2013-04-22 10:48:29";s:11:"customer_id";s:2:"65";s:17:"customer_lastname";s:3:"Ray";s:18:"customer_firstname";s:3:"Tay";s:14:"customer_email";s:15:"tay@example.com";s:6:"street";s:12:"Canal Street";s:4:"city";s:8:"Michigan";s:6:"region";s:8:"Michigan";s:8:"postcode";s:5:"49036";s:3:"sku";s:6:"abl004";s:4:"name";s:21:"Houston Travel Wallet";s:5:"price";s:8:"150.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:53;a:14:{s:12:"increment_id";s:9:"100000087";s:10:"created_at";s:19:"2013-04-23 19:27:51";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:16:"rack@example.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"aws006";s:4:"name";s:14:"Ann Ankle Boot";s:5:"price";s:8:"470.0000";s:12:"qty_invoiced";s:6:"4.0000";}i:54;a:14:{s:12:"increment_id";s:9:"100000087";s:10:"created_at";s:19:"2013-04-23 19:27:51";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:16:"rack@example.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"aws006";s:4:"name";s:14:"Ann Ankle Boot";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"4.0000";}i:55;a:14:{s:12:"increment_id";s:9:"100000087";s:10:"created_at";s:19:"2013-04-23 19:27:51";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:16:"rack@example.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"hbm000";s:4:"name";s:20:"A Tale of Two Cities";s:5:"price";s:7:"20.0000";s:12:"qty_invoiced";s:6:"5.0000";}i:56;a:14:{s:12:"increment_id";s:9:"100000087";s:10:"created_at";s:19:"2013-04-23 19:27:51";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:16:"rack@example.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"hde001";s:4:"name";s:14:"Madison LX2200";s:5:"price";s:8:"425.0000";s:12:"qty_invoiced";s:6:"6.0000";}i:57;a:14:{s:12:"increment_id";s:9:"100000087";s:10:"created_at";s:19:"2013-04-23 19:27:51";s:11:"customer_id";s:2:"26";s:17:"customer_lastname";s:3:"Fox";s:18:"customer_firstname";s:4:"Rack";s:14:"customer_email";s:16:"rack@example.com";s:6:"street";s:7:"15th St";s:4:"city";s:7:"Hoboken";s:6:"region";s:10:"New Jersey";s:8:"postcode";s:5:"07030";s:3:"sku";s:6:"hdd000";s:4:"name";s:17:"Herald Glass Vase";s:5:"price";s:8:"110.0000";s:12:"qty_invoiced";s:6:"5.0000";}i:58;a:14:{s:12:"increment_id";s:9:"100000088";s:10:"created_at";s:19:"2013-04-23 19:34:44";s:11:"customer_id";s:2:"25";s:17:"customer_lastname";s:8:"Woodland";s:18:"customer_firstname";s:4:"Mark";s:14:"customer_email";s:16:"mark@example.com";s:6:"street";s:13:"120 W 34th st";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10001";s:3:"sku";s:6:"abl001";s:4:"name";s:26:"Florentine Satchel Handbag";s:5:"price";s:8:"625.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:59;a:14:{s:12:"increment_id";s:9:"100000088";s:10:"created_at";s:19:"2013-04-23 19:34:44";s:11:"customer_id";s:2:"25";s:17:"customer_lastname";s:8:"Woodland";s:18:"customer_firstname";s:4:"Mark";s:14:"customer_email";s:16:"mark@example.com";s:6:"street";s:13:"120 W 34th st";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10001";s:3:"sku";s:6:"hde013";s:4:"name";s:18:"Compact mp3 Player";s:5:"price";s:7:"40.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:60;a:14:{s:12:"increment_id";s:9:"100000089";s:10:"created_at";s:19:"2013-04-23 20:04:25";s:11:"customer_id";s:2:"73";s:17:"customer_lastname";s:5:"Hertz";s:18:"customer_firstname";s:6:"Donald";s:14:"customer_email";s:18:"donald@example.com";s:6:"street";s:16:"277 Orchard Road";s:4:"city";s:9:"Singapore";s:6:"region";N;s:8:"postcode";s:6:"238858";s:3:"sku";s:6:"wbk002";s:4:"name";s:11:"NoLIta Cami";s:5:"price";s:8:"120.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:61;a:14:{s:12:"increment_id";s:9:"100000090";s:10:"created_at";s:19:"2013-04-23 20:16:31";s:11:"customer_id";s:2:"73";s:17:"customer_lastname";s:5:"Hertz";s:18:"customer_firstname";s:6:"Donald";s:14:"customer_email";s:18:"donald@example.com";s:6:"street";s:16:"277 Orchard Road";s:4:"city";s:9:"Singapore";s:6:"region";N;s:8:"postcode";s:6:"238858";s:3:"sku";s:8:"msj000xs";s:4:"name";s:31:"French Cuff Cotton Twill Oxford";s:5:"price";s:8:"190.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:62;a:14:{s:12:"increment_id";s:9:"100000090";s:10:"created_at";s:19:"2013-04-23 20:16:31";s:11:"customer_id";s:2:"73";s:17:"customer_lastname";s:5:"Hertz";s:18:"customer_firstname";s:6:"Donald";s:14:"customer_email";s:18:"donald@example.com";s:6:"street";s:16:"277 Orchard Road";s:4:"city";s:9:"Singapore";s:6:"region";N;s:8:"postcode";s:6:"238858";s:3:"sku";s:8:"msj000xs";s:4:"name";s:31:"French Cuff Cotton Twill Oxford";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:63;a:14:{s:12:"increment_id";s:9:"100000090";s:10:"created_at";s:19:"2013-04-23 20:16:31";s:11:"customer_id";s:2:"73";s:17:"customer_lastname";s:5:"Hertz";s:18:"customer_firstname";s:6:"Donald";s:14:"customer_email";s:18:"donald@example.com";s:6:"street";s:16:"277 Orchard Road";s:4:"city";s:9:"Singapore";s:6:"region";N;s:8:"postcode";s:6:"238858";s:3:"sku";s:6:"hde006";s:4:"name";s:16:"Large Camera Bag";s:5:"price";s:8:"120.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:64;a:14:{s:12:"increment_id";s:9:"100000090";s:10:"created_at";s:19:"2013-04-23 20:16:31";s:11:"customer_id";s:2:"73";s:17:"customer_lastname";s:5:"Hertz";s:18:"customer_firstname";s:6:"Donald";s:14:"customer_email";s:18:"donald@example.com";s:6:"street";s:16:"277 Orchard Road";s:4:"city";s:9:"Singapore";s:6:"region";N;s:8:"postcode";s:6:"238858";s:3:"sku";s:6:"hde005";s:4:"name";s:15:"8GB Memory Card";s:5:"price";s:7:"20.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:65;a:14:{s:12:"increment_id";s:9:"100000091";s:10:"created_at";s:19:"2013-04-23 20:24:59";s:11:"customer_id";s:2:"80";s:17:"customer_lastname";s:8:"Einstein";s:18:"customer_firstname";s:6:"Albert";s:14:"customer_email";s:18:"albert@example.com";s:6:"street";s:13:"Cold Water St";s:4:"city";s:9:"Coldwater";s:6:"region";s:8:"Michigan";s:8:"postcode";s:5:"49036";s:3:"sku";s:6:"mpd003";s:4:"name";s:18:"Bowery Chino Pants";s:5:"price";s:8:"140.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:66;a:14:{s:12:"increment_id";s:9:"100000091";s:10:"created_at";s:19:"2013-04-23 20:24:59";s:11:"customer_id";s:2:"80";s:17:"customer_lastname";s:8:"Einstein";s:18:"customer_firstname";s:6:"Albert";s:14:"customer_email";s:18:"albert@example.com";s:6:"street";s:13:"Cold Water St";s:4:"city";s:9:"Coldwater";s:6:"region";s:8:"Michigan";s:8:"postcode";s:5:"49036";s:3:"sku";s:6:"mpd003";s:4:"name";s:18:"Bowery Chino Pants";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:67;a:14:{s:12:"increment_id";s:9:"100000092";s:10:"created_at";s:19:"2013-04-23 20:27:45";s:11:"customer_id";s:2:"80";s:17:"customer_lastname";s:8:"Einstein";s:18:"customer_firstname";s:6:"Albert";s:14:"customer_email";s:18:"albert@example.com";s:6:"street";s:13:"Cold Water St";s:4:"city";s:9:"Coldwater";s:6:"region";s:8:"Michigan";s:8:"postcode";s:5:"49036";s:3:"sku";s:6:"wsd014";s:4:"name";s:27:"Lafayette Convertible Dress";s:5:"price";s:8:"340.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:68;a:14:{s:12:"increment_id";s:9:"100000092";s:10:"created_at";s:19:"2013-04-23 20:27:45";s:11:"customer_id";s:2:"80";s:17:"customer_lastname";s:8:"Einstein";s:18:"customer_firstname";s:6:"Albert";s:14:"customer_email";s:18:"albert@example.com";s:6:"street";s:13:"Cold Water St";s:4:"city";s:9:"Coldwater";s:6:"region";s:8:"Michigan";s:8:"postcode";s:5:"49036";s:3:"sku";s:6:"wsd014";s:4:"name";s:17:"Convertible Dress";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:69;a:14:{s:12:"increment_id";s:9:"100000093";s:10:"created_at";s:19:"2013-04-23 20:31:09";s:11:"customer_id";s:2:"74";s:17:"customer_lastname";s:4:"Wood";s:18:"customer_firstname";s:5:"Linda";s:14:"customer_email";s:17:"linda@example.com";s:6:"street";s:11:"Penn Street";s:4:"city";s:9:"Pittsburg";s:6:"region";s:12:"Pennsylvania";s:8:"postcode";s:5:"15201";s:3:"sku";s:6:"mpd004";s:4:"name";s:18:"Bowery Chino Pants";s:5:"price";s:8:"140.0000";s:12:"qty_invoiced";s:7:"10.0000";}i:70;a:14:{s:12:"increment_id";s:9:"100000093";s:10:"created_at";s:19:"2013-04-23 20:31:09";s:11:"customer_id";s:2:"74";s:17:"customer_lastname";s:4:"Wood";s:18:"customer_firstname";s:5:"Linda";s:14:"customer_email";s:17:"linda@example.com";s:6:"street";s:11:"Penn Street";s:4:"city";s:9:"Pittsburg";s:6:"region";s:12:"Pennsylvania";s:8:"postcode";s:5:"15201";s:3:"sku";s:6:"mpd004";s:4:"name";s:18:"Bowery Chino Pants";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:7:"10.0000";}i:71;a:14:{s:12:"increment_id";s:9:"100000094";s:10:"created_at";s:19:"2013-04-23 20:41:34";s:11:"customer_id";s:2:"74";s:17:"customer_lastname";s:4:"Wood";s:18:"customer_firstname";s:5:"Linda";s:14:"customer_email";s:17:"linda@example.com";s:6:"street";s:11:"Penn Street";s:4:"city";s:9:"Pittsburg";s:6:"region";s:12:"Pennsylvania";s:8:"postcode";s:5:"15201";s:3:"sku";s:6:"hbm000";s:4:"name";s:20:"A Tale of Two Cities";s:5:"price";s:7:"20.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:72;a:14:{s:12:"increment_id";s:9:"100000094";s:10:"created_at";s:19:"2013-04-23 20:41:34";s:11:"customer_id";s:2:"74";s:17:"customer_lastname";s:4:"Wood";s:18:"customer_firstname";s:5:"Linda";s:14:"customer_email";s:17:"linda@example.com";s:6:"street";s:11:"Penn Street";s:4:"city";s:9:"Pittsburg";s:6:"region";s:12:"Pennsylvania";s:8:"postcode";s:5:"15201";s:3:"sku";s:8:"wpd00027";s:4:"name";s:19:"TriBeCa Skinny Jean";s:5:"price";s:8:"185.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:73;a:14:{s:12:"increment_id";s:9:"100000094";s:10:"created_at";s:19:"2013-04-23 20:41:34";s:11:"customer_id";s:2:"74";s:17:"customer_lastname";s:4:"Wood";s:18:"customer_firstname";s:5:"Linda";s:14:"customer_email";s:17:"linda@example.com";s:6:"street";s:11:"Penn Street";s:4:"city";s:9:"Pittsburg";s:6:"region";s:12:"Pennsylvania";s:8:"postcode";s:5:"15201";s:3:"sku";s:8:"wpd00027";s:4:"name";s:19:"TriBeCa Skinny Jean";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:74;a:14:{s:12:"increment_id";s:9:"100000094";s:10:"created_at";s:19:"2013-04-23 20:41:34";s:11:"customer_id";s:2:"74";s:17:"customer_lastname";s:4:"Wood";s:18:"customer_firstname";s:5:"Linda";s:14:"customer_email";s:17:"linda@example.com";s:6:"street";s:11:"Penn Street";s:4:"city";s:9:"Pittsburg";s:6:"region";s:12:"Pennsylvania";s:8:"postcode";s:5:"15201";s:3:"sku";s:6:"msj000";s:4:"name";s:31:"French Cuff Cotton Twill Oxford";s:5:"price";s:8:"190.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:75;a:14:{s:12:"increment_id";s:9:"100000094";s:10:"created_at";s:19:"2013-04-23 20:41:34";s:11:"customer_id";s:2:"74";s:17:"customer_lastname";s:4:"Wood";s:18:"customer_firstname";s:5:"Linda";s:14:"customer_email";s:17:"linda@example.com";s:6:"street";s:11:"Penn Street";s:4:"city";s:9:"Pittsburg";s:6:"region";s:12:"Pennsylvania";s:8:"postcode";s:5:"15201";s:3:"sku";s:6:"msj000";s:4:"name";s:31:"French Cuff Cotton Twill Oxford";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:76;a:14:{s:12:"increment_id";s:9:"100000094";s:10:"created_at";s:19:"2013-04-23 20:41:34";s:11:"customer_id";s:2:"74";s:17:"customer_lastname";s:4:"Wood";s:18:"customer_firstname";s:5:"Linda";s:14:"customer_email";s:17:"linda@example.com";s:6:"street";s:11:"Penn Street";s:4:"city";s:9:"Pittsburg";s:6:"region";s:12:"Pennsylvania";s:8:"postcode";s:5:"15201";s:3:"sku";s:6:"abl000";s:4:"name";s:22:"Isla Crossbody Handbag";s:5:"price";s:8:"290.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:77;a:14:{s:12:"increment_id";s:9:"100000094";s:10:"created_at";s:19:"2013-04-23 20:41:34";s:11:"customer_id";s:2:"74";s:17:"customer_lastname";s:4:"Wood";s:18:"customer_firstname";s:5:"Linda";s:14:"customer_email";s:17:"linda@example.com";s:6:"street";s:11:"Penn Street";s:4:"city";s:9:"Pittsburg";s:6:"region";s:12:"Pennsylvania";s:8:"postcode";s:5:"15201";s:3:"sku";s:6:"msj009";s:4:"name";s:19:"Sullivan Sport Coat";s:5:"price";s:8:"510.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:78;a:14:{s:12:"increment_id";s:9:"100000094";s:10:"created_at";s:19:"2013-04-23 20:41:34";s:11:"customer_id";s:2:"74";s:17:"customer_lastname";s:4:"Wood";s:18:"customer_firstname";s:5:"Linda";s:14:"customer_email";s:17:"linda@example.com";s:6:"street";s:11:"Penn Street";s:4:"city";s:9:"Pittsburg";s:6:"region";s:12:"Pennsylvania";s:8:"postcode";s:5:"15201";s:3:"sku";s:6:"msj009";s:4:"name";s:19:"Sullivan Sport Coat";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:79;a:14:{s:12:"increment_id";s:9:"100000094";s:10:"created_at";s:19:"2013-04-23 20:41:34";s:11:"customer_id";s:2:"74";s:17:"customer_lastname";s:4:"Wood";s:18:"customer_firstname";s:5:"Linda";s:14:"customer_email";s:17:"linda@example.com";s:6:"street";s:11:"Penn Street";s:4:"city";s:9:"Pittsburg";s:6:"region";s:12:"Pennsylvania";s:8:"postcode";s:5:"15201";s:3:"sku";s:6:"ace000";s:4:"name";s:18:"Aviator Sunglasses";s:5:"price";s:8:"295.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:80;a:14:{s:12:"increment_id";s:9:"100000095";s:10:"created_at";s:19:"2013-04-23 21:12:51";s:11:"customer_id";s:2:"82";s:17:"customer_lastname";s:6:"Cooper";s:18:"customer_firstname";s:4:"Gogi";s:14:"customer_email";s:16:"gogi@example.com";s:6:"street";s:7:"30th St";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10450";s:3:"sku";s:6:"aws006";s:4:"name";s:14:"Ann Ankle Boot";s:5:"price";s:8:"470.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:81;a:14:{s:12:"increment_id";s:9:"100000095";s:10:"created_at";s:19:"2013-04-23 21:12:51";s:11:"customer_id";s:2:"82";s:17:"customer_lastname";s:6:"Cooper";s:18:"customer_firstname";s:4:"Gogi";s:14:"customer_email";s:16:"gogi@example.com";s:6:"street";s:7:"30th St";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10450";s:3:"sku";s:6:"aws006";s:4:"name";s:14:"Ann Ankle Boot";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:82;a:14:{s:12:"increment_id";s:9:"100000095";s:10:"created_at";s:19:"2013-04-23 21:12:51";s:11:"customer_id";s:2:"82";s:17:"customer_lastname";s:6:"Cooper";s:18:"customer_firstname";s:4:"Gogi";s:14:"customer_email";s:16:"gogi@example.com";s:6:"street";s:7:"30th St";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10450";s:3:"sku";s:6:"hdd000";s:4:"name";s:17:"Herald Glass Vase";s:5:"price";s:8:"110.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:83;a:14:{s:12:"increment_id";s:9:"400000001";s:10:"created_at";s:19:"2013-04-24 07:21:49";s:11:"customer_id";s:2:"84";s:17:"customer_lastname";s:5:"Glory";s:18:"customer_firstname";s:5:"Pearl";s:14:"customer_email";s:17:"pearl@example.com";s:6:"street";s:17:"Great Church Road";s:4:"city";s:9:"Baltimore";s:6:"region";s:8:"Maryland";s:8:"postcode";s:5:"21201";s:3:"sku";s:8:"Pmo000xs";s:4:"name";s:15:"Thomas Overcoat";s:5:"price";s:8:"590.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:84;a:14:{s:12:"increment_id";s:9:"400000001";s:10:"created_at";s:19:"2013-04-24 07:21:49";s:11:"customer_id";s:2:"84";s:17:"customer_lastname";s:5:"Glory";s:18:"customer_firstname";s:5:"Pearl";s:14:"customer_email";s:17:"pearl@example.com";s:6:"street";s:17:"Great Church Road";s:4:"city";s:9:"Baltimore";s:6:"region";s:8:"Maryland";s:8:"postcode";s:5:"21201";s:3:"sku";s:8:"Pmo000xs";s:4:"name";s:15:"Thomas Overcoat";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:85;a:14:{s:12:"increment_id";s:9:"400000002";s:10:"created_at";s:19:"2013-04-24 07:32:54";s:11:"customer_id";s:2:"84";s:17:"customer_lastname";s:5:"Glory";s:18:"customer_firstname";s:5:"Pearl";s:14:"customer_email";s:17:"pearl@example.com";s:6:"street";s:17:"Great Church Road";s:4:"city";s:9:"Baltimore";s:6:"region";s:8:"Maryland";s:8:"postcode";s:5:"21201";s:3:"sku";s:8:"Pmp00131";s:4:"name";s:11:"Draper Pant";s:5:"price";s:8:"295.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:86;a:14:{s:12:"increment_id";s:9:"400000002";s:10:"created_at";s:19:"2013-04-24 07:32:54";s:11:"customer_id";s:2:"84";s:17:"customer_lastname";s:5:"Glory";s:18:"customer_firstname";s:5:"Pearl";s:14:"customer_email";s:17:"pearl@example.com";s:6:"street";s:17:"Great Church Road";s:4:"city";s:9:"Baltimore";s:6:"region";s:8:"Maryland";s:8:"postcode";s:5:"21201";s:3:"sku";s:8:"Pmp00131";s:4:"name";s:11:"Draper Pant";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:87;a:14:{s:12:"increment_id";s:9:"100000111";s:10:"created_at";s:19:"2013-04-24 15:10:44";s:11:"customer_id";s:2:"92";s:17:"customer_lastname";s:4:"Chee";s:18:"customer_firstname";s:3:"Kip";s:14:"customer_email";s:15:"kip@example.com";s:6:"street";s:11:"Coffee Road";s:4:"city";s:9:"Coffeepot";s:6:"region";s:7:"Florida";s:8:"postcode";s:5:"33432";s:3:"sku";s:6:"hbm006";s:4:"name";s:21:"If You Were by Keshco";s:5:"price";s:6:"2.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:88;a:14:{s:12:"increment_id";s:9:"100000111";s:10:"created_at";s:19:"2013-04-24 15:10:44";s:11:"customer_id";s:2:"92";s:17:"customer_lastname";s:4:"Chee";s:18:"customer_firstname";s:3:"Kip";s:14:"customer_email";s:15:"kip@example.com";s:6:"street";s:11:"Coffee Road";s:4:"city";s:9:"Coffeepot";s:6:"region";s:7:"Florida";s:8:"postcode";s:5:"33432";s:3:"sku";s:6:"mpd011";s:4:"name";s:27:"The Essential Boot Cut Jean";s:5:"price";s:8:"140.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:89;a:14:{s:12:"increment_id";s:9:"100000111";s:10:"created_at";s:19:"2013-04-24 15:10:44";s:11:"customer_id";s:2:"92";s:17:"customer_lastname";s:4:"Chee";s:18:"customer_firstname";s:3:"Kip";s:14:"customer_email";s:15:"kip@example.com";s:6:"street";s:11:"Coffee Road";s:4:"city";s:9:"Coffeepot";s:6:"region";s:7:"Florida";s:8:"postcode";s:5:"33432";s:3:"sku";s:6:"mpd011";s:4:"name";s:27:"The Essential Boot Cut Jean";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:90;a:14:{s:12:"increment_id";s:9:"100000111";s:10:"created_at";s:19:"2013-04-24 15:10:44";s:11:"customer_id";s:2:"92";s:17:"customer_lastname";s:4:"Chee";s:18:"customer_firstname";s:3:"Kip";s:14:"customer_email";s:15:"kip@example.com";s:6:"street";s:11:"Coffee Road";s:4:"city";s:9:"Coffeepot";s:6:"region";s:7:"Florida";s:8:"postcode";s:5:"33432";s:3:"sku";s:6:"wbk012";s:4:"name";s:18:"Elizabeth Knit Top";s:5:"price";s:8:"210.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:91;a:14:{s:12:"increment_id";s:9:"100000111";s:10:"created_at";s:19:"2013-04-24 15:10:44";s:11:"customer_id";s:2:"92";s:17:"customer_lastname";s:4:"Chee";s:18:"customer_firstname";s:3:"Kip";s:14:"customer_email";s:15:"kip@example.com";s:6:"street";s:11:"Coffee Road";s:4:"city";s:9:"Coffeepot";s:6:"region";s:7:"Florida";s:8:"postcode";s:5:"33432";s:3:"sku";s:6:"wbk012";s:4:"name";s:18:"Elizabeth Knit Top";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:92;a:14:{s:12:"increment_id";s:9:"100000135";s:10:"created_at";s:19:"2013-04-25 10:41:25";s:11:"customer_id";s:2:"95";s:17:"customer_lastname";s:4:"Berg";s:18:"customer_firstname";s:4:"Dong";s:14:"customer_email";s:16:"dong@example.com";s:6:"street";s:7:"Orchard";s:4:"city";s:12:"Wachapreague";s:6:"region";s:7:"Indiana";s:8:"postcode";s:5:"46879";s:3:"sku";s:6:"msj012";s:4:"name";s:12:"Linen Blazer";s:5:"price";s:8:"455.0000";s:12:"qty_invoiced";s:7:"15.0000";}i:93;a:14:{s:12:"increment_id";s:9:"100000135";s:10:"created_at";s:19:"2013-04-25 10:41:25";s:11:"customer_id";s:2:"95";s:17:"customer_lastname";s:4:"Berg";s:18:"customer_firstname";s:4:"Dong";s:14:"customer_email";s:16:"dong@example.com";s:6:"street";s:7:"Orchard";s:4:"city";s:12:"Wachapreague";s:6:"region";s:7:"Indiana";s:8:"postcode";s:5:"46879";s:3:"sku";s:6:"msj012";s:4:"name";s:12:"Linen Blazer";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:7:"15.0000";}i:94;a:14:{s:12:"increment_id";s:9:"100000135";s:10:"created_at";s:19:"2013-04-25 10:41:25";s:11:"customer_id";s:2:"95";s:17:"customer_lastname";s:4:"Berg";s:18:"customer_firstname";s:4:"Dong";s:14:"customer_email";s:16:"dong@example.com";s:6:"street";s:7:"Orchard";s:4:"city";s:12:"Wachapreague";s:6:"region";s:7:"Indiana";s:8:"postcode";s:5:"46879";s:3:"sku";s:6:"msj009";s:4:"name";s:19:"Sullivan Sport Coat";s:5:"price";s:8:"510.0000";s:12:"qty_invoiced";s:7:"15.0000";}i:95;a:14:{s:12:"increment_id";s:9:"100000135";s:10:"created_at";s:19:"2013-04-25 10:41:25";s:11:"customer_id";s:2:"95";s:17:"customer_lastname";s:4:"Berg";s:18:"customer_firstname";s:4:"Dong";s:14:"customer_email";s:16:"dong@example.com";s:6:"street";s:7:"Orchard";s:4:"city";s:12:"Wachapreague";s:6:"region";s:7:"Indiana";s:8:"postcode";s:5:"46879";s:3:"sku";s:6:"msj009";s:4:"name";s:19:"Sullivan Sport Coat";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:7:"15.0000";}i:96;a:14:{s:12:"increment_id";s:9:"100000135";s:10:"created_at";s:19:"2013-04-25 10:41:25";s:11:"customer_id";s:2:"95";s:17:"customer_lastname";s:4:"Berg";s:18:"customer_firstname";s:4:"Dong";s:14:"customer_email";s:16:"dong@example.com";s:6:"street";s:7:"Orchard";s:4:"city";s:12:"Wachapreague";s:6:"region";s:7:"Indiana";s:8:"postcode";s:5:"46879";s:3:"sku";s:6:"wbk009";s:4:"name";s:17:"Ludlow Oxford Top";s:5:"price";s:8:"185.0000";s:12:"qty_invoiced";s:7:"15.0000";}i:97;a:14:{s:12:"increment_id";s:9:"100000135";s:10:"created_at";s:19:"2013-04-25 10:41:25";s:11:"customer_id";s:2:"95";s:17:"customer_lastname";s:4:"Berg";s:18:"customer_firstname";s:4:"Dong";s:14:"customer_email";s:16:"dong@example.com";s:6:"street";s:7:"Orchard";s:4:"city";s:12:"Wachapreague";s:6:"region";s:7:"Indiana";s:8:"postcode";s:5:"46879";s:3:"sku";s:6:"wbk009";s:4:"name";s:17:"Ludlow Oxford Top";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:7:"15.0000";}i:98;a:14:{s:12:"increment_id";s:9:"100000135";s:10:"created_at";s:19:"2013-04-25 10:41:25";s:11:"customer_id";s:2:"95";s:17:"customer_lastname";s:4:"Berg";s:18:"customer_firstname";s:4:"Dong";s:14:"customer_email";s:16:"dong@example.com";s:6:"street";s:7:"Orchard";s:4:"city";s:12:"Wachapreague";s:6:"region";s:7:"Indiana";s:8:"postcode";s:5:"46879";s:3:"sku";s:6:"hdd000";s:4:"name";s:17:"Herald Glass Vase";s:5:"price";s:8:"110.0000";s:12:"qty_invoiced";s:6:"7.0000";}i:99;a:14:{s:12:"increment_id";s:9:"100000199";s:10:"created_at";s:19:"2013-05-24 18:42:11";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:15:"wbk002c-Black-S";s:4:"name";s:11:"NoLIta Cami";s:5:"price";s:8:"150.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:100;a:14:{s:12:"increment_id";s:9:"100000199";s:10:"created_at";s:19:"2013-05-24 18:42:11";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:15:"wbk002c-Black-S";s:4:"name";s:25:"Black Nolita Cami-Black-S";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:101;a:14:{s:12:"increment_id";s:9:"100000199";s:10:"created_at";s:19:"2013-05-24 18:42:11";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"gif002";s:4:"name";s:24:"A $300 Virtual Gift Card";s:5:"price";s:8:"300.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:102;a:14:{s:12:"increment_id";s:9:"100000200";s:10:"created_at";s:19:"2013-05-24 18:58:37";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"hde003";s:4:"name";s:14:"Madison RX3400";s:5:"price";s:8:"715.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:103;a:14:{s:12:"increment_id";s:9:"100000200";s:10:"created_at";s:19:"2013-05-24 18:58:37";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"hde006";s:4:"name";s:16:"Large Camera Bag";s:5:"price";s:8:"120.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:104;a:14:{s:12:"increment_id";s:9:"100000201";s:10:"created_at";s:19:"2013-05-25 14:37:05";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:8:"wbk003xs";s:4:"name";s:9:"Tori Tank";s:5:"price";s:7:"60.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:105;a:14:{s:12:"increment_id";s:9:"100000201";s:10:"created_at";s:19:"2013-05-25 14:37:05";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:8:"wbk003xs";s:4:"name";s:9:"Tori Tank";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:106;a:14:{s:12:"increment_id";s:9:"100000201";s:10:"created_at";s:19:"2013-05-25 14:37:05";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"wsd005";s:4:"name";s:21:"Racer Back Maxi Dress";s:5:"price";s:8:"224.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:107;a:14:{s:12:"increment_id";s:9:"100000201";s:10:"created_at";s:19:"2013-05-25 14:37:05";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"wsd005";s:4:"name";s:21:"Racer Back Maxi Dress";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:108;a:14:{s:12:"increment_id";s:9:"100000202";s:10:"created_at";s:19:"2013-05-25 14:43:25";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"hdd001";s:4:"name";s:26:"Modern Murray Ceramic Vase";s:5:"price";s:8:"135.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:109;a:14:{s:12:"increment_id";s:9:"100000202";s:10:"created_at";s:19:"2013-05-25 14:43:25";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"hdd002";s:4:"name";s:26:"Modern Murray Ceramic Vase";s:5:"price";s:8:"135.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:110;a:14:{s:12:"increment_id";s:9:"100000202";s:10:"created_at";s:19:"2013-05-25 14:43:25";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"hdb001";s:4:"name";s:22:"Bath Minerals and Salt";s:5:"price";s:7:"25.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:111;a:14:{s:12:"increment_id";s:9:"100000202";s:10:"created_at";s:19:"2013-05-25 14:43:25";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:20:"hdb010-hdb007-hdb006";s:4:"name";s:20:"Pillow and Throw Set";s:5:"price";s:8:"485.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:112;a:14:{s:12:"increment_id";s:9:"100000202";s:10:"created_at";s:19:"2013-05-25 14:43:25";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"hdb006";s:4:"name";s:19:"Shay Printed Pillow";s:5:"price";s:8:"210.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:113;a:14:{s:12:"increment_id";s:9:"100000202";s:10:"created_at";s:19:"2013-05-25 14:43:25";s:11:"customer_id";s:3:"136";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:19:"janedoe@magento.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"hdb007";s:4:"name";s:21:"Carnegie Alpaca Throw";s:5:"price";s:8:"275.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:114;a:14:{s:12:"increment_id";s:9:"100000203";s:10:"created_at";s:19:"2013-05-27 17:07:47";s:11:"customer_id";s:3:"100";s:17:"customer_lastname";s:5:"Smith";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:21:"janesmith@example.com";s:6:"street";s:11:"Main Street";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10038";s:3:"sku";s:6:"wbk006";s:4:"name";s:24:"Delancy Cardigan Sweater";s:5:"price";s:8:"275.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:115;a:14:{s:12:"increment_id";s:9:"100000203";s:10:"created_at";s:19:"2013-05-27 17:07:47";s:11:"customer_id";s:3:"100";s:17:"customer_lastname";s:5:"Smith";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:21:"janesmith@example.com";s:6:"street";s:11:"Main Street";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10038";s:3:"sku";s:6:"wbk006";s:4:"name";s:24:"Delancy Cardigan Sweater";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:116;a:14:{s:12:"increment_id";s:9:"100000203";s:10:"created_at";s:19:"2013-05-27 17:07:47";s:11:"customer_id";s:3:"100";s:17:"customer_lastname";s:5:"Smith";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:21:"janesmith@example.com";s:6:"street";s:11:"Main Street";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10038";s:3:"sku";s:6:"acj003";s:4:"name";s:19:"Pearl Stud Earrings";s:5:"price";s:8:"110.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:117;a:14:{s:12:"increment_id";s:9:"100000204";s:10:"created_at";s:19:"2013-05-27 17:08:58";s:11:"customer_id";s:3:"100";s:17:"customer_lastname";s:5:"Smith";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:21:"janesmith@example.com";s:6:"street";s:11:"Main Street";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10038";s:3:"sku";s:6:"ace000";s:4:"name";s:18:"Aviator Sunglasses";s:5:"price";s:8:"295.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:118;a:14:{s:12:"increment_id";s:9:"100000205";s:10:"created_at";s:19:"2013-05-27 17:10:20";s:11:"customer_id";s:3:"100";s:17:"customer_lastname";s:5:"Smith";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:21:"janesmith@example.com";s:6:"street";s:11:"Main Street";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10038";s:3:"sku";s:6:"aws002";s:4:"name";s:26:"Barclay d'Orsay pump, Nude";s:5:"price";s:8:"390.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:119;a:14:{s:12:"increment_id";s:9:"100000205";s:10:"created_at";s:19:"2013-05-27 17:10:20";s:11:"customer_id";s:3:"100";s:17:"customer_lastname";s:5:"Smith";s:18:"customer_firstname";s:4:"Jane";s:14:"customer_email";s:21:"janesmith@example.com";s:6:"street";s:11:"Main Street";s:4:"city";s:8:"New York";s:6:"region";s:8:"New York";s:8:"postcode";s:5:"10038";s:3:"sku";s:6:"aws002";s:4:"name";s:26:"Barclay d'Orsay pump, Nude";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:120;a:14:{s:12:"increment_id";s:9:"100000206";s:10:"created_at";s:19:"2013-05-28 18:28:25";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"gif001";s:4:"name";s:30:"Virtual and Physical Gift Card";s:5:"price";s:8:"150.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:121;a:14:{s:12:"increment_id";s:9:"100000206";s:10:"created_at";s:19:"2013-05-28 18:28:25";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:8:"acj00124";s:4:"name";s:21:"Pearl Strand Necklace";s:5:"price";s:8:"280.0000";s:12:"qty_invoiced";s:6:"2.0000";}i:122;a:14:{s:12:"increment_id";s:9:"100000206";s:10:"created_at";s:19:"2013-05-28 18:28:25";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:8:"acj00124";s:4:"name";s:25:"Pearl Strand Necklace-24"";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"2.0000";}i:123;a:14:{s:12:"increment_id";s:9:"100000206";s:10:"created_at";s:19:"2013-05-28 18:28:25";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"hdb001";s:4:"name";s:22:"Bath Minerals and Salt";s:5:"price";s:7:"25.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:124;a:14:{s:12:"increment_id";s:9:"100000206";s:10:"created_at";s:19:"2013-05-28 18:28:25";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"hde001";s:4:"name";s:14:"Madison LX2200";s:5:"price";s:8:"425.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:125;a:14:{s:12:"increment_id";s:9:"100000208";s:10:"created_at";s:19:"2013-05-29 06:29:44";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"msj012";s:4:"name";s:12:"Linen Blazer";s:5:"price";s:8:"455.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:126;a:14:{s:12:"increment_id";s:9:"100000208";s:10:"created_at";s:19:"2013-05-29 06:29:44";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"msj012";s:4:"name";s:12:"Linen Blazer";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:127;a:14:{s:12:"increment_id";s:9:"100000208";s:10:"created_at";s:19:"2013-05-29 06:29:44";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"ace001";s:4:"name";s:25:"Jackie O Round Sunglasses";s:5:"price";s:8:"225.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:128;a:14:{s:12:"increment_id";s:9:"100000210";s:10:"created_at";s:19:"2013-05-29 06:47:04";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";N;s:4:"city";N;s:6:"region";N;s:8:"postcode";N;s:3:"sku";s:7:"hbm003 ";s:4:"name";s:19:"Alice in Wonderland";s:5:"price";s:6:"5.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:129;a:14:{s:12:"increment_id";s:9:"100000210";s:10:"created_at";s:19:"2013-05-29 06:47:04";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";N;s:4:"city";N;s:6:"region";N;s:8:"postcode";N;s:3:"sku";s:6:"hbm005";s:4:"name";s:30:"Falling by I Am Not Lefthanded";s:5:"price";s:6:"2.0000";s:12:"qty_invoiced";s:6:"1.0000";}i:130;a:14:{s:12:"increment_id";s:9:"100000211";s:10:"created_at";s:19:"2013-05-29 19:55:38";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"abl000";s:4:"name";s:22:"Isla Crossbody Handbag";s:5:"price";s:8:"340.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:131;a:14:{s:12:"increment_id";s:9:"100000211";s:10:"created_at";s:19:"2013-05-29 19:55:38";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"hdb001";s:4:"name";s:22:"Bath Minerals and Salt";s:5:"price";s:7:"25.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:132;a:14:{s:12:"increment_id";s:9:"100000211";s:10:"created_at";s:19:"2013-05-29 19:55:38";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"gif001";s:4:"name";s:30:"Virtual and Physical Gift Card";s:5:"price";s:7:"50.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:133;a:14:{s:12:"increment_id";s:9:"100000211";s:10:"created_at";s:19:"2013-05-29 19:55:38";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:8:"acj0006s";s:4:"name";s:23:"Blue Horizons Bracelets";s:5:"price";s:7:"55.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:134;a:14:{s:12:"increment_id";s:9:"100000211";s:10:"created_at";s:19:"2013-05-29 19:55:38";s:11:"customer_id";s:3:"135";s:17:"customer_lastname";s:3:"Doe";s:18:"customer_firstname";s:4:"John";s:14:"customer_email";s:19:"johndoe@example.com";s:6:"street";s:31:"10441 Jefferson Blvd, Suite 200";s:4:"city";s:11:"Culver City";s:6:"region";s:10:"California";s:8:"postcode";s:5:"90232";s:3:"sku";s:6:"hde010";s:4:"name";s:15:"Madison Earbuds";s:5:"price";s:7:"35.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:135;a:14:{s:12:"increment_id";s:9:"145000002";s:10:"created_at";s:19:"2015-02-17 20:33:41";s:11:"customer_id";s:3:"142";s:17:"customer_lastname";s:7:"Sanborn";s:18:"customer_firstname";s:4:"Mark";s:14:"customer_email";s:23:"mark.sanborn@vonnda.com";s:6:"street";s:21:"660 York St
2
+ Suite 202";s:4:"city";s:13:"San Francisco";s:6:"region";s:10:"California";s:8:"postcode";s:5:"94115";s:3:"sku";s:6:"msj012";s:4:"name";s:12:"Linen Blazer";s:5:"price";s:8:"455.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:136;a:14:{s:12:"increment_id";s:9:"145000002";s:10:"created_at";s:19:"2015-02-17 20:33:41";s:11:"customer_id";s:3:"142";s:17:"customer_lastname";s:7:"Sanborn";s:18:"customer_firstname";s:4:"Mark";s:14:"customer_email";s:23:"mark.sanborn@vonnda.com";s:6:"street";s:21:"660 York St
3
+ Suite 202";s:4:"city";s:13:"San Francisco";s:6:"region";s:10:"California";s:8:"postcode";s:5:"94115";s:3:"sku";s:6:"msj012";s:4:"name";s:12:"Linen Blazer";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:137;a:14:{s:12:"increment_id";s:9:"145000002";s:10:"created_at";s:19:"2015-02-17 20:33:41";s:11:"customer_id";s:3:"142";s:17:"customer_lastname";s:7:"Sanborn";s:18:"customer_firstname";s:4:"Mark";s:14:"customer_email";s:23:"mark.sanborn@vonnda.com";s:6:"street";s:21:"660 York St
4
+ Suite 202";s:4:"city";s:13:"San Francisco";s:6:"region";s:10:"California";s:8:"postcode";s:5:"94115";s:3:"sku";s:8:"msj003xs";s:4:"name";s:27:"Slim fit Dobby Oxford Shirt";s:5:"price";s:8:"140.0000";s:12:"qty_invoiced";s:6:"0.0000";}i:138;a:14:{s:12:"increment_id";s:9:"145000002";s:10:"created_at";s:19:"2015-02-17 20:33:41";s:11:"customer_id";s:3:"142";s:17:"customer_lastname";s:7:"Sanborn";s:18:"customer_firstname";s:4:"Mark";s:14:"customer_email";s:23:"mark.sanborn@vonnda.com";s:6:"street";s:21:"660 York St
5
+ Suite 202";s:4:"city";s:13:"San Francisco";s:6:"region";s:10:"California";s:8:"postcode";s:5:"94115";s:3:"sku";s:8:"msj003xs";s:4:"name";s:27:"Slim fit Dobby Oxford Shirt";s:5:"price";s:6:"0.0000";s:12:"qty_invoiced";s:6:"0.0000";}}
package.xml CHANGED
@@ -1,7 +1,7 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Taxify_Sales_Tax_Rates_and_Filing</name>
4
- <version>0.1.1</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.gnu.org/licenses/gpl-2.0.html">GNU General Public License V2</license>
7
  <channel>community</channel>
@@ -10,9 +10,9 @@
10
  <description>Taxify ensures that your Magento store collects, reports and remits accurate sales taxes for all Federal, state, and local jurisdictions throughout the United States</description>
11
  <notes>Initial Public Release</notes>
12
  <authors><author><name>Vonnda Development</name><user>Vonnda</user><email>info@vonnda.com</email></author></authors>
13
- <date>2015-02-18</date>
14
- <time>23:42:21</time>
15
- <contents><target name="magelocal"><dir name="Vonnda"><dir name="Taxify"><dir name="Block"><dir name="Adminhtml"><dir name="Tax"><dir name="Class"><dir name="Edit"><file name="Form.php" hash="279d8ed35ba0111216682c1613e65e9f"/></dir></dir></dir></dir></dir><dir name="Helper"><file name="Data.php" hash="4849bb226490a464c65ccbb624b248a7"/></dir><dir name="Model"><file name="Client.php" hash="94166ffd2b1ad7da5aad6747656cb61a"/><file name="Config.php" hash="2db3425ee59a162dedf5ef8a4fa655e3"/><file name="Feed.php" hash="04f391cc7357d47184c243e81d068bf7"/><file name="Observer.php" hash="52d7d7e74b2a0676b58ad4262e26fc49"/><dir name="Request"><file name="Calculate.php" hash="f0b3e106601fbea1a3af114fbba7d573"/><file name="Cancel.php" hash="2d1eadf52123f4db8151832502d8ba01"/><file name="Commit.php" hash="3ec21b8860ab14f3eadc7bb9e53c02c1"/><file name="Request.php" hash="c4e92c7d67e249750508017b74d0cc3c"/><file name="Verifyaddress.php" hash="fff9f9d0ac574ac185916afaf7bdde0c"/><file name="Version.php" hash="ff41825cbc827abed4e0a2597e67ee67"/><file name=".Calculate.php.swp" hash="ad08fce503a30eacdf20d709cda773a3"/></dir><dir name="Resource"><dir name="Mysql4"><file name="Setup.php" hash="326120cd05749e9b48e7dd966a3b2c19"/></dir></dir><dir name="Sales"><dir name="Quote"><dir name="Address"><dir name="Total"><file name="Tax.php" hash="8f7ffa65d9d537e4558329d46f53b47a"/></dir></dir></dir></dir></dir><dir name="etc"><file name="config.xml" hash="c45aad1a2501465e8a5e704e7ad8839f"/><file name="system.xml" hash="f99743421bbf8bf7c4d19dca7a4b0d53"/></dir><dir name="sql"><dir name="taxify_setup"><file name="mysql4-install-0.1.1.php" hash="523629216cc236efa1e3a08dc40b9291"/></dir></dir><dir name="tests"><dir name="Helper"><file name="DataTest.php" hash="da05ea802f6266b7a0fceed28c3d52c5"/></dir><dir name="Request"><file name="CalculateTest.php" hash="7bd6291be8d42329a211fd6f73161cd8"/><file name="CancelTest.php" hash="b8ba6f0004d493f72ce22c66375ffdac"/><file name="CommitTest.php" hash="59c4473ba919047dd821e05b335dbc38"/></dir><file name="SampleTest.php" hash="32606c8d8b84d95aec73bdeb1c03ca1e"/><dir name="fixtures"><file name="calculateMultiSimpleProductSuccess.txt" hash="6d7426310bebbcb0b758697035a4e8f7"/><file name="calculateSuccess.txt" hash="892ebdae0cd70bcf36cc34be2d21da76"/></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Vonnda_Taxify.xml" hash="b3120a86b364f80ee8daf825412a1318"/></dir></target></contents>
16
  <compatible/>
17
  <dependencies><required><php><min>5.3.0</min><max>5.6.2</max></php></required></dependencies>
18
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Taxify_Sales_Tax_Rates_and_Filing</name>
4
+ <version>0.1.2</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.gnu.org/licenses/gpl-2.0.html">GNU General Public License V2</license>
7
  <channel>community</channel>
10
  <description>Taxify ensures that your Magento store collects, reports and remits accurate sales taxes for all Federal, state, and local jurisdictions throughout the United States</description>
11
  <notes>Initial Public Release</notes>
12
  <authors><author><name>Vonnda Development</name><user>Vonnda</user><email>info@vonnda.com</email></author></authors>
13
+ <date>2015-03-04</date>
14
+ <time>18:51:25</time>
15
+ <contents><target name="magelocal"><dir name="Vonnda"><dir name="Taxify"><dir name="Block"><dir name="Adminhtml"><dir name="Tax"><dir name="Class"><dir name="Edit"><file name="Form.php" hash="279d8ed35ba0111216682c1613e65e9f"/></dir></dir></dir></dir></dir><dir name="Helper"><file name="Data.php" hash="4849bb226490a464c65ccbb624b248a7"/></dir><dir name="Model"><file name="Client.php" hash="94166ffd2b1ad7da5aad6747656cb61a"/><file name="Config.php" hash="2db3425ee59a162dedf5ef8a4fa655e3"/><dir name="Export"><file name="Row.php" hash="7c1ba01053c94524fa5bca031e310747"/></dir><file name="Export.php" hash="a7c54832cb11773f1598aa3a4778a59e"/><file name="Feed.php" hash="04f391cc7357d47184c243e81d068bf7"/><file name="Observer.php" hash="52d7d7e74b2a0676b58ad4262e26fc49"/><dir name="Request"><file name="Calculate.php" hash="f0b3e106601fbea1a3af114fbba7d573"/><file name="Cancel.php" hash="2d1eadf52123f4db8151832502d8ba01"/><file name="Commit.php" hash="3ec21b8860ab14f3eadc7bb9e53c02c1"/><file name="Request.php" hash="c4e92c7d67e249750508017b74d0cc3c"/><file name="Verifyaddress.php" hash="fff9f9d0ac574ac185916afaf7bdde0c"/><file name="Version.php" hash="ff41825cbc827abed4e0a2597e67ee67"/></dir><dir name="Resource"><dir name="Mysql4"><file name="Setup.php" hash="326120cd05749e9b48e7dd966a3b2c19"/></dir></dir><dir name="Sales"><dir name="Quote"><dir name="Address"><dir name="Total"><file name="Tax.php" hash="e80f3ee45a3f754fe98b851136546caa"/><file name=".Tax.php.swp" hash="8432b4075e1a7635338e510ec1ef66e5"/></dir></dir></dir></dir><file name=".Observer.php.swp" hash="c25c69f7b8955aee1bc0cf13829dfa37"/></dir><dir name="controllers"><file name="ExportController.php" hash="b3d01205020d5cf3809bdfc5625abb72"/></dir><dir name="etc"><file name="adminhtml.xml" hash="438da0a4ed05ca800233f73fef1c65a8"/><file name="config.xml" hash="acb0fdac89c51ea5da23e0b462de833a"/><file name="system.xml" hash="f99743421bbf8bf7c4d19dca7a4b0d53"/></dir><dir name="sql"><dir name="taxify_setup"><file name="mysql4-install-0.1.1.php" hash="523629216cc236efa1e3a08dc40b9291"/></dir></dir><dir name="tests"><dir name="Helper"><file name="DataTest.php" hash="da05ea802f6266b7a0fceed28c3d52c5"/></dir><dir name="Model"><dir name="Export"><file name="RowTest.php" hash="370afb16507950dcbf2ac27090c8452c"/></dir><file name="ExportTest.php" hash="04ec5d1e4a71bf840881b2cb55be5528"/></dir><dir name="Request"><file name="CalculateTest.php" hash="7bd6291be8d42329a211fd6f73161cd8"/><file name="CancelTest.php" hash="b8ba6f0004d493f72ce22c66375ffdac"/><file name="CommitTest.php" hash="59c4473ba919047dd821e05b335dbc38"/></dir><file name="SampleTest.php" hash="32606c8d8b84d95aec73bdeb1c03ca1e"/><dir name="fixtures"><file name="calculateMultiSimpleProductSuccess.txt" hash="6d7426310bebbcb0b758697035a4e8f7"/><file name="calculateSuccess.txt" hash="892ebdae0cd70bcf36cc34be2d21da76"/><file name="exportQueryResult.txt" hash="d07fec0de05420e89536fadb822baa84"/></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Vonnda_Taxify.xml" hash="b3120a86b364f80ee8daf825412a1318"/></dir></target></contents>
16
  <compatible/>
17
  <dependencies><required><php><min>5.3.0</min><max>5.6.2</max></php></required></dependencies>
18
  </package>