orders Exporter 0.1

Hi,

There is no discussion on this recent module. Has anyone installed it successfully? Is it useful? There isn't any installation instructions in the readme.txt.

The Orders_Exporter is just what one of my clients has been asking for. I installed the files and found the "Orders Export" link under "Tools". I clicked on it and tried creating the download file. It ran for several minutes and slowed the server down.

I stopped it and tried again running the link to place it in the oexport directory. It again ran for several minutes (there were over 1000 orders so I let it run). It finally ended (I assume it finished when the server speeded back up) but I was only left with a blank page. Nothing downloaded. Nothing in the oexport directory.

Summary: Good news is the installation was easy. Bad news is that other than slowing the server down while it does "something", nothing is produced from running it.

Seems to need a bit more testing or more instructions. Would love to have it in a workable format tho!

Jim

hm... I am really sorry to hear about this.

I have used the module on two websites (both Zen Cart 1.3.7) and it works fine.

I will have a look at it in about two weeks time and at least I will add some proper instructions. Sorry, youve wasted your time so far.

thematysek

Thanks for your reply and concern. I just went back and tried again on a different account and it worked. So it is likely something with that particular account and not the contribution After re-checking everything, I found that the account that doesn't work has over 5000 "undelivered" orders so it is possible that the script is just timing out. I suggested he start checking his completed orders as delivered and then try it again. I'll post the results if he does so. The other possibility is that his version is older - 1.3.0 or something. So that might have a bearing on it.

I'll share any updates I get on this because this guy is the one who really is eager to get this going. Thanks for the great contribution.

Jim

blarney:

I found that the account that doesn't work has over 5000 "undelivered" orders so it is possible that the script is just timing out.
...

I'll share any updates I get on this because this guy is the one who really is eager to get this going.

That's just what was happening... when I trimmed down his processing orders to 500, the script ran through to completion.

So lesson here is that if you try to run it on a lot of orders (thousands) it will slow your server to a crawl (and my server never crawls!), and after running for 15 minutes or so may just show a blank page without any results. If that happens, trim your not delivered orders back to less than 500 (depending on server capability), and just run it on orders not delivered.

Jim Smith

I use this modules with my site and don't see any trouble.

But i think it don't export the quantity of each product . I have customer order some product in 50 pcs and that program don't export the quantity. It only export name and model + attributor option only.

Hope this answer hopefull . I would like to know how to export quantity too but i don't know .... :mellow:

It works fine but doesn't include order totals or quanitites as someone else mentioned. Seems like it wouldn't be that hard to add those fields. It's really useless to me without amounts and I could really use something like this. Thanks for creating it and I hope it can be improved a bit!

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

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.

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.

Your trouble similar with me :D

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?

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?

thematysek:

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!

It works great, thanks!!!

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?

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:
```php
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.

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

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

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!

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