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

jikey:

um yeah just wondering can b create order or edit order or not ...;..
any screenshoot?

can't do any of those yet - BlindSide is working on a newer release which has order editing capabilities

Creating an order will probably always be done on the front end

samad64:

can't do any of those yet - BlindSide is working on a newer release which has order editing capabilities

Creating an order will probably always be done on the front end

yups but look not so professional actualy ...

Hi guys...Just downloaded/installed SO on my development site, so far poking around, I like it a lot!

Two problems:

• Textarea box on batch_status is ~1w x ~5, looking at the code, it should be called at 50x4
• Status update emails (both cust and admin copies) go fine from SO orders page, do NOT go (and are indicated as such (red checkmark))from batch status update

I have read the enitre thread here and caught many discussions on $notify and made/unmade changes suggested by blindside as they came up. Just got to the end of this lengthy thread, and don't see any perm. fix?

Ideas?

Dave......

i get the same problem to, im going to look to see if i can fix this, if anyone does before me please can you pm

thanks.

ok i think i have fixed this.

open super_batch_status.php from your admin folder

around line 255 find

replace with

            <td width="10%" class="smallText" valign="top"><?php echo HEADING_ADD_COMMENTS; ?></td>
            <td width="40%" class="smallText"><?php echo zen_draw_textarea_field('comments', 'soft', '250', '4'); ?></td>
            <td width="40%" class="smallText" valign="center"><?php

at the end of the file find

if ( ($check_status->fields['orders_status'] != $status) || zen_not_null($comments)) {
update_status($oID, $status, $notify, $comments);

if ($notify == 1) email_latest_status($oID);

$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');

}
else {
$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
}

replace this with

      if ( ($check_status->fields['orders_status'] != $status) || zen_not_null($comments)) {
      $customer_notified = '0';
      if (isset($_POST['notify']) && ($_POST['notify'] == 'on')) {
        $customer_notified = '1';
      }

      update_status($oID, $status, $customer_notified, $comments);

      if ($customer_notified == '1') {
        email_latest_status($oID);
		$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
      }
	  }

now save this, replace this one with the one on the server and all should be good.

Jynxy

Alright, time for some catch-up...

zas:

is there an easy way to uninstall the super orders?
There is no uninstall script, if that's what you mean. Back out the changes described in the Readme, then delete all the tables and files that have a prefix of "super_".

If you know a little SQL, you can also remove the configuration entries by looking at the inserts and searchingf or them in the configuration table using phpMyAdmin.

zas:

and if I have it installed but still want to use the original order system, will that create any problems?
Nope, not at all.
jikey:

um yeah just wondering can b create order or edit order or not... any screenshoot?
Well you can currently edit everything about an order except for the products. As others have said, that functionality is coming. Returns and exchanges are complete, I have to finish the reporting (nice tie-in with my Sales Report mod) and the functionality to simply add a new product.
jikey:

yups but look not so professional actualy ...
What do you mean? Any suggestions on how I can improve the look?
jerkynet:

Hi guys...Just downloaded/installed SO on my development site, so far poking around, I like it a lot!

Two problems:

• Textarea box on batch_status is ~1w x ~5, looking at the code, it should be called at 50x4
  That's a bug in IE7. Aside from obviously avoiding that piece of crap (how do break stuff that you previously had working!?), I'm implementing changes like the ones you described.
• Status update emails (both cust and admin copies) go fine from SO orders page, do NOT go (and are indicated as such (red checkmark))from batch status update
  Again, I have a solution, also similar to your own. Will be included in next release, but thanks for posting a fix; been meaning to do that for some time.

Quote:
Originally Posted by jikey
yups but look not so professional actualy ...
What do you mean? Any suggestions on how I can improve the look?

I think they are referring to the order creation being done on the catalog side is unprofessional.

MikeyG:

Super orders, VAT and Footers?

I have a couple of questions which partly relate to super orders and partly relate to invoice information requirements in the UK.

How do I get a VAT registration number on to my invoice? - I do have super orders installed but reading about FED tax ID (US I am assuming) inputting a reference in the language file turns off the TAX columns - not quite what I want. Having just hit the UK VAT threshold I now need to have tax columns showing and my VAT reg number on the invoice.

I am wondering if there is a way of getting VAT reg. Company No. addresss etc appearing at the bottom of the page as a footer on the invoice - without headed paper or entering these details in the printer settings as this does not get the right look/layout.

If not using super orders invoice then how do I achieve this in the original invoice file?

Thanks for the help in advance.

MG
The fix that NamSingh offered will get the display working for you, but like you said, that won't take care of the missing tax fields. You'll have to do a small file edit for that. Open admin/super_invoice.php and find this line near the very top:

$display_tax = (FED_TAX_ID_NUMBER == '' ? true : false);

Comment that out and add the following line below it:

$display_tax = true;

Now you're good to go.

NamSingh:

On a different problem. Anyone had issue with editing a customer?? I upgraded to 1.3.7 zen cart and think maybe this overwites some update function. The customer changes are not sent to be updated.
What problem are you seeing specifically? Explain what you tried to edit, and what happened? The more detail you provide the better.
magicpants:

...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!
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.

Frank et.al

Is there a list anywhere of which features you are currently working on?

For my own needs adding items to an order would be good. I can split an order by product quantity rather than just product but adding to the order is proving to be a pain.

Thanks

I posted a while back with the new features I've got in the pot right now. Here's the feature list I provided in that post:

