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

"Good news" update: All the logic and reporting for returns and exchanges is complete. The entire process for returns and exchanges is done using a four-step popup window, including all the auto-status and notification options used elsewhere in SO. The system also stores enough info to generate a "snapshot view" of the order as it existed at the time the return was processed, allowing you to view the changes over time.

I am moving on to the code to add a new product (independent of a return), and edit existing products. Since these are derivatives of the return/exchange logic, I'm hoping it won't take too long (but of course they vie for the same attention I have to give to the rest of my work). Still, though you'd like to know.

Thanks for the update and hard work.

I have done a fresh install of super orders 2 on Zen Cart 1.3.7 Everything seems to have gone right except for one thing. I dont have the customers > super orders option.

I checked my tables and all the inserts seemed to perform properly. What can it be?

Also

Install "Purchase Order" Payment Module

I dont have "Purchase Order" under payment module

kmallea:

I have done a fresh install of super orders 2 on Zen Cart 1.3.7 Everything seems to have gone right except for one thing. I dont have the customers > super orders option.

I checked my tables and all the inserts seemed to perform properly. What can it be?
You didn't upload the files properly, or didn't upload at all. Make sure the files ended up in your admin folder. For instance, make sure you don't have a folder "admin" inside the real admin folder.
Also

Install "Purchase Order" Payment Module

I dont have "Purchase Order" under payment module
Likely the same problem. Make sure the files are all uploaded properly.

FTP the contents of [temp directory]/catalog into the root of your Zen Cart
installation (i.e. your "/catalog" folder).

your "/catalog"

I assumed there was a folder already called catalog.

catalog represents my root.

"FTP the contents" I read but didnt comprehend I guess. I got it now.

Hey Blindside,

Okay, I verified I had installed rev45. I redownloaded the latest version from this site and went through each file, verifying that the modified dates were the same. They are. Plus, this snippet I got when running the upgrade file is in the latest version of the super_upgrade.php.

I got a little thrown by the idea it was an older version, because I can't find any mention of this installation step in the README or anywhere else. If this was just a mistake, no problem -- just let me know because I'm waiting to try to find the right place in that file to add the snippet.

I'm being cautious as I can too easily create bugs by doing things I don't understand.

I include our previous posts on this subject so you know what I'm talking about. :) And, thanks for being so thorough by responding to everyone's issues!

BlindSide:

The line numbers likely changed in newer versions since I wrote that text, however the code block you quoted is from an older version. Are you sure you have the latest one from the download section of the site? Double-check, and then read through the readme, as this installation step is described there as well.

magicpants:

I searched through and couldn't find a mention of this:

When I run the upgrade file, I get a message at the bottom saying:

Add the CC code to /includes/modules/pages/checkout_success/header_php.php, Line 97:
//SO_EDIT_START
// Add the CC payment to the Super Orders payment system
$cc_insert = $db->Execute("select cc_type, cc_owner, cc_number, cc_expires, cc_cvv, date_purchased, order_total from " . TABLE_ORDERS . " where orders_id = '" . $zv_orders_id . "' limit 1");

if (zen_not_null($cc_insert->fields['cc_number'])) {
$new_cc_payment = array('orders_id' => $zv_orders_id,
'payment_number' => $cc_data->fields['cc_number'],
'payment_name' => $cc_data->fields['cc_owner'],
'payment_amount' => $cc_data->fields['order_total'],
'payment_type' => $cc_data->fields['cc_type'],
'date_posted' => $cc_data->fields['date_purchased'],
'last_modified' => $cc_data->fields['date_purchased']);
zen_db_perform(TABLE_SO_PAYMENTS, $new_cc_payment);
}
//SO_EDIT_END

> 
> 
> But, line 97 is a bit vague.  It ends up being added in the middle of a bit about gift vouchers!  I didnt see this edit explained anywhere in the readme file.  
> 
> Could you offer some clarification please?  Great mod though, and nice improvements from the previous version!

