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.
Printable View
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
That's just what was happening... when I trimmed down his processing orders to 500, the script ran through to completion.Quote:
Originally Posted by blarney
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.
Quote:
Originally Posted by garyfranchi
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?
I have the latest Orders Exporter. Where do I install the files?Quote:
Originally Posted by thematysek
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:
you can see I added the quantity after the model number.PHP Code:'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++,
Then it should be added again like this:
It needs to be repeated for each type of output you want. I did it for the first selection.PHP Code: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,
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
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!
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.
downloaded latest version of OrderExporter today and installed.
Why was the customer's State (as in geographic, not the state of the order) eliminated from the output?
i have been using Mats order exporter for a while now and love it.
I have added another field to the exporter for quantity and works great.
I have recently had the need to add another but am not sure of the field i need to add.
I need to add the special comments field to the end of the spreadsheet but am running into trouble.
i get the error : There is an error in one of the sql statements - That's unlucky, see below...
1054: Unknown column 'comment' in 'field list'
here is a snippit of my code:
Any help would be grately appreciated :bigups:Code:'v_date_purchased' => $iii++,
'v_orders_status_name' => $iii++,
'v_orders_id' => $iii++,
'v_customers_id' => $iii++,
'v_customers_name' => $iii++,
'v_customers_company' => $iii++,
'v_customers_street_address' => $iii++,
'v_customers_suburb' => $iii++,
'v_customers_city' => $iii++,
'v_customers_postcode' => $iii++,
//'v_customers_state' => $iii++,
'v_customers_country' => $iii++,
'v_customers_telephone' => $iii++,
'v_customers_email_address' => $iii++,
'v_products_model' => $iii++,
'v_products_quantity' => $iii++,
'v_products_price' => $iii++,
'v_products_name' => $iii++,
'v_products_options' => $iii++,
'v_products_options_values' => $iii++,
'v_orders_comment' => $iii++,
);
$filelayout_sql = "SELECT
zo.orders_id as v_orders_id,
customers_id as v_customers_id,
customers_name as v_customers_name,
customers_company as v_customers_company,
customers_street_address as v_customers_street_address,
customers_suburb as v_customers_suburb,
customers_city as v_customers_city,
customers_postcode as v_customers_postcode,
customers_country as v_customers_country,
customers_telephone as v_customers_telephone,
customers_email_address as v_customers_email_address,
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_price as v_products_price,
products_name as v_products_name,
products_options as v_products_options,
products_options_values as v_products_options_values,
comment as v_orders_comment
FROM ".TABLE_ORDERS_PRODUCTS." zop LEFT JOIN ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES." opa
ON(zop.orders_products_id = opa.orders_products_id), ".TABLE_ORDERS." zo, ".TABLE_ORDERS_STATUS." zos
WHERE zo.orders_id = zop.orders_id
AND zo.orders_status = zos.orders_status_id
";
break;
FYI i have fixed my problem but i thought some of you guys might be interested in how i did it.
The 'comments' field was in a different table called 'ORDER_STATUS_HISTORY and had to connect that table to the order exporter before i could reference it.
corrected working code snippet below:
Code:case 'full':
// The file layout is dynamically made
$iii = 0;
$filelayout = array(
//all columns:
'v_date_purchased' => $iii++,
'v_orders_status_name' => $iii++,
'v_orders_id' => $iii++,
'v_customers_id' => $iii++,
'v_customers_name' => $iii++,
'v_customers_company' => $iii++,
'v_customers_street_address' => $iii++,
'v_customers_suburb' => $iii++,
'v_customers_city' => $iii++,
'v_customers_postcode' => $iii++,
//'v_customers_state' => $iii++,
'v_customers_country' => $iii++,
'v_customers_telephone' => $iii++,
'v_customers_email_address' => $iii++,
'v_products_model' => $iii++,
'v_products_quantity' => $iii++,
'v_products_price' => $iii++,
'v_products_name' => $iii++,
'v_products_options' => $iii++,
'v_products_options_values' => $iii++,
'v_orders_comment' => $iii++,
);
$filelayout_sql = "SELECT
zo.orders_id as v_orders_id,
customers_id as v_customers_id,
customers_name as v_customers_name,
customers_company as v_customers_company,
customers_street_address as v_customers_street_address,
customers_suburb as v_customers_suburb,
customers_city as v_customers_city,
customers_postcode as v_customers_postcode,
customers_country as v_customers_country,
customers_telephone as v_customers_telephone,
customers_email_address as v_customers_email_address,
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_price as v_products_price,
products_name as v_products_name,
products_options as v_products_options,
products_options_values as v_products_options_values,
osh.comments as v_orders_comment
FROM ".TABLE_ORDERS_PRODUCTS." zop LEFT JOIN ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES." opa
ON(zop.orders_products_id = opa.orders_products_id), ".TABLE_ORDERS." zo, ".TABLE_ORDERS_STATUS." zos, ".TABLE_ORDERS_STATUS_HISTORY." osh
WHERE zo.orders_id = zop.orders_id
AND zo.orders_status = zos.orders_status_id
";
break;
I need to add the products images field (Call to field products.products_image) to the end of the spreadsheet but am running into trouble.
here is my code:
ThanksPHP Code:'v_date_purchased' => $iii++,
'v_orders_status_name' => $iii++,
'v_orders_id' => $iii++,
//'v_customers_id' => $iii++,
'v_register_name' => $iii++,
'v_customers_email_address' => $iii++,
'v_customers_name' => $iii++,
//'v_customers_street_address' => $iii++,
//'v_customers_city' => $iii++,
//'v_customers_state' => $iii++,
'v_customers_country' => $iii++,
//'v_customers_postcode' => $iii++,
'v_customers_telephone' => $iii++,
'v_products_quantity' => $iii++,
'v_products_model' => $iii++,
'v_products_price' => $iii++,
//'v_products_name' => $iii++,
'v_products_options' => $iii++,
'v_products_options_values' => $iii++,
'v_producs_images' => $iii++,
);
$filelayout_sql = "SELECT
date_purchased as v_date_purchased,
orders_status_name as v_orders_status_name,
zo.orders_id as v_orders_id,
customers_id as v_customers_id,
customers_name as v_register_name,
customers_email_address as v_customers_email_address,
delivery_name as v_customers_name,
delivery_street_address as v_customers_street_address,
delivery_city as v_customers_city,
delivery_state as v_customers_state,
delivery_country as v_customers_country,
delivery_postcode as v_customers_postcode,
customers_telephone as v_customers_telephone,
zop.products_quantity as v_products_quantity,
zop.products_model as v_products_model,
zop.products_price as v_products_price,
products_options as v_products_options,
products_options_values as v_products_options_values,
os.producs_images as v_producs_images
FROM ".TABLE_ORDERS_PRODUCTS." zop LEFT JOIN ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES." opa
ON(zop.orders_products_id = opa.orders_products_id), ".TABLE_ORDERS." zo, ".TABLE_ORDERS_STATUS." zos, ".TABLE_PRODUCTS."os ON(zop.products_id=os.products_id)
WHERE zo.orders_id = zop.orders_id
AND zos.orders_status_id = '2'
AND zo.orders_status = zos.orders_status_id
";
I need to add the name of the buyer (ie: under billing address) which often differs from the name of the recipient of the shipping address. I would also like to add the SKU (which was part of another mod add on along with UPC). I send a portion of my orders over to a drop shipper and I need the SKU (ie: the drop shippers order number) to appear in the spreadsheet.
We are currently doing this manually but as you can imagine, it's quite tedious.
Any help would be appreciated
will this work with 1.3.9h?
I installed orders exporter in Zen Cart 1.5.4
and this is what I get when I export the orders
Success File ordersExpFull2015Feb28-1010.txt successfully exported! The file is ready for FTP download in your /oexport/ directory.
Warning There is an error in one of the sql statements - That's unlucky, see below...
1045: Access denied for user ''@'localhost' (using password: NO)
Any ideas how I can fix it?
anyone?
Can anyone help with this, I have the same issue!
Thanks
Cliff
I tried using this and all I get when I download are the table names and no information. Has anyone else seen this issue?
If so, please reply. I really need to export all order information from my store.
Attachment 15595
YES! I have the same problem, in the end I gave up and used Export Shipping & Order Information - https://www.zen-cart.com/downloads.php?do=file&id=406
And it works well!!
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
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.