Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


Export orders into csv

Recommended Posts

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.



Share this post

Link to post
Share on other sites
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
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 by driven22

Share this post

Link to post
Share on other sites

You should use


separation for csv's

  $order_dump = DIR_FS_TMP.'order_dump.csv';

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


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


Edited by fridgebox

- ICECAT specialist.
(Icecat: open feed with product information, data-sheets for oscommerce.)
- CSV IMPORT specialist.
(manage your suppliers via supplier manager)
Contact me via PM.

Share this post

Link to post
Share on other sites
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:

// --------------------    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?



Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now