mattice Posted December 6, 2002 Share Posted December 6, 2002 Quick Stock Update v1.0 [2.2-CVS - ALL CHECKOUTS] This stand-alone tool will allow you to update the stock on an entire category at once (on a per product basis). An optional checkbox will set the products status based on the stock quantity for that product. (so it is compatible for those of you that use the status_id field for other purposes) Category browsing is done through dropdown boxes for each root category. (If there are products in the root category it will include a dropdown with all the categories.) Just one file to upload, no changes needed to osCommerce files. Optional parameter to set the max products per row. screenshot: Download: http://www.oscommerce.com/downloads.php/co...ons,768/type,3/ Mattice Quote "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
Vin? Posted December 12, 2002 Share Posted December 12, 2002 Hi Mattice, First of all, this contribution is great! Easy to implement, immediatly works. Second, i did a little rebuilding to make your contribution fit in column_left.php. Added the header.php, and footer.php to make it a little more of osC-style. Third, i translated the file for our administration, but what needs to be implemented for a future release is the link with a additional php in de languages directories. If you're ok with it, i can implement these (small) features and pass the update to you, or directly to osC. Let me know what you think. Quote 'Time is a social construction to make the transitoriness manageable' Link to comment Share on other sites More sharing options...
Vin? Posted December 12, 2002 Share Posted December 12, 2002 I called the link in column_left 'voorraadbeheer'... Quote 'Time is a social construction to make the transitoriness manageable' Link to comment Share on other sites More sharing options...
mattice Posted December 12, 2002 Author Share Posted December 12, 2002 Just to let everybody know: Vin? and I have contacted eachother ('gezellig' as we Dutch say :)) and a new version will be released shortly, offering the Admin-integrated AND stand-alone files in a single package. Both versions will feature further improvements. Regards, Mattice Quote "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
arbocenc Posted December 18, 2002 Share Posted December 18, 2002 Hello, Do you know if it's easy to adapt your contribution/idea for updating prices instead stock? Or maybe two or three fields (for exaple, stock, prices and description...) See you later! Joan Quote joan@delaterra.net www.delaterra.net organic food in Catalonia Link to comment Share on other sites More sharing options...
mattice Posted December 18, 2002 Author Share Posted December 18, 2002 Yes, that would be easy. Just add or fetch the price field, won't be a problem. I might actually add the price field to the new version... good idea that. Damn... I will need to rename it to quickstockandpriceupdate now... ;) You can basically add anything but the description needs a fairly big input field (multiple on multi language shops) so the advantage of this page layout will be pretty much useless then... HTH Mattice Quote "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
Vin? Posted December 18, 2002 Share Posted December 18, 2002 agreed... description is out of the question. Model-name, or tax-class perhaps...? But the price is indeed a good and simple add-on... And yes, why not call it 'quickupdate' :wink: Quote 'Time is a social construction to make the transitoriness manageable' Link to comment Share on other sites More sharing options...
arbocenc Posted December 18, 2002 Share Posted December 18, 2002 Yes, that would be easy. Just add or fetch the price field, won't be a problem. I might actually add the price field to the new version... good idea that. Damn... I will need to rename it to quickstockandpriceupdate now... ;) You can basically add anything but the description needs a fairly big input field (multiple on multi language shops) so the advantage of this page layout will be pretty much useless then... HTH Mattice Could you alert us when the quickstockandprice update will be on line? Thanks a lot, Joan Quote joan@delaterra.net www.delaterra.net organic food in Catalonia Link to comment Share on other sites More sharing options...
mattice Posted December 18, 2002 Author Share Posted December 18, 2002 no prob. just click watch this thread (at the bottom of this page) and you'll be notified. (I'll post the new release on this thread) Quote "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
elari Posted December 20, 2002 Share Posted December 20, 2002 hello mattice as you can see some top categorie are reported in all cat but does not have their own menu.... can you please add a parameter in quick_xxxx to use the cPath parameter in the call link ? For Joan here is an old answer of mattice :) Hi Elari, Thanks. I did not need that for myself but it is not hard: change $sql2 = tep_db_query("SELECT p.products_id, p. products_quantity, p.products_status, p.products_image, pd.products_name from products p, products_to_categories ptc, products_description pd where p.products_id = ptc.products_id and p.products_id = pd.products_id and language_id = $languages_id and ptc.categories_id = '" . $HTTP_POST_VARS['cat_id'] . "'"); to $sql2 = tep_db_query("SELECT p.products_id, p. products_quantity, p.products_status, p.products_image, p.products_model, p.products_price, pd.products_name from products p, products_to_categories ptc, products_description pd where p.products_id = ptc.products_id and p.products_id = pd.products_id and language_id = $languages_id and ptc.categories_id = '" . $HTTP_POST_VARS['cat_id'] . "'"); Then change echo '<input type="text" size="3" name="stock_update[' . $results['products_id'] . ']" value="' . $results['products_quantity'] . '">stock<br><i>'; to echo '<input type="text" size="3" name="stock_update[' . $results['products_id'] . ']" value="' . $results['products_quantity'] . '">stock<br>' . $results['products_model'] . '<br>' . $results['products_price'] .'<br><i>'; (untested so try it) Hope that helps, Regards, Mattice Quote Link to comment Share on other sites More sharing options...
elari Posted December 20, 2002 Share Posted December 20, 2002 found a solution, not very nice but will work add if ($HTTP_GET_VARS['cat_id']) { $HTTP_POST_VARS['cat_id'] = $HTTP_GET_VARS['cat_id']; } after // see if there is a category ID: this way you can call with a parameter like quicstock.php?cat_id=xx where cat_id = your cID This way you can add a button on right side of catalog when browsing category to call directly quicstockupdate for this category in a separate window.... Quote Link to comment Share on other sites More sharing options...
Guest Posted December 20, 2002 Share Posted December 20, 2002 The tool works great, but if i want to place a product in a sub-category, like in |Xbox|Action|"The game" ? Cant see the option to place it right in there. Is there maden yet? -Henrik Quote Link to comment Share on other sites More sharing options...
mattice Posted December 22, 2002 Author Share Posted December 22, 2002 The tool works great, but if i want to place a product in a sub-category, like in |Xbox|Action|"The game" ? Cant see the option to place it right in there. Is there maden yet? -Henrik It is only intended to do quick stock updates, not moving products around... ;) Elari, I like your idea to add a button to the categories.php like you described. I will add that trick to the docs once I release the new version :D Mattice Quote "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
elari Posted December 22, 2002 Share Posted December 22, 2002 thanks :) if you agree i will add the link in qty & status mod wich apply on the categories files did you see why it does not sort all top categories ?? Quote Link to comment Share on other sites More sharing options...
mattice Posted December 22, 2002 Author Share Posted December 22, 2002 did you see why it does not sort all top categories ?? I not sure if I understand what you mean exactly with that...? :? Mattice Quote "Politics is the art of preventing people from taking part in affairs which properly concern them" Link to comment Share on other sites More sharing options...
elari Posted December 22, 2002 Share Posted December 22, 2002 sorry i forgot the link :( as you can see the top category test does not have a pull down maybe is a mistake in ma database... Quote Link to comment Share on other sites More sharing options...
Guest Posted December 23, 2002 Share Posted December 23, 2002 price update would be great :D :lol: Quote Link to comment Share on other sites More sharing options...
Jaap Posted June 15, 2003 Share Posted June 15, 2003 About quick_stockupdate.php (v1.1) I tried to implement it, but when i first clicked it didn't show up a thing. only the title, and the bottom. so i looked in the file and i saw the following string. // first select all categories that have 0 as parent: $sql = tep_db_query("SELECT c.categories_id, cd.categories_name from categories c, categories_description cd WHERE c.parent_id = 0 AND c.categories_id = cd.categories_id AND cd.language_id ="1"); ---> notice the 1 (fixed) So i changed it to: (and it's working) // first select all categories that have 0 as parent: $sql = tep_db_query("SELECT c.categories_id, cd.categories_name from categories c, categories_description cd WHERE c.parent_id = 0 AND c.categories_id = cd.categories_id AND cd.language_id =" . $languages_id); (well, maybe it's useful) Quote Link to comment Share on other sites More sharing options...
Jaap Posted June 15, 2003 Share Posted June 15, 2003 Another thing,.. no images.... --- In the script look for: echo '<td align="center">' . tep_image(DIR_WS_CATALOG1 . DIR_WS_IMAGES . $results['products_image'], 'ID ' . $results['products_id'] . ': ' . $results['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br>'; ---> Change DIR_WS_CATALOG1 to DIR_WS_CATALOG (without the 1) Quote Link to comment Share on other sites More sharing options...
azer Posted June 15, 2003 Share Posted June 15, 2003 " Do you know if it's easy to adapt your contribution/idea for updating prices instead stock? Or maybe two or three fields (for exaple, stock, prices and description...) " A french contribution transalted by me iun english calle : "Qucik update" allow u to change all the prices and the stock for all your product and is able to do it by categories ... Quote MS2 Link to comment Share on other sites More sharing options...
cashman Posted July 15, 2003 Share Posted July 15, 2003 who can help me ? Quote hey ! i am new boy Link to comment Share on other sites More sharing options...
cashman Posted July 15, 2003 Share Posted July 15, 2003 who can help me ? work now! In the script look for: echo '<td align="center">' . tep_image(DIR_WS_CATALOG1 . DIR_WS_IMAGES . $results['products_image'], 'ID ' . $results['products_id'] . ': ' . $results['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br>'; ---> Change DIR_WS_CATALOG1 to DIR_WS_CATALOG (without the 1) Quote hey ! i am new boy Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.