Quick Order

This module will let your customers add multiple products to cart at once by inserting the products' model numbers and quantities for the order into a simple form.
You will also be able to add any amount of products to cart by entering an URL, see readme for more details.

This mod assumes that product models are unique.
The mod does not work with attributes since products with attributes do not currently have a unique ID for each attribute variation in Zen-Cart.

Get the latest version from the Zen-Cart downloads area

Version 1.2.3 is now available for download.
Get the latest version of Quick Order.

Changelog:

Quote:

---

1.2.3 (2007.04.16) - Modified by Eivind E. Valderhaug

- Properly display path in breadcrumbs (Home :: Order Online).

- Set optional limit and order-by clause in config file (qo_settings.php) for similar matches results when product models are not found.

Previously if a product model was not found, all products that had similar product models would be displayed.

This can now (easily from the config file) be limited to a number and the result can be ordered by one or more columns in the products or products_description tables.

- Use common html header instead of custom header.

The downside is that the custom css file won't get included unless it's copied to the current template css directory.

---

Just a notice for those also using the SEFU mod by Tim Kroeger: See this post for how to get these 2 mods to work together properly.
I haven't verified this because I don't use the SEFU mod.

Quote:

---

Originally Posted by dwno

The mod does not work with attributes since products with attributes do not currently have a unique ID for each attribute variation in Zen-Cart.

:

---

Guess what, I am trying to solve this problem and in the process have discovered something in functions_general.php:

function zen_get_uprid($prid, $params) creates that unique "productid & attribute mix identifier" that is inserted into the cart.

function zen_get_prid($uprid) is used to extract the product ID from this identifier, but can be adapted to take it apart if necessary.

This could be a perfect way to define a unique product/attribute mix to be put into cart with the "single click URL" feature of Quick Order.

You can see the actual use in actionAddProduct in includes/classes/shopping_cart.php

I know, I know, you are thinking "if you are such a smartass to have done all this research, why don't you make it happen?"

Well, because I have never written more than 6 lines of PHP code, and this one would effectively require one to create an admin version of the cart - with the "product+attribute mix ID" field... :cry:
I just hope someone ;-) will find this useful and just GOES FOR IT

I'm afraid it's not that easy. Besides, even if it was you'd have to enter things like "59:3b270c58dc0fb4406c0036abeb0b41d4" into the input fields to specify the product "model" for a given attribute variation, and I don't think most customers would be comfortable with that. ;)

Why it's not so easy? Because the function you mention uses md5 encryption (can't be decrypted) on the attribute data to make it unique and so you would need a md5-hash-to-attribute-variation mapping that maps all possible attribute variations to their respective md5 hashes. That's a bad idea though for several obvious reasons. There are better ways of doing it, but it involves too much work for me to do for free anyway and I have no idea how much time it would take. I guess SKU-support would deal with this issue.

Btw, the only thing zen_get_prid() is removing the attribute md5 hash to return the product ID of the base product (without attributes).

Quote:

---

Originally Posted by dwno

I'm afraid it's not that easy. Besides, even if it was you'd have to enter things like "59:3b270c58dc0fb4406c0036abeb0b41d4" into the input fields to specify the product "model" for a given attribute variation, and I don't think most customers would be comfortable with that. ;)

Why it's not so easy? Because the function you mention uses md5 encryption (can't be decrypted) on the attribute data to make it unique and so you would need a md5-hash-to-attribute-variation mapping that maps all possible attribute variations to their respective md5 hashes. That's a bad idea though for several obvious reasons. There are better ways of doing it, but it involves too much work for me to do for free anyway and I have no idea how much time it would take. I guess SKU-support would deal with this issue.

Btw, the only thing zen_get_prid() is removing the attribute md5 hash to return the product ID of the base product (without attributes).

---

Got it. I missed the MD5 angle. Damn! - it was such a beautiful dream...

Granted, I use Quick Order not in the way you intended - I never display the form, just generate the URLs that are later embedded into my Wordpress pages, sort of "1-click Add-to-Cart".

Oh well, some day, when I am better at PHP...

BTW, you still get my eternal gratitude for Quick Order as it is:D

Is there some way that the quick order function can be built in to a product page, or into the product order process? Rather than go down the track of setting up attributes - which would get far too messy given the options I have, I would like to have the option to select other products (accessories). If I could get the quick_order thing to function as an adjunct to a product order, that would do it for me.

DWNO,

here is a small improvement (or so I hope) - please review and incorporate into your code (or kill it if it is horribly wrong).

