Excellent!!!:clap: Along these same lines, I am going to include a full list of Super Order files to help facilitate the uninstall process..
Printable View
Got a problem with Super orders (rev 47)and Firefox.
The 'Payment, Purchase Order and Refund on the main Superorders webpage do not work in FF3.5.5
They work perfectly in IE8, so I know its not Superorders, but if anyone can offer some advice its appreciated.
this is what ive done so far
1. Allowed all popups in FF
2. Enabled Javascript
Anything else that I should try??
Thanks in advance
Sorry for that:
When I hover over the image of the buttons I can see the code that it executes in the bottom Left corner, just like IE, but when I press the buttons nothing happens.
In IE7, and 8 the new window appears and more info is input......however in FF I see the code that begins
but no popup or new window ever appears.Code:javascript:popupWindow('http://localhost/zencart/admin/super_payments.php?.......etc
IE is fine for me at the min, but I am in the process of moving to Ubuntu, this is one of the things I need fixed, so 'er indoors' can keep working.:P LOL
To be honest this isn't a problem I've ever seen reported, and IMO it seems more indicative of a browser client issue versus a Super Orders issue.. You might want to check your browser settings to see if you have disabled javascript or if you have some sort of pop-up killer enabled.. Outside of that, you might want to try reinstalling Super Orders (though quite honestly if this is an issue of a browser setting that will likely not fix the issue..) Wish I could be of more help.. Hopefully someone else will chime in..
Does this mod only affect the back office?
Okay to continue on in my adventure of compiling a fully patched version of Super Orders, I have run into a challenge, and I was hoping that I could get a hand..
While I personally do not think that the "Edit Status History" feature is a particularly useful feature of Super Orders, (I think it creates an audit/accountability issue to allow the editing of order notes/comments) it's here and I suppose that folks are using it, but it is not working as it should. This particular problem also goes back to 2006, and has not been fully resolved/addressed even in the latest version of Super Orders. It is my understanding that this particular issue is another one of the security flaws within Super Orders that Phillip has been so good to point out to the community..
Apparently the issue is this:
The following posts which helped me fix the issue in the super_order.php and super_batch_status.php files.Quote:
The problem you experienced with the tags being displayed improperly in status update comments is due to the comments not being properly scrubbed before inserting them into the DB.
http://www.zen-cart.com/forum/showpo...&postcount=220
http://www.zen-cart.com/forum/showpo...&postcount=621
(So that it's clear to anyone reading this, the fix I applied was based largely on the 1st post, the second post includes an incorrect fix, but gave me a clue where a second change needed to be made..)
I made the following change around line 125 in super_orders.php:
I made the following change around line 69 in super_batch_status.php:Code://$comments = zen_db_scrub_in($_POST['comments']); // replaced line
$comments = zen_db_scrub_in($_POST['comments'], true);
So now I'm down to how to fix the stripping issue in the super_edit.php file.. I've tried variations of the fixes I found in the two previous referenced posts to no avail.. Since I don't know PHP, I am GUESSING right now how to fix the super_edit.php file (logical guesses.. but WRONG guesses:laugh:), and I was hoping that someone here would take pity and give me a hand..Code://$notify_comments = $_POST['notify_comments']; // replaced line
$notify_comments = zen_db_scrub_in($_POST['notify_comments'], true);
The "Edit Status History" feature injects HTML line breaks and ASCII line breaks into the database, and these line breaks are displayed when the customer views their order history from "Status History & Comments". For example:
I am fairly certain that it's this section of the super_edit.php code that needs to be corrected - around line 433:Quote:
New test.. I want to see if the HTML line breaks are added to the comments.\r\n\r\nIf this works, when I edit the comments, the line breaks end up with these weird characters after them..\r\n\r\nDon\'t understand why this code is broken..
I am plum out of guesses (logical and otherwise) as to what I need to change..Code:$this_status = $_POST['status_' . $this_history_id];
$this_comments = zen_db_scrub_in($_POST['comments_' . $this_history_id]);
$this_delete = $_POST['delete_' . $this_history_id];
$change_exists = false;
Now all that said, is this even a USEFUL feature.. because the EASIEST fix is to hide the "Edit Status History" link..:laugh::laugh:
And the story continues..:laugh:
I've run across several posts talking about combining Edit Orders with Super Orders.. I read the Edit Orders readme and it seems that this merging was a little simpler than previous posts had led me to believe.. (If anyone else has attempted this merge and disagrees, please let me know if I am incorrect)
According to the readme the following edits for orders.php are required:
I just applied a variation of these edits to the super_orders.php file as follows:Quote:
2. Make the following changes to admin/orders.php:
Find: (In 1.3.8a on line 854)
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
Replace With:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_details.gif', IMAGE_DETAILS) . '</a> <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
Find: (In 1.3.8a on line 898)
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
Replace With:
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
Near line(s) 300-321 (my super-orders.php file is heavily modded so the line numbers are approximate locations
Near line(s) 1420-1435 (my super-orders.php file is heavily modded so the line numbers are approximate locationsCode://BOF Add Order Edit button to order detail page
echo '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, 'oID=' . $oID) . '">' . zen_image_button('button_edit.gif', ICON_ORDER_EDIT) . '</a> ';
//EOF Add Order Edit button to order detail page
echo '<a href="' . zen_href_link(FILENAME_SUPER_DATA_SHEET, 'oID=' . $oID) . '" target="_blank">' . zen_image_button('btn_print.gif', ICON_ORDER_PRINT) . '</a> ';
The are a couple of issues I've found with using Edit Orders.Code:// EOF Add Edit Order button to order order list page
// $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_SUPER_DATA_SHEET, 'oID=' . $oInfo->orders_id) . '" target="_blank">' . zen_image_button('btn_print.gif', ICON_ORDER_PRINT) . '</a> <a href="' . zen_href_link(FILENAME_SUPER_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_ORDER_EDIT, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_SUPER_DATA_SHEET, 'oID=' . $oInfo->orders_id) . '" target="_blank">' . zen_image_button('btn_print.gif', ICON_ORDER_PRINT) . '</a> <a href="' . zen_href_link(FILENAME_SUPER_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete', 'NONSSL') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
// BOF Add Edit Order button to order order list page
The notifications are not working the way they do on the orders.php page...
For the record to fix Super Orders to work like orders.php check out this thread: http://www.zen-cart.com/forum/showpo...postcount=1147Quote:
In the original "Customers" > "Order", we have two checkboxes, one that says "Notify Customer" and one that says "Append Comments". If neither of the boxes are ticked, then the order history still updates with whatever in the textarea.
The original
- "Notify Customer" means send the customer the change in status email,
- "Append Comments" means add the comments in the textarea to the "change in status email".
In Edit Order, it only sends the customer notification e-mail when BOTH notify and append checkboxes are checked..
The other issue is that the "Back" button on the edit_orders.php page only takes you back to the the Super Orders order list page (super_orders.php). It should take you back to the detail page of the order you were editing.. It's minor and I can live with it..
Gonna keep messing around and try to figure out how to correct this, but for now the major edits to join these two apps seems to work.. Thought I'd share.. Contemplating including this as an optional edit for Super Orders.. (if I can get the back button to work correctly) I'm also contemplating an optional edit for merging Admin Comments with Super Orders as well..
First of all thanks for a much needed addin-on. Even though I am not a real programmer, I was able to install it. I did find one quirk in the sql statement.
In the first two statements, the command said, insert into and the first field was just " ". This threw an error, do I changed it to NULL, and it worked fine.
Also, I have 1.38a and the authorize.net does not have the if statement referred to in the read.me file for storing cc numbers.
Any suggestions on where to put that if?
Thanks again.
I have Super Orders installed...I see the Edit Products "button", but it doesn't allow me to change the quantity of the products or add a product. It seems to only be able to remove an item. Am I missing something? I need to change the quantity of a customer's order.
Edit Products is mis-labeled. The Super Orders Edit Product feature allows you to split an order into two orders.. If you want to edit an order, you need the Edit Orders module, and you will need to modify Super Orders in order for it to work with Edit Orders. Go back a page or two in this thread.. I posted instructions on how to edit Super Orders to work with Edit Orders.. HTH..
Quick question...
How do i totally remove the lines:
Amount Paid: $0.00
Balance Due: $99.99
from Super Orders Invoice.
So JUST the Total is visible?
(I'm scared of removing too much or not enough from the file(s)).
Thank you
In admin/super_invoice.php, you can simply remove the following lines:PHP Code:
echo ' <tr>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><strong>Amount Paid:</strong></td>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><strong>' . $currencies->format($so->amount_applied) . '</strong></td>' . "\n" .
' </tr>' . "\n";
echo ' <tr>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><strong>Balance Due:</strong></td>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><strong>' . $currencies->format($so->balance_due) . '</strong></td>' . "\n" .
' </tr>' . "\n";
Searched and I couldn't find a answer so i'm hoping someone can help me.
When i installed my store i copied it from another store I have and deleted the data...... or so i thought :D
The old data is turning up in the Cash Report. Any ideas on how I can remove the bad data and keep the good ???? Cheers
Assuming you're doing this directly through sql, did you clean up the tables starting with SO (SO_PAYMENTS...)? There may be a better way to do this - there's always reinstall, or even reinstall just the SO module using the sql instructions there to recreate the tables it needs.
My client loves SuperOrders. They would love it more if it would sort the items on this page - http://www.examplewebsite.com/elocin/super_orders.php? by Model number.
Can anyone help me do this?
Thanks,
Janelle
Thanks for responding but it's a dummy URL as the page is behind the Admin panel. This is just the main SuperOrders page once an order has been received. It displays all sorts of info, including a product list from the submitted shopping cart. It's this list that I'd like to have sorted by Model number.
Thanks,
Janelle
I am aware that the super_order.php file takes you to a page behind the admin.. Perhaps I wasn't clear enough.. The dummy link you provided redirects me to a page that looks NOTHING like the super_orders.php main page..:smile:
That said, your explanation provides a clearer picture of what you are after..:smile:
Have you looked at the sales report addon? It may have what you're looking for
I want to add a google maps button to the super orders page so that when i click it. it will pop open in a new window and take the customers address and enter it in the google maps link.
This is in case the customer has entered the wrong shipping/billing address in and i can double check and verify.
this will work exactly like the IP Address: [whois] popup but with an address instead
How can i go about this?
Thanks
My client used Super Orders to add a shipping cost to a Canadian order. When he looked in authorize it only charged the amount without the added shipping cost. Is there something we are doing wrong? This is how it shows:
Sub-Total: $45.00
Request FREIGHT or INTERNATIONAL Shipping Quote: $29.99
Total: $74.99
Reward Points earned: $0.00
Amount Applied: $0.00
Balance Due: $45.00
I've seen this when I use edit_orders to add a product line - this isn't reflected in the balance due. I don't believe edit-orders is updating the order_total fields.
As a workaround (maybe a fix?), after I add a product to the order, I click on "edit order totals" just below the balance due line. I don't need to change anything, just press 'Submit' and it'll refresh the totals.
Will that reflect as the correct total in Authorize? Thanks
Sorry, not familiar with Authorize.
But does your order show correctly in paypal or whatever you use?
It is correct, but the only way I've had the SuperOrders number come out wrong was by editing the order after the order was placed, so it's already gone through checkout by that time.
Perhaps that's the root problem - he's trying to add a shipping charge after the order's already gone through checkout? He should be getting the shipping charges into the order prior to checkout by using a shipping module, not super-orders.
:yes: Yep.. Anything you add to an order AFTER checkout whether you use Edit Orders or Super Orders will NOT be reflected in the balance show by your payment processor. It should be collected during the sale.
Now if you have a situation where you need to calculate shipping AFTER an order has been placed, you will need to collect it seperately from the order.. If you want to do this all through Zen Cart, you can use hideCategories to help achieve this.
I have one customer who uses the hideCategories add-on to create "special" products that she sends the customer a link to access. The hide Categories mod allows her to hide these products from other customers. The customer adds this special product to their cart and checks out like normal. She uses these "special" products for products in which additional shipping has to be calculated and collected after the sale or for custom orders where she has collected a deposit from the initial transaction and needs to collect the balance of the custom product cost. You will need to add the hideCategories code that is in the orders.php file in with your super_orders.php file to sue this mod with Super Orders..
Almost done compiling an updated Super Orders.. I'd like to see is anyone wants to test this before I submit it to the downloads section.. Any volunteers??
I will test it.. Just so I don't have to read this whole thread on what fixes to put in it :P
I will also test if you want. I use Super-Orders very extensively.
me too, just let me know.
I am putting together a new site as we speak.
I don't know much bout sql, sorry for asking some basic questions :blush: Hope u don't mind.
I want to remove the super order 2.0rev47 module, I've revert all the php files added/edited, but I have no idea how to uninstall the super_orders_sql.sql, is it I just install the sql file in admin>tools>install SQL patches you posted? (If yes which one do I upload, "uninstall_super_orders_sql.sql" or "uninstall_upto_version47_super_orders_sql.sql"? )
How do I check that the super_orders_sql.sql is in my database, so that after uninstall I can make sure that I've remove it?
Thanks in advance! :smile:
Thanks for the offers to test, but when I didn't get any responses within a day or two of my request, I went ahead and submitted the updated mod for approval.. Hopefully the admins will approve it soon.. Here's the full list of changes it includes
Change Log
- Clean up and reorganize the readme file
- Addition of a “Required_CoreEdits” folder. This folder contains files that include the edits outlined in the the “REQUIRED FILE EDITS” section of the previous version of the Super Orders readme
- Addition of an “Optional_Files” set of folders. This folder contains files that include most of the edits outlined in the the “OPTIONAL FILE EDITS” section of the previous version Super Orders readme
- Removed all the authorizenet_aim.php edits from readme because they appear to be from an older version of the Authorize.net payment module files. (These instructions are in the "OPTIONAL FILE EDITS" section of the previous versions readme file)
- Updated e-mail format (modified lines 30 - 33 of order_status_email.php) to improve the aesthetics of the e-mail generated
- The "Edit Status History" function has been removed. It creates an audit/accountability issue by allowing the editing of order notes/comments. The "Edit Status History" feature also injects HTML line breaks and ASCII line breaks into the database, and these line breaks are displayed when the customer views their order history from "Status History & Comments". This particular problem goes back to 2006, and has not been fully resolved/addressed even in the last version of Super Orders.
The problem is due to the comments not being properly scrubbed before inserting them into the DB. This particular issue also is a potential security flaw.- Removed the code in Rev47 which was supposed to correct the customer notifications and in particular the behavior of the "Customer Notified" flag in the "Status History" section. The "Customer Notified" flag did not match the actual activity. The Rev47 code did not correct the issue. The code to fix this problem comes from the the super_orders.php file that comes with Numinix's Fast & Easy Checkout. (v1.6.2)
- Changed the packing slip images to an on/off option. (Previous versions limited the number of images that would show on a packing slip to 3 -- other options for packing slip images are found later in this readme in the Other Tips/Edits section)
- Other changes in this version of Super Orders are based on the following threads:
- http://www.zen-cart.com/forum/showpo...&postcount=720
Items 1-3 are all various fixes which corrects the shipping display to show the full shipping description (carrier and shipping service) on the following files: super_packingslip.php, super_invoice.php, super_orders.php, and super_data_sheet.php. The default Zen Cart packing slip, invoice, orders, and datasheet all display the FULL shipping description while Super Orders has always used the short shipping descriptions. (It is likely that this is because this was a requirement of the client for whom this mod was originally built for)- http://www.zen-cart.com/forum/showpo...&postcount=777
See Item #1 for description information- http://www.zen-cart.com/forum/showpo...&postcount=851
See Item #1 for description information. Fixes shipping description on the super_orders.php file.- http://www.zen-cart.com/forum/showpo...postcount=1079
For products with text attributes that include multiple lines and line breaks entered by the customer, the default Zen Cart order invoice prints out the text entered by the customer fine, and retains the multiple lines and line breaks entered by the customer. However, the Super Orders invoice does not. This fix addresses that issue. Applied this fix to super_packingslip.php, super_invoice.php, super_orders.php, and super_data_sheet.php)- http://www.zen-cart.com/forum/showpo...postcount=1126
Corrects an issue where Super Orders fails to update the "last modified date" when updating the order status using the batch status update function- http://www.zen-cart.com/forum/showpo...postcount=1146
Includes an optional edit for the default state of the "Notify Customer" checkbox- http://www.zen-cart.com/forum/showpo...postcount=1147
Addresses another error in Append Comments & Notify Customer as well as a clarification on how these features are SUPPOSED to work. Changes to language files were made to support this.- http://www.zen-cart.com/forum/showpo...postcount=1316
Fixes the issue with packing list images displaying distorted- http://www.zen-cart.com/forum/showpo...postcount=1436
Options for how the number of images are displayed on packing list (more options for packingslip imagescan be found in the Other Tips/Edits section of this readme)- http://www.zen-cart.com/forum/showpo...postcount=1474
Fixes issue with Batch Status Updating & Batch Printing which throws errors when you search for orders using the following options:
- = equals
- < less than
As there is an issue with "= equals" not working with decimal values (ie: $2.50), the "= equals" option will be disabled from the dropdown. Perhaps someone will post the actual fix for the "= equals" option.- http://www.zen-cart.com/forum/showpo...postcount=1487
Fixes the textarea element on super_batch_status.php so it displays correctly in Internet Explorer. This is a bug with the way Internet Explorer displays textarea elements. The original author of this mod posted a hint regarding this issue here: (http://www.zen-cart.com/forum/showpost.php?p=292293&postcount=2
What exactly does Super Orders do?
From the readme file:
I recommend downloading the app and reading through the read me file for more details..Quote:
Description
Super Orders is exactly what its name implies: Zen Cart order management on steroids.
It's more in all the areas Zen users are asking for more:
- more navigation options
- more order control
- more thorough data
- more detailed reports.
But it's NOT more than you can handle. The system was designed for data entry clerks (some of the least-technically inclined people on the planet). You're a Zen user. You can handle it.
Ready to get started? Just follow the installation instructions below: note that the system only makes small changes to three pre-existing files!
Any questions, just hit the forums: http://www.zen-cart.com/forum/showthread.php?t=44668
!!READ EVERYTHING!!
I very strongly recommend you read through the *entire* FEATURES section beneath the installation instructions. There you will find out exactly what Super Orders can do. There are some cool tricks that you won't know about if you don't read them!
Diva, is your latest version available for download? Does this module affect the frontend of the site or just the admin section?
Not available yet.. Waiting for approval from the admins.. There are front end mods to support the admin order management.. I recommend downloading the mod to see the affected files, and read through the readme to see the additional mods required.. Will give you a sense of what this app does..
Just for the record (and benefit to other users) I must state that this is a fantastic mod. I installed and am busy testing rev. 48. The results so far are very good.
Firstly, the way the install files are structured makes the installation a breeze. (so for all future users, RTM ie. Read The Manual) The "HELP" file is very well constructed and easy to use. If you follow the instructions you cannot go wrong.
The Invoice, Admin order report and packing slips are all very usefull in a professional shopping environment. The "SPLIT ORDER" function is almost a 'must have' if you run a store where you may have to put orders or part of an order on backorder due to insufficient stock levels.
I also find the batch status update facility a real time saver. At the end of the day when all the orders are shipped or collected you need only to use this facility to update them all to "complete" status with one or two clicks.
This mod also integrates with the "EDIT ORDER" mod.
I basically disconnected the standard orders module and am using this mod as my main order processing interface.
Thank you to all that contributed to this essential add-on!:clap:
My Edit Order Total popup is blank. :blush:
I have not added anymore contributions.
There is code when Source is viewed.
Any hints appreciated.
Did you try the debugger from DrByte?
http://www.zen-cart.com/index.php?ma...roducts_id=860
I am really confused on how to get supper orders and paypal to work together. I found a fix on page 112 and followed that. My one problem I have is I cannot find the ipn_main_handler.php file.
Will these fixes automatically updated any previous orders that were already completed through paypal?
Yes.
Here are the results from clinking the edit order totals
[03-Jan-2010 17:25:20] PHP Warning: implode() [<a href='function.implode'>function.implode</a>]: Invalid arguments passed in content/includes/templates/classic/templates/tpl_index_product_list.php on line 61
Which is: $pro_vk=implode(',',$pro_vk_array);
Now I did go through the install process for the Edit order contribution and nothing changed as i was comparing pages.
Is there an update for Super Orders?
I've had no issue with this feature workig on my test stores which leads me to believe that you may have corrupted files..
Try downloading and re-installing..
Even IF this was an issue (and I don't believe it is), the version of Super Orders I submitted (as Rev 48) would not solve this "problem" as Rev 48 is NOT a re-coding of the Super Orders module at all (I'm not a programmer).
Rev 48 that I submitted for approval is simply a version of Super Orders which incorporates all the many changes and tweaks suggested in this support thread over the last 4 years years. (the full change log for the version I submitted is posted a page or two back in this post). I'm sure the admins are busy and have not had a chance to review/approve my submission yet.. When they do I will update you all..
Hello,
Does the last version can be used with multi languages?
Hoping someone more sage than I can help decypher this mystery.. If you click the "Modify" button next to to a Super Orders payment, the popup window does not open up the payment for modification at all.
I believe that the key to fixing this is found on line 108 or the super_payments.php file.
I've tried a few things, but ultimately I am not sure what needs to be modified.. (I think is a minor fix).. Anyone got any ideas??Code:zen_redirect(zen_href_link(FILENAME_SUPER_PAYMENTS, 'oID=' . $so->oID . '&payment_mode=' . $payment_mode . '&index=' . $_GET['payment_id'] . '&action=confirm', 'NONSSL'));
If I can't figure this out, I think I may just disable this feature since from an auditing point of view, the CORRECT way to "modify" a payment is to make a payment adjustment. (Yes even if you made a data entry mistake -- in real accounting software this is how it would be handled)
Another observation.. When an order is either canceled or marked completed, ALL of the buttons which allow you to add, modify, or delete payments, P.O.s and Refunds should be hidden. I noticed that other editing features are hidden, but not these.Does anyone have any clue as to how I would go about correcting this???
I've been testing how payments made using the "Credit Card - Offline Processing" payment module appear in Super Orders. I noticed that not all credit cards payments display the correct payment_type in Super Orders. In particular Master Card and Diners Club. (Visa, Amex, and Discover all show up correctly) After doing some tiptoeing through the Developers Tool Kit I think found the answer:
I believe that Master Card does not show up because the Master Card value used in the array in the Super Orders class files (store and admin) and the payment type for Master Card in the so_payment_types table do not match the cc_type for Master Card in the /includes/classes/cc_validation.php file.
Diners Club doesn't show up because it's not defined in the array in the Super Orders class files (store and admin) and simply needs to be added the class files and the so_payment_types table.
To fix Master Card and add Diners Club here's the changes I made:
Go to /admin/includes/classes/super_order.php around line 276 and make the changes highlighted in red:Go to /includes/classes/super_order.php around line 276 and make the changes highlighted in red:Code:$cc_type_key = array('MasterCard' => 'MC',
'Visa' => 'VISA',
'American Express' => 'AMEX',
'Diners Club' => 'DINE',
'Discover' => 'DISC');
Then run the following SQL changes in Admin>Tools>Code:$cc_type_key = array('MasterCard' => 'MC',
'Visa' => 'VISA',
'American Express' => 'AMEX',
'Diners Club' => 'DINE',
'Discover' => 'DISC');
Install SQL Patches to correct the Master Card payment type and add Diners Club to the Super Orders payment types tables.
For the record any other credit cards you would like to add, you can simply update the class files to add them to the array. You must make sure that you also add them to the so_payment_types table as well. Remember they must match the cc_types used in the /includes/classes/cc_validation.php file.Code:UPDATE `so_payment_types` SET `payment_type_full` = 'MasterCard' WHERE `so_payment_types`.`payment_type_full` = 'Master Card';
INSERT INTO `so_payment_types` (`payment_type_id` ,`language_id` ,`payment_type_code` ,`payment_type_full`)
VALUES ('10', '1', 'DINE', 'Diners Club');
Thought I'd share this too.. I used the following test credit card numbers for the various credit card types
Here's the source for these test credit card numbers: http://www.ameripayment.com/testcreditcard.htmQuote:
Master Card - 5105105105105100 - (16) Characters
Master Card - 5555555555554444 - (16) Characters
Master Card - 4222222222222 - (13) Characters
VISA - 4111111111111111 - (16) Characters
VISA - 4012888888881881 - (16) Characters
American Express - 378282246310005 - (15) Characters
American Express - 371449635398431 - (15) Characters
Amex Corporate - 378734493671000 - (15) Characters
Dinners Club - 38520000023237 - (14) Characters
Dinners Club - 30569309025904 - (14) Characters
Discover - 6011111111111117 - (16) Characters
Discover - 6011000990139424 - (16) Characters
JCB - 3530111333300000 - (16) Characters
JCB - 3566002020360505 - (16) Characters
Hope all of this is useful for someone else..
Please don't take this wrong Webskipper, but you've asked this question over and over since LAST December, and (IMO) it's been answered a few times in this support thread.. I'm not sure what additional information you are seeking in asking again, but I'll throw in my 3 cents on the subject again..
Super Orders as it's name and the readme file states is supposed to be the replacement for the stock Zen Cart orders.php, packingslip.php, and invoice.php. It's an order management system that includes many more features not included in the stock Zen Cart order management.
Edit Orders as it's name implies and the readme file states is a module that allows you to edit an order.
These are two separate mods with COMPLETELY different purposes, and there is NO FEATURE OVERLAP between the two.. It's not a matter of one versus the other, that's like comparing apples to oranges.. They are both fruit, but they are different kinds of fruit..
That said if you are replacing the stock order management with Super Orders there is no reason why you can't use Edit Orders with Super Orders. In fact there are instructions in the Edit Orders readme file which address SPECIFICALLY how to incorporate Edit Orders with Super Orders. There are also several threads in this support thread which give guidelines on how to achieve this integration as well.. (Including one posted by yours truly which I believe provides a lot more detail than other posts in past have provided on the subject)
http://www.zen-cart.com/forum/showpo...postcount=1510
http://www.zen-cart.com/forum/showpo...&postcount=250
It's been over a year since I dropped into this support thread, and it appears that you are still having issues getting the integration of these two modules to work. Perhaps you might want to consider seeking some paid assistance which might give you more detailed or hands on help than you've gotten here. It appears that Scott might offer commercial assistance with this integration on his site: http://www.zencartmod.com/index.php?...&products_id=3.. Dunno.. If you want to try taking a stab at this, check out the threads I posted and see if they help..
Ah yes since December 2008?
Been busy serving my country.
Appreciate your response.
Yep Dec 2008..
Appreciate your service to our country..
Hope the posts I listed help.. I used the guidelines I posted, and have Super Orders successfully integrated with Edit Orders. On my loaded test store I have Super Orders integrated with the following modules:
- Fast & Easy Check Out
- FedEx Shipping Labels
- Admin Comments
- Edit Orders
Everything is playing VERY nicely together.. The application Beyond Compare is my secret weapon to help pulling it all together..
So what you are saying is that you have the next version of So ready with Admin Notes Integrated? That's like including a corkscrew with a Wine & Cheese Gift set.:yes:
The issue I was having was that the htaccess page was hacked. Once I fixed that and cleaned up the mess, everything worked correctly. All the issues were resolved.
Don't take this the wrong way. In the future, you may want to ask more questions before responding the way you did above.:wink:
No.. not at all.. Sorry.. :laugh:
The next version I have ready (and am still awaiting admin approval) does not bundle in any other modules.. Just want to let you know that I have successfully gotten Super Orders to play nicely with the modules I listed..:smile:
I want to do this too, but when I click as above, I get this message:
404 Not found
http:// - Was Not Found On This Server.
Sorry, missing.
The page you requested could not be located on this server.
Please contact the webmaster below if you feel you have received this page in error.
I've looked through all the files I installed with SO2, and they all seem to be there.
New site, products not loaded yet, and no orders.
Zen Cart 1.3.8a
Database Patch Level: 1.3.8
PHP Version: 5.1.6 (Zend: 2.1.0)
Database: MySQL 5.0.27
Does this Add make me able to change the payment option?
Lets say the Client ordered per Money order/Check and wants it now to be paid per CC, what can I use to change that, or how do I change that?
Any idea?
Thanks
Not what this mod does.. However, you can use this mod to record the new payment with the new payment method, but if the new payment method is PayPal or a credit card you would have process the payment offline.. (In other words you would not be able to "run" the payment through the store) I suggest checking out the readme file for this module.. The readme file included with this module summarizes all the features of this mod..
So speaking of the Super Orders 2.0 Rev48 I compiled and submitted to the downloads section -- I need to get some feedback from the community..
I am still awaiting approval by the Admins for the Super Orders 2.0 Rev48 files I submitted to be included in the downloads section.. However, I have gotten an e-mail or two asking about this version and if I could make it available now.. It's too big to upload to the support thread, but I could probably post the zip file on my site.
Now I can and will do this if there is interest from the community.. (I hope the admins don't mind and won't ding me for this)
There is one small caveat.. (and it's a GOOD thing BTW) The version I submitted to the downloads did not include the fix for the display of the correct payment method when the Offline Credit Card payment module is used. Also I discovered that this little fix also works for anyone using the Authorize.net (AIM) payment module for accepting credits cards..(Details of this fix can be found here:http://www.zen-cart.com/forum/showpo...postcount=1556)
The version I would make available for download does include the credit card fix.. (told you it was a good thing) If/when Super Orders 2.0 Rev48 is approved by the admins I will update it IMMEDIATELY with the version that contains the credit card fix..
Okay.. long winded as usual.. Just need some community feedback if there is interest in getting access to Super Orders 2.0 Rev48 now.
DivaVocals, have the admins given you any idea when Rev48 might be available through the ZC download pages?
The tutorial at https://www.zen-cart.com/tutorials/index.php?article=11 says:By my reckoning, your submission has been around for at least 3 of those semi-weekly reviews.Quote:
Contributions submitted to the "downloads" area will be reviewed for compliance and acceptability. Such reviews happen twice weekly. Contribution authors will be notified by email when their contribution as been activated.
Just wondering if I should continue to be patient or ask you to do even more than you have already and make a copy available on your site.
No clue.. These were all submitted around the holiday season, and so that might be part of the issue, but I am just speculating..
I sent an e-mail asking for an update on my submission along with two others I submitted around the same time (WordPress on ZenCart Sideboxes Only, and Western Union Payment Module)
Rev 48 has gotten great feedback from my clients, and I think the Zen community will like it too.. I can't take credit for all of the changes.. There were a string of minor functional issues with Super Orders that over time IMO added up. All the fixes for these minor issues were posted right here in the support thread. Rev48 just compiles those fixes and therefore should eliminate most of those minor funcional issues.
I can post a link to Rev48 in the meantime.. I'm just hoping this will be okay with the admins while they review the submission..
http://www.overthehillweb.com/ZenCart
I just have a quick question - I'm wondering how the file admin/super_customers.php seems to integrate with everything else?
I'm having issue with not being able to edit customer info (capitol letters in the address and name etc) and I have Super Orders 2.0 Rev 47 (I think it's 47) installed and working fine. I also have the "Admin log in as customer" Mod installed and working also. When I first installed it (Admin log in), I added the changes to admin/customers.php and I also looked through super_customers.php and added bits where it looked like it made sense and it's working fine. But I'm now wondering if it's my "Admin Log in as Customer" additions to super_customers.php that could be effecting how I can't edit customer details?
Do you need to make additions to super_customers for the Admin log in mod to work?
Can anyone please help?
I am an absolute novice and I don't want go to the MySQL to simply fix spelling mistakes or even just change the group pricing discount settings for customers!
If you downloaded the most recent version available in the downloads sections then you would have Rev 47..
This is a GENERAL answer since I do not know if you have configured Super Orders to fully replace the stock Zen Cart order management or not.. (this is explained in the readme file)
Like other files in the Super Orders mod the super_customers.php file is meant to be the Super Orders version of the stock customers.php. So if you must edit customers.php for the "Admin Login as Customer" module, you will need to make those same changes in the super_customers.php file..
To troubleshoot issues with the "Admin Login as Customer" you will need to pose your question in the support thread for the "Admin Login as Customer" module.
Just an additional thought... why are you using "Admin Login as Customer" when you could use "Add Customers from Admin" which seems a more appropriate module for editing customer information. Captialize Sign-up Fields is another module "which checks and amends the capitalization of user entries on the client-side before they are submitted". This would eliminate the need to log into a customer account at all to just edit customer name data..
Thanks for your response DivaVocals - I really appreciate your time in responding!
Yes I have done those modifications to super_customers.php and it works fine.Quote:
Like other files in the Super Orders mod the super_customers.php file is meant to be the Super Orders version of the stock customers.php. So if you must edit customers.php for the "Admin Login as Customer" module, you will need to make those same changes in the super_customers.php file..
One question though - when I click on Admin>customers is it supposed to use the super_customers file? 'cause it doesn't with me. And even in the SO Readme file, it doesn't really mention using the super_customer file instead of the customers file (I think - I'm willing to be corrected). I've even tried adding "super_" in front of "customers.php" in the URL line when I've been in the admin screen and it doesn't seem to do anything.
Any ideas anyone?
PS I use "Admin Log in as Customer" for the purpose of placing an order for a customer when it's been emailed through. Works quite well. Is there a better mod for that purpose?
I use "Add Customers from Admin" when I need to add a customer
Please pardon my ignorance in my searching skills but I haven't been able to find one. Can anyone help here? I even searched putting it in inverted commas (assuming the search engine works the same as google) but I still didn't find it.Quote:
To troubleshoot issues with the "Admin Login as Customer" you will need to pose your question in the support thread for the "Admin Login as Customer" module.
Thanks too for the link to "Captialize Sign-up Fields" too! I'd remembered there was something like that but I couldn't find it! (I was searching for "spell check" and the like ... no wonder I didn't find it!) It's installed now and working great!
Actually another thing - I'd also installed Group Pricing per Item Mod (again via WinMerge) however due to the not easily being able to edit the discout group anymore I uninstalled it (the same was as I installed it ... went into the individual effected files and deleted the unrequired lines) Again everything works fine except being able to edit the Customers SQL through Admin. And was wondering what super_customers was used for etc.
Which mod is Admin Comments?
Do you mean Admin Notes?
Mark :-)
www.diversofpearls.com
If a customer pays using paypal express checkout any notes they leave with the order are missed off the batch invoice. This is a real problem for us as a lot of customers leave notes with specific order details etc.
Any ideas?
Are these PayPal notes entered after the customer is redirected to PayPal? If so, I am not sure if those notes are returned when the PayPal payment notification data is returned, but even if it is, these notes would only appear on the order window, and not on the batch invoice.
I'm sure it's a matter of adding the right code to get it to appear on the batch invoice. Perhaps someone here can chime in if they know how..
My initial response was a general response.. After taking a look at your initial question, I'm not sure you necessarily need to apply the changes from the Admin Login as Customer module to the Super Orders files.. In other words, I do not beleive they need to be integrated.
If you are having issues with the Admin Login as Customer module, and there is no specific support thread, you can still create a thread in the forum with your specific help question.. Folks here are pretty helpful, and should have you all straightened out in no time..
Hi I'm totally new with the sql codes. I have encountered a problem. After editing the following:
// migrate PO's from payment_purchase_order to so_purchase_orders
$po = $db->Execute("select * from zen_so_purchase_orders");
// migrate the data from payment_check to so_payments
$payments = $db->Execute("select * from zen_so_payments");
// migrate the extra check data from payment_check_balance to so_payments
$extra_checks = $db->Execute("select * from zen_so_payments
where check_direction = 1");
// migrate the refund check data from payment_check_balance to so_refunds
$refund_checks = $db->Execute("select * from zen_so_refunds
where check_direction = -1");
The result I have got was:
PO migration complete!
Payment migration complete!
1054 Unknown column 'check_direction' in 'where clause'
in:
[select * from zen_so_payments where check_direction = 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.
Please do help me with this problem. Thank you!
Guess the admins still haven't approved Rev48, so I picked up a copy from your site and noticed a "nit-pick" for Rev49. MasterCard became two words in Rev48 at line 276 of \1.Install_Files\includes\classes\super_order.php. I checked at MC's site (http://www.mastercard.com) and they seem to consistently refer to themselves as "MasterCard" (one word, bi-capitalized). ... FWIW
Back on Rev48 "nit patrol"...
- There seem to be two ".bak" files in the zip.
- A "thumbs.db" file survived the packaging process
- Two lines are mushed together in the "Core files modified" section of the readme.html file:
- super_orders_20_rev48/Install_Files/admin/includes/general.jssuper_orders_20_rev48/Optional_Edits/admin/includes/boxes/customers_dhtml.php
Yeah, and I'm not sure why.. I'll wait a little bit and perhaps consider re-submitting it.. Dunno yet..:unsure:
I merely fixed Super Orders so that it would pick up the Master Card payment type the same way the default orders.php does.
FYI, the fix for this requires an update to THREE files one of which includes the one file you reference.. What I did (and why) is all documented in detail in this thread: http://www.zen-cart.com/forum/showpo...postcount=1556
:oops: I'm such an idiot .... I had the files reversed on the screen when using BeyondCompare. Rev48 correctly has "MasterCard" and Rev47 incorrectly has "Master Card". DUH
Which is why I fixed it since Super Orders did not pickup Master Card payments correctly.. For good measure I also added Diners Club for anyone who needed it.. Again all documented here: http://www.zen-cart.com/forum/showpo...postcount=1556
Noted...
However, so it's clear for anyone following this thread, these are MINOR things, and do not affect IN ANY WAY the performance of the Rev48 version I have made available for download until it is approved by the ZenCart admins..
Simply delete the .bak files, and then delete the thumbs.db files. I'm sure that the two accidentally combined lines (corrected below) in the readme files won't stop folks from understanding it.. when I get some time later this week I'll take a look at these things and address them
I thought this new revision would take care of my paypal problems. I dont understand why it will not show a zero balance when I go into the detail section of the invoice. Do I really have to go in by hand and edit each one? Please help me out.
Dale
Hello BlindSide, Thanks for the great work. I went to setup my Gift Certificate module in Admin. and I am getting these messages.
Warning: main(/home/content/g/e/a/gearheadnikos/html/includes/languages/english/modules/order_total/ot_shipping2.php): failed to open stream: No such file or directory in /home/content/g/e/a/gearheadnikos/html/mm_2009/modules.php on line 173
Warning: main(/home/content/g/e/a/gearheadnikos/html/includes/languages/english/modules/order_total/ot_shipping2.php): failed to open stream: No such file or directory in /home/content/g/e/a/gearheadnikos/html/mm_2009/modules.php on line 173
Warning: main(): Failed opening '/home/content/g/e/a/gearheadnikos/html/includes/languages/english/modules/order_total/ot_shipping2.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/g/e/a/gearheadnikos/html/mm_2009/modules.php on line 173
Fatal error: Cannot redeclare class ot_shipping in /home/content/g/e/a/gearheadnikos/html/includes/modules/order_total/ot_shipping2.php on line 12
I am a newby with PHP so any help would be appreciated. I do not recall these messages before uploading Super Orders.
Thanks again
Thanks, DV. You're absolutely correct --- the things I noted are truly "nits" and don't deserve anything more than a mention in the forum and then quietly slipped in then next time the contrib is released. Just wanted to bring them to your attention as I recall that you were planning another update after the admins approved Rev48 -- whenever that may be. :unsure:
While I'm being a pest on the forum --- Does anyone know what level Rev47 is based on? It looks like some changes that appear in Rev46 disappear in Rev47 and then reappear in Rev48. Could it be that Rev47 was based on Rev45 instead of Rev46? :dontgetit
:clap: And great big gooey GOBS of thanks to DivaVocals and SWGUY for their updates --- and to everybody who has provided fixes & tips in the forum --- and to Blindside for putting SuperOrders together in the first place. My friend/client just loves the functionality and doesn't know how he would be able to run his store without SO.
If you are referring to Rev48, I listed very clearly ALL of the fixes/enhancements included in this version in the readme file..
There have been lots of posts in this thread which address how to get orders paid via PayPal to show paid in Super Orders.. You should search for this posts if you want to try your hand at adding some of this code.
I chose not to implement any of these solutions when I compiled the list of fixes for Super Orders because IMO much of the code posted in these threads does not appear to be complete, and IMO should NOT be included in a module that a store owner is depending upon to manage their orders.
As I've said before here in this thread, I am giving some thought to paying a developer to add this functionality and some other changes I'd like to see added to Super Orders.. I've looked into it, and it won't cost much for this development work. That is another option you could explore as well..
No worries..:smile: If/when the admins approve Rev48, I'll follow-up with a Rev48a (which is the version I have posted on my website) with the things you pointed out included.
No clue.. What compelled me to put together Rev48 in the first place was that the Rev47 files were not merging nicely with other modules that had created super_orders.php files to help ease the integration with Super Orders.
PLUS the key issue that was supposed to be addressed in Rev47 wasn't addressed at all.. The comments notifications were still not functioning correctly..
So I began a journey to mine this ENTIRE support thread for fixes that IMO should have been included in Super Orders. I wanted to restore functionality that was present in the default orders.php and modified for Super Orders (most notably the shortened shipping descriptions). I also wanted to address outright BUGS that had posted fixes which never made it's way into the Super Orders module..
So I started out using the super_orders.php file that Numinix (http://www.numinix.com) included with one of his add-ons (I believe it's the FedEx Shipping labels mod) because IT actually FIXED the comments notifications issue. After than Beyond Compare and Developers Notepad became my two best friends..
You're very welcome..:blush: Necessity is the mother of invention I guess.. I got tired of applying all of these fixes EVERY SINGLE TIME I installed Super Orders.. I also thought it made more sense that the optional and required fixes should already be "done", and since I write functional documents for a living, I HAD to re-write the readme to make it a little more user friendly..
So after compiling these fixes for me, I just shared it with the community in case anyone else wanted to save themselves a little time and trouble too.. I made sure to give credit for all the REAL contributors.. I only compiled it.. If I missed anyone, please let me know and I'll add their name to the readme..
Updated the link page so it's less "rough" looking.. :laugh:
http://overthehillweb.com/content/view/19/37/
Still awaiting approval, and as soon as it it approved by the admins, I will remove the zip file and link..
Hi DivaVocals, big Thanks for the update, so far so good.
A couple of points if I may:
1. includes\classes\order.php - Lines 349-350, BugFix#29,
see http://www.zen-cart.com/forum/showth...ificate&page=3 and link, has 'shipping_tax'=>0, before 'tax' => 0, not viceversa as in your file. I am not sure if this makes any difference.
2. admin\includes\functions\extra_functions\super_orders_functions.php has a fair bit of interaction with COWOA (Check Out With Out Account) but so far I have not encountered any problem.
Cheers
You're welcome.. My clients seem to like this new version better..
Regarding item 1 - I used the includes\classes\order.php from the default Zen Cart zip file. You should be merging this file with your own includes\classes\order.php file which is why this file is in a separate folder from the rest of the Super Order install files.
Regarding Item 2 - I can say I have tested this new version with a number of modules and have had no issues.. (COWOA was not one of these tested modules as I prefer Numinix's Fast and Easy Checkout mod) I only tested those modules I would be using for my own clients.
Whoo hoo!!!!:clap::clap: As of Mon 2/15/2010 4:47 AM Ver 2.0 (Rev 48) was finally approved by Zen Cart admins!! It's now available in the Zen Cart downloads section!!!
Now that Rev 48 is available in the downloads section I wanted to point out two MINOR changes I will be making to the module package (minor changes meaning these items WILL NOT stop Super Orders Ver 2.0 (Rev 48) from functioning).. I will submit a modified package with these MINOR fixes included as soon as my time permits.. (Next week or 2.. I promise:smile:) In the meantime I wanted to share these changes with the community so that you can modify the Super Orders Ver 2.0 (Rev 48) files yourself if the spirit so moves you.
The first change is VERY MINOR (see quoted post below) - there are some artifacts that inadvertently were included in the zip file and a typo in the readme document.. (Thanks to TonyBenedetti for bringing these "nits" to my attention :smile: -- I totally appreciate your eye for detail!!).
The second item is also VERY MINOR.. It merely corrects an issue that will only affect those using Authorize.net or the Credit Card - Offline Processing payment modules. I have included the FULL details for the fix (see quoted post below).
Can I safely said that super order work well with fast and easy checkout mod by Numinix?
Is a Sequence in installation of modules, and any php files needed to changes, I saw there are php files using the same name.
Can anyone advice me, I am very new with zen cart. Thank you.
I already stated that I had no problem getting this version of Super Orders to work with FEC. Not sure what else you are asking here..
Anytime you install modules, you should backup your store, and using a tool like Winmerge or Beyond Compare, merge any common files between the module your store..