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

Right, but payment methods are not a language-specific entity. The admin (currently) works off of a single language selection, and customers do not see these payment records. Hence, there was no need to add a language selection to the mix.

Should it be ideally? Sure. I'll make a note of it for a future release.

rollerdude:

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.
No, the parenthesized section of shipping methods is being actively stripped out. It was a problem for the company I worked for when SO began, caused confusion on the part of customers. There's a number of posts about how to revert it. Do a quick search on the thread and you'll find it.

This quote comes from my offline conversation with Maurice. I thought others might find it enlightening.

> what are the "Order Completed' and "Order Cancelled' buttons supposed to do?
The "Order Completed" and "Order Cancelled" buttons were added to increased the finality of a finished order. The standard Zen Cart statuses are simply numbers; any value attached to them (beyond settings for downloads) are based entirely on the shopkeeper's office practices. In other words, there was no way to call an order "done" in the confines of the system; it depended entirely on everyone who managed orders to follow the same rules. If one person screwed it up (i.e. assigned the wrong status for a completed/cancelled order), the whole thing would flop. In addition, some of the SO reports could potentially report erroneous values if canceled orders were included in the tallies (read: your bookkeeper's worst nightmare).

Enter these special buttons. They still assign an order status, however they also set special flags in the order table. With those separate flags in place, the status can be anything, and the order still maintains some sense of closure.

BlindSide:

Right, but payment methods are not a language-specific entity. The admin (currently) works off of a single language selection, and customers do not see these payment records. Hence, there was no need to add a language selection to the mix.

Should it be ideally? Sure. I'll make a note of it for a future release.

SO did ask me with boxes in three languages, what payment method I would like to add. There was nothing I could do except fill in the boxes.

[reviewing code]

By george she's right! Jeez, how long has it been since I touched this file? Run this SQL statement over your DB and the problem will be solved:

ALTER TABLE so_payment_types
  DROP INDEX type_code_2,
  DROP INDEX type_code,
  ADD UNIQUE idx_unq_payment_type ( language_id , payment_type_code );

Good catch, Heidi, and sorry it took me so long to get there. :bigups:

@everyone: This fix has already been incorporated into the installer for 2.1. Make the change if you need to, otherwise you can wait for 2.1.

Thanks BlindSide, I tried to patch the SQL by copying the code and got this:

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 1
in:
[show index from ]
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.

Server OS: Linux 2.6.9-67.0.7.ELsmp Database: MySQL 4.1.22-standard
PHP Version: 5.2.6 (Zend: 2.2.0)

I'm eagerly waiting for version 2.1!

The query does not appear to work with the "SQL Query Executor" tool in the Zen Cart admin. However this is definitely a valid query for the server information that the page displayed.

Do you have an alternative DB management tool, like phpMyAdmin? Your host almost certainly provides some interface to your databases via Cpanel or Plesk. I always recommend that you use those tools whenever possible, as the SQL tool in Zen Cart does have its moments.

Thanks Frank,

I'll try that later. It's way past midnight now.

It worked! Thanks Frank.

Glad to hear it, heidikfi! :clap:

I have been using super orders 2 for about 3 months now, and it has beene working great but now all of a sudden... when an invoice has been paid the invoice still has an AMOUNT DUE. and the amount applied is Zero. Any ideas or has anyone else experienced this? We are still geting money in our merchant account but the invoices, people are confused and think they still owe us something.

I just noticed that when I click on Super Orders from my admin panel I shift from my secure socket layer to a non secure one. Is there a way to change it back to secure? If this has already been asked and replied to I do apologize.

Beth-katherine

I am trying to edit what displays for the title of a table rate shipping...right now it shows up as "Table Rate" i would like it to say "shipping & handling" how could i do that?

Hello,
When I view an order and I want to refund the money, I used to just use the Refund/Partial Refund box and it was done. I understand that this does not work now with Super Orders installed.

However, I see the refund button that is new and part of Super Orders. When clicked it opens a new window with details of the order.- I select the Target Payment from the drop-down menu

