musicmaster Posted November 3, 2024 Author Share Posted November 3, 2024 For version 1.35 the Prestools minimodule for the backoffice has been rewritten. Make sure to update it when you update your Prestools. Link to comment Share on other sites More sharing options...
PanzerkampfPL Posted November 10, 2024 Share Posted November 10, 2024 I have a new integration with a wholesaler that downloads products from the wholesaler. All downloaded new products from this integration display on a red background until edited. IF I edit anything in them and save in Prestools then it dipay properly. What could be the cause of displaying on red background? Is it possible to find error logs somewhere? Link to comment Share on other sites More sharing options...
musicmaster Posted November 10, 2024 Author Share Posted November 10, 2024 This is outdated. It is a warning about the "state" field in ps_product. That field was introduced in PS 1.7.0 and served as a kind of "in process" flag. If it was zero your product was being processed and not shown. That was not really a good idea and in the latest versions it no longer has an effect. But I haven't followed it and I am not sure when this change happened. So you can ignore it. Link to comment Share on other sites More sharing options...
nestor44 Posted November 26, 2024 Share Posted November 26, 2024 @musicmaster is there a way to change separator of multiple values in a column? I want to export a csv file with a few features and import them to a different product IDs in bulk, but the default separator of multiple values is comma. The values of features also have commas so the result of the import is incorrect. Link to comment Share on other sites More sharing options...
musicmaster Posted November 27, 2024 Author Share Posted November 27, 2024 10 hours ago, banan_44 said: @musicmaster is there a way to change separator of multiple values in a column? I want to export a csv file with a few features and import them to a different product IDs in bulk, but the default separator of multiple values is comma. The values of features also have commas so the result of the import is incorrect. Di you try changing the main separator to a comma? In that case the subseparator will become a semicolon. On the top level values are automatically enclosed in quotes when they contain the separator. Link to comment Share on other sites More sharing options...
RCTSH Posted November 27, 2024 Share Posted November 27, 2024 I'm experiencing continuous 500 errors with the theme,warehouse and there are issues with both the live and normal IqitElementor. Can anyone help me find and fix the error using PrestaTools? Additionally, I would like to know if the warehouse has been deprecated, as there have been no updates since 2023. Link to comment Share on other sites More sharing options...
nestor44 Posted November 27, 2024 Share Posted November 27, 2024 13 hours ago, musicmaster said: Di you try changing the main separator to a comma? In that case the subseparator will become a semicolon. On the top level values are automatically enclosed in quotes when they contain the separator. Thank you for your reply. I have just change the separator of columns to comma. Unfortunately, separator of multiple values in the column is still comma For the features column all values are combined and separated by comma. And that combined list is enclosed in quotes. So I still have the problem if one of the values contains comma in the text. Import separates this value into two different values. Link to comment Share on other sites More sharing options...
musicmaster Posted November 28, 2024 Author Share Posted November 28, 2024 13 hours ago, banan_44 said: Thank you for your reply. I have just change the separator of columns to comma. Unfortunately, separator of multiple values in the column is still comma For the features column all values are combined and separated by comma. And that combined list is enclosed in quotes. So I still have the problem if one of the values contains comma in the text. Import separates this value into two different values. Can you download the latest version and try again? Link to comment Share on other sites More sharing options...
lovemyseo Posted December 29, 2024 Share Posted December 29, 2024 WIll this work with thirty bees ? Link to comment Share on other sites More sharing options...
musicmaster Posted December 30, 2024 Author Share Posted December 30, 2024 On 12/29/2024 at 6:35 AM, lovemyseo said: WIll this work with thirty bees ? Yes. Link to comment Share on other sites More sharing options...
PanzerkampfPL Posted January 5 Share Posted January 5 Is it possible to add functionality in the future to automate certain actions? e.g. saving macros and running them via cron or manually? Or is there already a possibility, e.g. using external tools? Link to comment Share on other sites More sharing options...
musicmaster Posted January 6 Author Share Posted January 6 10 hours ago, PanzerkampfPL said: Is it possible to add functionality in the future to automate certain actions? e.g. saving macros and running them via cron or manually? Or is there already a possibility, e.g. using external tools? That is a broad question, given that Prestools has many different functions. But in general the answer is: no. Prestools depends heavily on javascript and that is hard to automate in a cron. The general philosophy of Prestools is also that you see what you are doing so that mistakes and bugs are discovered early and that clashes with the idea of automation. Link to comment Share on other sites More sharing options...
PanzerkampfPL Posted January 6 Share Posted January 6 I will describe with an example: I import periodically products that are mixed up and all go into one temporary category. The cyclical tasks I need to do are: - remove ‘temporary version’ from the description - filter and move to the correct category the products by name. e.g. dog food, cat food, rodent food Currently, for such tasks, I use a programme that records click sequences and emulates a human being. I do not need strictly cron. Link to comment Share on other sites More sharing options...
Diwad Posted January 6 Share Posted January 6 For similar purpose I use AI to categorize products. Prestools doesn't have such option. Link to comment Share on other sites More sharing options...
musicmaster Posted January 7 Author Share Posted January 7 16 hours ago, PanzerkampfPL said: I will describe with an example: I import periodically products that are mixed up and all go into one temporary category. The cyclical tasks I need to do are: - remove ‘temporary version’ from the description - filter and move to the correct category the products by name. e.g. dog food, cat food, rodent food Currently, for such tasks, I use a programme that records click sequences and emulates a human being. I do not need strictly cron. Removing "temporary version" from a description is just a search and replace operation. You can do that in Prestools too. Quite likely you could integrate AI things into Prestools too. After all Deepl translations have already been integrated. But I would need to know details to say more about that. Link to comment Share on other sites More sharing options...
Milano2 Posted January 15 Share Posted January 15 Does the module have the ability to change the VAT rate without changing the gross price of the product? Link to comment Share on other sites More sharing options...
musicmaster Posted January 16 Author Share Posted January 16 19 hours ago, Milano2 said: Does the module have the ability to change the VAT rate without changing the gross price of the product? Prestools is not a module, but a program. It contains two methods to handle this. The manual contains instructions on how to handle this in PHP. Product-edit has a mass edit function to adapt the ex price after you have updated the VAT rate. Link to comment Share on other sites More sharing options...
Fabrizio Carloni Posted January 21 Share Posted January 21 I have installed the latest version of Prestools https://www.prestools.com/Prestools_Suite.zip with the Prestools Suite v1.0.7 module but when I try to open Prestools with the module I get the error in attachment. I use Prestashop v1.7.8.11 with PHP v7.4.33. How can I solve it? Best regards, Fabrizio Carloni. Link to comment Share on other sites More sharing options...
Diwad Posted January 21 Share Posted January 21 (edited) Did you set your settings1 file? Make sure it's in the correct directory Edited January 21 by Diwad (see edit history) Link to comment Share on other sites More sharing options...
Fabrizio Carloni Posted January 21 Share Posted January 21 8 minutes ago, Diwad said: Did you set your settings1 file? Make sure it's in the correct directory I confirm that I have configured the settings1.php file correctly. If I try to open prestools without using the module everything works fine. I have put the directory correctly as in the example (Example: if you put your Prestools files in /admin123/preztoolz this will be "preztoolz"). I think it is a problem with the module. Best regards, Fabrizio Carloni. Link to comment Share on other sites More sharing options...
musicmaster Posted January 22 Author Share Posted January 22 10 hours ago, Fabrizio Carloni said: I confirm that I have configured the settings1.php file correctly. If I try to open prestools without using the module everything works fine. I have put the directory correctly as in the example (Example: if you put your Prestools files in /admin123/preztoolz this will be "preztoolz"). I think it is a problem with the module. Best regards, Fabrizio Carloni. Did you upgrade both Prestools and the minimodule? There are some recent changes in the mini-module. Link to comment Share on other sites More sharing options...
Fabrizio Carloni Posted January 22 Share Posted January 22 52 minutes ago, musicmaster said: Did you upgrade both Prestools and the minimodule? There are some recent changes in the mini-module. I downloaded the Prestools_Suite.zip file last night so I think it's the latest version. I didn't update but I preferred to uninstall the previous module and delete the prestools folder and do a clean install with only the modification of settings1.php and module configuration. However, I will do other tests this evening and then I will let you know better. A question: in the "cleanup" section there is both "Delete abondonned carts" and "Delete old connections". Which tables are modified and is it safe to do so? I'm afraid it could create problems with Prestashop or with some module but I also have a database that unfortunately has grown a lot. Best regards, Fabrizio Carloni. Link to comment Share on other sites More sharing options...
Fabrizio Carloni Posted January 22 Share Posted January 22 11 hours ago, musicmaster said: Did you upgrade both Prestools and the minimodule? There are some recent changes in the mini-module. I have done several tests and I have come to the conclusion that it is probably a compatibility issue of the Prestools Suite v1.0.7 module with Prestashop v1.7.8.11 and PHP v7.4.33. The problem is not in the new version of Prestools that works well but in the module that returns this error. With the Prestools Suite v1.0.6 and Prestools v1.34f module I have no problems. Best regards, Fabrizio Carloni. Link to comment Share on other sites More sharing options...
musicmaster Posted January 22 Author Share Posted January 22 10 hours ago, Fabrizio Carloni said: I downloaded the Prestools_Suite.zip file last night so I think it's the latest version. I didn't update but I preferred to uninstall the previous module and delete the prestools folder and do a clean install with only the modification of settings1.php and module configuration. However, I will do other tests this evening and then I will let you know better. I asked you about the mini-module (the part that you install as a module under Prestashop and that gave you the error) and in your reaction you only talk about the main part of Prestools. ??? 10 hours ago, Fabrizio Carloni said: A question: in the "cleanup" section there is both "Delete abondonned carts" and "Delete old connections". Which tables are modified and is it safe to do so? I'm afraid it could create problems with Prestashop or with some module but I also have a database that unfortunately has grown a lot. Cleanup abandonned carts cleans ps_cart_cart_rule, ps_cart_product and ps_cart. Cleanup connections cleans up ps_connections, ps_connections_source and ps_referrer_cache. Such cleanups are quite common. You will find many recommendations to truncate ps_connections on the forum. I don't know of any report that it gives problems. Link to comment Share on other sites More sharing options...
Fabrizio Carloni Posted January 22 Share Posted January 22 17 minutes ago, musicmaster said: I asked you about the mini-module (the part that you install as a module under Prestashop and that gave you the error) and in your reaction you only talk about the main part of Prestools. ??? Cleanup abandonned carts cleans ps_cart_cart_rule, ps_cart_product and ps_cart. Cleanup connections cleans up ps_connections, ps_connections_source and ps_referrer_cache. Such cleanups are quite common. You will find many recommendations to truncate ps_connections on the forum. I don't know of any report that it gives problems. The mini module v1.0.7 does not work for me and gives me the error I attached before. Do you have a way to do some tests on Prestashop v1.7.8.11 and PHP v7.4.33? Thanks for the explanation on the use of cleaning. Best regards, Fabrizio Carloni. Link to comment Share on other sites More sharing options...
Fabrizio Carloni Posted January 22 Share Posted January 22 1 hour ago, musicmaster said: I asked you about the mini-module (the part that you install as a module under Prestashop and that gave you the error) and in your reaction you only talk about the main part of Prestools. ??? Cleanup abandonned carts cleans ps_cart_cart_rule, ps_cart_product and ps_cart. Cleanup connections cleans up ps_connections, ps_connections_source and ps_referrer_cache. Such cleanups are quite common. You will find many recommendations to truncate ps_connections on the forum. I don't know of any report that it gives problems. I changed line 73 in in modules/prestoolssuite/controllers/admin/AdminPrestoolsSuiteController.php From public function setMedia() To public function setMedia($isNewTheme = false) And now the mini module works fine. I think you need to make a correction. Best regards, Fabrizio Carloni. Link to comment Share on other sites More sharing options...
musicmaster Posted January 23 Author Share Posted January 23 11 hours ago, Fabrizio Carloni said: I changed line 73 in in modules/prestoolssuite/controllers/admin/AdminPrestoolsSuiteController.php From public function setMedia() To public function setMedia($isNewTheme = false) And now the mini module works fine. I think you need to make a correction. Best regards, Fabrizio Carloni. Thank you for the suggestion. I have adapted the code. Link to comment Share on other sites More sharing options...
Fabrizio Carloni Posted January 23 Share Posted January 23 11 minutes ago, musicmaster said: Thank you for the suggestion. I have adapted the code. Thank you for your support. Best regards, Fabrizio Carloni. Link to comment Share on other sites More sharing options...
Rolcsi Posted January 26 Share Posted January 26 @musicmaster Hi, I have used perstools in the past and bought several modules for it. The problem is that I get a 504 error after the login page. I am using the latest release, PS1.6.23, PHP-FPM 7.,1 max script time = 300s, own server, php error log (70007)The timeout specified has Link to comment Share on other sites More sharing options...
musicmaster Posted January 26 Author Share Posted January 26 26 minutes ago, Rolcsi said: @musicmaster Hi, I have used perstools in the past and bought several modules for it. The problem is that I get a 504 error after the login page. I am using the latest release, PS1.6.23, PHP-FPM 7.,1 max script time = 300s, own server, php error log (70007)The timeout specified has Hi Rolsci, What happens when you do the redirect yourself? That is: when you type the url to access product-edit.php. What changed after which it no longer works? Link to comment Share on other sites More sharing options...
Rolcsi Posted January 26 Share Posted January 26 (edited) @musicmaster Honestly, I have no idea. Maybe it's because I moved to a new server If I try product-edit.php it's the same. I will correct it: - apache error log (70007)The timeout specified has - no php error log Very strange.... Edited January 26 by Rolcsi (see edit history) Link to comment Share on other sites More sharing options...
musicmaster Posted January 27 Author Share Posted January 27 I have no idea. It would need direct access to try different variations in order to find out what exactly causes the problem. Link to comment Share on other sites More sharing options...
salouso Posted February 7 Share Posted February 7 Hi I have installed Prestools on all my domains (1.7.6.7) including the mini module suite. Now I just installed a fresh Prestashop 8.2 and downloaded your newest version which says it includes 8.2. Installation runs fine, but after installing the module(suite) I have 2 issues. First of all I see two entries Prestool Suite under Catalog in the Backoffice. Second and more serious problem: When clicking on one of those entries I get "Prestashop 8.2 is not yet supported by Prestools.". Please help as I urgently need to update all my shops within a week (php compatibilty issue with my new server) and the useless autoupgrader Prestashop offers does absolutely not work. Lost an entire day with that, so now I want to go down the manual way with the help of your module, that I love by the way 🙂 Kind Regards Sarah Link to comment Share on other sites More sharing options...
musicmaster Posted February 7 Author Share Posted February 7 Hi Sarah, Good to hear you like Prestools. The only possible cause is that you have an old version of Prestools confused with the new version. Please have a look in footer1.php for the version number. You can also access Prestools without the module - outside the backoffice. Link to comment Share on other sites More sharing options...
Rodas7 Posted February 22 Share Posted February 22 Hi Musicmaster I install Prestools in my Prestashop 1.7.6.5. When I try in the browser product-edit.php and I got this msg approve.php was not found! Could you help me please Thanks Paulo Link to comment Share on other sites More sharing options...
musicmaster Posted February 22 Author Share Posted February 22 Hi Paulo, The file approve.php is included in the zip file. So maybe you forgot to copy it or accidentally moved or deleted it. M Link to comment Share on other sites More sharing options...
Rodas7 Posted February 22 Share Posted February 22 Hi MusicMaster Thanks Do not know how but approve.php was not copied. + Now it works. It was the first step to install Prestools correctly. I have a B2B SHOP that worked for the last 5 years. Now suddenly the admin back office stopped working or is working with problems and very slow. The Prestashop I am using is 1.7.6.5. and php version 7.3. Front Office is working ok as usual. I tried many things and nothing worked. I thought about doing a new installation with Prestashop 8.2.0 and use your copy_shopdata to copy tables from old to new Prestashop.( If you think is better I can install the same version of Prestashop 1.7.6.5?) I read the manual about copy_shopdata, but I am not a experienced developer and I am affraid that it might be complicated for me, but I will try to follow yours "steps". Thanks again Paulo Link to comment Share on other sites More sharing options...
musicmaster Posted February 23 Author Share Posted February 23 14 hours ago, Rodas7 said: Hi MusicMaster Thanks Do not know how but approve.php was not copied. + Now it works. It was the first step to install Prestools correctly. I have a B2B SHOP that worked for the last 5 years. Now suddenly the admin back office stopped working or is working with problems and very slow. The Prestashop I am using is 1.7.6.5. and php version 7.3. Front Office is working ok as usual. I tried many things and nothing worked. I thought about doing a new installation with Prestashop 8.2.0 and use your copy_shopdata to copy tables from old to new Prestashop.( If you think is better I can install the same version of Prestashop 1.7.6.5?) I read the manual about copy_shopdata, but I am not a experienced developer and I am affraid that it might be complicated for me, but I will try to follow yours "steps". Thanks again Paulo I wouldn't expect problems with Copy_shopdata when going from 1.7.6 to 8.2. So I agree with you that PS 8.2 is the better choice. Of course changing version may bring costs for modules and a theme. Feel free to ask when you find a step hard or find some problems in the process. Don't forget to test everything when the copying is finished. M Link to comment Share on other sites More sharing options...
Rodas7 Posted February 24 Share Posted February 24 On 2/23/2025 at 7:41 AM, musicmaster said: I wouldn't expect problems with Copy_shopdata when going from 1.7.6 to 8.2. So I agree with you that PS 8.2 is the better choice. Of course changing version may bring costs for modules and a theme. Feel free to ask when you find a step hard or find some problems in the process. Don't forget to test everything when the copying is finished. M Hi My old shop (prestashop 1.7.6.5 is in a server) and my new shop(prestshop 8.2.0) are in same provider but in differents servers. The USERNAME is different, the server name is different. I use the info in the /app/config/parameters.php(old shop). In the databas_host I have 'database_host' => 'localhost', For the server i Tryed IP, server name, mydomain.com,'localhost'.. but I always receive this error. ____________ "Copy_shopdata version 0.75 starting at 12:02:27 You are copying tables 1-5 of 221 tables. Beware of timeouts: After finishing the last line on the screen should be "** finished **". If necessary increase the timeout at the start of this file. After a timeout you can increase startnum as you don't need to copy processed tables again. Could not connect to old database server!!! Did you fill in the credentials of the old shop correctly in the configuration file? ____________- What should I put in server name? As far as I understand after solving this server problem I need to set "$copy_mode" in the config file to "row"? I alredy tryied this also. Tnanks Paulo Link to comment Share on other sites More sharing options...
musicmaster Posted February 24 Author Share Posted February 24 Most servers don't allow external connections to the database. The best approach is exporting the database from the old server and importing into the new server. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now