OLD Super Orders 2.0 (See v3.0 thread instead)

crazycucumber:

Hi , Ive installed this for a client on his live site , and he loves the functionality , but when updating the status , and clicking to notify customer , it does,t send the e-mail , I can send the e-mail from the original zen orders singular , but on the batch update , even selecting one customer to notify , does not seem to work .

I am using 1.3.5d , latest version of Super orders , and the sendmail function .

Can anyone shed any light on this ?

Cheers

this issue had been raised on another thread for the old version of SO but as far as i can remember, there was still no solution to it... so, we have to wait the clarification from Blindside...! :D

Look forward to hearing from BlindSide on this one . I'm guessing then that I'm not the only person suffering from this. !

Tried to insert the customers first name into the emails send by SO for hours now but can't get it to work.

I know I have to edit the admin/includes/functions/extra_functions/super_orders_functions.php but all my attempts to use existing and new queries and arrays have failed. Guess my limited knowledge of SQL is playing a major roll here because I'm convinced that it should not be to hard to do.

Anyone willing to help me out here?

Try this, change the customer from the edit screen, then do a search for that customer from Admin > Customers > Customers. When you find that customer, pull up the orders that are attached to them...viola.

Same result, customer_id left unchanged in the orders table. My SQL log shows no update command in reference to the order table, why would the update query not pass yet the insert works fine? Split function works like a charm.

Bjorn

Hi

First of all thank you for creating this contribution. From the readme file it looks great. Unfortunately i have a problem somewhere in my database and so its not reading your sql file correctly. I am using MySQL4.0 with Super Orders v2. The error message i am receiving is:

SQL query: Documentation

-- Following is for a future release
-- Bar code display

• • INSERT INTO configuration
    VALUES (
    NULL , 'Display bar codes', 'BC_ENABLE', 'true', 'If enabled, a bar code of the order number will appear on invoices and packing slips.', 28, 99, now( ) , now( ) , NULL , 'zen_cfg_select_option(array(''true'', ''false''),'
    )

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '--INSERT INTO configuration VALUES (NULL, 'Display bar codes',

I found someone else with a similar error message on this forum and the problem was with the syntax on order's. However, I think this must have been in a previous version of super orders because i searched the sql file and cannot find order's or any other word containing an '.

Any help would be HUGELY appreciated as i am at a complete loss to find where i've gone wrong. :down:

Thanks in advance!

Blindside, Im having another issue, and i dont know if it just started or what..

its pretty odd too.

It seems that all my orders that are paid via authorize.net or creditcard, are showing as payments made and completed, however above it i get these extra payments which are $0.00. Im not sure why they are there, or what they are for since they just apperied on there own.

the really crazy part of it is - for some reason they say the year of 1969
like this
" $0.00 12/31/1969 18:59:59 12/31/1969 18:59:59"

some orders only have one of these extra payments, others have up to 3 of them.

what is going on? is it another contrib that is doing it? or what?

@crazycucumber et. al.
Regarding e-mails not going out in the batch updater. I got way behind on the old SO support thread, so this is the first I'm hearing about this. I'll have to take a look at the code for some ideas, but is this limited to those who use a local e-mail server? (Local server is Admin > Configuration > E-mail Options > E-Mail Transport Method > "sendmail"). Can you send order update e-mails without issue from the SO order details page?

tiger:

First of all thank you for creating this contribution. From the readme file it looks great. Unfortunately i have a problem somewhere in my database and so its not reading your sql file correctly. I am using MySQL4.0 with Super Orders v2. The error message i am receiving is:

SQL query: Documentation

-- Following is for a future release
-- Bar code display

• • INSERT INTO configuration
    VALUES (
    NULL , 'Display bar codes', 'BC_ENABLE', 'true', 'If enabled, a bar code of the order number will appear on invoices and packing slips.', 28, 99, now( ) , now( ) , NULL , 'zen_cfg_select_option(array(''true'', ''false''),'
    )

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '--INSERT INTO configuration VALUES (NULL, 'Display bar codes',

I found someone else with a similar error message on this forum and the problem was with the syntax on order's. However, I think this must have been in a previous version of super orders because i searched the sql file and cannot find order's or any other word containing an '.
That code at the end of the SQL file is for a future release (yes, I want to add barcode support :smile: ). If that piece of code is giving you grief, just get rid of it. Anything that starts with a double dash (--) is a comment and can be deleted from the file without worry.
wickedklown:

Blindside, Im having another issue, and i dont know if it just started or what..

its pretty odd too.

It seems that all my orders that are paid via authorize.net or creditcard, are showing as payments made and completed, however above it i get these extra payments which are $0.00. Im not sure why they are there, or what they are for since they just apperied on there own.

the really crazy part of it is - for some reason they say the year of 1969
like this
" $0.00 12/31/1969 18:59:59 12/31/1969 18:59:59"

