Order Export & Order Import for WooCommerce - Version 2.0.1

Version Description

  • Tested OK with PHP 8.0
  • Option to connect products using SKU when importing orders
Download this release

Release Info

Developer webtoffee
Plugin Icon 128x128 Order Export & Order Import for WooCommerce
Version 2.0.1
Comparing to
See all releases

Code changes from version 2.0.0 to 2.0.1

Files changed (22) hide show
  1. admin/class-wt-import-export-for-woo-admin.php +2 -2
  2. admin/css/wt-import-export-for-woo-admin.css +9 -0
  3. admin/modules/coupon/data/data-coupon-post-columns.php +33 -33
  4. admin/modules/coupon/data/data/data-wf-reserved-fields-pair.php +28 -28
  5. admin/modules/export/export.php +2 -2
  6. admin/modules/history/history.php +2 -2
  7. admin/modules/import/import.php +2 -2
  8. admin/modules/import/views/_import_mapping_page.php +4 -3
  9. admin/modules/import/views/_import_method_import_page.php +1 -1
  10. admin/modules/order/data/data-order-post-columns.php +57 -57
  11. admin/modules/order/data/data-wf-post-columns-coupon.php +34 -34
  12. admin/modules/order/data/data-wf-post-subscription-columns.php +86 -86
  13. admin/modules/order/data/data-wf-xml-default-meta.php +44 -44
  14. admin/modules/order/data/data/data-wf-reserved-fields-pair.php +53 -53
  15. admin/modules/order/export/export.php +2 -0
  16. admin/modules/order/import/import.php +8 -2
  17. admin/modules/order/order.php +24 -0
  18. admin/views/admin-settings-help.php +1 -1
  19. helpers/class-wt-security-helper.php +1 -1
  20. includes/class-wt-import-export-for-woo.php +1 -1
  21. order-import-export-for-woocommerce.php +22 -2
  22. readme.txt +30 -15
admin/class-wt-import-export-for-woo-admin.php CHANGED
@@ -140,7 +140,7 @@ class Wt_Import_Export_For_Woo_Admin_Basic {
140
  'menu',
141
  __('General Settings'),
142
  __('General Settings'),
143
- 'manage_options',
144
  WT_IEW_PLUGIN_ID_BASIC,
145
  array($this,'admin_settings_page'),
146
  'dashicons-controls-repeat',
@@ -163,7 +163,7 @@ class Wt_Import_Export_For_Woo_Admin_Basic {
163
  $parent_menu_key,
164
  __('General Settings'),
165
  __('General Settings'),
166
- "manage_options",
167
  WT_IEW_PLUGIN_ID_BASIC,
168
  array($this, 'admin_settings_page')
169
  );
140
  'menu',
141
  __('General Settings'),
142
  __('General Settings'),
143
+ apply_filters('wt_import_export_allowed_capability', 'manage_woocommerce'),
144
  WT_IEW_PLUGIN_ID_BASIC,
145
  array($this,'admin_settings_page'),
146
  'dashicons-controls-repeat',
163
  $parent_menu_key,
164
  __('General Settings'),
165
  __('General Settings'),
166
+ apply_filters('wt_import_export_allowed_capability', 'manage_woocommerce'),
167
  WT_IEW_PLUGIN_ID_BASIC,
168
  array($this, 'admin_settings_page')
169
  );
