OLD Super Orders 2.0 (See v3.0 thread instead)

A little more info re: my PayPal error with SO. After checking the PayPal cURL logs (/includes/modules/payment/paypal/logs) I noted that the customer made 2 attempts 10 minutes apart to complete the transaction. The first time the PayPal server reported a "500 Internal Server Error" for the "DoExpressCheckoutPayment" transaction. Is it possible that when the transaction finally succeeded, the SO database was not updated?

i'm trying to integrate edit orders and super orders i did this

<tr>
        <td class="main"><?php echo '<a href="javascript:popupWindow(\'' .
          zen_href_link(FILENAME_SUPER_EDIT, 'oID=' . $oID . '&target=product', 'NONSSL') . '\', \'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=650,height=450,screenX=150,screenY=100,top=100,left=150\')">' .
          zen_image(DIR_WS_IMAGES . 'icon_edit3.gif', ICON_EDIT_PRODUCT) . ICON_EDIT_PRODUCT . '</a>'
        ?>
        <?php echo '<a href="javascript:popupWindow(\'' .
          zen_href_link(FILENAME_EDIT_ORDERS, 'oID=' . $oID . '&target=product', 'NONSSL') . '\', \'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=650,height=450,screenX=150,screenY=100,top=100,left=150\')">' .
          zen_image(DIR_WS_IMAGES . 'icon_edit3.gif', ICON_EDIT) . ICON_EDIT . '</a>';
        ?></td>
      </tr>

but now i get a  at the top left corner of the super orders page any ideas how i can clean up the code to get rid of that line

this edit was to super_orders.php line 673-682 i think

i checked out these 2 posts

http://www.zen-cart.com/forum/showpost.php?p=485965&postcount=814
http://www.zen-cart.com/forum/showpost.php?p=546046&postcount=1019

i can't seem to get this to work i get the following error when i try to print batch invoices
 
Fatal error: Call to a member function on a non-object in /home/www/gorillagear.ca/store/admin/super_invoice.php on line 38

files i edited super_stylesheet.css, super_batch_forms, super_packingslip, super_invoice and super_shipping_label

step1: i replaced all instances of require with require_once in super_batch_forms, super_packingslip, super_invoice and super_shipping_label

step 2: in super_batch_forms at around line 229 i replaced everything from function to closing php tag with this code

function batch_forms($target_file, $selected_oids, $num_copies = 1)
{
	// begin error handling
	if (!is_array($selected_oids)) { exit(ERROR_NO_ORDERS); }
	if (!is_file($target_file)) { exit(ERROR_NO_FILE); }
	// end error handling
	
	unset($batch_order_numbers);
	foreach ($selected_oids as $order_number => $print_order)
	{
	  $batch_order_numbers[] = $order_number;
	}
	sort($batch_order_numbers);
	
	if (file_exists(DIR_WS_LANGUAGES . $_SESSION['language'] . '/'. $target_file))
	{
		include_once(DIR_WS_LANGUAGES . $_SESSION['language'] . '/'. $target_file);
	}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
		<title><?php echo TITLE; ?></title>
		<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
		<script language="javascript" src="includes/menu.js"></script>
	</head>
	<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<?php
	$_GET['pagebreaks'] = 1;

	foreach ($batch_order_numbers as $order_number)
	{
		$_GET['oID'] = $order_number;
		for ($copies = 1; $copies <= $num_copies; ++$copies)
		{
		  include($target_file);
		  echo '<div style="page-break-after: always;"></div>';
		}
	}
?>
	</body>
</html>
<?php
	require(DIR_WS_INCLUDES . 'application_bottom.php');
}

step 3: at the bottom of the super_stylesheet.css i added the pagebreak

.endline {
page-break-after: always;
}

step 4: added the pagebreak inside the </body> tag

<div class="endline">------------ pagebreak --------------</div>

so what did i do wrong

I think that Super Orders is too tedious. With Google cart I get another order to close out so this is too much. Is there a way to simplify this?

MB1:

step1: i replaced all instances of require with require_once in super_batch_forms, super_packingslip, super_invoice and super_shipping_label

On super_batch_forms don't do the 'require_once'. leave it with just 'require'.

Just discovered a small glitch in the Reports>Orders Awaiting Payment. When I tried to run it I got an error:

"super_report_await_pay.php line 364. Parse error- unexpected '}'.

Traced the error to a short php tag on line 122. Should be '<?php', not '<?'.

mauryg:

If it's a "partial" shipiment of a single item, then I would have to split the order to remove the partial item, delete that order and create 2 new orders using "Encrypted Password", one for the amount to be shipped now and one for the balance to be shipped later. Lots of work. Easier to tell the customer you'll ship the whole amount when you get the balance.You might find this helpful. It's a slightly reworked super_edits file that allows you to split individual lines on an order. So for example if a customer orders 5 widgets and you've only got 3 in stock, you can move 2 to another order using super_edit's edit orders function without having to do all that deleting orders and using "encrypted password" to reconstruct them from scratch.

