Zen Cart Logo
Forums / All Other Contributions/Addons / OLD Super Orders 2.0 (See v3.0 thread instead)

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

Locked

Views: 456,080

Results 1,861 to 1,880 of 2,020
This thread is locked. New replies are disabled.
7 Sep 2010, 1:23 PM
#1861
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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

Deleted

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

7 Sep 2010, 1:39 PM
#1862
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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

Currently Super Orders doesn't support "true" internationalization for payment types. While we've not done a full analysis of what would be needed to implement this, I imagine that to do this would not only require some re-write/modification of the current Super Orders code, but also a good deal of the core Zen Cart code and possibly some of the payment modules code would have to modified as well to fully implement this..

However, (as the readme indicates) it's easy enough to enter new payment types or modify existing payment types in Super Orders from the Zen Cart admin.. However, in doing this you should note that your new payment types will simply be included in the payment types dropdown. They will not be automatically selected when language 2 is selected.

Additionally for credit card payments (Visa MC, AMEX, etc), Super Orders automatically enters a payment record for payments made with credit cards. It does this when the payment type code matches the credit card type code in the default Zen Cart credit card class file. So if you modify the existing payment types for any of the credit cards take care NOT to modify the payment type code. just modify the display name. You won't create errors if you modify the payment type code, it's just that the automatic payment entry simply won't work and you will have to manually enter a payment record for the order (like you must do for orders paid by checks, money order, etc).

orange_juice:

Hallo!

INSERT INTO so_payment_types VALUES (NULL, 1, 'CA', 'Cash');
INSERT INTO so_payment_types VALUES (NULL, 1, 'CK', 'Check');
INSERT INTO so_payment_types VALUES (NULL, 1, 'MO', 'Money Order');
INSERT INTO so_payment_types VALUES (NULL, 1, 'ADJ', 'Adjustment');
INSERT INTO so_payment_types VALUES (NULL, 1, 'CC', 'Credit Card');
INSERT INTO so_payment_types VALUES (NULL, 1, 'MC', 'Master Card');
INSERT INTO so_payment_types VALUES (NULL, 1, 'VISA', 'Visa');
INSERT INTO so_payment_types VALUES (NULL, 1, 'AMEX', 'American Express');
INSERT INTO so_payment_types VALUES (NULL, 1, 'DISC', 'Discover');

> 
> How could I update the database to get it working on an bilingual site? 
> 
> I do not really care about the translation. I just need the drop down  menu to show the same options if language 2 is selected in the admin  area.
> 
> I tried 
> 
> ```
INSERT INTO so_payment_types VALUES (NULL, 2, 'CA', 'Cash');
INSERT INTO so_payment_types VALUES (NULL, 2, 'CK', 'Check');
INSERT INTO so_payment_types VALUES (NULL, 2, 'MO', 'Money Order');
INSERT INTO so_payment_types VALUES (NULL, 2, 'ADJ', 'Adjustment');
INSERT INTO so_payment_types VALUES (NULL, 2, 'CC', 'Credit Card');
INSERT INTO so_payment_types VALUES (NULL, 2, 'MC', 'Master Card');
INSERT INTO so_payment_types VALUES (NULL, 2, 'VISA', 'Visa');
INSERT INTO so_payment_types VALUES (NULL, 2, 'AMEX', 'American Express');
INSERT INTO so_payment_types VALUES (NULL, 2, 'DISC', 'Discover');
```but this failed as duplicate entry in the database.
> 
> Will the operation of super orders be impaired if I enter new codes in  the payment_type_code in order to cater for the translation?
> 
> Otherwise, how could I make it work when I choose my second admin language?
> 
> Kind regards,
> orange_juice

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

7 Sep 2010, 7:02 PM
#1863
orange_juice avatar

orange_juice

Zen Follower

Join Date:
Apr 2009
Location:
Athens, Europe
Posts:
125
Plugin Contributions:
0

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

DivaVocals:

Currently Super Orders doesn't support "true" internationalization for payment types. While we've not done a full analysis of what would be needed to implement this, I imagine that to do this would not only require some re-write/modification of the current Super Orders code, but also a good deal of the core Zen Cart code and possibly some of the payment modules code would have to modified as well to fully implement this..