admin/css/wt-import-export-for-woo-admin.css CHANGED
@@ -311,6 +311,15 @@ border-top-right-radius: 5px; padding:5px; padding-left: 15px; line-height: 35px
311
  .wt_iew_mapping_field_selector li:hover{ background:#0073aa; color:#fff; }
312
  .wt_iew_mapping_field_selector_no_column{ float:left; width:100%; color:red; }
313
  .wt_iew_no_sample_mapping_data{ color:gray; display:inline-block !important; padding:0px !important; margin:0px !important; font-style:italic; }
 
 
 
 
 
 
 
 
 
314
 
315
  /* debug panel */
316
  .wt_iew_debug_panel{ position:fixed; top:30px; right:0px; background:#fff; padding:5px; padding-bottom:0px; box-shadow:2px 2px 2px #ccc; }
311
  .wt_iew_mapping_field_selector li:hover{ background:#0073aa; color:#fff; }
312
  .wt_iew_mapping_field_selector_no_column{ float:left; width:100%; color:red; }
313
  .wt_iew_no_sample_mapping_data{ color:gray; display:inline-block !important; padding:0px !important; margin:0px !important; font-style:italic; }
314
+ .wt_evaluation_expression_points{list-style: none;}
315
+ .wt_evaluation_expression_points li::before {
316
+ content: "\2022"; /* Add content: \2022 is the CSS Code/unicode for a bullet */
317
+ color: red; /* Change the color */
318
+ font-weight: bold; /* If you want it to be bold */
319
+ display: inline-block; /* Needed to add space between the bullet and the text */
320
+ width: 1em; /* Also needed for space (tweak if needed) */
321
+ }
322
+
323
 
324
  /* debug panel */
325
  .wt_iew_debug_panel{ position:fixed; top:30px; right:0px; background:#fff; padding:5px; padding-bottom:0px; box-shadow:2px 2px 2px #ccc; }
admin/modules/coupon/data/data-coupon-post-columns.php CHANGED
@@ -1,34 +1,34 @@
1
- <?php
2
- if ( ! defined( 'ABSPATH' ) ) {
3
- exit;
4
- }
5
-
6
- return apply_filters('coupon_csv_coupon_post_columns', array(
7
- 'post_title' => 'post_title',
8
- 'ID' => 'ID',
9
- 'post_excerpt' => 'post_excerpt',
10
- 'post_status' => 'post_status',
11
- 'post_date' => 'post_date',
12
- 'post_author' => 'post_author',
13
-
14
- // // Meta
15
- 'discount_type' => 'discount_type',
16
- 'coupon_amount' => 'coupon_amount',
17
- 'individual_use' => 'individual_use',
18
- 'product_ids' => 'product_ids',
19
- 'product_SKUs' => 'product_SKUs',
20
- 'exclude_product_ids' => 'exclude_product_ids',
21
- 'exclude_product_SKUs' => 'exclude_product_SKUs',
22
- 'usage_count' => 'usage_count',
23
- 'usage_limit' => 'usage_limit',
24
- 'usage_limit_per_user' => 'usage_limit_per_user',
25
- 'limit_usage_to_x_items' => 'limit_usage_to_x_items',
26
- 'date_expires' => 'date_expires',
27
- 'free_shipping' => 'free_shipping',
28
- 'exclude_sale_items' => 'exclude_sale_items',
29
- 'product_categories' => 'product_categories',
30
- 'exclude_product_categories' => 'exclude_product_categories',
31
- 'minimum_amount' => 'minimum_amount',
32
- 'maximum_amount' => 'maximum_amount',
33
- 'customer_email' => 'customer_email',
34
  ) );
1
+ <?php
2
+ if ( ! defined( 'ABSPATH' ) ) {
3
+ exit;
4
+ }
5
+
6
+ return apply_filters('coupon_csv_coupon_post_columns', array(
7
+ 'post_title' => 'post_title',
8
+ 'ID' => 'ID',
9
+ 'post_excerpt' => 'post_excerpt',
10
+ 'post_status' => 'post_status',
11
+ 'post_date' => 'post_date',
12
+ 'post_author' => 'post_author',
13
+
14
+ // // Meta
15
+ 'discount_type' => 'discount_type',
16
+ 'coupon_amount' => 'coupon_amount',
17
+ 'individual_use' => 'individual_use',
18
+ 'product_ids' => 'product_ids',
19
+ 'product_SKUs' => 'product_SKUs',
20
+ 'exclude_product_ids' => 'exclude_product_ids',
21
+ 'exclude_product_SKUs' => 'exclude_product_SKUs',
22
+ 'usage_count' => 'usage_count',
23
+ 'usage_limit' => 'usage_limit',
24
+ 'usage_limit_per_user' => 'usage_limit_per_user',
25
+ 'limit_usage_to_x_items' => 'limit_usage_to_x_items',
26
+ 'date_expires' => 'date_expires',
27
+ 'free_shipping' => 'free_shipping',
28
+ 'exclude_sale_items' => 'exclude_sale_items',
29
+ 'product_categories' => 'product_categories',
30
+ 'exclude_product_categories' => 'exclude_product_categories',
31
+ 'minimum_amount' => 'minimum_amount',
32
+ 'maximum_amount' => 'maximum_amount',
33
+ 'customer_email' => 'customer_email',
34
  ) );
admin/modules/coupon/data/data/data-wf-reserved-fields-pair.php CHANGED
@@ -1,29 +1,29 @@
1
- <?php
2
-
3
- // Reserved column names
4
- return apply_filters('woocommerce_csv_product_import_reserved_fields_pair',array(
5
- 'ID' => array('title'=>'Coupon ID','description'=>'Coupon ID'),
6
- 'post_title' => array('title'=>'Coupon Title','description'=>'Name of the coupon '),
7
- //'post_name' => array('title'=>'Coupon Permalink','description'=>'Unique part of the coupon URL'),
8
- 'post_status' => array('title'=>'Coupon Status','description'=>'Coupon Status ( published , draft ...)'),
9
- //'post_content' => array('title'=>'Coupon Description','description'=>'Description about the Coupon'),
10
- 'post_excerpt' => array('title'=>'Coupon Short Description','description'=>'Short description about the Coupon'),
11
- 'post_date' => array('title'=>'Post Date','description'=>'Coupon posted date', 'type' => 'date'),
12
- 'discount_type' => array('title'=>'Coupon Type','description'=>'fixed_cart OR percent OR fixed_product OR percent_product'),
13
- 'coupon_amount' => array('title'=>'Coupon Amount','description'=>'Numeric values'),
14
- 'individual_use' => array('title'=>'Individual Use?','description'=>'yes or no'),
15
- 'product_ids' => array('title'=>'Associated Product Ids','description'=>'With comma(,) Separator'),
16
- 'exclude_product_ids' => array('title'=>'Exclude Product Ids','description'=>'With comma(,) Separator'),
17
- 'usage_count' => array('title'=>'No of times used','description'=>'Numeric Values'),
18
- 'usage_limit' => array('title'=>'Usage Limit Per Coupon','description'=>'Numeric Values'),
19
- 'usage_limit_per_user' => array('title'=>'Usage Limit Per User','description'=>'Numeric Values'),
20
- 'limit_usage_to_x_items' => array('title'=>'Limit Usage To X Items','description'=>'Maximum Number Of Individual Items This Coupon Can Apply'),
21
- 'date_expires' => array('title'=>'Expiry Date','description'=>'YYYY-MM-DD', 'type' => 'date'),
22
- 'free_shipping' => array('title'=>'Is Free Shipping?','description'=>'yes or no'),
23
- 'exclude_sale_items' => array('title'=>'Is Exclude Sale Items?','description'=>'yes or no'),
24
- 'product_categories' => array('title'=>'Product Categories','description'=>'with comma(,) Separator'),
25
- 'exclude_product_categories' => array('title'=>'Exclude Product Categories','description'=>'With comma(,) Separator'),
26
- 'minimum_amount' => array('title'=>'Minimum Amount','description'=>'Numeric'),
27
- 'maximum_amount' => array('title'=>'Maximum Amount','description'=>'Numeric'),
28
- 'customer_email' => array('title'=>'Restricted Customers Email Ids','description'=>'With comma(,) Separator'),
29
  ));
1
+ <?php
2
+
3
+ // Reserved column names
4
+ return apply_filters('woocommerce_csv_product_import_reserved_fields_pair',array(
5
+ 'ID' => array('title'=>'Coupon ID','description'=>'Coupon ID'),
6
+ 'post_title' => array('title'=>'Coupon Title','description'=>'Name of the coupon '),
7
+ //'post_name' => array('title'=>'Coupon Permalink','description'=>'Unique part of the coupon URL'),
8
+ 'post_status' => array('title'=>'Coupon Status','description'=>'Coupon Status ( published , draft ...)'),
9
+ //'post_content' => array('title'=>'Coupon Description','description'=>'Description about the Coupon'),
10
+ 'post_excerpt' => array('title'=>'Coupon Short Description','description'=>'Short description about the Coupon'),
11
+ 'post_date' => array('title'=>'Post Date','description'=>'Coupon posted date', 'type' => 'date'),
12
+ 'discount_type' => array('title'=>'Coupon Type','description'=>'fixed_cart OR percent OR fixed_product OR percent_product'),
13
+ 'coupon_amount' => array('title'=>'Coupon Amount','description'=>'Numeric values'),
14
+ 'individual_use' => array('title'=>'Individual Use?','description'=>'yes or no'),
15
+ 'product_ids' => array('title'=>'Associated Product Ids','description'=>'With comma(,) Separator'),
16
+ 'exclude_product_ids' => array('title'=>'Exclude Product Ids','description'=>'With comma(,) Separator'),
17
+ 'usage_count' => array('title'=>'No of times used','description'=>'Numeric Values'),
18
+ 'usage_limit' => array('title'=>'Usage Limit Per Coupon','description'=>'Numeric Values'),
19
+ 'usage_limit_per_user' => array('title'=>'Usage Limit Per User','description'=>'Numeric Values'),
20
+ 'limit_usage_to_x_items' => array('title'=>'Limit Usage To X Items','description'=>'Maximum Number Of Individual Items This Coupon Can Apply'),
21
+ 'date_expires' => array('title'=>'Expiry Date','description'=>'YYYY-MM-DD', 'type' => 'date'),
22
+ 'free_shipping' => array('title'=>'Is Free Shipping?','description'=>'yes or no'),
23
+ 'exclude_sale_items' => array('title'=>'Is Exclude Sale Items?','description'=>'yes or no'),
24
+ 'product_categories' => array('title'=>'Product Categories','description'=>'with comma(,) Separator'),
25
+ 'exclude_product_categories' => array('title'=>'Exclude Product Categories','description'=>'With comma(,) Separator'),
26
+ 'minimum_amount' => array('title'=>'Minimum Amount','description'=>'Numeric'),
27
+ 'maximum_amount' => array('title'=>'Maximum Amount','description'=>'Numeric'),
28
+ 'customer_email' => array('title'=>'Restricted Customers Email Ids','description'=>'With comma(,) Separator'),
29
  ));
admin/modules/export/export.php CHANGED
@@ -144,7 +144,7 @@ class Wt_Import_Export_For_Woo_Basic_Export
144
  'menu',
145
  __('Export'),
146
  __('WebToffee Import Export (Basic)'),
147
- 'manage_options',
148
  $this->module_id,
149
  array($this,'admin_settings_page'),
150
  'dashicons-controls-repeat',
@@ -155,7 +155,7 @@ class Wt_Import_Export_For_Woo_Basic_Export
155
  $this->module_id,
156
  __('Export'),
157
  __('Export'),
158
- "manage_options",
159
  $this->module_id,
160
  array($this, 'admin_settings_page')
161
  ),
144
  'menu',
145
  __('Export'),
146
  __('WebToffee Import Export (Basic)'),
147
+ apply_filters('wt_import_export_allowed_capability', 'manage_woocommerce'),
148
  $this->module_id,
149
  array($this,'admin_settings_page'),
150
  'dashicons-controls-repeat',
155
  $this->module_id,
156
  __('Export'),
157
  __('Export'),
158
+ apply_filters('wt_import_export_allowed_capability', 'manage_woocommerce'),
159
  $this->module_id,
160
  array($this, 'admin_settings_page')
161
  ),
admin/modules/history/history.php CHANGED
@@ -70,7 +70,7 @@ class Wt_Import_Export_For_Woo_Basic_History
70
  WT_IEW_PLUGIN_ID_BASIC,
71
  __('History'),
72
  __('History'),
73
- 'manage_options',
74
  $this->module_id,
75
  array($this, 'admin_settings_page')
76
  );
@@ -79,7 +79,7 @@ class Wt_Import_Export_For_Woo_Basic_History
79
  WT_IEW_PLUGIN_ID_BASIC,
80
  __('Logs'),
81
  __('Logs'),
82
- 'manage_options',
83
  $this->module_id.'_log',
84
  array($this, 'admin_log_page')
85
  );
70
  WT_IEW_PLUGIN_ID_BASIC,
71
  __('History'),
72
  __('History'),
73
+ apply_filters('wt_import_export_allowed_capability', 'manage_woocommerce'),
74
  $this->module_id,
75
  array($this, 'admin_settings_page')
76
  );
79
  WT_IEW_PLUGIN_ID_BASIC,
80
  __('Logs'),
81
  __('Logs'),
82
+ apply_filters('wt_import_export_allowed_capability', 'manage_woocommerce'),
83
  $this->module_id.'_log',
84
  array($this, 'admin_log_page')
85
  );
admin/modules/import/import.php CHANGED
@@ -62,7 +62,7 @@ class Wt_Import_Export_For_Woo_Basic_Import
62
  'description'=>__('Choose from the options below to continue with your import: quick import, based on a pre-saved template or a new import with advanced options.'),
63
  ),
64
  'mapping'=>array(
65
- 'title'=>__('Map and reorder import columns'),
66
  'description'=>__('Map the standard columns with your CSV column names.'),
67
  ),
68
  'advanced'=>array(
@@ -253,7 +253,7 @@ class Wt_Import_Export_For_Woo_Basic_Import
253
  WT_IEW_PLUGIN_ID_BASIC,
254
  __('Import'),
255
  __('Import'),
256
- 'manage_options',
257
  $this->module_id,
258
  array($this, 'admin_settings_page')
259
  )
62
  'description'=>__('Choose from the options below to continue with your import: quick import, based on a pre-saved template or a new import with advanced options.'),
