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

[Happyworker]

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

[Happyworker]

Figured it out.

Thanks.

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

Thanks

[harlyman]

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

[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?

Not Found

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

Thanks
Andrew

[BlindSide]

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.

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?

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.

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.

[harlyman]

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

[BlindSide]

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.

[BlindSide]

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

            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:

            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.

[harlyman]

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

            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:

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