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

I read through a b'jillion posts on this but can't find if this is workable off the shelf for 1.3.8

Quote:

---

Originally Posted by serrow

I read through a b'jillion posts on this but can't find if this is workable off the shelf for 1.3.8

---

Yep, still working.:clap:

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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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