However, (as the readme indicates) it's easy enough to enter new payment types or modify existing payment types in Super Orders from the Zen Cart admin.. However, in doing this you should note that your new payment types will simply be included in the payment types dropdown. They will not be automatically selected when language 2 is selected.

Additionally for credit card payments (Visa MC, AMEX, etc), Super Orders automatically enters a payment record for payments made with credit cards. It does this when the payment type code matches the credit card type code in the default Zen Cart credit card class file. So if you modify the existing payment types for any of the credit cards take care NOT to modify the payment type code. just modify the display name. You won't create errors if you modify the payment type code, it's just that the automatic payment entry simply won't work and you will have to manually enter a payment record for the order (like you must do for orders paid by checks, money order, etc).

Thank you for your prompt reply.

Actually, what happens is the following:

When I am trying to add a new payment in an order, if the English language is preselected, everything works great.

If I select my language the drop down menu for the payment method -in the popup window- will show nothing. No selections at all.

If I go to admin -> Localization -> payment types, I see the same payment types which are also shown in the relevant drop down menu.

If I try to 'edit' them, although the same payment name and payment code appear to both language entries and this is great news ... hitting the 'update' button without changing anything at all, just hitting the 'update' button the following error appears:

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 'where payment_type_id = '1'' at line 1
in:
[update so_payment_types se where payment_type_id = '1']
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.

I do not need the translation. I need it to work in my language because the mail sent to the client depends on the language it is set to the admin area.

Native clients should receive emails in their language ... and therefore I should make it work in both languages.

I would appreciate your help if this is an issue related to super orders and easy to fix, or I would just like to report it as a bug.

Kind regards,
orange_juice

http://www.dodeca.eu/
Zen Cart is simply Jamming

7 Sep 2010, 7:49 PM
#1864
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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

Again, my answer is the same with regards to the internationalization of Super Orders.. While we haven't done any in depth analysis on what it would take to include this support, it appears that it would require a fairly substantial code change to Super Orders and POSSIBLY some core Zen Cart files to implement this. Especially to make sure that the auto payments functionality for credit payments continues to work as it does now.. We've not done any work in that respect and the upcoming release (currently in testing) does not address this.

As for the SQL error you are reporting.. It's been corrected in the upcoming release and is included in the RC2 code we are testing. It's a harmless/nuisance error since it only occurs if you update a payment code when you haven't made any actual changes.

orange_juice:

Thank you for your prompt reply.

Actually, what happens is the following:

When I am trying to add a new payment in an order, if the English language is preselected, everything works great.

If I select my language the drop down menu for the payment method -in the popup window- will show nothing. No selections at all.

If I go to admin -> Localization -> payment types, I see the same payment types which are also shown in the relevant drop down menu.

If I try to 'edit' them, although the same payment name and payment code appear to both language entries and this is great news ... hitting the 'update' button without changing anything at all, just hitting the 'update' button the following error appears:

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 'where payment_type_id = '1'' at line 1
in:
[update so_payment_types se where payment_type_id = '1']
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.

> 
> Native clients should receive emails in their language ... and therefore I should make it work in both languages. 
> 
> I would appreciate your help if this is an issue related to super orders and easy to fix, or I would just like to report it as a bug.
> 
> Kind regards,
> orange_juice

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

7 Sep 2010, 8:08 PM
#1865
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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

orange_juice:

I do not need the translation. I need it to work in my language because the mail sent to the client depends on the language it is set to the admin area.

Native clients should receive emails in their language ... and therefore I should make it work in both languages.Have you tried copying over the Super Order language files to the language folders for the desired language?? If you don't need the translations in theory this should work..

orange_juice:

I would appreciate your help if this is an issue related to super orders and easy to fix,** or I would just like to report it as a bug.**This is not a bug, it is a feature/functionality that currently does not exist.. (BIG difference as a bug technically implies a function that prevents the module from working at all.. Super Orders works, it just does not fully support internationalization features)

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

