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

Hey everyone,

Quick question. About Batch Printing the Invoices...

It seems there isn't a page break in-between Invoices so they all print together. Any ideas on how I can insert a page break? Just so when they print their invoices, they're on seperate sheets of paper.

Thanks in advance.

Here is what I do:
Download PFD orders, and print them from there.

Quite a cool programme. Took some messing about to get it looknig right, not very knowledgeable about PFDs, but you can batch print invoices, shipping labels, anything you like from it.

Rupert

I tried installing Super Orders...

SQL error - #1060 duplicate column name 'date_completed'....

and:

Super Orders doesn't show up in Admin -> Configuration..menu

I have looked through this and haven't found any answers yet.
If someone has any hints, tips etc.. I appreciate it.

thanks:frusty:

Rupert:

Here is what I do:
Download PFD orders, and print them from there.

Thanks for the advice Rupert. I actually have the PDF module, and was thinking of that as my alternative. I just wanted to use Super Orders to do it... And thought that inserting a page break in the code would be feasible. I would just have no idea where... I'm surprised such a useful feature like Batch Printing, would not allow me to print separate pages.

SuperOrders is still the best Mod out there...

If anyone else knows how I could do it, I'd be anxious to hear...

Thanks.

I have just tried to add the super_orders_sql.sql into zen cart, but get the following error:

1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]
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.

Any ideas? (I'm pretty new to this):unsure:

buonacorsi:

I have just tried to add the super_orders_sql.sql into zen cart, but get the following error:

1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]
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.

Any ideas? (I'm pretty new to this):unsure:

I had some of the same problems with it. I am still waiting to hear back from the author...but still waiting.
Check the mods section though, there are some useful alternatives.

Had the same problem. I tried running the script by pasting the .sql file directly into the tools->install sql patches, then got the error and tried again by uploading (not the smartest thing to do, but it was a test database). The order module was working fine, but the config items were missing. After using phpmyadmin to verify exactly what structures in the database were missing, it was confirmed that only the Admin-Configuration items were missing, pasting the following update query into tools->install sql patches seems to have fixed the problem. Note that I have only recently installed this mod and have little experience with it, but it is working correctly. thanks.

in super_orders_sql.sql starting at line:

"-- Super Orders configuration group"

copy all the text till the end of the file.

i still have a NONE! on the invoices on my taxes columns for each item but then at the end i have the taxes calculated alright in the totals

jmatthewsr:

Had the same problem. I tried running the script by pasting the .sql file directly into the tools->install sql patches, then got the error and tried again by uploading (not the smartest thing to do, but it was a test database). The order module was working fine, but the config items were missing. After using phpmyadmin to verify exactly what structures in the database were missing, it was confirmed that only the Admin-Configuration items were missing, pasting the following update query into tools->install sql patches seems to have fixed the problem. Note that I have only recently installed this mod and have little experience with it, but it is working correctly. thanks.

---

in super_orders_sql.sql starting at line:

"-- Super Orders configuration group"

copy all the text till the end of the file.

Awesome! That was the main problem I had with SO. We shall see..

Hello Gang... Frank,

I searched high and low, but can't find the answer.

Parse error: syntax error, unexpected $end in /home/intiucom/public_html/admin/super_report_await_pay.php on line 377

The code on line 377 is in red below:

<!-- footer_eof //-->
<?php } ?>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

What am I not seeing? Any one have an idea?

Rupert:

Here is what I do:
Download PFD orders, and print them from there.

Rupert

For anyone else searching for the problem. Lawbird123 answered it perfectly.

If you're trying to print all the invoices that get batched to html frames in Firefox on separate pages...

When the print dialog comes up, just use the pulldown and select Firefox. You then get to decide

• As Laid Out on Screen
• The Selected Frame
• Each Frame Separately

And it works perfect from there...

...Now if someone can just figure out why some of us can't notify customers when batch changing their status..!

I love SOrders! However, I'm having a problem... We are capturing credit card information, but not billing the card until we ship the product. Before SO was installed, there didn't seem to be an issue. Post SO, it's applying a credit card payment to the balance and showing that it is paid--even though we haven't captured the funds yet.

I looked around, but couldn't find a place to change anything that made sense. I tried moving default statuses around, but that had no effect.

Any help is appreciated.

k

Never mind,

Someone could have just suggested that I try to re-FTP the file again...
But no, this crowd would rather I thought it thru on my own.

Problem solved... Sorry I asked.

Swan,

You will see that in an earlier post a page back there is a similar question raised. I am waiting for an answer from Blindside but I have not seen him on the forum for over a month. I hope he is okay.

