orders Exporter 0.1

[brushwoodnursery]

Yes, the download is limited without quantity. Luckily, the file structure to generate the spreadsheet is very simple. Looking here:

'v_customers_country'    => $iii++, 
'v_customers_telephone'    => $iii++, 
'v_customers_email_address'    => $iii++, 
'v_products_model'    => $iii++, 
'v_products_quantity'    => $iii++,
'v_products_name'    => $iii++, 
'v_products_options'    => $iii++, 
'v_products_options_values'    => $iii++, 

you can see I added the quantity after the model number.
Then it should be added again like this:

date_purchased as v_date_purchased,
orders_status_name as v_orders_status_name,
products_model as v_products_model,
products_quantity as v_products_quantity,
products_name as v_products_name,
products_options as v_products_options, 

It needs to be repeated for each type of output you want. I did it for the first selection.

I'm going to look into other ways to manipulate the output like dropping the extra data and adding a line between orders.

[brushwoodnursery]

Note also: the output is the Customer name and address. The file should also be changed to pull the delivery address data where needed (always in my case).

[brushwoodnursery]

OK, I can't figure out how to drop a line break between orders. Any help would be appreciated.

[thirtytwo16]

I've downloaded this addon, and am excited to use it...but where the heck to I upload it to? I know it is probably easy, but I can't figure it out. Thanks!

[blarney]

In the readme file it sez:

++++
Upload the import script files and import_osc_configure.php to the same directory on your url.

Point your browser to one of the import scripts you want to run.
Example: http://www.yoursite.com/import_osc_customers.php
++++

It doesn't have to be in the root directory but in that example you would put those files in your root directory. Reminder: Do NOT leave them in there after you are done.

Jim

[aeolidia]

This thread is for "Mat's Orders Exporter," correct?

Is there a way to include the PayPal transaction ID for each order? I see "txn_id" in the paypal_payment_status_history" table and the "paypal" table. I'd love some help including this in the export. Thanks!

[Unicorn]

I'm stuck.

Need order total in full export, but when I try editing the code it either won't work or gives me a "cannot find header information" or whatever it says.