Jump to content
spooks

CONTRIBUTION Product Quick Edit

Recommended Posts

Great contribution Sam. Mark suggested it as a way to help me on another post. I installed and love it. I was surprised that there is no delete function though. Funny, that was the reason for installing this. I wanted a way to quickly delete obsolete products.

 

No problem though. This mod has the delete image function as well as the quick search.

 

Oh! Before I post, could you explain the 'show all' button? When I click it, I get an error page:

 

Not Acceptable

An appropriate representation of the requested resource /******/product_quickedit.php could not be found on this server.

 

 

Tim

Share this post


Link to post
Share on other sites

 

Not Acceptable

An appropriate representation of the requested resource /******/product_quickedit.php could not be found on this server.

 

 

 

Sound like a corrupted file, try re-uploading, all the 'show all' does is put % into the search, which will match all products, ie put % in the box & click 'search' is same.


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Sound like a corrupted file, try re-uploading, all the 'show all' does is put % into the search, which will match all products, ie put % in the box & click 'search' is same.

Thanks for the reply.

 

I tried uploading again. I even downloaded the latest version again and tried those files. Same result. (I wondered about that % sign. it does the same as show all) All other features work great.

Will it make a difference if I am on a subdomain? I am playing with a new installation on a sub. Once I have what I want, I will move it to a regular domain.

 

Tim

Share this post


Link to post
Share on other sites

Is there a way to include the AJAX Attribute Manager when you edit (product_quickedit_info) in QuickEdit - I have tried to do the same install as you do in Product_Info but nothing happened...

Share this post


Link to post
Share on other sites

In my case, the product quantity field can´t be modified. It shows the quantities, but there isn´t any box to change them.

 

Ref:

$product_query = tep_db_query("select p.products_id, p.products_model, pd.products_name, pd.products_description, " . ($short ? 'pd.short_desc, ' : '') . "p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_tax_class_id, p.products_weight" . ($flaged ? ', pd.discount_description, p.products_discount_point, p.products_discount, p.products_deposit' : '') . " from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . $pID . "' and p.products_id = pd.products_id");

 

...

 $sql_data_array = array('products_quantity' => tep_db_prepare_input($HTTP_POST_VARS['products_quantity']),
    											'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']),
                         'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']),

 

...

 

          <tr>
           <td class="main"><?php echo TEXT_PRODUCTS_QUANTITY; ?></td><td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . ($edit_quantity ? tep_draw_input_field('products_quantity', $pInfo->products_quantity, 'size="10"') : $pInfo->products_quantity .  tep_draw_hidden_field('products_quantity', $pInfo->products_quantity)); ?></td>
         </tr>
         <!-- <tr>
   <td class="main">Products Condition:</td>

Edited by bhbilbao

Share this post


Link to post
Share on other sites

Is there really only three files in this download?

I read the instructions but the admin page shows nothing that can be edited. It lists the products fine but you can't edit them. Is there a missing sql mod and stylesheet?


If the only tool you have is a hammer, all your problems look like nails

Share this post


Link to post
Share on other sites

Just wondering If somebody got this working with split_page_result when choosing "show all" This because I got a list with 6000 products and like them to split.

Share this post


Link to post
Share on other sites

for those who want to split also

 

