musicmaster Posted October 8, 2017 Share Posted October 8, 2017 (edited) Prestools is a suite of user-friendly and very powerful tools to mass edit your products, orders and categories. It is a kind of Swiss Army knife that runs outside your backoffice. You can download it here and find a manual here. Prestools was started in 2012 by putting together a small selection of tools for Prestashop. It has since grown steadily to become a comprehensive set of tools for maintaining Prestashop and Thirty Bees. It is one of the most popular downloads on the Prestashop forum. The main parts are: product-edit: great options for mass editing more than 50 product fields. Add categories, change prices, update descriptions - for hundreds of products at once. product csv: a very flexible tool to generate csv files. product-sort: an easy way to sort products inside a category. From position 500 to 1 in a blink. With the visual sort option you can see immediately how things will look. prodcombi: edit and oversee properties of combinations of a number of products at once. order-edit: adding and deleting products and changing prices without problems. order-search: make a selection on carrier, payment type, status, etc. or just search. With csv export option. category-edit: useful for editing metadata and descriptions for SEO combi-edit: assign pictures to your combinations quickly combi-copy and combi-delete: copy, modify and delete attribute combinations using one product as a template attribute-list and feature-list: see how many products use each feature and attribute and get a product list. regenerate images for selections of products cleanup images: save on disk space by cleaning up images of deleted products shop rescue: turn off overrides and non-Prestashop modules when due to some bug you can no longer login in the backoffce. override-list and module-list: get lists of modules and of overrides and the modules might own them. eu-tax: get a quick overview how much you sold in each of the EU countries and how much VAT you withheld in the process integrity checks: find and fix database and file corruption. lots of statistics Installation: Unzip the downloaded file and copy the resulting files to a subdirectory below your admin directory (do not install as a PS module!).You can access the program in the browser like "www.myshop.com/myadmin/mydir/login1.php". You will be welcomed by a login screen: the default username is "demo@demo.com" and the default password is "opensecret". Please adapt your security settings in the "settings1.php" file. There is a mini-module included for integration into the Thirty Bees backoffice. There is a demo-installation available. Username and password are the default. Below you find a view of the product-edit page where the description field has been made editable: /assets/uploads/files/34/1507463122156preview.jpg Prestools was originally written for Prestashop 1.5, 1.6 and 1.7. Some parts may still work only with Prestashop. If you find a problem please let me know. There are a few parts in product-edit that you need to buy at the Prestools website. However, over 95% of the script is free. Among the files you will find a file prestoolssuite-module.zip. You can install this file as a module. It is a mini-module as the only thing it does is adding a link to your Prestools installation in the Catalog menu in the backoffice. If you find a problem, please update Prestools to its latest version before you report it here. When reporting, please mention your Thirty Bees version. Follow the installation instructions! This is not a module! Edited June 8 by musicmaster 5 Link to comment Share on other sites More sharing options...
zimmer-media Posted December 8, 2017 Share Posted December 8, 2017 It's a very helpful tool, we love it because it makes our job a lot easier. How can I filter in the tool, for example, if I want to see entries without values? So that I can enter the missing information. As an example product available, it is not filled in all articles, because it was forgotten when importing CSV. Link to comment Share on other sites More sharing options...
musicmaster Posted December 9, 2017 Author Share Posted December 9, 2017 There are many different ways to get products with specific field values: - you can search for it - you can use the Sort By field. Even fields without a value will appear somewhere either at the top or the bottom. - you can also sort by clicking a column header - Just setting the field in the Search field is sometimes enough. If you search for example for discounts (without filling in a specific value) you will see all products with discounts. And by using the Not operator you can also see all the products that do not have a discount Link to comment Share on other sites More sharing options...
zimmer-media Posted December 9, 2017 Share Posted December 9, 2017 Many thanks for your response. Damn, of course, I completely forgot to sort fields without values. I always tried filtering for fields without values. Link to comment Share on other sites More sharing options...
bzndk Posted December 11, 2017 Share Posted December 11, 2017 Just wondering why the "module" is not using login information from TB? would it not make a lot more sence if it did? And be more secure? and since it allready uses the MySQL db connectet to the store it should be quite easy to actually add that, not a fan of hardcoded logins at all. But i like what you have done just think it could be better if it used the store admin logins. Link to comment Share on other sites More sharing options...
musicmaster Posted December 11, 2017 Author Share Posted December 11, 2017 From an user point of view it would certainly be more pleasant when Prestools would use the TB login. However, it is not as easy to implement as you suggest and it might have disadvantages too. Prestools operates outside the TB engine. Only that way can it have complete control over the screen and achieve adequate speed. So in order to use the TB login - that is tightly integrated with the rest of its code - the code must be replicated without that context. That would require a deep understanding of how the TB login works (the shop password is stored encoded and you also need to deal with the cookies that keep you logged in). So this is quite a tough job and I have never found the time and motivation for it. Maybe somewhere in the future, but this has not a high priority. I believe Prestools is quite secure as it is. But of course suggestions for improvement are always welcome. Link to comment Share on other sites More sharing options...
bzndk Posted December 15, 2017 Share Posted December 15, 2017 Should be quite easy to do actually, since TB uses the passwordverify and passwordhash feature for login Link to comment Share on other sites More sharing options...
musicmaster Posted January 18, 2018 Author Share Posted January 18, 2018 Recently Prestools had some bugs due to a few structural changes. Line submit had been changed to make virtual product edit work and to increase security the cookie format was changed. It should all work now again. Please notify me if you find any remaining problems. Recent improvements in Prestools: - problems with the mini-module were fixed. - product-solo was fixed. It had been dysfunctional since the line submit fix. Now that has been repaired and also a few improvements have been made. - Integrity checks has been improved and offers now the possibility to repair some problems. - Some minor additional functionality: attribute sort, statistics on categories - Some minor bug fixes Link to comment Share on other sites More sharing options...
Kleijn36 Posted February 14, 2018 Share Posted February 14, 2018 @musicmaster When i delete a special price i get this page/error. Link to comment Share on other sites More sharing options...
musicmaster Posted February 14, 2018 Author Share Posted February 14, 2018 Hi Kleijn, Sorry to hear you found some problem. I have uploaded an improved version that should solve the problem. Can you download it from your user account? Link to comment Share on other sites More sharing options...
Kleijn36 Posted February 14, 2018 Share Posted February 14, 2018 Yes will do that in an hour. Also no option to edit warehousing. Link to comment Share on other sites More sharing options...
musicmaster Posted February 14, 2018 Author Share Posted February 14, 2018 @kleijn36 Prestools cannot edit warehousing data. That is a limitation of the software. It only gives you a passive overview of what you have in stock. Link to comment Share on other sites More sharing options...
Kleijn36 Posted February 14, 2018 Share Posted February 14, 2018 @musicmaster Thanks for the quick update. Problem with delete special price is solved. Link to comment Share on other sites More sharing options...
Cassim Posted June 11, 2018 Share Posted June 11, 2018 Any plan to add a meta title mass updater ? @musicmaster Link to comment Share on other sites More sharing options...
musicmaster Posted June 11, 2018 Author Share Posted June 11, 2018 @cassim Do you have any problem doing that now? Link to comment Share on other sites More sharing options...
Cassim Posted June 14, 2018 Share Posted June 14, 2018 @musicmaster said in Prestools - the mass edit toolset: @cassim Do you have any problem doing that now? Its more a request. I love if it can do something like this : Mass update using a code line like this : Buy {productname} for just {pricevat} at {storename} So that you can make a custom meta tag, and fill this automatic to the products without meta tags already. Same goes for meta description. Link to comment Share on other sites More sharing options...
musicmaster Posted June 14, 2018 Author Share Posted June 14, 2018 You can do much of that already with the "copy from field" and "replace from field" mass update functions. The only thing that you can't get is discounted prices. Link to comment Share on other sites More sharing options...
Cassim Posted June 15, 2018 Share Posted June 15, 2018 @musicmaster So i can use the Copy from Name, into the field. ? And make it that way. ? As i don't see that obtion http://prntscr.com/jv7qkt Am i missing anything. ? Any module or something. ?? Im running 1.20 Link to comment Share on other sites More sharing options...
musicmaster Posted June 15, 2018 Author Share Posted June 15, 2018 For metadescription these options have been there for quite some time. For metatitle you need to download the latest version. Link to comment Share on other sites More sharing options...
colorful-ant Posted June 15, 2018 Share Posted June 15, 2018 @cassim from prestashop -> seoupdater https://www.prestashop.com/forums/topic/56865-seo-updater-module-automatically-generate-title-description-and-keywords-meta-tags/ it works with tb -> but it does not work with php 7+ I think the problem was here with mysql meta tags for products and category Link to comment Share on other sites More sharing options...
Cassim Posted June 19, 2018 Share Posted June 19, 2018 @musicmaster But you can't make it do. this title : Download (productname) now - For just (price) if you buy now - (product description) It can't do that. I can just copy from the description if i understand you right. . Link to comment Share on other sites More sharing options...
musicmaster Posted June 19, 2018 Author Share Posted June 19, 2018 Yes, you can do that perfectly with "replace from field". The only thing that will give a problem are the brackets of (productname). But if you do it with "Download xxxxx now - For just yyyyy if you buy now - zzzz" replacing the strings will work. Just three mass edit commands. Link to comment Share on other sites More sharing options...
Cassim Posted June 19, 2018 Share Posted June 19, 2018 Arh yes that is right. ! Link to comment Share on other sites More sharing options...
Beeta Posted November 23, 2018 Share Posted November 23, 2018 is it possible to configure a cronjob that run a specific prestools mass edit? Link to comment Share on other sites More sharing options...
musicmaster Posted November 23, 2018 Author Share Posted November 23, 2018 @foolab said in Prestools - the mass edit toolset: is it possible to configure a cronjob that run a specific prestools mass edit? No, that is not possible. Of course Prestools has quite a lot of different functions and it depends what you want to do. But in general it is not possible. Link to comment Share on other sites More sharing options...
