in the admin console, under LOCALIZATION, youll find PAYMENT TYPES
you can add/delete payment types and refund types from there.
Printable View
well iv looked at all these files, and checked it all,
everything seems ok. Both the files you reqested i look at are identical to those that come with the zc install fileset. so they are unchanged.
is there anything else i can try?
its a drag having to del a comment and re-do it, just to make an edit..
thanks again. if you can think of anything, please let me know.
it works fine, as long as i dont try and edit it. thats when it gets all messed up.
---------------------------------------------
Extra NOTE:
I have a customized super_orders page now. It has the Info at a Glance contrib on it, as well as the USPS AUTOFILL contrib.
Search through the USPS Autofill contrib support thread and he has it posted right there for you to see. i also posted it in the info at a glace thread.
Just so you guys can take advantage of it too.
I am willing to let absolute look at my admin side , if its going to be any use for you , to help fix the batch e-mail thing. my cliemt really needs this to work , as he has 40+ orders a day . if it needs some money thrown at it let me know.
here is a link to the authors post.
http://www.zen-cart.com/forum/showpo...8&postcount=15
basicly, there are two files in there. both have the USPS click-n-ship autofill contrib, and the other overlib has the info at a glance.
NOTE: you must already have both these mods installed in order for this to work. all we are doing is adding them to super orders. for more info, contact the author
Bolded part has me curious. Are you using one of the admin levels modifications, which allow/deny access to various admin pages? That could very well be the issue. You need access to several files in order for the e-mail to go through. Here's a list...
- admin/includes/languages/english/super_orders.php
- admin/includes/functions/extra_functions/super_orders_functions.php
- admin/super_batch_status.php
I don't use any of those admin level mods, so I have no diea how SO will behave with them. Any way to disable it and then try again?
It's creating the record, but not storing the proper values (the table defaults to all 0's when no value is added). Did you place the code from README step Edit the order.php class (catalog side) after the indicated line? it must go after
The result you're seeing is possible otherwise.Code:$insert_id = $db->Insert_ID();
Admin > Localization > Payment Types
Like wickedclown said, I have code to automate PayPal payments made at checkout for the next version. If you're feeling adventurous, here's the code for the modified function. Just replace the entire function as it exists in [catalog]/includes/class/super_order.php...
I'd also like to hear from those of you who use PayPal extensively (I don't at all). What other stuff can I do here to make this more useful?Code:function cc_line_item() {
global $db;
// first we look for credit card payments
$cc_data = $db->Execute("select cc_type, cc_owner, cc_number, cc_expires, cc_cvv, date_purchased, order_total
from " . TABLE_ORDERS . " where orders_id = '" . $this->oID . "' limit 1");
if ($cc_data->RecordCount() ) {
// collect payment types from the DB
$payment_data = $db->Execute("select * from " . TABLE_SO_PAYMENT_TYPES . "
where language_id = " . $_SESSION['languages_id']);
$cc_type_key = array();
while (!$payment_data->EOF) {
$cc_type_key[$payment_data->fields['payment_type_full']] = $payment_data->fields['payment_type_code'];
$payment_data->MoveNext();
}
// convert CC name to match shorthand type in SO payment system
// the name used at checkout must match name entered into Admin > Localization > Payment Types!
$payment_type = $cc_type_key[$cc_data->fields['cc_type']];
$new_cc_payment = array('orders_id' => $this->oID,
'payment_number' => $cc_data->fields['cc_number'],
'payment_name' => $cc_data->fields['cc_owner'],
'payment_amount' => $cc_data->fields['order_total'],
'payment_type' => $payment_type,
'date_posted' => 'now()',
'last_modified' => 'now()');
zen_db_perform(TABLE_SO_PAYMENTS, $new_cc_payment);
}
// now look for PayPal data
$pp_data = $db->Execute("select * from " . TABLE_PAYPAL . " where zen_order_id = " . $this->oID);
if ($pp_data->RecordCount() ) {
$new_pp_payment = array();
while (!$pp_data->EOF) {
$name = $pp_data->fields['first_name'] . ' ' . $pp_data->fields['last_name'];
$new_pp_payment[] = array('orders_id' => $this->oID,
'payment_number' => $pp_data->fields['txn_id'],
'payment_name' => $name,
'payment_amount' => $pp_data->fields['mc_gross'],
'payment_type' => 'PP',
'date_posted' => 'now()',
'last_modified' => 'now()');
$pp_data->MoveNext();
}
foreach ($new_pp_payment as $key => $payment) {
zen_db_perform(TABLE_SO_PAYMENTS, $payment);
}
}
}
Blindside,
can you please help me to find out the problem with my order status comments box.
I really need to find a fix for it
I have posted in the general forum hoping that maybe someone would have an idea, or maybe went through the same problem, and found a fix.
any help would be great at this point.
thanks man
a man in desperate need of help :)
benjamin
Yes BS,
I checked to make sure i had that SO code below the indecated line, and i do. i fallowed and double checked the edits before i came asking about the problem..
thanks man
(The following is from a PM)
The first issue sounds like you have run and rerun the SQL file over your DB. The so_payment_types is a new table that SO installs, so it would only find it if you had already run the script. UNless you know what the initial error was, your best bet is to restore from your DB backup and try again. I recommend that you use phpMyAdmin instead of the Zen SQL installer.Quote:
Originally Posted by frank_lyy
The second may or may not be related. Look at the table name: wwwlin5_zc1.orders. In the first error, you have a table prefix (zen_), and here you have none. Restore from your backup, go through the entire file to add your DB prefix (if you do, in fact, have one), and run the file again.
@wickedclown
Okay, so here's the situation as I see it...
- The order status does update from the order details page
- The order status also updates from the batch page
- You can successfully e-mail your customer on a status update from the order details page
- You CANNOT send the same e-mail from the batch page
Super Orders uses a single function -- email_latest_status() -- to e-mail order status updates regardless of where they originate. That fact, combined with the list above, means that the problem resides with the batch file's call to this function.
I should have asked earlier, but what version of PHP are you using? I'm wondering if the syntax that calls this function is not the problem. Open admin/super_batch_status.php, and go all the way to the bottom, find this line...
Note the lack of curly braces { }. I want you to add those braces so it looks like the following...Code:if ($notify == 1) email_latest_status($oID);
Then, as a precautionary measure, lets make sure that $notify is actually being set properly. Go back to the top of the page, and find this line...Code:if ($notify == 1) {
email_latest_status($oID);
}
Let's define this so that it's set as a variable type int, like this...Code:$notify = $_POST['notify'];
Based on all the information you've provided, that's about the only possible cause; it must be somewhere in the code that actually calls the email_latest_status() function within super_batch_status.php.Code:$notify = (int)$_POST['notify'];
If you still have the issue after these steps, trying echo'ing out the $notify variable both outside and inside the batch_status() function. It would look something like this...
That may tell you more about what is being (or not being) passed. If that doesn't make sense, or the thought terrifies you, just report back what happened with the code changes.Code:// DEBUG
echo '<br />' . $notify . '<br />';
blindside, you think that its the code for emailing that is the problem? it seems that the emails are fine- iv not had an issue with them, its the order status comments in the catalog side, and the admin side.
Do you still believe that i should do this edit? it looks to me like its to fix the batch email..... i dont really use the batch system that offten unless to print. which has seemed to work just fine.
please advise... thanks
Dear Blindeside,
This might be the longest post on this thread. Please bear with me, for I really want this Super Order mod to work in my cart.
I did everything like you suggested, here is the details on my actions and problems that followed:
1. Tried to restore my DB backup both by using DB-Backup MySQL (by DrBite) from Admin and PhPmyAdmin on my server. Both methods seemed working fine. But, I noticed that there are four fields "zen_so_payment_types", "zen_so_payments", "zen_so_purchase_orders","zen_so_refunds" which seemed did not get erased during DB restore. So, I dropped them by using PhPMyAdmin. Now, I am ready to re-run super_orders_sql.sql
2. Tried using PhPMyAdmin upload super_orders_sql.sql and got the following:
Error SQL query:
-- EDIT EXISTING TABLES
ALTER TABLE orders ADD date_completed datetime default NULL
MySQL said:
#1146 - Table 'wwwlin5_zc1.orders' doesn't exist
3. Restored my DB and tried to upload super_orders_sql.sql by using Install Sql Patch from Admin, then got the following:
1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'True', 'False'), ')' at line 1 in:
[INSERT INTO zen_configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array('True', 'False'), ');]
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.
4. Did not restore DB, and try upload super_orders_sql.sql again by using Install Sql Patch, then got the following:
1062 Duplicate entry 'CA' for key 2 in:
[INSERT INTO zen_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.
5. Tried to run Fresh_install.sql in Ty_Package_Tracker contrib using PhPMyAdmin twice and got the following:
Error SQL query:
SELECT (@tyid := configuration_group_id) AS tyid
FROM configuration_group
WHERE configuration_group_title = 'Ty Package Tracker'
MySQL said:
#1146 - Table 'wwwlin5_zc1.configuration_group' doesn't exist
6. Tried upload Fresh_install.sql in Ty_Package_Tracker contrib using Install Sql Patch from Admin. Guess what, it worked!!! And I noticed that the four fields I dropped before were back, which are "zen_so_payment_types", "zen_so_payments", "zen_so_purchase_orders","zen_so_refunds".
My concerns now are:
Are there any relations between Super Order mod and Ty_Package_Tracker mod? It seemed that Ty_Package_Tracker added "zen_so_x_x" fields.
Are there any thing wrong with PhPMyAdmin settings on my server side? Nonetheless, it seemed that PhPMyAdmin can run my DB backup sql file ok.
Here are some of my server info:
MySQL 4.0.27-standard
Server OS: Linux 2.6.9999-MIDPHAZED-410a66d10418e44a615e653ff4a8476e
HTTP Server: Apache/1.3.34 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.10 FrontPage/5.0.2.2635 mod_ssl/2.8.25 OpenSSL/0.9.7a
PHP Version: 4.3.10 (Zend: 1.3.0)
Database Host: localhost
If you need more of my server info such as PHP settings, I can always run techsupp.php in zc_install folder and post those settings here.
Thank you for all your help in advance!
Sincerely,
Frank
Hello!
The more i check out this contribution, the better i realise it is! Great work :cool: !!
I am having a problem with the display of the payment date and time for Paypal payments, however, and am hoping someone can help me. Nothing to do with a probem with the code, just a setting that is wrong for my set up...
Basically i have a UK PayPal account but on the Super Orders page it shows the Paypal payment date in US format and the time in presumably a US time zone. Is there anyway to change this to show UK date and time of payment???
Thanks in advance :D .
\
YES, TY does have releate back to super orders for editing, IF you instruct it to. for that reason, i would say that it prolly does have a field in the db to work with super orders.
bascily, you can set the tracking system to point you to super orders when needing to make a change to an order, rather than going to the standard order system.
Have to agree with wicked on this one, Frank. The Ty package piggybacks on SO. Do you have a backup of your DB without Ty installed? Install SO first, then Ty; and do so from phpMyAdmin.
hay Blindside, this is a feature request....
it would be nice if super orders could be able to search out model numbers with the search function.
so that you could pull up super orders, and do a search for "part28648" and it will pull up all the orders that have orderd that item.
does anyone know how i could add a .js call to the header of my super_orders.php file in the admin section?
i want to put in a call to a new .js file, similar to the one in the header of the stats_sales_report.php file. something like this:
<script language="javascript" src="includes/javascript/spiffyCal/spiffyCal_v2_1.js"></script>
i'm trying to install a date search tool that has javascript calendar function and it's not working b/c i think the .js path is missing in the header.
thanks everyone
k-
@wicked: Yeah we could see about that...
@krizzle: Umm, what about mimicking the line you copied? :happy:
Just be sure to put it in the admin/includes/javascript/ folder.Code:<script language="javascript" src="includes/javascript/YOUR_JS_HERE.js"></script>
@wickedklown et. al.
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. "Scrubbing" is the act of prepping the data for DB insert. The stock zen uses two functions -- zen_db_input() and zen_db_prepare_input() -- to complete this task. I combined the two and went a few steps further with the zen_db_scrub_in() function.
The important part for this problem is that we also do a conversion from <br> tags to newline returns (aka the br2nl() function). This process is then reversed when the status is outputted on the page (nl2br(), new lines become <br> tags again). Since the code isn't doing it on the way in, the output gets kinda screwy.
I know that it was there at some point, but it was probably edited/moved/removed and never re-added in the course of writing the file. My apologies. Here's how to fix it. Find this line near the top of super_batch_status.php...
Adjust the line to read as follows...Code:$notify_comments = $_POST['notify_comments'];
That will prevent the problem from occuring further. To correct already affected comments, go to the Orders Detail page for the affected order and click "edit status history" beneath the status history table. Edit the comments as necessary and click "Submit" (this file does perform the scrubbing correctly)Code:$notify_comments = zen_db_scrub_in($_POST['notify_comments'], true);
For those of you who do not use Admin > Customers > Batch Status Update, I still strongly recommend you perform the above fix, as not scrubbing the input leaves you vulnerable to SQL injections. Fortunately, since it's an admin file, the problem is only on the admin side, so access is extremely limited. Still, always better to be safe than sorry.
i preformed the edit as asked, however it didnt fix the problem. as i said, i dont use batch stuff, i only use super orders. So it has to be inside super orders somewhere. its still doing the same exact thing. it does bring it down to the next line, but it shows the <br/> tags at the end of each line. and under admin you see rn.
can you please take a look at SUPER_ORDERS.php and tell me what it could be that is going wrong.
im sorry that you keep thinking that my problem lies in the batch status, and your tring so hard to make it work. but i dont use that system *yet*
also, do you have a paypal account for donations for your hard work at this problem? id be glade to buy you a "cold one" for your troubles...
Dear Blindside,
I think there is a minor bug in the Super Order 2.0 Rev 45.
When I ran out of all options and kept getting following error message:
1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'True', 'False'), ')' at line 1 in:
[INSERT INTO zen_configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array('True', 'False'), ');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I went back to the download section and downloaded the older contribs on this mod. Then I used BeyondCompare and found out that this line is what caused all my troubles:
INSERT INTO configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ');
I changed it to the following based on the older versions:
INSERT INTO configuration VALUES (NULL, 'Enable Purchase Order Module', 'MODULE_PAYMENT_PURCHASE_ORDER_STATUS', 'True', 'Do you want to accept Purchase Order payments?', 6, 1, now(), now(), NULL, 'zen_cfg_select_option(array(''True'', ''False''), ');
and it solved my problem with installation.
I don't know how other people got around this line. Maybe their PHP and MySql versions are different from mine. Here is my server info:
MySQL 4.0.27-standard
Server OS: Linux 2.6.9999-MIDPHAZED-410a66d10418e44a615e653ff4a8476e
HTTP Server: Apache/1.3.34 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.10 FrontPage/5.0.2.2635 mod_ssl/2.8.25 OpenSSL/0.9.7a
PHP Version: 4.3.10 (Zend: 1.3.0)
Database Host: localhost
Anyway, this Super Order is a great module and I finally got it working in my cart.
Thanks,
Frank
Blindside: see attached picture. What did I do wrong?
How do I test it to make sure everything will run fine. Thanks so much!
Blindside: It's working. I forgot to install one file. Slap me on the head! Thanks for such a great contribution and all your work. I have not fully tested it but it seems to be okay at the moment. Thanks again :)
New problem??
I have been using super orders for a while now but am just getting a chance to try the batch status update feature to notify multiple customers who purchased a certain item.
I have used it successfully many times to update things for my info (pending to shipped, for example) and I have used the details pages to update the status AND notify the customer. Worked like a charm... :D
The problem is coming when I try to use the batch update status page to send an email notification to mutiple customers. It APPEARS to work - I click the notify customer checkbox, paste the email into the box, and update -- status update notification works.
*but* the email never goes out - :( - it *is* noted on the customer details area that the customer was _not_ notified (even though I checked for it TO notify them). Again, if I use their details page it works fine - it is only from the batch page that the problem exists.
what have I missed??? :huh:
OK, cannot seem to edit my own post... LOL. I apparently was not using correct search terms to sind what I needed -the first five times around - sorry!
I did find where this was addressed a little while back. I tried the edits to super_batch_edits which were posted.
no luck.Quote:
>>Note the lack of curly braces { }. I want you to add those braces so it looks like the following...
Code:
if ($notify == 1) {
email_latest_status($oID);
}Then, as a precautionary measure, lets make sure that $notify is actually being set properly. Go back to the top of the page, and find this line...
Code:
$notify = $_POST['notify'];Let's define this so that it's set as a variable type int, like this...
Code:
$notify = (int)$_POST['notify'];>>
You mention the debug. I am not qualified... LOL
red, some other posters mentioned this issue, and as you saw I investigated, but never heard back from them either way. I am hoping that they found the source of their issue and simply didn't post back here. I'll see if I can track them down.
Thanks! I really appreciate the mod, and if there is any kind of input you need from me to track down the problem let me know. I assume this does not happen to you on your install? :D
And I promise to post the fix here if nobody else has by then... :-)
Sorry I thought i posted last night , but now cant see my post .
All it said was :
Created brand new 1.3.5 version of Zen on my
PHP 4.4.4. server with
4.1.21 MySQL
installed the Superorders Mod , and still didn't work , made the adjustmnents to the code in the last few posts from BS , still no Joy .
Hope this info is of use to someone !
Cheers
Dear Blindside,
I am having trouble with my batch e-mail notify function of Super Order 2.0 as well and am really eager to see solutions to this problem!
e-mail options setting:
SMTPAuth
LF
MySQL 4.0.27-standard
Server OS: Linux 2.6.9999-MIDPHAZED-410a66d10418e44a615e653ff4a8476e
HTTP Server: Apache/1.3.34 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.10 FrontPage/5.0.2.2635 mod_ssl/2.8.25 OpenSSL/0.9.7a
PHP Version: 4.3.10 (Zend: 1.3.0)
Database Host: localhost
Hi,
Does anyons happen to know if Super orders runs smoothly with Dual Pricing. Please let me know if you know !
If nobody knows, I'll try it out, and try and make them work together if there are troubles and post about it in new thread if anyone is interested...
Are we getting close to a Super Orders 2.0 rev 46?
I just learned that these Super Orders 2.0 cannot edit those products with attributes and same goes to the old mod v1.3...:(
hi guys
i seem to be having an issue with editing orders.
it seems that the sub-total and the total say the same figure to begin with and then the calculations are done from that point which means the figures are all wrong.
eg: an order will say sub=20.00 vat=5.00 total=20.00 ( total and vat are correct )
- then i will edit the order say put a disount of 5.00 in.
it will then read ( something like ) sub=20.00 vat=3.50 total 23.50
it has done the sums assuming the origonal sub total was correct.
maybe its something silly ive missed, and help would be appreciated :)
just a question, kinda off topic, but how are you guys calculating the VAT totals in your order? and also why? do you pay these before shipping the package overseas? or what?
I hear alot of people calculating VAT into the total, however im unable to find the option to do so, and also wondering why it is that you calculate the VAT into the total.
any info would be great.
Thanks Bud.
Benjamin
I just install super mode but my test order got this error:
Warning: create(includes/classes/super_order.php): failed to open stream: No such file or directory in /home/httpd/vhosts/findaflorist.org/httpdocs/sendflowers/includes/classes/order.php on line 621
Line 621 is
require(DIR_WS_CLASSES . 'super_order.php');
Please help !!!:(
The "why" is easy... its the law.Quote:
just a question, kinda off topic, but how are you guys calculating the VAT totals in your order? and also why? do you pay these before shipping the package overseas? or what?
I hear alot of people calculating VAT into the total, however im unable to find the option to do so, and also wondering why it is that you calculate the VAT into the total.
Some countries require VAT to be shown included in the price when it is displayed to the customer. It is also required that the VAT be removed at time of checkout for overseas customers.
I think Germany is like that. I'm pretty sure UK is not. Canada no, netherland yes (?), etc etc.
- Steven
As a follow up...
Taxes was the reason I originally ditched SO. I promised at one point to fix it, but I never got around to it (still on the list which is why I follow this thread). It did occur to me at one point though... fix it for who? I mean, I can fix it for Canadians and anyone with the exact same taxation rules, but it won't work for Germans for example. Even for Canadians though... I'd be able to fix it for those in British Columbia (we charge federal and provincial tax independently) easy enough, but for those in Novascotia (combined tax) it would be different.
SO and taxes will always be a problem, unless the logic used in the orders.php process is mimicked exactly. That way, it will use whatever rules the customer defines. Last I checked, that was not the case.
- Steven
steven hi
was wondering if you had any thoughts on my issues above ?
Only that I had the same problems and had to stop using SO until I could figure it out, which I never did because I have 19 (18 after today if I stop looking at the forum) items on the list ahead of it. :)
Really, I would suggest you not use SuperOrders with a foreign (non-USA) tax system until/unless it has been fixed (as I said, I haven't used SO in quite some time... I just follow the forum to monitor developments because in my mind it is the single most useful mod available).
- Steven
My bad. Module work beatifully. Would recommend it.
Searching on super orders invoice font did not return any results, any idea how the font size on the invloce can be altered?
Thanks -- Ken
Solved:
The class invoiceHeading is not defined in admin/includes/stylesheet.css
One example on what to add is below:
.invoiceHeading{
font-size:13px;
font-weight:bold;
}
Keep in mind you are altering a core file and since there are no overrides in admin, it will be over-written if upgrading. You might want to document this for later ;-)
Ken
However it is defined in admin/includes/super_stylesheet.css. The super_invoice calls this custom stylesheet when it loads. Set it to whatever you like in there.
I would need better than "something like." How about an exact example of the behavior your seeing? Off hand it looks like you may be editing the wrong field in the popup. If you want to add a custom discount, use the empty field at the top. If you edit one of the fields that already has a value, that sub-total field value (shipping, tax, vat, etc) will be changed. You may also want to check the sort order in which your sub-totals are being calculated (Admin > Modules > Order Total).
My Super Orders installation seems to be working well except for the Purchase Orders module, which never showed up under Admin>Payment Modules
I have followed the readme to the best of my knowledge and read all of this thread, yes all of it, looking for the solution. I have seen the problem posted before, but no solution. I am sure that I did something stupid in the install, but would somebody please point me in the right direction?
PHP Version: 4.4.1 (Zend: 1.3.0)
Database: MySQL 4.1.21-standard-log
Thanks,
Dustin
The PO module is a drop-in. Just upload the files into the correct directory and SO's directory structure will put everything in the right place. Double check your upload and make sure it went into the right spot.
Thanks, you were correct, some files were in the wrong place. The readme states that unzipping the files in the catalog directory will lead to everything being in the right place. This correct, but I still got confused because of the second includes folder in the admin directory. Perhaps a line could be added to the readme noting which includes folder it goes in for us novices.
This is a great program, by the way, good job. I did the suggested modifications to display entire shipping service in the invoice and packing list. (UPS Next Day vs. UPS). This is important for me because I need to notice when a customer has upgraded shipping.
Thanks again!:P
When my client goes to Batch Form Print, enters search criteria, and then clicks search, she gets sent to the admin login page... so she logs in again, goes to Batch Form Print again, re-enters search criteria, and then it all works fine. I tested it, and the same thing happens to me. I've been searching the forums for batch form problems, and relogging into the admin, but I can't find anything about this problem. Has anyone else had this problem, and know what it is causing it?
Sorry if this has already been addressed and I missed it.
Hi,
I've had two people building sites with Zen Cart contact me through this forum with problems with super orders and 1.3.5...
It seems that Super Orders is interfering somehow with the address_format_id for the UK in the countries table. It appears that it changes it to 6 so that, although customers can complete the checkout process and their address details are recorded, when it comes to displaying these address details they do not show up as address_format_id 6 doesn't normally exist (unless you add it yourself). Of course this means that the order e-mails don't show the billing/shipping addresses either.
This is just a heads up for whoever writes this module, I don't use it myself and don't have the time to look into this. However two people with exactly the same setup and problem (1 at least from a completely fresh install of 1.3.5) sounds like a coincidence and I've found that rarely is there is such a thing in computing... that's normally how I find bugs! :)
Hope that is of use to someone.
All the best...
Conor
ceon
Frank, please let us know if Super Orders is compatible with ZC v1.3.6 which was just released. Thanks.
Question about "edit products" link on Order Details. When i click on this link a window (attached jpg) is displayed but there is no fields or buttons to allow me to change the item.
Please let me know what needs to be done.
Thanks.
edit products hasn't been implemented yet.. only allows for splitting the ticket at this time. the zen team is adding more fields / rewriting the product stuff, so Frank decided not to touch it until the changes have stopped :)
I'm very new to Zencart so forgive me if the questions seem uninformed (because they are):
1. The installation instructions say "FTP the contents of [temp directory]/catalog into the root of your Zen Cart installation." Are the "admin" and "includes" folders meant to replace the ones that are already there? If so, won't that delete files that I've already customized? Rather than risk that happening, I hand installed all of the files into the proper folders but I'm not sure this worked because there is not a "Super Orders" selection under "Configuration" but there is a "Super Orders" under "Customers."
2. The second part of the install says to "Run the super_orders_sql.sql file on your database. Will work with the "SQL Query Executor" tool in the Admin (Tools > Install SQL Patches)." There really are no instructions for using this tool. I went to SQL Query Executor, clicked on the "Choose File" button and selected the super_orders_sql.sql file. I then clicked on the "Upload" button and got this message:
1062 Duplicate entry 'CA' for key 2I assume that this was the way to run this file but I can't be sure. Did I do it correctly?
in:
[INSERT INTO zen_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.
3. The Purchase Payment module is installed and turned on. Is it supposed to put a text entry field somewhere in the order form where the customer can input the P.O.?
4. Is there something I can turn on to so that tax exempt customers can identify themselves as such and enter their tax ID number to insure that they are not taxed?
Thanks for any help.
If you ftp the contents of the file you are about to upload to your server, some files might be overwritten, but most files will likely be new and so won't overwrite any existing files. This is why it is important to read the instructions and determine if the mod overwrites anything, and to make backups first.
Had you installed a previous version of this mod before? The "duplicate entry" message shows that you already have that table in your database. What I did to solve this - and I don't know if it's the best or even the right way to do it - was do delete the areas of the sql file that would give me that message. However, if you're not comfortable with this you might want to check with the mod creator first.Quote:
2. The second part of the install says to "Run the super_orders_sql.sql file on your database. Will work with the "SQL Query Executor" tool in the Admin (Tools > Install SQL Patches)." There really are no instructions for using this tool. I went to SQL Query Executor, clicked on the "Choose File" button and selected the super_orders_sql.sql file. I then clicked on the "Upload" button and got this message:
1062 Duplicate entry 'CA' for key 2I assume that this was the way to run this file but I can't be sure. Did I do it correctly?
in:
[INSERT INTO zen_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.
From what I understand it's best to copy the sql text and paste it into the text area rather than to use the "upload" function.
I believe there is another mod in the downloads area which gives a field for tax exempt numbers. The latest version of this mod might not be up to date, though, so you might want to search for the thread on this forum related to the mod and see if there's an update for the mod on its way.Quote:
4. Is there something I can turn on to so that tax exempt customers can identify themselves as such and enter their tax ID number to insure that they are not taxed?
I have installed super orders on a test site and love what I see. I really want to be able to edit orders though.
However something wierd is going on. When I Add a Payment of $100.00 Cash it confirms as $100 but then shows as $130.97 in the Order Payment Data and also subtracts $130.97 from the balance payable.
I did $300 also and this came up as $397.01. Makes no sense to me but at least it is consistent ;-)
Hope someone canhelp me with this.
THank
Raoul
anyone else having this issue? Im not sure if this is how its suppose to work or not.
when i split an order up, the new order created shows on the admin home page, but it dont show up on super orders, nor does it show on the standard orders system.
i can use the NEXT button on SO to pull up the order, or type the order number in manualy, and it pulls it right up... but why is it that its not showing both orders in the list of orders for both SO and standard orders system?
this makes it hard to pull both orders when you cant "point+click" on it....
thanks guys.
Wicked
Looking through the release notes, and based on what I've seen in the SVN logs, I don't believe there should be any issues. However, I am in the process of upgrading my site now, and will give a definitive answer ASAP.
P.S. Thanks for picking up on the newbie question for me. :smile:
The batch page doesn't do anything special with sessions or the like, so I doubt that the page itself is the culprit. I seem to recall threads detailing this logout issue in the admin before, I suggest running a search of the forums. Do you know what version your client is running?
I appreciate the heads-up, Conor! I need some more detail; where exactly does the address appear improperly? Unless you're editing, SO doesn't mess with order details, including address formats. Does this happen only after editing perhaps? The more you can tell me about how the problem occurs, the better chance I have of fixing it.
First time for this one. Are you sure you didn't edit any of the SO files?
Another first, and I'm beginning to believe your site is haunted, Wicked. :blink: An order created via splitting should behave just like any other order. It duplicates the order details (minus payments, we dont want duplicate payments in there), then simply migrates the selected payments to the new order. Is either order displaying anything odd on the detail screen post-split?
well, im starting to think the same thing Blind. There is nothing odd, or anything on the details page...
it seems to work just like it should. i just noticed that when you pull up a LIST of the orders, its not showing the newly split order for the customer, only the orig.
as stated, it shows both in the admin homepage just like it should. But to bring up the split order anywhere else, i have to locate the orig order, and use SO to move the the next order num. otherwise you cant even see that its there.
Is there any list of features how does this module function?
I would not like to install and then look but to get some idea if it is worth of trying for our usage.
Elli
Elli,
If you have to edit your customers orders/invoices often this is the perfect module for you. Allows you to edit, add, and delete items and charges to the orders received. :cool:
Just download and check out the README file, ellivir. Everything it does is listed in there.
I have seen references to a Purchase Order Module. Any idea where I can find it? I've searched all of the downloads and can't seem to locate it. Thanks.
The PO module is included with your SO download/zip.
I just tried to install Super Orders 2 on my Zen Cart 1.36 nd get the following error when running the sql through my admin/ tools:
1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO zen_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.
What should i do now?
Thanks
To the bolded portion, why not? if you're running the Javascript from the super_orders.php page, that's exactly where it should go. To mimic the existing JS calls is pretty easy...
- put your .js in the same folder as the others listed in the header
- copy one of the js includes line already present
- replace the file name with your own file
Really not that complicated. Am I missing something?
You ran the SQL file more than once. See previous posts on this issue.
Does anybody notice that if ot_shipping is installed, then on the "super invoice" the shipping method is always missing, yet the shipping charge stays on. I think it has to do with following code:
It seems to me that $display_title always equal to $clean_shipping.':'; rather than $order->totals[i]['title'];Quote:
<?php
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
if ($order->totals[$i]['class'] == 'ot_shipping') {
$format_shipping = explode(" (", $order->totals[$i]['title'], 2);
$clean_shipping = rtrim($format_shipping[0], ":");
$display_title = $clean_shipping . ':';
}
else {
$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'];
}
Can someone please help?
Hello -- any help will be appreciated..............
i tried to enter the test of the SQL file into the sql tab for my DB. I pressed go and this is what i got:
Error
SQL query:
-- Following is for a future release
-- Bar code display
- - INSERT INTO configuration
VALUES (
NULL , 'Display bar codes', 'BC_ENABLE', 'true', 'If enabled, a bar code of the order number will appear on invoices and packing slips.', 28, 99, now( ) , now( ) , NULL , 'zen_cfg_select_option(array(''true'', ''false''),'
);
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--INSERT INTO configuration VALUES (NULL, 'Display bar codes', 'BC_ENABLE', 'tru' at line 1
Someone else reported this problem earlier, same solution. If your MySQL server is complaining about the comments, just delete the comments.
If this question has already been asked and answered, please forgive me. I have searched this thread and not found what I needed, so here goes.
I have added a text attribute to my products so that people can give me their customization info for their orders. It is set to be 999 max length and 6 lines high. (more of a text area type thing). Some customers get very wordy.
On the admin side using Super Orders, their text doesn't wrap, even when they use returns when they type it out. In the regular Orders admin, they wrap fine.
I print out all my orders and work from hard copies. This becomes an issue in SO because it's cutting off the entire right side due to the scrolling and the text lines not wrapping. I could just print them out from the regular Orders, but I have gotten spoiled with the batch form print feature of SO and don't want to have to open orders one at a time to print from the regular "orders". :D
the comments for this order box has the same issue.
Any ideas?
TIA
signs
Thanks for the reply BlindSide. I will not even pretend to be MySql or phpmyadmin savy...............very limited experience.
I am excited about your module and itching to get it running. In the ZEN admin panel everything seems to be loaded, but that may be more of the files than the correctness of the DB additions.
Since it is just a comment that had an error and nothing else can this be ignored? Is there anyway to check the validity of the SQL file update?
Let me guess, your recommendation would be to dump the whole DB - restore from back up - then open your sql code, remove comments and try again?
These lines appear at the very end of the file, after all the queries have been executed. I think you would be safe to at least try to use the system as is, without redoing it. However if you run into errors, I would attempt the reinstall as you described (you may be new, but you sound like a fast learner :wink2: ).
Is the problem appearing in the attribute details for each product on an order on the order details screen, or on the order listing page (all the orders listed as line items)? I'm can't tell where you see this problem based on your comment. If you have no clue what I'm talking about, attach a pic, that should suffice.
I just installed and everything is working great. The only ting I would like to do is eliminate the item images from the packing slip. Can I do just this and retain all of the current functionality of the module?
Thanks
Open admin/super_packingslip.php. Find this block of code:
Right after this add the following line:Code:// Add product images if there are 3 or less products on order
if (sizeof($order->products) < 4) {
$display_images = 1;
}
else {
$display_images = 0;
}
Voila.Code:$display_images = 0;
Thanks a million
Mike
Hey BlindSide!
I got it working and seems like a great tool!
Questions and comments follow:
Edit the order.php class (admin side) - all of these edits noted in the install text were already in my order.php file.
Store last 4 digits (authorize.net) - I believe you note that this can be adjusted for any payment processor. I did some quick file comparison and there are obvious differences. I am using Linkpoint -- can this be modified to allow for the 4 digits?
Do i have to turn on the PO Module? - What do i lose or gain by it? My site owner does not currently process PO's.
Possible problem - I notice that if i update a specific order for a customer i can update that order and simultaneously send an email to the customer. Nice feature. BUT when i do a batch update and check the box to notify customer, nothing happens - ( and the comment box is tall and narrow - essentially unusable).
Also in cash report it seems as though I am forced to choose a date range.....
Ty Package Tracker - Does the integration of this mod and yours provide for the integration of tracking numbers on contact emails?
Process - - I notice that you can update orders, complete orders, and cancel orders. What processes do you have your office people follow with this. My site owner is currently using paypal and has been "comfortable" with that process. I like your mod because it can automate a ton of steps that paypal cannot. The batch processing alone is key. In paypal you have to go into each order add the weight and shipping type and then print your choice of items -- all from within a customer account screen -- I believe your mod will streamline that immensely.
Even though your mod does batch processing, how much tinkering is required? Do you have to do updates and complete orders? My site owner is a one man shop. Any streamlining and efficiencies are very important to me.
Thanks for this great addition BlindSide........
-B-
why doesn't the download section for the Super Order include a description of this module.
Ex; I don't know what this module does and never heard of it before.
For the developers of this module. At least include a brief description in the download section beside "Super Orders is exactly what its name implies:
Zen Cart order management on steroids."
like, does it fly like super man :)
Umm...okay. Then don't do them again.
Like I said in the readme:Quote:
Store last 4 digits (authorize.net) - I believe you note that this can be adjusted for any payment processor. I did some quick file comparison and there are obvious differences. I am using Linkpoint -- can this be modified to allow for the 4 digits?
If that's still not general enough, just look for $order->info['cc_number'] or even just 'cc_number'.Code:This can be adapted to other modules that allow you to store a CC
number. Just open the module file for your payment module, and
look for a line like the following:
$order->info['cc_number'] = $_POST['cc_number'];
It's just an additional payment module, practically identical to the check/money order module that comes with stock Zen. If your store doesn't accept PO's, just ignore it.Quote:
Do i have to turn on the PO Module? - What do i lose or gain by it? My site owner does not currently process PO's.
That's a new one. What browser do you use? Have you tried more than one?Quote:
Possible problem - I notice that if i update a specific order for a customer i can update that order and simultaneously send an email to the customer. Nice feature. BUT when i do a batch update and check the box to notify customer, nothing happens - ( and the comment box is tall and narrow - essentially unusable).
...and? You want automatically see all payments made ever or something? :blink:Quote:
Also in cash report it seems as though I am forced to choose a date range.....
Don't know, I don't use that module at all. I'd ask the module author.Quote:
Ty Package Tracker - Does the integration of this mod and yours provide for the integration of tracking numbers on contact emails?
We have an office of about 12 people, with about 6 of those touching various parts of the order system. As you noticed, most of the order updating is automatic, and happens transparently as my staff performs operations on a given order. That's delibrate, to streamline their work, minimize the chance of errors, and maintain consistency and accuracy in the update notes.Quote:
Process - I notice that you can update orders, complete orders, and cancel orders. What processes do you have your office people follow with this. My site owner is currently using paypal and has been "comfortable" with that process. I like your mod because it can automate a ton of steps that paypal cannot. The batch processing alone is key. In paypal you have to go into each order add the weight and shipping type and then print your choice of items -- all from within a customer account screen -- I believe your mod will streamline that immensely.
Without a security module like Admin Profiles (I currently don't use one), just make sure to clearly delineate the areas of responsibility and "do not touch" zones. The overlap can sometimes cause havoc otherwise. Let me know if that doesn't answer your question.
You mean how much tinkering to get it to work? It should be none, I don't knowingly put out broken code. :wink2: Like you say, there are several ways to do things in the system, and often it's a personal choice. For example my store uses the batch options sparingly, as we have two person who's sole job is to manage orders in the system. We don't need it that much, but I know others use them very heavily. Just find something that works for you.Quote:
Even though your mod does batch processing, how much tinkering is required? Do you have to do updates and complete orders? My site owner is a one man shop. Any streamlining and efficiencies are very important to me.
You're very welcome. :smile: If you really wanna thank me, send a donation to the team. My company is non-profit, so we don't have much spare cash, but I can give back in code. If everyone does their part, we all benefit.Quote:
Thanks for this great addition BlindSide........
Because it's too damn big to fit in that tiny description box without looking like a doctorial thesis. Download the thing and check out the readme for details.
Ah, a wise-arse, huh?Quote:
For the developers of this module. At least include a brief description in the download section beside "Super Orders is exactly what its name implies:
Zen Cart order management on steroids."
like, does it fly like super man :)
See previous answer.
:P
Sorry I didn't get back to you quicker! It's on the product details screen and it's on the invoice when I go to do a batch form print.
Maybe the issue is that I am manipulating the text attribute into a text area, so when it translates into the order details and invoice screens it's forcing it to be one line and ignoring their line breaks?
the order emails have the line breaks and don't stretch out the text attributes into one long line.
Let me guess, you're using IE7 aren't you? I just found this problem the other day while working on something else. IE7 has a bug with textarea tags that causes them to display weird in some situations. In this case, it's the checkboxes next to the field that are spurring the bug. Next release will see this problem fixed.
I'm exerting some extreme self control in not delivering a vicious castigation here of Microsoft for this ridiculous blunder. Keep it on topic, Frank...
[flanders]Well that's a noodle-scratcher...[/flanders]
FF version? What OS? Any display-modifying extensions installed?
Windows XP and here's a list of my installed FF extensions:
Web Developer
Screen Grab
Snapper
Clippings
Minimize to Tray
del.icio.us
FF version: 1.7.0.5 (yeah, I need to upgrade, but that doesn't explain why it works right in the regular order details, and not in super order details.)
Is there a page for super orders that takes the place of attributes.php? Maybe I need to edit that page to change input type=text to =textarea?
Your setup sounds pretty innocuous. The input type should already be textarea. Did you edit the file at all? Here's what the outputted HTML should look like:
Does it appear different in your source? What version of Zen Cart are you running?Code:<textarea name="comments" id="comments" wrap="soft" cols="60" rows="5"></textarea>
I'll get you a screen shot of what I'm talking about. I am using the text attribute as a text area, and it's so that customers can provide personalization info for each specific item they purchase (less confusing than entering the info on the checkout page). It's the way the attribute displays, not the comments box, that isn't wrapping. Altho, now that you mention it, the comments area doesn't wrap either. But does when viewing with the regular order details.
I have v 1.3.0.2 installed.
edited to add screen shots:
in regular Order details page:
http://76.162.0.166/screenshots/wraps-right.png
in Super Orders details page:
http://76.162.0.166/screenshots/wraps-not.png
ooooOOOOooo, I completely missed the fact that you were talking about attributes, and not the status comments (your first post confirms my mistake). Error on my part, I apologize.
Okay, I'm not 100% sure, but I have a guess. Open super_orders.php. Do a search for "nobr". You should find it three times. Delete the opening and closing <nobr> tags that appear right after this line:
Upload and see what you get.Code:for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {
Wooohoooo!!! worked like a charm!! THANKS!
only other thing I have to do is uncomment the one thing mentioned way back in this thread about getting the shipping method to display so I know if they got priority mail or something else.
Now Super Orders is everything I dreamed it would be! Thanks for hanging with me this morning to get it worked out. Have a great day!!
Signs
Your welcome, and no problem. :happy:
Also as a general note to everyone, the next major release of Super Orders is well under way. No release date yet, but changes aren't as sweeping as last time, so it shouldn't take as long (but we'll see). The bullets...
- More bug fixes, based largely on your feedback (thanks!)
- New installer for all users, new or returning. Will handle all DB changes automatically.
- Some fancy-shmancy AJAX effects, particularly in the new features below
- New order search interface for order listings, similar to the one on the batch pages.
- New product edit module. Edit product quantity and any associated attribute values (mimics attribute display on storefront, only fills in existing values).
- New product return/exchange module. Return a product and exchange for one or more new products. Also processes refunds on tax and shipping, and adds new fees for tax, shipping. Includes option for exchange service charge.
I know the last two bullets go against what I said earlier about waiting for attribute updates in the Zen core, however a freelance job came up asking for returns/exchanges and I was happy to oblige! The consequent leap from adding products to editing them was a breeze. If the sponsor wishes to be recognized (I have to confirm with them), they'll be listed in the README at the top.
So there you go: an option I didn't plan to do that a person came forward and paid for, and now you all get to benefit. Keep that in mind next time you want a feature that I don't have in there and/or don't plan on adding. *cough* hint-hint *cough*
Again, I don't have a release date, so don't PM or post asking when it will be ready or to see screenshots. :P
nice to see extra work going into super orders , can I just say I still dont have a working version for Batch e-mailing to update order - can anyone let me know if they ever solved this.
Cheers
Hello, today I installed Super Orders 2.0 on a zen-cart 1.36 shop with multilanguage function, general language is german.
It seems to work well, but all edits I have to make in adminarea-files (product_id, customer_id) are already done!? Is it right?
Our Server is located in california (GMT -8h), but our shop is located in Europe (GMT +1h). I use time zone offset for 1.36 and it works well, but not in super orders, because all status-changes get the original server-time. I try to edit the line with [now()] but I get no result. Please help me with this.
My second problem is, that the shop stores no creditcard numbers, only if I split it (the middle part as e-mail) it works. If I delete the email-address in the payment-module nothing is stored.
I don't know if it works before superorders, because I never test it in this version, but in the earlier versions of the shop it works fine. After the import of the database from the old shop I can choose to delete the middle of the card numbers and the cvv for security. But now for new orders there are only cvv, cardholder and date of expiration, but no cardnumber. Please help if you know why.
regards
Michael
O.K., the answer for the second question I found in " whats new 1.3.5." . It is not from super orders but from the zen-cart release.
"Bugfix: CC module no longer stores full CC numbers"
So I will try the cc-module from 1.302 because I don't want to type the numbers always by hand. I can delete the numbers after charging the card. But please help me with my first question, the time zone offset.