Admin Simple Create Order [Support Thread]

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

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?

cycochuck:

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.

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.:clap:

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

Greetings,

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

Any suggestions?

Also,

When placing a manual order through admin - it does not send an order confirmation to the customer...

Are others finding that this add-on is buggy?

For example, after creating an order and adding a product, when I change the tax amount and update nothing happens.

Are others encountering this problem?

We are running this addon on Zen Cart 1.3.9c.

We've received no error messages.

We are unable to edit orders or send the customer confirmation/welcome email after adding through admin.

We are interested in having different pay and ship modules currently installed in the store populate in the admin add order.

We can type them in, but they still show the mod's defaults (free shipper) on the customer's history screen (unless we've overlooked something).

We're looking into it, but sadly need more hours in the day...

Thanks for your work, Ivan. Peeking at your blog now.

I tried this module but had a few issues which i resolved such as :

1. database table error
2. it was setting default currenctysymbol as USD
3. the VAT / TAX is not adding to the create order total when doing a crate order on a product for a customer!

now the issue "3" i was not able to resolve - i did not spend a lot of time hunting through it all and debugging but i noticed all the code for the tax was there.... has anyone else had this issue? and if so managed to resolve it? if you resolved it mind sharing the fix :)

im using a VAT inc / ex mod on the and thinking it could be this but not sure....

Thanks,
James

I am having the same problem as previous poster.
I also have the inc/exc. VAT mod installed.
The problem is that the invoice only adds the exc. tax prices to the total, but in the text is says inc. tax.

I can't figure out how this happens.

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.

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:

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.:clap:

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.

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

I'm having similar issues:

1. Can't delete orders from the admin portal - annoying, but not crucial. I can delete them in the database manually if I really want to.

2. A confirmation email is NOT sent to the customer when I use the Create Order function. Nor is the [NEW ORDER] email sent to the Admin email addresses. This is a big problem for us, the customer needs to get the confirmation email and we need to know there is a new order - we have a group of people that manage fulfillment.

3. The "freeshipper" is the default shipping profile. Even if I type in something else in the FREE SHIPPING! field, it doesn't keep the data when submitted. The invoices still say "FREE SHIPPING!" ** Bad!** We don't offer FREE SHIPPING, ever.... How do I fix this??

Any help is greatly appreciated!

Thanks

lpettyjohn:

I'm having similar issues:

1. Can't delete orders from the admin portal - annoying, but not crucial. I can delete them in the database manually if I really want to.

2. A confirmation email is NOT sent to the customer when I use the Create Order function. Nor is the [NEW ORDER] email sent to the Admin email addresses. This is a big problem for us, the customer needs to get the confirmation email and we need to know there is a new order - we have a group of people that manage fulfillment.

3. The "freeshipper" is the default shipping profile. Even if I type in something else in the FREE SHIPPING! field, it doesn't keep the data when submitted. The invoices still say "FREE SHIPPING!" ** Bad!** We don't offer FREE SHIPPING, ever.... How do I fix this??

Any help is greatly appreciated!

Thanks

Same issues here..

1. i had an issue with the create customer from admin but was able to fix it with bye overiding this mods files with the add customers from admin mod files.

2. i noticed for edit orders the email you send to customers is not in the same format and really confuses the customers. like to have the same format email sent as the original carts order email.

3. the whole create an order is not great i just end up using log in as customers.

but would there be a way to set-up the create order section so you have the choosen customers group prices show up automatically, and all the shipping and payment options availible to be choosen via drop down or radio buttons.

also noticed that it automatically creates the order as soon as you choose the customer and the mod just sends you to a blank edit order page to fill with products it would be nice if you could at least confirm an order before it stores any info on the database.

Thought I'd share my experience with this mod.. This mod is using a much older and buggier version of Edit Orders so I decided to upgrade to Edit Orders 2.03. I made a few modifications to Edit Orders to use the same comments code as the latest version of Zen Cart (1.3.9) along with a few other minor cosmetic/functional updates to Edit Orders.

Next I updated all the Add Customers files with the latest version of Add Customers available.

Lastly if you downloaded this add-on from the Zen Cart downloads section, please note that there is an error in the submitted files that need to be corrected. 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;

> **MB1:**
>
> also noticed that it automatically creates the order  as soon as you choose the customer and the mod just sends you to a blank  edit order page to fill with products it would be nice if you could at  least confirm an order before it stores any info on the  database.I agree, but I think that this because of this add-on's dependence on Edit Orders is the reason why.. Edit Orders won't work if there is no order to Edit.. Not the greatest solution, but this is still a doable solution..

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       |
// | [email protected] 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'];
    }
  }

?>

rickcj:

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'];
}

}

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

So I'm still testing this.. Now that I've compared the version of this mod available here with the latest version of Edit Orders (v2.03) I'm going to see if I can figure out how to get this to work fully with the latest version of edit orders.. While I can create orders with the latest version of Edit Orders, what is missing is the ability to send an order confirmation e-mail to a customer and the shipping estimate data..

Also I noticed that regardless of which version of Edit Orders I use (the modified one that comes with this module or the latest version) the customer's street address comes through on the order without the state information. Very curious as I cannot see what in the code would cause this behavior..

Edited to Add: I see now the difference.. Customers who sign-up for an account in the store have a value in entry_zone_id but not in entry_state in the addressbook tables. While customers added using the Add Customer add-on will have an entry in entry_state but not in entry_zone_id. Seems that the create_orders.php code needs to accommodate BOTH kinds of customers..