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

Hi there,

Just downloaded the module and need help.


When printing out invoices, I want to take out the Fed Tax Id line. I don't need it and seem to have some trouble taking it out.
I set the define to '' but still seem to have this showing.

I have reviewed this thread and still can't seem to take it out entirely. Any help would really be appreciated.

Thanks again,
Happyworker
www.popoutportraits.com

Figured it out.

Thanks.

When I attempt to run the SQL Tool I get the following messages

super_orders_sql.sql;
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'super_orders_sql.sql' at line 1
in:
[super_orders_sql.sql;]
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.

Can anyone let me know what I need to do here.

Thanks

hello all

I have one question to the edit total part, if i will give a customer a discount, it takes the discount and adds it to the total amount instead, have triad to add a - to the amount with no luck, also if i remove the discount i try to add, it adds the amount again and makes the total higher, how do i substract the discount from total?? se below:

Original:

Total products: 3.870Kr
Shipping : 69Kr
Tax 25.0%: 788Kr
Total Order : 3.939Kr
Amount payed: 0Kr
Payment due : 3.939Kr

New order with discount:

Total products: 3.870Kr
Discount : -200Kr
Shipping : 69Kr
Tax 25.0% : 788Kr
Total Order : 4.527Kr
Amount payed: 0Kr
Payment due : 4.527Kr

the same happens if i add the discount with or without a - infront of the amount, any ideas what i'm doing wrong or what could be wrong??

Fed Tax ID #HEADER_TAX_ID_NUMBER on Invoices.

Can any tell me how I get around this problem, I had some problems in SQL update but installed manually, I have the field in Super Orders Config. and filled it in with my TAX number(whichs saves my number OK) but I still have the problem. I see that it will give me None in the TAX class as it is not seeing this field?

Also I have tried to run the super_upgrade.php and I get this error page when I press the submit button?

Quote:

---

Not Found

The requested URL /admin/super_upgrade.php was not found on this server.

---

Thanks
Andrew

Quote:

---

Originally Posted by [email protected]

When I attempt to run the SQL Tool I get the following messages

super_orders_sql.sql;
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'super_orders_sql.sql' at line 1
in:
[super_orders_sql.sql;]
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.

Can anyone let me know what I need to do here.

---

If it's giving you trouble, don't use the SQL tool. Run the script from phpMyAdmin.

Quote:

---

Originally Posted by harlyman

I have one question to the edit total part, if i will give a customer a discount, it takes the discount and adds it to the total amount instead, have triad to add a - to the amount with no luck, also if i remove the discount i try to add, it adds the amount again and makes the total higher, how do i substract the discount from total?? se below:

Original:

Total products: 3.870Kr
Shipping : 69Kr
Tax 25.0%: 788Kr
Total Order : 3.939Kr
Amount payed: 0Kr
Payment due : 3.939Kr

New order with discount:

Total products: 3.870Kr
Discount : -200Kr
Shipping : 69Kr
Tax 25.0% : 788Kr
Total Order : 4.527Kr
Amount payed: 0Kr
Payment due : 4.527Kr

the same happens if i add the discount with or without a - infront of the amount, any ideas what i'm doing wrong or what could be wrong??

---

It should create a discount (negative value) by simply adding a minus symbol to the front of the number. So for a 10Kr discount, type "-10" into the number field.

However you're saying you already tried this, so I'm wondering if this is a currency issue (I thought I had all that stuff licked). Do you accept any other currencies you might test this theory with?

Quote:

---

Originally Posted by Scrat

Fed Tax ID #HEADER_TAX_ID_NUMBER on Invoices.

Can any tell me how I get around this problem, I had some problems in SQL update but installed manually, I have the field in Super Orders Config. and filled it in with my TAX number(whichs saves my number OK) but I still have the problem. I see that it will give me None in the TAX class as it is not seeing this field?

Also I have tried to run the super_upgrade.php and I get this error page when I press the submit button?

---

Andrew, I'm afraid you likely have an EBSAK error here. :wink2:

The HEADER_TAX_ID_NUMBER define is configured through the database, so it sounds like you did not properly run the SQL script.

You're getting the page not found error for super_upgrade.php because it sits in a separated folder, because not everyone will need it. Look for a folder named "_upgrade" in the download, you'll find the file in there. Just upload that to your admin folder and run. You only need to run this file if you were using the payment system in the old super orders, so make sure you actually need to run the file before doing so.

Quote:

---

Originally Posted by BlindSide

It should create a discount (negative value) by simply adding a minus symbol to the front of the number. So for a 10Kr discount, type "-10" into the number field.

However you're saying you already tried this, so I'm wondering if this is a currency issue (I thought I had all that stuff licked). Do you accept any other currencies you might test this theory with?

---

