Export Shipping & Order Information

trickobrien:

A big thank you for this contribution by the way.

I have a customer who isnt comfortable working in his Zen Cart admin,this contribution allows him to login,export and log out in under a minute.Couldnt be easier :)

Excellent. Glad you like it and thanks for the kind feedback!

Hi,

That's a really really good plugin, thanks a lot for sharing...

Is there any way I can export with ';' instead of ',' ? Without breaking the layout ? as i changed the line $FIELDSEPARATOR = ','; to $FIELDSEPARATOR = ';'; and it didn't really work...
Thanks for your help.

Cheers,
meth0d

meth0d:

Hi,

That's a really really good plugin, thanks a lot for sharing...

Is there any way I can export with ';' instead of ',' ? Without breaking the layout ? as i changed the line $FIELDSEPARATOR = ','; to $FIELDSEPARATOR = ';'; and it didn't really work...
Thanks for your help.

Cheers,
meth0d

You are correct in making the change in the location you indicated. Using a semicolon however might interfere with the coding. What happens when you enter the semicolon? What type of error / problem arises?

Is there a way a to get State names as 2 letters and not the full name?

Hi Eric,

I seem to be having the same problem I had last year. The export worked great all year. But as soon as year end hit and the orders spanned the end of the year, the export gives me an empty file.

I've been using exactly the same settings as always because I have them hard-coded.

The first time I tried it, I did not put a date range. It showed me about 20 orders on the screen, but the file was empty.

Then I put in a date range which should have covered those same 20 records. Again I got a blank file.

I'm using version 1.3.2.

Thanks, Susie

Hi, has anyone installed this with v1.5? I have done but cannot get the page to show. ie from within admin, go to Tools> Export Shipping/Order Information. this does not exist after installing it. I can however get to the page by changing the web browser url to ....../adminxxxx/shipping_export.php

I would like to be able to get to it via the tools tab if this is possible. I assume the page just needs registering through admin page eegistration but have little idea of what info is required in the boxes

Any help will be much appreciated.

Thanks

webstar59:

Is there a way a to get State names as 2 letters and not the full name?

This was in one of the versions but it ended up throwing off the entire file for some reason. I took it out and thought about adding it at a later date.

susb8383:

Hi Eric,

I seem to be having the same problem I had last year. The export worked great all year. But as soon as year end hit and the orders spanned the end of the year, the export gives me an empty file.

I've been using exactly the same settings as always because I have them hard-coded.

The first time I tried it, I did not put a date range. It showed me about 20 orders on the screen, but the file was empty.

Then I put in a date range which should have covered those same 20 records. Again I got a blank file.

I'm using version 1.3.2.

Thanks, Susie

A few questions for you:

1. What did we determine was the issue and what corrected it for you last time?

2. About how many records do you think it is trying to export? Could your server be timing out due to the php time (processing setting) for scripts? If you you'll want to increase the memory limit in your php setting.

3. Does it work with shorter date ranges? If so, it might have something to do with #2 above.

4. Is there an order in there (from earlier in the year when it may have been a problem originally) that could be causing the entire file to end up blank?

Let me know some of this info and we'll see what we can come up with to correct it.

Well, the mysterious problem has mysteriously vanished. I set download_ship to no and tried again. Worked fine. Weird.

The last time you had me download a more recent version.

So...who knows? In answer to your question, there were only about 50 records, so I don't think it was a timing out issue.

quick1:

i get it done :smile:

but another issue, i use quantity discount module, when i export orders, the tax doesn't calculate correctly cause it ignores quantity discount value. then the tax exported is not same as the tax in admin invoice.

what do i make the tax exported just be same as it shows in admin invoice? :unsure:

I know this is a really old post, but was a resolution for this ever found? I am having the same issue. When using the quantity discounts module, the figures are incorrect.

Also, a request.. When you don't select a payment method in the dropdown, would it be possible to display the payment method on the report? My client needs to be able to sort by the payment method and it would be great not having to export each payment method group separately to know which is which.

abcisme:

I know this is a really old post, but was a resolution for this ever found? I am having the same issue. When using the quantity discounts module, the figures are incorrect.

