Advanced Order Export For WooCommerce - Version 3.0.1

Version Description

  • 2019-07-22 =
  • Added product field "Product Name (main)" to export name of variable product (not name of variation!)
  • Added summary product fields to export discounts and refunds
  • Fixed bug - bulk exporting from orders page didn't work if you set date range filter at page "Export Now"
  • Fixed bug - it was impossible to add custom field at tab "User"
  • Fixed bug - filter "User roles" applied incorrectly
  • Fixed bug - filter "Item meta" showed wrong results if you tried to filter by different meta keys
Download this release

Release Info

Developer algol.plus
Plugin Icon 128x128 Advanced Order Export For WooCommerce
Version 3.0.1
Comparing to
See all releases

Code changes from version 3.0.0 to 3.0.1

Files changed (12) hide show
  1. assets/css/export.css +4 -0
  2. assets/js/export-fields.js +39 -0
  3. classes/admin/class-wc-order-export-manage.php +31 -1
  4. classes/admin/class-wc-order-export-settings.php +1 -0
  5. classes/admin/tabs/ajax/class-wc-order-export-ajax.php +4 -1
  6. classes/core/class-wc-order-export-data-extractor-ui.php +22 -2
  7. classes/core/class-wc-order-export-data-extractor.php +56 -18
  8. classes/formats/abstract-class-woe-formatter-plain-format.php +15 -0
  9. i18n/languages/woo-order-export-lite.pot +169 -153
  10. readme.txt +12 -1
  11. view/settings-form.php +7 -7
  12. woo-order-export-lite.php +2 -2