Anyway there is some code to insert into one of the pages - instructions in the readme I think apply to one of the credit card modules which you then need to effectively copy and apply to your own credit card module.

I am not a programmer so I have not sussed this out for my situation yet but I hope this may help your own thinking and in findnig a solution. Perhaps if there is some one out there who has done this they could post the reply.

MikeyG,

Thanks for the input. The ironic thing is, I switched to doing immediate capturing of the funds, and NOW SuperOrders doesn't apply the payment.

Argh! I'd love to fix this.

I have the original version of SO installed on my live cart (1.3.0.2) and I am in the process of setting up a new cart v. 1.3.7. I've installed the new version of SO on it, but now I am wondering what will happen when I bring my database over from the live cart? Will the old SO tables, etc. overwrite the new version?

Any help is greatly appreciated. :smile:

I'm having a problem with the SO 2.0 refund portion. It summarizes the order correctly, shows the negative applied amount and when calculating the balance due, it ADDS instead of subtracing! (no id didn't use a mimus sign on the refund) Also my refunds are NOT being send via my goEmerchant module at all. See blow:
<font = xsmall>
Charles Burch**-$24.68Master Card05/29/2007 05:17:5905/29/2007 05:17:59 Color Key:Purchase OrderPaymentRefundProductsModelTaxPrice (ex)Price (inc)Total (ex)Total (inc)1 x Nucose 1033186.00%$17.50****$17.50****$17.50****$17.50**
Sub-Total:$17.50
Flat Rate: $5.78
GA TAX 6.0%:$1.40
Total:$24.68
Amount Applied:$-24.68
Balance Due:$49.36

All help is GREATLY appreciated.

CB

In "super_orders_sql.sql", lines 88 and 89 cause problems with MySQL 5. The first field should not be '', but should be NULL like on the other lines. For some reason MySQL 5 stopped the empty string support for numeric columns, I guess it makes sense though.

Hey everyone! I had to go underground for a while because my company puts on this huge, HUGE event at the end of May called Global Finals. You can check out the event site, if you're at all interested. A little background...

• We get almost 1000 teams of kids, each with two competition times, crammed within 3 days. Yours truly is responsible for scheduling that chaos.
• We have a total 15,000 people in attendance, and I am also responsible for the management system that houses and bills all of them.
• The same system arranges for security credentials for attendees.
• To top it all off, we prepare everything on a staff of just 14.
  Needless to say, it's a very busy time leading up to the event. :wacko: Our office is actually closed for duration of the event, so I'm completely out of touch that week.

I just got home on Saturday, and today's my first day back in the office. Let me catch up on the posts and I'll reply.

MikeyG:

...I am waiting for an answer from Blindside but I have not seen him on the forum for over a month. I hope he is okay.
I appreciate the concern. :hug:

SirBuck:

I had some of the same problems with it. I am still waiting to hear back from the author...but still waiting.
Check the mods section though, there are some useful alternatives.
Your problem is that you ran the SQL file twice. It creates a table called so_payment_types and performs an insert on it. Find that section of the SQL and comment it out, or delete it.
swan:

I love SOrders! However, I'm having a problem... We are capturing credit card information, but not billing the card until we ship the product. Before SO was installed, there didn't seem to be an issue. Post SO, it's applying a credit card payment to the balance and showing that it is paid--even though we haven't captured the funds yet.

I looked around, but couldn't find a place to change anything that made sense. I tried moving default statuses around, but that had no effect.
First, glad you like it! Your problem is a result of how I'm tapping into the order information. Any CC info is stored in specific fields in the orders table. I look to see if information is there, and generate the payment record accordingly. Works very well if you use a gateway like Authorize.net.

If you wish to enter these payments manually, you can simply undo the changes you made to the catalog-side order.php class. In the readme, look for the title "Edit the order.php class (catalog side)."

Zinfandel:

Never mind,

Someone could have just suggested that I try to re-FTP the file again...
But no, this crowd would rather I thought it thru on my own.

Problem solved... Sorry I asked.
Sorry I wasn't here, Zin, and shame on you SO old hats for not chipping in. Support in these forums is a two-way street.
moltar:

In "super_orders_sql.sql", lines 88 and 89 cause problems with MySQL 5. The first field should not be '', but should be NULL like on the other lines. For some reason MySQL 5 stopped the empty string support for numeric columns, I guess it makes sense though.
Correct, that is a major change in MySQL 5. Next release will account for it.

...and yes, I am still planning a new release. As I said in my last post, it's been a roller-coaster for most of 2007. Let's see how my summer plays out. I also want to reconnect with the dev team and see what they have cooking for the near future.