Exporting Order addresses to CSV file

[zefeena]

Hi,

 

I need a way to export my customer addresses by order number to a csv file so I can import that into Royal Mails software for printing postage labels.

 

I have looked at a few add ons, but the CSV export didn't work, and was really far to in depth.  All I need is the customers shipping address, telephone number, order number, and ideally their shipping method and order value (not essential).

 

Otherwise I will have to type each one in individually to create the label, and that will get old very fast!

 

Any ideas?

 

Thank you, Kellie

 

Installed Version: osCommerce Online Merchant v2.3.4  Boot strap

 

 

[PandV]

Hi,

 

Search the contributions for "MYOB" - there a couple of contributions for downloading the customer, items and order details into text files. Between them they have all the details you need and it shouldn't take much to get all the details you want output into one file. Even though they are quite old I have them working with 2.3.4 BS.

[♥bruyndoncx]

we use heidisql with a bunch of scripts for each carrier we use

 

this is for PostNL but it might get you started

select 'NP' as Methode, ucase(delivery_name) as Name, customers_telephone as 'Tel', ucase(delivery_street_address) as Street, 
delivery_postcode as 'Postal Code' , ucase(delivery_city) as City, c.countries_iso_code_2 as Country,
replace(sum(op.products_quantity * p.products_weight),'.',',') as Weight,o.orders_id as 'Customer Reference',
customers_email_address 'email'
 from orders o, orders_products op, products p, countries c, countries_names cn
  where o.orders_id = op.orders_id
  and op.products_id = p.products_id 
  and o.orders_id in (190719,190723,190721)
  and o.delivery_country = cn.countries_name and c.countries_id = cn.countries_id
group by delivery_name, delivery_street_address, delivery_postcode
order by o.orders_id

[Hotclutch]

Export the table contents directly from PHPMyAdmin to CSV file.

[zefeena]

Hi,

 

Thank you i'll have a play with those!

I did try export table contents from PHP, I got a blank file!  Obviously I did something wrong, but as I wasn't sure if that was an option I just gave up, but now I know that is 'supposed' to work i'll have another look at that too!

 

Kellie

[alexiscruz007]

http://addons.oscommerce.com/info/4728

http://addons.oscommerce.com/info/4181

use one of this.