Export Shipping & Order Information

[Tereadia]

Haven't seen anyone with this problem yet, but I installed this shipping export add-on, on v.1.3.8 I tried to run the sql but it said that it failed because the column already existed, although I haven't used this add-on before now. Now when I go to Admin > Tools > Shipping Exporter I get a 500 Internal Error. The rest of my admin is working fine, but I can't get this to work. I also installed orders exporter, but it exported everything except the info I needed price. I need to know how much each customer has paid for their order and shipping so I can do my taxes and accounting properly. Thanks for any help!

[Centec2b]

Haven'........shipping export add-on, on v.1.3.8 I tried to run the sql but it said that it failed because the column already existed, although I haven't used this add-on before now. ..................I get a 500 Internal Error...... I also installed orders exporter, but it exported everything except the info I needed price

Ignoring the 2nd contribution comments

Are you happy the rest of the installation was ok? Can you see the contribution ok in admin?

The server error is a general error message saying an unexpected condition prevented it from fulfilling the request. If you are comfortable with something like phpmyadmin, I would go and have a look directly at your database files. If your server is saying the column already existed, there has to be a reason for it being there - sounds odd that some other contribution requires the same SQL alteration. What other contributions do you have? Do they require a SQL insertion?

My personal inclination would be to identify if there has been an alteration to the data files and either remove the offending alterations/data or possibly a safer bet restore from an earlier backup and reapply the SQL statement. I should caveat these remarks with the comment BACKUP before you start delving in the database.

Hope this helps

Centec2b

[econcepts]

Haven't seen anyone with this problem yet, but I installed this shipping export add-on, on v.1.3.8 I tried to run the sql but it said that it failed because the column already existed, although I haven't used this add-on before now. Now when I go to Admin > Tools > Shipping Exporter I get a 500 Internal Error. The rest of my admin is working fine, but I can't get this to work. I also installed orders exporter, but it exported everything except the info I needed price. I need to know how much each customer has paid for their order and shipping so I can do my taxes and accounting properly. Thanks for any help!

What column did it say already existed? The only column added during this install is a "downloaded_ship" column. You could have received this error if you tried to install and it failed at one point. Then tried to re-install (refresh etc...) and the system saw the column which was already added during the first attempt.

A 500 Internal server error usually means something on the server end had issues (these come directly from the server side).

If you want to install my advice would be to run the uninstall program (a small sql file) and then re-run the install program (the first time install) and that should do it.

Report back what you find and I'll see if I can walk you thorough how to get it moving.

[econcepts]

Eric, All

Good Evening

First respect and thanks for a very useful tool

Have you had any further thoughts regarding this bug?

I have the same problem. The odd thing is ver 1.2.3 works fine on my localhost xampp system 1.3.8 cart, but will not show the dates or the export button in the live production version. I have installed ver 1.2.2 to my production 1.3.8 Cart and it works fine! The local xampp version is running mysql 5.067 and php 5.2.6 whilst the production server is running mysql 4.1 and php 5.2.6 (until it is upgraded to msql 5 in a couple of weeks).

I have compared the main file admin/shipping_export.php and there is quite a bit of difference isnt there

So I will retest when the upgraded version of php is running

Cheers
Centec 2b

Centenc,

I mentioned possibly finding a reason as to why some were experiencing part f the screen not loading (and no export button) in a post a short while back.

Have you got your end working yet and if not, would I be able to get into your system to try to correct the error (I think I have a fix). I have yet to be able to duplicate the issue (think it a combination of coding and PHP verision along one area of the code.) but want to try it on a site that is missing that button to be sure.

Let me know.

[Sailman]

Eric:

I am experiencing the same problem reported in previous posts. The mod installs fine, but the bottom half of the screen is missing, with no order data shown, and no Export button. I have ZC version 1.3.8a and your mod version 1.2.3 installed on a working server, but the store is hidden from the public for setup and testing purposes.

Reply to me by PM, and I can set you up with access to my Admin and root if you want to try something.

[econcepts]

Eric:

I am experiencing the same problem reported in previous posts. The mod installs fine, but the bottom half of the screen is missing, with no order data shown, and no Export button. I have ZC version 1.3.8a and your mod version 1.2.3 installed on a working server, but the store is hidden from the public for setup and testing purposes.

Reply to me by PM, and I can set you up with access to my Admin and root if you want to try something.

Jim,

Ok, thanks for the PM and login details. Check it now. I didn't have any problems with the install (less than 3 minutes) and it all looks ok to me. I posted a link to the page I see (works fine) in your PM area. For privacy reasons I'll leave it there.

Can you confirm that you see it OK now as well? I never did get the same thing you or others have reported (it worked for me from the start) which puzzles me.

