Hi,
Is there anyway for Super Orders to automatically update paypal and credit processed orders instead of having to go to add payments when the payment is authorized?
Thanks.
Printable View
Hi,
Is there anyway for Super Orders to automatically update paypal and credit processed orders instead of having to go to add payments when the payment is authorized?
Thanks.
IF you are using Super Orders v1.3.9 (This is the version dated Jul 05 2010 by That Software Guy) you will need to make a minor update to your Super Orders files to use it (Super Orders) with Edit Orders v3.0 Rev 1.
I will submitting a minor update to Edit Orders v3.0 Rev 1 to include the required Super Orders patch. If you need this patch before this update is activated in the downloads section you may PM me and I will provide you with instructions on how to get the Super Orders v1.3.9 for Edit Orders patch.
Note:
This Super Orders patch will NOT be required when Super Orders 3.0 is released.
Super Orders already creates a Super Order payment record when paid via Authorize.net or Linkpoint. Auto payments for PayPal paid order will be a part of the upcoming release.. (should be coming out in the next week or two..)Quote:
Originally Posted by kenny724
If you can't wait for the new Super Orders release, there are a few posted hacks for adding auto-payment for PayPal orders posted in this support thread.
Zen Cart Version 1.38a Original Install
Addons/Mods: Monthly Sales Report / Custom Skin
Just installed Super Orders Version 2.0 Rev 48
I receive the following SQL error:
1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO s2tj_so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]
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.
It appears taht Super Orders is installed as the menus appear in my Admin section.
The problem is that when a customer checks out they receive the follwing error:
1146 Table 'analogal_e0NzDze.s2tj_so_payment_types' doesn't exist
in:
[select * from s2tj_so_payment_types where language_id = '1' order by payment_type_full asc]
The customer does not receive an order confirmation, but the transaction is passed through to Authorize.net and is succesfully processed and captured. Zen Cart does not record an order for the transaction.
Please advise.
I just noticed that on the admin screen, I do show that I have pending orders from recent orders but when I click on pending orders nothing shows up. There are no records being displayed for these orders.Quote:
Originally Posted by free_roller
Update: I have removed all options from Admin/Localization/Payment Types other than the items I will actually accept at the store. These has allowed for a succesfull checkout and succesfull logging of the orders.Quote:
Originally Posted by free_roller
Do we know why this needed to be removed? Any idea how to recover the orders that are still registering as pending? Or how to reset the counter so I do not show any pending orders?
If this works for you fine, but I suspect that this will lead to other issues.. There are parts of Super Orders which will function incorrectly with certain payments types no longer in the payment types tables.Quote:
Originally Posted by free_roller
They DON'T need to be removed.. and as I stated, removing these default payment types (especially the credit cards) will cause OTHER issues with Super Orders.. Based on your initial post it sounds as if you ran the Super Orders SQL twice, and that may be where you issue began..Quote:
Originally Posted by free_roller
I cannot say much more on how to fix your situation or why it happened since I cannot see your store files), and your database tables to see EXACTLY what was created (because without seeing this stuff I would be GUESSING)
Super Order is a STRAIGHT FORWARD install. If the files are uploaded to the correct locations, the required core files are properly merged and upload, and the SQL is run via the Zen Cart SQL script feature, then it should all just WORK..
I STRONGLY suggest rolling back everything.. Remove all the Super Orders files, runt he uninstall script.. Then VERY carefully using your hosts mySQL admin tools make sure there are no stray SO tables in the wrong place in your database.. THEN re-install Super Orders and re-runt he SQL script.. One last thing..
That said.. Folks always groan when I give this kind of advice.. That's because people tend to like answers that have QUICK solutions..
You have a BIG problem so it requires a CAREFUL solution.. DON'T try to shortcut these steps.. You can spend TWICE as much time trying to make a quick fix work than it would have taken had you just followed the longer path..
Again without seeing what your orders actually look like inthe store and from the DB, I am guessing..Quote:
Originally Posted by free_roller
That said you can try using amod like "Login As Customer" and login as your customer and see if those incomplete orders can be found.. You can then complete the sale.. (use something like check/money order for the payment) this way the order will finalize and be seen in the store admin.. BTW, not to be a nag, but if you go this route and use the "Login As Customer" mod, specific questions regarding the "Login As Customer" mod need to be directed to the "Login As Customer" support thread..
HTH..
Quote:
Originally Posted by free_roller
Quote:
Originally Posted by DivaVocals
First and foremost, thank you for your thoughts and suggestions.
I think you might be correct in the idea that the SQL queries were done twice. I initally uploaded the file as per typical install Admin/Tools/Install SQL Patches. Upon uploading nothing was returned (no confirmation of updated records or change in the screen of any sort). I repeated this and was greeted with an error of a duplicate value (if I recall it had to due with a value for CA). No worries, I would try to roll back the installation and see what happened...not so easy. A roll back was unsuccesfull and I was greeted with errors that referenced that the requested tables were not found.
Any further instructions for a clean uninstall?
Based on this, I would say it sounds like you have an incomplete/incorrect Super Orders install and that is the reason for the issues you are having.. You can try running each line of the uninstall SQL individually until you get everything backed out..Quote:
Originally Posted by free_roller
The entire part of the uninstall script under the heading
"-- Super Orders configuration group"
has to run as one script, but the individual drop and delete lines can be run one line at a time.
Once you have all the database changes backed out try re-running the Super Orders install script again..
(cue "At Last" by Etta James)
Super Orders 3.0 is READY for release.. I am just doing one last quality check, and I will have this all packaged up and submitted tomorrow night..
BIG HUGE thanks to my co-contributors JTheed and TNiemann.
BIG GINORMOUS thanks to our super eagle eyed beta tester TonyBenedetti for finding all those very small and very BIG gotchas!!!
Change Log - v3.0 Rev 1
- Clean up and reorganize the readme file (again!!!)
- MANY misc bug fixes and corrections
- Overall cleanup of the files to remove deprecated and unused code
- Countries now included as search option in "Batch Form Printing" and "Batch Status Updating"
- The "Edit Status History" feature has been restored and the functionality modified. Editing of order comments is now limited to hidden "admin only" comments. Additionally in previous versions of Super Orders the "Edit Status History" feature inserted HTML and ASCII line breaks into the database, and this ugly line break code was displayed when the customer viewed their order history from "Status History & Comments". This particular problem goes back to 2006, and has now been FULLY resolved/addressed.
- Customer comments modified to incorporate the latest Zen Cart 1.3.9 functionality/format
- Packing slip images are now a simple on/off admin configurable option.
- Batch print functionality has been expanded to include PDF invoices!! Options for the invoices are admin configurable
- Split orders has been improved to help shopowners easily reconcile a split order. Creates a parent and child order. Paid split orders will display the grand total paid for both parent and child order. For orders paid via PayPal, Authorize.net or Linkpoint, the admin payment panel will not display on the child order.
- Order total and customer address edit features have been removed in their entirety. (use Edit Orders if you need order/customer address editing functionality)
- Added missing shortcut icons on the orders listing screen. Now there is a corresponding shortcut icon on each order line that matches the buttons that appear in the sidebox.
- Restoration of missing default Zen Cart orders.php functionality. This now allows payment processor generated (PayPal, Authorize.net or Linkpoint) refunds to now be processed within Super Orders. (no longer requires the retention of the default orders.php to process PayPal, Authorize.net or Linkpoint refunds)
- AUTO PAYMENT FOR ORDERS PAID VIA PAYPAL!!!!!!! 'Nuff said...
- Improved graphics and buttons to SPRUCE UP the Super Orders UI
- If you have Edit Orders installed, you can enable Edit Order in the Super Orders admin to enable Edit Orders buttons in Super Orders (No code merging required.. Simply install Edit Orders and "turn on" Edit Orders in the Super Orders admin!!)
- If you have Ty Package Tracker v3.0 installed, you can enable the Ty Package Tracker fields for Super Orders (No code merging required..) Simply install Ty Package Tracker and "turn on" Super Orders from the Ty Package Tracker admin!!)
- If you have USPS Click-N-Ship installed, you can enable USPS Click-N-Ship in the Super Orders admin to enable USPS Click-N-Ship fields/buttons in Super Orders (No code merging required.. Simply install USPS Click-N-Ship and "turn on" USPS Click-N-Ship in the Super Orders admin!!)
- If you have FedEx Automated Labels installed, you can enable FedEx Automated Labels in the Super Orders admin to enable FedEx Automated Labels buttons in Super Orders (No code merging required.. Simply install FedEx Automated Labels and "turn on" FedEx Automated Labels in the Super Orders admin!!)
Let me stress something here so that it's CLEAR.. With regards to the mod integration: You are NOT required to install ANY of Edit Orders, Ty Package Tracker, FedEx Automated Labels or USPS Click-N Ship to use Super Orders..
BUT...
If you are running any of these mods, you don't have to tear your hair out trying to get the correct Super Orders code merged into the Super Orders files to use these mods.. Install them as normal and TURN IT ON in the Super Orders admin (Ty Package Tracker will need to be turned on in the Ty Package Tracker admin)
In support of this new release there are updates to Edit Order and Ty Package Tracker that will also be submitted to the downloads.. (See the Ty Package Tracker and Edit Orders respective support threads tomorrow for details on those updates -- PLEASE do not ask non Super Orders related questions here..:smile:)
Lastly we are also supplying the properly merged files need for those running FEC and COWOA. (no admin flags for these mods.. simply use the provided pre-merged files for these mods)
Okay that's it.. Gotta turn in for the night.. Will post as soon as this new version has been submitted to the downloads section, and again when it is available in the downloads section..