Also, a request.. When you don't select a payment method in the dropdown, would it be possible to display the payment method on the report? My client needs to be able to sort by the payment method and it would be great not having to export each payment method group separately to know which is which.

The first issue has not been resolved yet. I would have to look at the ability to display the payment method when none is selected.

tat2nu:

I guess that I missed that one. Just trying to be helpful and save some people a little unneeded aggravation.

Thanks Eric...

Marc

You just saved me some aggravation trying to work out the Syntax of checkboxes - but via a working example - so thanks Marc! :clap:

Hi -

Great add-in and worked well for a while, but then suddenly stopped working. We have ZC 1.3.9f.

I applied a fix Eric posted earlier in this thread to change a few lines of code around line 95 of shipping_export.php and that fixed one error, but now I've got a new one. (Post 286 - http://www.zen-cart.com/showthread.php?75406-Export-Shipping-amp-Order-Information/page29)

It only happens when the option "1 Product per Row" is selected. Unfortunately this is the one we need for our fulfillment partners to process.

Here is the error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
in:
[SELECT Count(*) as num_rows FROM orders_products_attributes WHERE orders_id = 12050622 AND orders_products_id = ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Can anyone help?

dkwwkd:

Hi, has anyone installed this with v1.5? I have done but cannot get the page to show. ie from within admin, go to Tools> Export Shipping/Order Information. this does not exist after installing it. I can however get to the page by changing the web browser url to ....../adminxxxx/shipping_export.php

I would like to be able to get to it via the tools tab if this is possible. I assume the page just needs registering through admin page eegistration but have little idea of what info is required in the boxes

Any help will be much appreciated.

Thanks

I'm having the same problem. Great module but could just do with a fix to make it easier to get to!

We're having the same problem. Is there a fix for this?

We have version 1.3.2 with ZC 1.3.9h

This works fine, EXCEPT when we try to export 1 product per row. Then we get an SQL error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 in:
[SELECT Count(*) as num_rows FROM orders_products_attributes WHERE orders_id = 19012 AND orders_products_id = ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Is there a fix for this?

dkwwkd:

Hi, has anyone installed this with v1.5? I have done but cannot get the page to show. ie from within admin, go to Tools> Export Shipping/Order Information. this does not exist after installing it. I can however get to the page by changing the web browser url to ....../adminxxxx/shipping_export.php

I would like to be able to get to it via the tools tab if this is possible. I assume the page just needs registering through admin page eegistration but have little idea of what info is required in the boxes

Any help will be much appreciated.

Thanks

Hi All,

I was able to get the menu item to show by following the advice on this forum post Addons / modules not visable in admin

To do so create a php file under <YOUR_ADMIN>/includes/functions/extra_functions/init_shipping_export.php and include the following code:

<?php
if (!defined('IS_ADMIN_FLAG')) {
	    die('Illegal Access');
} 

if (function_exists('zen_register_admin_page')) {
	    if (!zen_page_key_exists('shipping_export')) {
		             zen_register_admin_page('shipping_export', 'BOX_TOOLS_SHIPPING_EXPORT',
				                 'FILENAME_SHIPPING_EXPORT','' , 'tools', 'Y', 20);
			         } 

	        
}

?>

I had to clean out some initial attempts from my admin_pages database table, and then voila! it worked!

Hope this proves helpful to others!

Regards,
Jason

:cool:

Hi,

Thanks for this great mod! We are looking for a way to include the customer's Billing Address information in the export file. Could you point us to information on how to do this, or ?

thanks!

It looks like the "Orders Products ID" is blank in this case (meaning there is something missing in the db relating to the order.)

Find out what that might be be looking at this order compared to another (at the database level might be easiest) and then report back here so I can help you get around it.

You would need to open up the "shipping_export.php" file (in the admin directory) and then my recommendation would be to copy the lines for the "shipping information" and alter to include the billing info for the customer. You will need to alter this in multiple areas of the script and may also need to alter some SQL queries for it to work.

If you need help adding this let me know (just send me a private message). I've customized this for many others.