• I put the amount of the refund in the Amount box
• I put the customers name in the Name box.
• What goes in the Number box? Is that the order number, the CVV number?
• What do I choose from the Type drop-down menu? Is that referring to the type of credit card?Thank you for helping clear this up for me.

I recently installed SO and LOVE it. however, I'm desperate to fix one little thing. I've read and read this thread and I've seen the question but not answers.

One of my attributes requires A LOT of text (it's an invitation- so many lines and many returns). The Zen Cart Orders Invoice prints out fine, holding the returns the customer inputted.

Super Orders does not. Everything for that attribute is ONE LONG LINE. Even if I use a legal size sheet and shrink it, it won't all fit, so I end up with something you have to read with a magnifying glass.

How do I fix this!? Printing batch invoices is the entire reason I installed SO!

Also, how do I note something was refunded in SO? I have no refund button that I have read about on here. At least I can't find it. I'm not talking about actually doing the refund in Paypal or Auth.net, but just to note it on my SO so it doesn't show up in the sales total still. I've just been deleting orders, but I'd rather keep the info and mark it as refunded.

Any advice is much appreciated!

Thanks-

Amy

lexxymark:

One of my attributes requires A LOT of text (it's an invitation- so many lines and many returns). The Zen Cart Orders Invoice prints out fine, holding the returns the customer inputted.

Super Orders does not. Everything for that attribute is ONE LONG LINE. Even if I use a legal size sheet and shrink it, it won't all fit, so I end up with something you have to read with a magnifying glass.

I figured out how to fix this. There is a bit of code not included in super_invoice.php that's in invoice.php that I guess makes the line breaks inputted by customers when they enter info in a text box stick around.

I found this line in super_invoice.php:

$order->products[$i]['attributes'][$j]['value'];

And replaced it with this from invoice.php:

nl2br(zen_output_string_protected($order->products[$i]['attributes'][$j]['value']));

Now, it still looks like one long line in the details page of the order, but when I go to the invoice it prints out perfectly with line breaks intact.

I hope this helps someone else looking for the answer!

Amy

Ruff! sniff... sniff...
Sounds like something that should be addressed in the next iteration of S.O.
Did you hear that BlindSide?

Frank!
Can we get an ETA update?
Please.

By all means take your time, I only want to know when to check back again.

I wonder if anybody can help me achieve this

On the super orders packing slips, I'd like to have in front of the order number, the amount of orders that customer has placed

so say it's order 1055 and he has placed 4 orders till date it would show

Order #1055 (4)

Any ideas how to achieve this ?

FatGuyinAZ:

Hello,
When I view an order and I want to refund the money, I used to just use the Refund/Partial Refund box and it was done. I understand that this does not work now with Super Orders installed.

However, I see the refund button that is new and part of Super Orders. When clicked it opens a new window with details of the order.

• I select the Target Payment from the drop-down menu

• I put the amount of the refund in the Amount box

• I put the customers name in the Name box.

• What goes in the Number box? Is that the order number, the CVV number?

• What do I choose from the Type drop-down menu? Is that referring to the type of credit card?

Thank you for helping clear this up for me.

Has support vanished? I was hoping my question would be simple for power users. Can anyone tell me the answers to my questions?

Thank you,

@FatGuyinAZ
NO, support hasn't vanished, but I think Blindside is pushing hard to get the new updated version out. Let me try to help

The TYPE box is the payment type and is usually the credit card name if you are refunding the money via the customer's credit card. It is the list which you can set via Admin>Localization>Payment Types. For example, I have added one called "Adjustment". You could add one called "Refund". It will not affect the credit card account because SO does not communicate with the credit card gateway. You have to do that separately.

The NUMBER box is supposedly the payment number which is at the beginning of the payment line. I find that nothing is entered when the customer pays via credit card, but a number is there when they use PayPal. Again, it just seems to be for reference purposes so you can enter whatever you like.

You can also do a refund or adjustment by using the "Edit Order Totals" popup and entering a negative amount and a reason of "Refund" or "Credit", etc

Hope this helps.