The following code extends Quick Order to handle ONE (1) REQUIRED attribute.

So, if you are adding a product via Quick Order and it has REQUIRED attributes, the product will be added into the cart together with one of them (first in the database). Optional attributes are ignored.

Why only one? - I actually do not know. The SQL query should return all of the required attributes, but it does not. I have run the query in phpMyAdmin, and it works just fine. So, after two hours of banging my head against the wall, I am posting my code here in hope that someone way more qualified takes it and makes it work for multiple required attributes.

So, the only changes are in the includes/modules/pages/quick_order/header_php.php file around line 185 or so. I am posting a bit of code around mine as well, so that you can see where it belongs. All my comments and variables have "aa" prefix.

PHP Code:

---

                        //only add if does not exceed maximum
                        if (($add_max == 1 and $cart_qty == 1)) {
                            // do not add
                        } else {

// AA get product attributes
      $aa_attributes_db = $db->Execute("select options_id, options_values_id from " . TABLE_PRODUCTS_ATTRIBUTES . "
                             where  products_id = '" . $qo_item_info['pid'][$i] . "' and attributes_default='1'");

      $aa_attributes = array($aa_attributes_db->fields["options_id"] => $aa_attributes_db->fields["options_values_id"]);

                            // check for min/max and add that value or 1

// AA: Original code was:     $_SESSION['cart']->add_cart($qo_item_info['pid'][$i], $cart_qty+$new_qty);
                            $_SESSION['cart']->add_cart($qo_item_info['pid'][$i], $cart_qty+$new_qty, $aa_attributes);  // <-AA put new total of the product into cart by ID
                        }


                    }//end if (isset...
                } //end for $i < $total_models

                zen_redirect(zen_href_link(FILENAME_SHOPPING_CART, zen_get_all_get_params($parameters)));

            } //end if $error === false 


---

As you can see, it's just three extra lines. I am also attaching the full modified file.

What do you think? :smartalec:

