Ds_Import - Version 1.0.0

Version Notes

stable

Download this release

Release Info

Developer Dotsquares
Extension Ds_Import
Version 1.0.0
Comparing to
See all releases


Version 1.0.0

Files changed (35) hide show
  1. app/code/community/Ds/Imports/Block/Adminhtml/Sales/Order.php +13 -0
  2. app/code/community/Ds/Imports/Block/Adminhtml/Sales/Order/Form.php +74 -0
  3. app/code/community/Ds/Imports/Block/Adminhtml/Sales/Order/Grid.php +141 -0
  4. app/code/community/Ds/Imports/Helper/Data.php +109 -0
  5. app/code/community/Ds/Imports/Model/Allorder.php +154 -0
  6. app/code/community/Ds/Imports/Model/Createorder.php +447 -0
  7. app/code/community/Ds/Imports/Model/Functional/Creditmemo.php +86 -0
  8. app/code/community/Ds/Imports/Model/Functional/Export.php +136 -0
  9. app/code/community/Ds/Imports/Model/Functional/Invoice.php +48 -0
  10. app/code/community/Ds/Imports/Model/Functional/Shipment.php +50 -0
  11. app/code/community/Ds/Imports/Model/Importallorders.php +171 -0
  12. app/code/community/Ds/Imports/Model/Selectorder.php +157 -0
  13. app/code/community/Ds/Imports/Model/Table/Billingtable.php +27 -0
  14. app/code/community/Ds/Imports/Model/Table/Csvcontent.php +109 -0
  15. app/code/community/Ds/Imports/Model/Table/Csvhead.php +128 -0
  16. app/code/community/Ds/Imports/Model/Table/Saleitems.php +37 -0
  17. app/code/community/Ds/Imports/Model/Table/Saletable.php +75 -0
  18. app/code/community/Ds/Imports/controllers/Adminhtml/ExportsController.php +59 -0
  19. app/code/community/Ds/Imports/controllers/Adminhtml/ImportsController.php +61 -0
  20. app/code/community/Ds/Imports/etc/adminhtml.xml +61 -0
  21. app/code/community/Ds/Imports/etc/config.xml +68 -0
  22. app/code/community/Ds/Imports/etc/system.xml +46 -0
  23. app/etc/modules/Ds_Imports.xml +9 -0
  24. package.xml +32 -0
  25. var/ds/log/error.htm +4 -0
  26. var/ds/ordercsv/orderexport_form_orderid_15_to_69_date_20160406_134431.csv +4 -0
  27. var/ds/ordercsv/orderexport_form_orderid_15_to_69_date_20160406_134628.csv +4 -0
  28. var/ds/ordercsv/orderexport_form_orderid_1_to_11_date_20160407_090823.csv +6 -0
  29. var/ds/ordercsv/orderexport_form_orderid_1_to_1_date_20160407_084241.csv +2 -0
  30. var/ds/ordercsv/orderexport_form_orderid_1_to_2_date_20160406_133253.csv +3 -0
  31. var/ds/ordercsv/orderexport_form_orderid_1_to_2_date_20160406_133352.csv +3 -0
  32. var/ds/ordercsv/orderexport_form_orderid_1_to_8_date_20160407_081033.csv +9 -0
  33. var/ds/ordercsv/orderexport_form_orderid_1_to_8_date_20160407_081059.csv +9 -0
  34. var/ds/ordercsv/orderexport_form_orderid_3_to_86_date_20160405_130734.csv +22 -0
  35. var/ds/ordercsv/orderexport_form_orderid_3_to_86_date_20160406_133855.csv +22 -0
