Printable View
Right now the product ID is not exported. Only the model etc.. I'll included that option within the next release which I am actively working on now. There have been enough requests for additional items that I moved the development of that release forward here.
I hope to have it complete in the near future.
I'll post to this board when ready.
Thanks Eric,
Appreciate your help :)
Except I went in Admin to Tools > Install SQL Patches, I cut and paste this in the box:
UPDATE orders SET downloaded_ship="no" WHERE downloaded_ship="yes"
and clicked "SEND" and it comes back with FAILED
Sorry but I don't know PHP or SQL so no clue what I would type for AND [add your other criteria here such as dates between etc...]. I tried a few thinngs but still "failed"
I just need July 2006 - June 2007, but if I can just reset all orders to NO and export them all again that is more than fine!! I can then sort in excel
Anyone know how I can correct that SQL statement above so it works and keep moving??
Basically for those who didn't see my last post I want to export all my past orders again, this time with the full details, but since I have exported them before they don't appear ... pls help :)
Quote:
Originally Posted by econcepts
Instead of that SQL, try this one. The quotes needed to be reworked.
UPDATE orders SET downloaded_ship='no' WHERE downloaded_ship='yes';
If you want to export just the orders between July 2006 and June 2007 then try something like the following:
UPDATE orders SET downloaded_ship='no' WHERE date_purchased >= '2006-07-01 00:00:00' AND date_purchased <= '2007-07-01 00:00:00' AND downloaded_ship='yes';
any update on a new release? specifically quoting bug fixes and the ability to clear the exported flag?
Quote:
Hi,
A+ contrib. Thank you very much!
Any chance you can add a option to download payment type chosen aswell? :)
Thanks again
Gavin
Hi,Quote:
Hi,
Yes that is correct. Basically I download paypal csv accounts aswell.
I need to know which payments are with paypal so that dont re-enter the same info twice when combining the two together.
The reason I need the paypal sheet aswell is because I make sales on eBay aswell.
So if I can see what payment type they are I can delete those ones that are paid by paypal without having to compare with paypal one by one.
A HUGE time saver :)
This later release coming anytime soon?
Best wishes,
Gavin
Just wanted to remind you to include the above in the new relese if possible. Really would appreciate it. Thanks alot, is it coming out any time soon :blink::clap:
Getting real close I'm hoping within the next 2 weeks to have it ready for release.Quote:
Originally Posted by dhcernese
Eric,
Thanks for this contribution! I am new to Zen Cart and I like all of the help these forums offer.
I am setting up a new cart for event registrations. Because the product is virtual there is no shipping address needed. Is there any easy way to copy the customer information to the shipping fields so it will download? Would it just be easier to modify the shipping_export file to pull from other fields in the database?
Thanks, I appreicate it!Quote:
Originally Posted by econcepts
Thanks Eric you're a champ! This worked like a charm and is very handy when sometimes I export orders without all the fields I need and then need to reset them to export again
Just hanging out eagerly for the next release of Export Orders, atm cutting and pasting company name so just if that field is fixed will be a lifesaver
cheers,
Dave
Quote:
Originally Posted by econcepts
Curious, why the "WHERE" clause? Can I leave it out?Quote:
Originally Posted by econcepts
Sure, you could leave it out, however it is there so that it finds every record that has already been exported (once exported, that field is marked as 'yes') and the resets it to 'no' (as if the export never occurred.)Quote:
Originally Posted by dhcernese
If you leave it out, it will set everything in the database to 'no'. This may be what you want. Either way will work. Including the WHERE clause gives you more control over what exact records are being updated.
For example, if you decide to only include orders to set as "no" (not exported) in the db, then you would want to add the date to the sql commands and include the fact that you want to also take only those orders that have been exported already.
Just a "completion" type thing.
Minor but annoying bug, in admin/shopping_export.php is this:
<img src="/z137/admin/images/icons/preview.gif" border="0" ALT="Preview Order Details">
Note the hard-coded path to the preview.gif
I suggest this to resolve quoting problems, if losing the quotes is acceptable. If not, it's a little more complicated:
Code:[FONT="Courier New"] if ($_POST['order_comments'] == 1) {
if ($_POST['filelayout2'] == 1) { // 1 Product per row
$orders_comments_query="SELECT * FROM " . TABLE_ORDERS_STATUS_HISTORY . " WHERE orders_id = " . $order_details->fields['orders_id'] . " GROUP BY orders_id ORDER BY orders_status_history_id ASC";
$orders_comments = $db->Execute($orders_comments_query);
$note = $orders_comments->fields['comments'];
} else {
$note = $order_details->fields['comments'];
}
$cnote = str_replace(array("\"","\'"), "", $note); // Remove any double or single quotes
$str_export = $str_export . ",\"". str_replace(array("\r\n","\r","\n"), " ", $cnote) . "\""; // Remove any line breaks in first comment and print to export string
}[/FONT]
Hi Eric, I just downloaded and installed your export feature and it RULES!!! works like a charm:clap:
thanks so much for making this excellent mod available!
Let me tell you, i have been getting the info from copy's of order conformation mailes. So i had to copy, name, adres, the likes into an excell sheet for external use... took me like an hour for the first 20 orders.
With your tool, i now do the same in a minute. THANKS THANKS THANKS!:clap:
(just a little thing i'd apreciate for a next release: selectoption to add manufacturer info)
Keep up the great work :smile:
Glad you like the mod. I think you'll like the next release as well (coming very soon). :)
Can't wait. there's some small things i'd like to see added. (more options to export data)
Just got the conversion pack/book and google workbook as an apriciation of this great module :) Keep these handy items coming :) I'm gonna get the analytics implemented now
I'm having trouble downloading this mod. I keep getting an unable to determine file format message from Stuffit. Is there any other source for the file? Thanks
I had only one other user inform me of this message as well (using the same Stuffit program).Quote:
Originally Posted by johnga
They contacted Stuffit and found out that it had to do with a flaw in the version of Stuffit they were using. They updated (or somehow corrected the issue) and were able to open the file just fine.
You may want to contact the guys over at Stuffit to find out what the issue is. If I find his exact response in my messages here (if I still got it) I'll post it. You may already have the answer by then though.
I had the same problem when I tried to download your mod using my Mac. I have never had any issues with any other downloads. But if I downloaded your mod and unziped it on my PC it was okay. There must be something in your zip that is not recognizable with the stuffit for mac.Quote:
Originally Posted by econcepts
But I will update my stuffit and hopefully any of your new updates I will not have to go on my slow PC to get you mod.
Does this Mod have the ability to select a date range of orders to export?
Thanks
JON
Yes, that is what I heard from two other Mac stuffit users. They both told me that they could download all other zips but that one.Quote:
Originally Posted by supersnow
I even re-zipped it for them and resent in an email. In both cases they said the Stuffit team looked at the files and although I do not know what exactly they did, they determined that the files were fine, but that version of Stuffit for Mac had a glitch that caused the files not to open. Somehow they both corrected the issue and got them opened.
I wish I could find that original conversation from them and shoot it up here for you as it may help, but I looked and unfortunately can't locate it.
The current version 1.2.2 does not. The next release won't either, but 1.2.4 will (2 releases from now). Unless I can squeeze it into 1.2.3 here (to be released shortly).Quote:
Originally Posted by wapnoj
Is there a possibility to have the tax exported into a column. The tax is include into the total, but it woulb great for ivoice reasons to have the tax in a seperate column.
Having the attributes in seperate colmns would be awesome too.
Thanks
JON
The attributes can't be split into separate columns due to the unlimited and un "common" nature of them (throws off the number of columns in the import which many programs do not like). That is why the PIPE delimiter was used. You can parse that field based on the pipe and achieve the same effect.Quote:
Originally Posted by wapnoj
The tax will be be in this next release. I have been working on it here but the holidays put me behind from when I wanted to release it (which was a few weeks ago). In any event, I hope to have the newest version released and posted soon. That will include the ability to export the tax into it's own column as well as a number of other requests I have gathered since the last 1.2.2 release.
Keep your eyes open. I'll post a message to this thread when the new version is ready for download.
Can I have some help please? I'm trying to get it so that is exports in this order
COMPANY NAME, CUSTOMER NAME, EMAIL, PHONE, ADDRESS LINE 1, ADDRESS LINE 2, CITY, STATE, POSTAL CODE, COUNTRY, ORDER QUANTITY
I only ever export 1 product per row. I really need some help because this is causing me to go crossed eyed.
Thanks
SJE
The current mod already gives you the option of exporting only one product per row. This is selectable from within the Admin. That part is in place.Quote:
Originally Posted by sjemms
If you want the order of the fields to be altered, I can custom alter that for you if you would like. Just shoot me a private message.
Any news on the new version (1.2.4)? I hope I hope...
Also, Have you tried to save the file as well as open it. In other words, make a backup of the cvs file on the server as well as having the popup?
Marg
I've been customizing this mod for a number of different people that have requested it and that has taken some time from the 1.2.4 version. However, the 1.2.4 version is moving along, and will be out here. Hopefully soon.Quote:
Originally Posted by Marg
It would be possible to save the file to the server as a backup. That would require the user to set the proper write permissions on the directory to which the file is saved.
I think you said that back in, oh, October 2007? Just poking fun! :shocking:Quote:
Originally Posted by econcepts
Will this mod work in version 1.3.8 because I don't want to try and explain to the client how to export via phpMyAdmin... ugh. This thing sounds perfect for what he needs.
Yes, works without a hitch on 1.3.8 and up as well.Quote:
Originally Posted by robinstl
Just want to say I love this mod. I also would like to share what I think would make it even better and more useful.
- Export Tax info column
- Export by Date Range
- Export by payment method (credit card, money order etc)
If it could do the above that would be awesome.
Thanks again
JON
I have been using this mod for months with success however in the last week it has been harder to get a full download of orders to take place. For instance right now it only downloads about 80-90% of my orders and will also have different amounts each time I run it. I can run it once and get 900 orders and then run it 2 minutes later and get 850 and then 2 minutes later and get 965 but I never can get everything. this never happened to me before and nothing has ben changed on my server since it last workied correctly. Anyone know of a solution or experience this issue?
Any help or insight would be appreciated.
Thanks
JON
I've got a question... I just installed the export orders contrib and I get an "internal server error" when I click "export shipping/order information" in the tools menu. I tried the install on another install of zen cart on the same server and also got the same error. Any clue why??
i'm running zc 1.3.8 and have no orders/customers yet in the system. I don't know if this would be an issue. I really can't wait to use this mod, it sounds great. Thanks in advance..
Will this export the attributes?
I have installed this contribution and it works great!
What can I do to get the attributes on the same as the order?
As of now, it puts a new line for each attribute.
Does anyone know how to extract the pipes into sperate columns?
Thanks
You'll have to extract them in your spreadsheet if you want to do that. The reason is that most import programs require a set amount of columns and if you take each attribute and export it into it's own column, then you have an odd number of columns which will through off most imports.Quote:
Originally Posted by wapnoj
Yes, it exports the attributes as well.Quote:
Originally Posted by webrob
This type of error is directly server (not module / contribution) related. You'll have to check with your host on it. It could be any number of things that are causing it.Quote:
Originally Posted by kjott
To get the attributes on the same line as the order, choose the "one order per row" option.Quote:
Originally Posted by webrob
Quote:
Originally Posted by econcepts
Thanks, I guess what I am asking is how to do it in the spreadsheet. Does anyone know how to do that?
Thanks
If you are using Google Checkout when you export your orders you will not be able to use this and see your order amount totals. Google checkout stores these values in another table (google_orders) not the default table (orders).
While this probably will not affect many people a company that I work for is using php scripts to automate shipping ( converting to xml, and using dazzle and worldship software ). Because of the possiblitiy of need to manual overrides we are using this mod to pull orders into a format viewable by excel, change the ship type variable if needed and run through the xml converter to print postage automatically. Seems more complicated than what it is, and it allows us to print postage for 300 orders very quickly.
At any rate the point is that they base their shipping methods in part on the the order totals. If orders are over $100 they go by UPS, not USPS, and if orders are $150 or more they are nsured.....
Since this mod doesn't take into account the order totals from Google Checkout, I had to modify it a bit. I added the following code to pull the order totals from the google checkout table into the order table:
$query = 'update orders,google_orders set orders.order_total=google_orders.order_amount where orders.orders_id=google_orders.orders_id';
If you need to see order totals and you are using Google Checkout you can place this code in the export file: Admin->shipping_export.php and it will solve the issue. Place the code near the top right after the includes.
Might be worthwile to include something like this or a conditional statment to grab the google info in future releases.
Thanks for the export btw, works great, and it saved me a lot of coding time! :-)
Hi,
I asked the below question back in September. Any news about the update? Thanks
"Hi,
A+ contrib. Thank you very much!
Any chance you can add a option to download payment type chosen aswell? :)
Thanks again
Gavin"
Well since we're asking.. ..export by date range? If exported by date, orders should have their 'exported' flag set just as before.
Quote:
Originally Posted by dhcernese
Hi there,
Downloaded the mod and installed it as per the instructions.... all I get is a blank page, no writting, no nothing!! ........ any thoughts as to why? Anyone else experienced this problem?
Here are the mods I have installed, as there might be a conflict
UK Zencart
Disable Registration
Capitalisation of fields
Add customers from admin
Admin notes
Admin Profiles
Edit Orders
Lightbox
Any help is greatly appreciated as from this thread it is exactly as I am looking for.
Many thanks
My client is a florist so they need to export the billing information as well. Is there a way I could add this to this module? Or are there any plans on having that added as well.
Thank you for such a great module! It has been very helpful already! :clap:
- Karen
WOW! I just wanted to tell you this mod is so simple, yet FABULOUS! Exactly what I had been looking for. THANK YOU!!!:clap:
I just added 180 customers from my database to my stamps.com address book in under a minute. THIS MOD IS IMPRESSIVE!!!!! You are awesome, econcepts!!
Glad you like it.
I am finishing up a new release here (just about complete) that I have been working on. It integrates a number of new features that have been requested over the past year including the ability to export based on a selected date range.
Watch for this new release in the coming week or so.
:clap: much anticipated. Will you be preserving the existing function of all-since-last-export at the same time? Want another last-minute request? We use a "clear export flag" function here.Quote:
Originally Posted by econcepts
Also, please remember to include the minor bug fixes I posted (image link, quoting fix), etc.
Thanks!
I've followed the installation in the readme text file that came with the download, but get
'Sorry, your security clearance does not allow you to access this resource.
Please contact your site administrator if you believe this to be incorrect.
Sorry for any inconvenience.'
Any ideas why this could be?
Would the fact I'm running 1.3.8 be the problem?
Thanks
Sounds like you probably have the Admin Profiles contribution installed and you need to add this module to the list of "accessible" mods.
Once you add yourself there, you should see it.
How do I do that?Quote:
Originally Posted by econcepts
I've managed to fix it
Just need to test tit on the live server
Thanks
Ok
I have installed the module on the live server and I get the following errors:
Any ideas how I'd fix these?Quote:
Warning: MagpieRSS: Failed to fetch http://www.zencartoptimization.com/wp-feed.php (Request timed out after 5 seconds) in /var/www/bullbrand/version_14.3/admin/magpierss/rss_fetch.inc on line 238
Warning: array_slice() [function.array-slice]: The first argument should be an array in /var/www/bullbrand/version_14.3/admin/rss2htmlblock.php on line 22
Warning: array_slice() [function.array-slice]: The first argument should be an array in /var/www/bullbrand/version_14.3/admin/rss2htmlblock.php on line 24
Warning: Invalid argument supplied for foreach() in /var/www/bullbrand/version_14.3/admin/rss2htmlblock.php on line 26
Thanks
Awesome news about the update. I love this mod and use it every day. What would make this even beter I think would be if it could export tax info, date range, and payment method. These aditions would make it a huge time saver.
Thanks and look forward to the update.
JON
Was trying to run something like this to automate a production process. I have the information from the database, and export it to an excel file. The file exports every product with a separate line for each attribute. This should be one line with many attributes. I would also need it to export to multiple excel files, based on product name and order number.
Any ideas? Is there a better place to post this?
Thanks, Matt
Brillant mod, my friend.
I have a virtual product so I do not require the customer to have a shipping address. All I have is the billing address. Is it possible to modify your mod to retrieve the billing information and send it to the csv file, or at least the customers name. That would rock if someone could help me out.
Thanks zenners,
Greg
Whenever I am attempting to export my customer orders, I get a CSV sheet with the headers only, but no information. Even in test mode this happens. Both Zen Cart and this module are up to date, as far as I can tell, and I'm choosing the correct options... so I'm not sure what's going on here.
Anyone else have the same issue?
- Joe
First off, thank you so much, eConcepts. I'm always impressed with how helpful people are to other users. This add-on is an essential one.
I've searched and searched but can't figure this one out. When I export orders, there is no 'State' field. I saw that the state field was commented out in the .php files so I uncommented them out. Now the field is there in the .xls files but is blank. Any ideas? Also, is it possible to export all of the other data from the order as well? This could include order total, comments, payment method, etc.
Thanks in advance for any help anyone can offer.
http://www.utahwoodturning.com
-Nils
Hi and MANY THANKS for a great module!
I just installed it, but have an issue. Although I have not downloaded/exported anything there is no "export" button. I also tried the SQL query to reset the downloaded to "no" - just in case. But still no "export" button???
Also a strange thing is that I do not see the latest orders in your module.
Apart from this all seems OK, like in the screenshot.
I´m running Zencart 1.3.8a, on PHP 5.2.5 (Zend: 2.2.0). I also have Swedish installed as language (which messed up things before I copied shipping_export.php to swedish/extra_definitions).
Did I miss something in the install, or maybe something in my SQL-database?
Thanks for any help
Erik, Sweden
I've not set the time aside to read the last 17 pages, but I think this may be the answer to my question. Here is my question, and the question I have after reading a part of this thread.
1. Is there a way that I can download the customer information, their orders, etc? I'm using the shopping cart as a registration form so I need to be able to provide all this information to the people that make the nametags, order the food, etc.
And if this is the mod I am looking for, where can I get it?
Thanks for your help!
No worries - I've figured it out and have successfully downloaded the mod, and corrected the errors that were brought to my attention with the mod. I had to upload the newer files of the html_output files found here: http://www.zen-cart.com/forum/showpo...0&postcount=10
Thanks for the mod, I hope it works well once we open up for registration!
Hi,
I uploaded version 1.0.0, ran the sql command and it worked OK, but I didn't have an entry in my Tools menu for Export Shipping/Order Information. I upgraded to 1.2.3, overwrote the old files, didn't re-run the sql command and I still don't have the Export Shipping/Order Information command in my Tools menu.
I'm using Zen Cart 1.3.8. Any ideas what might be going on?
Many thanks in advance.
You can find it here.Quote:
Originally Posted by juniper
I just had a look in phpMyadmin and not being an sql guru or anything but I did manage to see the 'download_ship' entry in the 'zen_orders' table.Quote:
Originally Posted by 10gallons
I just don't have an "Export Shipping/Order Information" entry in my Tools menu.
Any ideas?
Sorry I'm an idiot. One day I learn to copy files to their correct location. Please delete these posts in the thread if you wish.
One thing I'd like to be able to do is ... My product has 3 visitor selectable attributes, I can see these in the report I get, but it would be great if they could all be in their own column with their descriptive field removed. At the moment I get this ...
Packaging & Handling: $X.00 per bar | Height (in mm's): 550 | Width (in mm's): 510 | Colour: black |
in a single column called Product 0 Attributes. It'd be great to get Height, Width and Colour exported into their own columns, but without the wording of Height Width and Colour in the column as well, if that makes any sense.
Also, all the text on the right hand side where you select your options is all text_this and text_that. Like this ...
TEXT_ADDITIONAL_FIELDS
TEXT_SHIPPING_METHOD_FIELD
TEXT_SHIPPING_TOTAL_FIELD
TEXT_PHONE_NUMBER_FIELD
TEXT_ORDER_TOTAL_FIELD
TEXT_ORDER_DATE_FIELD
TEXT_ORDER_COMMENTS_FIELD
Is that normal??
The only columns that are populated are the email and order id. Is there something I am missing?
Thanks.
Can anyone help? When I do an export the customer's information does not export. Is there something I am doing wrong, a box I need to check off? :( Thanks.
The columns that are empty are:
First Name Last Name Company Delivery Street Delivery Suburb Delivery City Delivery State Delivery Post Code Delivery Country
hi, thank you for this mod, i need it very much, but i got a problem, the customer names and addresses on my order page including the special characters é è ç , after i export the information, those characters become ? ? ? , :unsure:
This is not my mod but I have run into similar situations with other internet related items and typically the situation you are listing is a result of the HTML page "character set" being used. For example, if the page character set is UTF-8 and you export in a different character set format (or don't recognize the UTF-8 conversion) then characters you think should bee one thing change themselves to be another.Quote:
Originally Posted by myworld20091
It sounds like that is what you are experiencing, but again, since this is not my mod I don't know how it works with character sets etc...
Hope that helps.
i cant get it work but i have an idea, perhaps i could display all the columns on the page shipping_export.php, then copy and paste them to my excel?Quote:
Originally Posted by econcepts
i dont know what do i make all the colums showing on shipping_export, currently there are 10 colums:
Order ID, Email, Customer Name, Company, Delivery Street, Delivery Suburb, Delivery City, Post Code, State, Country
i need to show all the others:
Shipping Method, Shipping Total, Phone Number, Order Total, Order Date, 1st Order Comment, Full Product Details, Order Tax Amount, Order Subtotal, Order Discount, Payment Method, Order Status
could you help me with this modification? thanks in advance.
Ah, now it sounds like you're talking about the module I created. The columns / options you are listing are those that are in my mode.Quote:
Originally Posted by myworld20091
I could help you with customization of this to make it work for you.
Send me a private message and we can go over the details.
I could look at this today if needed.
- Eric
Great contribution!
I am having a similar issue to the ones previously described. I have gone back and attempted that fix that was described back in post 69 but that line seems to already been removed most likely when the newest version was released.
When I export orders, I only get 4 in the csv while I have a couple hundred orders displayed on the screen. These four orders also happen to be the ones that I created from the back end using the Add Customer module.
I have since uninstalled the Add Customer module as well as all other add ins to my cart and run the appropriate sql queries to uninstall them, I uninstalled and reinstalled this module, and I created a new order - same problem!
I am out of ideas to resolve it, please help!!!
Rich
Hi there
I have one quick question about Export Shipping Information mod.
Is it possible to export customers email addresses only into the spreadsheet, as this is what I need to do.
Also, is it quite safe to install this mod, as I have no idea how to back up my website and I don't have an access to mysql
Cheers in advance
Hi,
I hope someone can help me. I used to use the addon some time ago on 1.3.7 and was working great. An excellent module.
I have now created a new site and using 1.3.8a.
I have tried using all the options but no information is downloaded. I get all the information showing on the left hand side. All I get are the field names and no orders data. I always use test mode so they can be re-expored if required.
I dont know if there is a problem with this in 1.3.8a?
I have updated with the SQL statement. So cant see where I am going wrong, some help would be really appreciated if possible.
Many Thanks
Samantha
The most recent version had a few bugs in it that are corrected in my version 1.2.7 (soon to be released).Quote:
Originally Posted by ffemtshok
The most stable version is 1.2.5 at the moment.
It is safe to install this mod.Quote:
Originally Posted by safeg
But to export just email addresses only I recommend the following module by Dr. Byte:
Email Address Exporter
This mod had been tested and works on all versions of zen (including 1.3.8a).Quote:
Originally Posted by Sam_uk
When you upgraded could you possibly have altered the way the "state" field displays on the "create an account" form?
Older versions had a bug in them when the state was selected from a drop down (instead of entered by hand into a text field.)
My new version (1.2.7) soon to be released should correct this issue.
How do you have customers enter their "state" on that form currently?
You might also try the add-on we've contributed: http://www.zen-cart.com/index.php?ma...oducts_id=1500Quote:
Originally Posted by Sam_uk
Please let me know if you see problems with it.
Hope this helps.
Apsona
http://apsona.com
Hi Guys,
The install is a fresh 1.3.8a no upgrades, no alterations made to the state field from what I know.
Apsona thank you for the alternative, will do the job for now
Thanks for all your help guys
Samantha
Sam,Quote:
Originally Posted by Sam_uk
What version of the mod are you running?
1.2.7 is being BETA tested by my members currently and is just about ready for release (a few minor bugs we ran across). This corrects a number of bugs that were introduced in versions 1.2.5 and 1.2.6.
Also, did anything change on your server (PHP version, MySQL Version, etc...)
I would like to export:
products
total sale price
delivery method
name/company address
into .doc file. Is this possible?
Some suggestions, though I'm not sure I fully understand your requirement. If you want to simply export all fields from your order records, you could use our add-on available here: http://www.zen-cart.com/index.php?ma...oducts_id=1500
If you want to export fields from multiple records, e.g., some fields from orders, some from the related products, and some from the related customer, you can use our free ShopAdmin tool to create a custom report containing the fields you want, and then export the results of running it.
Hope this helps.
Apsona
http://apsona.com
i want to export to .doc file and then just print all orders out.
What ever became of v1.2.7?
Did the focus shift to Apsona CSV data exporter?
i need a way to export the order info into word so it is easy to print out for the packaging...
Nope. No focus on that at the moment.Quote:
Originally Posted by split63
I just completed the newest version and that is being uploaded now. It is 1.3.0 (moved from 1.2.6 to 1.3.0 due to some new functionality add-ons.)
I just submitted to the zen cart upload section and will post a direct link to it here (with more info) in a minute (in case you can't wait for it to activate on the zen cart downloads side.)
Ok, here is the direct link to the page you can download this new 1.3.0 version from if you don't want to wait for it to be activated in the Zen Cart downloads section (it has been submitted ... just waiting for the Zen Cart team to activate it.)
http://www.zencartoptimization.com/downloads/
Here are the changes and updates you'll find in the 1.3.0 version:
1) Added ability to have the exported file either downloaded to your computer or automatically sent to a desired email address. This is nice for automating the sending of orders to suppliers for fulfillment (as in the case of those using zen cart to drop ship).
2) Added ability to automatically update the order status after a successful export. Status can be updated to what ever you choose (from dropdown).
3) Added ability to include header row or leave it out of your exported file.
4) Added the ability to export different file types. (CSV / TXT)
5) Bugfix: REMOVED the option to export manufacturing data as it was causing problems. (This will be added in the next release after worked on a bit.)
6) Bugfix: Corrected issues with Company Name not showing up in export.
7) Bugfix: Corrected issue with some people getting a header row but no orders exported.
8) Moved product details field data to the end of the export again. After recent additions to new fields the product details were showing up in the middle of the exported file and this could throw off columns if exporting 1 order per line on mixed orders with attributes and without.
A number of things are needed for this to happen. Got your private message and am responding to that to figure out what might be able to be done (and present options available to you that you might want to consider which are already built into native zen cart.)Quote:
Originally Posted by riolas
Great. Let me know as soon as you can.
I installed 1.3.0 into my 1.3.8a store-- I've become one of those people with no exports! I tried all sorts of combinations, everything I could think of. :yuck: I cannot get it to export anything, I am rolling back once again to 1.2.2 !:oops:Quote:
Originally Posted by econcepts
...it does successfully set all the orders downloaded_ship = "yes" :wacko:Quote:
Originally Posted by dhcernese
I'm reading the code and I can't see how it could ever work!Quote:
Originally Posted by dhcernese
Specifically, it no longer echos $str_export inside the loop. It only writes a single record to either to be emailed or the download. :blink:
So I change it to clear the $str_export before the loop and inside the loop begin $str_export construction with .=
Now it outputs orders :clap: (but only in 1 order per row mode)
You got same major bugs dude, maybe you uploaded the wrong version??
I debugged a little further, I need 1 order per product-- if I try that it outputs every order 240 times! :(Quote:
Originally Posted by dhcernese
I forgot to mention: in order to get this to work at all for my order, I had to rename the ACCOUNT_STATE variable (and just to be safe, I commented out the devliery_country stuff).. ..that indicates to me that your ACCOUNT_STATE code is not going to work for me.Quote:
Originally Posted by dhcernese
:clap: I commented out all the country code stuff and now even 1 product per row works (and no multiplier by 240, which might have something to do with the number of countries?).Quote:
Originally Posted by dhcernese
fyi -- the last history comment can have newlines in it and the attributes can have ^M^J in them, neither are cleaned.