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

Quote:

---

Originally Posted by HMG

Okay, you were of course, correct. Some files were missing. I placed them in the appropriate spot but still do not see the missing categories in the Admin tools. Do I need to re-run the script? If so, any other edits to the script since it's already been installed?

Thanks.

---

I went ahead and tried to re-run the script, keeping in mind the usual issues with duplicate entries for payment types. I rec'd the following note in the admin console and still see nothing for Super Orders other than in Admin --> Configuration --> Super Orders:


ERROR: Cannot ADD column date_completed because it already exists.
ERROR: Cannot ADD column date_cancelled because it already exists.
ERROR: Cannot ADD column balance_due because it already exists.
ERROR: Cannot create table customers_admin_notes because it already exists
ERROR: Cannot create table so_payments because it already exists
ERROR: Cannot create table so_payment_types because it already exists
ERROR: Cannot create table so_purchase_orders because it already exists
ERROR: Cannot create table so_refunds because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_STATUS" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_PAYTO" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_SORT_ORDER" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_ZONE" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_ORDER_STATUS_ID" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_PO" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_PO_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_REFUND" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_PO_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_PO" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_REFUND" because it already exists
ERROR: Cannot insert configuration_key "FED_TAX_ID_NUMBER" because it already exists
ERROR: Cannot insert configuration_key "STATUS_ORDER_CANCELLED" because it already exists
ERROR: Cannot insert configuration_key "STATUS_ORDER_COMPLETED" because it already exists
ERROR: Cannot insert configuration_key "STATUS_ORDER_REOPEN" because it already exists
Note: 25 statements ignored. See "upgrade_exceptions" table for additional details.

how can I reverse the bill to and ship to on the packing slip ?

Quote:

---

Originally Posted by HMG

Okay, you were of course, correct. Some files were missing. I placed them in the appropriate spot but still do not see the missing categories in the Admin tools. Do I need to re-run the script? If so, any other edits to the script since it's already been installed?

Thanks.

---

If you still don't see the categories, then you still have files missing, simple as that. Make sure you have everything from the "admin/includes/boxes" folder uploaded properly.

And no, the script only needs to be run once. Running it more than once will get in the same boat as these other poor souls.

@Other poor souls - Your problems would largely be rectified by a proper installer, like the one that comes with stock Zen Cart. That was to be part of the next release, but given all my delays I may have to release it without one.

Quote:

---

Originally Posted by HMG

I went ahead and tried to re-run the script, keeping in mind the usual issues with duplicate entries for payment types. I rec'd the following note in the admin console and still see nothing for Super Orders other than in Admin --> Configuration --> Super Orders:


ERROR: Cannot ADD column date_completed because it already exists.
ERROR: Cannot ADD column date_cancelled because it already exists.
ERROR: Cannot ADD column balance_due because it already exists.
ERROR: Cannot create table customers_admin_notes because it already exists
ERROR: Cannot create table so_payments because it already exists
ERROR: Cannot create table so_payment_types because it already exists
ERROR: Cannot create table so_purchase_orders because it already exists
ERROR: Cannot create table so_refunds because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_STATUS" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_PAYTO" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_SORT_ORDER" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_ZONE" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_ORDER_STATUS_ID" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_PO" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_PO_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_REFUND" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_PO_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_PO" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_REFUND" because it already exists
ERROR: Cannot insert configuration_key "FED_TAX_ID_NUMBER" because it already exists
ERROR: Cannot insert configuration_key "STATUS_ORDER_CANCELLED" because it already exists
ERROR: Cannot insert configuration_key "STATUS_ORDER_COMPLETED" because it already exists
ERROR: Cannot insert configuration_key "STATUS_ORDER_REOPEN" because it already exists
Note: 25 statements ignored. See "upgrade_exceptions" table for additional details.

---

Same problem as the duplicate payment types, HMG. These are all existent entries, and thus entering them again causes conflicts. I suggest that, instead of running the whole thing, you simply extract the part(s) you need and run it from the SQL box in phpMyAdmin.

Quote:

---

Originally Posted by NullMind

how can I reverse the bill to and ship to on the packing slip ?

---

You'll have to edit admin/super_packingslip.php. Pretty easy edit; you just have to change one word in two lines. The delivery line looks like this...

Code:

---

<td class="main"><?php echo zen_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br />'); ?></td>

---

...and the billing looks like this...

Code:

---

<td class="main"><?php echo zen_address_format($order->customer['format_id'], $order->billing, 1, '', '<br />'); ?></td>

---

Swap the two words I have highlighted in green and red with their counterpart in the opposing line.

Quote:

---

Originally Posted by BlindSide

If you still don't see the categories, then you still have files missing, simple as that. Make sure you have everything from the "admin/includes/boxes" folder uploaded properly.

And no, the script only needs to be run once. Running it more than once will get in the same boat as these other poor souls.

---

Getting CLOSER! The only thing I am missing now seems to be the PO Payment module. I am unsure if the folder "extra_datafiles" is just a place holder and the file "super_orders_defines.php" belongs in the root of admin/includes.

I'm sorry about all the questions, I didn't see in the directions anything about moving files out of placeholder directories, so pardon me if I misunderstood!

Thanks!

Quote:

---

Originally Posted by HMG

Getting CLOSER! The only thing I am missing now seems to be the PO Payment module. I am unsure if the folder "extra_datafiles" is just a place holder and the file "super_orders_defines.php" belongs in the root of admin/includes.

I'm sorry about all the questions, I didn't see in the directions anything about moving files out of placeholder directories, so pardon me if I misunderstood!

Thanks!

---

Screenshot attached so you can see what I mean.

Quote:

---

Originally Posted by HMG

Screenshot attached so you can see what I mean.

---

Okay, I think I have the problem solved.

Everything seems to look right, including purchase orders. Now to test! Thanks for all the help, I will be using this module quite a bit, it seems -perfect- for what I need it to do.

-HMG

:clap:

Glad you got it working. And for anyone who's having the same problem, let me make it clear: you must upload all the files in the included directory structure; that's what allows them to drop into the proper places on your server.

I installed this for the first time last night, and couldn't get everything to show up in admin.

I uploaded the files twice and I checked the folder/files for accuracy, but I still cant see this:

Admin --> Configuration --> Super Orders:

/mycopath.com/html/admin/includes/boxes/extra_boxes

has the following files:
super_orders_customers_dhtml.php
super_orders_localization_dhtml.php
super_orders_reports_dhtml.php


am I missing any other files? are there files from the previous install that weren't included in the new file set?

Thanks!

-Graham

The configuration entries have nothing to do with the files, they are all entries in the DB, which means you probably didn't run the SQL file. Run the included SQL file over your DB and those entries will appear.

I have run the sql file, and the other super order links are there... but not the admin.

-Graham