app/code/community/Ds/Imports/Block/Adminhtml/Sales/Order.php ADDED
@@ -0,0 +1,13 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+ class Ds_Imports_Block_Adminhtml_Sales_Order extends Mage_Adminhtml_Block_Widget_Grid_Container
3
+ {
4
+ public function __construct()
5
+ {
6
+ $this->_blockGroup = 'imports';
7
+ $this->_controller = 'adminhtml_sales_order';
8
+ $this->_headerText = Mage::helper('imports')->__('Orders - Inchoo');
9
+
10
+ parent::__construct();
11
+ $this->_removeButton('add');
12
+ }
13
+ }
app/code/community/Ds/Imports/Block/Adminhtml/Sales/Order/Form.php ADDED
@@ -0,0 +1,74 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Block_Adminhtml_Sales_Order_Form extends Mage_Adminhtml_Block_Widget_Form
4
+ {
5
+ protected function _prepareForm()
6
+ {
7
+ $form = new Varien_Data_Form(array(
8
+ 'id' => 'config_form',
9
+ 'action' => $this->getUrl('*/*/importallOrders'),
10
+ 'method' => 'post',
11
+ 'enctype' => 'multipart/form-data'
12
+ ));
13
+ $form->setUseContainer(true);
14
+ $this->setForm($form);
15
+ $fieldset = $form->addFieldset('imports_form', array('legend'=>Mage::helper('imports')->__('Import Orders')));
16
+ $fieldset->addField('store_id', 'select', array(
17
+ 'name' => 'store_id',
18
+ 'label' => Mage::helper('imports')->__('Store View'),
19
+ 'title' => Mage::helper('imports')->__('Store View'),
20
+ 'required' => true,
21
+ 'values' => Mage::getModel('imports/functional_export')->getStoreIds(),
22
+ ));
23
+ $fieldset->addField('import_limit', 'select', array(
24
+ 'label' => Mage::helper('imports')->__('Order Import Limit'),
25
+ 'name' => 'import_limit',
26
+ 'required' => true,
27
+ 'values' => array(
28
+ array(
29
+ 'value' => '25',
30
+ 'label' => Mage::helper('imports')->__('25'),
31
+ ),
32
+ array(
33
+ 'value' => '50',
34
+ 'label' => Mage::helper('imports')->__('50'),
35
+ ),
36
+ array(
37
+ 'value' => '100',
38
+ 'label' => Mage::helper('imports')->__('100'),
39
+ ),
40
+ array(
41
+ 'value' => '150',
42
+ 'label' => Mage::helper('imports')->__('150'),
43
+ ),
44
+ array(
45
+ 'value' => '200',
46
+ 'label' => Mage::helper('imports')->__('200'),
47
+ ),
48
+ ),
49
+ ));
50
+
51
+ $fieldset->addField('order_csv', 'file', array(
52
+ 'label' => Mage::helper('imports')->__('CSV File : '),
53
+ 'required' => true,
54
+ 'name' => 'order_csv',
55
+ 'after_element_html' => '</br>Note : <small>use the csv file which has been export by the same module.</small>',
56
+ ));
57
+
58
+ $fieldset->addField('submit', 'submit', array(
59
+ 'value' => 'Import',
60
+ 'after_element_html' => '<small></small>',
61
+ 'class' => 'form-button',
62
+ 'tabindex' => 1
63
+ ));
64
+
65
+ if ( Mage::getSingleton('adminhtml/session')->getExporterData() )
66
+ {
67
+ $form->setValues(Mage::getSingleton('adminhtml/session')->getExporterData());
68
+ Mage::getSingleton('adminhtml/session')->setExporterData(null);
69
+ } elseif ( Mage::registry('imports_data') ) {
70
+ $form->setValues(Mage::registry('imports_data')->getData());
71
+ }
72
+ return parent::_prepareForm();
73
+ }
74
+ }
app/code/community/Ds/Imports/Block/Adminhtml/Sales/Order/Grid.php ADDED
@@ -0,0 +1,141 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+ class Ds_Imports_Block_Adminhtml_Sales_Order_Grid extends Mage_Adminhtml_Block_Widget_Grid
3
+ {
4
+ public function __construct()
5
+ {
6
+ parent::__construct();
7
+ $this->setId('sales_order_export_grid');
8
+ $this->setDefaultSort('increment_id');
9
+ $this->setDefaultDir('DESC');
10
+ $this->setSaveParametersInSession(true);
11
+ $this->setUseAjax(true);
12
+ $this->setFilterVisibility(true);
13
+ }
14
+
15
+ protected function _getCollectionClass()
16
+ {
17
+ return 'sales/order_grid_collection';
18
+ }
19
+
20
+ protected function _prepareCollection()
21
+ {
22
+ $collection = Mage::getResourceModel($this->_getCollectionClass());
23
+ $this->setCollection($collection);
24
+ return parent::_prepareCollection();
25
+ }
26
+
27
+
28
+ protected function _prepareColumns()
29
+ {
30
+
31
+ $this->addColumn('real_order_id', array(
32
+ 'header'=> Mage::helper('sales')->__('Order #'),
33
+ 'width' => '80px',
34
+ 'type' => 'text',
35
+ 'index' => 'increment_id',
36
+ ));
37
+
38
+ if (!Mage::app()->isSingleStoreMode()) {
39
+ $this->addColumn('store_id', array(
40
+ 'header' => Mage::helper('sales')->__('Purchased From (Store)'),
41
+ 'index' => 'store_id',
42
+ 'type' => 'store',
43
+ 'store_view'=> true,
44
+ 'display_deleted' => true,
45
+ ));
46
+ }
47
+
48
+ $this->addColumn('created_at', array(
49
+ 'header' => Mage::helper('sales')->__('Purchased On'),
50
+ 'index' => 'created_at',
51
+ 'type' => 'datetime',
52
+ 'width' => '100px',
53
+ ));
54
+
55
+ $this->addColumn('billing_name', array(
56
+ 'header' => Mage::helper('sales')->__('Bill to Name'),
57
+ 'index' => 'billing_name',
58
+ ));
59
+
60
+ $this->addColumn('shipping_name', array(
61
+ 'header' => Mage::helper('sales')->__('Ship to Name'),
62
+ 'index' => 'shipping_name',
63
+ ));
64
+
65
+ $this->addColumn('base_grand_total', array(
66
+ 'header' => Mage::helper('sales')->__('G.T. (Base)'),
67
+ 'index' => 'base_grand_total',
68
+ 'type' => 'currency',
69
+ 'currency' => 'base_currency_code',
70
+ ));
71
+
72
+ $this->addColumn('grand_total', array(
73
+ 'header' => Mage::helper('sales')->__('G.T. (Purchased)'),
74
+ 'index' => 'grand_total',
75
+ 'type' => 'currency',
76
+ 'currency' => 'order_currency_code',
77
+ ));
78
+
79
+ $this->addColumn('status', array(
80
+ 'header' => Mage::helper('sales')->__('Status'),
81
+ 'index' => 'status',
82
+ 'type' => 'options',
83
+ 'width' => '70px',
84
+ 'options' => Mage::getSingleton('sales/order_config')->getStatuses(),
85
+ ));
86
+
87
+ /* if (Mage::getSingleton('admin/session')->isAllowed('sales/order/actions/view')) {
88
+ $this->addColumn('action',
89
+ array(
90
+ 'header' => Mage::helper('sales')->__('Action'),
91
+ 'width' => '50px',
92
+ 'type' => 'action',
93
+ 'getter' => 'getId',
94
+ 'actions' => array(
95
+ array(
96
+ 'caption' => Mage::helper('sales')->__('View'),
97
+ 'url' => array('base'=>'adminhtml/sales_order/view'),
98
+ 'field' => 'order_id'
99
+ )
100
+ ),
101
+ 'filter' => false,
102
+ 'sortable' => false,
103
+ 'index' => 'stores',
104
+ 'is_system' => true,
105
+ ));
106
+ } */
107
+
108
+ $this->addExportType('*/*/exportallorder', Mage::helper('imports')->__('All Order CSV'));
109
+
110
+ return parent::_prepareColumns();
111
+ }
112
+
113
+ /* protected function _prepareMassaction()
114
+ {
115
+ parent::_prepareMassaction();
116
+
117
+ $this->getMassactionBlock()->addItem(
118
+ 'imports',
119
+ array('label' => $this->__('Export'),
120
+ 'url' => $this->getUrl('exports/selectorder')
121
+ )
122
+ );
123
+ } */
124
+
125
+ protected function _prepareMassaction()
126
+ {
127
+ $this->setMassactionIdField('entity_id');
128
+ $this->getMassactionBlock()->setFormFieldName('order_ids');
129
+ $this->getMassactionBlock()->setUseSelectAll(false);
130
+
131
+ $this->getMassactionBlock()->addItem('export_order', array(
132
+ 'label'=> Mage::helper('sales')->__('Export Orders'),
133
+ 'url' => $this->getUrl('*/*/selectorder'),
134
+ ));
135
+ return $this;
136
+ }
137
+ public function getGridUrl()
138
+ {
139
+ return $this->getUrl('*/*/grid', array('_current'=>true));
140
+ }
141
+ }
app/code/community/Ds/Imports/Helper/Data.php ADDED
@@ -0,0 +1,109 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Helper_Data extends Mage_Core_Helper_Abstract
4
+ {
5
+ public $error_file = '';
6
+
7
+ public function __construct()
8
+ {
9
+ $this->error_file = Mage::getBaseDir('var') .'/ds/log/error.htm';
10
+ $handle = fopen($this->error_file, "a+");
11
+ chmod($this->error_file, 0777);
12
+ }
13
+
14
+ public function logException(Exception $exception,$order_id,$type,$line_nuber = '')
15
+ {
16
+ $message = $exception->getMessage();
17
+ $code = $exception->getCode();
18
+ $file = $exception->getFile();
19
+ $line = $exception->getLine();
20
+ $trace = $exception->getTraceAsString();
21
+ $date = date('M d, Y h:iA');
22
+
23
+ if($type=='order'){
24
+ $log_message = "<p><strong>Order Id:</strong> {$order_id}
25
+ <p><strong>Error Message:</strong> {$message}</p>
26
+ <p><strong>Line Number:</strong> {$line_nuber}</p>
27
+ <p><strong>Date:</strong> {$date}</p>";
28
+ }
29
+ else if($type=='invoice'){
30
+ $log_message = "<p><strong>Invoice Error : </strong></p>
31
+ <p><strong>Order Id:</strong> {$order_id}</p>
32
+ <p><strong>Error Message:</strong> {$message}</p>
33
+ <p><strong>Date:</strong> {$date}</p>";
34
+ }
35
+ else if($type=='shipment'){
36
+ $log_message = "<p><strong>Shipment Error : </strong></p>
37
+ <p><strong>Order Id:</strong> {$order_id}</p>
38
+ <p><strong>Error Message:</strong> {$message}</p>";
39
+ }
40
+ else if($type=='creditmemo'){
41
+ $log_message = "<p><strong>Creditmemo Error : </strong></p>
42
+ <p><strong>Order Id:</strong> {$order_id}</p>
43
+ <p><strong>Error Message:</strong> {$message}</p>
44
+ <p><strong>Date:</strong> {$date}</p>";
45
+ }
46
+
47
+ if( is_file($this->error_file) === false ) {
48
+ file_put_contents($this->error_file, '');
49
+ }
50
+
51
+ $content = file_get_contents($this->error_file);
52
+ file_put_contents($this->error_file, $content.$log_message);
53
+ }
54
+
55
+ public function logAvailable($order_id,$type,$line_nuber)
56
+ {
57
+ $message = "Order id already exist";
58
+ $log_message = "<p><strong>Order Id:</strong> {$order_id}</p>
59
+ <p><strong>Error Message:</strong> {$message}</p>
60
+ <p><strong>Line Number:</strong> {$line_nuber}</p>
61
+ <p><strong>Date:</strong> {$date}</p>";
62
+
63
+ if( is_file($this->error_file) === false ) {
64
+ file_put_contents($this->error_file, '');
65
+ }
66
+ $content = file_get_contents($this->error_file);
67
+ file_put_contents($this->error_file, $content.$log_message);
68
+ }
69
+
70
+ public function header()
71
+ {
72
+ file_put_contents($this->error_file, '<h3 style="text-align:center;">Error information:</h3><hr /><br />');
73
+ }
74
+
75
+ public function isPrintable()
76
+ {
77
+ if(filesize($this->error_file)>67)
78
+ return true;
79
+ }
80
+
81
+ public function footer()
82
+ {
83
+ $content = file_get_contents($this->error_file);
84
+ file_put_contents($this->error_file, $content.'<br /><hr /><br /><br />');
85
+ }
86
+
87
+ public function unlinkFile()
88
+ {
89
+ unlink($this->error_file);
90
+ }
91
+
92
+ public function getVersion()
93
+ {
94
+ $m= new Mage;
95
+ $version=$m->getVersion();
96
+ if(in_array($version,array('1.5.0.0','1.5.0.1','1.5.1.0','1.6.0.0','1.9.1.1','1.10.0.2','1.10.1.1','1.11.0.0')))
97
+ return true;
98
+ else
99
+ return false;
100
+ }
101
+
102
+ public function getStoreVar() {
103
+ if(Mage::getStoreConfig('ds_imports/dsimports/enable')== 1 && Mage::getStoreConfig('ds_imports/dsimports/enable') ==1){
104
+ return true;
105
+ }
106
+ return false;
107
+ }
108
+
109
+ }
app/code/community/Ds/Imports/Model/Allorder.php ADDED
@@ -0,0 +1,154 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Model_Allorder extends Ds_Imports_Model_Functional_Export
4
+ {
5
+ const ENCLOSURE = '"';
6
+ const DELIMITER = ',';
7
+
8
+ public function selectOrders($orders)
9
+ {
10
+ $i = 0;
11
+ $len = count($orders);
12
+ //echo $len;
13
+ foreach ($orders as $item) {
14
+ if ($i == 0) {
15
+ $startid = $item;
16
+ } else if ($i == $len - 1) {
17
+ $lastid = $item;
18
+ }
19
+ $i++;
20
+ }
21
+ if($lastid == 0 || $lastid == null || empty($lastid)){
22
+ $lastid = $startid;
23
+ }
24
+ if($startid > $lastid){
25
+ $lastid1 = $lastid;
26
+ $lastid = $startid;
27
+ $startid = $lastid1;
28
+ }
29
+
30
+ $fileName = 'orderexport_form_orderid_'.$startid.'_to_'.$lastid.'_date_'.date("Ymd_His").'.csv';
31
+ //echo $fileName;
32
+ //die();
33
+ $locatio = Mage::getBaseDir('var').'\ds\ordercsv';
34
+ $fp = fopen($locatio .'/'.$fileName, 'w');
35
+ $this->writeHeadRow($fp);
36
+ foreach ($orders as $order) {
37
+ $order = Mage::getModel('sales/order')->load($order);
38
+ $this->writeOrder($order, $fp);
39
+ }
40
+
41
+ fclose($fp);
42
+
43
+ return $fileName;
44
+ }
45
+
46
+ public function selectOrdersdownload($orders)
47
+ {
48
+ $i = 0;
49
+ $len = count($orders);
50
+ //echo $len;
51
+ foreach ($orders as $item) {
52
+ if ($i == 0) {
53
+ $startid = $item;
54
+ } else if ($i == $len - 1) {
55
+ $lastid = $item;
56
+ }
57
+ $i++;
58
+ }
59
+ if($lastid == 0 || $lastid == null || empty($lastid)){
60
+ $lastid = $startid;
61
+ }
62
+ if($startid > $lastid){
63
+ $lastid1 = $lastid;
64
+ $lastid = $startid;
65
+ $startid = $lastid1;
66
+ }
67
+
68
+ $fileName = 'orderexport_form_orderid_'.$startid.'_to_'.$lastid.'_date_'.date("Ymd_His").'.csv';
69
+ //echo $fileName;
70
+ //die("testing");
71
+ $locatio = Mage::getBaseDir('var').'\ds\ordercsv';
72
+ //$fp = fopen($locatio .'/'.$fileName, 'w');
73
+ $fp = fopen(Mage::getBaseDir('export').'/'.$fileName, 'w');
74
+ $this->writeHeadRow($fp);
75
+ foreach ($orders as $order) {
76
+ $order = Mage::getModel('sales/order')->load($order);
77
+ $this->writeOrder($order, $fp);
78
+ }
79
+
80
+ fclose($fp);
81
+
82
+ return $fileName;
83
+ }
84
+ public function writeHeadRow($fp)
85
+ {
86
+ $head = Mage::getModel('imports/table_csvhead')->getCSVHead();
87
+ fputcsv($fp, $head , self::DELIMITER, self::ENCLOSURE);
88
+ }
89
+
90
+
91
+ public function writeOrder($order, $fp)
92
+ {
93
+ $common = Mage::getModel('imports/table_csvcontent')->getCSVvalue($order);
94
+ $blank = $this->getBlankOrderValues($order);
95
+ $orderItems = $order->getItemsCollection();
96
+ $itemInc = 0;
97
+ $data = array();
98
+ $count = 0;
99
+ foreach ($orderItems as $item)
100
+ {
101
+ if($count==0)
102
+ {
103
+ $record = array_merge($common, $this->getOrderItemValues($item, $order, ++$itemInc));
104
+ fputcsv($fp, $record, self::DELIMITER, self::ENCLOSURE);
105
+ }
106
+ else
107
+ {
108
+ $record = array_merge($blank, $this->getOrderItemValues($item, $order, ++$itemInc));
109
+ fputcsv($fp, $record, self::DELIMITER, self::ENCLOSURE);
110
+ }
111
+ $count++;
112
+ }
113
+
114
+ }
115
+
116
+ public function getBlankOrderValues($order)
117
+ {
118
+ return array(
119
+ '','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',
120
+ '','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',
121
+ '','','','','','','','','','','','','','','','','','','','','','','','','');
122
+ }
123
+
124
+ //To return the array of ordered items
125
+ public function getOrderItemValues($item, $order, $itemInc=1)
126
+ {
127
+ return array(
128
+ $this->getItemSku($item),
129
+ $this->formatText($item->getName()),
130
+ (int)$item->getQtyOrdered(),
131
+ (int)$item->getQtyInvoiced(),
132
+ (int)$item->getQtyShipped(),
133
+ (int)$item->getQtyRefunded(),
134
+ (int)$item->getQtyCanceled(),
135
+ $item->getProductType(),
136
+ $item->getOriginalPrice(),
137
+ $item->getBaseOriginalPrice(),
138
+ $item->getRowTotal(),
139
+ $item->getBaseRowTotal(),
140
+ $item->getRowWeight(),
141
+ $item->getPriceInclTax(),
142
+ $item->getBasePriceInclTax(),
143
+ $item->getTaxAmount(),
144
+ $item->getBaseTaxAmount(),
145
+ $item->getTaxPercent(),
146
+ $item->getDiscountAmount(),
147
+ $item->getBaseDiscountAmount(),
148
+ $item->getDiscountPercent(),
149
+ $this->getChildInfo($item),
150
+ $item->getdata('product_options')
151
+ );
152
+ }
153
+
154
+ }
app/code/community/Ds/Imports/Model/Createorder.php ADDED
@@ -0,0 +1,447 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Model_Createorder extends Mage_Core_Model_Abstract
4
+ {
5
+ public $last_order_increment_id = null ;
6
+ public $order_items = array() ;
7
+ public $shipped_item = array() ;
8
+ public $invoiced_item = array() ;
9
+ public $credit_item = array() ;
10
+ public $canceled_item = array() ;
11
+ public $partial_shipped = false;
12
+ public $partial_credited = false;
13
+ public $partial_invoiced = false;
14
+ public $order_status = null;
15
+ public $order_detai_arr = null;
16
+ public $parent_id_flag = 0;
17
+ public $parent_id = 0;
18
+ public $store_id = 0;
19
+ public $invoice_created_at = '';
20
+ public $shipment_created_at = '';
21
+
22
+ public function _construct()
23
+ {
24
+ $this->setLastOrderItemId();
25
+ }
26
+
27
+ public function setItemData()
28
+ {
29
+ $order = $this->getOrderModel($this->last_order_increment_id);
30
+ $shipped_item = array();
31
+ $invoiced_item = array();
32
+ $credit_item = array();
33
+ $canceled_item = array();
34
+ $itemCount = 0;
35
+ $orderItems = $this->order_items;
36
+ foreach($order->getAllItems() as $item)
37
+ {
38
+ $shipped_item[$item->getItemId()] = $orderItems[$itemCount]['qty_shipped'];
39
+ $invoiced_item[$item->getItemId()] = $orderItems[$itemCount]['qty_invoiced'];
40
+ $credit_item[$item->getItemId()] = $orderItems[$itemCount]['qty_refunded'];
41
+ $canceled_item[$item->getItemId()] = $orderItems[$itemCount]['qty_canceled'];
42
+
43
+ if($orderItems[$itemCount]['qty_shipped']>0)
44
+ $this->partial_shipped = true;
45
+
46
+ if($orderItems[$itemCount]['qty_invoiced']>0)
47
+ $this->partial_invoiced = true;
48
+
49
+ if($orderItems[$itemCount]['qty_refunded']>0)
50
+ $this->partial_credited = true;
51
+
52
+ $itemCount++;
53
+ }
54
+
55
+ $this->invoiced_item = $invoiced_item;
56
+ $this->shipped_item = $shipped_item;
57
+ $this->credit_item = $credit_item;
58
+ $this->canceled_item = $canceled_item;
59
+ }
60
+
61
+ public function setGlobalData($last_order_increment_id,$order_items,$sales_order_arr)
62
+ {
63
+ $this->last_order_increment_id = $last_order_increment_id;
64
+ $this->order_items = $order_items;
65
+ $this->order_detai_arr = $sales_order_arr;
66
+ $this->order_status = $sales_order_arr['order_state'];
67
+ $this->invoice_created_at = $sales_order_arr['invoice_created_at'];
68
+ $this->shipment_created_at = $sales_order_arr['shipment_created_at'];
69
+ $this->setTime($last_order_increment_id,$sales_order_arr);
70
+ $this->setItemData();
71
+ }
72
+
73
+ public function setTime($last_order_increment_id,$sales_order_arr)
74
+ {
75
+ Mage::getModel('sales/order')->loadByIncrementId($last_order_increment_id)
76
+ ->setCreatedAt($sales_order_arr['created_at'])
77
+ ->setUpdatedAt($sales_order_arr['updated_at'])
78
+ ->save()
79
+ ->unsetData();
80
+ }
81
+
82
+ public function setLastOrderItemId()
83
+ {
84
+ $resource = Mage::getSingleton('core/resource');
85
+ $conn = $resource->getConnection('core_read');
86
+ $results = $conn->query("SHOW TABLE STATUS LIKE '".$resource->getTableName('sales/order_item')."'")->fetchAll();
87
+ foreach($results as $data)
88
+ $this->parent_id_flag = $data['Auto_increment']-1;
89
+ }
90
+
91
+
92
+ //To create order
93
+ public function createOrder($sales_order_arr,$sales_order_item_arr,$store_id)
94
+ {
95
+ $this->store_id = $store_id;
96
+ if(!$this->orderIdStatus($sales_order_arr['increment_id']))
97
+ return 2;
98
+
99
+ $transaction = Mage::getSingleton('core/resource_transaction');
100
+ $order = Mage::getModel('sales/order')
101
+ ->setIncrementId($sales_order_arr['increment_id'])
102
+ ->setStoreId($this->store_id)
103
+ ->setStatus($sales_order_arr['order_status'])
104
+ ->setHoldBeforeState($sales_order_arr['hold_before_state'])
105
+ ->setHoldBeforeStatus($sales_order_arr['hold_before_status'])
106
+ ->setIsVirtual($sales_order_arr['is_virtual'])
107
+ ->setBaseCurrencyCode($sales_order_arr['base_currency_code'])
108
+ ->setStoreCurrencyCode($sales_order_arr['store_currency_code'])
109
+ ->setGlobalCurrencyCode($sales_order_arr['store_currency_code'])
110
+ ->setOrderCurrencyCode($sales_order_arr['order_currency_code']);
111
+
112
+ // Set Customer data
113
+
114
+ $custm_detail = $this->getCustomerInfo($sales_order_arr['customer_email']);
115
+
116
+ if($custm_detail)
117
+ {
118
+ $order->setCustomerEmail($custm_detail['email'])
119
+ ->setCustomerFirstname($custm_detail['firstname'])
120
+ ->setCustomerLastname($custm_detail['lastname'])
121
+ ->setCustomerId($custm_detail['entity_id'])
122
+ ->setCustomerGroupId($custm_detail['group_id']);
123
+ }
124
+ else
125
+ {
126
+ $order->setCustomerEmail($sales_order_arr['customer_email'])
127
+ ->setCustomerFirstname($sales_order_arr['customer_firstname'])
128
+ ->setCustomerLastname($sales_order_arr['customer_lasttname'])
129
+ ->setCustomerIsGuest(1)
130
+ ->setCustomerGroupId(0);
131
+ }
132
+
133
+
134
+ // Set Billing Address
135
+ $billingAddress = Mage::getModel('sales/order_address')
136
+ ->setStoreId($this->store_id)
137
+ ->setAddressType(Mage_Sales_Model_Quote_Address::TYPE_BILLING)
138
+ ->setCustomerAddressId($sales_order_arr['billing_address']['customer_address_id'])
139
+ ->setPrefix($sales_order_arr['billing_address']['prefix'])
140
+ ->setFirstname($sales_order_arr['billing_address']['firstname'])
141
+ ->setMiddlename($sales_order_arr['billing_address']['middlename'])
142
+ ->setLastname($sales_order_arr['billing_address']['lastname'])
143
+ ->setSuffix($sales_order_arr['billing_address']['suffix'])
144
+ ->setCompany($sales_order_arr['billing_address']['company'])
145
+ ->setStreet($sales_order_arr['billing_address']['street'])
146
+ ->setCity($sales_order_arr['billing_address']['city'])
147
+ ->setCountryId($sales_order_arr['billing_address']['country_id'])
148
+ ->setRegion($sales_order_arr['billing_address']['region'])
149
+ ->setPostcode($sales_order_arr['billing_address']['postcode'])
150
+ ->setTelephone($sales_order_arr['billing_address']['telephone'])
151
+ ->setFax($sales_order_arr['billing_address']['fax']);
152
+ $order->setBillingAddress($billingAddress);
153
+
154
+ // Set Shipping Address
155
+ $shippingAddress = Mage::getModel('sales/order_address')
156
+ ->setStoreId($this->store_id)
157
+ ->setAddressType(Mage_Sales_Model_Quote_Address::TYPE_SHIPPING)
158
+ ->setCustomerAddressId($sales_order_arr['shipping_address']['customer_address_id'])
159
+ ->setPrefix($sales_order_arr['shipping_address']['prefix'])
160
+ ->setFirstname($sales_order_arr['shipping_address']['firstname'])
161
+ ->setMiddlename($sales_order_arr['shipping_address']['middlename'])
162
+ ->setLastname($sales_order_arr['shipping_address']['lastname'])
163
+ ->setSuffix($sales_order_arr['shipping_address']['suffix'])
164
+ ->setCompany($sales_order_arr['shipping_address']['company'])
165
+ ->setStreet($sales_order_arr['shipping_address']['street'])
166
+ ->setCity($sales_order_arr['shipping_address']['city'])
167
+ ->setCountry_id($sales_order_arr['shipping_address']['country_id'])
168
+ ->setRegion($sales_order_arr['shipping_address']['region'])
169
+ ->setPostcode($sales_order_arr['shipping_address']['postcode'])
170
+ ->setTelephone($sales_order_arr['shipping_address']['telephone'])
171
+ ->setFax($sales_order_arr['shipping_address']['fax']) ;
172
+
173
+ if(!$sales_order_arr['is_virtual']){
174
+ $order->setShippingAddress($shippingAddress)
175
+ ->setShippingMethod($sales_order_arr['shipping_method'])
176
+ ->setShippingDescription($sales_order_arr['shipping_method']);
177
+ }
178
+
179
+ $orderPayment = Mage::getModel('sales/order_payment')
180
+ ->setStoreId($this->store_id)
181
+ ->setCustomerPaymentId(0)
182
+ ->setMethod('checkmo')
183
+ ->setPoNumber(' - ');
184
+ $order->setPayment($orderPayment);
185
+
186
+ $flag = 1;
187
+ foreach($sales_order_item_arr as $product)
188
+ {
189
+ $orderItem = Mage::getModel('sales/order_item')
190
+ ->setStoreId($this->store_id)
191
+ ->setQuoteItemId(0)
192
+ ->setQuoteParentItemId(NULL)
193
+ ->setSku($product['product_sku'])
194
+ ->setProductType($product['product_type'])
195
+ ->setProductOptions(unserialize($product['product_option']))
196
+ ->setQtyBackordered(NULL)
197
+ ->setTotalQtyOrdered($product['qty_ordered'])
198
+ ->setQtyOrdered($product['qty_ordered'])
199
+ ->setName($product['product_name'])
200
+ ->setPrice($product['original_price'])
201
+ ->setBasePrice($product['base_original_price'])
202
+ ->setOriginalPrice($product['original_price'])
203
+ ->setBaseOriginalPrice($product['base_original_price'])
204
+ ->setRowWeight($product['row_weight'])
205
+ ->setPriceInclTax($product['price_incl_tax'])
206
+ ->setBasePriceInclTax($product['base_price_incl_tax'])
207
+ ->setTaxAmount($product['product_tax_amount'])
208
+ ->setBaseTaxAmount($product['product_base_tax_amount'])
209
+ ->setTaxPercent($product['product_tax_percent'])
210
+ ->setDiscountAmount($product['product_discount'])
211
+ ->setBaseDiscountAmount($product['product_base_discount'])
212
+ ->setDiscountPercent($product['product_discount_percent'])
213
+ ->setRowTotal($product['row_total'])
214
+ ->setBaseRowTotal($product['base_row_total']);
215
+
216
+ if($product['is_child']=='yes')
217
+ $orderItem->setParentItemId($this->parent_id);
218
+
219
+ else if($product['is_child']=='no')
220
+ $this->parent_id = $this->parent_id_flag+$flag;
221
+
222
+ $order->addItem($orderItem);
223
+
224
+ $flag++;
225
+ }
226
+
227
+
228
+ $order->setShippingAmount($sales_order_arr['shipping_amount']);
229
+ $order->setBaseShippingAmount($sales_order_arr['base_shipping_amount']);
230
+
231
+ //Apply Discount
232
+ $order->setBaseDiscountAmount($sales_order_arr['base_discount_amount']);
233
+ $order->setDiscountAmount($sales_order_arr['discount_amount']);
234
+
235
+ //Apply Tax
236
+ $order->setBaseTaxAmount($sales_order_arr['base_tax_amount']);
237
+ $order->setTaxAmount($sales_order_arr['tax_amount']);
238
+
239
+ $order->setSubtotal($sales_order_arr['subtotal'])
240
+ ->setBaseSubtotal($sales_order_arr['base_subtotal'])
241
+ ->setGrandTotal($sales_order_arr['grand_total'])
242
+ ->setBaseGrandTotal($sales_order_arr['base_grand_total'])
243
+ ->setShippingTaxAmount($sales_order_arr['shipping_tax_amount'])
244
+ ->setBaseShippingTaxAmount($sales_order_arr['base_shipping_tax_amount'])
245
+ ->setBaseToGlobalRate($sales_order_arr['base_to_global_rate'])
246
+ ->setBaseToOrderRate($sales_order_arr['base_to_order_rate'])
247
+ ->setStoreToBaseRate($sales_order_arr['store_to_base_rate'])
248
+ ->setStoreToOrderRate($sales_order_arr['store_to_order_rate'])
249
+ ->setSubtotalInclTax($sales_order_arr['subtotal_incl_tax'])
250
+ ->setBaseSubtotalInclTax($sales_order_arr['base_subtotal_incl_tax'])
251
+ ->setCouponCode($sales_order_arr['coupon_code'])
252
+ ->setDiscountDescription($sales_order_arr['coupon_code'])
253
+ ->setShippingInclTax($sales_order_arr['shipping_incl_tax'])
254
+ ->setBaseShippingInclTax($sales_order_arr['base_shipping_incl_tax'])
255
+ ->setTotalQtyOrdered($sales_order_arr['total_qty_ordered'])
256
+ ->setRemoteIp($sales_order_arr['remote_ip']);
257
+
258
+ $transaction->addObject($order);
259
+ $transaction->addCommitCallback(array($order, 'place'));
260
+ $transaction->addCommitCallback(array($order, 'save'));
261
+
262
+ if($transaction->save())
263
+ {
264
+ $this->setLastOrderItemId();
265
+ $last_order_increment_id = Mage::getSingleton("sales/order")->getCollection()->getLastItem()->getIncrementId();
266
+
267
+ $this->setGlobalData($last_order_increment_id,$sales_order_item_arr,$sales_order_arr);
268
+
269
+ if($sales_order_arr['order_state']=='processing' || $sales_order_arr['order_state']=='complete')
270
+ return $this->setProcessing();
271
+
272
+ if($sales_order_arr['order_state']=='canceled')
273
+ return $this->setCanceled();
274
+
275
+ if($sales_order_arr['order_state']=='closed')
276
+ return $this->setClosed();
277
+
278
+ if($sales_order_arr['order_state']=='holded')
279
+ return $this->setHolded();
280
+
281
+ if($sales_order_arr['order_state']=='payment_review')
282
+ return $this->setPaymentReview();
283
+
284
+ return 1;
285
+ }
286
+ else
287
+ return 3;
288
+
289
+ }
290
+
291
+
292
+ public function setProcessing()
293
+ {
294
+ if($this->partial_invoiced)
295
+ $resp = $this->getInvoiceObj()->createInvoice($this->last_order_increment_id,$this->invoiced_item,$this->invoice_created_at);
296
+
297
+ if($this->partial_shipped)
298
+ $resp = $this->getShipmentObj()->createShipment($this->last_order_increment_id,$this->shipped_item,$this->shipment_created_at);
299
+
300
+ if($this->partial_credited)
301
+ $resp = $this->getCreditmemoObj()->createCreditMemo($this->last_order_increment_id,$this->credit_item,$this->order_detai_arr);
302
+
303
+ $this->unsetAllData();
304
+ return 1;
305
+ }
306
+
307
+ public function setHolded()
308
+ {
309
+ try
310
+ {
311
+ if($this->setProcessing()== 1)
312
+ {
313
+ $order = $this->getOrderModel($this->last_order_increment_id);
314
+ $order->setState(Mage_Sales_Model_Order::STATE_HOLDED, true)->save();
315
+ $order->unsetData();
316
+ return 1;
317
+ }
318
+ } catch (Exception $e) {
319
+ Mage::helper('imports')->logException($e,$order->getIncrementId(),'order');
320
+ Mage::helper('imports')->footer();return 1;
321
+ }
322
+ }
323
+
324
+ public function setPaymentReview()
325
+ {
326
+ try
327
+ {
328
+ if($this->setProcessing()== 1)
329
+ {
330
+ $order = $this->getOrderModel($this->last_order_increment_id);
331
+ $order->setState(Mage_Sales_Model_Order::STATE_PAYMENT_REVIEW, true)->save();
332
+ $order->unsetData();
333
+ return 1;
334
+ }
335
+ } catch (Exception $e) {
336
+ Mage::helper('imports')->logException($e,$order->getIncrementId(),'order');
337
+ Mage::helper('imports')->footer();return 1;
338
+ }
339
+ }
340
+
341
+
342
+ public function setCanceled()
343
+ {
344
+ try
345
+ {
346
+ if($this->setProcessing()== 1)
347
+ {
348
+ $this->updateCanceledQTY();
349
+ $order = $this->getOrderModel($this->last_order_increment_id);
350
+ $order->setState(Mage_Sales_Model_Order::STATE_CANCELED, true)->save();
351
+ $order->unsetData();
352
+ return 1;
353
+ }
354
+ } catch (Exception $e) {
355
+ Mage::helper('imports')->logException($e,$order->getIncrementId(),'order');
356
+ Mage::helper('imports')->footer();return 1;
357
+ }
358
+ }
359
+
360
+ public function setClosed()
361
+ {
362
+ try
363
+ {
364
+ if($this->setProcessing()== 1)
365
+ {
366
+ $order = $this->getOrderModel($this->last_order_increment_id);
367
+ $order->setStatus(Mage_Sales_Model_Order::STATE_CLOSED, true)->save();
368
+ $order->unsetData();
369
+ return 1;
370
+ }
371
+ } catch (Exception $e) {
372
+ Mage::helper('imports')->logException($e,$order->getIncrementId(),'order');
373
+ Mage::helper('imports')->footer();return 1;
374
+ }
375
+ }
376
+
377
+
378
+ public function updateCanceledQTY()
379
+ {
380
+ $items = $this->canceled_item;
381
+ foreach($items as $itemid => $itemqty)
382
+ {
383
+ $orderItem = Mage::getModel('sales/order_item')->load($itemid);
384
+ $orderItem->setQtyCanceled($itemqty)->save();
385
+ $orderItem->unsetData();
386
+ }
387
+ }
388
+
389
+ public function getOrderModel($last_order_increment_id)
390
+ {
391
+ $order = Mage::getModel('sales/order')->loadByIncrementId($last_order_increment_id);
392
+ return $order;
393
+ }
394
+
395
+ public function orderIdStatus($last_order_increment_id)
396
+ {
397
+ $order = Mage::getModel('sales/order')->loadByIncrementId($last_order_increment_id);
398
+ if($order->getId())
399
+ return false;
400
+ else
401
+ return true;
402
+ }
403
+
404
+ public function unsetAllData()
405
+ {
406
+ $this->shipped_item = array() ;
407
+ $this->invoiced_item = array() ;
408
+ $this->credit_item = array() ;
409
+ $this->canceled_item = array() ;
410
+ $this->partial_shipped = false;
411
+ $this->partial_credited = false;
412
+ $this->partial_invoiced = false;
413
+ $this->order_detai_arr = false;
414
+ }
415
+
416
+ public function getInvoiceObj()
417
+ {
418
+ return Mage::getModel('imports/functional_invoice');
419
+ }
420
+
421
+ public function getShipmentObj()
422
+ {
423
+ return Mage::getModel('imports/functional_shipment');
424
+ }
425
+
426
+ public function getCreditmemoObj()
427
+ {
428
+ return Mage::getModel('imports/functional_creditmemo');
429
+ }
430
+
431
+ public function getCustomerInfo($email)
432
+ {
433
+ $customer = Mage::getModel("customer/customer");
434
+ $customer->setWebsiteId(Mage::getModel('core/store')->load($this->store_id)->getWebsiteId());
435
+ if($customer->loadByEmail($email))
436
+ return $customer->getData();
437
+ else
438
+ return false;
439
+ }
440
+
441
+ public function removeOrderStatusHistory()
442
+ {
443
+ $coll = Mage::getModel('sales/order_status_history')->getCollection()->addFieldToFilter('parent_id',Mage::getSingleton("sales/order")->getCollection()->getLastItem()->getId());
444
+ foreach($coll as $history)
445
+ Mage::getModel('sales/order_status_history')->load($history->getId())->delete()->save()->unsetData();
446
+ }
447
+ }
app/code/community/Ds/Imports/Model/Functional/Creditmemo.php ADDED
@@ -0,0 +1,86 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Model_Functional_Creditmemo extends Mage_Core_Model_Abstract
4
+ {
5
+ public function createCreditMemo($order_id,$credit_item,$creditDetail)
6
+ {
7
+ $order = $this->getOrderModel($order_id);
8
+ try{
9
+ $data = array('qtys' => $credit_item ,'shipping_amount'=>$creditDetail['refunded_shipping_amount'],
10
+ 'adjustment_positive'=>$creditDetail['adjustment_positive'],'adjustment_negative'=>$creditDetail['adjustment_negative']);
11
+ if(Mage::helper('ds_import')->getVersion())
12
+ {
13
+ $service = Mage::getModel('sales/service_order', $order);
14
+ $creditMemo = $service->prepareCreditmemo($data);
15
+ $creditMemo = $creditMemo->setState(2)->save();
16
+ $this->updateStatus($order_id,$creditDetail);
17
+ }
18
+ else
19
+ {
20
+ $creditMemo = Mage::getModel('sales/order_creditmemo_api')
21
+ ->create($order_id, $data ,null ,0,0);
22
+ }
23
+
24
+ $model = Mage::getSingleton("sales/order_creditmemo");
25
+ $credit_id = $model->getCollection()->getLastItem()->getId();
26
+ $model->load($credit_id)
27
+ ->setCreatedAt($creditDetail['creditmemo_created_at'])
28
+ ->setUpdatedAt($creditDetail['creditmemo_created_at'])
29
+ ->save()
30
+ ->unsetData();
31
+
32
+ $this->updateCreditQTY($credit_item);
33
+
34
+ }catch (Exception $e) {
35
+
36
+ Mage::helper('imports')->logException($e,$order->getIncrementId(),'creditmemo');
37
+ Mage::helper('imports')->footer();
38
+ return true;
39
+ }
40
+ $order->unsetData();
41
+ return true;
42
+ }
43
+
44
+
45
+
46
+ public function updateCreditQTY($credit_item)
47
+ {
48
+ foreach($credit_item as $itemid => $itemqty)
49
+ {
50
+ $orderItem = Mage::getModel('sales/order_item')->load($itemid);
51
+ $orderItem->setQtyRefunded($itemqty)->save();
52
+ $orderItem->unsetData();
53
+ }
54
+ }
55
+
56
+ public function updateStatus($order_id,$refunded)
57
+ {
58
+ $order = $this->getOrderModel($order_id);
59
+
60
+ //set creditmemo data
61
+ $order->setSubtotalRefunded($refunded['refunded_subtotal'])
62
+ ->setBaseSubtotalRefunded($refunded['refunded_subtotal'])
63
+ ->setTaxRefunded($refunded['refunded_tax_amount'])
64
+ ->setBaseTaxRefunded($refunded['base_refunded_tax_amount'])
65
+ ->setDiscountRefunded($refunded['refunded_discount_amount'])
66
+ ->setBaseDiscountRefunded($refunded['base_refunded_discount_amount'])
67
+ ->setShippingRefunded($refunded['refunded_shipping_amount'])
68
+ ->setBaseShippingRefunded($refunded['base_refunded_shipping_amount'])
69
+ ->setTotalRefunded($refunded['total_refunded'])
70
+ ->setBaseTotalRefunded($refunded['base_total_refunded'])
71
+ ->setTotalOfflineRefunded($refunded['total_refunded'])
72
+ ->setBaseTotalOfflineRefunded($refunded['base_total_refunded'])
73
+ ->setAdjustmentNegative($refunded['adjustment_positive'])
74
+ ->setBaseAdjustmentNegative($refunded['adjustment_positive'])
75
+ ->setAdjustmentPositive($refunded['adjustment_negative'])
76
+ ->setBaseAdjustmentPositive($refunded['adjustment_negative'])
77
+ ->save();
78
+ $order->unsetData();
79
+ }
80
+
81
+ public function getOrderModel($last_order_increment_id)
82
+ {
83
+ $order = Mage::getModel('sales/order')->loadByIncrementId($last_order_increment_id);
84
+ return $order;
85
+ }
86
+ }
app/code/community/Ds/Imports/Model/Functional/Export.php ADDED
@@ -0,0 +1,136 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Model_Functional_Export extends Mage_Core_Model_Abstract
4
+ {
5
+ public function getPaymentMethod($order)
6
+ {
7
+ return $order->getPayment()->getMethod();
8
+ }
9
+
10
+ public function getChildInfo($item)
11
+ {
12
+
13
+ if($item->getParentItemId())
14
+ return 'yes';
15
+ else
16
+ return 'no';
17
+
18
+ }
19
+
20
+ public function getShippingMethod($order)
21
+ {
22
+ if (!$order->getIsVirtual() && $order->getShippingDescription()) {
23
+ return $order->getShippingDescription();
24
+ }
25
+ else if (!$order->getIsVirtual() && $order->getShippingMethod()) {
26
+ return $order->getShippingMethod();
27
+ }
28
+ return '';
29
+ }
30
+
31
+ public function getItemSku($item)
32
+ {
33
+ if ($item->getProductType() == Mage_Catalog_Model_Product_Type::TYPE_CONFIGURABLE) {
34
+ return $item->getProductOptionByCode('simple_sku');
35
+ }
36
+ return $item->getSku();
37
+ }
38
+
39
+ public function formatText($string)
40
+ {
41
+ $string = str_replace(',', ' ', $string);
42
+ return $string;
43
+ }
44
+
45
+ public function getStoreIds()
46
+ {
47
+ $collection = Mage::getModel('core/store')->getCollection();
48
+ $store_ids = array();
49
+ $i = 0;
50
+ foreach($collection as $data)
51
+ {
52
+ $store_ids[$i]['label'] = $data['name'];
53
+ $store_ids[$i]['value'] = $data['store_id'];
54
+ $i++;
55
+ }
56
+ return $store_ids;
57
+ }
58
+
59
+ public function getCreditMemoDetail($order)
60
+ {
61
+ $credit['adjustment_positive'] = 0;
62
+ $credit['adjustment_negative'] = 0;
63
+ $credit['shipping_amount'] = 0;
64
+ $credit['base_shipping_amount'] = 0;
65
+ $credit['subtotal'] = 0;
66
+ $credit['base_subtotal'] = 0;
67
+ $credit['tax_amount'] = 0;
68
+ $credit['base_tax_amount'] = 0;
69
+ $credit['discount_amount'] = 0;
70
+ $credit['base_discount_amount'] = 0;
71
+ $collection = $order->getCreditmemosCollection();
72
+ if(count($collection))
73
+ {
74
+ foreach($collection as $data)
75
+ {
76
+ $credit['adjustment_positive'] += $data->getData('adjustment_positive');
77
+ $credit['adjustment_negative'] += $data->getData('adjustment_negative');
78
+ $credit['shipping_amount'] += $data->getData('shipping_amount');
79
+ $credit['base_shipping_amount'] += $data->getData('base_shipping_amount');
80
+ $credit['subtotal'] += $data->getData('subtotal');
81
+ $credit['base_subtotal'] += $data->getData('base_subtotal');
82
+ $credit['tax_amount'] += $data->getData('tax_amount');
83
+ $credit['base_tax_amount'] += $data->getData('base_tax_amount');
84
+ $credit['discount_amount'] += $data->getData('discount_amount');
85
+ $credit['base_discount_amount'] += $data->getData('base_discount_amount');
86
+ }
87
+ }
88
+
89
+ return $credit;
90
+
91
+ }
92
+
93
+ public function getInvoiceDate($order)
94
+ {
95
+ $date = '';
96
+ $collection = $order->getInvoiceCollection();
97
+ if(count($collection))
98
+ {
99
+ foreach($collection as $data)
100
+ $date = $data->getData('created_at');
101
+ }
102
+
103
+ return $date;
104
+
105
+ }
106
+
107
+ public function getShipmentDate($order)
108
+ {
109
+ $date = '';
110
+ $collection = $order->getShipmentsCollection();
111
+ if(count($collection))
112
+ {
113
+ foreach($collection as $data)
114
+ $date = $data->getData('created_at');
115
+ }
116
+
117
+ return $date;
118
+
119
+ }
120
+
121
+ public function getCreditmemoDate($order)
122
+ {
123
+ $date = '';
124
+ $collection = $order->getCreditmemosCollection();
125
+ if(count($collection))
126
+ {
127
+ foreach($collection as $data)
128
+ $date = $data->getData('created_at');
129
+ }
130
+
131
+ return $date;
132
+
133
+ }
134
+
135
+
136
+ }
app/code/community/Ds/Imports/Model/Functional/Invoice.php ADDED
@@ -0,0 +1,48 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Model_Functional_Invoice extends Mage_Core_Model_Abstract
4
+ {
5
+ public function createInvoice($order_id,$invoice_item,$date)
6
+ {
7
+ $order = $this->getOrderModel($order_id);
8
+ try{
9
+ if($order->canInvoice())
10
+ {
11
+ $invoiceId = Mage::getModel('sales/order_invoice_api')
12
+ ->create($order->getIncrementId(), $invoice_item ,null ,0,0);
13
+
14
+ if($invoiceId)
15
+ {
16
+ Mage::getSingleton("sales/order_invoice")->loadByIncrementId($invoiceId)
17
+ ->setCreatedAt($date)
18
+ ->setUpdatedAt($date)
19
+ ->save()
20
+ ->unsetData();
21
+ $this->updateInvoiceQTY($invoice_item);
22
+ }
23
+ }
24
+ } catch (Exception $e) {
25
+ Mage::helper('imports')->logException($e,$order->getIncrementId(),'invoice');
26
+ Mage::helper('imports')->footer();
27
+ return true;
28
+ }
29
+ $order->unsetData();
30
+ return $invoiceId;
31
+ }
32
+
33
+ public function updateInvoiceQTY($invoice_item)
34
+ {
35
+ foreach($invoice_item as $itemid => $itemqty)
36
+ {
37
+ $orderItem = Mage::getModel('sales/order_item')->load($itemid);
38
+ $orderItem->setQtyInvoiced($itemqty)->save();
39
+ $orderItem->unsetData();
40
+ }
41
+ }
42
+
43
+ public function getOrderModel($last_order_increment_id)
44
+ {
45
+ $order = Mage::getModel('sales/order')->loadByIncrementId($last_order_increment_id);
46
+ return $order;
47
+ }
48
+ }
app/code/community/Ds/Imports/Model/Functional/Shipment.php ADDED
@@ -0,0 +1,50 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Model_Functional_Shipment extends Mage_Core_Model_Abstract
4
+ {
5
+
6
+ public function createShipment($order_id,$shipped_item,$date)
7
+ {
8
+ $order = $this->getOrderModel($order_id);
9
+ try
10
+ {
11
+ if($order->canShip())
12
+ {
13
+ $shipId = Mage::getModel('sales/order_shipment_api')
14
+ ->create($order_id, $shipped_item ,null ,0,0);
15
+
16
+ if($shipId)
17
+ {
18
+ Mage::getSingleton("sales/order_shipment")->loadByIncrementId($shipId)
19
+ ->setCreatedAt($date)
20
+ ->setUpdatedAt($date)
21
+ ->save()
22
+ ->unsetData();
23
+ $this->updateShipmentQTY($shipped_item);
24
+ }
25
+ }
26
+ } catch (Exception $e) {
27
+ Mage::helper('imports')->logException($e,$order->getIncrementId(),'shipment');
28
+ Mage::helper('imports')->footer();
29
+ return true;
30
+ }
31
+ $order->unsetData();
32
+ return $shipment;
33
+ }
34
+
35
+ public function updateShipmentQTY($shipped_item)
36
+ {
37
+ foreach($shipped_item as $itemid => $itemqty)
38
+ {
39
+ $orderItem = Mage::getModel('sales/order_item')->load($itemid);
40
+ $orderItem->setQtyShipped($itemqty)->save();
41
+ $orderItem->unsetData();
42
+ }
43
+ }
44
+
45
+ public function getOrderModel($last_order_increment_id)
46
+ {
47
+ $order = Mage::getModel('sales/order')->loadByIncrementId($last_order_increment_id);
48
+ return $order;
49
+ }
50
+ }
app/code/community/Ds/Imports/Model/Importallorders.php ADDED
@@ -0,0 +1,171 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Model_Importallorders extends Mage_Core_Model_Abstract
4
+ {
5
+ public $order_info = array();
6
+ public $order_item_info = array();
7
+ public $order_item_flag = 0;
8
+
9
+ public function readCSV($csvFile,$data)
10
+ {
11
+ $import_limit = $data['import_limit'];
12
+ $store_id = $data['store_id'];
13
+ $file_handle = fopen($csvFile, 'r');
14
+ $i=0;
15
+ $decline = array();
16
+ $available = array();
17
+ $success = 0;
18
+ $parent_flag = 0;
19
+ $invalid = 0;
20
+ $line_number = 2;
21
+ $total_order = 0;
22
+ Mage::helper('imports')->unlinkFile();
23
+ Mage::helper('imports')->header();
24
+ feof($file_handle);
25
+ //print_r(feof($file_handle));
26
+ //die("test");
27
+ while (!feof($file_handle) )
28
+ {
29
+ $count[] = fgetcsv($file_handle);
30
+ //print_r($count);
31
+ //die();
32
+ if($i!=0)
33
+ {
34
+ if($count[$i][0]!='' && $parent_flag==0)
35
+ {
36
+ $this->insertOrderData($count[$i]);
37
+ $parent_flag = 1;
38
+ $total_order++;
39
+ }
40
+ else if($count[$i][91]!='' && $parent_flag == 1 && $count[$i][0]=='')
41
+ {
42
+ $this->insertOrderItem($count[$i]);
43
+ }
44
+ else if($parent_flag==1)
45
+ {
46
+ try
47
+ {
48
+ $message = Mage::getModel('imports/createorder')->createOrder($this->order_info,$this->order_item_info,$store_id);
49
+ Mage::getModel('imports/createorder')->removeOrderStatusHistory();
50
+ } catch (Exception $e) {
51
+ Mage::helper('imports')->logException($e,$this->order_info['increment_id'],'order',$line_number);
52
+ Mage::helper('imports')->footer();
53
+ $decline[] = $this->order_info['increment_id'];
54
+ $message = 0;
55
+ }
56
+
57
+ if($message== 1)
58
+ $success++;
59
+
60
+ if($message== 2){
61
+ Mage::helper('imports')->logAvailable($this->order_info['increment_id'],'order',$line_number);
62
+ Mage::helper('imports')->footer();
63
+ $decline[] = $this->order_info['increment_id'];
64
+ }
65
+
66
+ $this->order_info = array();
67
+ $this->order_item_info = array();
68
+ $this->order_item_flag = 0;
69
+
70
+ $this->insertOrderData($count[$i]);
71
+ $parent_flag = 1;
72
+ $line_number = $i+1;
73
+ $total_order++;
74
+ }
75
+
76
+ }
77
+
78
+ $i++;
79
+
80
+ if($import_limit < $total_order)
81
+ break;
82
+ }
83
+ $isPrintable = Mage::helper('imports')->isPrintable();
84
+ if($success)
85
+ Mage::getModel('core/session')->addSuccess(Mage::helper('imports')->__('Total '.$success.' order(s) imported successfully!'));
86
+
87
+ if($decline || $isPrintable)
88
+ Mage::getModel('core/session')->addError(Mage::helper('imports')->__('Click <a href="'.Mage::helper("adminhtml")->getUrl("*/*/error").'">here</a> to view the error log. please give 777 permission file var/ds/log/error.htm then you can access error.' ));
89
+
90
+ fclose($file_handle);
91
+ //print_r($file_handle);
92
+ //die("test");
93
+ return array($success,$decline);
94
+ }
95
+
96
+ public function insertOrderData($orders_data)
97
+ {
98
+ $sales_order_arr = array();
99
+ $sales_order_item_arr = array();
100
+ //$sales_order = $this->getSalesTable();
101
+ $sales_order = Mage::getModel('imports/table_saletable')->getsalestable();
102
+ $sales_shipping = Mage::getModel('imports/table_billingtable')->getbillingtable();
103
+ $sales_billing = Mage::getModel('imports/table_billingtable')->getbillingtable();
104
+ //Mage::getModel('imports/table_saletable');
105
+ $sales_payment = $this->getSalesPayment();
106
+ //$sales_shipping = $this->getSalesBilling();
107
+ //$sales_billing = $this->getSalesBilling();
108
+ $sales_order_item = Mage::getModel('imports/table_saleitems')->getSaleitems();
109
+ $model = Mage::getModel('sales/order');
110
+ $i = 0;
111
+ $j = 0;
112
+ $k = 0;
113
+ $l = 0;
114
+ $m = 0;
115
+ foreach($orders_data as $order)
116
+ {
117
+ if(count($sales_order)>$i)
118
+ $sales_order_arr[$sales_order[$i]]= $order;
119
+
120
+ else if(count($sales_billing)>$j)
121
+ {
122
+ $sales_billing[$j].$sales_order_arr['billing_address'][$sales_billing[$j]]= $order;
123
+ $j++;
124
+ }
125
+ else if(count($sales_shipping)>$k)
126
+ {
127
+ $sales_order_arr['shipping_address'][$sales_shipping[$k]]= $order;
128
+ $k++;
129
+ }
130
+ else if(count($sales_payment)>$l)
131
+ {
132
+ $sales_order_arr['payment'][$sales_payment[$l]]= $order;
133
+ $l++;
134
+ }
135
+ else if(count($sales_order_item)>$m)
136
+ {
137
+ $sales_order_item_arr[$sales_order_item[$m]]= $order;
138
+ $m++;
139
+ }
140
+ $i++;
141
+ }
142
+
143
+ $this->order_info = $sales_order_arr;
144
+ $this->order_item_info[$this->order_item_flag] = $sales_order_item_arr;
145
+ $this->order_item_flag++;
146
+ }
147
+
148
+ public function insertOrderItem($orders_data)
149
+ {
150
+ $sales_order_item_arr = array();
151
+ //$sales_order_item = $this->getSalesItem();
152
+ $sales_order_item = Mage::getModel('imports/table_saleitems')->getSaleitems();
153
+ $i=0;
154
+ for($j=91;$j<count($orders_data); $j++)
155
+ {
156
+ if(count($sales_order_item)>$i)
157
+ $sales_order_item_arr[$sales_order_item[$i]]= $orders_data[$j];
158
+ $i++;
159
+ }
160
+ $this->order_item_info[$this->order_item_flag] = $sales_order_item_arr;
161
+ $this->order_item_flag++;
162
+ }
163
+ public function getSalesPayment()
164
+ {
165
+ return array('method');
166
+ }
167
+
168
+
169
+
170
+
171
+ }
app/code/community/Ds/Imports/Model/Selectorder.php ADDED
@@ -0,0 +1,157 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Model_Selectorder extends Ds_Imports_Model_Functional_Export
4
+ {
5
+ const ENCLOSURE = '"';
6
+ const DELIMITER = ',';
7
+
8
+ public function selectOrders($orders)
9
+ {
10
+ $i = 0;
11
+ $len = count($orders);
12
+ //echo $len;
13
+ foreach ($orders as $item) {
14
+ if ($i == 0) {
15
+ $startid = $item;
16
+ } else if ($i == $len - 1) {
17
+ $lastid = $item;
18
+ }
19
+ $i++;
20
+ }
21
+ if($lastid == 0 || $lastid == null || empty($lastid)){
22
+ $lastid = $startid;
23
+ }
24
+ if($startid > $lastid){
25
+ $lastid1 = $lastid;
26
+ $lastid = $startid;
27
+ $startid = $lastid1;
28
+ }
29
+
30
+ $fileName = 'orderexport_form_orderid_'.$startid.'_to_'.$lastid.'_date_'.date("Ymd_His").'.csv';
31
+ //echo $fileName;
32
+ //die("testing");
33
+ $locatio = Mage::getBaseDir('var').'\ds\ordercsv';
34
+ $fp = fopen($locatio .'/'.$fileName, 'w');
35
+ //$fp = fopen(Mage::getBaseDir('export').'/'.$fileName, 'w');
36
+ $this->writeHeadRow($fp);
37
+ foreach ($orders as $order) {
38
+ $order = Mage::getModel('sales/order')->load($order);
39
+ $this->writeOrder($order, $fp);
40
+ }
41
+
42
+ fclose($fp);
43
+
44
+ return $fileName;
45
+ }
46
+ public function selectOrdersdownload($orders)
47
+ {
48
+ $i = 0;
49
+ $len = count($orders);
50
+ //echo $len;
51
+ foreach ($orders as $item) {
52
+ if ($i == 0) {
53
+ $startid = $item;
54
+ } else if ($i == $len - 1) {
55
+ $lastid = $item;
56
+ }
57
+ $i++;
58
+ }
59
+ if($lastid == 0 || $lastid == null || empty($lastid)){
60
+ $lastid = $startid;
61
+ }
62
+ if($startid > $lastid){
63
+ $lastid1 = $lastid;
64
+ $lastid = $startid;
65
+ $startid = $lastid1;
66
+ }
67
+
68
+ $fileName = 'orderexport_form_orderid_'.$startid.'_to_'.$lastid.'_date_'.date("Ymd_His").'.csv';
69
+ //echo $fileName;
70
+ //die("testing");
71
+ $locatio = Mage::getBaseDir('var').'\ds\ordercsv';
72
+ //$fp = fopen($locatio .'/'.$fileName, 'w');
73
+ $fp = fopen(Mage::getBaseDir('export').'/'.$fileName, 'w');
74
+ $this->writeHeadRow($fp);
75
+ foreach ($orders as $order) {
76
+ $order = Mage::getModel('sales/order')->load($order);
77
+ $this->writeOrder($order, $fp);
78
+ }
79
+
80
+ fclose($fp);
81
+
82
+ return $fileName;
83
+ }
84
+
85
+
86
+ public function writeHeadRow($fp)
87
+ {
88
+ $head = Mage::getModel('imports/table_csvhead')->getCSVHead();
89
+ fputcsv($fp, $head , self::DELIMITER, self::ENCLOSURE);
90
+ }
91
+
92
+
93
+ public function writeOrder($order, $fp)
94
+ {
95
+ $common = Mage::getModel('imports/table_csvcontent')->getCSVvalue($order);
96
+ //$common = $this->getCSVvalue($order);
97
+ $blank = $this->getBlankOrderValues($order);
98
+ $orderItems = $order->getItemsCollection();
99
+ $itemInc = 0;
100
+ $data = array();
101
+ $count = 0;
102
+ foreach ($orderItems as $item)
103
+ {
104
+ if($count==0)
105
+ {
106
+ $record = array_merge($common, $this->getOrderItemValues($item, $order, ++$itemInc));
107
+ fputcsv($fp, $record, self::DELIMITER, self::ENCLOSURE);
108
+ }
109
+ else
110
+ {
111
+ $record = array_merge($blank, $this->getOrderItemValues($item, $order, ++$itemInc));
112
+ fputcsv($fp, $record, self::DELIMITER, self::ENCLOSURE);
113
+ }
114
+ $count++;
115
+ }
116
+
117
+ }
118
+
119
+
120
+ public function getBlankOrderValues($order)
121
+ {
122
+ return array(
123
+ '','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',
124
+ '','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',
125
+ '','','','','','','','','','','','','','','','','','','','','','','','','');
126
+ }
127
+
128
+ //To return the array of ordered items
129
+ public function getOrderItemValues($item, $order, $itemInc=1)
130
+ {
131
+ return array(
132
+ $this->getItemSku($item),
133
+ $this->formatText($item->getName()),
134
+ (int)$item->getQtyOrdered(),
135
+ (int)$item->getQtyInvoiced(),
136
+ (int)$item->getQtyShipped(),
137
+ (int)$item->getQtyRefunded(),
138
+ (int)$item->getQtyCanceled(),
139
+ $item->getProductType(),
140
+ $item->getOriginalPrice(),
141
+ $item->getBaseOriginalPrice(),
142
+ $item->getRowTotal(),
143
+ $item->getBaseRowTotal(),
144
+ $item->getRowWeight(),
145
+ $item->getPriceInclTax(),
146
+ $item->getBasePriceInclTax(),
147
+ $item->getTaxAmount(),
148
+ $item->getBaseTaxAmount(),
149
+ $item->getTaxPercent(),
150
+ $item->getDiscountAmount(),
151
+ $item->getBaseDiscountAmount(),
152
+ $item->getDiscountPercent(),
153
+ $this->getChildInfo($item),
154
+ $item->getdata('product_options')
155
+ );
156
+ }
157
+ }
app/code/community/Ds/Imports/Model/Table/Billingtable.php ADDED
@@ -0,0 +1,27 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php class Ds_Imports_Model_Table_Billingtable extends Mage_Core_Model_Abstract
2
+ {
3
+ //To create order
4
+ public function getbillingtable()
5
+ {
6
+ $table = array();
7
+ $table = array(
8
+ 'customer_address_id',
9
+ 'prefix',
10
+ 'firstname',
11
+ 'middlename',
12
+ 'lastname' ,
13
+ 'suffix',
14
+ 'street',
15
+ 'city',
16
+ 'region',
17
+ 'country_id',
18
+ 'postcode',
19
+ 'telephone' ,
20
+ 'company',
21
+ 'fax'
22
+ );
23
+ return $table;
24
+
25
+ }
26
+
27
+ }
app/code/community/Ds/Imports/Model/Table/Csvcontent.php ADDED
@@ -0,0 +1,109 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Model_Table_Csvcontent extends Ds_Imports_Model_Functional_Export
4
+ {
5
+ public function getCSVvalue($order)
6
+ {
7
+ $content = array();
8
+ $shippingAddress = !$order->getIsVirtual() ? $order->getShippingAddress() : null;
9
+ $billingAddress = $order->getBillingAddress();
10
+ if(!$shippingAddress)
11
+ $shippingAddress = $billingAddress;
12
+ $credit_detail = $this->getCreditMemoDetail($order);
13
+ $content = array(
14
+ $order->getIncrementId(),
15
+ $order->getData('customer_email'),
16
+ $this->formatText($order->getData('customer_firstname')),
17
+ $this->formatText($order->getData('customer_lastname')),
18
+ $this->formatText($order->getData('customer_prefix')),
19
+ $this->formatText($order->getData('customer_middlename')),
20
+ $this->formatText($order->getData('customer_suffix')),
21
+ $order->getData('customer_taxvat'),
22
+ $order->getData('created_at'),
23
+ $order->getData('updated_at'),
24
+ $this->getInvoiceDate($order),
25
+ $this->getShipmentDate($order),
26
+ $this->getCreditmemoDate($order),
27
+ $order->getData('tax_amount'),
28
+ $order->getData('base_tax_amount'),
29
+ $order->getData('discount_amount'),
30
+ $order->getData('base_discount_amount'),
31
+ $order->getData('shipping_tax_amount'),
32
+ $order->getData('base_shipping_tax_amount'),
33
+ $order->getData('base_to_global_rate'),
34
+ $order->getData('base_to_order_rate'),
35
+ $order->getData('store_to_base_rate'),
36
+ $order->getData('store_to_order_rate'),
37
+ $order->getData('subtotal_incl_tax'),
38
+ $order->getData('base_subtotal_incl_tax'),
39
+ $order->getData('coupon_code'),
40
+ $order->getData('shipping_incl_tax'),
41
+ $order->getData('base_shipping_incl_tax'),
42
+ $this->getShippingMethod($order),
43
+ $order->getData('shipping_amount'),
44
+ $order->getData('subtotal'),
45
+ $order->getData('base_subtotal'),
46
+ $order->getData('grand_total'),
47
+ $order->getData('base_grand_total'),
48
+ $order->getData('base_shipping_amount'),
49
+ $credit_detail['adjustment_positive'],
50
+ $credit_detail['adjustment_negative'],
51
+ $credit_detail['shipping_amount'],
52
+ $credit_detail['base_shipping_amount'],
53
+ $credit_detail['subtotal'],
54
+ $credit_detail['base_subtotal'],
55
+ $credit_detail['tax_amount'],
56
+ $credit_detail['base_tax_amount'],
57
+ $credit_detail['discount_amount'],
58
+ $credit_detail['base_discount_amount'],
59
+ $order->getData('store_id'),
60
+ $order->getStatus(),
61
+ $order->getState(),
62
+ $order->getHoldBeforeState(),
63
+ $order->getHoldBeforeStatus(),
64
+ $order->getData('store_currency_code'),
65
+ $order->getData('base_currency_code'),
66
+ $order->getData('order_currency_code'),
67
+ $order->getData('total_paid'),
68
+ $order->getData('base_total_paid'),
69
+ $order->getData('is_virtual'),
70
+ $order->getData('total_qty_ordered'),
71
+ $order->getData('remote_ip'),
72
+ $order->getData('total_refunded'),
73
+ $order->getData('base_total_refunded'),
74
+ $order->getData('total_canceled'),
75
+ $order->getData('total_invoiced'),
76
+ $order->getData('customer_id'),
77
+ $this->formatText($order->getBillingAddress()->getData('prefix')),
78
+ $this->formatText($order->getBillingAddress()->getData('firstname')),
79
+ $this->formatText($order->getBillingAddress()->getData('middlename')),
80
+ $this->formatText($order->getBillingAddress()->getData('lastname')),
81
+ $this->formatText($order->getBillingAddress()->getData('suffix')),
82
+ $this->formatText($order->getBillingAddress()->getData('street')),
83
+ $this->formatText($order->getBillingAddress()->getData('city')),
84
+ $this->formatText($order->getBillingAddress()->getData('region')),
85
+ $this->formatText($order->getBillingAddress()->getData('country_id')),
86
+ $order->getBillingAddress()->getData('postcode'),
87
+ $order->getBillingAddress()->getData('telephone'),
88
+ $this->formatText($order->getBillingAddress()->getData('company')),
89
+ $order->getBillingAddress()->getData('fax'),
90
+ $order->getData('customer_id'),
91
+ $shippingAddress->getData('prefix'),
92
+ $this->formatText($shippingAddress->getData('firstname')),
93
+ $this->formatText($shippingAddress->getData('middlename')),
94
+ $this->formatText($shippingAddress->getData('lastname')),
95
+ $this->formatText($shippingAddress->getData('suffix')),
96
+ $this->formatText($shippingAddress->getData('street')),
97
+ $this->formatText($shippingAddress->getData('city')),
98
+ $this->formatText($shippingAddress->getData('region')),
99
+ $shippingAddress->getData('country_id'),
100
+ $shippingAddress->getData('postcode'),
101
+ $shippingAddress->getData('telephone'),
102
+ $this->formatText($shippingAddress->getData('company')),
103
+ $shippingAddress->getData('fax'),
104
+ $this->getPaymentMethod($order)
105
+ );
106
+ return $content;
107
+ }
108
+
109
+ }
app/code/community/Ds/Imports/Model/Table/Csvhead.php ADDED
@@ -0,0 +1,128 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Model_Table_Csvhead extends Mage_Core_Model_Abstract
4
+ {
5
+ public function getCSVHead()
6
+ {
7
+ $head = array();
8
+ $head = array(
9
+ "order_id",
10
+ "email",
11
+ "firstname",
12
+ "lastname",
13
+ "prefix",
14
+ "middlename",
15
+ "suffix",
16
+ "taxvat",
17
+ "created_at",
18
+ "updated_at",
19
+ "invoice_created_at",
20
+ "shipment_created_at",
21
+ "creditmemo_created_at",
22
+ "tax_amount",
23
+ "base_tax_amount",
24
+ "discount_amount",
25
+ "base_discount_amount",
26
+ "shipping_tax_amount",
27
+ "base_shipping_tax_amount",
28
+ "base_to_global_rate",
29
+ "base_to_order_rate",
30
+ "store_to_base_rate",
31
+ "store_to_order_rate",
32
+ "subtotal_incl_tax",
33
+ "base_subtotal_incl_tax",
34
+ "coupon_code",
35
+ "shipping_incl_tax",
36
+ "base_shipping_incl_tax",
37
+ "shipping_method",
38
+ "shipping_amount",
39
+ "subtotal",
40
+ "base_subtotal",
41
+ "grand_total",
42
+ "base_grand_total",
43
+ "base_shipping_amount",
44
+ "adjustment_positive",
45
+ "adjustment_negative",
46
+ "refunded_shipping_amount",
47
+ "base_refunded_shipping_amount",
48
+ "refunded_subtotal",
49
+ "base_refunded_subtotal",
50
+ "refunded_tax_amount",
51
+ "base_refunded_tax_amount",
52
+ "refunded_discount_amount",
53
+ "base_refunded_discount_amount",
54
+ "store_id",
55
+ "order_status",
56
+ "order_state",
57
+ "hold_before_state",
58
+ "hold_before_status",
59
+ "store_currency_code",
60
+ "base_currency_code",
61
+ "order_currency_code",
62
+ "total_paid",
63
+ "base_total_paid",
64
+ "is_virtual",
65
+ "total_qty_ordered",
66
+ "remote_ip",
67
+ "total_refunded",
68
+ "base_total_refunded",
69
+ "total_canceled",
70
+ "total_invoiced",
71
+ "customer_id",
72
+ "billing_prefix",
73
+ "billing_firstname",
74
+ "billing_middlename",
75
+ "billing_lastname",
76
+ "billing_suffix",
77
+ "billing_street_full",
78
+ "billing_city",
79
+ "billing_region",
80
+ "billing_country",
81
+ "billing_postcode",
82
+ "billing_telephone",
83
+ "billing_company",
84
+ "billing_fax",
85
+ "customer_id",
86
+ "shipping_prefix",
87
+ "shipping_firstname",
88
+ "shipping_middlename",
89
+ "shipping_lastname",
90
+ "shipping_suffix",
91
+ "shipping_street_full",
92
+ "shipping_city",
93
+ "shipping_region",
94
+ "shipping_country",
95
+ "shipping_postcode",
96
+ "shipping_telephone",
97
+ "shipping_company",
98
+ "shipping_fax",
99
+ "payment_method",
100
+ "product_sku",
101
+ "product_name",
102
+ "qty_ordered",
103
+ "qty_invoiced",
104
+ "qty_shipped",
105
+ "qty_refunded",
106
+ "qty_canceled",
107
+ "product_type",
108
+ "original_price",
109
+ "base_original_price",
110
+ "row_total",
111
+ "base_row_total",
112
+ "row_weight",
113
+ "price_incl_tax",
114
+ "base_price_incl_tax",
115
+ "product_tax_amount",
116
+ "product_base_tax_amount",
117
+ "product_tax_percent",
118
+ "product_discount",
119
+ "product_base_discount",
120
+ "product_discount_percent",
121
+ "is_child",
122
+ "product_option"
123
+
124
+ );
125
+ return $head;
126
+ }
127
+
128
+ }
app/code/community/Ds/Imports/Model/Table/Saleitems.php ADDED
@@ -0,0 +1,37 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php class Ds_Imports_Model_Table_Saleitems extends Mage_Core_Model_Abstract
2
+ {
3
+ //To create order
4
+ public function getSaleitems()
5
+ {
6
+ $sale = array();
7
+ $sale = array
8
+ (
9
+ 'product_sku',
10
+ 'product_name',
11
+ 'qty_ordered',
12
+ 'qty_invoiced',
13
+ 'qty_shipped',
14
+ 'qty_refunded',
15
+ 'qty_canceled',
16
+ 'product_type',
17
+ 'original_price',
18
+ 'base_original_price',
19
+ 'row_total',
20
+ 'base_row_total',
21
+ 'row_weight',
22
+ 'price_incl_tax',
23
+ 'base_price_incl_tax',
24
+ 'product_tax_amount',
25
+ 'product_base_tax_amount',
26
+ 'product_tax_percent',
27
+ 'product_discount',
28
+ 'product_base_discount',
29
+ 'product_discount_percent',
30
+ 'is_child',
31
+ 'product_option'
32
+ );
33
+ return $sale;
34
+
35
+ }
36
+
37
+ }
app/code/community/Ds/Imports/Model/Table/Saletable.php ADDED
@@ -0,0 +1,75 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php class Ds_Imports_Model_Table_Saletable extends Mage_Core_Model_Abstract
2
+ {
3
+ //To create order
4
+ public function getSalesTable()
5
+ {
6
+ $table = array();
7
+ $table = array(
8
+ 'increment_id',
9
+ 'customer_email',
10
+ 'customer_firstname',
11
+ 'customer_lasttname',
12
+ 'customer_prefix',
13
+ 'customer_middlename',
14
+ 'customer_suffix',
15
+ 'taxvat',
16
+ 'created_at',
17
+ 'updated_at',
18
+ 'invoice_created_at',
19
+ 'shipment_created_at',
20
+ 'creditmemo_created_at',
21
+ 'tax_amount',
22
+ 'base_tax_amount',
23
+ 'discount_amount',
24
+ 'base_discount_amount',
25
+ 'shipping_tax_amount',
26
+ 'base_shipping_tax_amount',
27
+ 'base_to_global_rate',
28
+ 'base_to_order_rate',
29
+ 'store_to_base_rate',
30
+ 'store_to_order_rate',
31
+ 'subtotal_incl_tax',
32
+ 'base_subtotal_incl_tax',
33
+ 'coupon_code',
34
+ 'shipping_incl_tax',
35
+ 'base_shipping_incl_tax',
36
+ 'shipping_method',
37
+ 'shipping_amount',
38
+ 'subtotal',
39
+ 'base_subtotal',
40
+ 'grand_total',
41
+ 'base_grand_total',
42
+ 'base_shipping_amount',
43
+ 'adjustment_positive',
44
+ 'adjustment_negative',
45
+ 'refunded_shipping_amount',
46
+ 'base_refunded_shipping_amount',
47
+ 'refunded_subtotal',
48
+ 'base_refunded_subtotal',
49
+ 'refunded_tax_amount',
50
+ 'base_refunded_tax_amount',
51
+ 'refunded_discount_amount',
52
+ 'base_refunded_discount_amount',
53
+ 'store_id',
54
+ 'order_status',
55
+ 'order_state',
56
+ 'hold_before_state',
57
+ 'hold_before_status',
58
+ 'store_currency_code',
59
+ 'base_currency_code',
60
+ 'order_currency_code',
61
+ 'total_paid',
62
+ 'base_total_paid',
63
+ 'is_virtual',
64
+ 'total_qty_ordered',
65
+ 'remote_ip',
66
+ 'total_refunded',
67
+ 'base_total_refunded',
68
+ 'total_canceled',
69
+ 'total_invoiced'
70
+ );
71
+ return $table;
72
+
73
+ }
74
+
75
+ }
app/code/community/Ds/Imports/controllers/Adminhtml/ExportsController.php ADDED
@@ -0,0 +1,59 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Adminhtml_ExportsController extends Mage_Adminhtml_Controller_Action
4
+ {
5
+ public function indexAction()
6
+ {
7
+ $enble = Mage::helper('imports')->getStoreVar();
8
+ if($enble == 1){
9
+ $this->_title($this->__('Orders export'));
10
+ $this->loadLayout();
11
+ $this->_setActiveMenu('sales/sales');
12
+ $this->_addContent($this->getLayout()->createBlock('imports/adminhtml_sales_order_grid'));
13
+ $this->renderLayout();
14
+ }else{
15
+
16
+ $message = $this->__('Please Enble extension System->Configuration->Ds order export/import->enble. Please <a href="'.Mage::helper("adminhtml")->getUrl("*/system_config").'">here</a>');
17
+ //echo '<h1>' . $message . '</h1>';
18
+ Mage::getSingleton('core/session')->addError($message);
19
+ $this->_redirect('*/sales_order');
20
+ }
21
+ }
22
+ public function gridAction()
23
+ {
24
+ $this->loadLayout();
25
+ $this->getResponse()->setBody(
26
+ $this->getLayout()->createBlock('imports/adminhtml_sales_order_grid')->toHtml()
27
+ );
28
+ }
29
+
30
+
31
+ public function selectorderAction()
32
+ {
33
+ $orders = $this->getRequest()->getPost('order_ids', array());
34
+ $file = Mage::getModel('imports/selectorder')->selectOrders($orders);
35
+ $file1 = Mage::getModel('imports/selectorder')->selectOrdersdownload($orders);
36
+ $this->_prepareDownloadResponse($file1, file_get_contents(Mage::getBaseDir('export').'/'.$file1));
37
+ $message = $this->__('Successfully CSV Export in "var/ds/ordercsv" directory.');
38
+ Mage::getSingleton('core/session')->addSuccess($message);
39
+ //$this->_redirect('*/exports');
40
+ }
41
+
42
+ public function exportallorderAction()
43
+ {
44
+ $orders = Mage::getModel('sales/order')->getCollection()->addAttributeToSelect('entity_id');
45
+ $order_arr = array();
46
+ foreach ($orders as $order) {
47
+ $order_arr[] = $order->getId();
48
+ }
49
+ $file = Mage::getModel('imports/allorder')->selectOrders($order_arr);
50
+ $file1 = Mage::getModel('imports/selectorder')->selectOrdersdownload($order_arr);
51
+ $this->_prepareDownloadResponse($file1, file_get_contents(Mage::getBaseDir('export').'/'.$file1));
52
+ $message = $this->__('Successfully CSV Export in "var/ds/ordercsv" directory.');
53
+ Mage::getSingleton('core/session')->addSuccess($message);
54
+ //$this->_redirect('*/exports');
55
+ }
56
+
57
+
58
+
59
+ }
app/code/community/Ds/Imports/controllers/Adminhtml/ImportsController.php ADDED
@@ -0,0 +1,61 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+
3
+ class Ds_Imports_Adminhtml_ImportsController extends Mage_Adminhtml_Controller_Action
4
+ {
5
+ protected function _initAction()
6
+ {
7
+ $this->loadLayout()
8
+ ->_setActiveMenu('imports/items')
9
+ ->_addBreadcrumb(Mage::helper('adminhtml')->__('Orders Import'), Mage::helper('adminhtml')->__('Orders Import'));
10
+
11
+ return $this;
12
+ }
13
+
14
+ public function indexAction()
15
+ {
16
+ $enble = Mage::helper('imports')->getStoreVar();
17
+ if($enble == 1){
18
+ $this->_title($this->__('Orders Import'));
19
+ $this->loadLayout();
20
+ $this->_setActiveMenu('sales/sales');
21
+ $this->_addContent($this->getLayout()->createBlock('imports/adminhtml_sales_order_Form'));
22
+ $this->renderLayout();
23
+ }else{
24
+
25
+ $message = $this->__('Please Enble extension System->Configuration->Ds order export/import->enble. Please <a href="'.Mage::helper("adminhtml")->getUrl("*/system_config").'">here</a>');
26
+ Mage::getSingleton('core/session')->addError($message);
27
+ $this->_redirect('*/sales_order');
28
+ }
29
+ }
30
+
31
+ public function importallOrdersAction()
32
+ {
33
+ if($_FILES['order_csv']['name'] != '') {
34
+ $data = $this->getRequest()->getPost();
35
+ try {
36
+ $uploader = new Varien_File_Uploader('order_csv');
37
+ $uploader->setAllowedExtensions(array('csv'));
38
+ $uploader->setAllowRenameFiles(false);
39
+ $uploader->setFilesDispersion(false);
40
+ $path = Mage::getBaseDir('media') . DS.'ds/ordercsvimport/';
41
+ $uploader->save($path, $_FILES['order_csv']['name'] );
42
+ $csv = Mage::getModel('imports/importallorders')->readCSV($path.$_FILES['order_csv']['name'],$data);
43
+
44
+ } catch (Exception $e) {
45
+ Mage::getModel('core/session')->addError(Mage::helper('imports')->__('Invalid file type!!'));
46
+ }
47
+ $this->_redirect('*/*/');
48
+ }
49
+ else {
50
+ Mage::getSingleton('adminhtml/session')->addError(Mage::helper('imports')->__('Unable to find the import file'));
51
+ $this->_redirect('*/*/');
52
+ }
53
+ }
54
+ public function errorAction()
55
+ {
56
+ $this->_title($this->__('Error'));
57
+ $this->loadLayout();
58
+ $file = 'error.htm';
59
+ $this->_prepareDownloadResponse($file, file_get_contents(Mage::getBaseDir('var') .'/ds/log/'.$file));
60
+ }
61
+ }
app/code/community/Ds/Imports/etc/adminhtml.xml ADDED
@@ -0,0 +1,61 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?xml version="1.0"?>
2
+ <config>
3
+ <menu>
4
+ <sales>
5
+ <children>
6
+ <import module="imports">
7
+ <title>DS Order Import/Export</title>
8
+ <sort_order>20</sort_order>
9
+ <children>
10
+ <export module="imports">
11
+ <title>Export Orders</title>
12
+ <sort_order>1</sort_order>
13
+ <action>*/exports</action>
14
+ </export>
15
+ <import module="imports">
16
+ <title>Import Orders</title>
17
+ <sort_order>2</sort_order>
18
+ <action>*/imports</action>
19
+ </import>
20
+ </children>
21
+ </import>
22
+ </children>
23
+ </sales>
24
+ </menu>
25
+ <acl>
26
+ <resources>
27
+ <all>
28
+ <title>Allow Everything</title>
29
+ </all>
30
+ <admin>
31
+ <children>
32
+ <imports>
33
+ <title>Exporter Module</title>
34
+ <sort_order>10</sort_order>
35
+ <children>
36
+ <!-- <export>
37
+ <title>Export Orders</title>
38
+ </export> -->
39
+ <import>
40
+ <title>Import Orders</title>
41
+ </import>
42
+ </children>
43
+ </imports>
44
+ <system>
45
+ <children>
46
+ <config>
47
+ <children>
48
+ <ds_imports translate="title" module="imports">
49
+ <title>General Setting Section</title>
50
+ <sort_order>0</sort_order>
51
+ </ds_imports>
52
+ </children>
53
+ </config>
54
+ </children>
55
+ </system>
56
+ </children>
57
+ </admin>
58
+ </resources>
59
+ </acl>
60
+
61
+ </config>
app/code/community/Ds/Imports/etc/config.xml ADDED
@@ -0,0 +1,68 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?xml version="1.0"?>
2
+ <config>
3
+ <modules>
4
+ <Ds_Imports>
5
+ <version>1.0.0</version>
6
+ </Ds_Imports>
7
+ </modules>
8
+ <admin>
9
+ <routers>
10
+ <adminhtml>
11
+ <args>
12
+ <modules>
13
+ <ds_imports before="Mage_Adminhtml">Ds_Imports_Adminhtml</ds_imports>
14
+ </modules>
15
+ </args>
16
+ </adminhtml>
17
+ </routers>
18
+ </admin>
19
+ <global>
20
+ <adminhtml>
21
+ <!-- <events>
22
+ <core_block_abstract_prepare_layout_before>
23
+ <observers>
24
+ <imports_core_block_abstract_prepare_layout_before>
25
+ <class>Ds_Imports_Model_Observer</class>
26
+ <method>exportselectedorder</method>
27
+ </imports_core_block_abstract_prepare_layout_before>
28
+ </observers>
29
+ </core_block_abstract_prepare_layout_before>
30
+ </events> -->
31
+ <layout>
32
+ <updates>
33
+ <ds_imports>
34
+ <file>importer.xml</file>
35
+ </ds_imports>
36
+ </updates>
37
+ </layout>
38
+ </adminhtml>
39
+ <helpers>
40
+ <imports>
41
+ <class>Ds_Imports_Helper</class>
42
+ </imports>
43
+ </helpers>
44
+ <blocks>
45
+ <imports>
46
+ <class>Ds_Imports_Block</class>
47
+ </imports>
48
+ <!-- <adminhtml>
49
+ <rewrite>
50
+ <sales_order_grid>Ds_Imports_Block_Adminhtml_Sales_Order_Grid</sales_order_grid>
51
+ </rewrite>
52
+ </adminhtml> -->
53
+ </blocks>
54
+ <models>
55
+ <imports>
56
+ <class>Ds_Imports_Model</class>
57
+ <resourceModel>imports_resource</resourceModel>
58
+ </imports>
59
+ </models>
60
+ <resources>
61
+ <imports_setup>
62
+ <setup>
63
+ <module>Ds_Imports</module>
64
+ </setup>
65
+ </imports_setup>
66
+ </resources>
67
+ </global>
68
+ </config>
app/code/community/Ds/Imports/etc/system.xml ADDED
@@ -0,0 +1,46 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?xml version="1.0" ?>
2
+ <!--
3
+ /**
4
+ * System configuration file
5
+ */
6
+ -->
7
+ <config>
8
+ <tabs>
9
+ <imports translate="label" module="imports">
10
+ <label>Ds Order Export/Import</label>
11
+ <sort_order>11</sort_order>
12
+ </imports>
13
+ </tabs>
14
+ <sections>
15
+ <ds_imports translate="label" module="imports">
16
+ <label>Ds Order Export/Import</label>
17
+ <tab>imports</tab>
18
+ <frontend_type>text</frontend_type>
19
+ <sort_order>0</sort_order>
20
+ <show_in_default>1</show_in_default>
21
+ <show_in_website>1</show_in_website>
22
+ <show_in_store>1</show_in_store>
23
+ <groups>
24
+ <dsimports translate="label">
25
+ <label>Ds Order Export/Import</label>
26
+ <frontend_type>text</frontend_type>
27
+ <sort_order>0</sort_order>
28
+ <show_in_default>1</show_in_default>
29
+ <show_in_website>1</show_in_website>
30
+ <show_in_store>1</show_in_store>
31
+ <fields>
32
+ <enable translate="label">
33
+ <label>Enable</label>
34
+ <frontend_type>select</frontend_type>
35
+ <source_model>adminhtml/system_config_source_yesno</source_model>
36
+ <sort_order>0</sort_order>
37
+ <show_in_default>1</show_in_default>
38
+ <show_in_website>1</show_in_website>
39
+ <show_in_store>1</show_in_store>
40
+ </enable>
41
+ </fields>
42
+ </dsimports>
43
+ </groups>
44
+ </ds_imports>
45
+ </sections>
46
+ </config>
app/etc/modules/Ds_Imports.xml ADDED
@@ -0,0 +1,9 @@
 
 
 
 
 
 
 
 
 
