Printable View
I installed the Quickbooks add on after Super Orders and now I can't access the Super Orders in the dropdown for Customers. I get a blank screen. I was very careful when adding Quickbooks add on not to overwrite any files and did not.
I just went back and readded all of the Superorder files but still nothing.
Any ideas?
Not sure if a link helps but I'm at ddandlamber dot com
Zen Cart 1.3.9
What error message is in your cache folder?? Blank page = Error message...Quote:
Originally Posted by ddandlamber
Doesn't sound like a Super Orders issue at all.. The Quickbook mod shares no files in common with Super Orders.. I'm afraid that issues related to the other mod can't be resolved in this support thread..
The only thing I can suggest is comparing the Quickbooks mod to Super Orders.. If there are any files these mods share in common you'll need to use a file comparison tool like Winmerge or Beyond Compare to merge those modifications together..
If that doesn't work, then you need to carefully check your Super Orders install and/or rollback to a copy of your store before you installed BOTH mods, and start by re-installing Super Orders and making sure it works before re-installing the Quickbooks mod..
I sent you an email with feedback after I completed testing. Just a few more tweaks needed and we should be good to go :)Quote:
Originally Posted by fo0bar
Just got back from the hospital.. Could you keep me in the loop too??:smile:Quote:
Originally Posted by ScriptJunkie
Check your email girl :wink:Quote:
Originally Posted by DivaVocals
Just did.. thanks!! :smile: Looks like you are on top of this..:smile:Quote:
Originally Posted by ScriptJunkie
So I'll continue with testing the rest of the module, updating the readme and wait for you and foobar to work out this part.. I'll merge your final result with the code I have and send out the "final beta" for you to test..
Sounds great! If you have a chance, shoot me an email or give me a buzz and let me know how your bff is doing :smile:Quote:
Originally Posted by DivaVocals
So I figured out why I was getting the blank screen when selecting SO from the Customer drop down. I didn't upload the Edit Orders batch for Super Orders.
Now I have a different problem. When I installed the patch I got this message when uploading the SQL:
1 statment ignored. See "upgrade_exceptions" table for additional details.
Now I get the SO screen; however if I click on the details of an order I get this message:
1146 Table 'ddandlam_znc1.TABLE_CUSTOMERS_ADMIN_NOTES' doesn't exist
in:
[select * from TABLE_CUSTOMERS_ADMIN_NOTES where customers_id = '8']
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 help!
applied fixes to my shonky code - sent an email with the new file. Sorry about the novel - just explaining some technicalities.Quote:
Originally Posted by ScriptJunkie
i'm not going to post the code here until i know it tests out ok :)
Short answer, you've got a version of the super_orders.php that is NOT included with the Super Orders v3.0 fileset..
Quick search of this support thread turned up this information:Quote:
Originally Posted by ddandlamber
Quote:
Search: Keyword(s):
TABLE_CUSTOMERS_ADMIN_NOTES
Forum: All Other Contributions/Addons 23rd April 2011, 08:47 PM Replies: 408
Sticky: Super Orders v3.0 Support Thread
Views: 13,986
Posted By ddandlamber
Re: Super Orders v3.0 Support Thread
So I figured out why I was getting the blank screen when selecting SO from the Customer drop down. I didn't upload the Edit Orders batch for Super Orders.
Now I have a different problem. When...
Forum: All Other Contributions/Addons 4th March 2011, 09:01 AM Replies: 408
Sticky: Super Orders v3.0 Support Thread
Views: 13,986
Posted By DivaVocals
Re: Super Orders v3.0 Support Thread
Was busy last night.. Didn't get your PM until this morning.. I'm at work and I can't look at this here.. but I do have a few observations/suggestions:
The files in the SO3 fileset DO NOT contain...
Forum: All Other Contributions/Addons 4th March 2011, 07:58 AM Replies: 408
Sticky: Super Orders v3.0 Support Thread
Views: 13,986
Posted By Rizla
Re: Super Orders v3.0 Support Thread
The call for TABLE_CUSTOMERS_ADMIN_NOTES is comming from the admin/super_orders.php that is INCLUDED with the FEC module from the Numinix site.
How should I proceed with this as my PHP is...
Forum: All Other Contributions/Addons 3rd March 2011, 09:13 AM Replies: 408
Sticky: Super Orders v3.0 Support Thread
Views: 13,986
Posted By DivaVocals
Re: Super Orders v3.0 Support Thread
I'm at work so I can't look at the fileset from here.. But all of that admin notes code was removed from SO3. So I'll have to take a look when I get home and see if there is a remnant I'm unaware of...
Forum: All Other Contributions/Addons 3rd March 2011, 08:18 AM Replies: 408
Sticky: Super Orders v3.0 Support Thread
Views: 13,986
Posted By Rizla
Re: Super Orders v3.0 Support Thread
Arrrgh HELP!
SO3 was working great on my live site with test customers.
Just got my first real LIVE order and going into SO I got the following:
1146 Table...
and actually if it tests okay we'll add it to the codebase so no need to post at all!!:smile:Quote:
Originally Posted by fo0bar
No worries about a long email - detail is very much appreciated :)Quote:
Originally Posted by fo0bar
Looking forward to testing these latest changes :)
Once again, thank you for your hard work! I believe that your changes will benefit everyone in the community who uses this mod :)
Hey again, just noticed this a moment ago. But, is there something I'm missing from HTML Emails where no line breaks are?
Running 1.3.9h Just installed Super Orders 3.0. Ran the SQL code. All of my customers are intact, however all old orders are 'missing' One New one shows up, but no old orders are there. What did/didn't I do and how do I fix it??
Thank you!
-Andrew
[email protected]
www.burkesfinemeats.com
Don't know what you did.. SO3 adds two new columns to the orders table, but it wouldn't "remove" orders from the orders table.. Though that said I'm not entirely sure what you mean by orders missing..Quote:
Originally Posted by andrewbrk1
As suggested on page 1 of this support thread, it might help if you provided some details on HOW you installed SO.. it's not enough to know that you "copied the files over and ran the SQL" -- need to know WHICH files you copied over, WHICH SQL file you ran, and is this a NEW install or an UPGRADE.. If it is an upgrade from which version are you upgrading??
Sorry for the vagueness.
By missing I mean they do not show up under orders. The only one that shows up is one that came in AFTER I updated. HOWEVER, I CAN click back and see the others if I 'start' from the one that shows up and click to previous orders (Under Super Orders:Details: Jump to order).
I renamed to match my admin folder the folders in '1_Install_Files' , '2_Required_Core_Edits' and '3_Optional_Files'. I ftp/overwrote them to my store directory. I then copied, and pasted into Admin:Tools:Install Sql Patches the code from 'super_orders_install_v30.sql' and executed it. There were no errors.
It seems to work fine with the one order that is there, i.e.; print, edit, etc. Just don't see the previous orders.
Example, When I click on one of the 'New Orders:' from the main Admin screen, no matter which customer I click on, it takes me only to the one new one.
I can provide ftp/login access if that would help you in any way. I appreciate any help you can give... I have reviewed the install directions repeatedly and can't see what I did incorrectly...
Thank you
-Andrew Burke
Running 1.3.9h Just installed Super Orders 3.0. Ran the SQL code. All of my customers are intact, however all old orders are 'missing' One New one shows up, but no old orders are there. What did/didn't I do and how do I fix it??
Thank you!
-Andrew
[email protected]
www.burkesfinemeats.com
Sorry for the vagueness.
It was a fresh install.
By missing I mean they do not show up under orders. The only one that shows up is one that came in AFTER I Installed. HOWEVER, I CAN click back and see the others if I 'start' from the one that shows up and click to previous orders (Under Super Ordersetails: Jump to order).
I renamed to match my admin folder the folders in '1_Install_Files' , '2_Required_Core_Edits' and '3_Optional_Files'. I ftp/overwrote them to my store directory. I then copied, and pasted into Admin:Tools:Install Sql Patches the code from 'super_orders_install_v30.sql' and executed it. There were no errors.
It seems to work fine with the one order that is there, i.e.; print, edit, etc. Just don't see the previous orders.
Example, When I click on one of the 'New Orders:' from the main Admin screen, no matter which customer I click on, it takes me only to the one new one.
I can provide ftp/login access if that would help you in any way. I appreciate any help you can give... I have reviewed the install directions repeatedly and can't see what I did incorrectly...
Thank you
-Andrew Burke
What you need to do is do a backup of your store before you installed SO. After that check to make sure your old orders are there. Re-install SO making sure you do not over write any other files that this module is using with core files. Use a program like WinMerge to compare files with the core file that SO is using. See what happens after that. Take your time a lot of misstates happen when people rush to install a module.:yes:Quote:
Originally Posted by andrewbrk1
I did a backup of the entire store and the SQL. As I stated, the orders ARE there... If I look at the one order that came in AFTER I installed, I can browse back and see/edit/print the others. That is from the Super Orders Side. If I click on a customer from the main Admin page, they do not show up.
I am on a Mac, so I can't use WinMerge, However I DID use Apple File Merge and do not see anywhere that I overwrote a key file/function/issue.
Stumped.
-Andrew Burke
burkesfinemeats.com
I think this should be a fairly easy one.................Okay, in /MyCustomAdminFolder/super_packingslip.php, line 222:
....displays the Model Numbers in their column.Code:<td class="dataTableContent" valign="middle">' . $order->products[$i]['model'] . '</td>' . "\n" .
What I need to know is, can this line also be manipulated to "Order by model ASC", to make these list alphabetically by model number.
Any ideas?
Just an FYI... Solved my 'problem'. It appears Super Orders only shows orders labeled as 'Processing'. On my past orders, I would change the status to 'Update' to send people the tracking # of their order once shipped. I set a few of them back to processing and they showed up. Is this a bug or a feature?Quote:
Originally Posted by andrewbrk1
Thank you
-Andrew Burke
www.burkesfinemeats.com
I'm totally not clear on where you are "missing" or not seeing orders.. When you go to Customers > Super Orders are your orders there or not??Quote:
Originally Posted by andrewbrk1
If they are, then are you speaking of the MAIN Zen Cart admin page is where you are "missing" orders??? A screenprint of what you are seeing would really help..
Since I am really unsure where you are not "seeing" orders, I thought I'd add this..
Zen Cart by default displays the last 5 orders received on the admin home page regardless of status. (see screenprint below) the Super Orders module DOES NOT MODIFY this default Zen Cart behavior.
So if it is indeed the Zen Cart admin home page that you are referring to, then it sounds like you have made modifications to your /YOUR_ADMIN/index.php. This is not something installing Super Orders would have caused. But again, I'm not clear on where it is you are not seeing orders.. (better details and screenprints would help) I am presuming based on your posts that the Zen Cart admin home page is what you are speaking of..
http://i54.tinypic.com/11k9n3m.png
Quote:
Originally Posted by DivaVocalsI'm totally not clear on where you are "missing" or not seeing orders.. When you go to Customers > Super Orders are your orders there or not??Quote:
Originally Posted by andrewbrk1
If they are, then are you speaking of the MAIN Zen Cart admin page is where you are "missing" orders??? A screenprint of what you are seeing would really help..
Andrew,
If you are on a Mac, there are two good utils I use for file compares: Kdiff3 and Diffmerge. Diffmerge can also be linked into Dreamweaver so you can compare with remote files.
Oh, and both are free if I remember correctly.
-cj
Hey DivaVocals,
I see that you have a Purchase Order feature in SuperOrders. Was wondering if it would be possible to put this into the checkout process.
We've been using the Purchase Order contrib to do this. For us, our customers know the PO at time of order submission, and having that available at checkout is really handy.
From what I see of SO3, you would have to enter the PO from within the admin as an additional step.
Would it involve much editing to add PO to checkout in SO3?
Thanks,
cj
I was referring to the Super Orders window under Customers:Super Orders It was not showing ANY orders. HOWEVER... I went back into the older orders, changed the status from 'Update' to 'Processing' and they now show up. Very odd.Quote:
Originally Posted by DivaVocals
Additionally, under the 'Zen-Cart' Admin 'Main Screen' (The one you refer to in your screenshot) It DID show the past orders, HOWEVER, no matter which one I clicked on, it went only to the one that was generated AFTER the install of Super Orders.
Nonetheless, All seems to be working fine now, and as a side note, LOVE the additions you have done... Very cool!
http://www.burkesfinemeats.com/screen.tiff
CJ,Quote:
Originally Posted by chadderuski
Thank you... I will check those out... Should be a big help in the future.
Thanks!
-Andrew
I'm not inclined to think that your issue is TRULY resolved..
The behavior you describe is NOT AT ALL what should happen if Super Orders is installed correctly.. This indicates to me that something went wrong with your install.. I suggest you take CountryCharm's original advice, and roll your store back to a state BEFORE you installed Super Orders.
Then try installing Super Orders again..
Quote:
Originally Posted by andrewbrk1
Haven't looked at this, and if the current PO module that comes with Super Orders is not capturing POs at checkout time, then I'm sure it could be done. Off the top of my head (I'm at work) how Super Orders links the P.O. to payments is what MIGHT (again I haven't looked at this yet..) make this change well over my paygrade to look into.Quote:
Originally Posted by chadderuski
Remember that Super Orders was a custom module Blindside developed for HIS client. They may not have required the collection of PO numbers (if this is indeed how this works) at checkout, and instead entered them in after the order was placed.
Once they received payment, Super Orders allowed them (at the time they create the Super Orders payment record) to link the PO to the payment (or payments).
This is VERY useful functionality that should be retained if a change is required to achieve what you are asking for..
Quote:
Originally Posted by Get Em Fast
Hmmm...........is this not as easy as I was thinking? I know I've been working on a solution to no avail.
Yep looked at this earlier today.. I'm stumped too..Quote:
Originally Posted by Get Em Fast
The issue you are having is that the sort order of the super_invoice.php and super_packinslips.php are not controlled in these files (and the Super Orders versions work EXACTLY like their default cousins)Quote:
Originally Posted by Get Em Fast
Try searching the forum for:
Search: Keyword(s): sort, packingslip, model
I found three threads that look promising.. Good luck..:smile:
Ahhh...........better key words.............that's all I needed. Thanks Diva!
Anyway, if anybody else ever needed this done, Admin/classes/order.php, find
line 121 and change to:
order by products_model
You are very welcome.. :smile:Quote:
Originally Posted by Get Em Fast
So now that I looked at the mod I THINK you are using (there are several PO add-ons), I don't completely understand your question..
The workflow supported by Super Orders' currently included PO module is the standard practice used by most businesses who issue POs and businesses who accept POs..
- Invoice/Estimate received
- Invoice/Estimate is routed to customer's accounting department
- Accounting issues PO
- Customer provides PO data to vendor
- Vendor processes the order
- Vendor bill customer
In the standard flow, vendors do not receive POs until AFTER an order has been placed. The reason is simple. Their customers generally need to get the final total and an invoice/estimate from the vendor that they will route to their accounting department BEFORE issuing a PO to a vendor. (unless it is a blanket PO being issued - meaning it will be applied to multiple invoices until the PO is out of funds, and a new blanket PO will be issued).
Your workflow assumes that the amount of the estimate is known BEFORE the order is placed.. This is not a standard accounting workflow with regards to POs and their use in MOST businesses.
However, the add-on I THINK you are using captures PO numbers at checkout which seems to accommodate your desired workflow.. So I'm not sure why you think the PO module that comes with Super Orders should be updated to have the same functionality?? (capture PO numbers at checkout??)
It seems that both workflows need to be supported and there are already TWO payment modules which handle POs both BEFORE and AFTER the order is placed..
Quote:
Originally Posted by DivaVocalsHaven't looked at this, and if the current PO module that comes with Super Orders is not capturing POs at checkout time, then I'm sure it could be done. Off the top of my head (I'm at work) how Super Orders links the P.O. to payments is what MIGHT (again I haven't looked at this yet..) make this change well over my paygrade to look into.
Remember that Super Orders was a custom module Blindside developed for HIS client. They may not have required the collection of PO numbers (if this is indeed how this works) at checkout, and instead entered them in after the order was placed.
Once they received payment, Super Orders allowed them (at the time they create the Super Orders payment record) to link the PO to the payment (or payments).
Sounds like what you REALLY want is the ability to automate entering the PO record to the Super Orders IF you are using the PO add-on you currently have in place.. (Similar to the automated Super Orders payment entry for credit card payments or PayPal orders)
This is VERY useful functionality that should be retained if a change is required to achieve what you are asking for..
Quote:
Originally Posted by chadderuski
Server OS: Linux 2.6.35.8-nx
PHP Version: 5.2.17 (Zend: 2.2.0)
Database: MySQL 4.1.22-standard-log
Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2011-03-18 22:41:21] (Fresh Installation)
v1.3.9h [2011-03-18 22:41:21] (Fresh Installation)
Super Orders 3.0
Language English/Japanese
I installed successfully and am pleased but note two issues.
1) Manage Payment Types
This displays in English but does not in Japanese. The English side allows me to enter both languages. Not sure why it does not display when admin is in Japanese language.
2) Clicking the "Print" button in the "Orders Listing" page results in a new blank window being opened. No data appears in the new window.
Craig
Additinal language support for payment types does not work (never has).. No idea when this will be addressed as I understand WHAT it does, but not how to fix it.. I do have a fairly decent woraround included in the upcoming release..
As for the data sheet issue, there is a fix posted in this support thread.. Please do a search in this support thread to locate this fix.
Posted via Mobile DeviceQuote:
Originally Posted by cjcraven
Thanks for the info. Couple of other things I noticed in the Configuration of Super Orders. 4 settings, Auto Comments - Payments, Auto Comments - P.O. Payment, Auto Comments - Purchase Order, and Auto Comments - Refund, do not have settings for other languages. If you change the wording in one language then all the other languages will use the same text.Quote:
Originally Posted by DivaVocals
Super Orders is based on a custom module written for a US client. Super Orders 3 is based on this original code with improvements as noted in the readme.. Hence support for additional languages is lacking in MANY areas of the add-on.. ALL of these areas would required re-writes to support additional languages.. These re-writes are over my paygrade to tackle.. But it's open source and if a community member were to tackle this, and be willing to share it, I'd be happy to add it to the codebase..Quote:
Originally Posted by cjcraven
So it's time I contributed something to this magnificent project. I have made some code changes to make the invoice multilingual.
in YOUR_ADMIN_FOLDER\includes\super_invoice find rule 268
and replace with:PHP Code:<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
$display_title = $order->totals[$i]['title'];
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $display_title . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
' </tr>' . "\n";
$order_total = $order->totals[$i]['text'];
}
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";
?>
In the language file YOUR_ADMIN_FOLDER\includes\languages\YOUR_LANGUAGE\super_invoice.php add two definesPHP Code:<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
$display_title = $order->totals[$i]['title'];
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $display_title . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
' </tr>' . "\n";
$order_total = $order->totals[$i]['text'];
}
echo ' <tr>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><strong>'. ENTRY_AMOUNT_APPLIED.'</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>'. ENTRY_BALANCE_DUE.'</strong></td>' . "\n" .
' <td class="dataTableContent" align="right" valign="top"><strong>' . $currencies->format($so->balance_due) . '</strong></td>' . "\n" .
' </tr>' . "\n";
?>
PHP Code:define('ENTRY_AMOUNT_APPLIED', 'Amount Applied:');
define('ENTRY_BALANCE_DUE', 'Balance Due:');
Hi Diva,
Thanks for looking into this. Hope you didn't feel I was criticizing SO3's handling of PO's! I have no doubt that you are correct in your assessment of the proper handling of PO's.
I guess we have an uncomplicated relationship with our customer base. It's rather small (several thousand vendors). We are a true wholesale distributor, so we don't sell direct. Generally a customer will either FAX, e-mail or call in their order. Most if not all include a generated PO number from THEIR system. The order is entered in our ye-ole ancient IBM risc 6000 aix box, and an order confirmation is faxed/emailed back to them for validation and their actual pricing. So we end up with OUR order number and their PO number tied together. So from our point of view, allowing the customer to enter their PO # at order entry would be convenient.
I've had our website up and fully functional for years, but convincing the powers-that-be and allowing customers to login and submit orders via the website is a good thing has been a challenge to say the least.
But in other news, after years of banging away and stubborn indecision, "they" have finally made the decision to upgrade our server/enterprise software (to SAP).
So all this may be for naught as SAP has an integrated web solution far beyond what would be practical to add to ZC (like real time pricing and inventory).
I'm still excited about SO3 for other clients I have. Really do appreciate all the hard work!
-cj
Quote:
Originally Posted by DivaVocals
Not thinking you were criticizing anything.. I get that your workflow is different.. I am unclear why, if you have a PO module which allows this, did you think the one that comes with Super Orders should be modified.. I guess I'm unsure what you think is "missing" from SO3..
Quote:
Originally Posted by chadderuski
Ah, right. The two mods store and handle PO's differently. Was just looking at using one (SO3) and modifying it myself if need be to accommodate our work flow.Quote:
Originally Posted by DivaVocals
But why?? You already have a PO module which does this.. The one that comes with Super Orders doesn't REQUIRE SO3 to use..Quote:
Originally Posted by chadderuski
Now that I didn't know! I thought your PO solution was integrated into SO3!
It's just a PLAIN OLD Zen Cart payment module -- for POs.. Nothing more special about it.. It was bundled in with Super Orders because the client Super Orders was originally built for needed a PO payment module.. They still have to create a SUPER ORDERS PO Payment record once they have the PO in hand..Quote:
Originally Posted by chadderuski
From the readme:
Quote:
Go to Admin > Modules > Payment, you should find "Purchase Order" at the bottom. It should look familiar when you install and configure it, since it mimics the "Check/Money Order" module.
Re: Blank Page Orders ListingQuote:
Originally Posted by DivaVocals
Did the search then went through the 40+ pages in this forum. I found the topic on page 5, 8, and 23 but did not find a resolution. Perhaps I overlooked it - could you suggest the fix or point me in the right location??
Re: LanguageQuote:
Originally Posted by DivaVocals
Thank you, I'm just a simple shop owner and can make do with the Japanese text for these fields for now. Full language intergration is a lot of work but would be greatly appreciated.
I am not able to search for this right now.. (on a mobile device posting from a hospital)Quote:
Originally Posted by cjcraven
Search in this thread for "super_data_sheet.php".. The "Print" button prints the Super Data Sheet. I posted a fix in this support thread for that file.
Re: Payment TypesQuote:
Originally Posted by DivaVocals
The simple workaround is to create a payment type for each language with a different code. Each language has a naming and code but only one of them actually seems to work, the others become duplicates and you get a db error.
Actually that does NOT work because there is other Super Orders code (namely the code which drives auto payments for credit card payments) which is dependent on certain payment types being configured in a particular way. Additional language support in Super Orders will require some substantial re-writes to be done correctly..Quote:
Originally Posted by cjcraven
However, like I said I have a down and dirty workaround included in the upcoming release. It requires the use of a DB script to directly enter the payment types for additional languages.
Is the fix in super_data_sheet.zip? I wish you a speedy recovery and thanks for helping from the hospital!Quote:
Originally Posted by DivaVocals
Nuts, I was hoping for the simple solution.Quote:
Originally Posted by DivaVocals
Yes that was the fix! Works fine except for minor Japanese language issues. The fix is in post #55 http://www.zen-cart.com/forum/showpo...6&postcount=55Quote:
Originally Posted by cjcraven
Had SO3 installed for a while now and although only used test orders it seemed fine.
My site is beginning to receive orders and payment through paypal. However I have noticed that the payment details come through ok but the amount has not been applied automatically...
Just wondered if this is correct and I have to manually apply payment or if I have a bad install? as there is no PayPal option in the manual method.
Thanks
Several posts here already covering this topic -- quoted one of these posts for your reference..Quote:
Originally Posted by Rizla
Short answer -- Auto payments for orders paid via PayPal is not working and will be addressed in the next release..
Quote:
Originally Posted by DivaVocals
Arrh... Good news... Not me then ;))
Thanks Diva (bet I was 1.5 pages off on back posts (
I'm using Reward Points module, but, when using Super Orders to delete a Order, the points are not being deducted from the customers account.
Any feedback on this?
If I had to take a swing at a guess, I'd say that Reward Points makes changes to orders.php. Whatever those changes are in the orders.php file to support this add-on must be included in super_orders.php to work with Super Orders.Quote:
Originally Posted by leilanddale
Not familiar with Rewards Points, and the issue is very specific to how that add-on works (not truly a Super Orders specific issue).. I'm afraid you'll have to get more details on the required changes on the Reward Points support thread.
Any idea when the new version will be posted? I could have swore I read several months ago that a new version was submitted?
I am looking forward to the "No Order Payment Data Available" being fixed!
I work on this when my free time permits.. (my day job, paid projects and family obligations ALL come before free module work) Hoping that would be last week.. didn't happen.. I can't give an estimate at all except to say I am working on it (in between aforementioned higher priority obligations) and when it's ready to be released I will post the information here.. Additionally there are two other folks working on changes to this release. They also have work and family obligations that take precedence over free module development.Quote:
Originally Posted by nohart
By the way saying that "No Order Payment Data Available" needs to be fixed is not entirely accurate. Orders where there is no Super Orders payment record will display this message.. This how the software is designed to work. Once you enter a Super Orders payment, refund or PO record, this message is replaced by the payment, refund, or PO entry. I want to make sure this is clear because newbies read this support thread and I don't want anyone thinking that something is "broken" when they see "No Order Payment Data Available".
That said, if what you are ACTUALLY referring to is auto-generation of Super Order payment records for orders paid via PayPal (when the PayPal payment status -- not the order status -- is "Completed"), then YES this will be addressed in the next release.. In the meantime, you can simply add a manual payment, and the message will be replaced.
This is what she said about it.Quote:
Originally Posted by nohart
Quote:
Originally Posted by DivaVocals
:hug: You feel my pain!!!:laugh:Quote:
Originally Posted by countrycharm
and so much MORE has happened since I posted that!!! **sigh**
I thought things were a little quiet in your corner of the world - now I know why! Anything I can do to help just let me know!Quote:
Originally Posted by DivaVocals
Everyday:laugh:Quote:
Originally Posted by DivaVocals
The only quiet I have is on this forum!!:laugh: Trust me I LONG for peace right now.. :laugh::laugh:Quote:
Originally Posted by ScriptJunkie
I'll call ya.. Need to reconnect with both of you guys and get things rolling forward on this again.. We are soooooooo daggone close!!!
Ain't that the truth!!!:laugh:Quote:
Originally Posted by countrycharm
And ya know what's gonna happen, don't ya? 1.4 (2.0? Please! No death threats for mentions that!) beta will hit with a slew of changes .... mmwahahahahah!
Well, we can hope it won't be too bad! Or maybe I should say we can hope it will be real good! ;)
Well I can't worry about 1.4 until it's a reality..Quote:
Originally Posted by chadderuski
From my understanding, it's common knowledge that all mods will have to be re-written for 2.0.. So I'm not worried about either at the moment.. We'll all cross that bridge then.. If Super Orders like features aren't a part of 2.0, it's MORE likely that someone else will take the reigns of this add-on at that time.. Fairly certain that the changes required for 2.0 will be WAY over my head to mess with.. :smile:
Very silly question, but doesn't appear to be documents, and I'm daunted by all the pages of notes here. I don't want to go through the whole installation process and find I need other options.
So:-
(1) Can I export pending orders - due for shipping - to spreadsheets or other formats, for sending over to the fulfilment warehouse?
(2) Can I bulk update the customer's status of the order to show something like "At Warehouse for dispatch", when the pending orders are exported?
(3) Can I import or make a bulk update of pending or "At warehouse" (or some such notice) status to "Shipped" when I receive notification from the warehouse that the goods are en route, ideally with additional notes such as Courier ID/web site and Tracking ID?
When I mean updating it's for the customer information on their order status. Bulk updating also needing batch management to flag and track each export/update batch where needed.
If I have to handle bulk orders it will have to be outsourced and these are the key points I need to deal with.
(And apologies for appearing to duplite this post form the 2.0 version thread, didn't see this 3.0 thread until afterwards.)
:unsure:
The answers to all of your questions are in the first tab of the ReadMe file that's included with the download package. Suggest downloading the most recent version and reading the ReadMe file in its entirety to see if it will meet your needs.
OR
You could just read the very first post in this thread, which contains the highlights from the ReadMe file.
Quote:
Originally Posted by worldmaker
I bet you can find your answer here somewhere.Quote:
Originally Posted by worldmaker
Or you can read the read-me file that comes with Super order and click on the CONFIGURE & FEATURES. There are other add ons you will have to install along with Super Orders to do what you need to do. FIRST THING TO DO IS READ WHAT IT DOES, AND WHAT IT DOES NOT DO.Quote:
- 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 v3.0 installed, you can enable Edit Order in the Super Orders admin to enable Edit Orders buttons in Super Orders (No Super Orders 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 Super Orders 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 Super Orders 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 Super Orders code merging required.. Simply install FedEx Automated Labels and "turn on" FedEx Automated Labels in the Super Orders admin!!)
Ummmm doesn't appear to be documents eh?? PAGES of notes you say?? **SMH** :no:Quote:
Originally Posted by worldmaker
I do have to concur with countrycharm and ScriptJunkie.. There is a very detailed readme that comes with this add-on AND the FIRST PAGE of THIS support thread contains a TON of information as well including this tidbit:Suggest reading the information already posted here and downloading and reading the readme that comes with Super Orders. This should more than help you gain insight as to whether this add-on meets your needs.Quote:
Here's the answer to the most frequently asked question: "What does Super Orders do?"
(which BTW REALLY IS explained in detail in the readme for those who REALLY wanna know.. it doesn't hurt to download the fileset..)
We will all be happy to answer any questions NOT covered in these sources.. (but I think you will find they do indeed answer your questions..)
Quote:
Originally Posted by ScriptJunkie
Quote:
Originally Posted by countrycharm
Thanks for your advice, I had already read through all the Readme file, all the tabs, and the introduction to the module on the site here this morning.
I also searched through this entire thread.
I found no comment referring to any export management function incorporated into the mod, but I wanted to be absolutely sure I had not missed anything.
That's why I asked.
As there is no super export function I can find I'll use one of the other modules for that and get back to this when I have a few spare hours.
Thanks again.
:cool:
So I guess invoices that show everything you need an invoice to show - including account status and account notations, as well as detailed packing slips with all the info needed to fulfill an order, printing beautifully to an electronic PDF file - which can both be run in batches and physically or electronically provided to whomever is managing your bulk orders.....
I guess none of that counts as a method for exporting the data?
Quote:
Originally Posted by worldmaker
Quote:
Originally Posted by ScriptJunkie
If you put it like that then it's possible. On the other hand if the warehouse need a simple spreadsheet or DB file to merge with their system you could say "No".
I sought clarity on this specific point.
:smile:
Yes, the answer is completely dependent upon what format the warehouse needs the information to be delivered to them in.
However, your question didn't specify the format you were looking for. It only stated "to spreadsheets or other formats". So the answer is an overall "yes", and that answer can be found in the first post of this thread and also in the ReadMe that comes with the download package.
I recommend you download and install this mod, take a look at the PDFs and reports it is capable of producing and then see if it meets your needs.
Your original post said you didn't want to take the time to install this mod if it's not going to do what you need it to do. That kind of thinking is a mistake when it comes to Zen Cart and/or additional mods because often times, that is either the only or best way to determine what will work for you and what won't.
Best of luck and happy zenning :smile:
Quote:
Originally Posted by worldmaker
Thanks for the advice, but what daunted me was all the extra code editing, and I'm running out of time on my work at this end before the new launch of the product. I'll probably look into it again once all my other sites are up and ready.Quote:
Originally Posted by ScriptJunkie
Meanwhile I've loaded a mod that does exactly and only what I need, without code editing, which I completed testing overnight.
I'm sure I'll be back in a few weeks. :cool:
Let me jump in here real quick so folks reading this thread don't get the wrong idea.. There is no "extra code editing" required to install and use Super Orders.. So I assume by "extra code editing" you mean "extra code editing" to Super Orders to achieve the specific kind of order export (export to Excel spreadsheet) that you were seeking correct??Quote:
Originally Posted by worldmaker
In my reading of the instructions one midnight this week, I recall that some .php has to be cut and pasted over to achieve integration. I'd already spent a few days doing this with other modules and have no time left for more.Quote:
Originally Posted by DivaVocals
Was I wrong in this, that all Super Order .php files are unique and don't require additions to Zen files?
:unsure:
Okay, I've just had a quick peek and it appears only two core edits are required, along with all the other uploads. Might have time for that in a couple of weeks.
Much better!
:smile:
I'm not sure I fully understand your question.. (highlighed in red)Quote:
Originally Posted by worldmaker
As for "core edits" do you mean core ZEN CART files or edits to Super Orders files??
Almost six months ago,
Got the response:Quote:
Originally Posted by TonyBenedetti
But I'm seeing this problem now. Did a fix ever get posted? If so, I need to find out where I'm using old versions!Quote:
Originally Posted by DivaVocals
Iain
I've recently installed Super Orders 3 onto a fairly old ZC installation. The client saw Super Orders on a brand new setup I've done for them, and understandably wanted it on on their old site too.
But the batch print / status update search screens were not loading. It seems to be due to the customer: dropdown in the super_batch_status.php and super_batch_orders.php pages.
When I look at the database, there are about 65,000 customers of the store, which may be why the pages weren't loading. I commented this field out of the query and now it works again.
Also, I've had to increase the memory_limit from 32M because the batch print function wasn't loafing.
I'm a little worried that there may be some old files left on the system somewhere. Could that be causing these problems, or is Super Orders likely to have these problems with an established store?
Almost two days ago:Quote:
Originally Posted by hairydog
http://www.zen-cart.com/forum/showth...170525&page=47
This question is far too broad to provide any kind of definitive answer..Quote:
Originally Posted by hairydog
Sorry, misthreaded reply
I'll take that as a "no". Fair enough.Quote:
Originally Posted by DivaVocals
OK, I'll narrow it:Quote:
Originally Posted by DivaVocals
In the two search pages for batch print and batch update, is there supposed to be a limit to the number of customer IDs returned, or is the page supposed to try to build a drop-down list of all the customers on the system?
Iain
Edits to the core Zen cart files, not intention of interfering with the Super Orders documents.Quote:
Originally Posted by DivaVocals
:cool:
Hi guys.
We've been using Zen Cart for about 3 years. Finally thought it was about time we installed Super Orders 3.0. We're using 1.3.9h.
There are a few minor problems/queries I have. I've attached some screen shots to help.
1. £ syntax is showing up on PDF packing slips AND balance due is blank. See screen shot 1. This doesn't seem to happen if we generate print outs via the browser. Any ideas why this may be the case?
2. Printing order detail produces a slight error. See screen shot 2...
"1054 Unknown column 'track_id1' in 'field list'
in:
[select orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, track_id4, track_id5, comments from orders_status_history where orders_id = '17877' order by date_added]
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."
This problem is only on order detail printout pages, invoice/packing slip print out pages don't show this error.
3. Perhaps I'm being a bit stupid here but how do I access PDF invoice print outs? See screen shot 3.
I can see there are PDF packing slip option and master packing list options on the Batch Form Printing page (although the generated PDF Packing Slip actually looks more like an invoice to me).
But I can't see a specific option to creare a PDF invoice print out, is this correct?
Thanks
Answers in red..
Quote:
Originally Posted by Dunk
In the two search pages for batch print and batch update, is there supposed to be a limit to the number of customer IDs returned, or is the page supposed to try to build a drop-down list of all the customers on the system?
I'd have to look at the query, but I assume given the issue you're reporting that it is the later.. Dunno when I'll have a chance to look at this and confirm for sure.. Maybe someone else can chime in..Quote:
Originally Posted by hairydog
I installed it on an existing store, and it worked for a little while, but then the client reported that they were just getting a blank page.
When I looked into it, I think that what had happened is that the number of customers had gone past 64k - whether there is a 64k limit, or it just happened that that's when the thing timed out, I'm not sure.
Because it was retro-fitted to an old store, I wasn't sure if it is a design bug, a coding error or an installation snafu.
Removing the customer id from the query got it working again. I wonder if it would be useful if the customer list was populated only if you specified a short date range.
1. Hmm... is this a known issue? I've noticed at least two other people in this thread are having the same problem but I can't see a resolution.Quote:
Originally Posted by DivaVocals
Ignore what I said about balance due, of course it's meant to read 0.00 if we're taking payment upon placement of the order :blush:
2. Great, worked perfectly thanks.
3. OK. I understand that the packing slip is a detailed packing slip. But is there no way to generate a separate pdf INVOICE (regardless of how similar it may be to the packing slip)?
Or do most people treat the pdf master packing list as their "packing list" and the detailed pdf packing list as the "invoice"?
A few other questions that I can't find an answer to...
4. We'd like PDF invoices and packing slips to be generated when one of the admin clicks the "invoice" or "packing slip" buttons via admin > customers > super orders (effectively removing access to the browser based invoices/packing slips). Is this something that anyone has attempted to do before?
5. Is there a guide to modifying the PDF output of the master packing slip and packing slip PDFs?
Thanks!
Just out of interest does the Super Orders PDF function *replace* the PDF order centre mod that is available.
I noticed PDF order centre hasn't been updated since 1.3.8 although we tested it briefly on 1.3.9h yesterday and it seemed fine.
No it does not replace the pdf order center. They work fine next to each other. I am us both myself on 1.39h
I use POC mainly for printing invoice, packing slip and shipping labels
Answers posted below..
Quote:
Originally Posted by Dunk
As the lead post of this support thread and the readme states, Super Orders was only meant to "replace" the default Zen Cart orders management.. PDF Order Center is a completely separate module..Quote:
Originally Posted by Dunk
Thanks,
I ask because we need a detailed PDF packing list with no prices on it. 1 per order.
We also need a PDF invoice generating that contains prices and tax information.
As far as I can tell there's no way of producing both using the standartd install of Super Orders? Am I correct?
never mind....
I installed both order edit and super orders and then uninstalled Super Orders and now all I get in the admin is a blank screen (store side works fine).
I deleted all new SO new files and restored backups of edited core files. I ran the uninstall sql which broke at the point of "comment out the fax info...". I reran the sql at the point past that error, leaving the fax define in place.
This is very troubling because without any error messages, I can't troubleshoot. I have no idea why restoring my files to a pre-superorder/edit order configuration shouldn't fix the problem. Any ideas or thoughts? When I try to log into the admin from a fresh browser window and a cleared cache, it's still the same whit screen. Not even asking for my zencart admin id and password.
I'm stumped.