Quick Price Updates - official support

[spyrotsk 0]

Hi All,

I need to change one features, I need to update the price of products with this module, alredy has implemented this function, but I need change include the special price, even if possibile with one variable (true or false, in the admin panel) for enable this feature.

 

I don't have great experience with php and mysql, for this I need your help!

 

Thanks for your time and have a nice day!

 

spyrotsk.

 

Please, i need help!

Does anyone know how to do?

 

Thanks!

SpyroTSK

[pleasureidea 0]

Looks like the error with

"select manufacturers_name from manufacturers where manufacturers_id="

happens when one or more products has no manufacturer assigned in DB. Is there anybody can help to make code corrections, so it will be also working without manufacturer assigned?

I have products with manufacturers and without. When the correct manufacturer chosen, everything works just fine. When "all manufacturers" chosen the "select manufacturers_name from manufacturers where manufacturers_id=" error happens.

Your help is appreciated.

 

Regards,

Oleg

[-Buggi- 0]

I would very much like to expanded the boxes for the product and model name so that you can see all the text if you - like I - have long model numbers.

 

Can anybody help me? :blush:

[dstebo 1]

I downloaded version (Quick Updates 2.8.3 Full-PT) when I change the price, the prices do not change this in the DB

What can be?

[partsace 1]

Here's a good one for you...

 

I have 2 sites using the Quick Price Updates and both are working just fine, but I do not have the "<< Page 1 of 27 >>" at the bottom of one of the sites. One has it and the other one doesn’t! What am I missing? I've made sure that the "Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)" is on. I've also been using this for years (Great add-on), just can't figure this one out. I've even put up the lastest version and still have the same problem.

 

Scott

[Psytanium 15]

alright, a BIG THX for this contribution, its saving me time. i have 2 questions:

 