7 Sep 2010, 9:00 PM
#1866
orange_juice avatar

orange_juice

Zen Follower

Join Date:
Apr 2009
Location:
Athens, Europe
Posts:
125
Plugin Contributions:
0

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

Thank you for your answers, you are great!

DivaVocals:

Have you tried copying over the Super Order language files to the language folders for the desired language?? If you don't need the translations in theory this should work..

I have done this, it works mostly, only the issue with the types of payment is currently misbehaving.

DivaVocals:

This is not a bug, it is a feature/functionality that currently does not exist.. (BIG difference as a bug technically implies a function that prevents the module from working at all.. Super Orders works, it just does not fully support internationalization features)

OK, I understood about the multilingual support.
I was mostly referring to the mysql message which is already solved in the next release of super orders.

Thank you again, you have been very helpful and kind.

Kind regards,
orange_juice

http://www.dodeca.eu/
Zen Cart is simply Jamming

7 Sep 2010, 10:44 PM
#1867
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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

It will show the payment types twice. Since SO doesn't quite support internationalization this is the result.. It's not elegant, but doable though..

orange_juice:

Thank you for your answers, you are great!

I have done this, it works mostly, only the issue with the types of payment is currently misbehaving.

OK, I understood about the multilingual support.
I was mostly referring to the mysql message which is already solved in the next release of super orders.

Thank you again, you have been very helpful and kind.

Kind regards,
orange_juice

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

8 Sep 2010, 8:02 AM
#1868
orange_juice avatar

orange_juice

Zen Follower

Join Date:
Apr 2009
Location:
Athens, Europe
Posts:
125
Plugin Contributions:
0

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

DivaVocals:

It will show the payment types twice. Since SO doesn't quite support internationalization this is the result.. It's not elegant, but doable though..

:cool:

It is fairly all right!

Kind regards,
orange_juice

http://www.dodeca.eu/
Zen Cart is simply Jamming

13 Sep 2010, 4:36 PM
#1869
stevelucky avatar

stevelucky

New Zenner

Join Date:
Jun 2010
Posts:
44
Plugin Contributions:
0

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

I anybody else having problems deleting orders? Recently, whenever I try to delete an order, I get the button that allows me to confirm the deletion, and when I click that, I get taken to a blank page. When I go back into the admin, the order's still there. Has anyone else had this?

20 Sep 2010, 5:27 PM
#1870
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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

profitshock:

I've found out more and None! is displayed in the invoice by some clever logic that is only useful if your are based in the US.
See http://www.zen-cart.com/forum/showpost.php?p=266046&postcount=150 which is where BlindSide explains it more.

By removing the 00-0000000 number from
Configuration > Super Orders > Federal Tax Exempt Number in admin,
the Invoice now displays 0.00% in the Tax Column in stead of None!.
While it's an improvement it's still incorrect and not relevant to the European marketplace in it's current format.

I can't for the life of me see how it can be configured to use VAT so to all intents and purposes it can be 'hidden' for the time being or partially disabled and used for display only of an EU VAT number.

The other option is to call and display the correct rate from the original order (if it is stored). I say from the order rather than the current rate because the current rate may change. While that's fine if you are posting your invoice today it would be wrong if you tried to reprint for example an old invoice and the tax rate had changed from 15 - 17.5% or 17.5 - 20%.

hths

Kevin
Finally had some time to really look into this.. Believe it or not this is not fully a Super Orders issue, but rather a function of how you configure taxes in Zen Cart.

First: The Configuration > Super Orders > Federal Tax Exempt Number in admin doesn't do any validation of the number entered here. The Super Orders logic simply removes the tax display on invoices and orders when there is ANY value set here. So (except for the language used) this feature is not USA specific per-say. So it should work for ANY country/state which supports tax exemption.

All that said, this configuration setting should have a default value of NULL when Super Orders is installed. In the next Super Orders release I will make sure that NULL is the default setting. I will also update the language definitions for this configuration setting so that it is less "USA-Centric". (ie: change "Federal Tax Exempt Number" to "Tax Exempt Number") This should eliminate a lot of the confusion for all shopowners..