63
  ),
64
  'mapping'=>array(
65
+ 'title'=>__('Map import columns'),
66
  'description'=>__('Map the standard columns with your CSV column names.'),
67
  ),
68
  'advanced'=>array(
253
  WT_IEW_PLUGIN_ID_BASIC,
254
  __('Import'),
255
  __('Import'),
256
+ apply_filters('wt_import_export_allowed_capability', 'manage_woocommerce'),
257
  $this->module_id,
258
  array($this, 'admin_settings_page')
259
  )
admin/modules/import/views/_import_mapping_page.php CHANGED
@@ -18,9 +18,10 @@ if (!defined('ABSPATH')) {
18
 
19
  <label><?php _e('Expression');?></label>
20
  <p class="wt_iew_mapping_field_editor_info">
21
- <?php _e('Any of the operators +*/-()&@ or string constants can be used along with the attributes to manipulate the respective value.'); ?>
22
- <br />
23
- <?php echo sprintf(__('Enclose the operations within square brackets. e.g. if you want to increase the stock quantity of %sall imported products%s by 5 units during import simply use [{_stock}+5].'), '<b>', '</b>');?>
 
24
  </p>
25
  <p class="wt_iew_mapping_field_editor_er"></p>
26
  <div class="wt_iew_mapping_field_editor_box">
18
 
19
  <label><?php _e('Expression');?></label>
20
  <p class="wt_iew_mapping_field_editor_info">
21
+ <ul class="wt_evaluation_expression_points">
22
+ <li><?php _e('Append operators like + * / - () & @ or string constants along with the column names to update the values on import.'); ?></li>
23
+ <li><?php echo sprintf(__('Ensure to enclose the expressions in square brackets. E.g. To increase the stock quantity of %sall imported products%s by 5 units, input [{_stock}+5] in the stock column.'), '<b>', '</b>');?></li>
24
+ </ul>
25
  </p>
26
  <p class="wt_iew_mapping_field_editor_er"></p>
27
  <div class="wt_iew_mapping_field_editor_box">
admin/modules/import/views/_import_method_import_page.php CHANGED
@@ -27,7 +27,7 @@ if (!defined('ABSPATH')) {
27
  </div>
28
  </td>
29
  </tr>
30
- <tr><div id="user-required-field-message" class="updated" style="margin-left:0px;display: none;background: #dceff4;"><p><?php _e('For a successful import, the uploading file must contain data for <b>at least 1 column: user_email</b>.'); ?></p></div></tr>
31
  <tr class="wt-iew-import-method-options wt-iew-import-method-options-template" style="display:none;">
32
  <th><label><?php _e('Import template');?></label></th>
33
  <td>
27
  </div>
28
  </td>
29
  </tr>
30
+ <tr><div id="user-required-field-message" class="updated" style="margin-left:0px;display: none;background: #dceff4;"><p><?php _e('Ensure the import file has the user\'s email ID for a successful import. Use default column name <b>user_email</b> or map the column accordingly if you are using a custom column name.'); ?></p></div></tr>
31
  <tr class="wt-iew-import-method-options wt-iew-import-method-options-template" style="display:none;">
32
  <th><label><?php _e('Import template');?></label></th>
33
  <td>
admin/modules/order/data/data-order-post-columns.php CHANGED
@@ -1,57 +1,57 @@
1
- <?php
2
-
3
- if (!defined('ABSPATH')) {
4
- exit;
5
- }
6
-
7
- return apply_filters('hf_csv_order_post_columns', array(
8
- 'order_id' => 'order_id',
9
- 'order_number' => 'order_number',
10
- 'order_date' => 'order_date',
11
- 'status' => 'status',
12
- 'shipping_total' => 'shipping_total',
13
- 'shipping_tax_total' => 'shipping_tax_total',
14
- 'fee_total' => 'fee_total',
15
- 'fee_tax_total' => 'fee_tax_total',
16
- 'tax_total' => 'tax_total',
17
- 'cart_discount' => 'cart_discount',
18
- 'order_discount' => 'order_discount',
19
- 'discount_total' => 'discount_total',
20
- 'order_total' => 'order_total',
21
- //'refunded_total' => 'refunded_total',
22
- 'order_currency' => 'order_currency',
23
- 'payment_method' => 'payment_method',
24
- 'shipping_method' => 'shipping_method',
25
- 'customer_id' => 'customer_id',
26
- 'customer_user' => 'customer_user',
27
- 'customer_email' => 'customer_email',
28
- 'billing_first_name' => 'billing_first_name',
29
- 'billing_last_name' => 'billing_last_name',
30
- 'billing_company' => 'billing_company',
31
- 'billing_email' => 'billing_email',
32
- 'billing_phone' => 'billing_phone',
33
- 'billing_address_1' => 'billing_address_1',
34
- 'billing_address_2' => 'billing_address_2',
35
- 'billing_postcode' => 'billing_postcode',
36
- 'billing_city' => 'billing_city',
37
- 'billing_state' => 'billing_state',
38
- 'billing_country' => 'billing_country',
39
- 'shipping_first_name' => 'shipping_first_name',
40
- 'shipping_last_name' => 'shipping_last_name',
41
- 'shipping_company' => 'shipping_company',
42
- 'shipping_address_1' => 'shipping_address_1',
43
- 'shipping_address_2' => 'shipping_address_2',
44
- 'shipping_postcode' => 'shipping_postcode',
45
- 'shipping_city' => 'shipping_city',
46
- 'shipping_state' => 'shipping_state',
47
- 'shipping_country' => 'shipping_country',
48
- 'customer_note' => 'customer_note',
49
- 'wt_import_key' => 'wt_import_key',
50
- 'shipping_items' => 'shipping_items',
51
- 'fee_items' => 'fee_items',
52
- 'tax_items' => 'tax_items',
53
- 'coupon_items' => 'coupon_items',
54
- 'refund_items' => 'refund_items',
55
- 'order_notes' => 'order_notes',
56
- 'download_permissions' => 'download_permissions'
57
- ));
1
+ <?php
2
+
3
+ if (!defined('ABSPATH')) {
4
+ exit;
5
+ }
6
+
7
+ return apply_filters('hf_csv_order_post_columns', array(
8
+ 'order_id' => 'order_id',
9
+ 'order_number' => 'order_number',
10
+ 'order_date' => 'order_date',
11
+ 'status' => 'status',
12
+ 'shipping_total' => 'shipping_total',
13
+ 'shipping_tax_total' => 'shipping_tax_total',
14
+ 'fee_total' => 'fee_total',
15
+ 'fee_tax_total' => 'fee_tax_total',
16
+ 'tax_total' => 'tax_total',
17
+ 'cart_discount' => 'cart_discount',
18
+ 'order_discount' => 'order_discount',
19
+ 'discount_total' => 'discount_total',
20
+ 'order_total' => 'order_total',
21
+ //'refunded_total' => 'refunded_total',
22
+ 'order_currency' => 'order_currency',
23
+ 'payment_method' => 'payment_method',
24
+ 'shipping_method' => 'shipping_method',
25
+ 'customer_id' => 'customer_id',
26
+ 'customer_user' => 'customer_user',
27
+ 'customer_email' => 'customer_email',
28
+ 'billing_first_name' => 'billing_first_name',
29
+ 'billing_last_name' => 'billing_last_name',
30
+ 'billing_company' => 'billing_company',
31
+ 'billing_email' => 'billing_email',
32
+ 'billing_phone' => 'billing_phone',
33
+ 'billing_address_1' => 'billing_address_1',
34
+ 'billing_address_2' => 'billing_address_2',
35
+ 'billing_postcode' => 'billing_postcode',
36
+ 'billing_city' => 'billing_city',
37
+ 'billing_state' => 'billing_state',
38
+ 'billing_country' => 'billing_country',
39
+ 'shipping_first_name' => 'shipping_first_name',
40
+ 'shipping_last_name' => 'shipping_last_name',
41
+ 'shipping_company' => 'shipping_company',
42
+ 'shipping_address_1' => 'shipping_address_1',
43
+ 'shipping_address_2' => 'shipping_address_2',
44
+ 'shipping_postcode' => 'shipping_postcode',
45
+ 'shipping_city' => 'shipping_city',
46
+ 'shipping_state' => 'shipping_state',
47
+ 'shipping_country' => 'shipping_country',
48
+ 'customer_note' => 'customer_note',
49
+ 'wt_import_key' => 'wt_import_key',
50
+ 'shipping_items' => 'shipping_items',
51
+ 'fee_items' => 'fee_items',
52
+ 'tax_items' => 'tax_items',
53
+ 'coupon_items' => 'coupon_items',
54
+ 'refund_items' => 'refund_items',
55
+ 'order_notes' => 'order_notes',
56
+ 'download_permissions' => 'download_permissions'
57
+ ));
admin/modules/order/data/data-wf-post-columns-coupon.php CHANGED
@@ -1,35 +1,35 @@
1
- <?php
2
- if ( ! defined( 'ABSPATH' ) ) {
3
- exit;
4
- }
5
-
6
- return apply_filters('coupon_csv_coupon_post_columns', array(
7
- 'post_title' => 'post_title',
8
- 'ID' => 'ID',
9
- 'post_excerpt' => 'post_excerpt',
10
- 'post_status' => 'post_status',
11
- 'post_date' => 'post_date',
12
- 'post_author' => 'post_author',
13
-
14
- // // Meta
15
- 'discount_type' => 'discount_type',
16
- 'coupon_amount' => 'coupon_amount',
17
- 'individual_use' => 'individual_use',
18
- 'product_ids' => 'product_ids',
19
- 'product_SKUs' => 'product_SKUs',
20
- 'exclude_product_ids' => 'exclude_product_ids',
21
- 'exclude_product_SKUs' => 'exclude_product_SKUs',
22
- 'usage_count' => 'usage_count',
23
- 'usage_limit' => 'usage_limit',
24
- 'usage_limit_per_user' => 'usage_limit_per_user',
25
- 'limit_usage_to_x_items' => 'limit_usage_to_x_items',
26
- 'expiry_date' => 'expiry_date',
27
- 'date_expires' => 'date_expires',
28
- 'free_shipping' => 'free_shipping',
29
- 'exclude_sale_items' => 'exclude_sale_items',
30
- 'product_categories' => 'product_categories',
31
- 'exclude_product_categories' => 'exclude_product_categories',
32
- 'minimum_amount' => 'minimum_amount',
33
- 'maximum_amount' => 'maximum_amount',
34
- 'customer_email' => 'customer_email',
35
  ) );
1
+ <?php
2
+ if ( ! defined( 'ABSPATH' ) ) {
3
+ exit;
4
+ }
5
+
6
+ return apply_filters('coupon_csv_coupon_post_columns', array(
7
+ 'post_title' => 'post_title',
8
+ 'ID' => 'ID',
9
+ 'post_excerpt' => 'post_excerpt',
10
+ 'post_status' => 'post_status',
11
+ 'post_date' => 'post_date',
12
+ 'post_author' => 'post_author',
13
+
14
+ // // Meta
15
+ 'discount_type' => 'discount_type',
16
+ 'coupon_amount' => 'coupon_amount',
17
+ 'individual_use' => 'individual_use',
18
+ 'product_ids' => 'product_ids',
19
+ 'product_SKUs' => 'product_SKUs',
20
+ 'exclude_product_ids' => 'exclude_product_ids',
21
+ 'exclude_product_SKUs' => 'exclude_product_SKUs',
22
+ 'usage_count' => 'usage_count',
23
+ 'usage_limit' => 'usage_limit',
24
+ 'usage_limit_per_user' => 'usage_limit_per_user',
25
+ 'limit_usage_to_x_items' => 'limit_usage_to_x_items',
26
+ 'expiry_date' => 'expiry_date',
27
+ 'date_expires' => 'date_expires',
28
+ 'free_shipping' => 'free_shipping',
29
+ 'exclude_sale_items' => 'exclude_sale_items',
30
+ 'product_categories' => 'product_categories',
31
+ 'exclude_product_categories' => 'exclude_product_categories',
32
+ 'minimum_amount' => 'minimum_amount',
33
+ 'maximum_amount' => 'maximum_amount',
34
+ 'customer_email' => 'customer_email',
35
  ) );
admin/modules/order/data/data-wf-post-subscription-columns.php CHANGED
@@ -1,87 +1,87 @@
1
- <?php
2
-
3
- if (!defined('ABSPATH')) {
4
- exit;
5
- }
6
-
7
- $columns = array(
8
- 'subscription_id' => 'subscription_id',
9
- 'subscription_status' => 'subscription_status',
10
- 'customer_id' => 'customer_id',
11
- 'customer_username' => 'customer_username',
12
- 'customer_email' => 'customer_email',
13
- 'date_created' => 'date_created',
14
- 'trial_end_date' => 'trial_end_date',
15
- 'next_payment_date' => 'next_payment_date',
16
- 'last_order_date_created' => 'last_order_date_created',
17
- 'end_date' => 'end_date',
18
- 'post_parent' => 'post_parent',
19
- 'billing_period' => 'billing_period',
20
- 'billing_interval' => 'billing_interval',
21
- 'order_shipping' => 'order_shipping',
22
- 'order_shipping_tax' => 'order_shipping_tax',
23
- 'fee_total' => 'fee_total',
24
- 'fee_tax_total' => 'fee_tax_total',
25
- 'order_tax' => 'order_tax',
26
- 'cart_discount' => 'cart_discount',
27
- 'cart_discount_tax' => 'cart_discount_tax',
28
- 'order_total' => 'order_total',
29
- 'order_currency' => 'order_currency',
30
- 'payment_method' => 'payment_method',
31
- 'payment_method_title' => 'payment_method_title',
32
- 'shipping_method' => 'shipping_method',
33
- 'billing_first_name' => 'billing_first_name',
34
- 'billing_last_name' => 'billing_last_name',
35
- 'billing_email' => 'billing_email',
36
- 'billing_phone' => 'billing_phone',
37
- 'billing_address_1' => 'billing_address_1',
38
- 'billing_address_2' => 'billing_address_2',
39
- 'billing_postcode' => 'billing_postcode',
40
- 'billing_city' => 'billing_city',
41
- 'billing_state' => 'billing_state',
42
- 'billing_country' => 'billing_country',
43
- 'billing_company' => 'billing_company',
44
- 'shipping_first_name' => 'shipping_first_name',
45
- 'shipping_last_name' => 'shipping_last_name',
46
- 'shipping_address_1' => 'shipping_address_1',
47
- 'shipping_address_2' => 'shipping_address_2',
48
- 'shipping_postcode' => 'shipping_postcode',
49
- 'shipping_city' => 'shipping_city',
50
- 'shipping_state' => 'shipping_state',
51
- 'shipping_country' => 'shipping_country',
52
- 'shipping_company' => 'shipping_company',
53
- 'customer_note' => 'customer_note',
54
- 'order_items' => 'order_items',
55
- 'order_notes' => 'order_notes',
56
- 'renewal_orders' => 'renewal_orders',
57
- 'shipping_items' => 'shipping_items',
58
- 'coupon_items' => 'coupon_items',
59
- 'fee_items' => 'fee_items',
60
- 'tax_items' => 'tax_items',
61
- 'download_permissions' => 'download_permissions'
62
- );
63
-
64
- global $wpdb;
65
-
66
- if(class_exists('HF_Subscription')){
67
- $post_type = 'hf_shop_subscription';
68
- } else {
69
- $post_type = 'shop_subscription';
70
- }
71
- $meta_keys = $wpdb->get_col($wpdb->prepare("SELECT DISTINCT pm.meta_key
72
- FROM {$wpdb->postmeta} AS pm
73
- LEFT JOIN {$wpdb->posts} AS p ON p.ID = pm.post_id
74
- WHERE p.post_type = %s
75
- AND pm.meta_key NOT IN ('_schedule_next_payment','_schedule_start','_schedule_end','_schedule_trial_end','_download_permissions_granted','_subscription_renewal_order_ids_cache','_subscription_resubscribe_order_ids_cache','_subscription_switch_order_ids_cache','_created_via','_customer_user')
76
- ORDER BY pm.meta_key",$post_type));
77
- foreach ($meta_keys as $meta_key) {
78
- if (empty($columns[$meta_key])) {
79
- if($meta_key[0] == '_' && empty($columns[substr($meta_key, 1)])){
80
- $columns['meta:'.$meta_key] = 'meta:'.$meta_key; // adding an extra prefix for identifying meta while import process
81
- } elseif($meta_key[0] != '_') {
82
- $columns['meta:'.$meta_key] = 'meta:'.$meta_key;
83
- }
84
- }
85
- }
86
-
87
  return apply_filters('hf_csv_subscription_order_header_columns',$columns);
1
+ <?php
2
+
3
+ if (!defined('ABSPATH')) {
4
+ exit;
5
+ }
6
+
7
+ $columns = array(
8
+ 'subscription_id' => 'subscription_id',
9
+ 'subscription_status' => 'subscription_status',
10
+ 'customer_id' => 'customer_id',
11
+ 'customer_username' => 'customer_username',
12
+ 'customer_email' => 'customer_email',
13
+ 'date_created' => 'date_created',
14
+ 'trial_end_date' => 'trial_end_date',
15
+ 'next_payment_date' => 'next_payment_date',
16
+ 'last_order_date_created' => 'last_order_date_created',
17
+ 'end_date' => 'end_date',
18
+ 'post_parent' => 'post_parent',
19
+ 'billing_period' => 'billing_period',
20
+ 'billing_interval' => 'billing_interval',
21
+ 'order_shipping' => 'order_shipping',
22
+ 'order_shipping_tax' => 'order_shipping_tax',
23
+ 'fee_total' => 'fee_total',
24
+ 'fee_tax_total' => 'fee_tax_total',
25
+ 'order_tax' => 'order_tax',
26
+ 'cart_discount' => 'cart_discount',
27
+ 'cart_discount_tax' => 'cart_discount_tax',
28
+ 'order_total' => 'order_total',
29
+ 'order_currency' => 'order_currency',
30
+ 'payment_method' => 'payment_method',
31
+ 'payment_method_title' => 'payment_method_title',
32
+ 'shipping_method' => 'shipping_method',
33
+ 'billing_first_name' => 'billing_first_name',
34
+ 'billing_last_name' => 'billing_last_name',
35
+ 'billing_email' => 'billing_email',
36
+ 'billing_phone' => 'billing_phone',
37
+ 'billing_address_1' => 'billing_address_1',
38
+ 'billing_address_2' => 'billing_address_2',
39
+ 'billing_postcode' => 'billing_postcode',
40
+ 'billing_city' => 'billing_city',
41
+ 'billing_state' => 'billing_state',
42
+ 'billing_country' => 'billing_country',
43
+ 'billing_company' => 'billing_company',
44
+ 'shipping_first_name' => 'shipping_first_name',
45
+ 'shipping_last_name' => 'shipping_last_name',
46
+ 'shipping_address_1' => 'shipping_address_1',
47
+ 'shipping_address_2' => 'shipping_address_2',
48
+ 'shipping_postcode' => 'shipping_postcode',
49
+ 'shipping_city' => 'shipping_city',
50
+ 'shipping_state' => 'shipping_state',
51
+ 'shipping_country' => 'shipping_country',
52
+ 'shipping_company' => 'shipping_company',
53
+ 'customer_note' => 'customer_note',
54
+ 'order_items' => 'order_items',
55
+ 'order_notes' => 'order_notes',
56
+ 'renewal_orders' => 'renewal_orders',
57
+ 'shipping_items' => 'shipping_items',
58
+ 'coupon_items' => 'coupon_items',
59
+ 'fee_items' => 'fee_items',
60
+ 'tax_items' => 'tax_items',
61
+ 'download_permissions' => 'download_permissions'
62
+ );
63
+
64
+ global $wpdb;
65
+
66
+ if(class_exists('HF_Subscription')){
67
+ $post_type = 'hf_shop_subscription';
68
+ } else {
69
+ $post_type = 'shop_subscription';
70
+ }
71
+ $meta_keys = $wpdb->get_col($wpdb->prepare("SELECT DISTINCT pm.meta_key
72
+ FROM {$wpdb->postmeta} AS pm
73
+ LEFT JOIN {$wpdb->posts} AS p ON p.ID = pm.post_id
74
+ WHERE p.post_type = %s
75
+ AND pm.meta_key NOT IN ('_schedule_next_payment','_schedule_start','_schedule_end','_schedule_trial_end','_download_permissions_granted','_subscription_renewal_order_ids_cache','_subscription_resubscribe_order_ids_cache','_subscription_switch_order_ids_cache','_created_via','_customer_user')
76
+ ORDER BY pm.meta_key",$post_type));
77
+ foreach ($meta_keys as $meta_key) {
78
+ if (empty($columns[$meta_key])) {
79
+ if($meta_key[0] == '_' && empty($columns[substr($meta_key, 1)])){
80
+ $columns['meta:'.$meta_key] = 'meta:'.$meta_key; // adding an extra prefix for identifying meta while import process
81
+ } elseif($meta_key[0] != '_') {
82
+ $columns['meta:'.$meta_key] = 'meta:'.$meta_key;
83
+ }
84
+ }
85
+ }
86
+
87
  return apply_filters('hf_csv_subscription_order_header_columns',$columns);
admin/modules/order/data/data-wf-xml-default-meta.php CHANGED
@@ -1,44 +1,44 @@
1
- <?php
2
- // Default meta columns for xml
3
- return apply_filters('hf_xml_order_default_meta_columns', array(
4
- '_billing_address_1' => '_billing_address_1',
5
- '_billing_address_2' => '_billing_address_2',
6
- '_billing_city' => '_billing_city',
7
- '_billing_company' => '_billing_company',
8
- '_billing_country' => '_billing_country',
9
- '_billing_email' => '_billing_email',
10
- '_billing_first_name' => '_billing_first_name',
11
- '_billing_last_name' => '_billing_last_name',
12
- '_billing_phone' => '_billing_phone',
13
- '_billing_postcode' => '_billing_postcode',
14
- '_billing_state' => '_billing_state',
15
- '_shipping_address_1' => '_shipping_address_1',
16
- '_shipping_address_2' => '_shipping_address_2',
17
- '_shipping_city' => '_shipping_city',
18
- '_shipping_company' => '_shipping_company',
19
- '_shipping_country' => '_shipping_country',
20
- '_shipping_first_name' => '_shipping_first_name',
21
- '_shipping_last_name' => '_shipping_last_name',
22
- '_shipping_method' => '_shipping_method',
23
- '_shipping_postcode' => '_shipping_postcode',
24
- '_shipping_state' => '_shipping_state',
25
- 'wf_order_exported_status' => 'wf_order_exported_status',
26
- '_payment_method' => '_payment_method',
27
- '_payment_method_title' => '_payment_method_title',
28
- '_completed_date' => '_completed_date',
29
- '_customer_email' => '_customer_email',
30
- '_fee_total' => '_fee_total',
31
- '_order_currency' => '_order_currency',
32
- '_order_total' => '_order_total',
33
- '_order_number' => '_order_number',
34
- '_cart_discount' => '_cart_discount',
35
- '_order_discount' => '_order_discount',
36
- '_discount_total' => '_discount_total',
37
- '_tax_total' => '_tax_total',
38
- '_date_completed' => '_date_completed',
39
- '_shipping_tax_total' => '_shipping_tax_total',
40
- '_paid_date' => '_paid_date',
41
- '_customer_user' => '_customer_user',
42
- '_order_shipping' => '_order_shipping',
43
- '_order_shipping_tax' => '_order_shipping_tax'));
44
-
1
+ <?php
2
+ // Default meta columns for xml
3
+ return apply_filters('hf_xml_order_default_meta_columns', array(
4
+ '_billing_address_1' => '_billing_address_1',
5
+ '_billing_address_2' => '_billing_address_2',
6
+ '_billing_city' => '_billing_city',
7
+ '_billing_company' => '_billing_company',
8
+ '_billing_country' => '_billing_country',
9
+ '_billing_email' => '_billing_email',
10
+ '_billing_first_name' => '_billing_first_name',
11
+ '_billing_last_name' => '_billing_last_name',
12
+ '_billing_phone' => '_billing_phone',
13
+ '_billing_postcode' => '_billing_postcode',
14
+ '_billing_state' => '_billing_state',
15
+ '_shipping_address_1' => '_shipping_address_1',
16
+ '_shipping_address_2' => '_shipping_address_2',
17
+ '_shipping_city' => '_shipping_city',
18
+ '_shipping_company' => '_shipping_company',
19
+ '_shipping_country' => '_shipping_country',
20
+ '_shipping_first_name' => '_shipping_first_name',
21
+ '_shipping_last_name' => '_shipping_last_name',
22
+ '_shipping_method' => '_shipping_method',
23
+ '_shipping_postcode' => '_shipping_postcode',
24
+ '_shipping_state' => '_shipping_state',
25
+ 'wf_order_exported_status' => 'wf_order_exported_status',
26
+ '_payment_method' => '_payment_method',
27
+ '_payment_method_title' => '_payment_method_title',
28
+ '_completed_date' => '_completed_date',
29
+ '_customer_email' => '_customer_email',
30
+ '_fee_total' => '_fee_total',
31
+ '_order_currency' => '_order_currency',
32
+ '_order_total' => '_order_total',
33
+ '_order_number' => '_order_number',
34
+ '_cart_discount' => '_cart_discount',
35
+ '_order_discount' => '_order_discount',
36
+ '_discount_total' => '_discount_total',
37
+ '_tax_total' => '_tax_total',
38
+ '_date_completed' => '_date_completed',
39
+ '_shipping_tax_total' => '_shipping_tax_total',
40
+ '_paid_date' => '_paid_date',
41
+ '_customer_user' => '_customer_user',
42
+ '_order_shipping' => '_order_shipping',
43
+ '_order_shipping_tax' => '_order_shipping_tax'));
44
+
admin/modules/order/data/data/data-wf-reserved-fields-pair.php CHANGED
@@ -1,54 +1,54 @@
1
- <?php
2
-
3
- // Reserved column names
4
- return apply_filters('woocommerce_csv_order_reserved_fields_pair',array(
5
- 'order_id' => array('title'=>'Order ID ','description'=>'Order ID '),
6
- 'order_number' => array('title'=>'Order Number','description'=>'Order Number'),
7
- 'order_date' => array('title'=>'Order Date','description'=>'Order Date', 'type' => 'date'),
8
- 'status' => array('title'=>'Order Status','description'=>'Order Status ( processing , pending ...) '),
9
- 'shipping_total' => array('title'=>'Shipping Total','description'=>'Shipping Total amount'),
10
- 'shipping_tax_total' => array('title'=>'Shipping Tax Total','description'=>'Shipping Tax Total'),
11
- 'fee_total' => array('title'=>'Total Fee','description'=>'Total Fee'),
12
- 'fee_tax_total' => array('title'=>'Total Tax Fee','description'=>'Total Tax Fee'),
13
- 'tax_total' => array('title'=>'Total Tax','description'=>'Total Tax'),
14
- 'cart_discount' => array('title'=>'Cart Discount','description'=>'Cart Discount'),
15
- 'order_discount' => array('title'=>'Order Discount','description'=>'Order Discount'),
16
- 'discount_total' => array('title'=>'Discount Total','description'=>'Discount Total'),
17
- 'order_total' => array('title'=>'Order Total','description'=>'Order Total'),
18
- //'refunded_total' => array('title'=>'refunded_total','description'=>'refunded_total'),
19
- 'order_currency' => array('title'=>'order_currency','description'=>'Order Currency'),
20
- 'payment_method' => array('title'=>'payment_method','description'=>'Payment Method'),
21
- 'shipping_method' => array('title'=>'shipping_method','description'=>'Shipping Method'),
22
- 'customer_email' => array('title'=>'customer_email','description'=>'Customer Email ( if not provided order will be created as Guest)'),
23
- 'customer_user' => array('title'=>'customer_user','description'=>'Customer id ( if not provided order will be created as Guest)'),
24
- 'billing_first_name' => array('title'=>'billing_first_name','description'=>'billing_first_name'),
25
- 'billing_last_name' => array('title'=>'billing_last_name','description'=>'billing_last_name'),
26
- 'billing_company' => array('title'=>'billing_company','description'=>'billing_company'),
27
- 'billing_email' => array('title'=>'billing_email','description'=>'billing_email'),
28
- 'billing_phone' => array('title'=>'billing_phone','description'=>'billing_phone'),
29
- 'billing_address_1' => array('title'=>'billing_address_1','description'=>'billing_address_1'),
30
- 'billing_address_2' => array('title'=>'billing_address_2','description'=>'billing_address_2'),
31
- 'billing_postcode' => array('title'=>'billing_postcode','description'=>'billing_postcode'),
32
- 'billing_city' => array('title'=>'billing_city','description'=>'billing_city'),
33
- 'billing_state' => array('title'=>'billing_state','description'=>'billing_state'),
34
- 'billing_country' => array('title'=>'billing_country','description'=>'billing_country'),
35
- 'shipping_first_name' => array('title'=>'shipping_first_name','description'=>'shipping_first_name'),
36
- 'shipping_last_name' => array('title'=>'shipping_last_name','description'=>'shipping_last_name'),
37
- 'shipping_company' => array('title'=>'shipping_company','description'=>'shipping_company'),
38
- 'shipping_address_1' => array('title'=>'shipping_address_1','description'=>'shipping_address_1'),
39
- 'shipping_address_2' => array('title'=>'shipping_address_2','description'=>'shipping_address_2'),
40
- 'shipping_postcode' => array('title'=>'shipping_postcode','description'=>'shipping_postcode'),
41
- 'shipping_city' => array('title'=>'shipping_city','description'=>'shipping_city'),
42
- 'shipping_state' => array('title'=>'shipping_state','description'=>'shipping_state'),
43
- 'shipping_country' => array('title'=>'shipping_country','description'=>'shipping_country'),
44
- 'customer_note' => array('title'=>'customer_note','description'=>'customer_note'),
45
- 'wt_import_key' => array('title'=>'wt_import_key','description'=>'wt_import_key'),
46
- 'shipping_items' => array('title'=>'shipping_items','description'=>'shipping_items'),
47
- 'fee_items' => array('title'=>'fee_items','description'=>'fee_items'),
48
- 'tax_items' => array('title'=>'tax_items','description'=>'tax_items'),
49
- 'coupon_items' => array('title'=>'coupon_items','description'=>'coupons'),
50
- 'refund_items' => array('title'=>'refund_items','description'=>'refund_items'),
51
- 'order_notes' => array('title'=>'order_notes','description'=>'Order notes'),
52
- 'line_item_' => array('title'=>'line_item_','description'=>'Line Items','field_type'=>'start_with'),
53
- 'download_permissions' => array('title'=>'Downloadable Product Permissions ','description'=>'Permissions for order items will automatically be granted when the order status changes to processing or completed.'),
54
  ));
1
+ <?php
2
+
3
+ // Reserved column names
4
+ return apply_filters('woocommerce_csv_order_reserved_fields_pair',array(
5
+ 'order_id' => array('title'=>'Order ID ','description'=>'Order ID '),
6
+ 'order_number' => array('title'=>'Order Number','description'=>'Order Number'),
7
+ 'order_date' => array('title'=>'Order Date','description'=>'Order Date', 'type' => 'date'),
8
+ 'status' => array('title'=>'Order Status','description'=>'Order Status ( processing , pending ...) '),
9
+ 'shipping_total' => array('title'=>'Shipping Total','description'=>'Shipping Total amount'),
10
+ 'shipping_tax_total' => array('title'=>'Shipping Tax Total','description'=>'Shipping Tax Total'),
11
+ 'fee_total' => array('title'=>'Total Fee','description'=>'Total Fee'),
12
+ 'fee_tax_total' => array('title'=>'Total Tax Fee','description'=>'Total Tax Fee'),
13
+ 'tax_total' => array('title'=>'Total Tax','description'=>'Total Tax'),
14
+ 'cart_discount' => array('title'=>'Cart Discount','description'=>'Cart Discount'),
15
+ 'order_discount' => array('title'=>'Order Discount','description'=>'Order Discount'),
16
+ 'discount_total' => array('title'=>'Discount Total','description'=>'Discount Total'),
17
+ 'order_total' => array('title'=>'Order Total','description'=>'Order Total'),
18
+ //'refunded_total' => array('title'=>'refunded_total','description'=>'refunded_total'),
19
+ 'order_currency' => array('title'=>'order_currency','description'=>'Order Currency'),
20
+ 'payment_method' => array('title'=>'payment_method','description'=>'Payment Method'),
21
+ 'shipping_method' => array('title'=>'shipping_method','description'=>'Shipping Method'),
22
+ 'customer_email' => array('title'=>'customer_email','description'=>'Customer Email ( if not provided order will be created as Guest)'),
23
+ 'customer_user' => array('title'=>'customer_user','description'=>'Customer id ( if not provided order will be created as Guest)'),
24
+ 'billing_first_name' => array('title'=>'billing_first_name','description'=>'billing_first_name'),
25
+ 'billing_last_name' => array('title'=>'billing_last_name','description'=>'billing_last_name'),
26
+ 'billing_company' => array('title'=>'billing_company','description'=>'billing_company'),
27
+ 'billing_email' => array('title'=>'billing_email','description'=>'billing_email'),
28
+ 'billing_phone' => array('title'=>'billing_phone','description'=>'billing_phone'),
29
+ 'billing_address_1' => array('title'=>'billing_address_1','description'=>'billing_address_1'),
30
+ 'billing_address_2' => array('title'=>'billing_address_2','description'=>'billing_address_2'),
31
+ 'billing_postcode' => array('title'=>'billing_postcode','description'=>'billing_postcode'),
32
+ 'billing_city' => array('title'=>'billing_city','description'=>'billing_city'),
33
+ 'billing_state' => array('title'=>'billing_state','description'=>'billing_state'),
34
+ 'billing_country' => array('title'=>'billing_country','description'=>'billing_country'),
35
+ 'shipping_first_name' => array('title'=>'shipping_first_name','description'=>'shipping_first_name'),
36
+ 'shipping_last_name' => array('title'=>'shipping_last_name','description'=>'shipping_last_name'),
37
+ 'shipping_company' => array('title'=>'shipping_company','description'=>'shipping_company'),
38
+ 'shipping_address_1' => array('title'=>'shipping_address_1','description'=>'shipping_address_1'),
39
+ 'shipping_address_2' => array('title'=>'shipping_address_2','description'=>'shipping_address_2'),
40
+ 'shipping_postcode' => array('title'=>'shipping_postcode','description'=>'shipping_postcode'),
41
+ 'shipping_city' => array('title'=>'shipping_city','description'=>'shipping_city'),
42
+ 'shipping_state' => array('title'=>'shipping_state','description'=>'shipping_state'),
43
+ 'shipping_country' => array('title'=>'shipping_country','description'=>'shipping_country'),
44
+ 'customer_note' => array('title'=>'customer_note','description'=>'customer_note'),
45
+ 'wt_import_key' => array('title'=>'wt_import_key','description'=>'wt_import_key'),
46
+ 'shipping_items' => array('title'=>'shipping_items','description'=>'shipping_items'),
47
+ 'fee_items' => array('title'=>'fee_items','description'=>'fee_items'),
48
+ 'tax_items' => array('title'=>'tax_items','description'=>'tax_items'),
49
+ 'coupon_items' => array('title'=>'coupon_items','description'=>'coupons'),
50
+ 'refund_items' => array('title'=>'refund_items','description'=>'refund_items'),
51
+ 'order_notes' => array('title'=>'order_notes','description'=>'Order notes'),
52
+ 'line_item_' => array('title'=>'line_item_','description'=>'Line Items','field_type'=>'start_with'),
53
+ 'download_permissions' => array('title'=>'Downloadable Product Permissions ','description'=>'Permissions for order items will automatically be granted when the order status changes to processing or completed.'),
54
  ));
admin/modules/order/export/export.php CHANGED
@@ -471,12 +471,14 @@ class Wt_Import_Export_For_Woo_Basic_Order_Export {
471
 
472
  // get tax items
473
  foreach ($order->get_tax_totals() as $tax_code => $tax) {
 
474
  $tax_items[] = implode('|', array(
475
  'rate_id:' . $tax->rate_id,
476
  'code:' . $tax_code,
477
  'total:' . wc_format_decimal($tax->amount, 2),
478
  'label:' . $tax->label,
479
  'tax_rate_compound:' . $tax->is_compound,
 
480
  ));
481
  }
482
 
471
 
472
  // get tax items
473
  foreach ($order->get_tax_totals() as $tax_code => $tax) {
474
+ $rate_percent = wc_get_order_item_meta( $tax->id, 'rate_percent', true ) ? wc_get_order_item_meta( $tax->id, 'rate_percent', true ):'';
475
  $tax_items[] = implode('|', array(
476
  'rate_id:' . $tax->rate_id,
477
  'code:' . $tax_code,
478
  'total:' . wc_format_decimal($tax->amount, 2),
479
  'label:' . $tax->label,
480
  'tax_rate_compound:' . $tax->is_compound,
481
+ 'rate_percent:'.$rate_percent,
482
  ));
483
  }
484
 
admin/modules/order/import/import.php CHANGED
@@ -875,6 +875,10 @@ class Wt_Import_Export_For_Woo_Basic_Order_Import {
875
  $tax_item_data['rate_id'] = 0;
876
  }
877
 
 
 
 
 
878
  // have a tax amount or shipping tax amount
879
  if (isset($tax_item_data['total']) || isset($tax_item_data['shipping_tax_amount'])) {
880
  // try and look up rate id by label if needed
@@ -922,6 +926,7 @@ class Wt_Import_Export_For_Woo_Basic_Order_Import {
922
  'compound' => $tax_item_data['tax_rate_compound'],
923
  'tax_amount' => $tax_item_data['total'],
924
  'shipping_tax_amount' => $tax_item_data['shipping_tax_amount'],
 
925
  );
926
  }
927
  }
@@ -1735,6 +1740,7 @@ class Wt_Import_Export_For_Woo_Basic_Order_Import {
1735
  wc_add_order_item_meta($tax_order_item_id, 'compound', $tax_item['compound']);
1736
  wc_add_order_item_meta($tax_order_item_id, 'tax_amount', $tax_item['tax_amount']);
1737
  wc_add_order_item_meta($tax_order_item_id, 'shipping_tax_amount', $tax_item['shipping_tax_amount']);
 
1738
  }
1739
  }
1740
  }
@@ -1832,7 +1838,7 @@ class Wt_Import_Export_For_Woo_Basic_Order_Import {
1832
  remove_action('woocommerce_order_status_refunded', array('WC_Emails', 'send_transactional_email'));
1833
  remove_action('woocommerce_order_partially_refunded', array('WC_Emails', 'send_transactional_email'));
1834
  remove_action('woocommerce_order_fully_refunded', array('WC_Emails', 'send_transactional_email'));
1835
- $this->wt_create_refund($args, $input_currency);
1836
  }
1837
  }
1838
 
@@ -1905,7 +1911,7 @@ class Wt_Import_Export_For_Woo_Basic_Order_Import {
1905
 
1906
 
1907
 
1908
- function wt_create_refund( $args = array(), $input_currency ) {
1909
 
1910
  $default_args = array(
1911
  'amount' => 0,
875
  $tax_item_data['rate_id'] = 0;
876
  }
877
 
878
+ if (!isset($tax_item_data['rate_percent'])) {
879
+ $tax_item_data['rate_percent'] = '';
880
+ }
881
+
882
  // have a tax amount or shipping tax amount
883
  if (isset($tax_item_data['total']) || isset($tax_item_data['shipping_tax_amount'])) {
884
  // try and look up rate id by label if needed
926
  'compound' => $tax_item_data['tax_rate_compound'],
927
  'tax_amount' => $tax_item_data['total'],
928
  'shipping_tax_amount' => $tax_item_data['shipping_tax_amount'],
929
+ 'rate_percent' => $tax_item_data['rate_percent'],
930
  );
931
  }
932
  }
1740
  wc_add_order_item_meta($tax_order_item_id, 'compound', $tax_item['compound']);
1741
  wc_add_order_item_meta($tax_order_item_id, 'tax_amount', $tax_item['tax_amount']);
1742
  wc_add_order_item_meta($tax_order_item_id, 'shipping_tax_amount', $tax_item['shipping_tax_amount']);
1743
+ wc_add_order_item_meta($tax_order_item_id, 'rate_percent', $tax_item['rate_percent']);
1744
  }
1745
  }
1746
  }
