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

Sure:```

Change the red "false" to true in super_orders.php it down around line 930

I get the following sql error when installing sql patch for super orders:

1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO zc_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.

:(

please help

@babynatura - You've run the SQL file more than once. If the SQL did not complete successfully, you'll have to comment out the offending lines, which should be just the inserts into the so_payment_types table. You'll find them immediately after the comment "-- Some good default payment types"

toholio:

I've been setting up Super Orders and have run into a problem with order totals editing. From this thread I can see that the problem is quite common.

In Australia, and other countries, prices need to always be shown including tax. This means that invoices include the total of all item prices (inc. tax) in addition to a tax field.

So an invoice might have the following:
Order subtotal: $45
Included Tax: $4.09
Total: $45

If one edits the order totals using Super Orders then the new total will have the tax summary incorrectly added to the tax inclusive subtotal. Using the above totals as an example, if one opens the edit totals window and clicks submit without actually changing anything then the totals would be changed to:
Order subtotal: $45
Included Tax: $4.09
Total: $49.09

The quick and dirty fix I'm using for this problem is to comment out line 491 in super_edit.php which will remove tax from the running total calculated there.

Obviously a better solution would be required for people who do sometimes need tax added. The addition of tax in the total could be made conditional but I'm unsure of what to test...

Hope this helps.

anyone got a solution for this?!?!?!? its driving me mental!:censored::lamo:

BlindSide:

@babynatura - You've run the SQL file more than once. If the SQL did not complete successfully, you'll have to comment out the offending lines, which should be just the inserts into the so_payment_types table. You'll find them immediately after the comment "-- Some good default payment types"

Hi Frank, thanks for your answer. Unfortunately it did not work... I commented out the lines after "some good default ..." and I got a long sql error message... then I only see "super order" menu in the configuration menu in the admin panel, but I still do not see any order edit button / function (which is why I wanted to install super order for..) Can you please help me ?

thanks
Pat
babynatura

Does anyone know of a way to add an order on behalf of a client. I tried the transfer order in SUPER ORDERS, but it doesnt transfer.

I am doing this so I can have the status of orders on-line for my customers, so they dont need to call me for the status.

I tried loging in as the customer, but some have changed thier password, which means I cant add orders for them

Thanks in advance.
P.S. I am using super orders 2 on the latest download of ZEN (As of yesterday)

I've searched for an answer on this and can't find one - is there a way for SO to appear on the admin dashboard, or a way to link 'new orders' direct to SO?

When I click an order link on new orders it appears to want to take me to the default order pages - which returns a blank screen.

Look in the readme file that came with super orders as it gives you the option of removing the original orders system to be replaced with super orders look for optional file edits

I would also reinstall the zen cart as when you click the new orders it should take you to the original orders system unless you made the modifications in the readme file as above.

Wingz:

I've searched for an answer on this and can't find one - is there a way for SO to appear on the admin dashboard, or a way to link 'new orders' direct to SO?

When I click an order link on new orders it appears to want to take me to the default order pages - which returns a blank screen.

Hi,
I'm looking for a manual order entry system for my store owner so she can add orders from the back end.

Is this what Super Orders will allow her to do?

I read through the files that came with the install but I don't see the answer to this question there.

Can you let me know...Thank you so much.

Tracy

No. If she's taking phone orders from new clients then using Add Customer from Admin combined with** Admin Login as Customer** will do.

Alternatively if she's only taking orders for existing clients, Encrypted Master Password allows you to login as the customer from the store side.

Either way, the actual order placement is done through the store as if the customer.

babynatura:

Hi Frank, thanks for your answer. Unfortunately it did not work... I commented out the lines after "some good default ..." and I got a long sql error message... then I only see "super order" menu in the configuration menu in the admin panel, but I still do not see any order edit button / function (which is why I wanted to install super order for..) Can you please help me ?
You shouldn't comment from that point forward all the way to the end, just to the end of the payment_types section. The last line to comment out should look like this:

INSERT INTO so_payment_types VALUES (NULL, 1, 'DISC', 'Discover');

Barring that, the easiest thing to do is restore your database from backup and try again. That remove all traces of SO and allow you to try again. You DO have a backup, right?

BlindSide:

You DO have a backup, right?

ROFLMAO!

Un-named company that I work for doing about 20mil a year in sales...

When hired, I inquired about their disaster recovery plan... was told "it's covered"... <shrugs shoulders and goes about my business>

About 6 months later insert 5 alarm fire in main building taking it to the ground (six inch gas main made putting it out impossible).

They were using DAT2 (gasp & shudder) on an IBM AIX system. They DID take a copy home every night... they NEVER attempted a restore on a secondary box. Turns out the DAT2 drive was bad (weren't they all?) ... it made unique backups only IT could verify... Long story short: Lost all data including accounts receivables!

BlindSide:

You DO have a backup, right?

I just love that! Many many related stories!

Perfect example, chadderuski. In my experience, everyone and every company, (large and small) can be really bad with backups. But it's up to everyone to do their part.

To bring your example home here, backing up a MySQL database is so brainlessly simple that there's no excuse. If you have command line access it's even easier, as you can simply copy the entire data directory or use mysqlhotcopy.

There's a reason the first instruction in the README is to back up.

[aside @babynatura] this is not at all directed at you, so please don't take offense. You haven't answered yet, after all. :wink:

First, we love this mod and it's working great so far! However, we just noticed one minor thing today:

Some of our products have a one-time option attached to it to handle extra shipping charges (i.e. tube mailer for posters). Now, while the extra charge shows up in admin and in the 'print data sheet' window, it's not on the invoice.

On the invoice, it lists the mailer, but has no unit price, yet the total is correct. While it's ok for us, the customers may get 'confused'. Is there a quick fix for it?

Thanks,
Andrea

tracyselena:

Hi,
I'm looking for a manual order entry system for my store owner so she can add orders from the back end.

Is this what Super Orders will allow her to do?

I read through the files that came with the install but I don't see the answer to this question there.

Can you let me know...Thank you so much.

Tracy

I've developed module to add order for each customer from admin section (see attached img)...
..I'll prepare it for others to use ASAP, but I'm too busy now :mellow:

http://www.zen-cart.com/forum/showthread.php?p=494362#post494362

Anyone with help to solve:
"Furniture Packs" = One product (unique price), but when ordered stock of all product in pack changed.

Thanks!

Hi Frank,

I'm having trouble with displaying the USPS Shipping Method in Super Orders. The Orders Listing only displays United States Postal Service and not the actual method. Same issue with details, invoice and packing slip.

I'm running:
// $Id: super_orders.php 25 2006-02-03 18:55:56Z BlindSide $

Will an upgrade to r46 solve this problem?

I've been asking over here, btw, where I've posted a screenshot detail:
http://www.zen-cart.com/forum/showthread.php?t=85972

Thanks in advance,

• Rand

Take a look at page 78 of this as it has been discussed before.

Randolph Hoppe:

Hi Frank,

I'm having trouble with displaying the USPS Shipping Method in Super Orders. The Orders Listing only displays United States Postal Service and not the actual method. Same issue with details, invoice and packing slip.

I'm running:
// $Id: super_orders.php 25 2006-02-03 18:55:56Z BlindSide $

Will an upgrade to r46 solve this problem?

I've been asking over here, btw, where I've posted a screenshot detail:
http://www.zen-cart.com/forum/showthread.php?t=85972

Thanks in advance,

• Rand

Thanks, topcat.

And problem solved.

Gracias,

• Rand

I've searched through this forum to no avail, so need to ask - Is there a way to increase the number of records displayed on the Admin->Customers->Customers page? Right now it displays only 20 customers per page, I'd really like to see ALL or at least a couple hundred per page - is this doable?

Thanks!