assets/css/export.css CHANGED
@@ -745,3 +745,7 @@ input.date {
745
  .add_form_tip {
746
  color: green;
747
  }
 
 
 
 
745
  .add_form_tip {
746
  color: green;
747
  }
748
+
749
+ .default-html-css-label {
750
+ display: block;
751
+ }
assets/js/export-fields.js CHANGED
@@ -1142,6 +1142,36 @@ jQuery( document ).ready( function ( $ ) {
1142
  return false;
1143
  } );
1144
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1145
  ///*CUSTOM FIELDS BINDS
1146
 
1147
  jQuery( 'input[name=custom_meta_order_mode]' ).change( function () {
@@ -1295,6 +1325,9 @@ jQuery( document ).ready( function ( $ ) {
1295
  var summary_report_fields = [];
1296
  summary_report_fields.push( $( '#products_unselected_segment input[value="plain_products_summary_report_total_qty"]' ).parents( 'li' ) );
1297
  summary_report_fields.push( $( '#products_unselected_segment input[value="plain_products_summary_report_total_amount"]' ).parents( 'li' ) );
 
 
 
1298
 
1299
  jQuery( '#manage_fields' ).toggleClass( 'summary-products-report', ! ! jQuery( this ).prop( 'checked' ) );
1300
 
@@ -1317,6 +1350,9 @@ jQuery( document ).ready( function ( $ ) {
1317
  // purge summary report fields before insert
1318
  $( '#order_fields input[value="plain_products_summary_report_total_qty"]' ).closest( '.mapping_row' ).remove();
1319
  $( '#order_fields input[value="plain_products_summary_report_total_amount"]' ).closest( '.mapping_row' ).remove();
 
 
 
1320
 
1321
  // insert summary report fields
1322
  jQuery.each( summary_report_fields, function ( i, value ) {
@@ -1350,6 +1386,9 @@ jQuery( document ).ready( function ( $ ) {
1350
  // purge summary report fields
1351
  $( '#order_fields input[value="plain_products_summary_report_total_qty"]' ).closest( '.mapping_row' ).remove();
1352
  $( '#order_fields input[value="plain_products_summary_report_total_amount"]' ).closest( '.mapping_row' ).remove();
 
 
 
1353
 
1354
  jQuery.each( summary_report_fields, function ( i, value ) {
1355
  $( value ).hide();
1142
  return false;
1143
  } );
1144
 
1145
+ jQuery('#button_custom_meta_users').click(function () {
1146
+ var label = jQuery('#select_custom_meta_user').val();
1147
+ var colname = jQuery('#colname_custom_meta_user').val();
1148
+ var format_field = jQuery('#format_custom_meta').val();
1149
+ if (!label) {
1150
+ //try custom text
1151
+ label = jQuery('#text_custom_meta_user').val();
1152
+ }
1153
+ if (!label) {
1154
+ alert(export_messages.empty_meta_key);
1155
+ jQuery('#select_custom_meta_user').focus();
1156
+ return false
1157
+ }
1158
+ if (!colname) {
1159
+ alert(export_messages.empty_column_name);
1160
+ jQuery('#colname_custom_meta_user').focus();
1161
+ return false
1162
+ }
1163
+
1164
+ var segment = jQuery('.segment_choice.active').attr('data-segment');
1165
+
1166
+ woe_add_custom_meta(jQuery("#" + segment + '_unselected_segment'), 'orders', output_format, label, colname, segment, format_field);
1167
+
1168
+ woe_reset_field_contorls();
1169
+
1170
+ jQuery(this).siblings('.button-cancel').trigger('click');
1171
+
1172
+ return false;
1173
+ });
1174
+
1175
  ///*CUSTOM FIELDS BINDS
1176
 
1177
  jQuery( 'input[name=custom_meta_order_mode]' ).change( function () {
1325
  var summary_report_fields = [];
1326
  summary_report_fields.push( $( '#products_unselected_segment input[value="plain_products_summary_report_total_qty"]' ).parents( 'li' ) );
1327
  summary_report_fields.push( $( '#products_unselected_segment input[value="plain_products_summary_report_total_amount"]' ).parents( 'li' ) );
1328
+ summary_report_fields.push( $( '#products_unselected_segment input[value="plain_products_summary_report_total_discount"]' ).parents( 'li' ) );
1329
+ summary_report_fields.push( $( '#products_unselected_segment input[value="plain_products_summary_report_total_refund_count"]' ).parents( 'li' ) );
1330
+ summary_report_fields.push( $( '#products_unselected_segment input[value="plain_products_summary_report_total_refund_amount"]' ).parents( 'li' ) );
1331
 
1332
  jQuery( '#manage_fields' ).toggleClass( 'summary-products-report', ! ! jQuery( this ).prop( 'checked' ) );
1333
 
1350
  // purge summary report fields before insert
1351
  $( '#order_fields input[value="plain_products_summary_report_total_qty"]' ).closest( '.mapping_row' ).remove();
1352
  $( '#order_fields input[value="plain_products_summary_report_total_amount"]' ).closest( '.mapping_row' ).remove();
1353
+ $( '#order_fields input[value="plain_products_summary_report_total_discount"]' ).closest( '.mapping_row' ).remove();
1354
+ $( '#order_fields input[value="plain_products_summary_report_total_refund_count"]' ).closest( '.mapping_row' ).remove();
1355
+ $( '#order_fields input[value="plain_products_summary_report_total_refund_amount"]' ).closest( '.mapping_row' ).remove();
1356
 
1357
  // insert summary report fields
1358
  jQuery.each( summary_report_fields, function ( i, value ) {
1386
  // purge summary report fields
1387
  $( '#order_fields input[value="plain_products_summary_report_total_qty"]' ).closest( '.mapping_row' ).remove();
1388
  $( '#order_fields input[value="plain_products_summary_report_total_amount"]' ).closest( '.mapping_row' ).remove();
1389
+ $( '#order_fields input[value="plain_products_summary_report_total_discount"]' ).closest( '.mapping_row' ).remove();
1390
+ $( '#order_fields input[value="plain_products_summary_report_total_refund_count"]' ).closest( '.mapping_row' ).remove();
1391
+ $( '#order_fields input[value="plain_products_summary_report_total_refund_amount"]' ).closest( '.mapping_row' ).remove();
1392
 
1393
  jQuery.each( summary_report_fields, function ( i, value ) {
1394
  $( value ).hide();
classes/admin/class-wc-order-export-manage.php CHANGED
@@ -168,7 +168,37 @@ class WC_Order_Export_Manage {
168
  return self::apply_defaults( $mode, $settings );
169
  }
170
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
171
  private static function get_defaults( $mode ) {
 
172
  return array(
173
  'version' => '2.0',
174
  'mode' => $mode,
@@ -266,7 +296,7 @@ class WC_Order_Export_Manage {
266
  'format_html_table_header_background_color' => '#FFFFFF',
267
  'format_html_table_row_text_color' => '#000000',
268
  'format_html_table_row_background_color' => '#FFFFFF',
269
- 'format_html_custom_css' => "",
270
 
271
  'all_products_from_order' => 1,
272
  'skip_refunded_items' => 1,
168
  return self::apply_defaults( $mode, $settings );
169
  }
170
 
171
+
172
+ public static function get_defaults_filters() {
173
+
174
+ return array(
175
+ 'statuses' => array(),
176
+ 'from_date' => '',
177
+ 'to_date' => '',
178
+ 'shipping_locations' => array(),
179
+ 'shipping_methods' => array(),
180
+ 'item_names' => array(),
181
+ 'item_metadata' => array(),
182
+ 'user_roles' => array(),
183
+ 'user_names' => array(),
184
+ 'user_custom_fields' => array(),
185
+ 'billing_locations' => array(),
186
+ 'payment_methods' => array(),
187
+ 'any_coupon_used' => 0,
188
+ 'coupons' => array(),
189
+ 'order_custom_fields' => array(),
190
+ 'product_categories' => array(),
191
+ 'product_vendors' => array(),
192
+ 'products' => array(),
193
+ 'product_taxonomies' => array(),
194
+ 'product_custom_fields' => array(),
195
+ 'product_attributes' => array(),
196
+ 'product_itemmeta' => array(),
197
+ );
198
+ }
199
+
200
  private static function get_defaults( $mode ) {
201
+ $settings = WC_Order_Export_Main_Settings::get_settings();
202
  return array(
203
  'version' => '2.0',
204
  'mode' => $mode,
296
  'format_html_table_header_background_color' => '#FFFFFF',
297
  'format_html_table_row_text_color' => '#000000',
298
  'format_html_table_row_background_color' => '#FFFFFF',
299
+ 'format_html_custom_css' => $settings['default_html_css'],
300
 
301
  'all_products_from_order' => 1,
302
  'skip_refunded_items' => 1,
classes/admin/class-wc-order-export-settings.php CHANGED
@@ -22,6 +22,7 @@ class WC_Order_Export_Main_Settings {
22
  'zapier_file_timeout' => 60,
23
  'show_date_time_picker_for_date_range' => false,
24
  'display_html_report_in_browser' => false,
 
25
  );
26
 
27
  return apply_filters( 'woe_get_main_settings', $settings );
22
  'zapier_file_timeout' => 60,
23
  'show_date_time_picker_for_date_range' => false,
24
  'display_html_report_in_browser' => false,
25
+ 'default_html_css' => '',
26
  );
27
 
28
  return apply_filters( 'woe_get_main_settings', $settings );
classes/admin/tabs/ajax/class-wc-order-export-ajax.php CHANGED
@@ -29,7 +29,10 @@ class WC_Order_Export_Ajax {
29
 
30
 
31
  public function ajax_export_download_bulk_file() {
32
- $this->build_and_send_file( $this->get_settings_from_bulk_request() );
 
 
 
33
  }
34
 
35
  protected function get_settings_from_bulk_request() {
29
 
30
 
31
  public function ajax_export_download_bulk_file() {
32
+
33
+ $settings = array_merge($this->get_settings_from_bulk_request(), WC_Order_Export_Manage::get_defaults_filters());
34
+
35
+ $this->build_and_send_file( $settings );
36
  }
37
 
38
  protected function get_settings_from_bulk_request() {
classes/core/class-wc-order-export-data-extractor-ui.php CHANGED
@@ -227,12 +227,12 @@ class WC_Order_Export_Data_Extractor_UI extends WC_Order_Export_Data_Extractor {
227
  public static function get_products_taxonomies_values( $key ) {
228
  $values = array();
229
  $terms = get_terms( array( 'taxonomy' => $key ) );
230
- if ( ! empty( $terms ) ) {
231
  $values = array_map( function ( $term ) {
232
  return $term->name;
233
  }, $terms );
 
234
  }
235
- sort( $values );
236
 
237
  return $values;
238
  }
@@ -356,6 +356,11 @@ class WC_Order_Export_Data_Extractor_UI extends WC_Order_Export_Data_Extractor {
356
  'checked' => 0,
357
  'format' => 'string',
358
  ),
 
 
 
 
 
359
  'variation_id' => array(
360
  'label' => __( 'Variation Id', 'woo-order-export-lite' ),
361
  'checked' => 0,
@@ -541,6 +546,21 @@ class WC_Order_Export_Data_Extractor_UI extends WC_Order_Export_Data_Extractor {
541
  'checked' => 0,
542
  'format' => 'image',
543
  ),
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
544
  );
545
 
546
  foreach ( $map as $key => $value ) {
227
  public static function get_products_taxonomies_values( $key ) {
228
  $values = array();
229
  $terms = get_terms( array( 'taxonomy' => $key ) );
230
+ if ( ! empty( $terms ) && ! is_wp_error( $terms ) ) {
231
  $values = array_map( function ( $term ) {
232
  return $term->name;
233
  }, $terms );
234
+ sort( $values );
235
  }
 
236
 
237
  return $values;
238
  }
356
  'checked' => 0,
357
  'format' => 'string',
358
  ),
359
+ 'product_name_main' => array(
360
+ 'label' => __( 'Product Name (main)', 'woo-order-export-lite' ),
361
+ 'checked' => 0,
362
+ 'format' => 'string',
363
+ ),
364
  'variation_id' => array(
365
  'label' => __( 'Variation Id', 'woo-order-export-lite' ),
366
  'checked' => 0,
546
  'checked' => 0,
547
  'format' => 'image',
548
  ),
549
+ 'summary_report_total_discount' => array(
550
+ 'label' => __( 'Summary Report Total Discount', 'woo-order-export-lite' ),
551
+ 'checked' => 0,
552
+ 'format' => 'money',
553
+ ),
554
+ 'summary_report_total_refund_count' => array(
555
+ 'label' => __( 'Summary Report Total Refund Count', 'woo-order-export-lite' ),
556
+ 'checked' => 0,
557
+ 'format' => 'number',
558
+ ),
559
+ 'summary_report_total_refund_amount' => array(
560
+ 'label' => __( 'Summary Report Total Refund Amount', 'woo-order-export-lite' ),
561
+ 'checked' => 0,
562
+ 'format' => 'money',
563
+ ),
564
  );
565
 
566
  foreach ( $map as $key => $value ) {
classes/core/class-wc-order-export-data-extractor.php CHANGED
@@ -692,35 +692,66 @@ class WC_Order_Export_Data_Extractor {
692
  // check item names ?
693
  if ( ! empty( $settings['item_names'] ) ) {
694
  $order_items_name_where = array();
 
 
 
 
 
695
  $filters = self::parse_complex_pairs( $settings['item_names'], array( 'coupon', 'fee', 'line_item', 'shipping', 'tax' ) );
696
  foreach ( $filters as $operator => $fields ) {
697
  foreach ( $fields as $field => $values ) {
698
  if ( $values ) {
699
  if ( $operator == 'IN' OR $operator == 'NOT IN' ) {
700
- $values = self::sql_subset( $values );
701
- $order_items_name_where[] = "(order_item_type='$field' AND order_item_name $operator ($values))";
 
 
 
 
 
 
 
702
  } elseif ( in_array( $operator, self::$operator_must_check_values ) ) {
 
703
  $pairs = array();
704
  foreach ( $values as $v ) {
705
- $pairs[] = self::operator_compare_field_and_value( "order_item_name", $operator, $v );
 
 
 
 
 
 
 
 
 
 
 
706
  }
707
- $pairs = join( "OR", $pairs );
708
- $order_items_name_where[] = "(order_item_type='$field' AND ({$pairs}))";
709
 
710
  }
 
 
 
711
  }//if values
712
  }
713
  }
714
 
715
  $order_items_name_where_sql = join( " OR ", $order_items_name_where );
716
- $where_item_names = " SELECT order_id FROM {$wpdb->prefix}woocommerce_order_items WHERE {$order_items_name_where_sql}";
 
 
 
717
 
718
  $order_items_where .= " AND orders.ID IN ($where_item_names)";
719
  }
720
 
721
  // check item metadata
722
  if ( ! empty( $settings['item_metadata'] ) ) {
723
- $order_items_metadata_where = array();
 
 
 
724
  $filters = self::parse_complex_pairs( $settings['item_metadata'] );
725
  foreach ( $filters as $operator => $fields ) {
726
  foreach ( $fields as $field => $values ) {
@@ -728,24 +759,29 @@ class WC_Order_Export_Data_Extractor {
728
  self::extract_item_type_and_key( $field, $type, $key );
729
  $key = esc_sql( $key );
730
  if ( $operator == 'IN' OR $operator == 'NOT IN' ) {
731
- $values = self::sql_subset( $values );
732
- $order_items_metadata_where[] = "(order_item_type='$type' AND meta_key='$key' AND meta_value $operator ($values))";
 
 
 
733
  } elseif ( in_array( $operator, self::$operator_must_check_values ) ) {
734
  $pairs = array();
735
  foreach ( $values as $v ) {
736
- $pairs[] = self::operator_compare_field_and_value( "meta_value", $operator, $v );
737
  }
738
- $pairs = join( "OR", $pairs );
739
- $order_items_metadata_where[] = "(order_item_type='$type' AND meta_key='$key' AND ({$pairs}))";
 
740
  }
 
 
 
741
  }//if values
742
  }
743
  }
744
 
745
- $order_items_metadata_where_sql = join( " OR ", $order_items_metadata_where );
746
- $where_item_metadata = " SELECT order_id FROM {$wpdb->prefix}woocommerce_order_items AS items
747
- JOIN {$wpdb->prefix}woocommerce_order_itemmeta AS meta ON meta.order_item_id = items.order_item_id
748
- WHERE {$order_items_metadata_where_sql}";
749
 
750
  $order_items_where .= " AND orders.ID IN ($where_item_metadata)";
751
  }
@@ -870,7 +906,7 @@ class WC_Order_Export_Data_Extractor {
870
 
871
  $roles_where = array();
872
  foreach ( $settings['user_roles'] as $role ) {
873
- $roles_where[] = "( usermeta_cf_role.meta_value LIKE '%$role%' )";
874
  }
875
  $user_meta_where[] = "(" . join( ' OR ', $roles_where ) . ")";
876
  }
@@ -1412,6 +1448,8 @@ class WC_Order_Export_Data_Extractor {
1412
  $row[ $field ] = $item["name"];
1413
  } elseif ( $field == 'product_name' ) {
1414
  $row[ $field ] = $product ? $product->get_name() : '';
 
 
1415
  } elseif ( $field == 'product_variation' ) {
1416
  $row[ $field ] = self::get_product_variation( $item, $order, $item_id, $product );
1417
  } elseif ( $field == 'seller' ) {
@@ -1502,7 +1540,7 @@ class WC_Order_Export_Data_Extractor {
1502
  $subtotal_amount = $item['line_subtotal'];
1503
  $subtotal_tax = $item['line_subtotal_tax'];
1504
  }
1505
- $row[ $field ] = ( $subtotal_amount > 0 ) ? round( 100 * $subtotal_tax / $subtotal_amount, 2 ) : 0;
1506
  } elseif ( $field == 'product_url' ) {
1507
  $row[ $field ] = get_permalink( $product_id );
1508
  } elseif ( $field == 'sku' ) {
692
  // check item names ?
693
  if ( ! empty( $settings['item_names'] ) ) {
694
  $order_items_name_where = array();
695
+
696
+ $order_items_name_joins = array();
697
+
698
+ $pos = 0;
699
+
700
  $filters = self::parse_complex_pairs( $settings['item_names'], array( 'coupon', 'fee', 'line_item', 'shipping', 'tax' ) );
701
  foreach ( $filters as $operator => $fields ) {
702
  foreach ( $fields as $field => $values ) {
703
  if ( $values ) {
704
  if ( $operator == 'IN' OR $operator == 'NOT IN' ) {
705
+
706
+ $values = self::sql_subset( $values );
707
+
708
+ if (!$pos) {
709
+ $order_items_name_where[] = "items.order_item_type='$field' AND items.order_item_name $operator ($values)";
710
+ } else {
711
+ $order_items_name_joins[] = "JOIN {$wpdb->prefix}woocommerce_order_items as items_{$pos} ON items.order_id = items_{$pos}.order_id AND items_{$pos}.order_item_type='$field' AND items_{$pos}.order_item_name $operator ($values)";
712
+
713
+ }
714
  } elseif ( in_array( $operator, self::$operator_must_check_values ) ) {
715
+
716
  $pairs = array();
717
  foreach ( $values as $v ) {
718
+ if (!$pos) {
719
+ $pairs[] = self::operator_compare_field_and_value( "items.order_item_name", $operator, $v );
720
+ } else {
721
+ $pairs[] = self::operator_compare_field_and_value( "items_{$pos}.order_item_name", $operator, $v );
722
+ }
723
+ }
724
+ $pairs = join( "OR", $pairs );
725
+
726
+ if (!$pos) {
727
+ $order_items_name_where[] = "items.order_item_type='$field' AND ({$pairs})";
728
+ } else {
729
+ $order_items_name_joins[] = "JOIN {$wpdb->prefix}woocommerce_order_items as items_{$pos} ON items.order_id = items_{$pos}.order_id AND items_{$pos}.order_item_type='$field' AND ({$pairs})";
730
  }
 
 
731
 
732
  }
733
+
734
+ $pos++;
735
+
736
  }//if values
737
  }
738
  }
739
 
740
  $order_items_name_where_sql = join( " OR ", $order_items_name_where );
741
+
742
+ $order_items_name_joins_sql = implode(' ', $order_items_name_joins);
743
+
744
+ $where_item_names = " SELECT items.order_id FROM {$wpdb->prefix}woocommerce_order_items as items {$order_items_name_joins_sql} WHERE {$order_items_name_where_sql}";
745
 
746
  $order_items_where .= " AND orders.ID IN ($where_item_names)";
747
  }
748
 
749
  // check item metadata
750
  if ( ! empty( $settings['item_metadata'] ) ) {
751
+
752
+ $order_items_metadata_joins = array();
753
+ $pos = 1;
754
+
755
  $filters = self::parse_complex_pairs( $settings['item_metadata'] );
756
  foreach ( $filters as $operator => $fields ) {
757
  foreach ( $fields as $field => $values ) {
759
  self::extract_item_type_and_key( $field, $type, $key );
760
  $key = esc_sql( $key );
761
  if ( $operator == 'IN' OR $operator == 'NOT IN' ) {
762
+
763
+ $values = self::sql_subset( $values );
764
+
765
+ $order_items_metadata_joins[] = "JOIN {$wpdb->prefix}woocommerce_order_itemmeta AS meta_{$pos} ON meta_{$pos}.order_item_id = items.order_item_id AND items.order_item_type='$type' AND meta_{$pos}.meta_key='$key' AND meta_{$pos}.meta_value $operator ($values)";
766
+
767
  } elseif ( in_array( $operator, self::$operator_must_check_values ) ) {
768
  $pairs = array();
769
  foreach ( $values as $v ) {
770
+ $pairs[] = self::operator_compare_field_and_value( "meta_{$pos}.meta_value", $operator, $v );
771
  }
772
+ $pairs = join( "OR", $pairs );
773
+
774
+ $order_items_metadata_joins[] = "JOIN {$wpdb->prefix}woocommerce_order_itemmeta AS meta_{$pos} ON meta_{$pos}.order_item_id = items.order_item_id AND items.order_item_type='$type' AND meta_{$pos}.meta_key='$key' AND ({$pairs})";
775
  }
776
+
777
+ $pos++;
778
+
779
  }//if values
780
  }
781
  }
782
 
783
+ $order_items_metadata_joins_sql = implode(' ', $order_items_metadata_joins);
784
+ $where_item_metadata = " SELECT order_id FROM {$wpdb->prefix}woocommerce_order_items AS items {$order_items_metadata_joins_sql}";
 
 
785
 
786
  $order_items_where .= " AND orders.ID IN ($where_item_metadata)";
787
  }
906
 
907
  $roles_where = array();
908
  foreach ( $settings['user_roles'] as $role ) {
909
+ $roles_where[] = "( usermeta_cf_role.meta_value LIKE '%\"$role\"%' )";
910
  }
911
  $user_meta_where[] = "(" . join( ' OR ', $roles_where ) . ")";
912
  }
1448
  $row[ $field ] = $item["name"];
1449
  } elseif ( $field == 'product_name' ) {
1450
  $row[ $field ] = $product ? $product->get_name() : '';
1451
+ } elseif ( $field == 'product_name_main' ) {
1452
+ $row[ $field ] = $product ? $product->get_title() : '';
1453
  } elseif ( $field == 'product_variation' ) {
1454
  $row[ $field ] = self::get_product_variation( $item, $order, $item_id, $product );
1455
  } elseif ( $field == 'seller' ) {
1540
  $subtotal_amount = $item['line_subtotal'];
1541
  $subtotal_tax = $item['line_subtotal_tax'];
1542
  }
1543
+ $row[ $field ] = ( $subtotal_amount <> 0 ) ? round( 100 * $subtotal_tax / $subtotal_amount, apply_filters('woe_tax_rate_rounding_precision', 2) ) : 0;
1544
  } elseif ( $field == 'product_url' ) {
1545
  $row[ $field ] = get_permalink( $product_id );
1546
  } elseif ( $field == 'sku' ) {
classes/formats/abstract-class-woe-formatter-plain-format.php CHANGED
@@ -286,6 +286,21 @@ abstract class WOE_Formatter_Plain_Format extends WOE_Formatter {
286
  'get_total' ) ? $product_item->get_total() : $product_item['line_total'];
287
  $_SESSION['woe_summary_products'][ $key ]['summary_report_total_amount'] += wc_round_tax_total( $total );
288
  }
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
289
  do_action( "woe_summary_products_add_item", $key, $product_item, $order );
290
  }
291
 
286
  'get_total' ) ? $product_item->get_total() : $product_item['line_total'];
287
  $_SESSION['woe_summary_products'][ $key ]['summary_report_total_amount'] += wc_round_tax_total( $total );
288
  }
289
+
290
+ if ( isset( $_SESSION['woe_summary_products'][ $key ]['summary_report_total_discount'] ) ) {
291
+ $total = $product_item->get_subtotal() - $product_item->get_total();
292
+ $_SESSION['woe_summary_products'][ $key ]['summary_report_total_discount'] += wc_round_tax_total( $total );
293
+ }
294
+
295
+ if ( isset( $_SESSION['woe_summary_products'][ $key ]['summary_report_total_refund_count'] ) ) {
296
+ $_SESSION['woe_summary_products'][ $key ]['summary_report_total_refund_count'] += abs( $order->get_qty_refunded_for_item($item_id) );
297
+ }
298
+
299
+ if ( isset( $_SESSION['woe_summary_products'][ $key ]['summary_report_total_refund_amount'] ) ) {
300
+ $total = $order->get_total_refunded_for_item($item_id);
301
+ $_SESSION['woe_summary_products'][ $key ]['summary_report_total_refund_amount'] += wc_round_tax_total( $total );
302
+ }
303
+
304
  do_action( "woe_summary_products_add_item", $key, $product_item, $order );
305
  }
306
 
i18n/languages/woo-order-export-lite.pot CHANGED
@@ -3,7 +3,7 @@ msgid ""
3
  msgstr ""
4
  "Project-Id-Version: Advanced Order Export For WooCommerce\n"
5
  "Report-Msgid-Bugs-To: \n"
6
- "POT-Creation-Date: 2019-07-03 07:56+0000\n"
7
  "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
8
  "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
9
  "Language-Team: \n"
@@ -35,22 +35,22 @@ msgid "Filter orders by"
35
  msgstr ""
36
 
37
  #: view/settings-form.php:116 view/settings-form.php:660
38
- #: classes/core/class-wc-order-export-data-extractor-ui.php:657
39
  msgid "Order Date"
40
  msgstr ""
41
 
42
  #: view/settings-form.php:123 view/settings-form.php:661
43
- #: classes/core/class-wc-order-export-data-extractor-ui.php:662
44
  msgid "Modification Date"
45
  msgstr ""
46
 
47
  #: view/settings-form.php:130
48
- #: classes/core/class-wc-order-export-data-extractor-ui.php:682
49
  msgid "Paid Date"
50
  msgstr ""
51
 
52
  #: view/settings-form.php:137
53
- #: classes/core/class-wc-order-export-data-extractor-ui.php:677
54
  msgid "Completed Date"
55
  msgstr ""
56
 
@@ -358,7 +358,7 @@ msgid "This option cancels UI settings(above) and don't applied to Preview"
358
  msgstr ""
359
 
360
  #: view/settings-form.php:602
361
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1165
362
  msgid "Date"
363
  msgstr ""
364
 
@@ -371,7 +371,7 @@ msgid "Time"
371
  msgstr ""
372
 
373
  #: view/settings-form.php:659
374
- #: classes/core/class-wc-order-export-data-extractor-ui.php:642
375
  msgid "Order ID"
376
  msgstr ""
377
 
@@ -541,9 +541,9 @@ msgid "Any coupon used"
541
  msgstr ""
542
 
543
  #: view/settings-form.php:1139
544
- #: classes/admin/class-wc-order-export-manage.php:654
545
- #: classes/core/class-wc-order-export-data-extractor-ui.php:945
546
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1152
547
  msgid "Coupons"
548
  msgstr ""
549
 
@@ -1041,7 +1041,7 @@ msgid "can not open for output"
1041
  msgstr ""
1042
 
1043
  #: classes/formats/class-woe-formatter-xls.php:132
1044
- #: classes/admin/class-wc-order-export-manage.php:205
1045
  msgid "Orders"
1046
  msgstr ""
1047
 
@@ -1073,9 +1073,9 @@ msgstr ""
1073
  msgid "Sat"
1074
  msgstr ""
1075
 
1076
- #: classes/admin/class-wc-order-export-manage.php:611
1077
- #: classes/core/class-wc-order-export-data-extractor-ui.php:933
1078
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1151
1079
  msgid "Products"
1080
  msgstr ""
1081
 
@@ -1104,562 +1104,578 @@ msgid "Product Name"
1104
  msgstr ""
1105
 
1106
  #: classes/core/class-wc-order-export-data-extractor-ui.php:360
1107
- msgid "Variation Id"
1108
  msgstr ""
1109
 
1110
  #: classes/core/class-wc-order-export-data-extractor-ui.php:365
1111
- msgid "Product Variation"
1112
  msgstr ""
1113
 
1114
  #: classes/core/class-wc-order-export-data-extractor-ui.php:370
1115
- msgid "Item Seller"
1116
  msgstr ""
1117
 
1118
  #: classes/core/class-wc-order-export-data-extractor-ui.php:375
1119
- msgid "Quantity"
1120
  msgstr ""
1121
 
1122
  #: classes/core/class-wc-order-export-data-extractor-ui.php:380
1123
- msgid "Quantity (- Refund)"
1124
  msgstr ""
1125
 
1126
  #: classes/core/class-wc-order-export-data-extractor-ui.php:385
1127
- msgid "Item Cost"
1128
  msgstr ""
1129
 
1130
  #: classes/core/class-wc-order-export-data-extractor-ui.php:390
1131
- msgid "Product Current Price"
1132
  msgstr ""
1133
 
1134
  #: classes/core/class-wc-order-export-data-extractor-ui.php:395
1135
- msgid "Order Line (w/o tax)"
1136
  msgstr ""
1137
 
1138
  #: classes/core/class-wc-order-export-data-extractor-ui.php:400
1139
- msgid "Order Line Tax"
1140
  msgstr ""
1141
 
1142
  #: classes/core/class-wc-order-export-data-extractor-ui.php:405
1143
- msgid "Order Line Tax Refunded"
1144
  msgstr ""
1145
 
1146
  #: classes/core/class-wc-order-export-data-extractor-ui.php:410
1147
- msgid "Order Line Tax (- Refund)"
1148
  msgstr ""
1149
 
1150
  #: classes/core/class-wc-order-export-data-extractor-ui.php:415
1151
- msgid "Order Line Subtotal"
1152
  msgstr ""
1153
 
1154
  #: classes/core/class-wc-order-export-data-extractor-ui.php:420
1155
- msgid "Order Line Subtotal Tax"
1156
  msgstr ""
1157
 
1158
  #: classes/core/class-wc-order-export-data-extractor-ui.php:425
1159
- msgid "Order Line Total"
1160
  msgstr ""
1161
 
1162
  #: classes/core/class-wc-order-export-data-extractor-ui.php:430
1163
- msgid "Order Line Total (include tax)"
1164
  msgstr ""
1165
 
1166
  #: classes/core/class-wc-order-export-data-extractor-ui.php:435
1167
- msgid "Order Line Total Refunded"
1168
  msgstr ""
1169
 
1170
  #: classes/core/class-wc-order-export-data-extractor-ui.php:440
1171
- msgid "Order Line Total (- Refund)"
1172
  msgstr ""
1173
 
1174
  #: classes/core/class-wc-order-export-data-extractor-ui.php:445
1175
- msgid "Item Discount Amount"
1176
  msgstr ""
1177
 
1178
  #: classes/core/class-wc-order-export-data-extractor-ui.php:450
1179
- msgid "Item Tax Rate"
1180
  msgstr ""
1181
 
1182
  #: classes/core/class-wc-order-export-data-extractor-ui.php:455
1183
- msgid "Type"
1184
  msgstr ""
1185
 
1186
  #: classes/core/class-wc-order-export-data-extractor-ui.php:460
1187
- msgid "Category"
1188
  msgstr ""
1189
 
1190
  #: classes/core/class-wc-order-export-data-extractor-ui.php:465
1191
- msgid "Tags"
1192
  msgstr ""
1193
 
1194
  #: classes/core/class-wc-order-export-data-extractor-ui.php:470
1195
- msgid "Width"
1196
  msgstr ""
1197
 
1198
  #: classes/core/class-wc-order-export-data-extractor-ui.php:475
1199
- msgid "Length"
1200
  msgstr ""
1201
 
1202
  #: classes/core/class-wc-order-export-data-extractor-ui.php:480
1203
- msgid "Height"
1204
  msgstr ""
1205
 
1206
  #: classes/core/class-wc-order-export-data-extractor-ui.php:485
1207
- msgid "Weight"
1208
  msgstr ""
1209
 
1210
  #: classes/core/class-wc-order-export-data-extractor-ui.php:490
1211
- msgid "Product URL"
1212
  msgstr ""
1213
 
1214
  #: classes/core/class-wc-order-export-data-extractor-ui.php:495
1215
- msgid "Download URL"
1216
  msgstr ""
1217
 
1218
  #: classes/core/class-wc-order-export-data-extractor-ui.php:500
1219
- msgid "Item download URL"
1220
  msgstr ""
1221
 
1222
  #: classes/core/class-wc-order-export-data-extractor-ui.php:505
1223
- msgid "Image URL"
1224
  msgstr ""
1225
 
1226
  #: classes/core/class-wc-order-export-data-extractor-ui.php:510
1227
- msgid "Product Shipping Class"
1228
  msgstr ""
1229
 
1230
  #: classes/core/class-wc-order-export-data-extractor-ui.php:515
1231
- msgid "Description"
1232
  msgstr ""
1233
 
1234
  #: classes/core/class-wc-order-export-data-extractor-ui.php:520
1235
- msgid "Short Description"
1236
  msgstr ""
1237
 
1238
  #: classes/core/class-wc-order-export-data-extractor-ui.php:525
1239
- msgid "Full names for categories"
1240
  msgstr ""
1241
 
1242
  #: classes/core/class-wc-order-export-data-extractor-ui.php:530
1243
- msgid "Summary Report Total Quantity"
1244
  msgstr ""
1245
 
1246
  #: classes/core/class-wc-order-export-data-extractor-ui.php:535
1247
- msgid "Summary Report Total Amount"
1248
  msgstr ""
1249
 
1250
  #: classes/core/class-wc-order-export-data-extractor-ui.php:540
 
 
 
 
1251
  msgid "Embedded Product Image"
1252
  msgstr ""
1253
 
1254
- #: classes/core/class-wc-order-export-data-extractor-ui.php:557
 
 
 
 
 
 
 
 
 
 
 
 
1255
  msgid "Coupon Code"
1256
  msgstr ""
1257
 
1258
- #: classes/core/class-wc-order-export-data-extractor-ui.php:562
1259
  msgid "Discount Amount"
1260
  msgstr ""
1261
 
1262
- #: classes/core/class-wc-order-export-data-extractor-ui.php:567
1263
  msgid "Discount Amount Tax"
1264
  msgstr ""
1265
 
1266
- #: classes/core/class-wc-order-export-data-extractor-ui.php:572
1267
  msgid "Discount Amount + Tax"
1268
  msgstr ""
1269
 
1270
- #: classes/core/class-wc-order-export-data-extractor-ui.php:577
1271
  msgid "Coupon Description"
1272
  msgstr ""
1273
 
1274
- #: classes/core/class-wc-order-export-data-extractor-ui.php:581
1275
  msgid "Coupon Type"
1276
  msgstr ""
1277
 
1278
- #: classes/core/class-wc-order-export-data-extractor-ui.php:586
1279
  msgid "Coupon Amount"
1280
  msgstr ""
1281
 
1282
- #: classes/core/class-wc-order-export-data-extractor-ui.php:637
1283
  msgid "Line number"
1284
  msgstr ""
1285
 
1286
- #: classes/core/class-wc-order-export-data-extractor-ui.php:647
1287
  msgid "Order Number"
1288
  msgstr ""
1289
 
1290
- #: classes/core/class-wc-order-export-data-extractor-ui.php:652
1291
  msgid "Order Status"
1292
  msgstr ""
1293
 
1294
- #: classes/core/class-wc-order-export-data-extractor-ui.php:667
1295
  msgid "Transaction ID"
1296
  msgstr ""
1297
 
1298
- #: classes/core/class-wc-order-export-data-extractor-ui.php:672
1299
  msgid "Currency"
1300
  msgstr ""
1301
 
1302
- #: classes/core/class-wc-order-export-data-extractor-ui.php:687
1303
  msgid "Date of first refund"
1304
  msgstr ""
1305
 
1306
- #: classes/core/class-wc-order-export-data-extractor-ui.php:692
1307
  msgid "Customer Note"
1308
  msgstr ""
1309
 
1310
- #: classes/core/class-wc-order-export-data-extractor-ui.php:697
1311
  msgid "Order Notes"
1312
  msgstr ""
1313
 
1314
- #: classes/core/class-wc-order-export-data-extractor-ui.php:702
1315
  msgid "Link to edit order"
1316
  msgstr ""
1317
 
1318
- #: classes/core/class-wc-order-export-data-extractor-ui.php:712
1319
  msgid "Customer IP address"
1320
  msgstr ""
1321
 
1322
- #: classes/core/class-wc-order-export-data-extractor-ui.php:717
1323
  msgid "Customer User ID"
1324
  msgstr ""
1325
 
1326
- #: classes/core/class-wc-order-export-data-extractor-ui.php:722
1327
  msgid "Customer Username"
1328
  msgstr ""
1329
 
1330
- #: classes/core/class-wc-order-export-data-extractor-ui.php:727
1331
  msgid "User Website"
1332
  msgstr ""
1333
 
1334
- #: classes/core/class-wc-order-export-data-extractor-ui.php:732
1335
  msgid "Customer User Email"
1336
  msgstr ""
1337
 
1338
- #: classes/core/class-wc-order-export-data-extractor-ui.php:737
1339
  msgid "Customer Role"
1340
  msgstr ""
1341
 
1342
- #: classes/core/class-wc-order-export-data-extractor-ui.php:742
1343
  msgid "Customer Total Orders"
1344
  msgstr ""
1345
 
1346
- #: classes/core/class-wc-order-export-data-extractor-ui.php:747
1347
  msgid "Customer first order date"
1348
  msgstr ""
1349
 
1350
- #: classes/core/class-wc-order-export-data-extractor-ui.php:752
1351
  msgid "Customer last order date"
1352
  msgstr ""
1353
 
1354
- #: classes/core/class-wc-order-export-data-extractor-ui.php:762
1355
  msgid "First Name (Billing)"
1356
  msgstr ""
1357
 
1358
- #: classes/core/class-wc-order-export-data-extractor-ui.php:767
1359
  msgid "Last Name (Billing)"
1360
  msgstr ""
1361
 
1362
- #: classes/core/class-wc-order-export-data-extractor-ui.php:772
1363
  msgid "Full Name (Billing)"
1364
  msgstr ""
1365
 
1366
- #: classes/core/class-wc-order-export-data-extractor-ui.php:777
1367
  msgid "Company (Billing)"
1368
  msgstr ""
1369
 
1370
- #: classes/core/class-wc-order-export-data-extractor-ui.php:782
1371
  msgid "Address 1&2 (Billing)"
1372
  msgstr ""
1373
 
1374
- #: classes/core/class-wc-order-export-data-extractor-ui.php:787
1375
  msgid "Address 1 (Billing)"
1376
  msgstr ""
1377
 
1378
- #: classes/core/class-wc-order-export-data-extractor-ui.php:792
1379
  msgid "Address 2 (Billing)"
1380
  msgstr ""
1381
 
1382
- #: classes/core/class-wc-order-export-data-extractor-ui.php:797
1383
  msgid "City (Billing)"
1384
  msgstr ""
1385
 
1386
- #: classes/core/class-wc-order-export-data-extractor-ui.php:802
1387
  msgid "State Code (Billing)"
1388
  msgstr ""
1389
 
1390
- #: classes/core/class-wc-order-export-data-extractor-ui.php:807
1391
  msgid "City, State, Zip (Billing)"
1392
  msgstr ""
1393
 
1394
- #: classes/core/class-wc-order-export-data-extractor-ui.php:812
1395
  msgid "City, State Zip (Billing)"
1396
  msgstr ""
1397
 
1398
- #: classes/core/class-wc-order-export-data-extractor-ui.php:817
1399
  msgid "State Name (Billing)"
1400
  msgstr ""
1401
 
1402
- #: classes/core/class-wc-order-export-data-extractor-ui.php:822
1403
  msgid "Postcode (Billing)"
1404
  msgstr ""
1405
 
1406
- #: classes/core/class-wc-order-export-data-extractor-ui.php:827
1407
  msgid "Country Code (Billing)"
1408
  msgstr ""
1409
 
1410
- #: classes/core/class-wc-order-export-data-extractor-ui.php:832
1411
  msgid "Country Name (Billing)"
1412
  msgstr ""
1413
 
1414
- #: classes/core/class-wc-order-export-data-extractor-ui.php:837
1415
  msgid "Email (Billing)"
1416
  msgstr ""
1417
 
1418
- #: classes/core/class-wc-order-export-data-extractor-ui.php:842
1419
  msgid "Phone (Billing)"
1420
  msgstr ""
1421
 
1422
- #: classes/core/class-wc-order-export-data-extractor-ui.php:852
1423
  msgid "First Name (Shipping)"
1424
  msgstr ""
1425
 
1426
- #: classes/core/class-wc-order-export-data-extractor-ui.php:857
1427
  msgid "Last Name (Shipping)"
1428
  msgstr ""
1429
 
1430
- #: classes/core/class-wc-order-export-data-extractor-ui.php:862
1431
  msgid "Full Name (Shipping)"
1432
  msgstr ""
1433
 
1434
- #: classes/core/class-wc-order-export-data-extractor-ui.php:867
1435
  msgid "Company (Shipping)"
1436
  msgstr ""
1437
 
1438
- #: classes/core/class-wc-order-export-data-extractor-ui.php:872
1439
  msgid "Address 1&2 (Shipping)"
1440
  msgstr ""
1441
 
1442
- #: classes/core/class-wc-order-export-data-extractor-ui.php:877
1443
  msgid "Address 1 (Shipping)"
1444
  msgstr ""
1445
 
1446
- #: classes/core/class-wc-order-export-data-extractor-ui.php:882
1447
  msgid "Address 2 (Shipping)"
1448
  msgstr ""
1449
 
1450
- #: classes/core/class-wc-order-export-data-extractor-ui.php:887
1451
  msgid "City (Shipping)"
1452
  msgstr ""
1453
 
1454
- #: classes/core/class-wc-order-export-data-extractor-ui.php:892
1455
  msgid "State Code (Shipping)"
1456
  msgstr ""
1457
 
1458
- #: classes/core/class-wc-order-export-data-extractor-ui.php:897
1459
  msgid "City, State, Zip (Shipping)"
1460
  msgstr ""
1461
 
1462
- #: classes/core/class-wc-order-export-data-extractor-ui.php:902
1463
  msgid "City, State Zip (Shipping)"
1464
  msgstr ""
1465
 
1466
- #: classes/core/class-wc-order-export-data-extractor-ui.php:907
1467
  msgid "State Name (Shipping)"
1468
  msgstr ""
1469
 
1470
- #: classes/core/class-wc-order-export-data-extractor-ui.php:912
1471
  msgid "Postcode (Shipping)"
1472
  msgstr ""
1473
 
1474
- #: classes/core/class-wc-order-export-data-extractor-ui.php:917
1475
  msgid "Country Code (Shipping)"
1476
  msgstr ""
1477
 
1478
- #: classes/core/class-wc-order-export-data-extractor-ui.php:922
1479
  msgid "Country Name (Shipping)"
1480
  msgstr ""
1481
 
1482
- #: classes/core/class-wc-order-export-data-extractor-ui.php:956
1483
  msgid "Shipping Method Title"
1484
  msgstr ""
1485
 
1486
- #: classes/core/class-wc-order-export-data-extractor-ui.php:961
1487
  msgid "Shipping Method"
1488
  msgstr ""
1489
 
1490
- #: classes/core/class-wc-order-export-data-extractor-ui.php:966
1491
  msgid "Shipping Method (no id)"
1492
  msgstr ""
1493
 
1494
- #: classes/core/class-wc-order-export-data-extractor-ui.php:971
1495
  msgid "Payment Method Title"
1496
  msgstr ""
1497
 
1498
- #: classes/core/class-wc-order-export-data-extractor-ui.php:976
1499
  msgid "Payment Method"
1500
  msgstr ""
1501
 
1502
- #: classes/core/class-wc-order-export-data-extractor-ui.php:981
1503
  msgid "Coupons Used"
1504
  msgstr ""
1505
 
1506
- #: classes/core/class-wc-order-export-data-extractor-ui.php:986
1507
  msgid "Cart Discount Amount"
1508
  msgstr ""
1509
 
1510
- #: classes/core/class-wc-order-export-data-extractor-ui.php:991
1511
  msgid "Cart Discount Amount Tax"
1512
  msgstr ""
1513
 
1514
- #: classes/core/class-wc-order-export-data-extractor-ui.php:996
1515
  msgid "Order Subtotal Amount"
1516
  msgstr ""
1517
 
1518
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1001
1519
  msgid "Order Subtotal - Cart Discount"
1520
  msgstr ""
1521
 
1522
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1006
1523
  msgid "Order Subtotal Amount Refunded"
1524
  msgstr ""
1525
 
1526
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1011
1527
  msgid "Order Subtotal Amount (- Refund)"
1528
  msgstr ""
1529
 
1530
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1016
1531
  msgid "Order Tax Amount"
1532
  msgstr ""
1533
 
1534
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1026
1535
  msgid "Order Shipping Amount"
1536
  msgstr ""
1537
 
1538
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1031
1539
  msgid "Order Shipping + Tax Amount"
1540
  msgstr ""
1541
 
1542
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1036
1543
  msgid "Order Shipping Amount Refunded"
1544
  msgstr ""
1545
 
1546
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1041
1547
  msgid "Order Shipping Amount (- Refund)"
1548
  msgstr ""
1549
 
1550
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1046
1551
  msgid "Order Shipping Tax Amount"
1552
  msgstr ""
1553
 
1554
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1051
1555
  msgid "Order Shipping Tax Refunded"
1556
  msgstr ""
1557
 
1558
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1056
1559
  msgid "Order Shipping Tax Amount (- Refund)"
1560
  msgstr ""
1561
 
1562
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1066
1563
  msgid "Order Total Fee"
1564
  msgstr ""
1565
 
1566
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1071
1567
  msgid "Order Refund Amount"
1568
  msgstr ""
1569
 
1570
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1076
1571
  msgid "Order Total Amount (- Refund)"
1572
  msgstr ""
1573
 
1574
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1081
1575
  msgid "Order Total Amount"
1576
  msgstr ""
1577
 
1578
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1086
1579
  msgid "Order Total Amount without Tax"
1580
  msgstr ""
1581
 
1582
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1091
1583
  msgid "Order Total Tax Amount"
1584
  msgstr ""
1585
 
1586
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1096
1587
  msgid "Order Total Tax Amount Refunded"
1588
  msgstr ""
1589
 
1590
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1101
1591
  msgid "Order Total Tax Amount (- Refund)"
1592
  msgstr ""
1593
 
1594
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1111
1595
  msgid "Total weight"
1596
  msgstr ""
1597
 
1598
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1116
1599
  msgid "Total items"
1600
  msgstr ""
1601
 
1602
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1121
1603
  msgid "Exported items"
1604
  msgstr ""
1605
 
1606
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1126
1607
  msgid "Total products"
1608
  msgstr ""
1609
 
1610
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1147
1611
  msgid "Common"
1612
  msgstr ""
1613
 
1614
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1148
1615
  msgid "User"
1616
  msgstr ""
1617
 
1618
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1149
1619
  msgid "Billing Address"
1620
  msgstr ""
1621
 
1622
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1150
1623
  msgid "Shipping Address"
1624
  msgstr ""
1625
 
1626
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1153
1627
  msgid "Cart"
1628
  msgstr ""
1629
 
1630
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1154
1631
  msgid "Shipping"
1632
  msgstr ""
1633
 
1634
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1155
1635
  msgid "Totals"
1636
  msgstr ""
1637
 
1638
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1156
1639
  msgid "Others"
1640
  msgstr ""
1641
 
1642
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1162
1643
  msgid "String"
1644
  msgstr ""
1645
 
1646
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1163
1647
  msgid "Money"
1648
  msgstr ""
1649
 
1650
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1164
1651
  msgid "Number"
1652
  msgstr ""
1653
 
1654
- #: classes/core/class-wc-order-export-data-extractor-ui.php:1166
1655
  msgid "Image"
1656
  msgstr ""
1657
 
1658
- #: classes/core/class-wc-order-export-data-extractor.php:1957
1659
  msgid "Edit order"
1660
  msgstr ""
1661
 
1662
- #: classes/core/class-wc-order-export-data-extractor.php:2139
1663
  msgid "[Rest of the World]"
1664
  msgstr ""
1665
 
3
  msgstr ""
4
  "Project-Id-Version: Advanced Order Export For WooCommerce\n"
5
  "Report-Msgid-Bugs-To: \n"
6
+ "POT-Creation-Date: 2019-07-18 12:31+0000\n"
7
  "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
8
  "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
9
  "Language-Team: \n"
35
  msgstr ""
36
 
37
  #: view/settings-form.php:116 view/settings-form.php:660
38
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:677
39
  msgid "Order Date"
40
  msgstr ""
41
 
42
  #: view/settings-form.php:123 view/settings-form.php:661
43
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:682
44
  msgid "Modification Date"
45
  msgstr ""
46
 
47
  #: view/settings-form.php:130
48
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:702
49
  msgid "Paid Date"
50
  msgstr ""
51
 
52
  #: view/settings-form.php:137
53
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:697
54
  msgid "Completed Date"
55
  msgstr ""
56
 
358
  msgstr ""
359
 
360
  #: view/settings-form.php:602
361
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1185
362
  msgid "Date"
363
  msgstr ""
364
 
371
  msgstr ""
372
 
373
  #: view/settings-form.php:659
374
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:662
375
  msgid "Order ID"
376
  msgstr ""
377
 
541
  msgstr ""
542
 
543
  #: view/settings-form.php:1139
544
+ #: classes/admin/class-wc-order-export-manage.php:684
545
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:965
546
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1172
547
  msgid "Coupons"
548
  msgstr ""
549
 
1041
  msgstr ""
1042
 
1043
  #: classes/formats/class-woe-formatter-xls.php:132
1044
+ #: classes/admin/class-wc-order-export-manage.php:235
1045
  msgid "Orders"
1046
  msgstr ""
1047
 
1073
  msgid "Sat"
1074
  msgstr ""
1075
 
1076
+ #: classes/admin/class-wc-order-export-manage.php:641
1077
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:953
1078
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1171
1079
  msgid "Products"
1080
  msgstr ""
1081
 
1104
  msgstr ""
1105
 
1106
  #: classes/core/class-wc-order-export-data-extractor-ui.php:360
1107
+ msgid "Product Name (main)"
1108
  msgstr ""
1109
 
1110
  #: classes/core/class-wc-order-export-data-extractor-ui.php:365
1111
+ msgid "Variation Id"
1112
  msgstr ""
1113
 
1114
  #: classes/core/class-wc-order-export-data-extractor-ui.php:370
1115
+ msgid "Product Variation"
1116
  msgstr ""
1117
 
1118
  #: classes/core/class-wc-order-export-data-extractor-ui.php:375
1119
+ msgid "Item Seller"
1120
  msgstr ""
1121
 
1122
  #: classes/core/class-wc-order-export-data-extractor-ui.php:380
1123
+ msgid "Quantity"
1124
  msgstr ""
1125
 
1126
  #: classes/core/class-wc-order-export-data-extractor-ui.php:385
1127
+ msgid "Quantity (- Refund)"
1128
  msgstr ""
1129
 
1130
  #: classes/core/class-wc-order-export-data-extractor-ui.php:390
1131
+ msgid "Item Cost"
1132
  msgstr ""
1133
 
1134
  #: classes/core/class-wc-order-export-data-extractor-ui.php:395
1135
+ msgid "Product Current Price"
1136
  msgstr ""
1137
 
1138
  #: classes/core/class-wc-order-export-data-extractor-ui.php:400
1139
+ msgid "Order Line (w/o tax)"
1140
  msgstr ""
1141
 
1142
  #: classes/core/class-wc-order-export-data-extractor-ui.php:405
1143
+ msgid "Order Line Tax"
1144
  msgstr ""
1145
 
1146
  #: classes/core/class-wc-order-export-data-extractor-ui.php:410
1147
+ msgid "Order Line Tax Refunded"
1148
  msgstr ""
1149
 
1150
  #: classes/core/class-wc-order-export-data-extractor-ui.php:415
1151
+ msgid "Order Line Tax (- Refund)"
1152
  msgstr ""
1153
 
1154
  #: classes/core/class-wc-order-export-data-extractor-ui.php:420
1155
+ msgid "Order Line Subtotal"
1156
  msgstr ""
1157
 
1158
  #: classes/core/class-wc-order-export-data-extractor-ui.php:425
1159
+ msgid "Order Line Subtotal Tax"
1160
  msgstr ""
1161
 
1162
  #: classes/core/class-wc-order-export-data-extractor-ui.php:430
1163
+ msgid "Order Line Total"
1164
  msgstr ""
1165
 
1166
  #: classes/core/class-wc-order-export-data-extractor-ui.php:435
1167
+ msgid "Order Line Total (include tax)"
1168
  msgstr ""
1169
 
1170
  #: classes/core/class-wc-order-export-data-extractor-ui.php:440
1171
+ msgid "Order Line Total Refunded"
1172
  msgstr ""
1173
 
1174
  #: classes/core/class-wc-order-export-data-extractor-ui.php:445
1175
+ msgid "Order Line Total (- Refund)"
1176
  msgstr ""
1177
 
1178
  #: classes/core/class-wc-order-export-data-extractor-ui.php:450
1179
+ msgid "Item Discount Amount"
1180
  msgstr ""
1181
 
1182
  #: classes/core/class-wc-order-export-data-extractor-ui.php:455
1183
+ msgid "Item Tax Rate"
1184
  msgstr ""
1185
 
1186
  #: classes/core/class-wc-order-export-data-extractor-ui.php:460
1187
+ msgid "Type"
1188
  msgstr ""
1189
 
1190
  #: classes/core/class-wc-order-export-data-extractor-ui.php:465
1191
+ msgid "Category"
1192
  msgstr ""
1193
 
1194
  #: classes/core/class-wc-order-export-data-extractor-ui.php:470
1195
+ msgid "Tags"
1196
  msgstr ""
1197
 
1198
  #: classes/core/class-wc-order-export-data-extractor-ui.php:475
1199
+ msgid "Width"
1200
  msgstr ""
1201
 
1202
  #: classes/core/class-wc-order-export-data-extractor-ui.php:480
1203
+ msgid "Length"
1204
  msgstr ""
1205
 
1206
  #: classes/core/class-wc-order-export-data-extractor-ui.php:485
1207
+ msgid "Height"
1208
  msgstr ""
1209
 
1210
  #: classes/core/class-wc-order-export-data-extractor-ui.php:490
1211
+ msgid "Weight"
1212
  msgstr ""
1213
 
1214
  #: classes/core/class-wc-order-export-data-extractor-ui.php:495
1215
+ msgid "Product URL"
1216
  msgstr ""
1217
 
1218
  #: classes/core/class-wc-order-export-data-extractor-ui.php:500
1219
+ msgid "Download URL"
1220
  msgstr ""
1221
 
1222
  #: classes/core/class-wc-order-export-data-extractor-ui.php:505
1223
+ msgid "Item download URL"
1224
  msgstr ""
1225
 
1226
  #: classes/core/class-wc-order-export-data-extractor-ui.php:510
1227
+ msgid "Image URL"
1228
  msgstr ""
1229
 
1230
  #: classes/core/class-wc-order-export-data-extractor-ui.php:515
1231
+ msgid "Product Shipping Class"
1232
  msgstr ""
1233
 
1234
  #: classes/core/class-wc-order-export-data-extractor-ui.php:520
1235
+ msgid "Description"
1236
  msgstr ""
1237
 
1238
  #: classes/core/class-wc-order-export-data-extractor-ui.php:525
1239
+ msgid "Short Description"
1240
  msgstr ""
1241
 
1242
  #: classes/core/class-wc-order-export-data-extractor-ui.php:530
1243
+ msgid "Full names for categories"
1244
  msgstr ""
1245
 
1246
  #: classes/core/class-wc-order-export-data-extractor-ui.php:535
1247
+ msgid "Summary Report Total Quantity"
1248
  msgstr ""
1249
 
1250
  #: classes/core/class-wc-order-export-data-extractor-ui.php:540
1251
+ msgid "Summary Report Total Amount"
1252
+ msgstr ""
1253
+
1254
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:545
1255
  msgid "Embedded Product Image"
1256
  msgstr ""
1257
 
1258
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:550
1259
+ msgid "Summary Report Total Discount"
1260
+ msgstr ""
1261
+
1262
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:555
1263
+ msgid "Summary Report Total Refund Count"
1264
+ msgstr ""
1265
+
1266
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:560
1267
+ msgid "Summary Report Total Refund Amount"
1268
+ msgstr ""
1269
+
1270
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:577
1271
  msgid "Coupon Code"
1272
  msgstr ""
1273
 
1274
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:582
1275
  msgid "Discount Amount"
1276
  msgstr ""
1277
 
1278
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:587
1279
  msgid "Discount Amount Tax"
1280
  msgstr ""
1281
 
1282
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:592
1283
  msgid "Discount Amount + Tax"
1284
  msgstr ""
1285
 
1286
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:597
1287
  msgid "Coupon Description"
1288
  msgstr ""
1289
 
1290
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:601
1291
  msgid "Coupon Type"
1292
  msgstr ""
1293
 
1294
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:606
1295
  msgid "Coupon Amount"
1296
  msgstr ""
1297
 
1298
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:657
1299
  msgid "Line number"
1300
  msgstr ""
1301
 
1302
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:667
1303
  msgid "Order Number"
1304
  msgstr ""
1305
 
1306
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:672
1307
  msgid "Order Status"
1308
  msgstr ""
1309
 
1310
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:687
1311
  msgid "Transaction ID"
1312
  msgstr ""
1313
 
1314
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:692
1315
  msgid "Currency"
1316
  msgstr ""
1317
 
1318
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:707
1319
  msgid "Date of first refund"
1320
  msgstr ""
1321
 
1322
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:712
1323
  msgid "Customer Note"
1324
  msgstr ""
1325
 
1326
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:717
1327
  msgid "Order Notes"
1328
  msgstr ""
1329
 
1330
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:722
1331
  msgid "Link to edit order"
1332
  msgstr ""
1333
 
1334
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:732
1335
  msgid "Customer IP address"
1336
  msgstr ""
1337
 
1338
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:737
1339
  msgid "Customer User ID"
1340
  msgstr ""
1341
 
1342
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:742
1343
  msgid "Customer Username"
1344
  msgstr ""
1345
 
1346
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:747
1347
  msgid "User Website"
1348
  msgstr ""
1349
 
1350
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:752
1351
  msgid "Customer User Email"
1352
  msgstr ""
1353
 
1354
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:757
1355
  msgid "Customer Role"
1356
  msgstr ""
1357
 
1358
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:762
1359
  msgid "Customer Total Orders"
1360
  msgstr ""
1361
 
1362
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:767
1363
  msgid "Customer first order date"
1364
  msgstr ""
1365
 
1366
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:772
1367
  msgid "Customer last order date"
1368
  msgstr ""
1369
 
1370
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:782
1371
  msgid "First Name (Billing)"
1372
  msgstr ""
1373
 
1374
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:787
1375
  msgid "Last Name (Billing)"
1376
  msgstr ""
1377
 
1378
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:792
1379
  msgid "Full Name (Billing)"
1380
  msgstr ""
1381
 
1382
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:797
1383
  msgid "Company (Billing)"
1384
  msgstr ""
1385
 
1386
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:802
1387
  msgid "Address 1&2 (Billing)"
1388
  msgstr ""
1389
 
1390
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:807
1391
  msgid "Address 1 (Billing)"
1392
  msgstr ""
1393
 
1394
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:812
1395
  msgid "Address 2 (Billing)"
1396
  msgstr ""
1397
 
1398
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:817
1399
  msgid "City (Billing)"
1400
  msgstr ""
1401
 
1402
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:822
1403
  msgid "State Code (Billing)"
1404
  msgstr ""
1405
 
1406
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:827
1407
  msgid "City, State, Zip (Billing)"
1408
  msgstr ""
1409
 
1410
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:832
1411
  msgid "City, State Zip (Billing)"
1412
  msgstr ""
1413
 
1414
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:837
1415
  msgid "State Name (Billing)"
1416
  msgstr ""
1417
 
1418
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:842
1419
  msgid "Postcode (Billing)"
1420
  msgstr ""
1421
 
1422
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:847
1423
  msgid "Country Code (Billing)"
1424
  msgstr ""
1425
 
1426
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:852
1427
  msgid "Country Name (Billing)"
1428
  msgstr ""
1429
 
1430
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:857
1431
  msgid "Email (Billing)"
1432
  msgstr ""
1433
 
1434
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:862
1435
  msgid "Phone (Billing)"
1436
  msgstr ""
1437
 
1438
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:872
1439
  msgid "First Name (Shipping)"
1440
  msgstr ""
1441
 
1442
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:877
1443
  msgid "Last Name (Shipping)"
1444
  msgstr ""
1445
 
1446
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:882
1447
  msgid "Full Name (Shipping)"
1448
  msgstr ""
1449
 
1450
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:887
1451
  msgid "Company (Shipping)"
1452
  msgstr ""
1453
 
1454
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:892
1455
  msgid "Address 1&2 (Shipping)"
1456
  msgstr ""
1457
 
1458
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:897
1459
  msgid "Address 1 (Shipping)"
1460
  msgstr ""
1461
 
1462
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:902
1463
  msgid "Address 2 (Shipping)"
1464
  msgstr ""
1465
 
1466
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:907
1467
  msgid "City (Shipping)"
1468
  msgstr ""
1469
 
1470
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:912
1471
  msgid "State Code (Shipping)"
1472
  msgstr ""
1473
 
1474
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:917
1475
  msgid "City, State, Zip (Shipping)"
1476
  msgstr ""
1477
 
1478
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:922
1479
  msgid "City, State Zip (Shipping)"
1480
  msgstr ""
1481
 
1482
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:927
1483
  msgid "State Name (Shipping)"
1484
  msgstr ""
1485
 
1486
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:932
1487
  msgid "Postcode (Shipping)"
1488
  msgstr ""
1489
 
1490
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:937
1491
  msgid "Country Code (Shipping)"
1492
  msgstr ""
1493
 
1494
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:942
1495
  msgid "Country Name (Shipping)"
1496
  msgstr ""
1497
 
1498
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:976
1499
  msgid "Shipping Method Title"
1500
  msgstr ""
1501
 
1502
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:981
1503
  msgid "Shipping Method"
1504
  msgstr ""
1505
 
1506
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:986
1507
  msgid "Shipping Method (no id)"
1508
  msgstr ""
1509
 
1510
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:991
1511
  msgid "Payment Method Title"
1512
  msgstr ""
1513
 
1514
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:996
1515
  msgid "Payment Method"
1516
  msgstr ""
1517
 
1518
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1001
1519
  msgid "Coupons Used"
1520
  msgstr ""
1521
 
1522
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1006
1523
  msgid "Cart Discount Amount"
1524
  msgstr ""
1525
 
1526
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1011
1527
  msgid "Cart Discount Amount Tax"
1528
  msgstr ""
1529
 
1530
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1016
1531
  msgid "Order Subtotal Amount"
1532
  msgstr ""
1533
 
1534
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1021
1535
  msgid "Order Subtotal - Cart Discount"
1536
  msgstr ""
1537
 
1538
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1026
1539
  msgid "Order Subtotal Amount Refunded"
1540
  msgstr ""
1541
 
1542
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1031
1543
  msgid "Order Subtotal Amount (- Refund)"
1544
  msgstr ""
1545
 
1546
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1036
1547
  msgid "Order Tax Amount"
1548
  msgstr ""
1549
 
1550
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1046
1551
  msgid "Order Shipping Amount"
1552
  msgstr ""
1553
 
1554
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1051
1555
  msgid "Order Shipping + Tax Amount"
1556
  msgstr ""
1557
 
1558
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1056
1559
  msgid "Order Shipping Amount Refunded"
1560
  msgstr ""
1561
 
1562
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1061
1563
  msgid "Order Shipping Amount (- Refund)"
1564
  msgstr ""
1565
 
1566
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1066
1567
  msgid "Order Shipping Tax Amount"
1568
  msgstr ""
1569
 
1570
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1071
1571
  msgid "Order Shipping Tax Refunded"
1572
  msgstr ""
1573
 
1574
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1076
1575
  msgid "Order Shipping Tax Amount (- Refund)"
1576
  msgstr ""
1577
 
1578
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1086
1579
  msgid "Order Total Fee"
1580
  msgstr ""
1581
 
1582
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1091
1583
  msgid "Order Refund Amount"
1584
  msgstr ""
1585
 
1586
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1096
1587
  msgid "Order Total Amount (- Refund)"
1588
  msgstr ""
1589
 
1590
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1101
1591
  msgid "Order Total Amount"
1592
  msgstr ""
1593
 
1594
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1106
1595
  msgid "Order Total Amount without Tax"
1596
  msgstr ""
1597
 
1598
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1111
1599
  msgid "Order Total Tax Amount"
1600
  msgstr ""
1601
 
1602
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1116
1603
  msgid "Order Total Tax Amount Refunded"
1604
  msgstr ""
1605
 
1606
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1121
1607
  msgid "Order Total Tax Amount (- Refund)"
1608
  msgstr ""
1609
 
1610
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1131
1611
  msgid "Total weight"
1612
  msgstr ""
1613
 
1614
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1136
1615
  msgid "Total items"
1616
  msgstr ""
1617
 
1618
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1141
1619
  msgid "Exported items"
1620
  msgstr ""
1621
 
1622
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1146
1623
  msgid "Total products"
1624
  msgstr ""
1625
 
1626
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1167
1627
  msgid "Common"
1628
  msgstr ""
1629
 
1630
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1168
1631
  msgid "User"
1632
  msgstr ""
1633
 
1634
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1169
1635
  msgid "Billing Address"
1636
  msgstr ""
1637
 
1638
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1170
1639
  msgid "Shipping Address"
1640
  msgstr ""
1641
 
1642
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1173
1643
  msgid "Cart"
1644
  msgstr ""
1645
 
1646
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1174
1647
  msgid "Shipping"
1648
  msgstr ""
1649
 
1650
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1175
1651
  msgid "Totals"
1652
  msgstr ""
1653
 
1654
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1176
1655
  msgid "Others"
1656
  msgstr ""
1657
 
1658
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1182
1659
  msgid "String"
1660
  msgstr ""
1661
 
1662
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1183
1663
  msgid "Money"
1664
  msgstr ""
1665
 
1666
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1184
1667
  msgid "Number"
1668
  msgstr ""
1669
 
1670
+ #: classes/core/class-wc-order-export-data-extractor-ui.php:1186
1671
  msgid "Image"
1672
  msgstr ""
1673
 
1674
+ #: classes/core/class-wc-order-export-data-extractor.php:1995
1675
  msgid "Edit order"
1676
  msgstr ""
1677
 
1678
+ #: classes/core/class-wc-order-export-data-extractor.php:2177
1679
  msgid "[Rest of the World]"
1680
  msgstr ""
1681
 
readme.txt CHANGED
@@ -5,7 +5,7 @@ Tags: woocommerce,export,order,xls,csv,xml,woo export lite,export orders,orders
5
  Requires PHP: 5.4.0
6
  Requires at least: 4.7
7
  Tested up to: 5.2
8
- Stable tag: 3.0.0
9
  License: GPLv2 or later
10
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
11
 
@@ -68,6 +68,9 @@ Check [some snippets](https://algolplus.com/plugins/snippets-plugins/) for popul
68
  = I want to add a product attribute to the export =
69
  Check screenshot #5! You should open section "Set up fields", open section "Products"(right column), click button "Add field", select field in 2nd dropdown, type column title and press button "Confirm".
70
 
 
 
 
71
  = I see only GREEN fields in section "Set up fields" =
72
  Please, unmark checkbox "Summary Report By Products" (it's below date range)
73
 
@@ -106,6 +109,14 @@ Yes, you can email a request to aprokaev@gmail.com. We intensively develop this
106
 
107
  == Changelog ==
108
 
 
 
 
 
 
 
 
 
109
  = 3.0.0 - 2019-07-03 =
110
  * New format - **HTML**
111
  * Added order field "Link to edit order" (useful for HTML format)
5
  Requires PHP: 5.4.0
6
  Requires at least: 4.7
7
  Tested up to: 5.2
8
+ Stable tag: 3.0.1
9
  License: GPLv2 or later
10
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
11
 
68
  = I want to add a product attribute to the export =
69
  Check screenshot #5! You should open section "Set up fields", open section "Products"(right column), click button "Add field", select field in 2nd dropdown, type column title and press button "Confirm".
70
 
71
+ = Same order was exported many times =
72
+ You should open section "Set up fields to export" and set "Fill order columns for" to "1st row only". The plugin repeats common information for each order item (by default).
73
+
74
  = I see only GREEN fields in section "Set up fields" =
75
  Please, unmark checkbox "Summary Report By Products" (it's below date range)
76
 
109
 
110
  == Changelog ==
111
 
112
+ = 3.0.1 - 2019-07-22 =
113
+ * Added product field "Product Name (main)" to export name of variable product (not name of variation!)
114
+ * Added summary product fields to export discounts and refunds
115
+ * Fixed bug - bulk exporting from orders page didn't work if you set date range filter at page "Export Now"
116
+ * Fixed bug - it was impossible to add custom field at tab "User"
117
+ * Fixed bug - filter "User roles" applied incorrectly
118
+ * Fixed bug - filter "Item meta" showed wrong results if you tried to filter by different meta keys
119
+
120
  = 3.0.0 - 2019-07-03 =
121
  * New format - **HTML**
122
  * Added order field "Link to edit order" (useful for HTML format)
view/settings-form.php CHANGED
@@ -589,7 +589,7 @@ function remove_time_from_date( $datetime ) {
589
  </div>
590
  <div>
591
  <?php _e( 'Custom css', 'woo-order-export-lite' ) ?><br>
592
- <textarea style="width: 100%" type=text name="settings[format_html_custom_css]"><?php echo $settings['format_html_custom_css'] ?></textarea>
593
  <div><i><?php _e( "This option cancels UI settings(above) and don't applied to Preview", 'woo-order-export-lite' ) ?></i></div>
594
  </div>
595
  </div>
@@ -1453,26 +1453,26 @@ function remove_time_from_date( $datetime ) {
1453
  };
1454
  ?>
1455
  </select>
1456
- <div id="custom_meta_order_mode" style="margin-bottom: 10px;">
1457
- <input style="width: 80%;" type='text' id='text_custom_meta_order'
1458
  placeholder="<?php _e( 'or type meta key here',
1459
  'woo-order-export-lite' ) ?>"/><br>
1460
  </div>
1461
  <div style="margin-bottom: 8px;">
1462
- <input id="custom_meta_order_mode_used" type="checkbox"
1463
  name="custom_meta_order_mode" value="used"> <?php _e( 'Hide unused fields',
1464
  'woo-order-export-lite' ) ?>
1465
  </div>
1466
  <hr>
1467
- <div style="margin-top: 20px;"><label for="colname_custom_meta"><?php _e( 'Column name',
1468
  'woo-order-export-lite' ) ?>:</label><input type='text'
1469
- id='colname_custom_meta'/>
1470
  </div>
1471
  <div style="margin-top: 20px;">
1472
  <?php echo print_formats_field( 'meta' ); ?>
1473
  </div>
1474
  <div style="text-align: right;">
1475
- <button id='button_custom_meta' class='button-secondary'><?php _e( 'Confirm',
1476
  'woo-order-export-lite' ) ?></button>
1477
  <button class='button-secondary button-cancel'><?php _e( 'Cancel',
1478
  'woo-order-export-lite' ) ?></button>
589
  </div>
590
  <div>
591
  <?php _e( 'Custom css', 'woo-order-export-lite' ) ?><br>
592
+ <textarea style="width: 100%" type=text name="settings[format_html_custom_css]" rows=5><?php echo $settings['format_html_custom_css'] ?></textarea>
593
  <div><i><?php _e( "This option cancels UI settings(above) and don't applied to Preview", 'woo-order-export-lite' ) ?></i></div>
594
  </div>
595
  </div>
1453
  };
1454
  ?>
1455
  </select>
1456
+ <div id="custom_meta_user_mode" style="margin-bottom: 10px;">
1457
+ <input style="width: 80%;" type='text' id='text_custom_meta_user'
1458
  placeholder="<?php _e( 'or type meta key here',
1459
  'woo-order-export-lite' ) ?>"/><br>
1460
  </div>
1461
  <div style="margin-bottom: 8px;">
1462
+ <input id="custom_meta_user_mode_used" type="checkbox"
1463
  name="custom_meta_order_mode" value="used"> <?php _e( 'Hide unused fields',
1464
  'woo-order-export-lite' ) ?>
1465
  </div>
1466
  <hr>
1467
+ <div style="margin-top: 20px;"><label for="colname_custom_meta_user"><?php _e( 'Column name',
1468
  'woo-order-export-lite' ) ?>:</label><input type='text'
1469
+ id='colname_custom_meta_user'/>
1470
  </div>
1471
  <div style="margin-top: 20px;">
1472
  <?php echo print_formats_field( 'meta' ); ?>
1473
  </div>
1474
  <div style="text-align: right;">
1475
+ <button id='button_custom_meta_users' class='button-secondary'><?php _e( 'Confirm',
1476
  'woo-order-export-lite' ) ?></button>
1477
  <button class='button-secondary button-cancel'><?php _e( 'Cancel',
1478
  'woo-order-export-lite' ) ?></button>
woo-order-export-lite.php CHANGED
@@ -5,7 +5,7 @@
5
  * Description: Export orders from WooCommerce with ease (Excel/CSV/XML/JSON supported)
6
  * Author: AlgolPlus
7
  * Author URI: https://algolplus.com/
8
- * Version: 3.0.0
9
  * Text Domain: woo-order-export-lite
10
  * Domain Path: /i18n/languages/
11
  * WC requires at least: 2.6.0
@@ -39,7 +39,7 @@ if ( class_exists( 'WC_Order_Export_Admin' ) ) {
39
  return;
40
  }
41
 
42
- define( 'WOE_VERSION', '3.0.0' );
43
  define( 'WOE_PLUGIN_BASENAME', plugin_basename( __FILE__ ) );
44
  define( 'WOE_PLUGIN_BASEPATH', dirname( __FILE__ ) );
45
 
5
  * Description: Export orders from WooCommerce with ease (Excel/CSV/XML/JSON supported)
6
  * Author: AlgolPlus
7
  * Author URI: https://algolplus.com/
8
+ * Version: 3.0.1
9
  * Text Domain: woo-order-export-lite
10
  * Domain Path: /i18n/languages/
11
  * WC requires at least: 2.6.0
39
  return;
40
  }
41
 
42
+ define( 'WOE_VERSION', '3.0.1' );
43
  define( 'WOE_PLUGIN_BASENAME', plugin_basename( __FILE__ ) );
44
  define( 'WOE_PLUGIN_BASEPATH', dirname( __FILE__ ) );
45