Oh, and if anyone wonders why even a single required attribute is important... imagine that the product is a downloadable document! (that's why I needed it)

A>

Thank you for this wonderful mod. This is virtually what I was looking to do.

Question: I would like for customers to be able to type in either model numbers OR product names in the input fields. In this particular case, all model numbers and product names will be unique. I've tried modifying the header_php.php file at line 123 without success as I have limited php/sql experience. Could someone possibly offer some suggestions in achieving this?

Here is line 123 of header_php.php:

PHP Code:

---

$next_product_id = mysql_query(sprintf('select p.products_id, p.products_model from %s AS p where (p.products_model = \'' . implode("' OR p.products_model = '", $qo_item_info['model']) . "')", $db->prepare_input(TABLE_PRODUCTS)), $db->link); 


---

Hello andrabr

I like the idea of your code. I am sure it doesnt work on my setup as I have Attributes stock mod. I will try it again when the next zencart comes out, and do a fresh install.

Regards,

Heathenmagic

I cannot get quickorder to work.

http://scw.pepperspalace.com/cart/in...ge=quick_order

When I paste in either a product ID or description I get an error.
Invalid item number: 584

Here is a screenshot.
http://i52.photobucket.com/albums/g6...persPalace.jpg

Is this just a newbie mistake or is quick order broken.

I don't have time to support this at the moment, but I can answer the last post. :)

lifetimewebhost, Quick Order works with products_model, not products_id, and requires the product model for all your products to be unique. You'll probably want to display the product model on your product pages, so your customers know them.

I am creating an order form for a chain of restaurants we supply and they complain that the products are hard to find. Is there a way to sort the products alphabetically by name/model on the order page?

dwno,

Thanks for this wonderful mod! It fits perfectly into my store.

One question I have is if there is any way to turn the fields into "secure" fields? If a customer is rapidly entering product numbers and the field tries to fill in the number automatically, there's a possibility of a mistake being made in ordering. I thought making the field secure would eliminate this auto entry by the browser?

The last post mentions time is not available for support of this mod, but maybe there's a place I can be directed that answers the question? Is there anyone that has already addressed this issue? I tried a "secure field" search in the forum but didn't have any luck. Or maybe this is not even possible?

Thank you in advance!

I can not find an answer to this post. I would also like to do the same and sort the products alphabetically in the Quick Order module. Is there a way?

fubr69z

I am creating an order form for Firehouse Subs Restaurants to order all of their hot sauces on our approved list. however, I have already used this module to create an quick order form for all of our customers to use. I modified the filenames, extra datafiles, language files, template files, and header.php from "quick_order" to "fhs_quick_order" and QUICK_ORDER to "FHS_QUICK_ORDER" in their respecive places and the module will work and add items to the cart. however I am receiving some errors at the bottom of the page that I cannot figure out.

Warning: main(includes/templates/classic/fhs_quick_order//google_analytics.php) [function.main]: failed to open stream: No such file or directory in /home/hotshots/public_html/includes/templates/classic/common/tpl_main_page.php on line 180

Warning: main(includes/templates/classic/fhs_quick_order//google_analytics.php) [function.main]: failed to open stream: No such file or directory in /home/hotshots/public_html/includes/templates/classic/common/tpl_main_page.php on line 180

Fatal error: main() [function.require]: Failed opening required 'includes/templates/classic/fhs_quick_order//google_analytics.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/hotshots/public_html/includes/templates/classic/common/tpl_main_page.php on line 180

My first instinct was to check my install of google analytics, but everthing seems fine there and I am not getting any other errors on any other pages. Can someone please help me? The forms work, but I am slightly embarased by the errors on the bottom of the page. You can see them here:
http://hotshotshotsauce.com/index.ph...hs_quick_order

Thank you, Thank you, I will definitly support this module!! Its a lifesaver for me.. I was hoping you could also consider the following, have Quick order as an option on the account menu only after the user logs in. In addition would it be possible to also add prices to the columns in the form.
currently I made the modifications to put Quick Order as a static page in the header from previous posts, but I really would like it to appear under accounts but only after login.

I would like to add a second Quick Order form to my site. I see just above that someone else tried this for Firehouse Subs Restaurants, but had problems. Perhaps they can report back if they solved the problems? And if they could share what they modified to make a second form work, that would be greatly appreciated.

Thanks,

Rob

Quote:

---

Originally Posted by rstevenson

I would like to add a second Quick Order form to my site. I see just above that someone else tried this for Firehouse Subs Restaurants, but had problems. Perhaps they can report back if they solved the problems? And if they could share what they modified to make a second form work, that would be greatly appreciated.

Thanks,

Rob

---

Rob,

I have had a some difficulty in my many attempts to configure a second form. Here is what I did:

I started by modifying filenames from qo_ to fhs_qo_. Then I modified each of the files to reference the new filenames in the appropriate places and the form worked.

Later, I heard from one of our customers that the form was cutting off the orders (Uh, oh!) and quickly realized that there was a problem with the error messages. If a customer inputs an incorrect item code the form gives a list of 20 or more products that are not in any way related. I also found that the form will not add products from my preselected list if the user skips products and selects only the ones he wants. The funny thing is that these problems do not occur when using firefox, only using IE.

So I am close, but I have not fixed the problem completely. If you would like to see the live version, go to hotshotshotsauce.com and register for an account with Zen-Cart support as the company name and I will approve you. Corporate wants this fixed yesterday and is putting pressure on me to fix it or take the form down, so you may only have a short amount of time before I have to remove it. I hope we can solve this before then.


Matt

Thanks for the update Matt. I'll watch this space in hopes you succeed. It seems that it's way over my coding abilities. :(

Rob

ugh i dunno if anyone else is having this problem but for some reason the buy now button isn't working (or when i press enter) .. this only happens on IE .. firefox is fine.. i have no idea why.

any help would be appreciated, thanks.

What version of Zen Cart?
What version of IE? (and Windows?)
Site link?

I just checked my own site and QO seems to be working just fine in IE 7 under Win XP.

Rob

just reinstalled and it works now .. shoulda done that first

i'm having problems with this mod while using apple_zen template, basically the right hand links, shopping cart etc are showing at the bottom of the page rather than on the right hand side, i guess this is a tpl problem, would anyone know how to fix it?

Thanks
Rob

Has anyone been able to use this with attributes support?

I have quick order working with a link. Every thing loads in the cart and life is good. UNTIL, I click that link a second time. Then the cart empties out and will not refill until I restart the browser. Is there something I am missing?

This is a great mod for zencart.
I would like to see a sidebox like the one showed here however i dont know very much php to rewrite the mod as a sidebox.
This is the box i have seen that i would like to make.

http://thelayout94.siteforshop.com/

Thanks for all your help.

Where can I get the newest Version 2 of Quick Order.

Thanks,
martin

Quote:

---

Originally Posted by Martin Smith

Where can I get the newest Version 2 of Quick Order.

---

Why do you think there's a version 2? Have you seen it mentioned somewhere?

Rob

Does anyone have this running on version 1.3.8a. I installed everything as per the folder structure and all I'm getting is

Order Online
Name/Model Quantity

fields to show up. There is no form to fill in. I tried it both ways; logged in as a customer and not

Quote:

---

Originally Posted by nowie

Thank you for this wonderful mod. This is virtually what I was looking to do.

Question: I would like for customers to be able to type in either model numbers OR product names in the input fields. In this particular case, all model numbers and product names will be unique. I've tried modifying the header_php.php file at line 123 without success as I have limited php/sql experience. Could someone possibly offer some suggestions in achieving this?

Here is line 123 of header_php.php:

PHP Code:

---

$next_product_id = mysql_query(sprintf('select p.products_id, p.products_model from %s AS p where (p.products_model = \'' . implode("' OR p.products_model = '", $qo_item_info['model']) . "')", $db->prepare_input(TABLE_PRODUCTS)), $db->link); 


---

---

Hi, i use: zencart 1.38a, QO 1.2.3, QO settings:
define('QO_INPUT_ROWS', 1);
define('QO_MODELS_MUST_BE_CASE_SENSITIVE', false);
define('QO_SIMILAR_MATCHES_LIMIT', 1);
define('QO_SIMILAR_MATCHES_ORDER_BY', true);

I also wanted to the input to be by another field (barcode)
i managed to do this by the folowing:
/includes/modules/pages/quick_order/header.php line 123
my code added is in red

Code:

---

// if at least one model was entered
                        if ($total_models > 0) {
                                $barcode = "select products_model from products where products_barcode = '".$qo_item_info['model'][0]."'";
                                $barcode_values = $db->Execute($barcode);
                                $qo_item_info['model'][0] = $barcode_values->fields['products_model'];
                                // get the selected products
                                $next_product_id = mysql_query(sprintf('select p.products_id, p.products_model from %s AS p where (p.products_model = \'' . implode("' OR p.products_model = '", $qo_item_info['model']) . "')", $db->prepare_input(TABLE_PRODUCTS)), $db->link);
                                while ($row = mysql_fetch_array($next_product_id)) {
                                        $next_product_id_array[$row['products_model']] = $row['products_id'];
                                        $next_product_id_array_i[strtolower($row['products_model'])] = $row['products_id'];
                                }

---

what i did:
my input field from the form is the actual barcode off my product(you have to have defined the barcodes previosly to use this), as QO searcehes for the product model, with my code in red i change the barcode to the model off the product.

Best regards Zoli.

any updates on quick order for the newest zen cart?

Just an update to this old thread as it may help someone.

I've just installed Quick Order V1.2.3 on Zen V1.3.9h without any problems.

Hi,

I would like to implement "Quick order" into a sidebox to have it on each page in the left side. I put the php code into a new sidebox but it works only on quick_order page.
For the other pages, it shows only: TEXT_QO_NAME_MODEL TEXT_QO_QTY.
Can anyone tell me what to do to make it work?

Hi i have downloaded quick_order_1-2-3. i want to use this into my zencart based portal. could you please tell me step by step process how to install it in my zencart. thank u.

any news on whether this works w/ ZC 1.5?

What is a valid Model Number?

This is giving me an error?

http://web-mobile-cart.com/dir/index...arkets&qty_1=1

ERROR_NOT_VALID_MODEL_NUMBER
TEXT_QO_MODEL

it is accepting the product name and order qty

1 (this is not valid ?) Recycled Water Markets 1

@westdh
It appears you've improperly loaded the mod. But, we could help better if you answered the posting tips.

I am trying to install Quick Order Version 1.2.3, i am running zen-cart v1.5. also I see I am picking up the Product name and Qty. Why, I am not picking up the Model Number I do not know. It is 2/3 working so maybe I missed something on setting it up, bur where?

I have found one install problem. Now I am getting this:

my url is: http://web-mobile-cart.com/dir/index...arkets&qty_1=1

--------Response is:
Order Online
Name/Model Quantity
Invalid item number: Recycled Water Markets

Model: Recycled Water Markets 1

and a chain of order boxes?

I have also installed it in: my_template_default.
And I re-checked it for any install errors
http://web-mobile-cart.com/dir/index...arkets&qty_1=1

..now the error is:

Order Online
Name/Model Quantity
Invalid item number: Recycled Water Markets
-------------------------------------------------------------------------
Model: Recycled Water Markets 1
Model:
Model:
Model:
Model:
Model:
Model:
Model:
Model:
Model:
Model:
Model:
Model:
Model:
Model:

I have this installed and working fine, except for the fact that I really need attribute support for it.....
Anyone have that figured out?
Thx

I have this installed and it looks great. One problem: We have SSL turned on and I'm getting that security error

"Although this page is encrypted, the information you have entered is to be sent over an unencrypted connection and could easily be read by a third party."

Is there a fix for this?

hi, ive been using this plugin since time began lol just upgraded my template to a responsive one (m_o_z_e_n_temp) using 1.5.0 and the page loads ok but my template is being ignored. i thought it was the new ajax version so tried the old version still same problem, any ideas why it would ignore my template just because its responsive, if i put my old template on it works fine!

link: http://www.hilevel1.co.uk/hilevel/in...ge=quick_order

any help appreciated

Dessy

DOH! sorry my bad folder in wrong place, thats what happens when doing websites at stupid o'clock :blush: the old rule never take anything for granted lol

When using the pre-filled model numbers display, can the sort order be changed to either zen cart sort order or alphabetically? Or better yet, can it just use the order that the model numbers are entered in qo_settings.php.

Example:

$qo_model_array = array(
'00541-BNDL-Q',
'00602-BNDL-Q',
'00596-BNDL-Q',
'00527-BNDL-Q',
'00558-BNDL-Q',
'00534-BNDL-Q',
'00589-BNDL-Q');

Assuming you're using the latest version of the quick orders module, you can make a couple edits to manage sorting:

Edit the /includes/classes/ajax/zcAjaxQuickOrder.php file ... around line 39 you'll see a section like the following. Add the lines in red, as shown:

Code:

---

      while (!$result->EOF) {        $product_list_array[$result->fields['products_model']] = $result->fields['products_name'];
        $result->MoveNext();
      }


      // sort specifically by the order listed in the $qo_model_array() in the config file:
      $temp_array = $product_list_array;
      $product_list_array = array();
      foreach($qo_model_array as $key) {
        $product_list_array[$key] = $temp_array[$key];
      }
      unset($temp_array);


      // Uncomment the next line to sort by products_model
      // ksort($product_list_array);


      // Uncomment the next line to sort by products_name
      // asort($product_list_array);




      // finally, build list of models for menu use
      if (is_array($product_list_array)) {
        $product_list_models = array_keys($product_list_array);
      }
    }

---

EDIT:
I've added a variation of this code to the downloadable plugin, so that all sorting can be controlled by a new setting $qo_model_sortorder in the qo_settings.php file.

I've added a variation of the above sorting code to the latest update of the plugin, so that all sorting can be controlled by a new setting $qo_model_sortorder in the qo_settings.php file.

Quote:

---

Originally Posted by DrByte

I've added a variation of the above sorting code to the latest update of the plugin, so that all sorting can be controlled by a new setting $qo_model_sortorder in the qo_settings.php file.

---

Hi - great plugin - btw is there a way to make it default to the qty of 1 after typing in the model number, etc.? I am trying to use a barcode reader and the model is the same number as the upc for now and it will read the model number, but then stops and gives an error as opposed to going on to the next line.? Any help is appreciated. Thanks

Can we talk about attributes please?

Would this plugin do this >> http://zucando.com/demo/index.php?ma...id=quick_order

Quote:

---

Originally Posted by oavs

Can we talk about attributes please?

Would this plugin do this >> (link to zuc ando)

---

No. This plugin doesn't have anything to do with the regular product-listing pages as your example showed, let alone injecting attribute-selection into those listings.
As described, this plugin lets people "quick order" products by entering identifying information about the product in a grid so they can order 100 items on one page by manually typing in product models etc.

Tested this module out on a clean install of 1.5.4 as that is what it's listed as supporting, but as soon as I enter a model number I get a popup that says
"An unknown response null: :text/html; charset=UTF-8: :Internal Server Error was received while processing an ajax call. The action you requested could not be completed."

No other mods installed. Server is set to PHP 5.6. Database was set to utf-8 at install. Checked all files correctly uploaded. Classic template used for testing.

Any suggestions?

Quote:

---

Originally Posted by strelitzia

Tested this module out on a clean install of 1.5.4 as that is what it's listed as supporting, but as soon as I enter a model number I get a popup that says
"An unknown response null: :text/html; charset=UTF-8: :Internal Server Error was received while processing an ajax call. The action you requested could not be completed."

No other mods installed. Server is set to PHP 5.6. Database was set to utf-8 at install. Checked all files correctly uploaded. Classic template used for testing.

Any suggestions?

---

the jscript_framework.php script in your template needs replacing. see:

https://www.zen-cart.com/showthread....t-was-received

play around with that file, as that is where your problem lies....