Is anyone having an issue with this mod with apostrophe's? I'm having a client with issue with either updating products that have apostrophe's in their name, or apostrophe's in their customer's data. They cannot update the order as delivered. without a mysql error.

Thanks!

jettrue:

Is anyone having an issue with this mod with apostrophe's? I'm having a client with issue with either updating products that have apostrophe's in their name, or apostrophe's in their customer's data. They cannot update the order as delivered. without a mysql error.

Thanks!

I have this problem as well - easiest way to combat it (without having to write code) is escape the apostrophe in the field by putting the \ before the apostrophe.

Hi there, I have found a really odd bug, I cannot imagine what could be causing it. When I use the split packing slip feature, everything works great, the packing slips comes up with a checkmark beside the products I'm shipping and an x beside the products that aren't being shipped. Down at the bottom there is the legend where it shows the checkmark and x again and lets customers know what they mean. If I print the packing slip in black and white, it works fine. But if I print in color, which I always do, the checkmark and x in the legend don't show up at all, even though they're onscreen! They show up fine when printed in black & white! The checkmark and x beside the products show up fine in color. What on earth could be causing that? It's so bizarre!!! It's not a huge deal, but I always print in color because of my logo, and the legend at the bottom looks a little odd without the check and the x. Anyone have any insight on this?

Thanks!

Hello I am having some serious issues with this contribution:

First of all I attempted to install this contribution and followed the instructions exactly and still ran into problems with running the sql because it kept telling me that there were duplicate entries. So I decided not to install and had a full backup restored by my hosting company which should have put everything back to previous. However now I am getting these errors:

1054 Unknown column 'balance_due' in 'field list'
in:
[UPDATE orders SET balance_due = '8.8' WHERE orders_id = 32]

I have done a search for this on the forum and was only able to find references to this module. I was also unable to find a resolution that would suit my situation. Can someone please help me if they know what might be happening?
I am thinking that a fresh install of 1.3.7 might be necessary.
it's urgent

Thanks

OH and I haven't updated my signature yet so my version of zencart is 1.3.6.

magicpants:

Hey Blindside,

Okay, I verified I had installed rev45. I redownloaded the latest version from this site and went through each file, verifying that the modified dates were the same. They are. Plus, this snippet I got when running the upgrade file is in the latest version of the super_upgrade.php.

I got a little thrown by the idea it was an older version, because I can't find any mention of this installation step in the README or anywhere else. If this was just a mistake, no problem -- just let me know because I'm waiting to try to find the right place in that file to add the snippet.

I'm being cautious as I can too easily create bugs by doing things I don't understand.

I include our previous posts on this subject so you know what I'm talking about. :) And, thanks for being so thorough by responding to everyone's issues!
Take a look at step 7 in the "REQUIRED FILE EDITS" section of the readme. The update script is displaying an older setup that this step replaces.

Obviously, you should ignore that instruction in the update script (like I said, that needs major work).

jettrue:

Is anyone having an issue with this mod with apostrophe's? I'm having a client with issue with either updating products that have apostrophe's in their name, or apostrophe's in their customer's data. They cannot update the order as delivered. without a mysql error.
Yes, to all who reported apostrophe bugs, it's caused when you have **magic quotes** enabled. I have fixed this issue for the next release.
Danielle:

Hi there, I have found a really odd bug, I cannot imagine what could be causing it. When I use the split packing slip feature, everything works great, the packing slips comes up with a checkmark beside the products I'm shipping and an x beside the products that aren't being shipped. Down at the bottom there is the legend where it shows the checkmark and x again and lets customers know what they mean. If I print the packing slip in black and white, it works fine. But if I print in color, which I always do, the checkmark and x in the legend don't show up at all, even though they're onscreen! They show up fine when printed in black & white! The checkmark and x beside the products show up fine in color. What on earth could be causing that? It's so bizarre!!! It's not a huge deal, but I always print in color because of my logo, and the legend at the bottom looks a little odd without the check and the x. Anyone have any insight on this?
At first I was going to say that it was your print driver, but then I thought about it some more...