1838
  remove_action('woocommerce_order_status_refunded', array('WC_Emails', 'send_transactional_email'));
1839
  remove_action('woocommerce_order_partially_refunded', array('WC_Emails', 'send_transactional_email'));
1840
  remove_action('woocommerce_order_fully_refunded', array('WC_Emails', 'send_transactional_email'));
1841
+ $this->wt_create_refund($input_currency, $args);
1842
  }
1843
  }
1844
 
1911
 
1912
 
1913
 
1914
+ function wt_create_refund( $input_currency, $args = array() ) {
1915
 
1916
  $default_args = array(
1917
  'amount' => 0,
admin/modules/order/order.php CHANGED
@@ -439,6 +439,30 @@ class Wt_Import_Export_For_Woo_Basic_Order {
439
  )
440
  );
441
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
442
 
443
 
444
  foreach ($fields as $fieldk => $fieldv) {
439
  )
440
  );
441
 
442
+ $out['ord_link_using_sku'] = array(
443
+ 'label' => __("Link products using SKU instead of Product ID"),
444
+ 'type' => 'radio',
445
+ 'radio_fields' => array(
446
+ '1' => __('Yes'),
447
+ '0' => __('No')
448
+ ),
449
+ 'value' => '0',
450
+ 'field_name' => 'ord_link_using_sku',
451
+ 'help_text_conditional'=>array(
452
+ array(
453
+ 'help_text'=> __('Link the products associated with the imported orders by their SKU.'),
454
+ 'condition'=>array(
455
+ array('field'=>'wt_iew_ord_link_using_sku', 'value'=>1)
456
+ )
457
+ ),
458
+ array(
459
+ 'help_text'=> sprintf(__('Link the products associated with the imported orders by their Product ID. In case of a conflict with %sIDs of other existing post types%s the link cannot be established.'), '<b>', '</b>'),
460
+ 'condition'=>array(
461
+ array('field'=>'wt_iew_ord_link_using_sku', 'value'=>0)
462
+ )
463
+ )
464
+ ),
465
+ );
466
 
