Jump to content
dlan

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.

image.thumb.png.87d41fcd5bbeae0dbc98f479e09a6f1b.png


 

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
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 by driven22

Share this post


Link to post
Share on other sites

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

 

 

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

×