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

Just installed 1.3.8 and installed "Super Order" after installation do not have "Super Order" text button to click on. What have I done wrong?

most likely not got these files

admin/includes/boxes/extra_boxes/super_orders_localization_dhtml.php
admin/includes/boxes/extra_boxes/super_orders_reports_dhtml.php
admin/includes/boxes/extra_boxes/super_orders_customers_dhtml.php

Thanks Philip

That sure got me going in the right direction. I found almost nothing was uploaded. I have been using FileZila and it showed it was transfering files and folders but when I check with File Manager nothing. I had to manually move the files and now it works perfectly.

I have one more mod that is not working, now I know what to check.

Larry

I have this problem after installed this super order 2.0 mod. after i clicked on the superorder link on the admin menu here is what i got:

ID Customers Order Total Date Purchased Payment Method Status Action
1054 Unknown column 'date_cancelled' in 'field list'
in:
[SELECT date_cancelled, date_completed FROM zen_orders WHERE orders_id = 1 AND (date_cancelled IS NOT NULL OR date_completed IS NOT NULL)]
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.

and more error when I clicked on more time.

1054 Unknown column 'balance_due' in 'field list'
in:
[update zen_orders set balance_due = '297.69' where orders_id = 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.

Please help me!!!!

Thanks,

Dave Jr.

Dave2006:

I have this problem after installed this super order 2.0 mod. after i clicked on the superorder link on the admin menu here is what i got:

ID Customers Order Total Date Purchased Payment Method Status Action
1054 Unknown column 'date_cancelled' in 'field list'
in:
[SELECT date_cancelled, date_completed FROM zen_orders WHERE orders_id = 1 AND (date_cancelled IS NOT NULL OR date_completed IS NOT NULL)]
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.

and more error when I clicked on more time.

1054 Unknown column 'balance_due' in 'field list'
in:
[update zen_orders set balance_due = '297.69' where orders_id = 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.

Please help me!!!!

Thanks,

Dave Jr.

I got it folks... I just had to edit the sql queries and re-run in the sql server.

ORIGINAL from sql file:

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;

MODIFIED to:

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

Thank you.

Dave Junior

Err hi, you shouldn't need to alter the SQL if you paste it or upload to the Install SQL Patches box in Admin, as it "should" automatically substitute your table prefixes into the SQL that is unless you are using an external tool susch as phpMyAdmin. This woud suggest an element of misconfiguration in your current setup and you should check the DB_PREFIX in admin/includes/configure.php.

philip.

Couple of stupid questions about super orders... :blush:

1. Does the orange refund button actually process and send the refund or does it just deduct it from the order total?

2. Are refunds recorded and itemized in any of the reports?

Thanks.

rleepac:

Did you figure this out or get an answer to this? I'm having the same problem. The total is right but under the tax column it just shows "none!"

Anyone?

still having a problem with the invoice where it shows a column for tax and it says None! but then the tax shows up correctly in the total column on the right.

anyone know how to fix this?

Bekah

I'm hoping someone else may have experineced this issue. I have ben using SO for a long time now for batch update and batch print. Both of those pages all of a sudden changed the other day.

Those pages now only show:
Date range selection
current status
ordered product
and customer menus.

The missing sections are all the menus on the other side of the page such as:

payment method
order total
text search
and the search button.

Its really strange as I have not made any code changes or server changes at all and everything else is still working as usual. The only thing I have changed recently was that I added a new template but I have changed back to the old templat and it did not fix the issue. Any insight would be greatly appreciated.

Thanks
JON

Does the browser have a horizontal scroll bar at the bottom of the page, that is, did the menu items not really disappear but move off the screen?

No I wish that was the case. the menus are actually not on the page anymore. Looking at the source verifies this.

Thanks though.

carlvt88:

Does the browser have a horizontal scroll bar at the bottom of the page, that is, did the menu items not really disappear but move off the screen?

Which page is this ? e.g.

http://XXX/super_orders.php or http://XXX/super_batch.php

Just the page name as I'm having a funny five minutes and have lost my place. (obviously I don't want your admin URL...yet).

admin\super_batch_forms.php
and
admin\super_batch_status.php

carlvt88:

Does the browser have a horizontal scroll bar at the bottom of the page, that is, did the menu items not really disappear but move off the screen?

philip_clarke:

Which page is this ? e.g.

http://XXX/super_orders.php or http://XXX/super_batch.php

Just the page name as I'm having a funny five minutes and have lost my place. (obviously I don't want your admin URL...yet).

on around line 147 in the file admin/super_batch_forms.php you should have

          <td valign="top"><table border="0" cellspacing="3" cellpadding="0">
             <tr>
               <td class="smallText"><?php echo HEADING_SEARCH_PAYMENT_METHOD; ?></td>
               <td class="smallText" colspan="3"><?php echo zen_draw_pull_down_menu('payments', $payments, $_GET['payments'], ''); ?></td>