If it works for you now then I am wondering if it has something to do with installation for some (incorrect install). I'd like to work through it to see what might be the culprit for others that have seen the issue.

Report back your findings here.

Thanks!

[Sailman]

econcepts:

You are correct, sir.... The Admin page is complete and functional. I was very careful in the insertion of the files, and checked back on my backup copy and the files were correctly placed.

Here is my guess as to what the installation problem was: For the other "orders export" mod in the Download section, the file -orders_Exporter\admin\includes\boxes\extra_boxes\ordersExport_tools_dhtml.php - has the same name.

If the file was not removed, or my FTP didn't overwrite it, then that could have been the problem.....

However, thanks to your efforts, the Admin page is working, but the .csv file exported contains only headers, no data.

Thanks again for your help, but what do you think the problem is?

[misscotton]

Hi - i am hoping you can help me here. I am modifying this add on to include a "Product Cost" column to the report. I have it working except I can't quite figure out how I take the value and place it into the new column I created. It is essentially making the same query to the db as what is used for filling the "Products Atrributes" column only I don't need to format the multiple attribute options, i.e. like below where the field I am pulling out of the db is "options_values_price_w":

$product_attributes_rows="SELECT Count(*) as num_rows
FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "
WHERE orders_id = " . $order_details->fields['orders_id'] . "
AND orders_products_id = " . $order_details->fields['orders_products_id'] . "";
$attributes_query_rows = $db->Execute($product_attributes_rows);
$num_rows = $attributes_query_rows->fields['num_rows'];

	If ( $num_rows > 0) {
	$product_attributes_query="SELECT *
	FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "
	WHERE orders_id = " . $order_details->fields['orders_id'] . "
	AND orders_products_id = " . $order_details->fields['orders_products_id'] . "";
	$attributes_query_results = $db->Execute($product_attributes_query);
	$str_export = $str_export . "\"";
		for ($i = 0, $n = $num_rows; $i < $n; $i++) {
		$str_export = $str_export . $attributes_query_results->fields['options_values_price_w'] .
		$attributes_query_results->MoveNext();
		}
	$str_export = $str_export . "\"";

}

If I replace this code with what is used to fill the "Product Attributes" column it shows the cost value properly. But I would like both columns displayed - "Products Attributes" and "Product Cost". I added the name of the column successfully like below, but don't know what would make the data go into that column:

if ($_POST['product_details'] == 1) { // add to header row
	if ($_POST['filelayout'] == 2) { // 1 Product Per row RADIO
			$str_header = $str_header . ",Product Qty,Products Price,Product Name,Product Model,Product Attributes,Product Cost";
	} else { // File layout is 1 OPR
	/**************the following exports 1 OPR attribs****************/
	  $oID = zen_db_prepare_input($order_details->fields['orders_id']);
	  $oIDME = $order_details->fields['orders_id'];
	  $order = new order($oID);
		for ($i = 0, $n = $max_products; $i < $n; $i++) {
			$str_header = $str_header . ",Product " . $i . " Qty";
			$str_header = $str_header . ",Product " . $i . " Price";
			$str_header = $str_header . ",Product " . $i . " Name";
			$str_header = $str_header . ",Product " . $i . " Model";
			$str_header = $str_header . ",Product " . $i . " Attributes";
			$str_header = $str_header . ",Product " . $i . " Cost";
	    }
	/*****************************************************************/
	} // End if to determine which header to use
} // end Row header if product details selected

hope that makes sense - I feel like I am really close to figuring it out, but I am kinda crash coursing learning db and php coding to make this work..any help would be appreciated....thanks

[ccn1]

Hi All

Great contribution and exactly what we are looking for to use, however I must be doing something wrong....

I don't have any error messages, just the download button is not being shown no matter what I try.

Also the order list does not seem to change when I alter the status on the right.

I am using Export shipping module 1.2.3 and zencart 1.3.8a.



Thanks in advance.

[econcepts]

Hi All

Great contribution and exactly what we are looking for to use, however I must be doing something wrong....

I don't have any error messages, just the download button is not being shown no matter what I try.

Also the order list does not seem to change when I alter the status on the right.

I am using Export shipping module 1.2.3 and zencart 1.3.8a.



Thanks in advance.

I've heard this report more and more frequently now. I worked with another zen cart user who had the same issue and all I did was re-install the mod to get it working.

I'd like to look into your issue for you. Send me a private message and we can figure out a way for me to get in and look at it.

I have yet to be able to duplicate this problem on any site (even those I have helped resolve the issue) and I am eager to find out why it seems to occur so another site to look at (yours) would be great.

Please send me a private message and we'll get in to look at it.

Thanks!