Export orders into csv

[♥JcMagpie 1,693]

9 hours ago, ralgiere said:

Can someone PLEASE look at I have posted and at least make a few suggestions?

That is a custom csv file so only you can say if it's as you configured it.

[driven22 1]

 

I still have a small problem (Frozen version):

 
When the client has a name and two-membered surname after the second space it cuts off all the words
Example:
Johnny Bravo Scott
after export to csv I only have Johnny Bravo
Truncates only when a space after the second word is used

 

Where can I correct it so that it doesn't cut?

Edited September 10, 2019 by driven22

[fridgebox 7]

You should use

\t

separation for csv's

<?php
  $order_dump = DIR_FS_TMP.'order_dump.csv';


  $order_dump = fopen($order_dump ,"a") or die(" error opening - $order_dump \n");  


  fwrite($file_handle,"$key\t$value[0]\t$value[1]\n");


  fclose($file_handle) or die(" error closing $order_dump"); 
?>

 

Edited September 10, 2019 by fridgebox

[driven22 1]

I would like csv to export the order amount when the shipping payment is higher or equal to 19$ (My cod is 19$) and show e.g. in the $cod field in exportordes.php

It is needed for cash on delivery COD when importing to DHL or other courier.

I've been trying to enter the rule for a few days - but I'm too weak in php to do this.

Currently, order_total ($Order_Grand_Total) shows regardless of the chosen payment method or payment amount:

Quote

// --------------------    QUERIES 7  ------------------------------------//
//Orders_Total -
$orders_total = tep_db_query("select value from orders_total
where class = 'ot_total' and orders_id = " . $Orders_id);
//$row_orders_total = tep_db_fetch_array($orders_total);
while($row_orders_total = mysqli_fetch_array($orders_total)) {
 // end //
$Order_Grand_Total = $row_orders_total["value"];
}

Can I count on your help?

 

[Psytanium 17]

Where is the module link ? Thanks