i have usd also installed, and it looks like it works with usd, so looks like its a currency problem:(

any idea??

Quote:

---

Originally Posted by harlyman

i have usd also installed, and it looks like it works with usd, so looks like its a currency problem:(

any idea??

---

No but at least I have a starting place to look. I will let you know.

You're in luck, this was a quick fix (I hope). Open admin/includes/super_edit.php and find this block of text:

Code:

---

            elseif($ot_class == "ot_gv" || $ot_class == "ot_coupon" || $ot_class == "ot_group_pricing") {
              $running_total -= $ot_value;
            }

---

Create a new line directly after it (i.e. after the ending curly brace "}"), and add the following new block of code:

Code:

---

            elseif ($ot_value < 0) {
              $ot_value = abs($ot_value);
              $ot_class = "ot_coupon";
              $running_total -= $ot_value;
            }

---

Upload the file to your server and try another negative number. Remember that you can delete an order total entry by completely deleting the text and value from the order screen.

Quote:

---

Originally Posted by BlindSide

You're in luck, this was a quick fix (I hope). Open admin/includes/super_edit.php and find this block of text:

Code:

---

            elseif($ot_class == "ot_gv" || $ot_class == "ot_coupon" || $ot_class == "ot_group_pricing") {
              $running_total -= $ot_value;
            }

---

Create a new line directly after it (i.e. after the ending curly brace "}"), and add the following new block of code:

Code:

---

            elseif ($ot_value < 0) {
              $ot_value = abs($ot_value);
              $ot_class = "ot_coupon";
              $running_total -= $ot_value;
            }

---

Upload the file to your server and try another negative number. Remember that you can delete an order total entry by completely deleting the text and value from the order screen.

---

Hi BlindSide

That did not work, when i try to delete the entry, it adds the amount once more, and it does not change the tax, its the same ....
But i know now whats wrong, guess its my head again, i have total with tax and when i add a new line to the total, it take the total products -discount then add shipping and tax, thats why it gets wrong......

any idea how to change this??

Thanks for your reply BlindSide,

Quote:

---

Andrew, I'm afraid you likely have an EBSAK error here.

The HEADER_TAX_ID_NUMBER define is configured through the database, so it sounds like you did not properly run the SQL script.

---

How do I fix it, it have run all the SQL inserts seperately via phpadmin and it told me if their was any errors or dupicate entries, which I have removed.

Everything else seems OK

P.S What does EBSAK stand for ?:wacko:

If you properly ran the SQL file and all of it went in fine, try running just the following line. It's the SQL for the Tax ID config:

Code:

---

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Federal Tax Exempt Number', 'FED_TAX_ID_NUMBER', '', 'If your tax exempt, then you should have a federal tax ID number. Enter the number here and the tax columns will not appear on the invoice. The number will also be displayed at the top of the invoice.<br /><br /><strong>If you do not have a tax exempt number, leave this field blank.</strong>', @so_gid_new, 50, now(), now(), NULL , NULL);

---

However I should warn that since this one config isn't in there, it's likely there are more problems elsewhere. The best thing to do is restore from your DB backup (you did back up right?) and run the SQL file "clean" from phpMyAdmin (it gives better error descriptions).

EBSAK is an acronym we tech support people use, stands for "Error Between Seat And Keyboard." Don't worry, I use it out of love; I have more "choice" words for the truly unintelligent. :wink2:

Hi,

I did a backup from within Zencart, using the Backup utility. I have just tried your suggestion and this is the error I get?

Quote:

---

#1048 - Column 'configuration_group_id' cannot be null

---

I suppose because I did a backup this way it only backups the Data not the database fields!:no:

Quote:

---

Originally Posted by harlyman

Hi BlindSide

That did not work, when i try to delete the entry, it adds the amount once more, and it does not change the tax, its the same ....
But i know now whats wrong, guess its my head again, i have total with tax and when i add a new line to the total, it take the total products -discount then add shipping and tax, thats why it gets wrong......

any idea how to change this??

---

Hi BlindSide

After some more brain tweeking the problem is that my sub-total has tax included, thats why your module shows the total wrong, so i figured this problem to my problem not a SO problem, i think all i have to do is to get zen-cart to show sub-total without tax in admin, that way when i edit an order it will be correct, i just need to find the correct file to edit or setting to fix:) any hint?

Ho do I implement the Federal Tax ID ?

Quote:

---

Originally Posted by Scrat

Hi,

I did a backup from within Zencart, using the Backup utility. I have just tried your suggestion and this is the error I get?

Code:

---

#1048 - Column 'configuration_group_id' cannot be null

---

I suppose because I did a backup this way it only backups the Data not the database fields!:no:

---

So you're trying to restore from your backup? What backup utility are you using, the downloadable contrib? Something on your host's control panel? phpMyAdmin?

Whatever the answer, your question would be better posed to someone who's responsible for that utility. The error you have sounds like the backup set the configuration_group_id for reinserting configuration entries to NULL. I believe that's okay in the latest versions of MySQL (v5.x), but not earlier versions like v3.23. This is why I always recommend phpMyAdmin for all DB editing, it's smart enough to change syntax based on your server version.

Quote:

---

Originally Posted by harlyman

After some more brain tweeking the problem is that my sub-total has tax included, thats why your module shows the total wrong, so i figured this problem to my problem not a SO problem, i think all i have to do is to get zen-cart to show sub-total without tax in admin, that way when i edit an order it will be correct, i just need to find the correct file to edit or setting to fix:) any hint?

---

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

Not too obvious a hint I hope... :blink:

Quote:

---

Originally Posted by m8trixdg

Ho do I implement the Federal Tax ID ?

---

Read the README file.

How do I read a readme file? Is there instructions for that???

Quote:

---

Originally Posted by s_mack

How do I read a readme file? Is there instructions for that???

---