It's not the most elegant of code and you will still need to tweak the tax and shipping figures by hand, but it's a lot more straightforward (and less work) than the alternatives.

Attachment #3968

@Kuroi,

Thanks, Every little bit helps.

Right now I'm looking at modifying the Fedex Automated Shipping Labels mod to work with SO the way USPS Autofill does. Will let you know if it works.

Will that Super Edits you just mentioned allow me to add items and edit shipping and pricing?

I also need to know how to eliminate the second order that Google Cart adds.

It is annoying to have to close out 2 orders per customer. I don't know how this affects my Cash Flow Reports. Do you?

webskipper:

Will that Super Edits you just mentioned allow me to add items and edit shipping and pricing?

I also need to know how to eliminate the second order that Google Cart adds.

It is annoying to have to close out 2 orders per customer. I don't know how this affects my Cash Flow Reports. Do you?In answer to your first question, no. There is a separate edit orders mod which I suspect will support some of what you want, but I haven't used it for a long time and remember it as being a bit buggy.

Can't comment on your Google Cart issues as I've never used it.

Yup, have that one and Super Orders killed it.

I need to be able to touch all aspects of an order before it ships.

I'm testing this one. I can't add PayPal as a payment method, I always get an error from the data base on Duplicate entry, though there's no duplicate!

PayPal payments show as completed on Super Orders, but still the total amount shows as due. Why can't SO understand paid IPN purchases?

Is there a way to mark batches of orders as completed?

heidikfi:

I'm testing this one. I can't add PayPal as a payment method, I always get an error from the data base on Duplicate entry, though there's no duplicate!
I'm assuming that you are getting a SQL error, correct? Can you give me the exact error text you are seeing?

PayPal payments show as completed on Super Orders, but still the total amount shows as due. Why can't SO understand paid IPN purchases?
Two reasons. First the currently released version does not manage PayPal payments made at checkout. 2.1 does. Second, if you process the payment AFTER the checkout is complete, SO will not automatically update because SO does not tie into any external payment systems (yet).
Is there a way to mark batches of orders as completed?
No, but good idea.

@Kuroi: I am looking at your code and will see about incorporating it.

@All: Will have some word on 2.1 soon. I am working on the installer, and getting some support for the returns and exchanges from the team (Toronto was very enlightening all around). None of us want to put code out there that could run contrary to future core admin features. You want me sane, trust me on that one.

Also I am handling mauryg's issues offline. Just FYI for anyone thinking about that one.

UPDATE on various issues I posted:

After a few exchanges with Frank (Blindside) I think I have my answers.

1. The strange "disappearing" order in post #1042 could NOT be duplicated in my WAMP test system, so it appears it was an unknown gremlin. (Hate those!). As for the "Order Complete" and "Order Cancelled" they seem to just put a big time and date stamp on the top of the order details page. Useful.

2. The PayPal problems I reported in 1043 and 1044 are similar to one reported by heidikfi in 1056. From Frank's comment it looks like this will be fixed in v2.1.

3. As for the short php tag mentioned in 1050, this is a carryover from PHP4 practice and causes problems on some servers with PHP5 like GoDaddy. I now go through ALL of the mods before I install them and search and replace the '<?' tags with the proper '<?php' tags.

Thanks Frank, your disguise is working very well. :clap:

The error was the 1062 on duplicate entries, when I tried to add PayPal (PP) as a payment method in Super Orders. The error message stated that PP was inserted twice. I have a trilingual website and inserted PP in three languages. When I went to check the database, there was only one entry of PP. I only inserted it once. Can't copy the exact error message here, since I got it several days ago. It looked exactly the same as many people here have copied it (error 1062), except for the PP as the duplicate entry.

The problem others have posted about occurred during system installation; your problem sounds like it's post-install, right?

Anyway, if you look at the so_payment_types table, you'll see there's a unique requirement on the payment_type_code field. If you are trying to insert a PayPal payment type, and already have one for another language, you need to make sure that you don't use the same value for the shorthand code.

The invoice on super orders doesn't show the complete shipping method field as it does in the regular orders invoice. For instance, SO shows United States Postal Service: and the regular orders invoice shows United States Postal Service (Priority Mail):. Have I missed something during installation or is something I need to modify and if so, what file(s). Thanks.

BlindSide:

The problem others have posted about occurred during system installation; your problem sounds like it's post-install, right?

Anyway, if you look at the so_payment_types table, you'll see there's a unique requirement on the payment_type_code field. If you are trying to insert a PayPal payment type, and already have one for another language, you need to make sure that you don't use the same value for the shorthand code.

It's a post-install problem, since I only started testing the mod after installing my test shop.
The language system gives three alternatives for three languages when adding a payment method, so I did the insertion only once. The code is the same in all languages. That's how it works for ZC.