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

[samad64]

Not sure if this a bug in my Super Orders setup or just in my understanding of the feature. I am hoping that I can change the product description before Invoicing under certain circumstances and/or change the pricing.

Zen Cart 1.3.5
Super Orders 2.0

Admin -> Customers -> Super Orders -> Detail Button -> Edit Products link.

The edit products window opens but does not provide any way to change the information on the items. The only form element in the window is the checkbox to Notify the customer and move the order to the next incremental. It list all the products in the order, including pricing but it is not editable.

currently edit products is not installed in Super Orders. Its being developed as we speak by Blindside :)

For order editing.. use Super Orders 1.3 - just a note though that 1.3 uses an older Edit Orders mod which isn't perfect.. and will screw up from time to time

[ahelis]

Thanks getyourgameshere,

Like too many others, rushed in to install the module without reading enough of the posts in this forum. Maybe it would be better to have a couple of sticky posts at the top of this thread that should be required reading before installing the module.

Other than a few errors installing the super_orders_sql.sql file all the files outlined in the new install file were accurate and were completed just fine.

Mysql 5.0.18 Install procedure:

1. Edit super_orders_sql.sql, add first line USE zen3; to specify the database to access.

2. Install the .sql file from the command line:
$ mysql -u root -p < super_orders_sql.sql

After logging in and out of zenCart Admin, the SuperOrders menu item was not displaying in the configuration list.

3. Try Admin -> Tools > Install SQL Patches

First sql error:
Duplicate entry 'CA' for key2 in [INSERT INTO so_payment_types VALUES (NULL, 1 'CA', 'Cash');]

Because, I had manually loaded the .sql file first. Ok, comment out the problem line.

4. Retry using the Install SQL Patches window, and everything loaded without errors.

Summary:

Reloading the Admin, the configuration menu includes the Super Orders and Super Orders is available in a couple of other locations. My overall impression is this is a great improvement over the basic admin and would recommend it to others. From a functionality point of view, you can easily add Discounts, Credits or other items after the subtotal to modify what the customer pays for his order. Your invoice will become cleaner when the product edit feature becomes available but can be accomplished now as a separate line after the subtotal. I really like the ability to add/edit the customer's status history as you can document any changes with the customer's order.

[BlindSide]

I tried uploading the SQL file and got the following error:
1062 Duplicate entry 'STORE_FAX' for key 2
in:
[INSERT INTO configuration VALUES ('', 'Store Fax', 'STORE_FAX', '', 'Enter the fax number for your store.
You can call upon this by using the define STORE_FAX.', 1, 4, now(), now(), NULL, 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.


If I go to phpMyAdmin, I see the so_ tables. I do not see the Admin>Configuration>Super Orders though.

I tried deleting all the so_ tables in phpMyAdmin and rerunning the SQL upload but I got the same error. Any ideas on how to fix this?

The so_* tables were not the problem, but rather the inserts made to the configuration table. Do a search in the SQL file for the following:

insert into configuration

See all that stuff? If you attempt and fail to run the SQL file, then run it again, it does not overwrite existing entries. Unless you know what you're doing, your best bet is to restore from the backup you made right before running the SQL file and try again. The file works if applied properly.

Thanks getyourgameshere,

Like too many others, rushed in to install the module without reading enough of the posts in this forum. Maybe it would be better to have a couple of sticky posts at the top of this thread that should be required reading before installing the module.

Or just read the whole README file. Most of it is covered in there. I'd like to comment on your installation procedures (which are great! ), in hopes they save others from this recurring issue...

1. Edit super_orders_sql.sql, add first line USE zen3; to specify the database to access.

2. Install the .sql file from the command line:
$ mysql -u root -p < super_orders_sql.sql

This should typically be a given. The file should be run using a tool that already knows which DB to run on (i.e. phpmyadmin). Your step 2 would be the correct procedure if using the command line (which most shared hosts don't allow).

(Aside: As an FYI, I have a dedicated server like you, and I never use the command line. I think you'll find it far easier to maintain your DB's using phpMyAdmin. Just my opinion, though.)

After logging in and out of zenCart Admin, the SuperOrders menu item was not displaying in the configuration list.

3. Try Admin -> Tools > Install SQL Patches

First sql error:
Duplicate entry 'CA' for key2 in [INSERT INTO so_payment_types VALUES (NULL, 1 'CA', 'Cash');]

Because, I had manually loaded the .sql file first. Ok, comment out the problem line.

Bolding is my emphasis. This is for everyone who gets "duplicate entry" errors when running the SQL. Re-running the file simply won't work; comment out the duplicate line ('cause it went in properly on the first try), or reload your DB, fix the problem that caused the first failure, and try again.

4. Retry using the Install SQL Patches window, and everything loaded without errors.

See? DB properly selected; SQL file and DB properly configured; alls well!

[harlyman]

Hello BlindSide

Have you looked at this problem? any idea where and what i can edit to force sub-total to get the amount ex tax?

this is the only problem i have with this contribution, rest of it works great, would have been great to solve this small problem also..

[creeperkat]

Thank you Blindside. Fortunately, I did not have much in my database yet. I just ended up creating a fresh new database and everything worked out great.

Thanks again.

[BlindSide]

Have you looked at this problem? any idea where and what i can edit to force sub-total to get the amount ex tax?

this is the only problem i have with this contribution, rest of it works great, would have been great to solve this small problem also..

Does the sub-total appear differently when viewed through the regular orders.php file?

[harlyman]

Does the sub-total appear differently when viewed through the regular orders.php file?

hmm no, same problem sub-total is still inc tax, does zen-cart get the sup-total inc tax as default?? should be possible to change this and get the sub-total ex tax or?

[BlindSide]

Yes, it's determined by those configuration switches I posted before. You're sure you turned them both off?

[harlyman]

Yes, it's determined by those configuration switches I posted before. You're sure you turned them both off?

yes, both off, but sub-total is still inc tax

[BlindSide]

I'm afraid I don't have an answer for you. It's obviously not SO, and those two settings are the only ones I know of that affect the tax display. My store is non-profit, so my experience with tax is limited. You should do some forum searches, and check out the tax tutorials.