some orders only have one of these extra payments, others have up to 3 of them.

what is going on? is it another contrib that is doing it? or what?
The date you see is the default when the value is poorly formed or invalid. The time appears valid, however (usually appears as 00:00:00 or 23:59:59 when borked). Are you using the US standard date format? Do you have any other modules that mess with date functions or formats?

Bjorn:

Same result, customer_id left unchanged in the orders table. My SQL log shows no update command in reference to the order table, why would the update query not pass yet the insert works fine? Split function works like a charm.
Did you check the box that appears next to the text "Point order at a different customer:"? This box must eb checked for the customer change to occur. It'sa fail safe to prevent users with fast fingers from inadvertently changing the customer.
davale:

Have just installed the latest version of SO on 1.3.5. But, like crazycucumber, mails are not sent when 'Notify customer' is selected. Using smtpauth, the initial message is sent so my smtp is working. Did add several more order status.

Edit: While hitting the send button I wondered if the mails were somehow marked as spam. Just checked and they were. Don't have a clue why the initial mail is not and the follow ups are.

crazycucumber, could this be what's causing your problem?
Spam is always a suspect cause. If you are having this problem, make sure you are looking in spam folders. Unfortunately, this not something that I can help you with. My advice is to train your spam folders better, warn your customers when they sign up about (give them the "from" address), keep an eye on blacklists to make sure you aren't listed, and (if all else fails) change the text in the e-mail.

BlindSide:

The date you see is the default when the value is poorly formed or invalid. The time appears valid, however (usually appears as 00:00:00 or 23:59:59 when borked). Are you using the US standard date format? Do you have any other modules that mess with date functions or formats?

Im pretty sure im useing US standard date format, is there a setting for that? or is this set from my server and its settings?
i dont believe that i have any of modualy that mess with dates at all. as far as i know.

i believe that the rest of them do show that time you stated.
why is this happening? somtimes there are 3 of them on an order. and always there is a correct one that shows the true payment data.

any thing you can advise for me?

YEAY! THANK YOU BLINDSIDE - IT WORKED! :P Your help is epically appreciated!

wickedklown:

Im pretty sure im useing US standard date format, is there a setting for that? or is this set from my server and its settings?
i dont believe that i have any of modualy that mess with dates at all. as far as i know.

i believe that the rest of them do show that time you stated.
why is this happening? somtimes there are 3 of them on an order. and always there is a correct one that shows the true payment data.

any thing you can advise for me?
These bad dates are appareaing on the Order Details page, on the green payment lines, correct? Open admin/super_orders.php. Find this line...

<td class="paymentContent" align="center"><?php echo zen_datetime_short($so->payment[$a]['posted']); ?></td>

This line and the one directly below it use the zen_datetime_short() function. Remove that function from both lines, so it looks like this...

<td class="paymentContent" align="center"><?php echo $so->payment[$a]['posted']; ?></td>
<td class="paymentContent" align="center"><?php echo $so->payment[$a]['modified']; ?></td>