Second: Your taxes are displaying 0% because you do not have your Zen Cart tax setup configured correctly. Super Orders invoice/order display and the Zen Cart default invoice/order display will display EXACTLY the same information if you have removed the Configuration > Super Orders > Federal Tax Exempt Number and correctly setup Zen Cart for calculating taxes for your country/state/zone. See if these FAQ articles help:

I followed the instructions for setting up USA taxes, removed the Federal Tax Exempt Number from the** Configuration > Super Orders > Federal Tax Exempt Number** in admin and the problem you describe above disappears. See if removing Federal Tax Exempt Number, and following the instructions for configuring VAT does the same for you..

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

26 Sep 2010, 3:35 PM
#1871
raygabriel avatar

raygabriel

New Zenner

Join Date:
Apr 2009
Posts:
8
Plugin Contributions:
0

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

Hi!

I installed and uninstalled the current release of Super Orders 2. with ZenCart 1.3.9f.

I ran the two uninstall SQLs, and I even erased and restored my Zencart directory with pre-Super Orders installation.

So it should all be gone - right? However, when I use admin to view orders.php, I get the below message. I can't find where the statement is that calls the wrong ORDERS statement

404 Not Found
The requested URL /MYSHOP/ADMIN/super_orders.php?origin=index&page=1&oID=1113&action=edit does not exist.

How do I get rid of Super Orders 2.0 totally and go back to stock Zencart installation?? Thanks so much.

Ray

26 Sep 2010, 4:58 PM
#1872
jtheed avatar

jtheed

Zen Follower

Join Date:
Apr 2008
Posts:
356
Plugin Contributions:
2

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

RayGabriel:

Hi!

I installed and uninstalled the current release of Super Orders 2. with ZenCart 1.3.9f.

I ran the two uninstall SQLs, and I even erased and restored my Zencart directory with pre-Super Orders installation.

So it should all be gone - right? However, when I use admin to view orders.php, I get the below message. I can't find where the statement is that calls the wrong ORDERS statement

404 Not Found
The requested URL /MYSHOP/ADMIN/super_orders.php?origin=index&page=1&oID=1113&action=edit does not exist.

How do I get rid of Super Orders 2.0 totally and go back to stock Zencart installation?? Thanks so much.

Ray

Did you change the filenames.php in the includes folder? You have to tell it that define('FILENAME_ORDERS', 'super_orders'); is now define('FILENAME_ORDERS', 'orders');

27 Sep 2010, 5:58 PM
#1873
raygabriel avatar

raygabriel

New Zenner

Join Date:
Apr 2009
Posts:
8
Plugin Contributions:
0

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

That did it JT! Thanks so much for your help!

3 Oct 2010, 8:32 PM
#1874
soniccc avatar

soniccc

Zen Follower

Join Date:
May 2010
Location:
Cyberspace
Posts:
387
Plugin Contributions:
0

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

Hello Sir,

I keep getting this SQL error message when I try to install the: super_orders_sql.sql. Do you have any idea about what's causing this?

SQL query:


-- Store Phone and Fax numbers
INSERT INTO zc_soundfactory_nu_configuration
VALUES (

NULL , 'Store Fax', 'STORE_FAX', '', 'Enter the fax number for your store.<br>You can call upon this by using the define <strong>STORE_FAX</strong>.', 1, 4, NOW( ) , NOW( ) , NULL , NULL
);

MySQL said:

#1062 - Duplicate entry 'STORE_FAX' for key 2

Thanks!

Best regards
Jacob

6 Oct 2010, 4:14 PM
#1875
jtheed avatar

jtheed

Zen Follower

Join Date:
Apr 2008
Posts:
356
Plugin Contributions:
2

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

Soniccc:

Hello Sir,

I keep getting this SQL error message when I try to install the: super_orders_sql.sql. Do you have any idea about what's causing this?

SQL query:


-- Store Phone and Fax numbers
INSERT INTO zc_soundfactory_nu_configuration
VALUES (

NULL , 'Store Fax', 'STORE_FAX', '', 'Enter the fax number for your store.<br>You can call upon this by using the define <strong>STORE_FAX</strong>.', 1, 4, NOW( ) , NOW( ) , NULL , NULL
);