• More bug fixes, based largely on your feedback (thanks!)
• New installer for all users, new or returning. Will handle all DB changes automatically.
• Some fancy-shmancy AJAX effects, particularly in the new features below
• New order search interface for order listings, similar to the one on the batch pages.
• New product edit module. Edit product quantity and any associated attribute values (mimics attribute display on storefront, only fills in existing values).
• New product return/exchange module. Return a product and exchange for one or more new products. Also processes refunds on tax and shipping, and adds new fees for tax, shipping. Includes option for exchange service charge.

I should also note that the biggest hang-up to release will be updating the installer. The package has simply gotten too complicated for a simple SQL file and some readme steps (as many of the posts here can attest), so I'm gonna have to do something more along the lines of the Zen Cart installer.

I tried your changes....but i'm getting error messages, and batch update won't open. i had to revert to the orig super_batch_status.php. is it working for you?

I am working with a fresh install of 1.3.7, loaded by my host with some of the key Zen community contributions.

I am having a problem that I believe is related to SO based upon this thread by WickedKlown:

http://www.zen-cart.com/forum/showthread.php?t=46261&highlight=balance_due

I installed Paypal Express. I'm not clear as to whether it is incompatible w/ SO or whether there is just some lost functionality, but that is not really relevant here.

I received the exact error that WickedKlown describes in the above thread. I could see the order in admin, but if I tried to open the order or click on customers->super orders: > 1054 Unknown column 'balance_due' in 'field list'

in:
[update orders set balance_due = '0.08' where orders_id = 289]
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.

I removed Paypal Express and installed Paypal IPN. I created another order through the catalog end. This time, from the customer perspective, everything seemed perfect.

In the admin, the new order never appeared, but clicking on customers->super orders now functions correctly. Clicking on that first (Paypal Express) order now opens the order but with the error > 1054 Unknown column 'zen_order_id' in 'where clause'

in:
[select * from paypal where zen_order_id = 289 AND parent_txn_id = '' ]
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.

Based upon WickedKlown's thread I'm guessing that it is something not quite current with the SO install. Given that I didn't do the install I'm not real sure where to start. It looks like the defines and file edits are in place.

If I try to re-run the sql I receive an error because it is trying to add a field that already exists. I'm not clear from the errors what tables the noted fields should be in, so that I can at least look at those tables in phpMyAdmin.

Finally, I'm guessing that this is a simple upgrade fix, if I only knew what it was, lol. I have yet to try a cc order, so I am off to do that now.

Any ideas appreciated:D
Are you out there Wicked?

Thx!
Audra

Audra when you brought your old database parts you brought the orders table with correct?

Ok you need to run this in your sql updater in ZC admin

ALTER TABLE orders ADD date_completed datetime default NULL;
ALTER TABLE orders ADD date_cancelled datetime default NULL;
ALTER TABLE orders ADD balance_due decimal(14,2) default NULL;

when you added the old tables and ran the upgrade script did you add the zen_ prefix?

If so then you will need to download the SO module and run the sql file in the zc admin sql updater, this will then add the prefix to the mix

Hello,
I'm trying to install super orders for the first time and in the SQL Patch update I get this error: :no:

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 'True', 'False'), ')' at line 1
in:
[INSERT INTO zcart_configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array('True', 'False'), ');]
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.

I went back to the admin to try out Customers-> Super Orders but I get:

Sorry, your security clearance does not allow you to access this resource.

Please contact your site administrator if you believe this to be incorrect.

Sorry for any inconvenience.

I'm assuming it didn't install properly due to the SQL error. Can you provide some advice on how to proceed?

I have zen cart Zen Cart 1.3.6, PHP Version 4.4.4, MySQL 4.1.21.

Thanks!
Arthur

I'm no expert on this stuff, but removing the comma after ('True', 'False') in 'zen_cfg_select_option(array('True', 'False'), ');] so that it reads ```
'zen_cfg_select_option(array('True', 'False') ');]

If you are running super orders and admin levels you will need to assign the super orders to the admin levels

Merlinpa1969:

Audra when you brought your old database parts you brought the orders table with correct?

Ok you need to run this in your sql updater in ZC admin

ALTER TABLE orders ADD date_completed datetime default NULL;
ALTER TABLE orders ADD date_cancelled datetime default NULL;
ALTER TABLE orders ADD balance_due decimal(14,2) default NULL;

> 
> when you added the old tables and ran the upgrade script did you add the zen_ prefix?
> 
> If so then you will need to download the SO module and run the sql file in the zc admin sql updater, this will then add the prefix to the mix

Yes, I did bring in the orders table. 
I ran the suggested sql. I think maybe that portion was done when I tried to run the SO sql last night because I am getting already exists errors. That would explain the errors that went away.

What I am left with is an error only when opening a Paypal order. 
An example:
> 1054 Unknown column 'zen_order_id' in 'where clause'
> in:
> [select * from paypal where zen_order_id = '283' order by paypal_ipn_id DESC LIMIT 1]
> 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.

I see that it is looking for zen_order_id in the paypal table. My paypal table has just order_id. So, I see the problem, but don't know how to fix it. I'm off to peruse the SO mod, and see if I can't figure it out where it asks for zen_order_id.

(In answer to your question Merlin, no I did not add the zen prefix back into my database.)

Thanks!
Audra

OK try to uninstall and re-install the module in admin

I think that the trouble I had w/ SO is fixed, and what is remaining is not related to SO, so I am going to move my search for answers off this thread, which does not need any more traffic than it already gets!

: )
Audra