if (!tep_db_num_rows($product_query))  {
 ?>
  <tr>
	    <td colspan="8" align="center" class="messageStackWarning"><big><?php  echo TEXT_NO_MATCH; ?></big></td>
	   </tr>
				    <?php	 } elseif (isset($_GET['pSearch'])) {
$products_query_raw = "select distinct pd.products_name, p.products_id, p.products_status, p.products_quantity, p.products_price, p.products_model, p.products_model_2, p.products_image, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and (pd.products_name like '%".$prod_search."%'  or p.products_id like '%".$prod_search."%' " ." ) order by pd.products_name ASC";
$products_split = new splitPageResults_list($_REQUEST['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows);
   $product_query = tep_db_query($products_query_raw);	
 while ($product = tep_db_fetch_array($product_query)) {
  $products_count++;
  $rows++;
   echo '<tr valign="top"' . ($pID == $product['products_id'] ? 'bgcolor="#9999ff"' : (((int)($i/2)*2) == $i ? 'bgcolor="#ffffff"' : '')) . '>';
   ?>
   <td  align="center" class="main"><?php echo $product['products_model'];?></td>
   <td  align="center"><?php echo tep_image(DIR_EXT_HTTP . $product['products_image'], $product['products_name'], 40, 40); ?></td>
   <td  align="center" class="main"><?php echo $products_name=$product['products_name']; ?>
   <td  align="center" class="main"><?php echo $product['products_model_2']; ?>
   <td align="center" class="main"><?php echo $currencies->display_price($product['products_price'], tep_get_tax_rate($product['products_tax_class_id'])) ; ?></td>
   <td align="center" class="main"><?php echo $product['products_weight'];?></td>
   <td align="center" class="main"><?php echo $product['products_quantity']; ?></td>
   <td align="right" class="main"><a href="<?php echo tep_href_link(FILENAME_PRODUCT_QUICKEDIT_INFO, 'action=edit&pID='. $product['products_id'] . '&prod_search=' . $prod_search) ?>"><b><?php echo TEXT_EDIT; ?></b></a></td>
   </tr>
  <?php
   }
  ?>
   </table>
   </form>
		  <tr>
		    <td colspan="8"><table border="0" width="100%" cellspacing="0" cellpadding="2">
		    <tr>
		 <td class="smallText" valign="top"><?php echo $products_split->display_count_list($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS , $_REQUEST['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
 <td class="smallText" align="right"><?php echo $products_split->display_links_list($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS , TEXT_RESULT_PAGE, $_REQUEST['page'],'option=com_oscommerce&osMod=product_list', 'pSearch=' .$prod_search .'&page'.$page); ?></td>
		   </table></td>
		  </tr>
		  <tr>
		    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
		  </tr>
  <?php
   }
  ?>
	  </table></td>
	  </table>
    </td>
 </table>
 </td>
  </tr>
   </table></td>
<!-- body_text_eof //-->
 </tr>
</table>

Share this post


Link to post
Share on other sites

hi, is there a way to edit the prices on the same page (displayed as text field) then save the changes for once ?

because i have thousands of products and its taking so long to edit 1 by 1.

 

thx for sharing this contribution, it saved me some time.

Share this post


Link to post
Share on other sites

It could be modified for that, you would need to use arrays with $_POST in the same way that the multi buy now works on modified product listings.


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Hi,

We are using "product_quickedit" already a long time, but now we are using it with "Google Chrome".

When we want to edit a product, we click on the record, but "product_quickedit_info" is not activated.

When we are doing the same in IE 9 there is no problem and we can edit the product in "product_quickedit_info".

Who can help us with this problem?

Thanks

Share this post


Link to post
Share on other sites

@@dakota259

 

I`ll check that out & get back to you.


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

@@dakota259

 

I`ve now tested this and cannot reproduce. Could you say what does happen & have you tried clearing the browser cache?


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Thank you for the new version of this add on. Just one thing I would change though - when I installed it on my shop, it replaced the Categories/Products box, meaning I couldn't add new product to my shop. So instead of replacing the lines in admin/includes/boxes/catalog.php and admin/includes/languages/english.php, as suggested in the installation file, I added them and kept the old lines. This means that I have both boxes available. Hope this helps, and sorry if you already knew!!! :-)

Share this post


Link to post
Share on other sites

@@dsaltmer

 

Yeah I did the same thing as you, I kept the originals and just added the new code. The reason that the install file reads as that was it was how it was originally stated.

 

When you think about it though you really need to have both, otherwise how will you add or edit categories... I guess it needs to be updated.

 

http://addons.oscommerce.com/info/5680 There you go for version 2.3.2 as well!

Share this post


Link to post
Share on other sites

Thanks for this! It's going to be so helpful! I was wondering, I'm still using 2.2 and even though the pages say require('includes/application_top.php'); there is no application top, no left column with all the links I need, etc. I can only use my back-button to get back to wherever I need to be. Any suggestions?

Share this post


Link to post
Share on other sites

Hi !

Into catalog/admin/includes/filesnames.php must be added

 define('FILENAME_QUICK_EDIT_INFO', 'product_quickedit_info.php');

(new version 2.3.1)

No ?

Cheers !

bebe cash 59

Thanks to apologize my language

----------------------------------

Français

Un bout de code manque dans la version pour 2.3.1 (& 2.3.2)

Merci de corriger le zip - pour les autres...

Belle journée à vous

bebe cash 59

Share this post


Link to post
Share on other sites

@@bebe cash 59

 

I believe that was left out of the installation instructions as the only link to that page is from the product_quickedit.php page. The info page is not called from any other file so it doesnt need to be defined.

Share this post


Link to post
Share on other sites

Hi ,

 

First a big thanks for this addon , once it works it will save us a lot of time!

 

For now i get the following message:

Not Acceptable

 

An appropriate representation of the requested resource /xxxxxxxxx/product_quickedit.php could not be found on this server.

 

 

This happens with whatever i click on , i already tried to upload " product_quickedit.php" again but that did not help.

I also checked if the files were in admin.

 

Can someone help me with this?

 

Many thanks in advance,

 

Rob

Edited by CrazyCarzCustoms

Share this post


Link to post
Share on other sites

The installation of this addon doesn't modify any files as in changing any code. All you are doing when you install it is adding the link to it, and the language definitions so the links show correctly. I would look at what you have been doing to your shop lately and confirm nothing else is showing this error.

Share this post


Link to post
Share on other sites

The installation of this addon doesn't modify any files as in changing any code. All you are doing when you install it is adding the link to it, and the language definitions so the links show correctly. I would look at what you have been doing to your shop lately and confirm nothing else is showing this error.

 

 

Hi Clint,

 

Thank you for your response.

I did some to the shop AND updated it to 2.3.3 but about everything else is working , exept a link for Google login , but i´m fighting with that for a couple of days now.

 

Could this be caused bu a ht.acces , i realy have no idea as i am a total noob to this but i know that i have a extensive ht.acces file.

But like i said , everything else seems to be working , you can have a look if you want here.

 

Gr. Rob

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×