1
+ <?xml version="1.0"?>
2
+ <config>
3
+ <modules>
4
+ <Ds_Imports>
5
+ <active>true</active>
6
+ <codePool>community</codePool>
7
+ </Ds_Imports>
8
+ </modules>
9
+ </config>
package.xml ADDED
@@ -0,0 +1,32 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?xml version="1.0"?>
2
+ <package>
3
+ <name>Ds_Import</name>
4
+ <version>1.0.0</version>
5
+ <stability>stable</stability>
6
+ <license uri="http://opensource.org/licenses/osl-3.0.php">OSL 3.0</license>
7
+ <channel>community</channel>
8
+ <extends/>
9
+ <summary>Magento Extension For order import/export </summary>
10
+ <description>&lt;h3&gt;Detail Description&lt;/h3&gt;&#xD;
11
+ &lt;p&gt;Orders import / export extension, using this extension you can import/export all order data and related customer data like billing/shipping address, email address etc. This works for registered customers or people who made their orders as guest.&#xD;
12
+ &lt;/p&gt;&#xD;
13
+ &lt;h3&gt; Features &lt;/h3&gt;&#xD;
14
+ &lt;ul&gt;&#xD;
15
+ &lt;li&gt; Easy to installation &lt;/li&gt;&#xD;
16
+ &lt;li&gt; Import/Export orders for type (simple/configurable product) using csv. &lt;/li&gt;&#xD;
17
+ &lt;li&gt; Can create Invoices, Shipments at the time of import based on order status. &lt;/li&gt;&#xD;
18
+ &lt;li&gt; Enables Admin to export only selected orders or all orders. &lt;/li&gt; &#xD;
19
+ &lt;li&gt; Provide an error log report for orders which fails to import. &lt;/li&gt;&#xD;
20
+ &lt;li&gt;Exporting orders from older Magento and Importing exact same orders on new version. &lt;/li&gt;&#xD;
21
+ &lt;li&gt;By this module customer can be select no. of order import at a time like (50,100,200) etc. &lt;/li&gt;&#xD;
22
+ &lt;li&gt; Compatible with all browsers.&lt;/li&gt;&#xD;
23
+ &lt;/ul&gt; &#xD;
24
+ </description>
25
+ <notes>stable</notes>
26
+ <authors><author><name>Dotsquares</name><user>dotsquaresltd</user><email>support.extensions@dotsquares.com</email></author></authors>
27
+ <date>2016-04-07</date>
28
+ <time>13:40:40</time>
29
+ <contents><target name="magecommunity"><dir name="Ds"><dir name="Imports"><dir name="Block"><dir name="Adminhtml"><dir name="Sales"><dir name="Order"><file name="Form.php" hash="8f0b3d242cea0bed86afa246aa2dff0c"/><file name="Grid.php" hash="10f557a90360e92d0d3c76c2fa31a2eb"/></dir><file name="Order.php" hash="d29116b51614f397213886d5b2aa2f92"/></dir></dir></dir><dir name="Helper"><file name="Data.php" hash="89d6d6642ddc9be1b66c38c2665620b7"/></dir><dir name="Model"><file name="Allorder.php" hash="b0effae7ae72aacc958263b426e31b57"/><file name="Createorder.php" hash="38246fcf44d3181efaca7984702a0cb3"/><dir name="Functional"><file name="Creditmemo.php" hash="1f999a6be2954b5581caa16eb30a6c71"/><file name="Export.php" hash="f6540d47ff075e2dd3f97e8245b35dd5"/><file name="Invoice.php" hash="22438fa001f8bf61dbdbc14ef6d32eb4"/><file name="Shipment.php" hash="d4bb3f3cf0bf180df04523e3f9c0af33"/></dir><file name="Importallorders.php" hash="e99f213a29cf52fc0305fcb7acdfbde4"/><file name="Selectorder.php" hash="8b363ee545d244e0f63016c5191d89d7"/><dir name="Table"><file name="Billingtable.php" hash="fd2e89e0659aae59d0be93d478e60f7a"/><file name="Csvcontent.php" hash="e4bd8e6654fc6c0130439eda6c1db1c0"/><file name="Csvhead.php" hash="36f6573936de0d0e165ed444edf18ad9"/><file name="Saleitems.php" hash="188b864f2770907e9724015594d7113d"/><file name="Saletable.php" hash="0874175a7b596f107b1ae1de1617efaf"/></dir></dir><dir name="controllers"><dir name="Adminhtml"><file name="ExportsController.php" hash="0a1355d2042421297fefabb69f149472"/><file name="ImportsController.php" hash="c36cead6503d81be1b5856bb0f78b170"/></dir></dir><dir name="etc"><file name="adminhtml.xml" hash="ee094952df00680dec2d9ff2d7b6ae0f"/><file name="config.xml" hash="03cc94848e409144528e94f31092e4fc"/><file name="system.xml" hash="e4d1b443834fd5eb03ec7dae1832d971"/></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Ds_Imports.xml" hash="dda91ba6d6d371079903acecf62a8fb3"/></dir></target><target name="mage"><dir><dir name="var"><dir name="ds"><dir name="log"><file name="error.htm" hash="f859a2dad67f5e256c7d73b5adc06830"/></dir><dir name="ordercsv"><file name="orderexport_form_orderid_15_to_69_date_20160406_134431.csv" hash="198939ca300fcc9c85fa3d6f2e26c568"/><file name="orderexport_form_orderid_15_to_69_date_20160406_134628.csv" hash="198939ca300fcc9c85fa3d6f2e26c568"/><file name="orderexport_form_orderid_1_to_11_date_20160407_090823.csv" hash="1f15b355e3f752a9ede6d2662300e11f"/><file name="orderexport_form_orderid_1_to_1_date_20160407_084241.csv" hash="b47b220d08eaacae3a49127cb2df50f4"/><file name="orderexport_form_orderid_1_to_2_date_20160406_133253.csv" hash="b466acc1d412fc2e870c2b2a236f599c"/><file name="orderexport_form_orderid_1_to_2_date_20160406_133352.csv" hash="b466acc1d412fc2e870c2b2a236f599c"/><file name="orderexport_form_orderid_1_to_8_date_20160407_081033.csv" hash="a0bd6f4716ab3450eedb09aedcd71cdf"/><file name="orderexport_form_orderid_1_to_8_date_20160407_081059.csv" hash="a0bd6f4716ab3450eedb09aedcd71cdf"/><file name="orderexport_form_orderid_3_to_86_date_20160405_130734.csv" hash="933dfd246b3b8f6ef0f35991dc96f3cd"/><file name="orderexport_form_orderid_3_to_86_date_20160406_133855.csv" hash="933dfd246b3b8f6ef0f35991dc96f3cd"/></dir></dir></dir></dir></target></contents>
30
+ <compatible/>
31
+ <dependencies><required><php><min>5.1.0</min><max>6.0.0</max></php></required></dependencies>
32
+ </package>
var/ds/log/error.htm ADDED
@@ -0,0 +1,4 @@
 
 
 
 
1
+ <h3 style="text-align:center;">Error information:</h3><hr /><br /><p><strong>Order Id:</strong> 100000003</p>
2
+ <p><strong>Error Message:</strong> Order id already exist</p>
3
+ <p><strong>Line Number:</strong> 2</p>
4
+ <p><strong>Date:</strong> </p><br /><hr /><br /><br />
var/ds/ordercsv/orderexport_form_orderid_15_to_69_date_20160406_134431.csv ADDED
@@ -0,0 +1,4 @@
 
 
 
 
1
+ order_id,email,firstname,lastname,prefix,middlename,suffix,taxvat,created_at,updated_at,invoice_created_at,shipment_created_at,creditmemo_created_at,tax_amount,base_tax_amount,discount_amount,base_discount_amount,shipping_tax_amount,base_shipping_tax_amount,base_to_global_rate,base_to_order_rate,store_to_base_rate,store_to_order_rate,subtotal_incl_tax,base_subtotal_incl_tax,coupon_code,shipping_incl_tax,base_shipping_incl_tax,shipping_method,shipping_amount,subtotal,base_subtotal,grand_total,base_grand_total,base_shipping_amount,adjustment_positive,adjustment_negative,refunded_shipping_amount,base_refunded_shipping_amount,refunded_subtotal,base_refunded_subtotal,refunded_tax_amount,base_refunded_tax_amount,refunded_discount_amount,base_refunded_discount_amount,store_id,order_status,order_state,hold_before_state,hold_before_status,store_currency_code,base_currency_code,order_currency_code,total_paid,base_total_paid,is_virtual,total_qty_ordered,remote_ip,total_refunded,base_total_refunded,total_canceled,total_invoiced,customer_id,billing_prefix,billing_firstname,billing_middlename,billing_lastname,billing_suffix,billing_street_full,billing_city,billing_region,billing_country,billing_postcode,billing_telephone,billing_company,billing_fax,customer_id,shipping_prefix,shipping_firstname,shipping_middlename,shipping_lastname,shipping_suffix,shipping_street_full,shipping_city,shipping_region,shipping_country,shipping_postcode,shipping_telephone,shipping_company,shipping_fax,payment_method,product_sku,product_name,qty_ordered,qty_invoiced,qty_shipped,qty_refunded,qty_canceled,product_type,original_price,base_original_price,row_total,base_row_total,row_weight,price_incl_tax,base_price_incl_tax,product_tax_amount,product_base_tax_amount,product_tax_percent,product_discount,product_base_discount,product_discount_percent,is_child,product_option
2
+ 100000017,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:13:51",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
3
+ 100000016,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:12:59",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
4
+ 100000014,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:07:07",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
var/ds/ordercsv/orderexport_form_orderid_15_to_69_date_20160406_134628.csv ADDED
@@ -0,0 +1,4 @@
 
 
 
 
1
+ order_id,email,firstname,lastname,prefix,middlename,suffix,taxvat,created_at,updated_at,invoice_created_at,shipment_created_at,creditmemo_created_at,tax_amount,base_tax_amount,discount_amount,base_discount_amount,shipping_tax_amount,base_shipping_tax_amount,base_to_global_rate,base_to_order_rate,store_to_base_rate,store_to_order_rate,subtotal_incl_tax,base_subtotal_incl_tax,coupon_code,shipping_incl_tax,base_shipping_incl_tax,shipping_method,shipping_amount,subtotal,base_subtotal,grand_total,base_grand_total,base_shipping_amount,adjustment_positive,adjustment_negative,refunded_shipping_amount,base_refunded_shipping_amount,refunded_subtotal,base_refunded_subtotal,refunded_tax_amount,base_refunded_tax_amount,refunded_discount_amount,base_refunded_discount_amount,store_id,order_status,order_state,hold_before_state,hold_before_status,store_currency_code,base_currency_code,order_currency_code,total_paid,base_total_paid,is_virtual,total_qty_ordered,remote_ip,total_refunded,base_total_refunded,total_canceled,total_invoiced,customer_id,billing_prefix,billing_firstname,billing_middlename,billing_lastname,billing_suffix,billing_street_full,billing_city,billing_region,billing_country,billing_postcode,billing_telephone,billing_company,billing_fax,customer_id,shipping_prefix,shipping_firstname,shipping_middlename,shipping_lastname,shipping_suffix,shipping_street_full,shipping_city,shipping_region,shipping_country,shipping_postcode,shipping_telephone,shipping_company,shipping_fax,payment_method,product_sku,product_name,qty_ordered,qty_invoiced,qty_shipped,qty_refunded,qty_canceled,product_type,original_price,base_original_price,row_total,base_row_total,row_weight,price_incl_tax,base_price_incl_tax,product_tax_amount,product_base_tax_amount,product_tax_percent,product_discount,product_base_discount,product_discount_percent,is_child,product_option
2
+ 100000017,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:13:51",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
3
+ 100000016,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:12:59",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
4
+ 100000014,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:07:07",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
var/ds/ordercsv/orderexport_form_orderid_1_to_11_date_20160407_090823.csv ADDED
@@ -0,0 +1,6 @@
 
 
 
 
 
 
1
+ order_id,email,firstname,lastname,prefix,middlename,suffix,taxvat,created_at,updated_at,invoice_created_at,shipment_created_at,creditmemo_created_at,tax_amount,base_tax_amount,discount_amount,base_discount_amount,shipping_tax_amount,base_shipping_tax_amount,base_to_global_rate,base_to_order_rate,store_to_base_rate,store_to_order_rate,subtotal_incl_tax,base_subtotal_incl_tax,coupon_code,shipping_incl_tax,base_shipping_incl_tax,shipping_method,shipping_amount,subtotal,base_subtotal,grand_total,base_grand_total,base_shipping_amount,adjustment_positive,adjustment_negative,refunded_shipping_amount,base_refunded_shipping_amount,refunded_subtotal,base_refunded_subtotal,refunded_tax_amount,base_refunded_tax_amount,refunded_discount_amount,base_refunded_discount_amount,store_id,order_status,order_state,hold_before_state,hold_before_status,store_currency_code,base_currency_code,order_currency_code,total_paid,base_total_paid,is_virtual,total_qty_ordered,remote_ip,total_refunded,base_total_refunded,total_canceled,total_invoiced,customer_id,billing_prefix,billing_firstname,billing_middlename,billing_lastname,billing_suffix,billing_street_full,billing_city,billing_region,billing_country,billing_postcode,billing_telephone,billing_company,billing_fax,customer_id,shipping_prefix,shipping_firstname,shipping_middlename,shipping_lastname,shipping_suffix,shipping_street_full,shipping_city,shipping_region,shipping_country,shipping_postcode,shipping_telephone,shipping_company,shipping_fax,payment_method,product_sku,product_name,qty_ordered,qty_invoiced,qty_shipped,qty_refunded,qty_canceled,product_type,original_price,base_original_price,row_total,base_row_total,row_weight,price_incl_tax,base_price_incl_tax,product_tax_amount,product_base_tax_amount,product_tax_percent,product_discount,product_base_discount,product_discount_percent,is_child,product_option
2
+ 100000001,dot@gmail.com,govind,bhatt,,ram,,,"2016-03-30 06:36:01","2016-03-30 06:36:02",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
3
+ 100000010,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:37:51",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
4
+ 100000009,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:18:12","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
5
+ 100000011,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:45:24",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
6
+ 100000012,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:47:01","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
var/ds/ordercsv/orderexport_form_orderid_1_to_1_date_20160407_084241.csv ADDED
@@ -0,0 +1,2 @@
 
 
1
+ order_id,email,firstname,lastname,prefix,middlename,suffix,taxvat,created_at,updated_at,invoice_created_at,shipment_created_at,creditmemo_created_at,tax_amount,base_tax_amount,discount_amount,base_discount_amount,shipping_tax_amount,base_shipping_tax_amount,base_to_global_rate,base_to_order_rate,store_to_base_rate,store_to_order_rate,subtotal_incl_tax,base_subtotal_incl_tax,coupon_code,shipping_incl_tax,base_shipping_incl_tax,shipping_method,shipping_amount,subtotal,base_subtotal,grand_total,base_grand_total,base_shipping_amount,adjustment_positive,adjustment_negative,refunded_shipping_amount,base_refunded_shipping_amount,refunded_subtotal,base_refunded_subtotal,refunded_tax_amount,base_refunded_tax_amount,refunded_discount_amount,base_refunded_discount_amount,store_id,order_status,order_state,hold_before_state,hold_before_status,store_currency_code,base_currency_code,order_currency_code,total_paid,base_total_paid,is_virtual,total_qty_ordered,remote_ip,total_refunded,base_total_refunded,total_canceled,total_invoiced,customer_id,billing_prefix,billing_firstname,billing_middlename,billing_lastname,billing_suffix,billing_street_full,billing_city,billing_region,billing_country,billing_postcode,billing_telephone,billing_company,billing_fax,customer_id,shipping_prefix,shipping_firstname,shipping_middlename,shipping_lastname,shipping_suffix,shipping_street_full,shipping_city,shipping_region,shipping_country,shipping_postcode,shipping_telephone,shipping_company,shipping_fax,payment_method,product_sku,product_name,qty_ordered,qty_invoiced,qty_shipped,qty_refunded,qty_canceled,product_type,original_price,base_original_price,row_total,base_row_total,row_weight,price_incl_tax,base_price_incl_tax,product_tax_amount,product_base_tax_amount,product_tax_percent,product_discount,product_base_discount,product_discount_percent,is_child,product_option
2
+ 100000001,dot@gmail.com,govind,bhatt,,ram,,,"2016-03-30 06:36:01","2016-03-30 06:36:02",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
var/ds/ordercsv/orderexport_form_orderid_1_to_2_date_20160406_133253.csv ADDED
@@ -0,0 +1,3 @@
 
 
 
