Thanks!Quote:
Originally Posted by JTheed
Printable View
Thanks!Quote:
Originally Posted by JTheed
I hope this is the right place to post this, if not can someone point me in the right direction.
I am using zen cart 1.3.9d, just upgraded. When i get a order with paypal or AIM, the orders are completed however the item is not listed on the order info page i can see the customers name, address price of item ect... but not what the customer ordered. What i have notice is the order_products table is not being populated with the order_id, item information.
Please see attached screenshot for eample of what is happen. This is happen with all payment methods.
I've been using this mod for over a year now and have a small niggle that maybe you can help with. When I tick the 'notify customer' box it does waht it's supposed to, appends the updated info to the admin area and sends an email to the customer. However, insead of a tick in the notified customer column, it uses the red cross as though the customer hasn't been notified.
How do I make the green tick appear under customer notified column when they have in fact been notified?
It's always done this. I thought for about a year that the notify customer 'function' hadn't been installed correctly and so I always used the standard 'orders' area to notify. Now that I've upgraded to a PHP 5.3 server, the standard 'orders' has stopped working and so I resorted to testing super orders. It does actually notify, just doesn't use a grren tick.
EDIT: NEVER MIND< FOUND SOLUTION HERE: http://www.zen-cart.com/forum/showpo...&postcount=971
This thread is so long that it makes it very difficult to find the answer I am looking for and doing a search is not easy either so I thought it would be best to post.
Is it possible when doing a Batch Status Update to attach a different comment to each individual order that you are changing or must it all be the same comment for each order?
Doing it individually kind of defeats the purpose of doing it in batch, doesn't it? :PQuote:
Originally Posted by swilliams88
Seriously, though, I do get what you're saying, but that's not how the Batch system works.
Don't know what version of SO you are using (sounds like you are using an older version), but all of the issues related to status/comments notification was corrected as of Version: 2.0 (Rev 48a) of Super Orders. It was tested ad nauseum, and it works.
In the upcoming Super Orders release the comments/status management will incorporate the newest comments/status management features in the latest Zen Cart release for the default orders.php (specifically the hidden "admin only" comments) It was tested ad nauseum as well..
Quote:
Originally Posted by limelites
If the order items also do not appear when looking at the order from the default orders.php file, then you have a serious issue with your Zen Cart, and you will need to post a new support thread to get help with whatever issue you may have..Quote:
Originally Posted by lextechs
If the order appears normally when viewing it from the default orders.php file, then the issue is most likely due to an issue with your Super Order files.
If you've made modifications to the module files, those modifications are the source of your issue. If you have not modified the module files, then you should download a fresh copy of the Super Orders module, and re-install from scratch.
I can not see the details in orders.php any idea where i can post this so i can get help?
Quote:
Originally Posted by DivaVocals
Ok the answer to this is probably hidden in here some place but.... So I'm dying to use this mod can someone tell me their experience with version 1.3.9.D? I currently have 1.3.9.B but want to update but have never installed this mod. Anyone using with the later versions? I know it sometimes seems like things don't work because we discuss problems here but some of you must be happy with it or you wouldn't be using it. So anyone?:lookaroun
Current version was updated to be 1.3.9 and PHP 5.3 compatible.. So there shouldn't be any issues..Quote:
Originally Posted by Paul69
Not sure.. I think there are some "generic" sections for general setup questions..Quote:
Originally Posted by lextechs
Hope you get it all straightened out..
I have been searching this thread but I am having trouble finding the answer. When I do a batch print it prints multiple invoices on one page. Is it possible to tell it to print only one invoice per page?
the purpose of the batch report is to print multiple invoices for orders matching your selection criteria.. if you only want to print one order, you would open the invoice from the order you wish to view/print..
Posted via Mobile DeviceQuote:
Originally Posted by amyleew
I too am having this issue. I think you misunderstood the question, unless I am missing the problem.Quote:
Originally Posted by DivaVocals
When you run the batch command, the results are printed on one page. It's not that the admin wants to print one invoice, it's that SO outputs multiple invoices on one page.
thats the way it's designed to work.. what you want will require a modification to execute.. (ie# customization to SO)Posted via Mobile DeviceQuote:
Originally Posted by engine411
To print the invoices onto individual pages choose print command from file drop down menu then choose to print each frame individually from the options given at print (Firefox doesn't do it as default, but IE does)
G'day!
Question possibly answered already, but my search terms failed to find the answer ....
Is it possible to have a customer's outstanding amount owing transferred as an item to a new order?
Example:
Invoice 1
Customer orders $100 worth of gear.
Customer pays $75.
Customer still owes $25.
Invoice 2
Same customer orders another $40 worth of gear.
I want the invoice presented to the customer (and even the checkout process) to show that there is still an amount of $25 to be carried forward and that the amount will be included in the second invoice.
So, Invoice 2 would read something like:
Gear purchased: $40
Amount carried forward (Invoice 1): $25
Total: $65.
Any thoughts? Am I even asking the right questions? Am I even asking the questions in the right forum?!?
Cheers,
Bryson.
p.s. Great mod, by the way! Greatly appreciated.
Not how Super Orders works out the box. Yes it is possible, but what you are asking for would require customizations to the Super Orders code..
Quote:
Originally Posted by Bryson
I'm having an issue in Firefox where my date range has disappeared. I can't select a date range, and normally I could do a query without selecting any dates and it would pull up everything, but now it pulls up nothing. It works fine in Safari however (I'm on a Mac). It worked yesterday, but no more. Has anyone else had this problem?
Nevermind, a Firefox restart cured the problem.Quote:
Originally Posted by stevelucky
Hi!
I'm using ZenCart v.1.3.9d.
I downloaded newest version of Super Orders:
http://www.zen-cart.com/index.php?ma...roducts_id=257
I did step by step instalation.
Unfortunetly when i try to enter Super Orders it sends me back to login site.
Can anybody tell what's the problem??
I really need that addon or similar.
My server is using php 5.2.13 maybe that the thing?
Thanks for help!
Hi everybody.
I'm just installing SO in a new site. I'm customising the invoice and want to insert my own banner. I've done it before but I can't for the life of me remember where I go. Can anybody help please?
Regards
Philip
Based on the information provide it is difficult to say what the problem might be.. My guess would be an incomplete/incorrect install.. I suggest going over your install and perhaps re-installing the module again..
Quote:
Originally Posted by malachi
That wasn't very clear. What I mean is can someone remind me where the logo file goes (is it say admin>>images) and what file I need to tweek to change what is displayed ie superinvoice.phpQuote:
Originally Posted by philip56
Many thanks
Take a look at HEADER_LOGO_IMAGE in admin/includes/languages/english/super_invoice.php
Many thanks for that.Quote:
Originally Posted by carlvt88
Hi wondered if someone could give us a hand in super orders when i click on the invoice buttin the invoice pops up lovely but shows ex and inc vat prices twices is there way for them only to show once it also shows the inc vat prices as ex vat hope someone could help many thanks in advance
I've looked through this thread but haven't found a solution to my issue. Is there a way to make US States show up as the 2 letter abbreviated state code on packing slips, invoices, and shipping labels? In fact, I'd settle for just having it abbreviated on shipping labels as that's the most important.
Not truly a Super Orders "issue".. The default Zen Cart invoice and purchase orders work exactly the same way.. See if these threads help:Quote:
Originally Posted by stevelucky
http://www.zen-cart.com/forum/showthread.php?t=64335
http://www.zen-cart.com/forum/showthread.php?t=57057
I tried the code on http://www.zen-cart.com/forum/showthread.php?t=57057 and it just killed my site.Quote:
Originally Posted by DivaVocals
DivaVocals,Quote:
Originally Posted by DivaVocals
This was a really minor edit but if you're still interested.
- Open edit_orders.php.
- Search for
around line 659 or so.PHP Code:zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')))
- Modify this so that it reads:
.PHP Code:zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')). "action=edit")
- Save your file.
This should now take you back to the super_order.php file (if you altered the filenames.php file as instructed in super_orders readme file). Specifically to the screen you previously were on. Hope this helps.
Thanks for this.. Dunno if you know, but I found and posted the fix a coupla pages back..:smile: (http://www.zen-cart.com/forum/showth...44668&page=179) I also posted it in the Edit Order support thread..
Quote:
Originally Posted by retched
Hello
Has anyone experienced the following or seen posts on the subject please
I have installed Super Orders 1.3.9
I am running a copy of my web site on xammp to try an locate the issue (error occurs on both live and test sites)
MySQL 5.1.33
PHP Version: 5.2.9
The data is correct with the sole exception of the PRINTER version of the invoice tax column that reportsIt shows the correct tax data elsewhereQuote:
None!
See the attachement screen shot
You will understand that it doesnt create a good impression for the customer
I had a similar problem with rev47 - everything worked fine except for this print error
I have spent the past day trying to find something but no one else seems to have had this problem
Any guidance thoughts gratefully recieved
Thank you
Centec2b
Ahh ok. I was still going off the linked thread that the write posted in his helpme file. No worries.Quote:
Originally Posted by DivaVocals
No worries at all.. It is still good information no matter how many times it's posted!!:smile:Quote:
Originally Posted by retched
Hi everyone got a bit of a problem its been doing my head in for days, any help would be very much appreciated
on the super orders invoice the line description shows a inc vat price and and a ex vat price. however both prices show the ex vat price
How would one correct this so it shows a ex and inc price ??
all the subtotals correct,
Thank you in advance
Russ
I am experiencing the same issues as Centec2b.
Zen Cart version is 1.3.9e
PHP Version: 5.2.x
SO version: 2 - 139
Searching through the posts this issue was bought up with ZC 1.3.8 and due to the amount of activity probably got over looked.
Where 'None!' appears, based on what I see in the ZenCart invoice.php file I would expect to see the tax rate.
As far as I can work out the code affecting this is in super_invoice.php
Lines 239 - 245
The corresponding code (as far as I can tell) in invoice.php isCode:if ($display_tax) {
echo zen_display_tax_value($order->products[$i]['tax']) . '%';
}
else {
echo ENTRY_NO_TAX;
}
echo '</td>' . "\n" ;
The only thing I can think of is that the if($display_tax) in SO is not finding or reading the tax code but I wouldn't know where to fix it.Code:echo ' <td class="dataTableContent" align="right" valign="top">' . zen_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" .
Given that the original invoice.php file uses other ZC functions to determine the tax rate etc I have to wonder why the 'if' statement exists at all. Is there a reason specific to SO ??
In my case the pricing of the tax calculation works fine so it is just a display issue in the product lines.
Quote:
Originally Posted by Centec2b
Hi,
Having a problem with the update order when I add a new order status.
Instead of loading the order page witha note added to the message stack it is displaying a blank page.
A typical url of the problem would be:
https://mywebsite.co.uk/admin/super_...n=update_order
I have looked into the code (but not touched anything) and the action for update order at the moment seems to look like this (starting line 100 (approx) of admin/super_orders.php)
Is this correct or am I missing something? If its all correct then what can I do to fix the bug?PHP Code:case 'update_order':
$status = zen_db_scrub_in($_POST['status'], true);
$comments = zen_db_scrub_in($_POST['comments']);
$check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
date_purchased from " . TABLE_ORDERS . "
where orders_id = '" . (int)$oID . "'");
if ( ($check_status->fields['orders_status'] != $status) || zen_not_null($comments)) {
$db->Execute("update " . TABLE_ORDERS . "
set orders_status = '" . zen_db_input($status) . "', last_modified = date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR)
where orders_id = '" . (int)$oID . "'");
$customer_notified = '0';
if (isset($_POST['notify']) && ($_POST['notify'] == 'on')) {
$customer_notified = '1';
}
update_status($oID, $status, $customer_notified, $comments);
if ($customer_notified == '1') {
email_latest_status($oID);
}
if ($status == DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE) {
// adjust download_maxdays based on current date
$zc_max_days = date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;
$update_downloads_query = "update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays='" . $zc_max_days . "', download_count='" . DOWNLOAD_MAX_COUNT . "' where orders_id='" . (int)$oID . "'";
$db->Execute($update_downloads_query);
}
$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
}
else {
$messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
}
zen_redirect(zen_href_link(FILENAME_SUPER_ORDERS, zen_get_all_get_params(array('action')) . 'action=edit', 'NONSSL'));
break;
case 'deleteconfirm':
zen_remove_order($oID, $_POST['restock']);
$so->delete_all_data();
zen_redirect(zen_href_link(FILENAME_SUPER_ORDERS, zen_get_all_get_params(array('oID', 'action')), 'NONSSL'));
break;
Thanks
On checking I also get the same non page display issue as totalsam.
In my case the page link the browser is redirected to follows this format:
www.example.com/admin/super_orders.php?securityToken=[random numbers and letters]&page=2&oID=2&action=update_order
but nothing is visible in the browser.
After altering the browser url to /admin, when I recheck the status history for the order, the new notes I applied do appear and the status has been updated. This shows the data is being stored so I guess it is an issue with the redirect.
hth
Sorry I forgot to say it does update the status it just doesn't load the page correctly
In my last post I suggested in might be to do with a redirect and in trying to nail this down further so anyone with the skills/time can hopefully suggest a fix I remembered that ZC would kindly generated a myDEBUG-adm-xxx.log in the /cache folder for us :)
In my case the error message reads:
I guess this means it's not because the redirect is wrong, it's just not completing hence no page being displayed.Code:PHP Fatal error: Call to undefined function date_diff() in /home/path/to/domain.com/public_html/admin/super_orders.php on line 123
These are the lines of code from 121 - 128 which should give some context to the error.
(line 123 begins with $zc_max_days = date_diff )
The note on ln 122 suggests something has been tweaked and I have no idea what date_diff is or does or even why it isn't defined.Code:if ($status == DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE) {
// adjust download_maxdays based on current date
$zc_max_days = date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;
$update_downloads_query = "update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays='" . $zc_max_days . "', download_count='" . DOWNLOAD_MAX_COUNT . "' where orders_id='" . (int)$oID . "'";
$db->Execute($update_downloads_query);
}
$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
Any ideas on what will break if I comment out line 123 ?
or is it simpler to define date_diff?
hth
Quote:
Originally Posted by totalsam
Hate to be a pain but my system seems to have corrected itself :s if I find out more I will post
The fix For non displaying page after altering order status.
open super_orders.php
on line 123 (or thereabouts) find
and replace withCode:$zc_max_days = date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;
The difference is that date_diff is now zen_date_diffCode:$zc_max_days = zen_date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;
For those interested in how I worked it out in case you want to try debugging minor errors, I used the developers tool kit and searched for 'date_diff'.
There wasn't a 'date_diff' but there were a few zen_date_diff references.
I put two and two together and voila :)
hths
Kevin
Clever.
I have added the fix even though it appears to be working now. Hopefully it will prevent future issues!
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/showpo...&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
Quote:
Originally Posted by profitshock
I have installed the files for SOv2 and for whatever reason I can not access any of the modules for it in the admin section. I can only access the configuration for it... any ideas?
I have had this thing working before on my last test server. I guess thats what I get for trying to start all over from the ground up!?:censored:
NEVERMIND... :oops: I figured out the problem and boy do I feel stupid!
If anyone else has this problem ask yourself if you have renamed your "admin" folder. The file structure from the download still has the admin folder named "admin"... be sure you change it to whatever you renamed your admin folder to before you upload the Super Order files. No wonder it wouldn't work.
All is great now. :clap:
HI,
Has anyone tried to incorporate printing with specific document format e.g. EMS, custom declaration form, etc into Super Orders ? Or how can I change the printing position of the current printing ?
Thanks
KK
At long last I've got everyone's code compiled into our RC1 version..:clap: We're testing it now, and hopefully we'll be able to submit this soon.. Stay tuned!!!
Highlights include:
General updates
- Incorporate commenting updates from the default Zen Cart orders.php (most notably the hidden "admin only" comments functionality)
- Correct errors with downloads flags not setting correctly
Edit Orders
(http://www.zencartmod.com/index.php?...&products_id=3)
- Install package includes the modified files needed for those who use Edit Orders. (you must install Edit Orders BEFORE using these files)
- We've made a few improvement to the Edit Order files as follows:
- Incorporate commenting updates from the default Zen Cart orders.php (most notably the hidden "admin only" comments functionality)
- There is now one button to take you back to to the Super Orders order details page for the order you are adding products to and another new button to take you back to the Edit Order page for the order you are adding products to.. (Currently in Edit Orders the "Add Products" section only has a "Back" button that returns you to the order details page for the order you are adding products to..)
Reporting & Order Update Improvements
- Improved orders awaiting payment report
- PDF printing options included in batch printing
- Additional search options for Batch printing/update functions
Super Orders Payments Improvements
- For orders paid with PayPal the store owner is no longer required to manually enter a payment in Super Orders. Super Orders will now automatically enter a payment record and show these orders as paid without requiring the store owner to enter a manually enter a payment record.1
Split Orders Improvements
- Splitting an order now results in a “parent order” (original order number) and a child order (new order number). The resulting parent and child orders cannot be split.
- Super Orders now correctly re-calculates BOTH the parent and the child order when an order is split. (The original shipping charges stay with the parent order)
- If an order is paid in full, the split order function will distribute the payment correctly across both the parent and child orders so that you end up with two fully paid orders which true up to the amount of the original order amount.
- The original payment information is displayed on both the parent and child orders. This display shows the original grand total paid. ($ Parent + $ Child = Grand Total)
- For split orders paid via PayPal the “empty” PayPal payment notification data panel will no longer be displayed on child orders.
- The split order packing list button now appears ONLY when the order is either a parent order or the resulting child order -- otherwise it will NOT display.. (Currently it displays on EVERY order when the order includes multiple items)
- The split packing list details has been fixed to function as it was originally intended (but did not).
- The packing list for the parent order displays the FULL original order with the items that were moved to the child order flagged as "Product(s) will ship separately"
- The packing list for the child order displays the FULL original order with the items that remained on the parent order flagged as "Product(s) will ship separately"
About PayPal Payments:
1 There are a number of threads on the Super Orders support thread which discuss a number of methods for automating PayPal payments. Some of these methods include automating refunds as well. We chose not to implement any of these solutions or variations of them in order to maintain a level of consistency when it came to the module’s basic "out the box" functionality. This keeps the application functional across a wide variety of stores. While other payment methods (notably the Offline Credit Card Processing and Authorize.net modules) did not require the entry of a payment record, payments received through the PayPal payment module required shop owners to manually enter a payment record in Super Orders. (hence the reason for this change)
Furthermore, Super Orders does not include automated refunds processing for any other payment module (such as Authorize.net). Including automated refunds processing for ONLY the PayPal payment module while ignoring other payment modules would be building in a level of inconsistent functionality for a module that will be used by MANY different store owners each with different needs. Therefore the application's consistency was the guide in how this function was implemented.
That said, I fully recognize that there are shop owners who may want this specific functionality (automated refunds processing) for their particular store. There are lots of threads which cover how to add automated refunds for PayPal paid orders, and owners requiring this functionality should seek out those posts and see if they can adapt the suggested code for their needs. (I cannot offer any assistance in this regard)
Hallo,
(Thanx for the above posting, sounds great!)
When I update an order and click on the update button to send the email to the customer, I receive the following warning:
Line 123 reads:Code:date_diff() expects parameter 1 to be DateTime, string given in [mydomain]/admin/super_orders.php on line 123
I would appreciate your help.Code:$zc_max_days = date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;
Kind regards,
orange_juice
@ orange_juice see http://www.zen-cart.com/forum/showpo...postcount=1844 for answer
Thanx! :clap:Quote:
Originally Posted by profitshock
I didn't search thoroughly ... did I? :no: :blush:
Kind regards,
orange_juice
Hi everybody!
I have problem with Super Orders module:
http://www.zen-cart.com/forum/showthread.php?t=162842
Can somebody help me, please?
The order editing features in Super Orders was never fully flushed out/developed. The upcoming Super Order release has deprecated all of the order editing functionality. We are recommending instead for Super Order users that they use the Edit Orders module for order editing functionality. The upcoming Super Orders release will also provide the necessary edited files needed for Edit Orders and Super Orders to work together..Quote:
Originally Posted by malachi
In the meantime if you want to use Edit Orders and would like to use it with Super Orders, instructions for how to make these edits yourself have been posted in both the Edit Orders and Super Orders support threads. (the edits required are SUPER EASY to make yourself -- we are only including them in the new Super Orders release just to make it convenient for users) Search for "Edit Order, DivaVocals" and you will find my posts on this subject in both threads.
The Edit Orders support thread has the link where to get Edit Orders (the latest version is available on the authors website - the version in the downloads section is outdated)
I am working on a new site that plans to launch in a few days, but am having a blank page issue that I could not find a fix for. I have tried a few test transactions and they go through fine. The blank page is when you try to view the invoice. Either through the link sent to the customer or by going to "my account" and clicking on "view" by the order. I have ran the debug mod and it came back with this error...
[30-Aug-2010 07:24:33] PHP Fatal error: Cannot redeclare class order in *****/public_html/includes/classes/order.php on line 1028
I really do not know where to go from here. When I look at that file on line 1028 is the "}" at the very end of the file.
Version: 2.0 (Rev 48a)
Zen Cart Version: v1.3.8
I will try Edit Orders.Quote:
Originally Posted by DivaVocals
Thanks very much for explanation!
FYI, I believe the Super Orders readme also kinda covers this as well..Quote:
Originally Posted by malachi
Super Orders installed on a vanilla store works right out the box. Which leads me to believe that other modules you've installed which modify this file are the cause of your issue..
Quote:
Originally Posted by atl2rva
Hallo!
This works great for an one-language site.Code: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
but this failed as duplicate entry in the database.Code: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');
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
**Deleted**
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).
Quote:
Originally Posted by orange_juice
Thank you for your prompt reply.Quote:
Originally Posted by DivaVocals
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:
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.Code: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
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.
Quote:
Originally Posted by orange_juice
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..Quote:
Originally Posted by orange_juice
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)Quote:
Originally Posted by 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.Quote:
Originally Posted by DivaVocals
OK, I understood about the multilingual support.Quote:
Originally Posted by DivaVocals
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
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..
Quote:
Originally Posted by orange_juice
:cool:Quote:
Originally Posted by DivaVocals
It is fairly all right!
Kind regards,
orange_juice
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?
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.Quote:
Originally Posted by profitshock
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:
- My taxes aren't calculating properly. What should I check?: https://www.zen-cart.com/tutorials/i...hp?article=155
- How do I configure the taxes? (US state sales tax - single rate): https://www.zen-cart.com/tutorials/index.php?article=76
- How do I set up VAT?: https://www.zen-cart.com/tutorials/index.php?article=77
- How do I set a default Tax Class for new-products?: https://www.zen-cart.com/tutorials/index.php?article=78
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..
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');Quote:
Originally Posted by RayGabriel
That did it JT! Thanks so much for your help!
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.Quote:
Originally Posted by Soniccc
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
Sounds 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..Quote:
Originally Posted by 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?
-lindasdd
If your question is can something like this be developed, the answer is yes.:smile: I'm sure it's very possible..Quote:
Originally Posted by lindasdd
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..
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?
http://mydomain.com/shop/admin/super...28&action=edit page is blank when i click to edit a page in super orders in the customer /super admin/ and i select an order to edit it send me to blank page...... running zencart 1.3.9f installed super orders 2.0 1.3.9
Sounds like an incomplete/incorrect install.. Suggest going over all of your installation steps again..Quote:
Originally Posted by ripvoid
I am unable to do a partial refund with PayPal Express using the Super Orders screen. I didn't have access to the regular order screen that this one replaced so I uploaded the file includes\filenames.php. This allowed access to the original Orders screen screen and I was able to accomplish the partial refund.
Does anyone know what the issue may be? I thought that Super Orders basically accessed the original file that it replaced and just added more functions? I set the Log files to on in the PayPal Express payment module and have the IPN records if anyone wants to look at them. I think there is about 18 of them.
I am running v1.3.9g
One thing I did notice on the Super Orders Screen was that it says No Payment Data Available.
Here is one of the IPN Logs:
IPN ERROR :: No pending Website Payments Standard session data available.
Might be a duplicate transaction already entered via PDT.
Thanks for helping
Ok what I did was installed stamps.com This takes care of the shipping label issues.Quote:
Originally Posted by nohart
But I really think I am going to have to uninstall Super Orders because it has a few bugs one which I recently found out was that it doesn't do refunds or partial refunds. I really wish that someone with the knowledge to update this module would come along because it has great potential but in the state it is in now I think I am just asking for problems leaving it installed.
There's a BIG difference between a bug and a feature request.. Bugs imply features not working as they should.. It's been no secret that Super Orders doesn't support PayPal refunds.. That's not a bug.. It's a missing feature.. If you search through this thread you will see that others have tackled this and shared their code with the community..Quote:
Originally Posted by nohart
Let me correct this.. I'm not sure if you are referring to the PayPal payment module functions or the Super Orders payment and refunds entry.. If you are referring to the latter, then no currently Super Orders does not auto create a refund entry when you process a refund through PayPal.. If you are referring to the PayPal payment module, Super Orders uses the same PayPal functions as in the default orders..Quote:
Originally Posted by DivaVocals
and as a final follow-up, this is the code which brings the PayPal payment nofication data into orders.phpQuote:
Originally Posted by DivaVocals
This same code is also present in super_orders.php..Code:<?php
if (method_exists($module, 'admin_notification')) {
?>
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<?php echo $module->admin_notification($oID); ?>
</tr>
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<?php
}
?>
Ok thank you for your response. I have read most of this entire thread and I have noticed that many folks have a problem with Super Orders issuing complete or partial refunds. I thought that Super Orders did everything and then some as the original orders file did? As I stated for what ever reason I was not able to get the partial refund accomplished using Super Orders. I have a log file if you would like to see it. After I made the original Orders.php file accessible again I was able to accomplish the partial refund.
I am not aware of any fix for this problem. If there is a fix why doesn't someone update the Add on?
Also on page:
http://www.zen-cart.com/forum/showth...led#post587167 post #21
DrByte says:
"...There's nothing wrong with keeping Super Orders installed. But if you want the refund capability for Authorize.net orders (or PayPal or Linkpoint either) you'll need to just be sure to use the original /admin/orders.php page instead of the super orders page for doing that..."
Thanks for your help
I've looked over this whole support thread, and there seems to be a general mis-understanding of what Super Orders can and cannot do and where it ACTUALLY differs from the default orders.php.. Also so it's clear, the rest of my post is regarding the ability to process payment processor refunds from the admin using Super Orders (Authorize.net and PayPal)..Quote:
Originally Posted by nohart
Super Orders does do EVERYTHING the default orders does and then some.. It retains ALL of the original order functionality and adds in some new features such as:
- Super Payments - Allows store owners to record a payment, refund, or purchase order receipt for their orders. For payments paid by credit card these payment entries a made automatically. In the upcoming release payments made via PayPal will also auto generate a payment record.
- Admin comments editing - Allows store owners to edit admin comments
- Batch Status update - Update order status for a group of orders
- Batch Order Print - Print packing slips or invoices for a group of orders
Much of the default orders code remains in place and Super Orders features are added on TOP of those features..
Super Orders DOES NOT alter any of the core Zen Cart code code which affects ANY of the default Zen Cart payment modules. So how PayPal works with orders.php is EXACTLY how it works with Super Orders.. While some the default orders code was improved/modified, functions like comments and the display of the payment module's admin notifications panel was not altered from the original at all.Quote:
Originally Posted by nohart
Super Orders uses the SAME PayPal notification functions as the default Zen Cart Orders. (See the code snip I posted above..) That code is NOT modified by Super Orders in any way.. So to answer your question it's not been "fixed" because it's not broken..
That said, the only way for it to be broken is if that specific part of the super_orders.php code has been removed or modified..
I just double checked the version of Super Orders that's available in the downloads section and on lines 676-692 is this:
This is the code which calls the payment module's notification section. It is IDENTICAL to the code in orders.php. This is where you are able to generate refunds for PayPal or Authorize.net. Admin processing of refunds, and authorizations directly to a payment processor is NOT Super Orders code, but default Zen Cart code..Code:<?php
}
if (method_exists($module, 'admin_notification')) {
?>
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<?php echo $module->admin_notification($oID); ?>
</tr>
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<?php
}
?>
Now if what you are saying is that this notification section of the default orders DOES NOT look identical to the one in Super Orders then you should post some screenshots so that we can see what you see.. That's the only way to get to the bottom of your specific issue. I have this installed on enough stores to know that there is no difference between orders and Super Orders in this regard..
I JUST tested this again on a client's store tonight.. I processed four test transactions. Two paid by PayPal and two paid by credit card.. I processed both the Authorize.net and PayPal refunds using both Super Orders and the default orders with NO issues whatsoever.. Clearly you are having a different result.. post some screenshots so we can see what you see..
This is not accurate. Zen Cart's built in functions for processing Authorize.net and PayPal refunds from the admin works THE EXACT same in Super Orders as it does in the default orders.php..Quote:
Originally Posted by nohart
With regards to this particular post/thread: When Zen Cart 1.3.8 was released, the ability to process PayPal refunds from the Zen Cart admin was inadvertently removed, and there were quite a few threads on the forum with fixes and workarounds to make the PayPal refunds re-appear in the payment notifications panel in orders.php... (Help, how do you capture funds from within ZC 1.3.8? (PayPal Express))
Super Orders would have been affected the SAME way since it makes the same calls to the SAME admin payment notification functions.. DrByte may not have been aware of this..
If you'd like to confirm this do a search using the developer's tools and search for "admin_notification" to see which files contain this string. In addition to orders.php, super_orders.php the following payment modules will also show:
- Authorize.net
- Linkpoint
- PayPal
- Nochex
It should be noted that the admin refunds options for Authorize.net transactions also changed in the 1.3.8 release. Again, Super Orders would have been affected the SAME way by this change. These threads cover how to modify Authorize.net so that refund options are available from the admin:
Refunds and Authorize.net
Odd problem with orders and authorize.net
how do I refund an Authorize.net purchase?
Refunds and Authorize.net
Again in order to troubleshoot your issue screeshots would help us see what you see.. and to be clear you should post both orders.php and super_orders.php screenshots to compare the two. Also please check your super_orders.php file.. Is the admin notification code I previously referenced intact?? if yours is different, need to see what your code looks like..
Hey Diva!
I'm here with another issue...
I've been trying to test out a few orders on my site.
When you first enter admin you can see your site activity.
You can also see a summary of New Orders. When I try to click on an order I get this message in a blank screen:
1146 Table 'C260935_shop.so_payment_types' doesn't exist
in:
[select * from so_payment_types where language_id = '1' order by payment_type_full asc]
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.
??? Any ideas ???
Don't left the SQL query scare you.. The error message means EXACTLY what it says.. your payment types table does not exist.. Now that kinda smacks of an incomplete Super Orders install.. How did you run the SQL file from the Super Orders install files?? or better yet.. DID you run the Super Orders install SQL file??:smile:
Quote:
Originally Posted by joyjoy
I think I did the SQL file...the rest of the admin setup for Super Orders seems to be working okay.
I will BACKUP and try to reinstall the SQL file. Maybe I left something out. Thank you.
Okay I just tried to reinstall the SQL files, I received error messages because they already exist.
Any other suggestions?
Hold up Diva!!Quote:
Originally Posted by joyjoy
Nevermind. I just tried to review my admin overview again...and now the order links work!
Must've been some sort of missed code.
Thanks again though for pointing me in the right direction. You are awesome!!
Can someone help? Using super orders batch print I am selecting the invoices I want to print but in IE8 and Firefox the invoices page is blank. View source shows they are there. Tried with google chrome and I can see the invoices I want to print but they all print on one page. It did work in IE when I first installed it. Went from http to https for the whole admin area and everything else worked fine. I tried putting it back to http to see if that was the problem and it is still the same so I think this change is just a coincidence. Also reinstalled super orders. Tried the above suggestion in IE even though the page is blank but the "print each frame individually" is already selected and the other options are greyed out. The blank page prints - blank in IE, all invoices on the same page in Chrome ! Help! Thanks. CliffQuote:
Originally Posted by topcat24
Me again - bit of duff info in my cry for help!
Page source in IE is only:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://www.w3.org/TR/html4/frameset.dtd">
<html>
<head>
<title>Output Batch Print Job(super_invoice.php :: 2 pages :: 1 copies)</title>
</head>
<frameset rows="*,*">
<frame src="super_invoice.php?oID=44363">
<frame src="super_invoice.php?oID=44364">
</frameset>
</html>
In chrome the full invoices are visible but all print on 1 page and I can't find setting to print frames individually in chrome.
Cliff
Wow thanks for the info! In your tests did you try to do partial refunds and complete refunds? I attached a screen shot of the Super Orders Screen. It says on it "No Payment Data Available" I also included my log file and the superorders.php and orders.php in the zip file if you care to take a look. The admin code looks to be intact. I think what may be happening is the supperorders does not have reference to the payment data so it couldn't do the partial refund...Quote:
Originally Posted by DivaVocals
Yes.. I did both full and partial refunds.. Not for nothing, but I've got a lot on my plate right now so I am not going to have time to look at your orders.php and super_orders.php files.. Please have a look at them and let me know if the notifications code I referenced is still intact.. Also your screen print is a little small and hard to see.. Can you try uploading your screenprint to tinypic.com and post the image link here.. Also be sure to post BOTH the default orders and Super Orders screen shot (for the same order) so that I can see what the difference is..Quote:
Originally Posted by nohart
Yes the code seems to be intact. Here are the screen shots:Quote:
Originally Posted by DivaVocals
http://i55.tinypic.com/a4wf9u.png
http://i51.tinypic.com/2ezmcfs.png
So one last question.. When you tried to initiate the refund from Super Orders HOW did you do this??
Did you
A. Click the orange "Refund" button
http://i56.tinypic.com/a4odh4.png
B. Initiate the refund transaction within the payment module's admin notifications section (this is what is that code snip I asked you to confirm does)
http://i56.tinypic.com/wjv2iw.png
Quote:
Originally Posted by nohart
Separate question - when I press Modify under the order payment data, instead of opening a dialog to modify the payment, it opens a new window that brings shows the admin panel dashboard.
Has anyone seen this before I debug further?
Thanks,