Quick Updates

Of course, you are correct. I have gone through the loading of this module twice and cannot get a single product to appear.

Had no problem either time loading files or sql

system shows cat photo but no products:unsure:

Hi Everyone

After reading the forum on Quick Update, I installed on the local cart v1.3.01. Everything seemed to be fine. After trying a few items, then I found all the product description were trimed off when the first line ended with </ul> or a break. Can't understand why. A sample of the description as below for ref.

Before install Quick update
" <ul><b><font color=blue>Free batteries and soft pouch.</font></b></ul>
Precision machined from Aluminium alloy and anodised, this torch gives a robust and long lasting shiny finish. The press button on the body provides a firm control.<br /> "

After quick update

Wonder if anyone had similar problem and any if any idea to help?
It will make the mod perfect.

Cheers

How can I add an additional small row to mass update "featured products" as radio button to select YES/NO ? (like active YES/NO status)

Adding one by one takes to much time..

Dimi

Hallo,

i was just testing the quick updates and discovered some serious problems.

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 ",").

As you can see, that seems to be a quick method to screw up your whole database with one click:cry:

After a first quick look at the code i noticed some more issues like the numbers are not quoted in sql-statements and the contrib doesn't use the zen db-layer (i don't know why).

Well, great idea for a contrib but still too dangerous for (productive) use.

The above affects "Quick Updates v1.3"

ciao

Has anyone gotten this to work without experiencing the issues described in the above posts? I also experiences issues with descriptions been cut off.

Hi again:
Could it be that the file within the zipped mod includes/extra_datafiles/qucik_updates_filenames.php should be
quick_updates_filenames.php?

And a question I did above:
How can I add an additional small row to mass update "featured products" as radio button to select YES/NO ? (like active YES/NO status)

I would appriciate your help

Dimi

pivey:

Hi again:
Could it be that the file within the zipped mod includes/extra_datafiles/qucik_updates_filenames.php should be
quick_updates_filenames.php?

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

Well I fixed the name of that file under admin-includes-extra_datafiles.

Still though cannot get the SQL patch to go through successfully either with the tool or by C&Ping it. This is the second cart I've had that problem with. The first cart, Portali helped me install it, but I have no idea what he did. I thought maybe with a clean install of the newest zencart I could get it to go but nope :no:

Hi,

Ivan02:

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

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! :smile:

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.

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

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 require('includes/application_top.php');):

$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

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? :smartass:

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.

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.

ladysaat:

hmmm... which zip file do you have and where'd you get it?? My zip file's name is Quick_Updates_1.3 and I think I got it at ZenPortali. Maybe we have the wrong files?

Where is this download Quick_Updates_1.3? I can only find 1.1.

Thanks!

I actually went to https://www.zenportali.com and found the quick updates stuff there.

ETA: I'm totally embarrassed to post that I did NOT give adequate mention/credit for the support I got from Shane to install and get them working. I spaced it, Shane! I'm sorry! He really really helped me out!!!

ladysaat:

I actually went to https://www.zenportali.com and found the quick updates stuff there.

ETA: I'm totally embarrassed to post that I did NOT give adequate mention/credit for the support I got from Shane to install and get them working. I spaced it, Shane! I'm sorry! He really really helped me out!!!

Thanks... I had been trying to reach zenportali with no luck... of course now its working. :laugh:

jettrue:

Where is this download Quick_Updates_1.3? I can only find 1.1.

Thanks!

Here is the link to the Ouick Updates 1.3 http://www.zenportali.com/index.php?option=com_remository&itemid=0&func=select&id=1