Zen Cart Logo
Forums / All Other Contributions/Addons / OLD Super Orders 2.0 (See v3.0 thread instead)

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

Locked

Views: 456,068

Results 521 to 540 of 2,020
This thread is locked. New replies are disabled.
14 Apr 2007, 5:27 AM
#521
mb1 avatar

mb1

Totally Zenned

Join Date:
Jun 2006
Posts:
565
Plugin Contributions:
0

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

Just got this error when trying to install the sql with the zen cart sql patch installer in the tools section

1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO storeso_payment_types VALUES (NULL, 1, 'CA', 'Cash');]

14 Apr 2007, 1:33 PM
#522
hound avatar

hound

New Zenner

Join Date:
Jan 2007
Posts:
59
Plugin Contributions:
0

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

I'm getting this error:

Fatal error: Call to undefined function so_close_status() in /home/wholesom/public_html/admin/super_orders.php on line **1172

Searching the forum, it says that this is addressed in this thread, but I cannot find it. With over 53 pages of posts, does anyone have a link to the post?

Thanks
**

14 Apr 2007, 1:49 PM
#523
hound avatar

hound

New Zenner

Join Date:
Jan 2007
Posts:
59
Plugin Contributions:
0

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

Nevermind. I just found the post (#416) and no one bothered to reply to it. Is there no solution to this problem?:frusty:

14 Apr 2007, 2:32 PM
#524
mb1 avatar

mb1

Totally Zenned

Join Date:
Jun 2006
Posts:
565
Plugin Contributions:
0

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

mine seems to work fine right now even with that error. but i don't have super order as an option in my admin/configuration section what's going on i wanted to play with a few things?

another thing how would you go about adding the new phone and fax numbers to the contact us pages?

14 Apr 2007, 3:09 PM
#525
mb1 avatar

mb1

Totally Zenned

Join Date:
Jun 2006
Posts:
565
Plugin Contributions:
0

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

can you edit orders with this or do i still need my edit orders module?

14 Apr 2007, 5:07 PM
#527
mb1 avatar

mb1

Totally Zenned

Join Date:
Jun 2006
Posts:
565
Plugin Contributions:
0

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

thanks mark i'm going to look that up right away

14 Apr 2007, 5:42 PM
#528
mb1 avatar

mb1

Totally Zenned

Join Date:
Jun 2006
Posts:
565
Plugin Contributions:
0

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

ok got the edit orders working with it but all in all that module sucks

MB1:

mine seems to work fine right now even with that error. but i don't have super orders as an option in my admin/configuration section what's going on i wanted to play with a few things?

really like to see what you can do with this module i also get this added line when i look at my invoices and print them out Fed Tax ID #FED_TAX_ID_NUMBER

14 Apr 2007, 5:59 PM
#529
uswebworx avatar

uswebworx

Zen Follower

Join Date:
Sep 2006
Location:
USA
Posts:
297
Plugin Contributions:
0

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

MB1:

another thing how would you go about adding the new phone and fax numbers to the contact us pages?

This can be done here: store/includes/languages/english/html_includes/TEMPLATE_OVERRIDE/
If you are using the template override system if not then it would be store/includes/languages/english/html_includes/

Hope this helps you abit. I am installing super orders in a store so I knew exactly where that was, just did as a matter of fact.

16 Apr 2007, 1:15 AM
#530
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

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

MB1:

really like to see what you can do with this module i also get this added line when i look at my invoices and print them out Fed Tax ID #FED_TAX_ID_NUMBER
You didn't install the SQL properly. This defineis stored in the configuration table. It should appear in Admin > Configuration > Super Orders. It will be hidden as long as it's installed properly, and has an empty value.

16 Apr 2007, 2:33 AM
#531
mb1 avatar

mb1

Totally Zenned

Join Date:
Jun 2006
Posts:
565
Plugin Contributions:
0

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

allright i went and took off the code the posted the fed tax thingy on the invoice.

how would i go in my sql database and fix this manually so that Admin > Configuration > Super Orders actually appears and in the admin section and i can fix the fed tax thingy. there is no backup of the database that's worth looking at. as i've been learning how to do this as i go and i believe i attempted to install this mod months ago unsuccessfully and just continued upgrading and running my store so i don't have a back-up of a before i installed this sql patch

PM me if this goes beyond regular advice.

also i noticed that my months order total is different when i calculate super orders then on my sales report, i'm wondering what could be going on

16 Apr 2007, 2:39 AM
#532
mb1 avatar

mb1

Totally Zenned

Join Date:
Jun 2006
Posts:
565
Plugin Contributions:
0

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

you know what would be awesome, intergrating super orders, sales report and edit orders and having it working perfectly. that would be the cats meow of mods

16 Apr 2007, 12:20 PM
#533
mb1 avatar

mb1

Totally Zenned

Join Date:
Jun 2006
Posts:
565
Plugin Contributions:
0

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

just noticed today that orders from out of province state NONE! in te tax table when it should really state 6%, the taxes calculated at the end is ok just not a big fan of this NONE! printed on the invoice

16 Apr 2007, 1:20 PM
#534
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

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

MB1:

allright i went and took off the code the posted the fed tax thingy on the invoice.

how would i go in my sql database and fix this manually so that Admin > Configuration > Super Orders actually appears and in the admin section and i can fix the fed tax thingy. there is no backup of the database that's worth looking at. as i've been learning how to do this as i go and i believe i attempted to install this mod months ago unsuccessfully and just continued upgrading and running my store so i don't have a back-up of a before i installed this sql patch
The SQL file didn't install properly, so that's what you have to do. Go back to the contrib download, grab the SQL file, and start comparing the lines of the file to your DB. You'll need to use phpMyAdmin.

SQL code is pretty easy to break down: look for a table with the name and fields specified when it says "CREATE TABLE"; look for specific table entries where it says "INSERT INTO."

If anything is missing or incomplete, delete the bad entry and rerun the associated line from the SQL file. You just copy and paste the code into the SQL box (click the "SQL" tab along the top).

also i noticed that my months order total is different when i calculate super orders then on my sales report, i'm wondering what could be going on
How are you calculating in the Sales Report? The Sales Report gives provide a huge range of options, make sure they are set properly. See the readme for details. What SO report are you comparing to?
MB1:

you know what would be awesome, intergrating super orders, sales report and edit orders and having it working perfectly. that would be the cats meow of mods
I can't speak for edit orders, but the Sales Report and Super Orders work just fine together. I know that because I wrote both, and use them in my own store. The next version of Super Orders will actually have the Sales Report bundled with it.

As for edit orders, I am working on replicating the intended functionality of that mod, also for the next release. The problem with that contrib is that it is based on a very old contrib. I actually included a modified version of it in the first SO release.

MB1:

just noticed today that orders from out of province state NONE! in te tax table when it should really state 6%, the taxes calculated at the end is ok just not a big fan of this NONE! printed on the invoice
Fix the SQL file as described above and this problem should go away. The FED_TAX_ID_NUMBER define does some magic with tax displays on the invoice and packing slip.

17 Apr 2007, 9:54 PM
#535
mikeyg avatar

mikeyg

Totally Zenned

Join Date:
May 2005
Posts:
515
Plugin Contributions:
0

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

Blindside,

Testing locally still but just tried to do a batch status update and got this error.

1264 Out of range value adjusted for column 'customer_notified' at row 1
in:
[INSERT INTO fmorders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) VALUES ('3844', '2', now(), '', '')]
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 5 orders on same day.