1
+ order_id,email,firstname,lastname,prefix,middlename,suffix,taxvat,created_at,updated_at,invoice_created_at,shipment_created_at,creditmemo_created_at,tax_amount,base_tax_amount,discount_amount,base_discount_amount,shipping_tax_amount,base_shipping_tax_amount,base_to_global_rate,base_to_order_rate,store_to_base_rate,store_to_order_rate,subtotal_incl_tax,base_subtotal_incl_tax,coupon_code,shipping_incl_tax,base_shipping_incl_tax,shipping_method,shipping_amount,subtotal,base_subtotal,grand_total,base_grand_total,base_shipping_amount,adjustment_positive,adjustment_negative,refunded_shipping_amount,base_refunded_shipping_amount,refunded_subtotal,base_refunded_subtotal,refunded_tax_amount,base_refunded_tax_amount,refunded_discount_amount,base_refunded_discount_amount,store_id,order_status,order_state,hold_before_state,hold_before_status,store_currency_code,base_currency_code,order_currency_code,total_paid,base_total_paid,is_virtual,total_qty_ordered,remote_ip,total_refunded,base_total_refunded,total_canceled,total_invoiced,customer_id,billing_prefix,billing_firstname,billing_middlename,billing_lastname,billing_suffix,billing_street_full,billing_city,billing_region,billing_country,billing_postcode,billing_telephone,billing_company,billing_fax,customer_id,shipping_prefix,shipping_firstname,shipping_middlename,shipping_lastname,shipping_suffix,shipping_street_full,shipping_city,shipping_region,shipping_country,shipping_postcode,shipping_telephone,shipping_company,shipping_fax,payment_method,product_sku,product_name,qty_ordered,qty_invoiced,qty_shipped,qty_refunded,qty_canceled,product_type,original_price,base_original_price,row_total,base_row_total,row_weight,price_incl_tax,base_price_incl_tax,product_tax_amount,product_base_tax_amount,product_tax_percent,product_discount,product_base_discount,product_discount_percent,is_child,product_option
2
+ 100000001,dot@gmail.com,govind,bhatt,,ram,,,"2016-03-30 06:36:01","2016-03-30 06:36:02",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
3
+ 100000002,gfgf@gmail.com,ggf,gfg,,fgf,,,"2016-03-30 08:54:17","2016-04-01 12:16:08","2016-04-01 12:15:40","2016-04-01 12:16:07",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
var/ds/ordercsv/orderexport_form_orderid_1_to_2_date_20160406_133352.csv ADDED
@@ -0,0 +1,3 @@
 
 
 
