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 +0 -0
- app/code/local/Vonnda/Taxify/Model/Export.php +190 -0
- app/code/local/Vonnda/Taxify/Model/Export/Row.php +100 -0
- app/code/local/Vonnda/Taxify/Model/Request/.Calculate.php.swp +0 -0
- app/code/local/Vonnda/Taxify/Model/Sales/Quote/Address/Total/.Tax.php.swp +0 -0
- app/code/local/Vonnda/Taxify/Model/Sales/Quote/Address/Total/Tax.php +1 -0
- app/code/local/Vonnda/Taxify/controllers/ExportController.php +51 -0
- app/code/local/Vonnda/Taxify/etc/adminhtml.xml +39 -0
- app/code/local/Vonnda/Taxify/etc/config.xml +12 -1
- app/code/local/Vonnda/Taxify/tests/Model/Export/RowTest.php +116 -0
- app/code/local/Vonnda/Taxify/tests/Model/ExportTest.php +146 -0
- app/code/local/Vonnda/Taxify/tests/fixtures/exportQueryResult.txt +5 -0
- package.xml +4 -4
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.
|
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.
|
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-
|
14 |
-
<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"
|
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>
|