Any fixes? If I missed it in the thread forgive me it is rather a long topic now.

Many thanks

MG

18 Apr 2007, 5:05 AM
#536
mb1 avatar

mb1

Totally Zenned

Join Date:
Jun 2006
Posts:
565
Plugin Contributions:
0

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

thank you for the quick reply i hope i have time in the next few days to take a look at the phpadmin thingy which i hope won't be to hard as i have never attempted it before.

kep up the great work i look forward to your future mods

18 Apr 2007, 12:16 PM
#537
mikeyg avatar

mikeyg

Totally Zenned

Join Date:
May 2005
Posts:
515
Plugin Contributions:
0

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

Blindside,

I have at last gone live with my upgrade so on version 1.3.7 Yippeeee!

However couple of small niggles.

First one I have posted above regarding the error when using the batch update status.

The second question is regarding the payment gateway and how do I get orders placed using a credit card over the web through the protx gateway to come up in Super orders with the payment details and status as paid.

If I have missed the instructions some where I apologies. I am hoping that I do not have to enter the payment details for every order that goes through the web sight and protx okay.

Thanks

MG

19 Apr 2007, 7:12 AM
#538
aeolidia avatar

aeolidia

Zen Follower

Join Date:
Mar 2005
Posts:
166
Plugin Contributions:
0

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

I installed super orders on a 1.3.7 site and everything is working fine in the admin, but when you click to confirm your order (last stage of checkout), you get this error:

Fatal error: Call to a member function on a non-object in /home/blablabla/includes/classes/order.php on line 891

When I remove the chunk of code needed for super orders from order.php, the order goes through just fine.

Here is the code that seems to be causing me trouble:

// 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

I'm stuck! Thanks.

19 Apr 2007, 2:30 PM
#539
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

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

MikeyG:

I have at last gone live with my upgrade so on version 1.3.7 Yippeeee!

However couple of small niggles.

First one I have posted above regarding the error when using the batch update status.
First off, congrats! The first one is always the hardest.

Yeah I looked at that one. I think it has something to do with the structure of the table. Try this: open admin/includes/functions/extra_functions/super_orders_functions.php and scroll down to the function update_status(). After the call to global $db (first line inside the function), add the following code:

  if ($notified == '') {
    $notified = 0;
  }

Upload and see what you get.

The second question is regarding the payment gateway and how do I get orders placed using a credit card over the web through the protx gateway to come up in Super orders with the payment details and status as paid.

If I have missed the instructions some where I apologies. I am hoping that I do not have to enter the payment details for every order that goes through the web sight and protx okay.
Someone PM'd me with the same question, just for a different gateway. The answer is the same: you need to get your payment gateway to input the payment data to the Super Orders tables. If the gateway uses the cc_ fields in the orders table, this should happen automatically if you properly modified the catalog-side order class as described in the readme.

If it does not use those fields, then you need to do a little coding (emphasis on the "little"). Open includes/classes/super_order.php and take a look at the function cc_line_item(). There you'll find the logic to add lines to the SO payment tables.

Make a copy of this function, rename it, and simply modify it to look at the payment information created by your payment gateway, instead of the stuff in orders. Finally, replace cc_line_item() with this function in the catalog-side order class. I hope that doesn't sound more complicated than it is; all you need is some PHP knowledge.

aeolidia:

I installed super orders on a 1.3.7 site and everything is working fine in the admin, but when you click to confirm your order (last stage of checkout), you get this error:

Fatal error: Call to a member function on a non-object in /home/blablabla/includes/classes/order.php on line 891

When I remove the chunk of code needed for super orders from order.php, the order goes through just fine.

Here is the code that seems to be causing me trouble:

// 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

> 
> I'm stuck! Thanks.
Sounds like you didn't upload the super_order.php class to the catalog.  The class needs to go in admin/includes/classes/super_order.php **and** includes/classes/super_order.php.  The module download has the file in both places, you just need to upload the whole thing (i.e. not just the "admin" folder).
20 Apr 2007, 1:35 AM
#540
aeolidia avatar

aeolidia

Zen Follower

Join Date:
Mar 2005
Posts:
166
Plugin Contributions:
0

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

BlindSide:

Sounds like you didn't upload the super_order.php class to the catalog. The class needs to go in admin/includes/classes/super_order.php and includes/classes/super_order.php. The module download has the file in both places, you just need to upload the whole thing (i.e. not just the "admin" folder).

Mysterious! I uploaded all the files when I installed and I just now double checked my /admin/includes/classes and /includes/classes folders and both have their own super_order.php file. Is there anything else I should be looking at?

What does the code chunk that goes on order.php do, exactly? If I can't solve it, is it safe to leave it out?