1
+ order_id,email,firstname,lastname,prefix,middlename,suffix,taxvat,created_at,updated_at,invoice_created_at,shipment_created_at,creditmemo_created_at,tax_amount,base_tax_amount,discount_amount,base_discount_amount,shipping_tax_amount,base_shipping_tax_amount,base_to_global_rate,base_to_order_rate,store_to_base_rate,store_to_order_rate,subtotal_incl_tax,base_subtotal_incl_tax,coupon_code,shipping_incl_tax,base_shipping_incl_tax,shipping_method,shipping_amount,subtotal,base_subtotal,grand_total,base_grand_total,base_shipping_amount,adjustment_positive,adjustment_negative,refunded_shipping_amount,base_refunded_shipping_amount,refunded_subtotal,base_refunded_subtotal,refunded_tax_amount,base_refunded_tax_amount,refunded_discount_amount,base_refunded_discount_amount,store_id,order_status,order_state,hold_before_state,hold_before_status,store_currency_code,base_currency_code,order_currency_code,total_paid,base_total_paid,is_virtual,total_qty_ordered,remote_ip,total_refunded,base_total_refunded,total_canceled,total_invoiced,customer_id,billing_prefix,billing_firstname,billing_middlename,billing_lastname,billing_suffix,billing_street_full,billing_city,billing_region,billing_country,billing_postcode,billing_telephone,billing_company,billing_fax,customer_id,shipping_prefix,shipping_firstname,shipping_middlename,shipping_lastname,shipping_suffix,shipping_street_full,shipping_city,shipping_region,shipping_country,shipping_postcode,shipping_telephone,shipping_company,shipping_fax,payment_method,product_sku,product_name,qty_ordered,qty_invoiced,qty_shipped,qty_refunded,qty_canceled,product_type,original_price,base_original_price,row_total,base_row_total,row_weight,price_incl_tax,base_price_incl_tax,product_tax_amount,product_base_tax_amount,product_tax_percent,product_discount,product_base_discount,product_discount_percent,is_child,product_option
2
+ 100000001,dot@gmail.com,govind,bhatt,,ram,,,"2016-03-30 06:36:01","2016-03-30 06:36:02",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
3
+ 100000002,gfgf@gmail.com,ggf,gfg,,fgf,,,"2016-03-30 08:54:17","2016-04-01 12:16:08","2016-04-01 12:15:40","2016-04-01 12:16:07",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
var/ds/ordercsv/orderexport_form_orderid_1_to_8_date_20160407_081033.csv ADDED
@@ -0,0 +1,9 @@
 
 
 
 
 
 
 
 
 