if you add a word like HELLO

            <td valign="top">HELLO<table border="0" cellspacing="3" cellpadding="0">
              <tr>
                <td class="smallText"><?php echo HEADING_SEARCH_PAYMENT_METHOD; ?></td>
                <td class="smallText" colspan="3"><?php echo zen_draw_pull_down_menu('payments', $payments, $_GET['payments'], ''); ?></td>

That should pop up where you are missing the boxes. Of course if you don't have the code, then that could be the problem !

Now if it doesn't turn up you could look at admin/includes/languages/english/super_batch_forms.php because say if a < had popped into one of the defines, the it could muck up the html (although I acknowledge that you've said 'view source' shows it not appearing as HTML).

Philip.

Thank you for your response. I tried ading the "hello" as you sugested but nothing shows up. I also checked the admin/includes/languages/english/super_batch_forms and it doe snot appear to have any issues. I'm baffled as I really have not made any changes that would have any connection to this. That section of the code does not appear even at the source level.

philip_clarke:

on around line 147 in the file admin/super_batch_forms.php you should have

       <td valign="top"><table border="0" cellspacing="3" cellpadding="0">
          <tr>
            <td class="smallText"><?php echo HEADING_SEARCH_PAYMENT_METHOD; ?></td>
            <td class="smallText" colspan="3"><?php echo zen_draw_pull_down_menu('payments', $payments, $_GET['payments'], ''); ?></td>

>  
> if you add a word like HELLO
>  
> ```html
            <td valign="top">HELLO<table border="0" cellspacing="3" cellpadding="0">
              <tr>
                <td class="smallText"><?php echo HEADING_SEARCH_PAYMENT_METHOD; ?></td>
                <td class="smallText" colspan="3"><?php echo zen_draw_pull_down_menu('payments', $payments, $_GET['payments'], ''); ?></td>

That should pop up where you are missing the boxes. Of course if you don't have the code, then that could be the problem !

Now if it doesn't turn up you could look at admin/includes/languages/english/super_batch_forms.php because say if a < had popped into one of the defines, the it could muck up the html (although I acknowledge that you've said 'view source' shows it not appearing as HTML).

Philip.

So to confirm, you do have the PHP code but HELLO or the other side does not show up even when changes are made ?

Put a hello in the top of the page, I can't remember on IE but it's something like shift+ctrl+R or f5 to refresh and clear the cache and if the HELLO does not show up then the wrong file is being edited or it's being cached. The next question would be where is the right file ? and that's a tricky one since it's in admin it is unlikely to have a template override where one file is being loaded in preference to another. I assume you have re-uploaded the file just in case of corruption (thinking to myself at the moment that this is a stupid comment to make because if you've edited the file to add HELLO then the file must be reasonably intact to have found the line).

Try adding Hello to another file like the super_orders.php main file, or creating a new file on the system and visiting it, because I know this may sound strange but the only thing I can think of it is that your hosting company moved your files and you're editing the wrong ones, it's the only thing that expains the non-appearance of the HELLO and the changes happening without youu doing anything.

Philip.

Yes I put the hello in the page and refreshed and the hello did show up in the source of the page so I am loading the correct file it seems but the other menus are still gone. It is very strange. I can't for the life of me figure out what could have happened or be causing this. I actually have a test site on another server and on the test site things are still working fine so I copied all the associated files from the test site and copied them over for good measure and still no change.

philip_clarke:

So to confirm, you do have the PHP code but HELLO or the other side does not show up even when changes are made ?

Put a hello in the top of the page, I can't remember on IE but it's something like shift+ctrl+R or f5 to refresh and clear the cache and if the HELLO does not show up then the wrong file is being edited or it's being cached. The next question would be where is the right file ? and that's a tricky one since it's in admin it is unlikely to have a template override where one file is being loaded in preference to another. I assume you have re-uploaded the file just in case of corruption (thinking to myself at the moment that this is a stupid comment to make because if you've edited the file to add HELLO then the file must be reasonably intact to have found the line).

Try adding Hello to another file like the super_orders.php main file, or creating a new file on the system and visiting it, because I know this may sound strange but the only thing I can think of it is that your hosting company moved your files and you're editing the wrong ones, it's the only thing that expains the non-appearance of the HELLO and the changes happening without youu doing anything.

Philip.

Can you PM me, with the details because it looks like I'll have to have a look at it since you're editing the correct file and I can't think of anything to recreate this scenario.

Philip.

I have a question, I search this thread and found a few posts on it, but there old, and I am not sure the fixes are for this version. Super Orders is a great module and I have been using it for a long time, one thing that the order page did not have on my super orders was the shipping information, I have always had to get this from the new order e-mail, and when that did not come had to guess, but the more I think about it, there should be shipping information on the order page that tells you what type of shipping the order has, does super orders have this type of feature?, and if so could someone help me uncover it, at lest get me going in the right direction.

pete

I suspect that someone will contact you soon, I found out this morning that someone is selling their wares to modify this to display shipping information, and no doubt they are reading this thread.

Philip.