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

[BlindSide]

Ok now, shake hands and make up...

That's better.

@wickedklown
Here's how to edit the packingslip...
1. Undo whatever you did.
2. Find this line...

        <td class="main"><?php echo $shipping_method; ?></td>

3. Replace with the following...

        <td class="main"><?php echo $order->info['shipping_method']; ?></td>

This time I bypassed all my string-stripping code entirely, calling upon the value stored in the order class when the packingslip is generated. You can use this value whenever the order class is instantiated. Look for this...

$order = new order($oID);

@s_mack
It's great to see users who recognize the volunteer and open-source nature of the contribs. Yeah there's always a few who make "fix it now" demands, but they are in the minority and I don't think that's wickedklown fell into that category (tho there's always next time ). I still appreciate your efforts to extract a more thorough answer; at least there's one person who can jump in to help if I get pulled away.

[tajul_ashyqin]

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...!

[crazycucumber]

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

[davale]

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?

[Bjorn]

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

[tiger]

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.

Thanks in advance!

[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?

[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?

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 ). 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.

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?

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.

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.

[wickedklown]

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?

[tiger]

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