Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

CONTRIBUTION Product Quick Edit


spooks

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

Link to comment
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.

Link to comment
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

Link to comment
Share on other sites

  • 2 months later...

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

Link to comment
Share on other sites

  • 5 months later...

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
Link to comment
Share on other sites

  • 2 months later...

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?

Link to comment
Share on other sites

  • 5 months later...
  • 1 month later...

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>

Link to comment
Share on other sites

  • 3 months later...

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.

Link to comment
Share on other sites

  • 4 weeks later...

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.

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
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.

Link to comment
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.

Link to comment
Share on other sites

  • 3 months later...

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

Link to comment
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!

Link to comment
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?

Link to comment
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

Version OSCOM CE Phoenix v1.0.5.9 + french language (v1.0.5.8 & Merge pull request #955 from gburton/1.0.5.9

php 7.1.3 MySQL 5.7.17  local with easyphp 

adds on: shipping spu 

common browser: Chrome

Shop multishop 2.2 with many addons.

Link to comment
Share on other sites

  • 3 weeks later...

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
Link to comment
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.

Link to comment
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...