[Free script] Prestools - mass edit and other maintenance tools

[musicmaster]

For version 1.35 the Prestools minimodule for the backoffice has been rewritten. Make sure to update it when you update your Prestools.

[PanzerkampfPL]

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?

[musicmaster]

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.

[nestor44]

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

[musicmaster]

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.

[RCTSH]

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.

[nestor44]

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.

[musicmaster]

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?

[lovemyseo]

WIll this work with thirty bees ?

[musicmaster]

On 12/29/2024 at 6:35 AM, lovemyseo said:

WIll this work with thirty bees ?

Yes.

[PanzerkampfPL]

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? 
 

[musicmaster]

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.

[PanzerkampfPL]

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.

[Diwad]

For similar purpose I use AI to categorize products. Prestools doesn't have such option. 

[musicmaster]

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.

[Milano2]

Does the module have the ability to change the VAT rate without changing the gross price of the product?

[musicmaster]

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.

 

[Fabrizio Carloni]

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.

[Diwad]

Did you set your settings1 file? Make sure it's in the correct directory 

 

Edited January 21 by Diwad (see edit history)

[Fabrizio Carloni]

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.

[musicmaster]

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.

[Fabrizio Carloni]

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.

[Fabrizio Carloni]

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.

[musicmaster]

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.

[Fabrizio Carloni]

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.

[Fabrizio Carloni]

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.

[musicmaster]

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.

[Fabrizio Carloni]

11 minutes ago, musicmaster said:

Thank you for the suggestion. I have adapted the code.

Thank you for your support.

Best regards,
Fabrizio Carloni.

[Rolcsi]

@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

[musicmaster]

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?

[Rolcsi]

@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)

[musicmaster]

I have no idea. It would need direct access to try different variations in order to find out what exactly causes the problem.

[salouso]

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
 

[musicmaster]

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.

[Rodas7]

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

[musicmaster]

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

[Rodas7]

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

 

[musicmaster]

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

 

[Rodas7]

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

[musicmaster]

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.