Do you want me to "s_mack" you? :P

Quote:

---

Originally Posted by BlindSide

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

Not too obvious a hint I hope... :blink:

Read the README file.

---

Well i triad that but it doesnt change the sub-total when i go to edit an order, looks like sub-total gets the total amount with tax, instead of without tax, is it possible to override this?? so sub-total gets the amount without tax allways?

Your two sentences directly conflict with one another... perhaps you can re-word so it is more clear:

Quote:

---

looks like sub-total gets the total amount with tax

---

Quote:

---

so sub-total gets the amount without tax allways?

---

- Steven

Quote:

---

Originally Posted by s_mack

Your two sentences directly conflict with one another... perhaps you can re-word so it is more clear:



- Steven

---

sure, did type a bit to fast here i think, for where i'm standing it looks like sub-total in SO gets the amount with tax for some reason, and this might be becouse of some settings in my cart, but i would like to change this to sub-total with no tax.

this might have to be done in the code some where but my php skils are not at its best but still learning:)

did this help?

I guess... but did this not help then?

Quote:

---

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

---

Because that's where it is defined, as BlindSide said.

- Steven

Quote:

---

Originally Posted by s_mack

I guess... but did this not help then?

Because that's where it is defined, as BlindSide said.

- Steven

---

no it changed all prices to no tax but the sub-total and total in the part where we can edit the total order, guess this part is where the problem might be, thats why i would like to change sub-total to use the products price without tax allways.

Ok, I posted on here about the Federal Tax ID section. Got a great response, thanks. But Part of my issue is that I can not see Super Orders under the Configuration menu.

I do have Admin_Profiles installed and all other screens are fine. I just do not see this one page.

Any ideas?

Frank

I am still looking at how to fix the issue I have with Super Orders 2.0

When I attempt to run the SQL Tool I get the following messages

super_orders_sql.sql;
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'super_orders_sql.sql' at line 1
in:
[super_orders_sql.sql;]
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.

Can anyone let me know what I need to do here.

Thanks


David Moody

Quote:

---

Originally Posted by [email protected]

Frank

I am still looking at how to fix the issue I have with Super Orders 2.0

When I attempt to run the SQL Tool I get the following messages

super_orders_sql.sql;
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'super_orders_sql.sql' at line 1
in:
[super_orders_sql.sql;]
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.

Can anyone let me know what I need to do here.

Thanks


David Moody

---

I had that very same issue as I recall, but it's been a while since I installed SO. If I recall correctly, when you get that error, you have to scroll down to the bottom where the sql file is showing in the window and delete the part of the comments section that refers to "customer's order" because that apostrophy is causing the glitch. Try that and see if it works for you.

Yes i used the Database Backup Manager - MySQL in downloads section, I have upgraded to the lastest stable version of PhpAdmin and still I get the same result when I run your

Code:

---

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Federal Tax Exempt Number', 'FED_TAX_ID_NUMBER', '', 'If your tax exempt, then you should have a federal tax ID number. Enter the number here and the tax columns will not appear on the invoice. The number will also be displayed at the top of the invoice.<br /><br /><strong>If you do not have a tax exempt number, leave this field blank.</strong>', @so_gid_new, 50, now(), now(), NULL , NULL);

---

What I find strange is that everything else works fine except for the TAX. I originally inserted all the sql via PHPadmin.
Any other ideas what I can do to fix it?

Quote:

---

Originally Posted by crazycucumber

nice to see extra work going into super orders , can I just say I still dont have a working version for Batch e-mailing to update order - can anyone let me know if they ever solved this.

Cheers

---