1
+ order_id,email,firstname,lastname,prefix,middlename,suffix,taxvat,created_at,updated_at,invoice_created_at,shipment_created_at,creditmemo_created_at,tax_amount,base_tax_amount,discount_amount,base_discount_amount,shipping_tax_amount,base_shipping_tax_amount,base_to_global_rate,base_to_order_rate,store_to_base_rate,store_to_order_rate,subtotal_incl_tax,base_subtotal_incl_tax,coupon_code,shipping_incl_tax,base_shipping_incl_tax,shipping_method,shipping_amount,subtotal,base_subtotal,grand_total,base_grand_total,base_shipping_amount,adjustment_positive,adjustment_negative,refunded_shipping_amount,base_refunded_shipping_amount,refunded_subtotal,base_refunded_subtotal,refunded_tax_amount,base_refunded_tax_amount,refunded_discount_amount,base_refunded_discount_amount,store_id,order_status,order_state,hold_before_state,hold_before_status,store_currency_code,base_currency_code,order_currency_code,total_paid,base_total_paid,is_virtual,total_qty_ordered,remote_ip,total_refunded,base_total_refunded,total_canceled,total_invoiced,customer_id,billing_prefix,billing_firstname,billing_middlename,billing_lastname,billing_suffix,billing_street_full,billing_city,billing_region,billing_country,billing_postcode,billing_telephone,billing_company,billing_fax,customer_id,shipping_prefix,shipping_firstname,shipping_middlename,shipping_lastname,shipping_suffix,shipping_street_full,shipping_city,shipping_region,shipping_country,shipping_postcode,shipping_telephone,shipping_company,shipping_fax,payment_method,product_sku,product_name,qty_ordered,qty_invoiced,qty_shipped,qty_refunded,qty_canceled,product_type,original_price,base_original_price,row_total,base_row_total,row_weight,price_incl_tax,base_price_incl_tax,product_tax_amount,product_base_tax_amount,product_tax_percent,product_discount,product_base_discount,product_discount_percent,is_child,product_option
2
+ 100000001,dot@gmail.com,govind,bhatt,,ram,,,"2016-03-30 06:36:01","2016-03-30 06:36:02",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
3
+ 100000002,gfgf@gmail.com,ggf,gfg,,fgf,,,"2016-03-30 08:54:17","2016-04-01 12:16:08","2016-04-01 12:15:40","2016-04-01 12:16:07",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
4
+ 100000003,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 09:14:20",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
5
+ 100000004,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 11:34:10",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
6
+ 100000006,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:10:38",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
7
+ 100000007,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:11:36",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
8
+ 100000008,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:14:37",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
9
+ 100000009,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:18:12","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
var/ds/ordercsv/orderexport_form_orderid_1_to_8_date_20160407_081059.csv ADDED
@@ -0,0 +1,9 @@
 
 
 
 
 
 
 
 
 