Upload the file, look at an order with the offending dates, and tell me what they read as. (Dev note: The dates being displayed are now exactly what is being stored in the DB. By looking at these values we can tell if they are not being stored correctly, or if your shop's coding is at fault.)

tiger:

YEAY! THANK YOU BLINDSIDE - IT WORKED! :P Your help is epically appreciated!
Glad to hear it. :smile:

BlindSide:

@crazycucumber et. al.
Regarding e-mails not going out in the batch updater. I got way behind on the old SO support thread, so this is the first I'm hearing about this. I'll have to take a look at the code for some ideas, but is this limited to those who use a local e-mail server? (Local server is Admin > Configuration > E-mail Options > E-Mail Transport Method > "sendmail"). Can you send order update e-mails without issue from the SO order details page? ........
.......
Spam is always a suspect cause. If you are having this problem, make sure you are looking in spam folders. Unfortunately, this not something that I can help you with. My advice is to train your spam folders better, warn your customers when they sign up about (give them the "from" address), keep an eye on blacklists to make sure you aren't listed, and (if all else fails) change the text in the e-mail.

My settings are set to sendmail , I will try and get SMTP set up and working and test it that way.

Don't think it is spam , as the red cross is appearing in the update customer box etc . as if it never sent. Could it be a permissions thing ? I installed the easy Admin tool thing ( before super orders ) to create new users under admin , I have set myself and other user full perms to the super orders mod , but still no joy ! .

BlindSide:

These bad dates are appareaing on the Order Details page, on the green payment lines, correct? Open admin/super_orders.php. Find this line...

<td class="paymentContent" align="center"><?php echo zen_datetime_short($so->payment[$a]['posted']); ?></td> ``` > This line and the one directly below it use the zen_datetime_short() function. Remove that function from both lines, so it looks like this... > ``` <td class="paymentContent" align="center"><?php echo $so->payment[$a]['posted']; ?></td> <td class="paymentContent" align="center"><?php echo $so->payment[$a]['modified']; ?></td> ``` > Upload the file, look at an order with the offending dates, and tell me what they read as. (**Dev note:** The dates being displayed are now exactly what is being stored in the DB. By looking at these values we can tell if they are not being stored correctly, or if your shop's coding is at fault.)

by offending dates - you mean find an order that has 2 payments, one with correct data and one with $0.00. and the dates should NOT match?

This is my most current order. This is the second payment created (YES in green payments bar) it now shows all 0's
$0.00 0000-00-00 00:00:00 0000-00-00 00:00:00

Unfortunitly, the manager told them to remove the other payment data that was not valid- so that is now the only one that i have showing 2 payments.

i told them to leave them be for now, becuase i need to look at them. so when the next order comes in, ill post what it says.
if this is a coding problem within my site, how will i track it down, and is there someone here that i can hire to fix it?
thanks again for your time BS- im sorry to be a pain..

BlindSide:

@crazycucumber et. al.
Regarding e-mails not going out in the batch updater. I got way behind on the old SO support thread, so this is the first I'm hearing about this. I'll have to take a look at the code for some ideas, but is this limited to those who use a local e-mail server? (Local server is Admin > Configuration > E-mail Options > E-Mail Transport Method > "sendmail"). Can you send order update e-mails without issue from the SO order details page?

Confirmation that SMTP does not batch while status update emails send fine.

BlindSide:

@crazycucumber et. al.
Did you check the box that appears next to the text "Point order at a different customer:"? This box must eb checked for the customer change to occur. It'sa fail safe to prevent users with fast fingers from inadvertently changing the customer.

:) Stupid me. Uncomment the following line found in admin/super_edit.php: ```php
//$update['customers_id'] = $_POST['customers_id'];

to

```php
$update['customers_id'] = $_POST['customers_id'];

The original file comments out the above code as well Frank. Thanks for the support and the contrib! Take care,

Bjorn

Optional Edits QUESTION!

Blindside,
hay man
i setup some of the optional file edits. and i noticed something about the define for super orders in place of the standard orders.php system.

when im at the admin homepage, and i click on one of my new orders, it only takes me to the listing for new orders, it dont take me directly to that order that i selected.

I noticed that the link isnt that same as when i call them from super_orders itself.

is there any way to correct this? how do i change the link to go directly to a customers order.

action=edit?oid=
somthing like that?

when a customer pays by paypal and it auto updates the status of the order it appears that it si not actually applying the payment to the invoice total for this order (see below to understand what i meen as its awkward to explain)

basically as you can see in the picture below on the part marked as (A) we have recieved a paypal ipn payment but if you look at the part marked (B) that payment has not been applied to the account or the invoice total so this meens that according to (C) there is still £18.45 oustanding

is there any way to get this to auto update without me having to make a manual adjustment and apply the money manually??

nevermind i fixed it.

i changed the index.php under admin to add the fallowing action=edit&oid=

around line 171 (i have a customized index page) find the code

<div class="row"><span class="left"><a href="' . zen_href_link(FILENAME_ORDERS,

right after that you will see:

'oid='

change to

'action=edit&oid='

that will bring up the corrisponding order in super_orders.php

NOTE: you must have changed the OPTIONAL FILE EDIT for filenames.php in /includes/

modchipfitters.co.uk:

when a customer pays by paypal and it auto updates the status of the order it appears that it si not actually applying the payment to the invoice total for this order (see below to understand what i meen as its awkward to explain)

basically as you can see in the picture below on the part marked as (A) we have recieved a paypal ipn payment but if you look at the part marked (B) that payment has not been applied to the account or the invoice total so this meens that according to (C) there is still £18.45 oustanding

is there any way to get this to auto update without me having to make a manual adjustment and apply the money manually??

you will have to manualy add the paypal payment to the order for now.
Blindside said that he already has that automated for the next release.

all of us have to do it for now. Its pretty simple. and really you dont want paypal data to be automated if you accept e-checks via paypal. they take about a week to clear, and your sales report would be incorrect if it was auto added.

just add the payment data into super orders and it will show you the correct ballance.

hope that helps.

ok thanx

just gonna be a bit of a pain when i gotta do it for 40-50 orders a day lol

any idea when the new release will be showing its head??

btw 1 other thing how can i add paypal to the drop down box when im applying a payment cause at the mo there cash cheque and various credit card types but no paypal

heres the box that i meen

modchipfitters.co.uk:

btw 1 other thing how can i add paypal to the drop down box when im applying a payment cause at the mo there cash cheque and various credit card types but no paypal

heres the box that i meen

in the admin console, under LOCALIZATION, youll find PAYMENT TYPES

you can add/delete payment types and refund types from there.