I seem to keep getting forgotten ! :-(

Does anyone else still have this issue ?

Did you Solve it ?

Please Please help !

Tried on 1.3.5 and 1.3.6 , tried changing maiing settings to PHP , SMTP , etc etc

Its not getting blocked as SP@M and red tiks always appear when I ask it to update the orders and e-mail the customer. !


THANKS

I am having the same problem. When someone places an order, it just says that the order is with UPS or whatever - it doesn't say what the actual method of shipping is (Second day, etc...). This is vital to know and right now we have to rebuild *EVERY* order in order to match the shipping price with the methods in order to find out what people actually clicked on for shipping. We need to be able to print the method on the detail page, and the print pages.

Thanks for the super effective fix on this. Much appreciated!!!

:-D
:-D

Quote:

---

Originally Posted by crazycucumber

I seem to keep getting forgotten ! :-(

Does anyone else still have this issue ?

Did you Solve it ?

Please Please help !

Tried on 1.3.5 and 1.3.6 , tried changing maiing settings to PHP , SMTP , etc etc

Its not getting blocked as SP@M and red tiks always appear when I ask it to update the orders and e-mail the customer. !

---

Didn't forget about it, I just haven't had time to attempt a repro. It's a pretty deep problem, and I have to edit the mailer class so that messages get "processed" as sent without actually going out (don't wanna spam my customers with test messages).

Quote:

---

Originally Posted by finius_lyn

I am having the same problem. When someone places an order, it just says that the order is with UPS or whatever - it doesn't say what the actual method of shipping is (Second day, etc...). This is vital to know and right now we have to rebuild *EVERY* order in order to match the shipping price with the methods in order to find out what people actually clicked on for shipping. We need to be able to print the method on the detail page, and the print pages.

---

Quote:

---

Originally Posted by finius_lyn

Thanks for the super effective fix on this. Much appreciated!!!

---

I love solving problems before people even know they have one. It's such a rare treat in this world.

I'm having an issue at the moment having just installed this mod. Fresh install of 1.36 zen, a few other payment mods running including fax po, dir bank, ceon credit card, invoice popup. This means I'm not using the SO Purchase Order payment option (installed, not activated).

The only problem I'm having with this SO 2, rev 45 mod is that the email notification is not actually sending out the emails (to both customer and admin notifications). SO indicates success (just like the normal Orders module).

Checking email_archive confirms email is not sent. Works fine from the built Orders module however.

Any ideas?

What e-mails aren't going out? Normal order status updates? Batch e-mails? Auto-status updates attached to payment entries?

I need you to be more specific, tell me exactly what you're doing.

Quote:

---

Originally Posted by BlindSide

What e-mails aren't going out? Normal order status updates? Batch e-mails? Auto-status updates attached to payment entries?

I need you to be more specific, tell me exactly what you're doing.

---

Normal emails BlindSide. Normal notification to customer plus admin Copy of Orders Status Emails.

Status history in SO indicates (check) that Customer Notified. This also updates the status in the build in Orders module. Only difference is that by updating status from the SO mod (for example from Pending to Delivered) the emails are not actually sent.

Tried to get around this problem but no joy, so have set

Code:

---

$display_tax = true;//(FED_TAX_ID_NUMBER == '' ? true : false);

---

Iin super_invoice.php, and it works fine and as Fed_Tax is not an issue for me. Thanks for your help, what a great Contr.:yes:

First, perform a status update from the normal orders.php and confirm that it goes out "all the way." Even if you already have once or twice before, humor me. If not, then obviously you have a general system issue.

Secondly, make sure that all the files are properly uploaded. Status e-mail are sent out via a function that sits in admin/includes/function/extra_functions/super_orders_functions.php; if that file is not there, or corrupted, you won't get an e-mail. Obviously you'll want to re-up admin/super_orders.php as well.

I would also check your store's e-mail settings. SO still ties into the usual zen mailing functions, so if anything is disabled, it won't go out. Take a look at Admin > Configuration > E-mail Options > Send E-mail. I know you already mentioned the admin copy, so it's unlikely, but if I had nickel for every obvious error I made... :happy:

Quote:

---

Originally Posted by Scrat

Tried to get around this problem but no joy, so have set

Code:

---

$display_tax = true;//(FED_TAX_ID_NUMBER == '' ? true : false);

---

Iin super_invoice.php, and it works fine and as Fed_Tax is not an issue for me. Thanks for your help, what a great Contr.:yes:

---

Glad you found a working solution, and you like the contrib. However this is def not normal behavior, and workarounds to bugs are a bad idea. I recommend you find out the true cause of the problem. A complete reinstall of the mod would be a good idea.

Quote:

---

Originally Posted by BlindSide

First, perform a status update from the normal orders.php and confirm that it goes out "all the way." Even if you already have once or twice before, humor me. If not, then obviously you have a general system issue.

---

As mentioned this works, however in the interest of great mirth and seasonal laughter I again deleted all files including ../super_orders.php, ../super_orders_functions.php and re-uploaded. Still no joy.

Switched back to built in Orders mod, changed status to test, all works (email notifications).. as it always has.

So, as you don't have an obvious answer, I'll take a closer look (especially at the super_orders_functions_php) when I get more time, try it on another site, etc.

Thanks for the quick responses!

One thing I'm going to check out later is whether it's possible that SO is changing the email in any way which might be targeted by Spam Assassin, as I just blackhole everything which meets a specific hit count.. any way, will look at this.

Although this is unlikely as I test using a "customer" with a gmail account, so even if I don't get admin notifcations, the "customer" should get theirs.

Just regarding SpamAssassin (i'm pretty sure it's not the problem unless you're removing mail that receives scores lower than 2.0) -- adding your admin account to your user_prefs file in the following way:

Code:

---

whitelist_from_rcvd [email protected]  example.com

---

Where:

[email protected] is the address of your admin account.

&

example.com is the domain name for the shop.

SpamAssassin will automatically rescore your mails to be whitelisted as long as a domain lookup works for your host.

Cheers,

Paul
(who has never had a problem with SpamAssassin and Zen-Cart)

Quote:

---

Originally Posted by BlindSide

It should create a discount (negative value) by simply adding a minus symbol to the front of the number. So for a 10Kr discount, type "-10" into the number field.

However you're saying you already tried this, so I'm wondering if this is a currency issue (I thought I had all that stuff licked). Do you accept any other currencies you might test this theory with?

---

Hello again Blindside

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.

any ideas??

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

Quote:

---

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

Quote:

---

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

Quote:

---

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

Quote:

---

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

Quote:

---

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

Quote:

---

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

Code:

---

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.

Quote:

---

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

Quote:

---

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

Quote:

---

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.

Quote:

---

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.

Quote:

---

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

Quote:

---

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

Quote:

---

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

Quote:

---

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

I'm pretty sure it's a DB setting via the configuration table but, again, no sure idea. :unsure:

Hello harlyman,

I did a little reseach into your problem and here are my findings. These are my opinons and how I would approach solving the problem. I am sure there are other ways inwhich to get to the same solution which maybe easier, but I have not found.

As Super Orders 2.0 works right now the subtotal amount is retrieved directly from the 'orders_totals' table in the db which I assume gets written after a customer has submitted their order. Ok, so lets review how this value is set when you view a customer's order in the admin:

admin/includes/classes/order.php 'Line #43-46'

Code:

---

$totals = $db->Execute("select title, text, class
  from " . TABLE_ORDERS_TOTAL . "
  where orders_id = '" . (int)$order_id . "'
  order by sort_order");

---

So, this part of the class stores the subtotal with tax from the 'orders_totals' table in the db.

admin/super_data_sheet.php 'Line#32'

Code:

---

$order = new order($oID);

---

The $order object gets created (instantiated) here and at this time $order->totals[$i]['text'] is assigned the order's subtotal with tax.

admin/super_orders.php 'Line#773'

Code:

---

<td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .

---

This line actually displays the subtotal from $order->totals[$i]['text'] on the order's detail page in the admin.

Ok, but you want subtotal without tax. I will outline my solution but I have not tried this or tested it and it will need through testing to get it right.

1. Inside 'admin/includes/classes/order.php', add a new method/function like getSubTotalwoTax( ) to query the 'orders_product' table which lists all the items in an order. Loop through all the product lines and calculate the sum of fields 'products_quantity' x 'products_price' and return the total amount.

2. In 'admin/super_data_sheet.php' after Line 32, add a new variable, say $subTotalwoTax and call your new function from the $order object as:

$subTotalwoTax = $order->getSubTotalwoTax($oID);

3. Inside 'admin/super_orders.php - Line#773' change $order->totals[$i]['text'] to $subTotalwoTax.

Ok, this is a rough hack, and personally, it would be better to edit the orders.php class and add another array variable to the totals member variable to make it cleaner. In that case, you could simply change the display line from $order->totals[$i]['text'] to say, $order->totals[$i]['subTotalwoTax'], but you get the idea.

Of course you need to document the exact changes you make, because any future upgrade of zen-cart will likely overwrite the orders.php file and your will lose your changes.

Hi,

I installed Super Orders on my store, but I don't see any of the functionality.

I can go to Admin>Config>Super Orders

But I can't find Admin>Customers>Super Orders

and I see no links to super orders on any of my existing orders.

Does it only work with new orders or did I mess up in the installation process?

Thanks,

Nate

Quote:

---

Originally Posted by ahelis

Hello harlyman,

I did a little reseach into your problem and here are my findings. These are my opinons and how I would approach solving the problem. I am sure there are other ways inwhich to get to the same solution which maybe easier, but I have not found.

As Super Orders 2.0 works right now the subtotal amount is retrieved directly from the 'orders_totals' table in the db which I assume gets written after a customer has submitted their order. Ok, so lets review how this value is set when you view a customer's order in the admin:

admin/includes/classes/order.php 'Line #43-46'

Code:

---

$totals = $db->Execute("select title, text, class
  from " . TABLE_ORDERS_TOTAL . "
  where orders_id = '" . (int)$order_id . "'
  order by sort_order");

---

So, this part of the class stores the subtotal with tax from the 'orders_totals' table in the db.

admin/super_data_sheet.php 'Line#32'

Code:

---

$order = new order($oID);

---

The $order object gets created (instantiated) here and at this time $order->totals[$i]['text'] is assigned the order's subtotal with tax.

admin/super_orders.php 'Line#773'

Code:

---

<td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .

---

This line actually displays the subtotal from $order->totals[$i]['text'] on the order's detail page in the admin.

Ok, but you want subtotal without tax. I will outline my solution but I have not tried this or tested it and it will need through testing to get it right.

1. Inside 'admin/includes/classes/order.php', add a new method/function like getSubTotalwoTax( ) to query the 'orders_product' table which lists all the items in an order. Loop through all the product lines and calculate the sum of fields 'products_quantity' x 'products_price' and return the total amount.

2. In 'admin/super_data_sheet.php' after Line 32, add a new variable, say $subTotalwoTax and call your new function from the $order object as:

$subTotalwoTax = $order->getSubTotalwoTax($oID);

3. Inside 'admin/super_orders.php - Line#773' change $order->totals[$i]['text'] to $subTotalwoTax.

Ok, this is a rough hack, and personally, it would be better to edit the orders.php class and add another array variable to the totals member variable to make it cleaner. In that case, you could simply change the display line from $order->totals[$i]['text'] to say, $order->totals[$i]['subTotalwoTax'], but you get the idea.

Of course you need to document the exact changes you make, because any future upgrade of zen-cart will likely overwrite the orders.php file and your will lose your changes.

---

looks easy when you explain it, but i think i need someone with more php skills that me to help out.

anyone here that wants this challange?? i'll pay $$ for this fix if someone are able to solve this for me.

Quote:

---

Originally Posted by bgroup99

Hi,

I installed Super Orders on my store, but I don't see any of the functionality.

I can go to Admin>Config>Super Orders

But I can't find Admin>Customers>Super Orders

and I see no links to super orders on any of my existing orders.

Does it only work with new orders or did I mess up in the installation process?

Thanks,

Nate

---

Recheck your installation. You seem to have missed a few core files.

Quote:

---

Originally Posted by bgroup99

I can go to Admin>Config>Super Orders

But I can't find Admin>Customers>Super Orders

and I see no links to super orders on any of my existing orders.

---

You ran the SQL file properly, but did not upload the files correctly. Re-read the readme so you know exactly where the files need to go.

Batch_status_update not sending emails...

Well, this is no real solution but yo should know that SO 1.3 batch status update works just fine on Zen-Cart 1.3.6...

So if you need it (the only thing I really need from SO) you might consider down-grading :blush:

Still interested in 2.0 solution though :lookaroun

Cedo

Only one thing has changed in that file between major versions. Open admin/super_batch_status.php. Find this line...

Code:

---

$notify = (int)$_POST['notify'];

---

Change it to read as follows....

Code:

---

$notify = $_POST['notify'];

---

Upload and give it a whirl.

I just downloaded Super Orders 2.0, great features!

But, before I install it, want to make sure if it works with current ZenCart 1.3.6 and Stock by Attributes mod that I am using, doesn't it?

Thanks!

Yes, SO is fully compatible with Zen Cart 1.3.6

Quote:

---

Originally Posted by BlindSide

Yes, SO is fully compatible with Zen Cart 1.3.6

---

Do you know if it works with Stock by Attributes by any chance? Can't wait to give it a try...

Thanks!

What happened to the functionality of adding products on an existing order?
I found this very useful..

Quote:

---

Originally Posted by Svanis

What happened to the functionality of adding products on an existing order?
I found this very useful..

---

fyi, its not included in this latest mod...

Quote:

---

Originally Posted by BlindSide

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:

Code:

---

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.

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

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

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.

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

---

I'm having this problem

Code:

---

1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]

---

and I can't re-install my db from a backup because it's too old :( [I know for next time]. Just wondering how I can solve this problem. I can't see Admin-->Config-->Super orders and my Tax # is not displaying in on my invoices.

Any help would really be appreciated.
Thanks for your patience as this was probably covered, I just don't understand.
Cheers,
Happyworker

I understand this stuff can be tough for a beginner, but did you even read the message you quoted, Happy? Let's try again...

Quote:

---

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

---

You cant properly re-run the SQL file without first resetting your DB to the way it was before running it the first time. It sets up tables and entries that cannot be duplicated.

Commenting out the offending line only solves a fraction of the problem, as you'll undoubtedly have other duplicate lines. Since you don't have a viable backup, you'll now have to go through the SQL file line by line, and compare it to your DB's current state. Remove any duplicate entries it made (e.g. the `configuration` table is not set to prevent dupes), and manually execute each SQL statement that did not go in the first time.

Shame on you for not following all those big backup warnings. :wink2: :cry:

Quote:

---

Originally Posted by Svanis

What happened to the functionality of adding products on an existing order?
I found this very useful..

---

If you used any kind of attributes, it was totally broken with the latest versions of Zen Cart, so I scrapped it. Go back a few pages and you'll see a list of upcoming features. Adding new products is on there.

Quote:

---

Originally Posted by mkm

Do you know if it works with Stock by Attributes by any chance? Can't wait to give it a try...

---

The current version will be fine with that, as far as I know. Super Orders only changes order reporting output, not input. The next version includes adding products and doing returns and exchanges, which definitely will not work with Stocks by Attribute.

Thanks Blindside

Yes I read the text, I didn't understand the "commenting out of the offending line".
How do I comment this out and manually insert the sql that didn't go the first time?
I'm going to go through the configuration table and take out any duplicate.
Thanks again, much appreciated.

Quote:

---

Originally Posted by Happyworker

Thanks Blindside

Yes I read the text, I didn't understand the "commenting out of the offending line".
How do I comment this out and manually insert the sql that didn't go the first time?
I'm going to go through the configuration table and take out any duplicate.
Thanks again, much appreciated.

---

No problem, I'm sorry to see you suffering through. You can comment out a line in SQL by adding a double slash (//) double dash (--) to the beginning of the line. Whole sections can be commented using the /* */ format. In your case, I recommend you keep the file open and just copy and paste the necessary lines into the SQL field in phpMyAdmin. Go one line at a time to avoid further possible damage.

Thanks for the help Blindside,

Okay, everthing seems to be in order now and I see the admin-->config-->super orders.
Excellent

Now, just something has caught my eye....

When I click on the Invoices I notice that under the Tax column it says "None!".

Well I have set all my configurations to show tax and it shows it along the right hand side like normal....it's just underneath that column that it shows "None!"

Thanks again for your help
Cheers,
Happyworker

Nevermind about the last post....figured it out.

Thanks again for your help.

Cheers,
Happyworker

No problem, glad you got it all straight. Enjoy! :smile:

I would like to be able to send an email similar to the new order email after I edit the order. I don't see a way to do this in Super Orders. I don't mind doing coding myself, but I was wondering if someone (who has had more experience with this code) had any advice on where I should be looking. I started last night and found myself copying over a bunch of stuff from the catalog (including the order class as well as several others that it needs) in order to resend the email (although parts of it still aren't working such as the totals and customer info. Any advice would be greatly appreciated.

Hi All and thanks for an excellent cart.
I'll buy ya all a cup of coffe as soon as I get rich off this thing.:wink2: I have a question about installing the superorders mod, AND,... I'm a total newbie to php, mysql, phpadmin, apache, etc,... In short not a total dummass, but lacking in experience and knowledge. I do have a fair IQ though and have figured out apache, ssl, php, mysql, all the needed supporting modules and so forth required for a fully functioning website with cart, some basics of the entire process required and do have a cart working now with full functions and some basic customizations (V1.3.6). Pardon my ignorance though if I get something wrong here, education is the only cure to ignorance so I'm asking for some please.

Basically, I have the database working and backed it up, followed the install process (super_orders_2.0rev45) and got an error "1064...line 1,..." at the start of the import process using the sql patch in the admin. I followed a lot of threads here and got that phpmyadmin would get over this, but it didn't. I took a look at the raw data of the files and the tables and so forth and believe the problem is the table names. All the tables in my database start with zencart_whatever_table, the tables created by the script do not and I think this is the reason. Also one table, "catalog.orders" does not exsist at all even with the zencart_ prefix. Am I right in assuming that editing the .sql script to write the tables as zencart_this_or_that will solve the error ? Or is this an even deeper issue ? I'm using the latest phpmyadmin 2.9.1.1, Apache 2.2.3, mod_ssl 2.2.3, openssl 0.9.8d, php 5.1.6 and MySQL 5.0.20 I have not found any issues with these versions except the strict mode with mysql which I disabled. I'm hoping this isn't too complicated an issue, any input would be greatly appreciated.

Thanks,
Snowblind

Apologies to everyone, I'm having some weird errors trying to get this going.
Is there any reason to think that my versions of the programs installed on my system act differently than what appears to be the expected behavior of the install instructions for super orders? Several tries later and still some odd things.
Parts of SO work, and some don't. Errors when trying out the mod are from columns don't exist to tables don't exist or even double entries. I'm starting to think my cart is not right in some way. I rechecked the install steps and edits several times and have had partial success, partial failures, but not completely one or the other. Is there something about ZC 1.3.6 that requires altering the install process for SO that I've missed ? Maybe it's mySQL version ?

Um,... I can't seem to edit my posts.
I got this error after completely restoring everything, database and (catalog folder);
1064 You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right syntax to use near 'True', 'False'), ')' at line 1
in:
[INSERT INTO zencat_configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array('True', 'False'), ');]
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.

When I got this last time I edited the sql file and it did other errors, so I think it's something about the po module gone wrong. I copied the commands from below the po module ones to a new file "inserts.sql"and ran it through the sql patch tool and didn't get any errors, the database took the edits without error as I can see. Please stop me if i'm gone insane or will this run the SO properly ? I installed the po module from the admin>modules>payment and it seems all is well. should I jump now or hold on to the ledge a while longer?
:blink:
If I made a booboo somewhere I can't see it, but thanks to Blindside for a very cool mod.

Just an update on my issues if anyone is interested.

I ran the install per instructions (SO Rev45) and had a failure when the sql script got to the purchase orders part. I snipped the script below that part and ran it without errors. So maybe it's a unique or blind dummy thing I did that caused the failure. But with so many posts about the 1064 error and so many different reasons I thought I'd toss in my resolution. As I can see it if you have ZC 1.3.6 and MySQL 5.0.20 and PhP 5.1.6 :) then run the SO*.sql script through the sql patch tool and be sure to comment out the part about the purchase order inserts that look like this before running it:

-- Purchase Order payment module configs
INSERT INTO configuration VALUES (NULL, 'Enable Purchase Order ...
INSERT INTO configuration VALUES (NULL, 'Make payable to:', ...
INSERT INTO configuration VALUES (NULL, 'Sort order of display.', ...
INSERT INTO configuration VALUES (NULL, 'Payment Zone', ...
INSERT INTO configuration VALUES (NULL, 'Set Order Status', ...

AFTER doing the file edits (which BTW, most of those values were already in my *php files) then install the P.O. module from admin >modules >payment. This seems to have resolved all the little issues I was having with getting it to work and it now runs very well, Thank you BlindSide, Thank you ZC Team.

(Your Coffee is coming I promise :happy:)

Quote:

---

Originally Posted by mtgDoofy

I would like to be able to send an email similar to the new order email after I edit the order. I don't see a way to do this in Super Orders. I don't mind doing coding myself, but I was wondering if someone (who has had more experience with this code) had any advice on where I should be looking. I started last night and found myself copying over a bunch of stuff from the catalog (including the order class as well as several others that it needs) in order to resend the email (although parts of it still aren't working such as the totals and customer info. Any advice would be greatly appreciated.

---

So you want to resend message previously sent out through your store? I recommend you check out another of my modules: E-mail Archive Search. You need to turn on e-mail archiving for it to work, but then you can use it to resend messages previously sent at the click of a button.

@SnowBlind: I appreciate your letting us know what the problem was. I'll see about removing those SQL statements for the next release.

Blindside

this is some lovely code, real nice to edit/add to!

Thanks for the contribution.

Andy

Glad you like it, Chrome! Wait till you see the code for returns/exchanges. :blink:

Quote:

---

Originally Posted by BlindSide

Glad you like it, Chrome! Wait till you see the code for returns/exchanges. :blink:

---

:)

did you get my email regarding split the order with a quantity and increasing/decreasing price and order quantity?

I'm looking at the SQL file for the Super Orders 2.0, and I notice that all the files are the "base" filenames, whereas my Zen Cart installation uses a PREFIX for my store name, ie; instead of "configuration", I have "storename_configuration", etc.

Will I need to modify this to use it?

Or... should I simply move ALL my data back to the base files instead, and if so, is there an easy way to do this?

Thanks.

Blindside,
Im finaly going to have our site reconfiged by a pro to remove all these damned problems that plauged us this year. Get SO running smooth again and all that good stuff..


But i have a small question that we cant seem to come up with an answer..

Why is it that when an order is split, the shipping is duplicated to the next order? This seems to just make things that much harder to track, becuase you have to go back to the orig order, and pull the shipping bill to figgure out what shipping balance is actualy left on the split order.
any info on this matter is much appriciated.
Thanks
Wicked

I have a quick question. I allow customers to pay using two methods on my site. Credit Card using Skipjack and PayPal.

When I get a new order using either of the methods this is what my order looks like:

Sub-Total: $11.00
USPS Media Mail: $3.57
Tax charged when shipped to Minnesota: $0.72
Total: $15.29
Amount Applied: $0.00
Balance Due: $15.29

Why is the amount applied not automatically filled out when using either of these methods when the payment has already been approved and received?

On the old Super Orders if someone payed with a CC the balance do was automatically set to 0. Am I missing something here?

Hey guys, I'm currently on vacation visiting family, and wanted to drop a quick note regarding 1.3.7. Being part of the support team, I am well aware of the new changes and the fact that they directly affect SO. Just a FYI to head off all the Will this work with 1.3.7? posts and PM's. :wink2:

Since I've been away, I haven't had time to test yet, but from what I understand you should be ok using SO, it simply won't have the new bells and whistles attached to it. Next release will of course rectify this. I will confirm the compatibility once I get home and test things out.

I installed this mod, but when I click on the "Print" button, at the top of the invoice/order that's printed, and in the new window, I get this error:

PHP Fatal error: Call to undefined method super_order::get_admin_notes() in C:\Inetpub\VTStuffTest2\admin\super_data_sheet.php on line 262

I can see both the "super_orders_functions.php", and in it, the "get_admin_notes()" function...

It seems that the program is looking for it in the wrong place. I have the "super_orders_functions.php" in "C:\Inetpub\...\admin\includes\functions\extra_functions", but maybe it should be elsewhere?

I don't seem to get errors anyplace else.

Ideas? Thanks!

Hi All

Happy New Year! :-)

Is SO 2.0 (rev 45) the latest version ? (in the downloads section)

I've been hunting around in this thread for anything later, but so far no go.

Many thanks :-)

Quote:

---

Originally Posted by DogTags

Hi All

Happy New Year! :-)

Is SO 2.0 (rev 45) the latest version ? (in the downloads section)

I've been hunting around in this thread for anything later, but so far no go.

Many thanks :-)

---

95% sure its the latest version.. BlindSide has been talking about a newer version in which you can edit orders, do returns, etc.. but haven't seen any new news about it yet or releases :P

What's listed in the download section is the latest public version. All those new bells and whistles are currently in development.

Quote:

---

I installed this mod, but when I click on the "Print" button, at the top of the invoice/order that's printed, and in the new window, I get this error:

PHP Fatal error: Call to undefined method super_order::get_admin_notes() in C:\Inetpub\VTStuffTest2\admin\super_data_sheet.php on line 262

I can see both the "super_orders_functions.php", and in it, the "get_admin_notes()" function...

It seems that the program is looking for it in the wrong place. I have the "super_orders_functions.php" in "C:\Inetpub\...\admin\includes\functions\extra_fun ctions", but maybe it should be elsewhere?

I don't seem to get errors anyplace else.

---

That section should be commented out, but looking at the file I see that the opening php tag is shorthand ("<?" instead of "<?php") on line 261. Add the "php" to the tag and the problem should go away.

Quote:

---

Originally Posted by wickedclown

But i have a small question that we cant seem to come up with an answer..

Why is it that when an order is split, the shipping is duplicated to the next order? This seems to just make things that much harder to track, becuase you have to go back to the orig order, and pull the shipping bill to figgure out what shipping balance is actualy left on the split order.
any info on this matter is much appriciated.

---

Well the original idea was that, since you're splitting an order, the shipping would be adjusted to reflect two separate orders. So, I put the total on both orders so there's a starting point, then adjust accordingly. It's worked out in my office well, but I can see how that might cause some accounting havoc. I'll take that out, leaving the shipping and all other sub-total figures on the original order.

Quote:

---

Originally Posted by rcrosier

I'm looking at the SQL file for the Super Orders 2.0, and I notice that all the files are the "base" filenames, whereas my Zen Cart installation uses a PREFIX for my store name, ie; instead of "configuration", I have "storename_configuration", etc.

Will I need to modify this to use it?

---

Yes, and if you read the readme you'd know that, along with where to edit the file. :lamo:

Quote:

---

Or... should I simply move ALL my data back to the base files instead, and if so, is there an easy way to do this?

---

If the DB is not sharing space with tables from another system, I think you ought to drop the prefix. The Zen Cart installer allows you to do this, although I'd wait until your next upgrade to do so.