Zack,Quote:
Originally Posted by zackf
I'm having to manually post them... the system isn't recognizing it for some reason for me. :( I'm using Authorize.net...
Printable View
Zack,Quote:
Originally Posted by zackf
I'm having to manually post them... the system isn't recognizing it for some reason for me. :( I'm using Authorize.net...
Hi All!
I am running the newest version of everything, installed it fresh and upgraded the database. I have a customer who created a 'new' account and I if understood correctly I can theoretically point her old orders to her new self using the SO 'edit contact data' feature. Right? :huh:
When I go thru the porcess it all 'seems' to be working, I check the box, choose the new self, and submit. The pop-up goes away, the screen refreshes, and I am back to the same order with the customer's old data and a peek at her orders lists the 'old' and 'new' as being placed by separate people. So it is not updating, but no error code or anything I know to peek at in order to troubleshoot. I tried going old self to new self and the other way, too (since the old self was created before an upgrade I thought it might make a differnce. Nope.
:frusty:
ideas??
Thanks!
Lori
Hi I've just installed Super orders and it is a fantastic mod, though I did have trouble with the SQL file and the prefix.
Can anybody tell me how the edit orders functions, I know it has limited functionality at this stage but I just can't see what it does at present.
I read it somehow spilts the orders but after testing this I can't see that it does anything.
Cheers
PS: Thanks Frank for this great mod!
Hi..
I am developing zen cart site. I need to print orders before checkout. I thing Super order do this. Where can i download it?
Dhaya
In regard to the XSS Vulnerability patch for Zen-Cart:
http://www.zen-cart.com/forum/showthread.php?t=64115
Shouldn't the same sort of changes be made in:
super_data_sheet.php
super_edit.php
super_invoice.php
super_orders.php
super_packingslip.php
Not sure if the original author has gone awol or not but. I am in dire need of a fix on SuperOrders,
The e-mail batch update part of SO has never worked for me , and my client is desperate to get it to work.
I have contacted the author by email and PM but so far no reply , if anyone else wants to jump in if they think the can make it work $$$ or £££ waiting ! email me
mark at darksidesolutions dot co dot uk
Regards
Mark
Here is an idea for a future release...
Have the ability to restock products when using the special cancelled button.
Hi there,
Does anyone have any issues with emails at all.
When I try to do a bulk update for orders to notify customer. No email gets sent out. When I look at the order history for those orders I can see a red cross next to notified customer, although the status does update.
If I do a single order at a time, the email works and the green tick is shown on customer notified?
Any Ideas?
Many Thanks
hi all
my store is about selling vegetables and fruits
i m still constructin it ....by hit n trial method:cool:
i want to give u live example what i want to put in my admin:
like i want to know my total sales- product wise on everyday bases like at 21:00 i can get the print out :
list of things purchased on dat very day:
tomatoes 30 Kg
pottatoes 20 Kg
Bananas 10 dozen
& so on...
secondly is there any way i can get the invoice in smaller size and not on full one page:oops:
plz advice how can i get this kidda list on one click:lamo:
Does anyone know how I can do a batch update of orders where "select" is based on product model number, as opposed to payment method, date range, etc.?
Thanks!
All I want to use is the batch order status feature of Super Orders. Do I still need to do all the file mods during installation?
I've noticed there is no option to delete the CVV number for CC payments. This option is available in the standard orders module. Does anyone know another way to do this?
Thanks.
Payment option for Purchase Order not available
Before I paste the sql error in here let me tell you my config.
I am running the following server/zencart config...
Server Host: www.newvisioncolorlab.com (66.252.131.130) Database Host: localhost (127.0.0.1) Server OS: Windows NT NVWEB1 5.2 build 3790 Database: MySQL 5.0.41-community-nt Server Date: 07/15/2007 14:46:01 Database Date: 07/15/2007 14:46:01
Server Up Time:
PHP Version: 5.2.2 (Zend: 2.2.0)
HTTP Server: Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8e mod_autoindex_color PHP/5.2.2 mod_perl/2.0.3 Perl/v5.8.8
After I run the sql update through ZC Admin using the upload method I get the following message when it is done...
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.
Just to let you know, i deleted my DB, reinstalled the BU, and then this time, instead of using the upload method in Admin, I just pasted in your SQL text and now this is my result...
Query Results:ALTER TABLE zen_orders ADD date_completed datetime default NULL;
ALTER TABLE zen_orders ADD date_cancelled datetime default NULL;
ALTER TABLE zen_orders ADD balance_due decimal(14,2) default NULL;
CREATE TABLE zen_customers_admin_notes ( admin_notes_id int(12) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', date_added datetime NOT NULL default '0000-00-00 00:00:00', admin_id int(11) NOT NULL default '0', admin_notes text NOT NULL, rating tinyint(1) NOT NULL default '0', PRIMARY KEY (admin_notes_id), KEY customers_id (customers_id) ) TYPE=MyISAM ;
CREATE TABLE zen_so_payments ( payment_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL default '0', payment_number varchar(32) NOT NULL default '', payment_name varchar(40) NOT NULL default '', payment_amount decimal(14,2) NOT NULL default '0.00', payment_type varchar(20) NOT NULL default '', date_posted datetime NOT NULL default '0000-00-00 00:00:00', last_modified datetime NOT NULL default '0000-00-00 00:00:00', purchase_order_id int(11) NOT NULL default '0', PRIMARY KEY (payment_id) ) TYPE=MyISAM ;
CREATE TABLE zen_so_payment_types ( payment_type_id int(11) NOT NULL auto_increment, language_id int(11) NOT NULL default '1', payment_type_code varchar(4) NOT NULL default '', payment_type_full varchar(20) NOT NULL default '', PRIMARY KEY (payment_type_id), UNIQUE KEY type_code (payment_type_code), KEY type_code_2 (payment_type_code) ) TYPE=MyISAM;
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CA', 'Cash');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CK', 'Check');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'MO', 'Money Order');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'ADJ', 'Adjustment');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CC', 'Credit Card');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'MC', 'Master Card');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'VISA', 'Visa');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'AMEX', 'American Express');
INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'DISC', 'Discover');
CREATE TABLE zen_so_purchase_orders ( purchase_order_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL default '0', po_number varchar(32) default NULL, date_posted datetime NOT NULL default '0000-00-00 00:00:00', last_modified datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (purchase_order_id) ) TYPE=MyISAM ;
CREATE TABLE zen_so_refunds ( refund_id int(11) NOT NULL auto_increment, payment_id int(11) NOT NULL default '0', orders_id int(11) NOT NULL default '0', refund_number varchar(32) NOT NULL default '', refund_name varchar(40) NOT NULL default '', refund_amount decimal(14,2) NOT NULL default '0.00', refund_type varchar(4) NOT NULL default 'CK', date_posted datetime NOT NULL default '0000-00-00 00:00:00', last_modified datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (refund_id), KEY refund_id (refund_id) ) TYPE=MyISAM ;
INSERT INTO zen_configuration VALUES ('', 'Store Fax', 'STORE_FAX', '', 'Enter the fax number for your store.
You can call upon this by using the define STORE_FAX.', 1, 4, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES ('', 'Store Phone', 'STORE_PHONE', '', 'Enter the phone number for your store.
You can call upon this by using the define STORE_PHONE.', 1, 4, now(), now(), NULL, NULL);
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\'), ');
INSERT INTO zen_configuration VALUES (NULL, 'Make payable to:', 'MODULE_PAYMENT_PURCHASE_ORDER_PAYTO', 'Destination ImagiNation, Inc.', 'Who should payments be made payable to?', 6, 2, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Sort order of display.', 'MODULE_PAYMENT_PURCHASE_ORDER_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', 6, 4, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Payment Zone', 'MODULE_PAYMENT_PURCHASE_ORDER_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', 6, 5, now(), now(), 'zen_get_zone_class_title', 'zen_cfg_pull_down_zone_classes(');
INSERT INTO zen_configuration VALUES (NULL, 'Set Order Status', 'MODULE_PAYMENT_PURCHASE_ORDER_ORDER_STATUS_ID', '2', 'Set the status of orders made with this payment module to this value', 6, 6, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration_group VALUES (28, 'Super Orders', 'Settings for Super Order features', 100, 1);
INSERT INTO zen_configuration VALUES (NULL, 'Auto Status - Purchase Order', 'AUTO_STATUS_PO', '2', 'Number of the status assigned to an order when a purchase order is added to the payment data.', 28, 11, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Auto Status - Payment', 'AUTO_STATUS_PAYMENT', '2', 'Number of the order status assigned when a payment (not attached to a purchase order) is added to the payment data.', 28, 10, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Auto Status - P.O. Payment', 'AUTO_STATUS_PO_PAYMENT', '2', 'Number of the order status assigned when a payment attached to a purchase order is added to the payment data.', 28, 10, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Auto Status - Refund', 'AUTO_STATUS_REFUND', '2', 'Number of the order status assigned when a refund is added to the payment data.', 28, 13, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Auto Comments - Payment', 'AUTO_COMMENTS_PAYMENT', 'Payment received in our office. Payment ID: %s', 'You''ll have the option of adding these pre-configured comments to an order when a payment is entered. You can attach the payment number to the comments by typing %s.', 28, 14, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Auto Comments - P.O. Payment', 'AUTO_COMMENTS_PO_PAYMENT', 'Payment on purchase order received in our office. Payment ID: %s', 'You will have the option of adding these pre-configured comments to an order when a purchase order payment is entered. You can attach the payment number to the comments by typing %s.', 28, 14, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Auto Comments - Purchase Order', 'AUTO_COMMENTS_PO', 'Purchase Order #%s received in our office', 'You will have the option of adding these pre-configured comments to an order when a purchase order is entered. You can attach the payment number to the comments by typing %s.', 28, 15, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Auto Comments - Refund', 'AUTO_COMMENTS_REFUND', 'Refund #%s has been issued from our office.', 'You will have the option of adding these pre-configured comments to an order when a refund is entered. You can attach the refund number to the comments by typing %s.', 28, 17, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Federal Tax Exempt Number', 'FED_TAX_ID_NUMBER', '00-000000', 'If your tax exempt, then you should have a federal tax ID number. Enter the number here and the tax columns will not appear on the invoice. The number will also be displayed at the top of the invoice.', 28, 50, now(), now(), NULL , NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Closed Status - "Cancelled"', 'STATUS_ORDER_CANCELLED', '0', 'Insert the order status ID # you would like to assign to an order when you press the special "Cancelled!" button on super_orders.php.
If you do not have a "cancel" status, or do not want assign one automatically, choose default and this option will be ignored.
You cannot attach comments or notify the customer using this option.', 28, 30, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Closed Status - "Completed"', 'STATUS_ORDER_COMPLETED', '0', 'Insert the order status ID # you would like to assign to an order when you press the special "Completed!" button on super_orders.php.
If you do not have a "complete" status, or do not want assign one automatically, choose default and this option will be ignored.
You cannot attach comments or notify the customer using this option.', 28, 30, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
INSERT INTO zen_configuration VALUES (NULL, 'Closed Status - "Reopened"', 'STATUS_ORDER_REOPEN', '0', 'Insert the order status ID # you would like to assign to an order when you undo the cancelled/completed status of an order. If you do not have a "reopened" status, or do not want assign one automatically, choose default and this option will be ignored. You cannot attach comments or notify the customer using this option.', 28, 30, now(), now(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses(');
I'm just installing the CC payment module after using an older version of SO with Edit Orders. When I try to complete a test order, I get:
1146 Table 'db.TABLE_SO_PAYMENT_TYPES' doesn't exist
in:
[select * from TABLE_SO_PAYMENT_TYPES where language_id = '1' order by payment_type_full asc]
I'm not a programmer, but this may be because of the SO install? Has anyone else run into this? If I look at SO_PAYMENT_TYPES and it us there and credit cards are listed there. any suggestions? :huh:
Any news on these questions about payments not showing up from PayPal or if you can update them manually? Please see #601.
Thank you!
:frusty:
I thought this mod was working great until I realized that my customers are not receiving any emails now. I have two cart on the same server one with this mod and the other without, the one without the mod works and the one with the mod doesn't. My customers don't receive any order confirmations or updates. Any help!
I'm having same problem. When I check the email archive, it shows the emails were sent, but with no "To:" address (just empty brackets). Since we're still in testing mode, no biggie, but we sure do need to get this working.
Thanks
Anyone experience the prices change in the admin under super orders?
Example, $4.99 item shows up as $172.00 lol
I cant figure this thing out why it does that, any help be appreciated.
This is when a order is made it is correct on the customer side but changed on the admin
Me too. Browse->Upload of the super_orders_sql.sql file via "Admin->Tools->Install SQL Patches" gave me the same error you quoted further above, but when I pasted in the text from the file (again in "Admin->Tools->Install SQL Patches") and applied it via the send button, it worked just fine.Quote:
Originally Posted by jmacdoug
This was with Zen 1.3.7, Database Patch Level 1.3.7, MySQL 5.0.33, PHP 4.4.5, Apache 2.2.4.
See wickedklown's post of 14th October 2006, 05:24 PM for background.Quote:
Originally Posted by wickedklown
This was regarding non-scrubbing of [FONT=Courier New]<br />[/FONT] s from status comments added with super orders. I was experiencing the same problem. When adding one status comment to a single order with super orders, my newlines were being stored as [FONT=Courier New]<br />[/FONT] in the database, and the tags would then also appear when the customer viewed the status comment from within the order page in their zencart account. The html email sent to the customer looked as expected: line breaks where there were line breaks in the original text... it was just subsequent re-display of the stored comment on the customer's order page that had the [FONT=Courier New]<br />[/FONT] tags shown.
SO... I discovered a workaround. I "un-supered" the line that super_orders.php uses to scrub the comments and changed it back to the version in plain-old orders.php. In catalog/admin/super_orders.php , in the vicinity of line 100, I made the following change:
I believe zen_db_prepare_input() is the function that is builtin to zencart to scrub input prior to database storage, and zen_db_scrub_in() is a function from super orders that performs the same task.Code:// 070722: Changed this line to use same function orders.php uses, to fix improper
// scrubbing of <br /> from comments.
$comments = zen_db_prepare_input($_POST['comments']);
// 070722: Original Line
// $comments = zen_db_scrub_in($_POST['comments']);
Anyhow, a big disclaimer: This fixed the problem I described, but there obviously is some reason a new function was created to scrub input for super orders, so... user beware. This may have some undesirable effect that I simply haven't noticed yet, although the fact that orders.php uses this line makes me suspect that this will work OK in most situations. Time will tell.
Background info: I did this on an installation with: Zen 1.3.7, Database Patch Level 1.3.7, MySQL 5.0.33, PHP 4.4.5, Apache 2.2.4.
OK, regarding my post of 22nd July 2007, 04:29 AM:
There are, in fact, secondary effects from making the mod I outlined. They can be fixed up, I believe, with two edits to super_edit.php and one change to super_orders_functions.php . The end result is that newlines are stored in the database and not <br /> (which is what I wanted), and newlines are converted to <br /> when needed for html output to email, etc. It also fixes the behavior I kept seeing where, after editing status comments with super orders (for one order at a time, not batch mode), <br /> , \n , \r , (or some combination thereof) appearing in status comments would be re-saved to the database as "nr" at the beginning of each line.
So it appears to function the way I want now, with newlines appearing visually as line breaks in all contexts.
However, I can't really recommend it.
One reason is that I am not certain that protection from injection hazards is as good after this mod. It might be, but I'm not an expert in such matters. It isn't a consideration for our situation, as this all runs in the admin side and our admins are limited, non-malicious, and just use it to paste in simple, but multi-line, text. For general use it might be more of a concern.
One other reason I can't recommend it is that I suspect that the intent in altering the scrubbing strategy/code/functions in super orders was to preserve <br /> and other html tags in the database and display them properly in HTML contexts. For some reason there were a few cases in the unaltered code for super orders where status comments would appear with <br /> and also where, after editing status comments, line breaks such as \r\n would be converted, saved and subsequently displayed as "rn" (perhaps the reverse order, "nr", I forget which). These are probably just minor bugs, or it could also be that I, wickedklown, and the other person (somewhere in this thread) who observed "rn"s or "nr"s are doing something when entering or editing status comments that should be done differently to prevent these problems.
My point is that when/if a new rev of super orders is released, I would be willing to bet that the <br /> , \r\n , rn , nr strangeness in status comments will probably be eliminated.
Finally, I haven't tested other HTML tags in the comments, such as hrefs, etc. and can't vouch for how they are handled after modifying superorders as I did. We just need regular text with linebreaks, so it does what we want.
If someone else is having problems with newlines, <br /> , etc. in status comments, I can post the additional mods. PM me if you want the other mods and I'll post them with a big warning.
The source of the error page displayed after I click on "confirm order" button in checkout says the following:
The section in the cc.php file which includes the offending line says:Code:<br />
<b>Warning</b>: str_repeat() [<a href='function.str-repeat'>function.str-repeat</a>]: Second argument has to be greater than or equal to 0. in <b>C:\xampp\htdocs\PAC\shop\includes\modules\payment\cc.php</b> on line <b>259</b><br />
<br /><br />Email Error: SMTP Error: Data not accepted.<br /><br />
I'm too php-ignorant to know what's causing the problem here, or how to fix it. But since this section refers to 'MODULE_PAYMENT_CC_EMAIL', I thought maybe this could be the reason emails aren't being sent.Code:line256 $len = strlen($_POST['cc_number']);
line257 $this->cc_middle = substr($_POST['cc_number'], 4, ($len-8));
line258 if ( (defined('MODULE_PAYMENT_CC_EMAIL')) && (zen_validate_email(MODULE_PAYMENT_CC_EMAIL)) ) {
line259 $order->info['cc_number'] = substr($_POST['cc_number'], 0, 4) . str_repeat('X', (strlen($_POST['cc_number']) - 8)) . substr($_POST['cc_number'], -4);
line260 }
line261 }
Hope this helps!
BlindSide, bravo to your great mod - I love it!
I have a question regarding modification of the Packing Slip - I would like to show the total shipped item number at the end of the listing of purchased items, something like e.g.:
Total Shipped: 5 ITEMS
In the event of spilt slip, it will show whatever total the shipment is.
I realized it could be just a line of code to insert in the super_packingslip.php but I am not good at coding. Hope you would help me here! Many thanks!!!
so that I don't have to read 63 pages
does this mod support spliting orders with a quantity option?
TIA
TBR, try out this one-line change in super_orders_functions.php. Find the first commented out line, where it is replaced with a line that seems to work better:
Hope that works for you.PHP Code:function zen_db_scrub_in($string, $strip_tags = false) {
if ( $string == '""' || $string == "''" || strcasecmp($string, 'null') == 0 || strcasecmp($string, 'now()') == 0 ) {
return $string;
}
elseif (is_string($string)) {
$string = trim(stripslashes($string));
// $string = nl2br($string); // replaced line
$string = str_replace(array("\r\n", "\r", "\n"), "<br />", $string);
if ($strip_tags) {
$string = strip_tags($string);
}
//$string = mysql_real_escape_string($string);
$string = mysql_escape_string($string);
return $string;
}
elseif (is_array($string)) {
reset($string);
while (list($key, $value) = each($string)) {
if (!is_numeric($value)) $string[$key] = zen_db_scrub_in($value);
}
return $string;
}
else {
return $string;
}
}
Two quick questions about Super Orders 2.0 (which is a great mod!)
1. When I print out packing slips, why do some of them include the image of the product, and some do not include the images? I can't figure out any rhyme or reason on what makes the difference?
2. In the Batch Status Update, the comment box is really small (like 1 character by 2 characters). Is there anything I can do about that, to make it so I can edit something that I've pasted there?
Thanks!
LW
Hi,
I have successfully installed the super order mod (looks great), but when i place a test order and go to: Admin--->Customers---->Super orders then look at the order placed (which was by purchase order) then add a PO to the order, then proceed to pay it by adding the full amount due, the page then updates saying that they still owe X amount even though they have paid the full amount, so I have tried to add the amount due as well and the amount changes but there is still an amount due. I am confused why its doing this as there always appears to be an amount due. I hope I have explained this ok, I would really appreciate your help.
Thanks,
Ian
Anyone know how to remove this mod from the database completely, it has caused nothing but chaos the client has no clue what he was doing and I am wondering if anyone has ever uninstalled successfully.
i keep getting this error when im trying to apply the sql patch:
1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO 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.
i tried both with the file and with copy and past the query
anyine knows what to do....?
im installing the SO 2.0,, and i am in the 7th point,, --->
Open includes/classes/order.php, then find this line:
$insert_id = $db->Insert_ID();
Immediately after it, add the following code:
// BEGIN Super Orders edit
// add CC data as a line item to SO payment system
if (zen_not_null($this->info['cc_type']) || zen_not_null($this->info['cc_owner']) || zen_not_null($this->info['cc_number'])) {
require(DIR_WS_CLASSES . 'super_order.php');
$so = new super_order($insert_id);
$so->cc_line_item();
}
// END
Super Orders edit
The comments will ensure you know what this is for the next time you need to upgrade.
i can't find this line: $insert_id = $db->Insert_ID();
what to do with this now?
can anybody help?
regards
sorry i forgot to say that im using version 1.3.7
and one thing also i found with it is in:
Edit the order.php class (admin side)
The order class does a great job of collecting everything you need for an
order...almost.
The class completely lacks any ID numbers for the
information it represents, which is really useful information to have.
Super Orders uses the customers_id and products_id in a few places, so we
need to add them to the order class.
a. Open admin/includes/classes/order.php,
find the line that reads as follows:
...
all are done in the new version
regards
saher
I love super orders.
Is there a way to take off " Orders " so that I default to Super Orders all the time.
Or just make it so that the "Orders" tab is super orders.
Super Orders is fantastic - thanks so much for this mod. Maybe this is too obvious for me to figure out, but is there a way to have the order comments show up on the batch print? We occasionally have people make a last minute request to change the shipping address, or to ship 2 orders together. We note these in the comments section, but this is not printing in the batch print. Thanks!
When I make these changes in any of the SO files (orders, invoice, packingslip) in order to get the shipping method to show (not just the carrier) the page just comes up blank. Has anyone else encountered this problem?Quote:
Originally Posted by BouncerFL
Please disregard the previous post. I had a mistake in commenting out of the section of code mentioned. The problem is resolved. Thanks for the help.
Has anyone had any problems when doing a batch status update for notifying the customer. I want to be able to send a batch message to all customers who's status has changed with a comment. When I do this, i get the success update at the top of the screen, but no email is sent out, and a red X is on notify customer box, any ideas?
Thanks
Samantha
Known issue with no known resolution :(Quote:
Originally Posted by Sam_uk
Would love to know when/if anyone has ever figured it... this is a great feature and apparently it works for some and not for others. I would be willing to help collect data for comparison if anyone is able to help figure out what the difference is between mine, yours, and those that work... :smile:
I ain't no programmer, but I "think" this might get it working (old version):Quote:
Originally Posted by redheads
super_batch_status.php
HTH :smile:Code:function batch_status($oID, $status, $comments, $notify = 0, $notify_comments = 0) {
global $db, $messageStack;
global $orders_status_array; // (bug fix)
I am guessing this is something you used to repair the problem... Thanks for posting it, I know this has been an issue on this mod/thread for a while. I will give it a try and report back next time I need to do a batch-send!Quote:
Originally Posted by DogTags
:-)
Thanks for the bug fix try, Dogtags...
no change here when applied, but it was certainly worth a shot and I appreciate the idea.
I add the message, tell it to update, screen updates with
'Status has been updated successfully!'
in the header for as many orders as I have selected. Looks good thus far... then... In the order, a red X where 'customer notified' and no email is actually generated.
Thanks for the try! If anyone has ever successfully gone from no emails generated to a work-around, please tell us here :smile:
Dogtags thanks for trying, redheads i know what you mean i am getting the same problem as you.
Its a great feature to use, if anyone has got this to work or a workaround, will be really greatful
Thanks
Samantha
how can i remove this from my database without any problems
Help Please!
I put the files, I get a nice list of the previous orders but I do not get the new orders on the list but the order is in the db and you can access it from another order with "next". I also checked the the normal order list and the new one does not come up.
Can someone help me?
Also in the normal order and invoice I got working the TVA intracom for european companies and the VAT N. of the store and the client Company VAT comes up. With SO some FED TAX text comes up and no company VAT either.
Can you Help me Please?
Thanks
Frank,
When an order is generated I need to generate a Unique Customer Number that can be linked to customer info and exported to my CMS. Will Super Orders help me?
Thanks
I think I have fixed the update in the code for the batch status update so it now sends emails.Quote:
Originally Posted by redheads
On line 356 in super_batch_status it currently reads
if ($notify == 1) email_latest_status($oID);
It should read
if ($notify = 1) email_latest_status($oID);
It now sends out emails but it does not change notification it still reads as x and not a tick
I have now made a further correction so that it now updates the customer notification change the lines from 353 to 356 in the super_batch_status.php file in admin from
if ( ($check_status->fields['orders_status'] != $status) || zen_not_null($comments)) {
update_status($oID, $status, $notify, $comments);
if ($notify == 1) email_latest_status($oID);
to the following code
if ( ($check_status->fields['orders_status'] != $status) || zen_not_null($comments)) {
$customer_notified = '0';
if (isset($_POST['notify']) && ($_POST['notify'] == 'on')) {
$customer_notified = '1';
}
update_status($oID, $status, $customer_notified, $comments);
if ($customer_notified == '1') {
email_latest_status($oID);
}
I hope this does the trick with everyone who has had trouble with not being able to send emails in the batch status
Topcat24, u really are a topcat! :)
Thanks so much for the fix, so far so good, it seems to be all working.
Samantha:clap:
Thanks from me as well for your tips.
I have got a problem in super orders; the Tax Rate does not come out in the invoice. It says 0.00 but it gets calculated normally. Can you help?
One more thing!
I have installed the European VAT check and I managed to get the Store VAT and the Client Company VAT No. in the normal orders invoice.
I do not know how to get the Client Company VAT No in the super orders invoice.
Any Ideas
Thanks:smile:
You need to login to admin and then go to configuration then down to super orders and enter your tax number at the Federal Tax Exempt number.Quote:
Originally Posted by francocauter
You can also change the wording in the super invoice by changing the words in the file located at admin/includes/language/english/super_invoice.php from Fed Tax ID # to VAT No.
Regarding the client company VAT you would have to add code to the super invoice yourself as I do not use that module. A quick fix would be to use the normal order invoice by just renaming it from invoice.php to super_invoice.php it depends how you like the look of both.
Nevermind!
Sorry about the double post .. here's my question:
I am trying to allow a customer to purchase a custom designed product. They "purchase" a product on the shopping cart where they include the design they would like for their product. We then adjust the total for their purchase depending on how much it will cost.
However, once I adjust the cost I can't find a way to have them easily pay this amount. They can view their order of course, but there is no option to pay the balance due, via Paypal.
Is there a way to do this? Thanks!
Thanks topcatQuote:
Originally Posted by topcat24
That is another problem then cause I have not super orders in my configuration. Would you know what happened?
Thanks again
The configuration should have occured when you ran the sql.
Are you logged into your store's admin (it is not a file). Can you see the store fax number option in the My Store part, if so then you should be able to see the super orders under the configuration otherwise you will have to re-enter the code again just for the configuration as otherwise you will get the 1062 error. This is at the end of the sql. I have pm'd you the code if you cannot find it.
Hi! its me again!
I am getting the tax (VAT) rate in the super order details but I am not getting it in the super invoice.
Can you help please!:smile:
The logic to display the taxes is the same on both pages. Could you possibly give me some screenshots to look at?Quote:
Originally Posted by francocauter
No, sorry.Quote:
Originally Posted by calmo
Quote:
Originally Posted by BlindSide
I dont know how to put screen shots
I put the screen shots as attachenents
Thanks Blinside (Frank)
Sorry to bother you Blindside - FrankQuote:
Originally Posted by BlindSide
I have send the screen shots.
Any chance you could have a look at the problem, please?
This may be a bit off topic but I am looking around for someone to help me with making some customizations for my photo lab. My clients are wedding photographers and I want a way for a customer to upload hundreds of images in one shot. This wuold utilize an image uploader like jumploader or image uploader by www.aurigma.com
I already own a license for aurigma's Image Uploader and would really like if someone could help me out or do the integration for me. Essentially when somechooses a product called 4x6 Proof Print, I need them to have the ability like the File Upload Attribute only it would pull up the upload script, do a file count and report it back to the cart with the appropriate quantity.
Before I go any further would someone like to expand on this? I would like some feedback and pointers. This along with using Super Order v2 would be an incredible way for me to launch an awesome intuitive interface for my clients.
Jeff:cool:
I know that this is relatively simple, but that hasn't stopped it from bugging the heck out of me. :frusty:
I'm trying to create a pop-up window from the super_orders.php page that when clicked on, loads customers.php in edit mode for the customer whose order I'm viewing.
I can't figure out a way to correctly load the $cID variable and pass it into the URL string as part of the query.
I've added this to super_orders.php:
Towards the beginning of super_orders.php, I define $customers_id asCode:<?php
echo '<br /><a href="javascript:popupWindow(\'' .
zen_href_link(FILENAME_CUSTOMERS, . '&cID=' . $customers_id . '&action=edit', 'NONSSL') . '\', \'scrollbars=yes,resizable=yes,width=600,height=450,screenX=150,screenY=100,top=100,left=150\')">' .
zen_image(DIR_WS_IMAGES . 'icon_edit3.gif', ICON_EDIT_CONTACT) . ICON_EDIT_CONTACT . '</a>';
?>
$customers_id = zen_db_prepare_input($_GET['cID']);
Using
'cID=' . $orders->fields['customers_id']
doesn't seem to work either. I can load customers.php in the popup window in edit mode, but no customer ID is present, so all the fields are blank.
Any help?
Thank you all so much in advance.
Luke
I was also not getting tax displayed in the super invoice. I was getting "None!".Quote:
Originally Posted by francocauter
In super invoice the tax displayed hinges off the Fed Tax ID number. I just changed the following lines in admin/super_invoice.php:
Old Line 34:
$display_tax = (FED_TAX_ID_NUMBER == '' ? true : false);
New Line 34:
$display_tax = true;
This then ignores the Fed Tax ID value and always displays my local tax rate(AU GST). If I then get an overseas buyer, where I don't need to include any tax, the invoice is still displayed correctly(that is no tax).
Super Orders invoices are only designed for US based shops. But a quick and easy mod, makes it work with shops based in other countries.
Thanks Craig that worked wondersQuote:
Originally Posted by CraigW
Saluti
Franco
thanks Craig i was looking to fix this like 20pages ago i'm going to get right to it now that i know what to do
No worries, least I could do. :)
Did anyone manage to incorporate the "Time Zone" mod to work with "Super Orders"?
Its a right pain that Zen Cart does not have a feature to change the time zone globally..
Any help would be appreciated..
Regards,
Andy
Hi,
Can't find an answer to this, my apologies if I have missed it...
When I delete an order, keeping stock the same (cleaning out the database a bit) I get this error...
Fatal error: Call to a member function on a non-object in /home/afford/public_html/admin/super_orders.php on line 138
I looked at the code and here are lines around that number (the last line shows as line 138 for me)...
zen_redirect(zen_href_link(FILENAME_SUPER_ORDERS, zen_get_all_get_params(array('action')) . 'action=edit', 'NONSSL'));
break;
case 'deleteconfirm':
zen_remove_order($oID, $_POST['restock']);
$so->delete_all_data();
I am not a programmer so I do not know what to change.
Any help would be great.
Thanks
Ange
I have a client who needs to create some reports to follow up pending status orders. He wants to see each pending order including the items ordered on each order.
I did install this mod on a test cart I have and was in process of playing with it, but before I spend a lot of time perhaps someone can tell me if this is even possible with Super Orders. Otherwise, I'll write something custom for him off-cart.
Thanks!
Have you tried the sales report contribution?
It can filter by order status and time frame amongst others but unfortunately it seems to either show orders or products and not both.
Might be worth a starting point to amend though.
http://www.zen-cart.com/forum/showthread.php?t=44669
http://www.zen-cart.com/index.php?ma...products_id=83
Craig
My problems is i get this fail
Fatal error: Call to undefined function so_close_status() in \admin\super_orders.php on line 1172
in the admin side ->customer->super orders
and i get alle these kind of fails.
i looked up in the code
$close_status = so_close_status($orders->fields['orders_id']);
I have Linkpoint as a payment module...I use the Approval code to link ZenCart orders to the merchant account when reconciling cc transactions and entering into QuickBooks (it's the only number that shows up everywhere).
So how would I get the Linkpoint Approval Code to show up on the invoice that I'm going to print? I'm sure it's just a matter of adding a snipet of code somewhere, but I'm pretty PHP illiterate.
Thanks!
Michelle
After my client's site went live, they decided they didn't like the fact that there's no way to handle back orders in Zen Cart. I'm trying to find the best solution for them and I'm not sure yet if Super Orders is it. If someone can help me with this, I'd really appreciate it.
1. In the client's old cart, they could see on the invoice/packing slip if an item is out of stock/i.e. a "backorder" (They allow customers to order items that are out of stock because they can't sync inventory numbers with their brick and mortar store and the online shop AND are always getting deliveries so something that's "out of stock" on the shop may very well be sitting in the back room).
2. In the client's old cart, they could edit an order. They want to be able to take those things that are indeed out of stock off one invoice and to create a new one so that the customer can get their order and receive the other item later.
Will Super Orders allow me to make this happen?
If so, are there any precautions I should take when installing this since their Zen Cart is fully live and functional?
Thanks!!!!
:clap:
Hello all,
I've searched this thread, but I haven't found specific answers to my questions. Please forgive me if I have missed them!
Our client needs to see the shipping charges broken out and the CVV number and expiration date for the credit card listed on the printed invoice. Although I've been able to figure out some of the patterns, I'm not a PHP coder and I haven't had luck in getting any of these things to show up properly. Would someone please take mercy and send me specific file names and lines that I need to modify? I am already grateful for your help!! :smile:
Leah
When I try to install the sql path either by cut and paste or the upload file method all I get is this error message.
1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO bettertoso_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.
I have no idea what this means so I just reverted to my backup sql
Sounds like a nice mod, wish I was smarter, lol.
I've got somathing strange in the Sales report page.
I've modified the date format in english.php as told in this thread
http://www.zen-cart.com/forum/showth...ht=date+format
When I enter a custom date, the start date is in UK format as set in english.php.
The popup calendar writes the end date in UK format, but the process wants it to be US format, so I end up to enter :
Start Date=UK format
End date=US format
to not get errors when I click Show me the money button.
Any idea ?
Hubert
Hi I Just installed super orders, made the file edits and so forth. But when I go to the super order page in admin i see no orders, only the following:
1054 Unknown column 'date_cancelled' in 'field list'
in:
[SELECT date_cancelled, date_completed FROM ABCorders WHERE orders_id = 57 AND (date_cancelled IS NOT NULL OR date_completed IS NOT NULL)]
Can someone tell me what to do about this?
Thanks
Jason
Hi Jason.
Did you run the super_orders_sql.sql in the sql tool?
Ronald.
Quote:
Originally Posted by azrahn
Ronald,
I thought I did. LOL! DUH! I went back and ran it again and surprise surprise, it works. Thanks!
Jason
Hi,
When printing order details I need to have the (partial) credit card number, CVV number, expiry details etc. included; is there an easy way to set this up? (I.e. so they're all included in the invoice..)
I worked it by simply adding the data/criteria to super_invoice.php as displayed in super_orders.php. You also have to modify the language/english files to get the correct headings....Quote:
Originally Posted by warstormer
In the Invoice I'm getting the Fed Tax # showing as FED_TAX_ID_NUMBER. Where is this specified?
Authorize AIM displays this info on the order details, so likely you can use the code shown in that module added to the SO invoice display if you collect the info with AIM - if you collect CC info with SIM you are not saving that data so cannot show it. If you are collecting for offline processing you would have to write up something similar to what is in the AIM module to ensure the entire card number is not shown.Quote:
Originally Posted by warstormer
just noticed that the text for fedex shipping option doesn't show up on the super_invoices it's blank
Have you set the Federal Tax Exempt Number in Admin Console -> Configuration -> Super Orders? I can't remember what it puts in there by default, I thought it was a number.Quote:
Originally Posted by warstormer
It should be noted that this is not a fix; you simply forced sending an email by changing an equality check to an assignment. This logic will *always* send a status update, irrespective of whether or not the "Notify Customer?" checkbox is checked. This may not be desirable, especially if you're in the habit of cracking wise about the customer in the comments box. :)Quote:
Originally Posted by topcat24
I recently fixed both the email test and the customer notified icon on the status page, and have submitted the fixes to Frank for approval.
Scott
On a related issue, customers can see all comments added to an order by checking their order history. So, again, any negative comments such as "this guy is a deadbeat" will be seen by the customer if they check their order history under their account. Someone suggested a good way to solve this in this thread: http://www.zen-cart.com/forum/showthread.php?t=46868Quote:
Originally Posted by swguy
Tremendous mod. Thanks.
Question: When I search in batch form printing (or elsewhere in superorders), it does not seem to be including a search of the comments section of the Status History. In other words, if you search for a word that only exists in one order in the comments section of Status History, then the search returns as nothing found.
Is this correct behavior? If so, is there an easy way to include the Status History content in my search?
Thanks,
Thomas
I do not understand this section in the readme:
Outstanding Payments
-------------------------
Location: Admin > Reports > Orders Awaiting Payment
This report displays all your outstanding payment paperwork. Each radio
button will search for orders that are missing the indicated transaction
piece
What is the "indicated transaction piece" for a regular order (i.e. not a PO)? How does the system know that a COD order is missing its payment?
Overall, I am not figuring this out. And when I search for any overdue payments in my system, I always get nothing. :cry:
Having got Super Orders in one zen-cart, I'm now confused as to why it's not working in another... I've added the catalog folder and run the .sql file but Super Orders does not appear in Admin > Customers. Have I forgotten something or is something just not right and I should start again?
Loooong day, and some folder/file confusion. Working fine now.... :blush:Quote:
Originally Posted by warstormer
Quote:
Originally Posted by CraigW
On my fresh install, it had 00-00000 (or something like that) as the default. So I think warstormer may have different problems.
I just installed SO and ran the SQL patch. Everything seemed to be working fine until I tried to place a test order.
The order goes through, a confirmation email is sent, but the order does not show up in the SO orders listing page. If you type in the exact order number, it appears. It also doesn't appear in the customer's account, unless you follow the link sent to that exact order number that was in the confirmation email.
I have SO working on my own store, but now that I'm trying to set up a store for a client, I can't get it to work.
Thanks in advance!
Similar problem. Here are the symptoms. Maybe someone can figure this out for us:Quote:
Originally Posted by hopedesigns
Zencart 1.3.7
SO version 2.0, fresh install (not upgrade)
I have been running SO for a few days with no problem.
Then a customer placed an order yesterday, normal emails were sent and received, and the order appeared in SO. We shipped it out and made some changes to the status as normal, but somewhere along the way, the order suddenly disappeared from the SO order list (it also disappeared from the regular non-SO order listing). It also disappeared from the customer's account overview screen. But same as your situation, the order was in fact still in the system, and could be pulled up and edited via the search function (search for the specific order number).
I checked the MySQL database and the order appeared there as normal BUT the order status was listed as "0" (instead of one of the normal choices of 1-5).
I then went back to the SO Order Listing page and ran a search again for the order number. The edit screen appeared for this order. I went to the bottom and noticed that although we had previously changed the status to "Delivered [3]" (and the status history confirmed that), the status pull down menu was showing "Pending [1]" now. So I again selected "Delivered" from the menu and clicked the update button....Presto!...the order reappeared again in the SO order listing.
OK, no problem, but it worries me more than a little and I am wondering if this will continue to happen over time? How can we fix this?
Any asisstance would be greatly appreciated! Thanks!:smile:
I did notice with this installation (also a fresh install) that the orders status options were arranged differently than with my other ZC install. Wonder if that might have something to do with it? I'm having all the other problems that thomasw98 mentioned as well.......or maybe you just did a better job of explaining than I did.........
Here's what worked for me.
I started playing around with orders status (both on the Localization -> Orders Status Page and on the Config -> Super Orders page). Most of the settings on the Super Orders page were set to "Default" - but when I changed them to the Processing that my client will be using, the orders started appearing.
In my case, it was just that the "Default" setting wasn't working right, but once I changed it, everything worked.
I'll give it a try. My problem is actually not ongoing, just sort of one random occurence which I am trying to understand and prevent in the future. But I think you could be right about something being wrong with those default settings. Will let you know if I discover anything else.
I just uploaded all super order data files. My problem is when I tried to upload or enter the query of super_order_sql file, it gives me this error
what's the problem? Can anyone help me on this?Code: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.
BTW, I'm using ZC v1.3.5
I've got a fresh install of 1.3.7 and the latest super orders.
When I press the BATCH FORM PRINT link I get a blank screen. I have redone the install several times without luck.
Any ideas on why the super_batch_forms.php isn't responding?
Tom
I have an interesting problem I hope you all can help with. I'm totally sold on Super Orders. However, I'm using both the USPS and UPS shipping modules. When people select overnight shipping, for example, super orders just says "UPS" in the order. If I switch over to the standard order system, the full line "UPS: overnight" (or whatever they selected) is there. So, the information is being captured by the system, but SO is not showing it. So, we have to log into the regular ordering system to see what shipping method they chose.
Anyone have any ideas?
You need to compare the two files in admin: super_orders.php and orders.phpQuote:
Originally Posted by swan
From what I can see, orders.php has this line:
$contents[] = array('text' => '<br />' . ENTRY_SHIPPING . ' ' . $oInfo->shipping_method);
And super_orders.php has this line:
$contents[] = array('text' => TEXT_INFO_SHIPPING_METHOD . ' ' . $shipping_method);
First backup the original super_orders.php file so that if this does not work, you can always switch back to the orginal.
Now try changing the shipping line in super_orders.php from the one above to:
$contents[] = array('text' => TEXT_INFO_SHIPPING_METHOD . ' ' . $oInfo->shipping_method);
I tested this and it works for me.
General Advice:
By the way, this is the logic I use for just about all of these type of problems. I have almost no clue about php coding, so I just use common sense to compare two lines or to make a guess at what I should modify. Most of the time it works. Just remember to always leave a trail of backup files to fall back on in case these type of hack experiments don't work. I usually have several versions of each backup file with indicative names like super_ordersBEFORESHIPPINGLINEADJUSTMENTTEST.php, etc. Even if the adjustment of the shipping line works out ok, I still leave the backup file on my harddrive for a few months just in case.