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

hey guys, have a quick question

does anybody have a problem with sending emails with batch update

I've updated from SO 1.2 where it worked fine but now that I've upgraded to 2.0 when I make a batch status update (and I tack the notify customer) it updates the orders but doesn't send email (also when I check the status, there is a red X with the update denoting that customer wasn't notified).

Any ideas?

Much appreciate it.

Using Zen-Cart 1.3.6 and otherwise emails work OK (except for this :blush:)

cedomir:

hey guys, have a quick question

does anybody have a problem with sending emails with batch update

Yup.. I and a few others... as far as I know it has not been figured out yet. I worked on it for a while then just had to get to work emailing customers that I thought I had already emailed - LOL.

If you ever figure a fix please post it here so we will all know :D

harlyman:

I have made a pic out of my problem and i hope you will se what i mean here, i think i know what to do to change this but not sure where, from my side it looks like sub-total gets the amount inc tax and not without, so this is what i need to change, and there is no help in changing configuration sections, for display tax.
Set the following two options to false, and see what you get:

• Admin > Configuration > My Store > Display Prices with Tax
• Admin > Configuration > My Store > Display Prices with Tax in Admin

BlindSide:

Set the following two options to false, and see what you get:

• Admin > Configuration > My Store > Display Prices with Tax

• Admin > Configuration > My Store > Display Prices with Tax in Admin

the same as before, sub-total is still with tax

Hi Frank,

I've installed Super Orders 2.0, and my invoices are printing with a balance due even though they have paid, and the amount applied is $0.00, like this:

Sub-Total: $9.00
United States Postal Service: $6.05
Local Sales Tax: $0.66
Total: $15.71
Amount Paid: $0.00
Balance Due: $15.71

Could this be due to a mis-configuration of the payment status, or are the amounts due and applied coming from somewhere else?

Thanks,

David

Lovere:

I've installed Super Orders 2.0, and my invoices are printing with a balance due even though they have paid, and the amount applied is $0.00, like this:
See the bolded portion for the answer to your problem. :wink2:

/edit: Okay, on a second read-thru, you may also mean that the order total line is coming up zero. In that case, do you have a payment line item listed above the product listing? Even if they paid in full, if there's no SO payment line reflecting it, the amount applied will remain at zero.

I'm working on something here and wanted some initial feedback. Custom job I'm working on has required me to make some customizations to the Sales Report, another contrib I maintain. These customizations tie into the Super Orders system, so I was thinking that I might bundle the sales report into the next release and pass these mods along to you.

It's still the same report, you'll just have extra SO-specific options available. At the moment I am adding the following...

• Optional switch to remove orders marked as canceled (that big red button in lower left corner of order details)
• Include returns and exchanges (another new feature) at the end of the report if they fall within the specified date range (due to their unique nature, the other SR filters wouldn't apply)
  I've always thought the two would eventually meet, since they overlap so much. Just wanted to see what the public at large thought, and if they had any other ideas to link the two together. :smile:

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?

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.

ahelis:

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

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.

creeperkat:

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.

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.
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! :thumbsup: ), 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! :yes:

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

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.

harlyman:

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?

BlindSide:

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?

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

BlindSide:

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:(

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.

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.

ok, will do, but does SO get this info from the db or?? if so, is it possible to force this setting to get the data ex tax?