Quick Updates

[kelvyn]

whoa. I don't even have that folder in the zipped mod. Under New Install I have admin and that's it. No Includes folder outside of admin. I just download the mod from zenportali. Do I have the wrong stuff again???

This is another reason to have mods built to a standard which at least has a "latest version" check! When mods have so many homes, it's VERY difficult to keep up with the changes.

Anyway, is anyone thinking of making a new version of this, or perhaps a "super admin"? Where mass moves and edits are possible?


VVVV note: sig is out of date but cannot be edited

[Ivan02]

Hi,

...
quick updates might use wrong number format when writing to the database. This occurs when you use a different/additional(?) currency-format.

i better give an example:
If you have a price of "1.20" and you want to add +1 you might get something like "2,20" (note: "." changed to ",").
...

The above issue was caused by a setlocal statement of php.

If someone has the same problem as described above, please check the setlocal statements, especially LC_NUMERIC. As far as i can tell change of decimal separator was caused by this.

For me quick-updates works now

[Uncle Bob]

If anyone is wondering how to get the Quick Updates contribution to work with Register Globals turned off, this seems to be a simple way to do it.

Go to the quick_updates.php file in the admin directory and find the line near the top of the file that says require('includes/application_top.php');

Right under it, add this code:

$sort_by = $_GET['sort_by'];
$row_by_page = $_GET['row_by_page'];
$manufacturer = $_GET['manufacturer'];
$page = $_GET['page'];
$current_category_id = $_GET['cPath'];
$languages_id = $_SESSION['languages_id'];
$spec_price = $_POST['spec_price'];

So far it seems to be working great for me!

[businesstoweb]

Thanks uncle Bob, that update worked.

Is there anyway to also pull the products weight info? would that be

$products_weight = $_GET['products_weight'];

that doesn't seem to pull the info...


Also is there anyway we can add a search box to the quick updates. If one has 20,000 products, then it can be tedious going through the entire list, when a search by name or ID is all that is needed.

Ta.

[Uncle Bob]

The Quick Updates contribution has already been configured to pull the products' weight info. In the admin, just go to Configuration > Quick Updates and make sure the setting for "Modify the weight of the products" is set to "True". Under Catalog > Quick Updates you should then see a field for editing the weight of a product right after the field for editing the price of a product .

A search box would be nice. What I normally use is the "Select category" drop-down at the top of Quick Updates. That narrows down the list so that only the products in the selected category are shown. Hopefully that should make things at least a little more manageable for you.

Cheerio!

Uncle Bob

[Uncle Bob]

While we're talking about Quick Updates here, I thought I might share how I fixed up the Quick Updates preview product and edit product link icons to work with the latest version of Zen Cart (they seem to be disabled by default in Quick Updates 1.3).

First, make sure that "Display the link towards the products information page" and "Display the link towards the page where you will be able to edit the product" are set to True under Configuration > Quick Updates

Then, in quick_updates.php, change your SQL query by going to the line that says "//// select categories" and replacing the code under it with this:

  if ($current_category_id == 0){
          if($manufacturer){
            $products_query_raw = "select p.products_id, p.products_type, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, pc.categories_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and p.manufacturers_id = " . $manufacturer . " $sort_by ";
          }else{
                $products_query_raw = "select p.products_id, p.products_type, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, pc.categories_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id $sort_by ";
        }
  } else {
         if($manufacturer){
                 $products_query_raw = "select p.products_id, p.products_type, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, pc.categories_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by ";
          }else{
                $products_query_raw = "select p.products_id, p.products_type, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, pc.categories_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by ";
        }
  } 

Finally, still in quick_updates.php, find the section of the document that starts with "//// links to preview or full edit" and replace the following two lines with this code:

if(QUICKUPDATES_DISPLAY_PREVIEW == 'true')echo "<td class=\"smallText\" align=\"left\"><a href=\"".zen_href_link (FILENAME_PRODUCT, 'cPath='.$products['categories_id'].'&pID='.$products['products_id'].'&product_type='.$products['products_type'].'&action=new_product_preview&read=only&sort_by='.$sort_by.'&page='.$split_page.'&origin='.$origin)."\">". zen_image(DIR_WS_IMAGES . 'icon_info.gif', TEXT_IMAGE_PREVIEW) ."</a></td>\n";
if(QUICKUPDATES_DISPLAY_EDIT == 'true')echo "<td class=\"smallText\" align=\"left\"><a href=\"".zen_href_link (FILENAME_PRODUCT, 'cPath='.$products['categories_id'].'&pID='.$products['products_id'].'&product_type='.$products['products_type'].'&action=new_product')."\">". zen_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', TEXT_IMAGE_SWITCH_EDIT) ."</a></td>\n"; 

If you are using Quick Updates with Register Globals turned off (see my earlier post), you'll also want to add this line of code near the top of the document (right under [FONT="Courier New"]require('includes/application_top.php');[/FONT]):

$sort_by = $_GET['sort_by']; 

That's it! They seem to be working great now for me. Hope it's helpful to someone.

Uncle Bob

[businesstoweb]

Hi uncle bob, thanks for your info it has been very helpful.

However we really do need that search box. Take this example.

You have a batch of invoices come in -> 20 products to be updated. You have assigned your own product code to the products, so what do you do on the current system.

1) Find the manufacturer... Hmm, 300 of those, might take a while, rather large and cumbersome drop down! Then find the product, 500 of those... again, another slow process.

or

2) Type in the product code in the search -> Hey presto, your there.

Is there anyway that we can pull the code from the search box on the front page, and simply change the form variables?

[kelvyn]

Yeah, I could really do with this also, and for the cross-sell module. Paging through 5,600 products ain't fun!

I think Zen Cart was build from a "few products" point of view, and we're trying to push it too far with all this hi-tech stuff!

[Uncle Bob]

You're right about how useful something like that would be. Unfortunately, I don't think the front page search box is really going to be that helpful in setting up something like this. You could always try though.

By the way, what were you referring to by "product code"? Were you talking about the product's ID number? It's model number? I was just wondering which value would need to be pulled from the database.

Perhaps one day a client of mine will need that functionality and I'll be able to take the time to program it in. If so, I'll be sure to post the code for you.

[businesstoweb]

Hi,

I renamed all the lang files for "model" to "product code", because model is really an unnecessary field...

So I would need to pull that from the db.