MySQL said:

#1062 - Duplicate entry 'STORE_FAX' for key 2

Thanks!

Best regards
Jacob

Possibly you had a mod that created this field. Run the uninstall_super_orders_sql.sql first, then run the super_orders_sql.sql file after and see if the error is gone.

7 Oct 2010, 10:18 PM
#1876
lindasdd avatar

lindasdd

Zen Follower

Join Date:
Jun 2007
Posts:
474
Plugin Contributions:
0

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

I have an order status called Update. Whenever I change the status of an order to Update, the page goes blank. The status change/email seems to work, but it is rather annoying.

I'm assuming there is some conflict with my status name and the function of the mod when "updating" orders. Any ideas other than using a different status name? It worked prior to most recent upgrade.

-lindasdd

7 Oct 2010, 10:23 PM
#1877
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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

lindasdd:

I have an order status called Update. Whenever I change the status of an order to Update, the page goes blank. The status change/email seems to work, but it is rather annoying.

I'm assuming there is some conflict with my status name and the function of the mod when "updating" orders. Any ideas other than using a different status name? It worked prior to most recent upgrade.

-lindasddSounds like your most recent upgrade wiped something out as this is not a known bug.. I have clients who currently use Super Orders and using the "Update" status does not cause the issue you are reporting..

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

7 Oct 2010, 11:43 PM
#1878
lindasdd avatar

lindasdd

Zen Follower

Join Date:
Jun 2007
Posts:
474
Plugin Contributions:
0

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

Question 2: I've been looking for a solution for batch capture of Authorize.net funds. I only just realized that SuperOrders 2.0 has post authorization capture functionality built into it for Authorize.net transactions.

Any chance, you can create a tool which applies this functionality on a batch basis?

For instance, use the current template of "Batch Status Update" so that you can filter by payment type / status. Then all orders selected are sent to Authorize.net to be captured.

Any chance of having the same process work for Paypal?

-lindasdd

8 Oct 2010, 12:00 AM
#1879
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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

lindasdd:

Question 2: I've been looking for a solution for batch capture of Authorize.net funds. I only just realized that SuperOrders 2.0 has post authorization capture functionality built into it for Authorize.net transactions.

Any chance, you can create a tool which applies this functionality on a batch basis?

For instance, use the current template of "Batch Status Update" so that you can filter by payment type / status. Then all orders selected are sent to Authorize.net to be captured.

Any chance of having the same process work for Paypal?

-lindasddIf your question is can something like this be developed, the answer is yes.:smile: I'm sure it's very possible..

If your question is asking whether or not this is in the plans for the upcoming release of Super Orders that me and several others have been working on (currently in beta testing), the answer is no.

That said it's open source... so that doesn't mean that eventually functionality like this won't be included in some future version of Super Orders.. Someone may very well take on adding this very kind of functionality to Super Orders.. However the work currently being done on Super Orders will not be including any such functionality..

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

9 Oct 2010, 7:27 PM
#1880
nohart avatar

nohart

Zen Follower

Join Date:
Apr 2010
Posts:
133
Plugin Contributions:
0

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

Hello,

I apologize if I may not be posting this question in the correct forum area...

I am using Super Orders and I am up to date with Zen Cart v1.3.9g. I found that I only had to do about 1 line of merging to order.php using WinMerge to get all functions back to normal.

The problem I have now is that I am also using Authorize.net to process my orders. I cant seem to find a way to get that to interface with USPS for shipping labels. I saw that in Super Orders I can print a generic Label but no way to print a paid for shipping label as my PayPal Express module does with USPS.

So I thought I would add the add-on "USPS.com Click-n-Ship AutoFill Button" Because this is the only interface I can seem to find that would allow for printing a postage paid shipping label with USPS using Authorize.net.

The problem I have is that the file provided in "USPS.com Click-n-Ship AutoFill Button" has a heavily modified super_orders.php file that is about 2 years old and I am not good enough at Winmerge to know what I am doing to make the files current. Does anyone have any suggestions?