orders Exporter 0.1

[thematysek]

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

[garyfranchi]

Thematysek, great addition to the Zen cart...

I downloaded the newest update to get the order totals.... but when I used it for the first time I found it was the the total dollar amount for the purchase not the total number of items purchased.... guess we have a different idea what totals means...lol...

Since you were so kind to add that feature to your mod may I request a few more to make your mod really fly and make my life allot easier?

I need to be able to export the orders and have them include:

>>Total number of "widgets" per item per order... for example:

Customer X orders 10 widgets and 5 gidgets

Currently downloads only show that Customer X ordered a widget and a
gidget... I don't know exactly how many widgets and gidgets Customer X
ordered.


>>Select a date range for orders exporting... for example:

Can you add the ability to select a range of dates to selectively download?


I'd hate to abandon Zen cart and move to another shopping cart after all the time spent on getting it set up... your help in adding these features will be a tremendous burden lifted.

[kimsonvu]

Thematysek, great addition to the Zen cart...

I downloaded the newest update to get the order totals.... but when I used it for the first time I found it was the the total dollar amount for the purchase not the total number of items purchased.... guess we have a different idea what totals means...lol...

Since you were so kind to add that feature to your mod may I request a few more to make your mod really fly and make my life allot easier?

I need to be able to export the orders and have them include:

>>Total number of "widgets" per item per order... for example:

Customer X orders 10 widgets and 5 gidgets

Currently downloads only show that Customer X ordered a widget and a
gidget... I don't know exactly how many widgets and gidgets Customer X
ordered.


>>Select a date range for orders exporting... for example:

Can you add the ability to select a range of dates to selectively download?


I'd hate to abandon Zen cart and move to another shopping cart after all the time spent on getting it set up... your help in adding these features will be a tremendous burden lifted.

Your trouble similar with me

[muteyaar]

I am getting blank page when I click on the SHOW ME THE MONEY button.

i am using Zencart v 1.5.4
please help

[gjh42]

There have been several new versions of this mod since 0.1, and the thread where thy have been discussed is here:
https://www.zen-cart.com/showthread....r-Module/page3
The most recent v2.1 is attached to post 109. I will be folding in DrByte's v1.5.4+ updates before I post it to the download page.

[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).