1- how can i change the (Max. # of lines per page) by default ? its 20 lines, i want to make it 1000

2- the print button is printing the whole page, is there a way to make it print only the list of products ?

[Psytanium 15]

alright, a BIG THX for this contribution, its saving me time. i have 2 questions:

 

1- how can i change the (Max. # of lines per page) by default ? its 20 lines, i want to make it 1000

2- the print button is printing the whole page, is there a way to make it print only the list of products ?

 

i figured how to set the default number of lines per page. i change "MAX_DISPLAY_SEARCH_RESULTS" to 100 or any integer number.

 

but still can't solve my 2nd problem about printing.

[twindaddy 0]

i have the latest version i can see the prices, but i cannot change them.

Does anybody have a solluiton for this?

 

Thank you

Edited August 19, 2012 by twindaddy

[dculley 10]

my fist issue with the Quick Update. I had just sorted by manufacturer and then sorted by item #. All went well until I wanted to chance page to work on another set. I received the following:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by p.products_model ASC limit 21, 21' at line 1

 

select p.products_id, 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 from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = 11 order by order by p.products_model ASC limit 21, 21

 

I have no idea what the syntax problem is, I'm not a programmer.

 

Help Please

[burt 3,977]

You have two "order by"

 

p.manufacturers_id = 11 order by order by p.p...........

 

Somewhere buried in the code of the addon is problematic or you have introduced a problem.

[dculley 10]

I've done a file search in admin/quick_updates.php for the "two order by" could not bring it up. Search for p.manufactures_id to look for the = 11 and could not find it.

[♥geoffreywalton 139]

Try searching for "order".

 

HTH

 

G

[dculley 10]

searched "order" in admin/quick_update.php found 4 lines:

Line 19 - " order by tax_class_title"

Line 27 - " order by manufacturers_name"

Line 37 - " m order by m.manufacturers_name ASC"

Line 400 - $sort_by = 'order by '.$sort_by

[dculley 10]

line 25 - 47

////Info Row pour le champ fabriquant

$manufacturers_array = array(array('id' => '0', 'text' => NO_MANUFACTURER));

$manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");

while ($manufacturers = tep_db_fetch_array($manufacturers_query)) {

$manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'],

'text' => $manufacturers['manufacturers_name']);

}

 

// Display the list of the manufacturers

function manufacturers_list(){

global $manufacturer;

 

$manufacturers_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m order by m.manufacturers_name ASC");

$return_string = '<select name="manufacturer" onchange="this.form.submit();">';

$return_string .= '<option value="' . 0 . '">' . TEXT_ALL_MANUFACTURERS . '</option>';

while($manufacturers = tep_db_fetch_array($manufacturers_query)){

$return_string .= '<option value="' . $manufacturers['manufacturers_id'] . '"';

if($manufacturer && $manufacturers['manufacturers_id'] == $manufacturer) $return_string .= ' SELECTED';

$return_string .= '>' . $manufacturers['manufacturers_name'] . '</option>';

}

$return_string .= '</select>';

return $return_string;

}

[♥geoffreywalton 139]

Well it is not any of those.

 

Are you sure it is in that file

 

select p.products_id, 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 from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = 11 order by order by p.products_model ASC limit 21, 21

 

What is the url displayed when the error is displayed?

 

Try looking for

 

select p.products_id, p.products_image,

 

in that file.

 

HTH

 

G

[burt 3,977]

Line 400 - $sort_by = 'order by '.$sort_by

 

Here the code ask that $sort_by gets prefixed with `order by `

 

It is likely that in some (or all) circumstances $sort_by already contains an `order by` clause, so when this line of code prefixes it with another `order by`, well it's going to break.

Edited May 27, 2014 by burt

[dculley 10]

in admin/quick_updates found

//// select categories

if ($current_category_id == 0){

if($manufacturer){

$products_query_raw = "select p.products_id, 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 from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by ";

}else{

$products_query_raw = "select p.products_id, 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 from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '$languages_id' $sort_by ";

}

} else {

if($manufacturer){

$products_query_raw = "select p.products_id, 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 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{

 

if(tep_has_category_subcategories($current_category_id)){//if - check subcategory existence

$products_query_raw = "select p.products_id, 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 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 IN (select categories_id from categories where parent_id = '" . $current_category_id . "') $sort_by ";

}else{

$products_query_raw = "select p.products_id, 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 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 ";

}//if - check subcategory existence

}

}

 

also looked in quick_inventory.php for order, found 5

Line 90 “ p order by p.products_model”

Line 145 " m order by m.manufacturers_id"

Line 171 "%' order by p.products_model limit $limit_search_to"

Line 175 language_id = $languages_id order by p.products_model limit $limit_search_to"

Line 180 $languages_id order by p.products_model limit $limit_search_to"

[dculley 10]

how would you fix line 400

 

//// control string sort page

if ($sort_by && !preg_match('/^[a-z][ad]$/',$sort_by)) $sort_by = 'order by '.$sort_by ;

[dculley 10]

you asked

What is the url displayed when the error is displayed?

after sellecting the manufactor and sort the item # first page url:

/quick_updates.php?cPath=0&sort_by=p.products_model ASC&page=&row_by_page=21&manufacturer=11

 

next page (errors) url is:

quick_updates.php?&cPath=0&sort_by=order by p.products_model ASC&row_by_page=21&manufacturer=11&page=2

[dculley 10]

Still having the same problem is there a fix yet?

[alladin76ro 0]

Hi,

 

I upgraded to osCommerce Online Merchant v2.3.4 and my Quick Updates is not updating the Qty. of the products. Can anyone help?

 

Thank You.

[dculley 10]

I have updated a few months to osc234 w/ bootstrap.  I have installed the add on Quick updates and just trying to use it for the first item.  In calling up Quick Update,  I wanted to change the (add) to the descriptions on some items.  When I clicked on update I got the following error.

Warning: mysql_query(): Access denied for user 'ladyXXXXXXXXX'@'localhost' (using password: NO) in /home/ladyXXXXXX/public_html/admxxxxxx/quick_updates.php on line 80

Warning: mysql_query(): A link to the server could not be established in /home/ladyXXXXXX/public_html/adminlb/quick_updates.php on line 80

Warning: mysql_query(): Access denied for user 'ladyXXXXXXXXX'@'localhost' (using password: NO) in /home/ladyXXXXXX/public_html/admxxxxxx/quick_updates.php on line 81

Warning: mysql_query(): A link to the server could not be established in /home/ladyXXXXXX/public_html/admxxxxxx/quick_updates.php on line 81
Quick Update

How to correct?

[dculley 10]

I still haven't been able to fix this one.  All the other programs seems to be hitting the SQL data base just fine.  Is it a bootstrap thing?  Maybe this program is not ready for bootstrap? 

[dculley 10]

@@geoffreywalton

 

Geoffrey, just reach out.  Can you help me with the error I posted in #97?  I'm stilled stumped.

[♥kymation 630]

It appears that this program is not ready for osCommerce 2.3.4. The errors you posted above show that it is trying to use mysql_query() when it should be using mysqli_query(). Actually it should probably be using the osCommerce database functions which would have prevented this problem.

 

Regards

Jim