prodograw

Hi Alex,

ok so its just appending “from_date” & “to_date” on get params

I thought i would be able to add something to miscellaneous

• This reply was modified 5 years, 8 months ago by prodograw.

but still would like on run_one_job

daterange “LAST MONTH”

if possible parsing “From Date” & “To Date” on the fly

• This reply was modified 5 years, 8 months ago by prodograw.
• This reply was modified 5 years, 8 months ago by prodograw.

Ok so its seems ive sorted myself for the total weight part

i added 2 fields
Weight
Quantity

Then used modified code from your snippets (thanks) but utilising excels SUMPRODUCT

=SUMPRODUCT(A2:A$row,B2:B$row)

below is what i used

add_action( 'woe_xls_print_footer', function ($objXls,$formatter) {
 $row = $formatter->last_row;
 // edit column names below! 
 $formatter->objPHPExcel->getActiveSheet()->getStyle( "D2" )->getFont()->setBold( true );
 $formatter->objPHPExcel->getActiveSheet()->getStyle( "D3" )->getFont()->setBold( true );
 $formatter->objPHPExcel->getActiveSheet()->setCellValue( "D2", "Total KG:" );
 $formatter->objPHPExcel->getActiveSheet()->setCellValue( "D3", "=SUMPRODUCT(A2:A$row,B2:B$row)");
} ,10, 2);

• This reply was modified 5 years, 8 months ago by prodograw.
• This reply was modified 5 years, 8 months ago by prodograw.
• This reply was modified 5 years, 8 months ago by prodograw.

ok so this only works if you are logged in as admin ??

Hi sorry maybe i didnt explain myself correctly

what you suggested yes does work

but i do not want to export it if there is any other product in the order at all

basically we have 2 places we dispatch from. if the order only has this category export it

if i wanted to create a couple of profiles which i can modify the html form all ok for variable user select form

what would i need to do to parse the variable to the php function ?

i.e
WC_Order_Export_Ajax::run_one_job(“PASSED_VARIABLE”); ????

Thanks

so possibly can look at that isseu

I’ve disabled WP Hide Plugin Updates and Warnings and CSV files now download.

strange tested on staging site which is php7.2 and bulk works
not working in live site php 5.6

will keep digging

done….

that wasn’t the culprit ??

see below

WP_Hook Object ( [callbacks] => Array ( [10] => Array ( [000000005507ed640000559ae34e1ce7export_orders_bulk_action_process] => Array ( [function] => Array ( [0] => WC_Order_Export_Admin Object ( [activation_notice_option] => woocommerce-order-export-activation-notice-shown [step] => 30 [url_plugin] => https://www.prodograw.com/wp-content/plugins/woo-order-export-lite/ [path_plugin] => /home/prodograw/public_html/wp-content/plugins/woo-order-export-lite/ [methods_allowed_for_guests] => [path_views_default] => /home/prodograw/public_html/wp-content/plugins/woo-order-export-lite/view/ [settings] => Array ( [default_tab] => export [cron_tasks_active] => 1 [show_export_status_column] => 1 [show_export_actions_in_bulk] => 1 [show_export_in_status_change_job] => 0 [autocomplete_products_max] => 10 [ajax_orders_per_step] => 30 [limit_button_test] => 1 [cron_key] => 1234 [ipn_url] => [zapier_api_key] => 12345678 [zapier_file_timeout] => 60 ) ) [1] => export_orders_bulk_action_process ) [accepted_args] => 3 ) [000000005507f6ca0000559ae34e1ce7handle_bulk_actions_edit_shop_order] => Array ( [function] => Array ( [0] => WPDesk_Flexible_Shipping_Bulk_Actions Object ( ) [1] => handle_bulk_actions_edit_shop_order ) [accepted_args] => 3 ) ) ) [iterations:WP_Hook:private] => Array ( ) [current_priority:WP_Hook:private] => Array ( ) [nesting_level:WP_Hook:private] => 0 [doing_action:WP_Hook:private] => )

….. mistake

• This reply was modified 6 years ago by prodograw.

admin ajax not firing

see here:

View post on imgur.com

Thanks Sorted !

help for anyone else that needs its i needed to generate package ammounts based on weight

below is what i used

add_filter('woe_get_order_value_total_weight_items',function ($value, $order,$fieldname) {
  
  $value = round($value/25,0,PHP_ROUND_HALF_UP);

  if ($value < 1){
   return 1;
  }
  return $value;
},10,3);

Hi no it does not work does not matter where I put the code every export has no “