Make sure you color ink cartridge isn't empty... :laugh:

mafiasam:

Hello I am having some serious issues with this contribution:
well then you came to the right place.
First of all I attempted to install this contribution and followed the instructions exactly and still ran into problems with running the sql because it kept telling me that there were duplicate entries.
Stopping you right there. If you got dupe entry errors, that means the script was already run. If you're certain you didn't do it, then your host likely installed the mod for you. Just FYI...
So I decided not to install and had a full backup restored by my hosting company which should have put everything back to previous. However now I am getting these errors:```
1054 Unknown column 'balance_due' in 'field list'
in:
[UPDATE orders SET balance_due = '8.8' WHERE orders_id = 32]

That is an SO-only function (which is why your searches ended up here); it's trying to update the balance of the order, and that only occurs in SO files.  Are you sure you removed admin/super_orders.php, and are no longer using it?

BlindSide:

At first I was going to say that it was your print driver, but then I thought about it some more...

Make sure you color ink cartridge isn't empty... :laugh:

Nope, it's not empty :) Plus, if the color is empty it automatically prints color things in greyscale, but the check and the x aren't showing up at all, it's just completely blank where they should be. Everything else on the page is printing in color, including the checkmark and the x beside the products that were purchased. I printed it off several times and it was the same each time. Only the checkmark and the x at the very bottom on the right hand side don't print in color.

Okay then back to my original theory, which is some weird behavior on the part of your printer driver. You can print in B&W, which means everything is, in fact, reaching the printer. Things only go awry when you print in color. That problem's definitely occurring on the last leg of the trip (printer output).

Try updating the print driver, or reinstall the printer completely.

Well I did already try troubleshooting my printer, did the driver update and the other things the troubleshooter suggested, but there weren't any problems. I don't really see how it could be the printer when virtually everything else that should be in color is in color! I tried printing other documents and there were no issues, and everything else on the packing slip is in color, just not those two things, I don't know what else to check on my printer? This has got to be one of the most bizarre things I've come across so far!

Same here, that's just plain freaky. Do you have another net-connected PC with a color printer nearby that you could try from?

As soon as I wrote this reply my problems seemed to have been corrected. I'll be sure to update if there is another issue.

Danielle:

Well I did already try troubleshooting my printer, did the driver update and the other things the troubleshooter suggested, but there weren't any problems. I don't really see how it could be the printer when virtually everything else that should be in color is in color! I tried printing other documents and there were no issues, and everything else on the packing slip is in color, just not those two things, I don't know what else to check on my printer? This has got to be one of the most bizarre things I've come across so far!

are you using Firefox to print these? Sometimes FF will hide things from printing if you have it at a certain zoom level. I've noticed that whenever i start getting missing images on printed pages.. dropping it down to 90% shows everything on there

Does the fact that this mode alters ORDERS table affect any insert statements in other files/modules?

Will this change (alter table) cause any problems later on with Zen-Cart upgrades since it expects tables to have the original structure?

The short version, ericny, is no, this will not affect anything in the core, whether current or upcoming.

The reason this does not affect the system is because core Zen uses a very intelligent function, zen_db_perform(), to perform inserts and updates. This function takes an array of values to insert, and the array key corresponds to the field name.

With this information, the function can build a SQL statement that explicitly defines exactly which fields have values to insert, like so...

INSERT INTO orders (orders_id, customers_id, customers_name, [...]) 
VALUES ([$orders_id], [$customers_id], [$customers_name], [...])

This way Zen Cart always avoids using the looser (and more error-prone) SQL structure that lacks the field names...

INSERT INTO orders 
VALUES ([$orders_id], [$customers_id], [$customers_name], [...])

The Zen Cart core will never use SQL statements like the above, so there's never a problem with upgrades. Of course you still have to watch out for sloppy contrib code, but you won't find any of that nonsense here. :wink2: