Admin Simple Create Order [Support Thread]

[ivan.kristianto]

Hi this is the official support thread for Admin Simple Create Order module.
If you have any question please post here, i will try to answer if i can.

A brief information about this module:
I create this module 1 year ago. And this module is made from combining Create Customer mod and Edit Order mod.
I myself made the create order mod and add some feature into edit order mod.

Some people already email me or post it into my blog about the bugs. But most of the bugs is came from edit order module. So if you have solutions please share it with us.

Thanks.

Ivan

[cycochuck]

I installed the mod, but when I try to create an order I get this:

1054 Unknown column 'customers.customers_id' in 'where clause'
in:
[SELECT `customers_firstname` , `customers_lastname` , `customers_email_address` , `customers_telephone`, `entry_company` , `entry_street_address` , `entry_suburb` , `entry_postcode` , `entry_city` , `entry_state` , `entry_country_id` , `entry_zone_id` FROM zen_customers JOIN zen_address_book ON ( `customers_default_address_id` = `address_book_id` ) WHERE `customers`.`customers_id` = 6]
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.

Any idea on how to fix this?

[techiesrule]

I installed the mod, but when I try to create an order I get this:



Any idea on how to fix this?

I get the same thing.

[cycochuck]

Found a solution to my problem. Not sure if its the right way to do it since I'm not a coder, but whatever works.

in /admin/create_orders.php look at line 42. It will say:

WHERE `customers`.`customers_id` = ".$customer_id;

Change it so it now says:

WHERE ".TABLE_CUSTOMERS." . `customers_id` = ".$customer_id;

You may get the following error message after this fix:

Fatal error: Call to undefined function: zen_get_currency_value() in /home/content/n/e/w/newtonmrktng/html/flavorwood_store/admin/create_order.php on line 85

If you get this look in the /admin/create_orders.php file for the following:

'currency_value' => zen_get_currency_value(DEFAULT_CURRENCY),

and comment out the line. It should work now.

[Paul69]

Does anyone know if this is ok to use as is with 1.3.9B? I really need to know

[Convergence]

Greetings,

Seems to work fine so far, HOWEVER :) unable to delete any orders now...

Any suggestions?

[rickcj]

Found a solution to my problem. Not sure if its the right way to do it since I'm not a coder, but whatever works.

in /admin/create_orders.php look at line 42. It will say:

WHERE `customers`.`customers_id` = ".$customer_id;

Change it so it now says:

WHERE ".TABLE_CUSTOMERS." . `customers_id` = ".$customer_id;

You may get the following error message after this fix:


If you get this look in the /admin/create_orders.php file for the following:

'currency_value' => zen_get_currency_value(DEFAULT_CURRENCY),

and comment out the line. It should work now.

I found i was getting a blank page after fixing the initial table error.

Found the currency function is included in this addon in admin/includes/functions/extra_functions/edit_orders.php

To fix this just upload this file or add:

////////////////////////////////////////////////////////////////////////////////////////////////
  //
  // Function    : zen_get_currency_value
  //
  // Arguments   : currency_code		currency code string
  //
  // Return      : currency_value
  //
  // Description : Function to retrieve the currency_value based on the currency's code
  //
  ////////////////////////////////////////////////////////////////////////////////////////////////
  function zen_get_currency_value($currency_code) {

   global $db;
    $currency_query = $db -> Execute("select * from " . TABLE_CURRENCIES . " where code = '" . $currency_code . "'");

    if (!$currency_query->RecordCount()) {
      return 0;
    }
    else {
      return $currency_query->fields['value'];
    }
  }

to the end of this edit_orders.php file before the closing ?> tag.

This will make sure the currency symbol is inserted into the database for the order.

[breda]

Hi,
Did anyone get the Tax section working on this? I don't have any tax mods added on, just have 1 tax rate set to the products but when i create an order it brings up the tax rate in the tax box does not apply the tax onto the product price?

Regards,
Breda

[DivaVocals]

I implemented this by creating a extra functions folder for Create Orders (versus updating the one for Edit Orders).

I created admin/includes/functions/extra_functions/create_order.php with the the following code:

<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce                                       |
// +----------------------------------------------------------------------+
// | Copyright (c) 2007 Numinix Technology                           |
// |                                                                      |
// | http://www.zen-cart.com/index.php                                    |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license,       |
// | that is bundled with this package in the file LICENSE, and is        |
// | available through the world-wide-web at the following url:           |
// | http://www.zen-cart.com/license/2_0.txt.                             |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to       |
// | license@zen-cart.com so we can mail you a copy immediately.          |
// +----------------------------------------------------------------------+
/* 
 * @version $Id: edit_orders.php, v 1.0.0 12/11/2007 12:08:59 numinix $
 *
 */
 
  ////////////////////////////////////////////////////////////////////////////////////////////////
  //    Function    : zen_get_currency_value
  //    Arguments   : currency_code        currency code string
  //    Return      : currency_value
  //    Description : Function to retrieve the currency_value based on the currency's code
  ///////////////////////////////////////////////////////////////////////////////////////////////
  function zen_get_currency_value($currency_code) {
   global $db;
    $currency_query = $db -> Execute("select * from " . TABLE_CURRENCIES . " where code = '" . $currency_code . "'");
    if (!$currency_query->RecordCount()) {
      return 0;
    }
    else {
      return $currency_query->fields['value'];
    }
  }

?>

I found i was getting a blank page after fixing the initial table error.

Found the currency function is included in this addon in admin/includes/functions/extra_functions/edit_orders.php

To fix this just upload this file or add:

////////////////////////////////////////////////////////////////////////////////////////////////
  //
  // Function    : zen_get_currency_value
  //
  // Arguments   : currency_code        currency code string
  //
  // Return      : currency_value
  //
  // Description : Function to retrieve the currency_value based on the currency's code
  //
  ////////////////////////////////////////////////////////////////////////////////////////////////
  function zen_get_currency_value($currency_code) {

   global $db;
    $currency_query = $db -> Execute("select * from " . TABLE_CURRENCIES . " where code = '" . $currency_code . "'");

    if (!$currency_query->RecordCount()) {
      return 0;
    }
    else {
      return $currency_query->fields['value'];
    }
  }

to the end of this edit_orders.php file before the closing ?> tag.

This will make sure the currency symbol is inserted into the database for the order.

[creativeone]

I am using Admin Simple Create Order so that my client can add any physical orders they receive by check via mail. I can't seem to find a way to change the payment method from Credit Card to Check. Is there a way to do this? Thanks.