1
+ order_id,email,firstname,lastname,prefix,middlename,suffix,taxvat,created_at,updated_at,invoice_created_at,shipment_created_at,creditmemo_created_at,tax_amount,base_tax_amount,discount_amount,base_discount_amount,shipping_tax_amount,base_shipping_tax_amount,base_to_global_rate,base_to_order_rate,store_to_base_rate,store_to_order_rate,subtotal_incl_tax,base_subtotal_incl_tax,coupon_code,shipping_incl_tax,base_shipping_incl_tax,shipping_method,shipping_amount,subtotal,base_subtotal,grand_total,base_grand_total,base_shipping_amount,adjustment_positive,adjustment_negative,refunded_shipping_amount,base_refunded_shipping_amount,refunded_subtotal,base_refunded_subtotal,refunded_tax_amount,base_refunded_tax_amount,refunded_discount_amount,base_refunded_discount_amount,store_id,order_status,order_state,hold_before_state,hold_before_status,store_currency_code,base_currency_code,order_currency_code,total_paid,base_total_paid,is_virtual,total_qty_ordered,remote_ip,total_refunded,base_total_refunded,total_canceled,total_invoiced,customer_id,billing_prefix,billing_firstname,billing_middlename,billing_lastname,billing_suffix,billing_street_full,billing_city,billing_region,billing_country,billing_postcode,billing_telephone,billing_company,billing_fax,customer_id,shipping_prefix,shipping_firstname,shipping_middlename,shipping_lastname,shipping_suffix,shipping_street_full,shipping_city,shipping_region,shipping_country,shipping_postcode,shipping_telephone,shipping_company,shipping_fax,payment_method,product_sku,product_name,qty_ordered,qty_invoiced,qty_shipped,qty_refunded,qty_canceled,product_type,original_price,base_original_price,row_total,base_row_total,row_weight,price_incl_tax,base_price_incl_tax,product_tax_amount,product_base_tax_amount,product_tax_percent,product_discount,product_base_discount,product_discount_percent,is_child,product_option
2
+ 100000001,dot@gmail.com,govind,bhatt,,ram,,,"2016-03-30 06:36:01","2016-03-30 06:36:02",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
3
+ 100000002,gfgf@gmail.com,ggf,gfg,,fgf,,,"2016-03-30 08:54:17","2016-04-01 12:16:08","2016-04-01 12:15:40","2016-04-01 12:16:07",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
4
+ 100000003,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 09:14:20",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
5
+ 100000004,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 11:34:10",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
6
+ 100000006,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:10:38",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
7
+ 100000007,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:11:36",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
8
+ 100000008,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:14:37",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
9
+ 100000009,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:18:12","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
var/ds/ordercsv/orderexport_form_orderid_3_to_86_date_20160405_130734.csv ADDED
@@ -0,0 +1,22 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ order_id,email,firstname,lastname,prefix,middlename,suffix,taxvat,created_at,updated_at,invoice_created_at,shipment_created_at,creditmemo_created_at,tax_amount,base_tax_amount,discount_amount,base_discount_amount,shipping_tax_amount,base_shipping_tax_amount,base_to_global_rate,base_to_order_rate,store_to_base_rate,store_to_order_rate,subtotal_incl_tax,base_subtotal_incl_tax,coupon_code,shipping_incl_tax,base_shipping_incl_tax,shipping_method,shipping_amount,subtotal,base_subtotal,grand_total,base_grand_total,base_shipping_amount,adjustment_positive,adjustment_negative,refunded_shipping_amount,base_refunded_shipping_amount,refunded_subtotal,base_refunded_subtotal,refunded_tax_amount,base_refunded_tax_amount,refunded_discount_amount,base_refunded_discount_amount,store_id,order_status,order_state,hold_before_state,hold_before_status,store_currency_code,base_currency_code,order_currency_code,total_paid,base_total_paid,is_virtual,total_qty_ordered,remote_ip,total_refunded,base_total_refunded,total_canceled,total_invoiced,customer_id,billing_prefix,billing_firstname,billing_middlename,billing_lastname,billing_suffix,billing_street_full,billing_city,billing_region,billing_country,billing_postcode,billing_telephone,billing_company,billing_fax,customer_id,shipping_prefix,shipping_firstname,shipping_middlename,shipping_lastname,shipping_suffix,shipping_street_full,shipping_city,shipping_region,shipping_country,shipping_postcode,shipping_telephone,shipping_company,shipping_fax,payment_method,product_sku,product_name,qty_ordered,qty_invoiced,qty_shipped,qty_refunded,qty_canceled,product_type,original_price,base_original_price,row_total,base_row_total,row_weight,price_incl_tax,base_price_incl_tax,product_tax_amount,product_base_tax_amount,product_tax_percent,product_discount,product_base_discount,product_discount_percent,is_child,product_option
2
+ 100000003,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 09:14:20",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
3
+ 100000001,dot@gmail.com,govind,bhatt,,ram,,,"2016-03-30 06:36:01","2016-03-30 06:36:02",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
4
+ 100000002,gfgf@gmail.com,ggf,gfg,,fgf,,,"2016-03-30 08:54:17","2016-04-01 12:16:08","2016-04-01 12:15:40","2016-04-01 12:16:07",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
5
+ 100000004,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 11:34:10",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
6
+ 100000006,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:10:38",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
7
+ 100000007,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:11:36",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
8
+ 100000008,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:14:37",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
9
+ 100000009,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:18:12","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
10
+ 100000010,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:37:51",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
11
+ 100000011,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:45:24",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
12
+ 100000012,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:47:01","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
13
+ 100000013,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-04 05:19:26","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
14
+ 1000000014,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-04 05:19:27","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
15
+ 100000015,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-04 05:24:13","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
16
+ 100000014,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:07:07",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
17
+ 100000016,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:12:59",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
18
+ 100000017,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:13:51",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
19
+ 100000018,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-05 10:21:06","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
20
+ 100000019,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-05 10:21:10","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
21
+ 100000020,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-05 10:21:11","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
22
+ 100000021,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-05 10:21:12","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
var/ds/ordercsv/orderexport_form_orderid_3_to_86_date_20160406_133855.csv ADDED
@@ -0,0 +1,22 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ order_id,email,firstname,lastname,prefix,middlename,suffix,taxvat,created_at,updated_at,invoice_created_at,shipment_created_at,creditmemo_created_at,tax_amount,base_tax_amount,discount_amount,base_discount_amount,shipping_tax_amount,base_shipping_tax_amount,base_to_global_rate,base_to_order_rate,store_to_base_rate,store_to_order_rate,subtotal_incl_tax,base_subtotal_incl_tax,coupon_code,shipping_incl_tax,base_shipping_incl_tax,shipping_method,shipping_amount,subtotal,base_subtotal,grand_total,base_grand_total,base_shipping_amount,adjustment_positive,adjustment_negative,refunded_shipping_amount,base_refunded_shipping_amount,refunded_subtotal,base_refunded_subtotal,refunded_tax_amount,base_refunded_tax_amount,refunded_discount_amount,base_refunded_discount_amount,store_id,order_status,order_state,hold_before_state,hold_before_status,store_currency_code,base_currency_code,order_currency_code,total_paid,base_total_paid,is_virtual,total_qty_ordered,remote_ip,total_refunded,base_total_refunded,total_canceled,total_invoiced,customer_id,billing_prefix,billing_firstname,billing_middlename,billing_lastname,billing_suffix,billing_street_full,billing_city,billing_region,billing_country,billing_postcode,billing_telephone,billing_company,billing_fax,customer_id,shipping_prefix,shipping_firstname,shipping_middlename,shipping_lastname,shipping_suffix,shipping_street_full,shipping_city,shipping_region,shipping_country,shipping_postcode,shipping_telephone,shipping_company,shipping_fax,payment_method,product_sku,product_name,qty_ordered,qty_invoiced,qty_shipped,qty_refunded,qty_canceled,product_type,original_price,base_original_price,row_total,base_row_total,row_weight,price_incl_tax,base_price_incl_tax,product_tax_amount,product_base_tax_amount,product_tax_percent,product_discount,product_base_discount,product_discount_percent,is_child,product_option
2
+ 100000003,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 09:14:20",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
3
+ 100000001,dot@gmail.com,govind,bhatt,,ram,,,"2016-03-30 06:36:01","2016-03-30 06:36:02",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
4
+ 100000002,gfgf@gmail.com,ggf,gfg,,fgf,,,"2016-03-30 08:54:17","2016-04-01 12:16:08","2016-04-01 12:15:40","2016-04-01 12:16:07",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
5
+ 100000004,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 11:34:10",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
6
+ 100000006,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:10:38",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
7
+ 100000007,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:11:36",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
8
+ 100000008,dot@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-01 12:14:37",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
9
+ 100000009,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:18:12","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
10
+ 100000010,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:37:51",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
11
+ 100000011,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:45:24",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
12
+ 100000012,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-01 12:47:01","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
13
+ 100000013,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-04 05:19:26","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
14
+ 1000000014,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-04 05:19:27","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
15
+ 100000015,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-04 05:24:13","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
16
+ 100000014,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:07:07",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
17
+ 100000016,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:12:59",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
18
+ 100000017,dot1@gmail.com,govind,bhatt,,,,,"2016-03-30 06:36:00","2016-04-05 06:13:51",,,,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,pending,new,,,USD,USD,USD,,,0,1.0000,::1,,,,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,,,govind,ram,bhatt,,dsd,fdfd,"Federated States Of Micronesia",US,12212,2121212,dot,,checkmo,1,"Satin Ribbon",1,0,0,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""Xhyab4AtnxDsFLiJ"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:42:""jQuery1110037207608594955666_1459319657773"";s:1:""_"";s:13:""1459319657774"";s:3:""qty"";i:1;}}"
19
+ 100000018,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-05 10:21:06","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
20
+ 100000019,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-05 10:21:10","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
21
+ 100000020,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-05 10:21:11","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"
22
+ 100000021,gfgf@gmail.com,ggf,gfg,,,,,"2016-03-30 08:54:00","2016-04-05 10:21:12","2016-04-01 12:15:00","2016-04-01 12:16:00",,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000,1.0000,1.0000,1.0000,11.0000,11.0000,,5.0000,5.0000,"Flat Rate - Fixed",5.0000,11.0000,11.0000,16.0000,16.0000,5.0000,0,0,0,0,0,0,0,0,0,0,1,complete,complete,,,USD,USD,USD,16.0000,16.0000,0,1.0000,::1,,,,16.0000,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,,,ggf,fgf,gfg,,fdf,434,,GB,323,23233,fgfg,,checkmo,1,"Satin Ribbon",1,1,1,0,0,simple,11.0000,11.0000,11.0000,11.0000,1.0000,11.0000,11.0000,0.0000,0.0000,0.0000,0.0000,0.0000,0.0000,no,"a:1:{s:15:""info_buyRequest"";a:7:{s:4:""uenc"";s:64:""aHR0cDovL2xvY2FsaG9zdC9tYWdlbnRvMTkyMS9pbmRleC5waHAvdGVzdC5odG1s"";s:7:""product"";s:1:""1"";s:8:""form_key"";s:16:""3YO5VoMVvYmLxHPC"";s:6:""isAjax"";s:1:""1"";s:8:""callback"";s:41:""jQuery111003303963650609648_1459327972503"";s:1:""_"";s:13:""1459327972504"";s:3:""qty"";i:1;}}"