orders Exporter 0.1

[exactlyhow]

Is there a way to add a blank line after every entry? My client wants to sort by model number, then add all the quantities for each model number. A simple way to do this would be to add a blank line in the Excel spreadsheet, but that is tedious and it would be easier to have the module automatically add a blank line so an auto sum can be done in Excel without having to add the blank line manually. Any ideas?

[littleturtlemama]

is there a way to select particular orders with this? For example, if I want to export orders from a particular week, is that possible with this mod? If not, does anyone know of a mod that you can do that with?

[timcfi]

Extended version which includes order_totals is now available in download section.

I have the latest Orders Exporter. Where do I install the files?
Thanks!

[timcfi]

It works great, thanks!!!

[Tapper]

Hi

This is a great module, thanks.

But I really need to know how many of each product were ordered. It's nice that it has the line items for each product, but if someone ordered 3 of 1 thing and 5 of another, each product only gets 1 line and no info on item count.

Does anyone know how I can get the number of each product ordered?

[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