467
 
468
  foreach ($fields as $fieldk => $fieldv) {
admin/views/admin-settings-help.php CHANGED
@@ -10,7 +10,7 @@ if ( ! defined( 'WPINC' ) ) {
10
  </ul>
11
  <div class="wt_iew_sub_tab_container">
12
  <div class="wt_iew_sub_tab_content" data-id="help-links" style="display:block;">
13
- <h3><?php _e('Help Links'); ?></h3>
14
  <ul class="wf-help-links">
15
  <li>
16
  <img src="<?php echo WT_O_IEW_PLUGIN_URL;?>assets/images/documentation.png">
10
  </ul>
11
  <div class="wt_iew_sub_tab_container">
12
  <div class="wt_iew_sub_tab_content" data-id="help-links" style="display:block;">
13
+ <!--<h3><?php //_e('Help Links'); ?></h3>-->
14
  <ul class="wf-help-links">
15
  <li>
16
  <img src="<?php echo WT_O_IEW_PLUGIN_URL;?>assets/images/documentation.png">
helpers/class-wt-security-helper.php CHANGED
@@ -189,7 +189,7 @@ if(!class_exists('Wt_Iew_Sh'))
189
  */
190
  public static function check_role_access($plugin_id)
191
  {
192
- $roles = array('manage_options');
193
  $roles = apply_filters('wt_'.$plugin_id.'_alter_role_access_basic', $roles); //dynamic filter based on plugin id to alter roles
194
  $roles = (!is_array($roles) ? array() : $roles);
195
  $is_allowed = false;
189
  */
190
  public static function check_role_access($plugin_id)
191
  {
192
+ $roles = array('manage_options', 'shop_manager');
193
  $roles = apply_filters('wt_'.$plugin_id.'_alter_role_access_basic', $roles); //dynamic filter based on plugin id to alter roles
194
  $roles = (!is_array($roles) ? array() : $roles);
195
  $is_allowed = false;
includes/class-wt-import-export-for-woo.php CHANGED
@@ -80,7 +80,7 @@ class Wt_Import_Export_For_Woo_Basic {
80
  if ( defined( 'WT_O_IEW_VERSION' ) ) {
81
  $this->version = WT_O_IEW_VERSION;
82
  } else {
83
- $this->version = '2.0.0';
84
  }
85
  $this->plugin_name = 'wt-import-export-for-woo-basic';
86
 
80
  if ( defined( 'WT_O_IEW_VERSION' ) ) {
81
  $this->version = WT_O_IEW_VERSION;
82
  } else {
83
+ $this->version = '2.0.1';
84
  }
85
  $this->plugin_name = 'wt-import-export-for-woo-basic';
86
 
order-import-export-for-woocommerce.php CHANGED
@@ -6,7 +6,7 @@ Plugin URI: https://wordpress.org/plugins/order-import-export-for-woocommerce/
6
  Description: Export and Import Order detail including line items, From and To your WooCommerce Store.
7
  Author: WebToffee
8
  Author URI: https://www.webtoffee.com/product/woocommerce-order-coupon-subscription-export-import/
9
- Version: 2.0.0
10
  Text Domain: order-import-export-for-woocommerce
11
  WC tested up to: 5.2.2
12
  License: GPLv3
@@ -42,7 +42,7 @@ if ( ! defined( 'WT_IEW_DEBUG_BASIC' ) ) {
42
  * Start at version 1.0.0 and use SemVer - https://semver.org
43
  * Rename this for your plugin and update it as you release new versions.
44
  */
45
- define( 'WT_O_IEW_VERSION', '2.0.0' );
46
 
47
  /**
48
  * The code that runs during plugin activation.
@@ -167,6 +167,7 @@ function wt_order_import_export_for_woocommerce_update_message( $data, $response
167
  {
168
  if(isset( $data['upgrade_notice']))
169
  {
 
170
  printf(
171
  '<div class="update-message wt-update-message">%s</div>',
172
  $data['upgrade_notice']
@@ -175,6 +176,25 @@ function wt_order_import_export_for_woocommerce_update_message( $data, $response
175
  }
176
  add_action( 'in_plugin_update_message-order-import-export-for-woocommerce/order-import-export-for-woocommerce.php', 'wt_order_import_export_for_woocommerce_update_message', 10, 2 );
177
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
178
  // uninstall feedback catch
179
  include_once plugin_dir_path( __FILE__ ) . 'includes/class-wf-orderimpexp-plugin-uninstall-feedback.php';
180
 
6
  Description: Export and Import Order detail including line items, From and To your WooCommerce Store.
7
  Author: WebToffee
8
  Author URI: https://www.webtoffee.com/product/woocommerce-order-coupon-subscription-export-import/
9
+ Version: 2.0.1
10
  Text Domain: order-import-export-for-woocommerce
11
  WC tested up to: 5.2.2
12
  License: GPLv3
42
  * Start at version 1.0.0 and use SemVer - https://semver.org
43
  * Rename this for your plugin and update it as you release new versions.
44
  */
45
+ define( 'WT_O_IEW_VERSION', '2.0.1' );
46
 
47
  /**
48
  * The code that runs during plugin activation.
167
  {
168
  if(isset( $data['upgrade_notice']))
169
  {
170
+ add_action( 'admin_print_footer_scripts','wt_order_imex_basic_plugin_screen_update_js');
171
  printf(
172
  '<div class="update-message wt-update-message">%s</div>',
173
  $data['upgrade_notice']
176
  }
177
  add_action( 'in_plugin_update_message-order-import-export-for-woocommerce/order-import-export-for-woocommerce.php', 'wt_order_import_export_for_woocommerce_update_message', 10, 2 );
178
 
179
+ if(!function_exists('wt_order_imex_basic_plugin_screen_update_js'))
180
+ {
181
+ function wt_order_imex_basic_plugin_screen_update_js()
182
+ {
183
+ ?>
184
+ <script>
185
+ ( function( $ ){
186
+ var update_dv=$( '#order-import-export-for-woocommerce-update');
187
+ update_dv.find('.wt-update-message').next('p').remove();
188
+ update_dv.find('a.update-link:eq(0)').click(function(){
189
+ $('.wt-update-message').remove();
190
+ });
191
+ })( jQuery );
192
+ </script>
193
+ <?php
194
+ }
195
+ }
196
+
197
+
198
  // uninstall feedback catch
199
  include_once plugin_dir_path( __FILE__ ) . 'includes/class-wf-orderimpexp-plugin-uninstall-feedback.php';
200
 
readme.txt CHANGED
@@ -5,7 +5,7 @@ Tags: order export, order import, woocommerce export orders, woocommerce import
5
  Requires at least: 3.0.1
6
  Tested up to: 5.7
7
  Requires PHP: 5.6
8
- Stable tag: 2.0.0
9
  License: GPLv3
10
  License URI: http://www.gnu.org/licenses/gpl-3.0.html
11
 
@@ -26,7 +26,7 @@ The following are functionalities offered by the basic version of the plugin.
26
  &#128312; Import Subscription Orders from CSV file(Premium Feature).
27
  &#128312; Tested OK with WooCommerce 5.2.2
28
  &#128312; Tested OK with WP 5.7
29
- &#128312; Tested OK with PHP 7.3.5
30
 
31
  Additional features that will help you in the CSV export and import process:
32
 
@@ -187,18 +187,39 @@ Yes.
187
 
188
  == Screenshots ==
189
 
190
- 1. Order export advanced options
191
 
192
- 2. Order export filter options
193
 
194
  3. Order import advanced options
195
 
196
- 4. Order import finished
197
 
198
- 5. Sample order export CSV
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
199
 
200
  == Changelog ==
201
 
 
 
 
202
  = 2.0.0 =
203
  * Improved UI for better user experience
204
  * Export/Import options: via a pre-saved template or a quick(standard columns) export/import
@@ -409,12 +430,6 @@ Yes.
409
 
410
  == Upgrade Notice ==
411
 
412
- = 2.0.0 =
413
- * Improved UI for better user experience
414
- * Export/Import options: via a pre-saved template or a quick(standard columns) export/import
415
- * Option to export/import selective columns
416
- * Option to reorder columns during export
417
- * Import: Support for different types of delimiters
418
- * Export/Import options: Batch option with configurable batch count
419
- * History of all the Import/Export process
420
- * Dedicated logs for debugging failures
5
  Requires at least: 3.0.1
6
  Tested up to: 5.7
7
  Requires PHP: 5.6
8
+ Stable tag: 2.0.1
9
  License: GPLv3
10
  License URI: http://www.gnu.org/licenses/gpl-3.0.html
11
 
26
  &#128312; Import Subscription Orders from CSV file(Premium Feature).
27
  &#128312; Tested OK with WooCommerce 5.2.2
28
  &#128312; Tested OK with WP 5.7
29
+ &#128312; Tested OK with PHP 8.0
30
 
31
  Additional features that will help you in the CSV export and import process:
32
 
187
 
188
  == Screenshots ==
189
 
190
+ 1. Order export filter options
191
 
192
+ 2. Order export advanced options
193
 
194
  3. Order import advanced options
195
 
196
+ 4. Order quick import completed
197
 
198
+ 5. Order advanced import completed
199
+
200
+ 6. Exported order CSV
201
+
202
+ 7. Debug logs
203
+
204
+ 8. Import-export history
205
+
206
+ 9. Coupon export filters
207
+
208
+ 10. Coupon advanced export
209
+
210
+ 11. Coupon advanced import options
211
+
212
+ 12. Coupon quick import completed
213
+
214
+ 13. Coupon advanced import completed
215
+
216
+ 14. Exported coupon CSV
217
 
218
  == Changelog ==
219
 
220
+ = 2.0.1 =
221
+ * Tested OK with PHP 8.0
222
+ * Option to connect products using SKU when importing orders
223
  = 2.0.0 =
224
  * Improved UI for better user experience
225
  * Export/Import options: via a pre-saved template or a quick(standard columns) export/import
430
 
431
  == Upgrade Notice ==
432
 
433
+ = 2.0.1 =
434
+ * Tested OK with PHP 8.0
435
+ * Option to connect products using SKU when importing orders