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

[musicmaster]

Prestools is a suite of user-friendly and 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. There are also an instruction video and a demo website.

As an extra the following plugins can be bought: Features, Tags Plugin, Special Prices, Carriers, Suppliers, Combinations Copy and Delete, Image Cleanup, Multishop, Images, Customizations and Translation.

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.

Prestools does not support warehousing. So if your shop uses warehouses you should not use Prestools for any operation in which product quantities are changed.

Prestools operates outside the backoffice what allows it to be very fast. It supports multiple user accounts and logging.

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

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 "[email protected]" 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 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:

Prestools is compatible with Prestashop 1.5, 1.6, 1.7 and 8 and Thirty Bees.

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 adds a link to your Prestools installation in the Catalog menu of the backoffice.

If you find a problem, please update Prestools to its latest version before you report it here. When reporting, please mention your Prestashop version.

Follow the installation instructions! This is not a module!

       

Edited November 19 by musicmaster (see edit history)

[musicmaster]

This is how the product-edit page looks. 

[orotoi]

Great tool. I was using the free version for some time, and last week I bought the paid version for the "Features" edit ability.

Thanks for this nice and so useful tool, and I hope this new thread dont get deleted cause the previous had tons of info that now got lost..

[solsol69]

Thank you very much

[orotoi]

Hi @musicmaster

Is it possible on the Mass Update (on product or combination edits) where you SET a value to a field to use variables?

eg.. Mass Update a reference field by using product_id as a variable [ something like %id% ]

 

[musicmaster]

44 minutes ago, orotoi said:

Hi @musicmaster

Is it possible on the Mass Update (on product or combination edits) where you SET a value to a field to use variables?

eg.. Mass Update a reference field by using product_id as a variable [ something like %id% ]

 

You can do something like that with the "replace from field" option in the mass update menu.

[orotoi]

1 hour ago, musicmaster said:

You can do something like that with the "replace from field" option in the mass update menu.

Not useful for the case I need..

I want to give on the product combinations the following Reference pattern:

[CAT_ID]-[Product_ID]-[xxx]  

[xxx] is a number that i can give with "Insert After", but the first two var's... I dunno..

 

--

Also, is it possible to export to csv a given List as it appears on Product Combis (on Product Edit we can). At the moment I just select all rows and copy/paste them on spreadsheet..

 

 

Edited June 16, 2022 by orotoi (see edit history)

[musicmaster]

In the next release I will add an option to copy the product and category id's. That should solve your problem there.

Exporting Product combi's is not possible at the moment and not planned either.

[SandroR1]

Hello Musicmaster,

I find the massive regeneration of friendly url of products and categories very useful, but I would like to know if, in some way, it is possible to regenerate product url and category url separately (not both together).

I would also like to know if you plan to insert a function for the massive regeneration of image legends.

Prestool is magnificent: thank you a thousand times.

Hello.

[musicmaster]

31 minutes ago, SandroR1 said:

I find the massive regeneration of friendly url of products and categories very useful,

Which function where in the menu are you talking about?

[SandroR1]

12 minutes ago, musicmaster said:

Which function where in the menu are you talking about?

 

-> Tools & Stats -> Cleanup -> Regenerate friendly urls for products and categories

[musicmaster]

On 6/30/2022 at 5:08 PM, SandroR1 said:

Hello Musicmaster,

I find the massive regeneration of friendly url of products and categories very useful, but I would like to know if, in some way, it is possible to regenerate product url and category url separately (not both together).

I would also like to know if you plan to insert a function for the massive regeneration of image legends.

Prestool is magnificent: thank you a thousand times.

Hello.

Can you check the new version? The legends are under image_regenerate.

[SandroR1]

4 hours ago, musicmaster said:

Can you check the new version? The legends are under image_regenerate.

Hi Musicmaster,

I have done several tests and everything works PERFECTLY.

I think that, in case of massive changes to the name of the products, it is very useful to regenerate the image legends and the friendly urls.

I thank you once again for your kindness and for this indispensable tool.

Thank you.

Have a nice evening.

 

--

Sandro

[kerami82]

HI @musicmaster

In prestashop, it is possible to set the type of redirection for the product and to select, for example, the category to which the product will be redirected after deactivation. Can I edit this by Prestools?

[musicmaster]

On 10/10/2022 at 5:19 PM, kerami82 said:

HI @musicmaster

In prestashop, it is possible to set the type of redirection for the product and to select, for example, the category to which the product will be redirected after deactivation. Can I edit this by Prestools?

Sorry for the late reaction. No they are at the moment not supported.

[musicmaster]

 A new version of Prestools has appeared. Among other improvements is the support for generating webp images

[Hart]

works also with 1.7.8.8 version?

 

thanks

[musicmaster]

4 hours ago, Hart said:

works also with 1.7.8.8 version?

 

thanks

Yes

[orotoi]

Thanks for that update.. will check it as soon as possible next days. webp image generation seems nice

 

[musicmaster]

In the latest upgrade ProdCombi got a thorough review and a couple of bug fixes.

[linkin11]

Hello
I update the core version to the latest, and i see everywhere that i use demos instead of the bought modules.
I revert to my old version, and everything is ok again.
And yes, i copied all feature php files in to the main folder of the module.

Must i buy the add on again when using the latest module version?

thanks for this great module and service so far.
Still very happy besides this thing
 

[musicmaster]

I don't know what you did but the mechanism for the plugins didn't change. So somehow you must have deleted the TE_* files.

Of course it wouldn't hurt to download the latest version of the plugins. But that isn't the source of your problem.

[linkin11]

I have the full package of plugins, but it gives now this message:

In Prestools Free the image field is in demo mode and your changes cannot be saved. For full functionality buy Prestools Professional or the specific plugin at www.Prestools.com.

Is that this file who is in de root folder. te_plugin_images.php

thanks

 

[musicmaster]

It is a set of files. And there name starts with TE (in capitals).

[linkin11]

 

These below are mine.

Capitals will auto renamed from big to small, but that's not the issue.

Edited January 16, 2023 by Queenfan.nl
text (see edit history)

[musicmaster]

2 minutes ago, Queenfan.nl said:

Capitals will auto renamed from big to small, but that's not the issue.

Only when you are running under Windows. Linux is case sensitive.

[linkin11]

On 1/16/2023 at 6:01 PM, musicmaster said:

Only when you are running under Windows. Linux is case sensitive.

Changed to capital and it works again, thanks/

Question.

I want to remove multiple images from stock who is 0 and disabled.

I can remove the images 1 by 1 by clicking them individualy first and run, so they will be deleted.

I miss the function to select them all in 1 one and delete all images in 1 click.

Is that possible that you can make this query in the tool?

See image.

Thanks for all great effort so far, i use it for many years already.

[musicmaster]

On 1/20/2023 at 4:33 PM, Queenfan.nl said:

Changed to capital and it works again, thanks/

Question.

I want to remove multiple images from stock who is 0 and disabled.

I can remove the images 1 by 1 by clicking them individualy first and run, so they will be deleted.

I miss the function to select them all in 1 one and delete all images in 1 click.

Is that possible that you can make this query in the tool?

See image.

Thanks for all great effort so far, i use it for many years already.

Hi Queenfan,

I added an option "remove" to the image mass edit. Can you check it out?

 

[linkin11]

5 minutes ago, musicmaster said:

Hi Queenfan,

I added an option "remove" to the image mass edit. Can you check it out?

 

I will update the module and let you know, many thanks 

[linkin11]

Unfortunately, it doesn't do the job, see screen.

When selecting remove and click the Submit all button. nothing happen.

The page return to this blanco standard settings and i must insert the parameters again.

 

[musicmaster]

2 hours ago, Queenfan.nl said:

Unfortunately, it doesn't do the job, see screen.

When selecting remove and click the Submit all button. nothing happen.

The page return to this blanco standard settings and i must insert the parameters again.

 

You didn't press ctrl-F5 to refresh the javascript. So you are still looking at the effect of the old version's javascript from the cache.

Edited January 23, 2023 by musicmaster (see edit history)

[linkin11]

18 hours ago, musicmaster said:

You didn't press ctrl-F5 to refresh the javascript. So you are still looking at the effect of the old version's javascript from the cache.

That doesn't make the difference, after refresh or anything else the images are still there.

Also in the database and the backoffice.

[linkin11]

19 hours ago, musicmaster said:

You didn't press ctrl-F5 to refresh the javascript. So you are still looking at the effect of the old version's javascript from the cache.

It works, i delete the cache manually, not by ctrl F5. many thanks musicmaster

[pietaszeq]

Hi, is there any chance to have prestatools version compatible with Presta 8.0?

[musicmaster]

14 hours ago, pietaszeq said:

Hi, is there any chance to have prestatools version compatible with Presta 8.0?

You can run the latest versions of Prestools with PS 8.0. The PS changes have been mainly in the software (new Symfony version, etc) and not in the database where Prestools looks.

As far as I can see there are no major changes that need adaptations in Prestools. As always: report problems when you find them. I will be happy to fix them.

[pietaszeq]

Hi, I'm facing some issues. after copying all the files to a directory and trying to load a product-edit page, I'm getting this error: Error loading 1.5/1.6 config file!

do you know what is wrong?

[musicmaster]

2 hours ago, pietaszeq said:

Hi, I'm facing some issues. after copying all the files to a directory and trying to load a product-edit page, I'm getting this error: Error loading 1.5/1.6 config file!

do you know what is wrong?

Hi, I see that my fix for working with Prestashop 8 gives some problems. I have uploaded a fix. Can you test it?

[pietaszeq]

1 hour ago, musicmaster said:

Hi, I see that my fix for working with Prestashop 8 gives some problems. I have uploaded a fix. Can you test it?

It's working perfectly  Thanks a lot!

[Mihai00700]

Hello, how can I use the the function "Repair ps_currency_lang"?

I updated ps. to version 1.7.8.8 from 1.7.4.4. I saw your prestools function that can repair ps_currency_lang issues, but it doesen't works. When I hover over it with my mouse it turns orange and when I click on it nothing happens. @musicmaster Can you help me?

 

Edited February 11, 2023 by Mihai00700 (see edit history)

[musicmaster]

30 minutes ago, Mihai00700 said:

Hello, how can I use the the function "Repair ps_currency_lang"?

I updated ps. to version 1.7.8.8 from 1.7.4.4. I saw your prestools function that can repair ps_currency_lang issues, but it doesen't works. When I hover over it with my mouse it turns orange and when I click on it nothing happens. @musicmaster Can you help me?

 

Clicking this should open a new window where some functions are executed. It may be that some anti-spam function in your browser stops the opening of that new window.

[Mihai00700]

It doesen't work. When I click the button nothing happens. I disabled my ad blocker and I tried accessing it with other browsers. Can you please help me, my site is not working for over 5 days and I don't know what to do anymore.

[musicmaster]

If you pm me access data for your website (FTP) I can fix it for you.

If you know how to work with phpmyadmin I can also explain to you how to fix this. But that will of course only work when it is indeed the currency_lang table.

[SandroR1]

Hello Musicmaster,

is it possible that the "!in" filter does not work on the "reference" field?

I've tried several times (and I think I've used it before), but it just doesn't seem to work.

Would you be so kind as to try?

Thank you.

Bye.

--

SandroR1

[musicmaster]

Hi Sandro,

I have uploaded a fix. Can you test it.

Note that reference test both the product reference and the supplier reference,

M

[SandroR1]

11 hours ago, musicmaster said:

I have uploaded a fix. Can you test it.

Note that reference test both the product reference and the supplier reference,

 

Good morning Musicmaster!

it's perfect, everything works wonderfully!

Thank you very much!

I would like to report a small bug that I had detected some time ago: when 3 filters are applied, the export to csv file does not consider the third filter.

I will never thank you enough for this wonderful tool.

Thank you again.

Have a good day.

[musicmaster]

Hi Sandro,

Thank you for the additional bug report. It has been fixed.

I also fixed a bug with image uploading that sometimes gave black backgrounds when the source was a png and the target a jpg.

M

[SandroR1]

On 2/18/2023 at 1:58 PM, musicmaster said:

Hi Sandro,

It has been fixed.

 

Thank you very much!

--

Sandro

[bakko88]

hI, I HAVE THIS ERROR AFTER UPDATE:

Prestashop 1.7.8 is not yet supported by Prestools.

[musicmaster]

38 minutes ago, bakko88 said:

hI, I HAVE THIS ERROR AFTER UPDATE:

Prestashop 1.7.8 is not yet supported by Prestools.

Did you download the latest version and replace all files?

Edited March 10, 2023 by musicmaster (see edit history)

[banan_44]

Hi @musicmaster, thank you for this great piece of work. I have a little problem. Here are my specs: Prestashop version: 8.0.1, multilanguage with multistore enabled. Prestools version 1.31j. Release date: 14-feb-2023. PHP version 8.1.15 and MySQL version 10.4.27-MariaDB-cll-lve under Linux u34 3.10.0-962.3.2.lve1.5.77. PS 8.0.1 was freshly installed a few days ago.

I wanted to mass update names of the products in one category. Changes only in language in all of my shops. After clicking on Submit button I have a following error but despite it Prestools changed the names correctly (I think). The new names of products included German special characters. Maybe that's relevant to this error.

Time=01:05:44
41-1-1,41-1-2,
41-1-3,41-1-4,41-1-5,41-1-6,41-2-1,41-2-2,41-2-3,41-2-4,41-2-5,41-2-6,41-3-1,41-3-2,41-3-3,41-3-4,41-3-5,41-3-6,
41-4-1,41-4-2,41-4-3,41-4-4,41-4-5,41-4-6,41-5-1,41-5-2,41-5-3,41-5-4,41-5-5,41-5-6,41-6-1,41-6-2,41-6-3,41-6-4,
41-6-5,41-6-6,41-7-1,
Warning: Undefined variable $products_array in /XXXX/adminXXXXX/prestools/ps_sourced_code.php on line 620

Fatal error: Uncaught TypeError: array_unique(): Argument #1 ($array) must be of type array, null given in /XXX/adminXXXXX/prestools/ps_sourced_code.php:620 Stack trace: #0 /XXX/adminXXXXX/prestools/ps_sourced_code.php(620): array_unique(NULL) #1 /XXX/adminXXXXX/prestools/product-proc.php(947): update_shop_index(10, Array) #2 {main} thrown in /XXX/adminXXXXX/prestools/ps_sourced_code.php on line 620

 

[musicmaster]

9 hours ago, banan_44 said:

Hi @musicmaster, thank you for this great piece of work. I have a little problem. Here are my specs: Prestashop version: 8.0.1, multilanguage with multistore enabled. Prestools version 1.31j. Release date: 14-feb-2023. PHP version 8.1.15 and MySQL version 10.4.27-MariaDB-cll-lve under Linux u34 3.10.0-962.3.2.lve1.5.77. PS 8.0.1 was freshly installed a few days ago.

I wanted to mass update names of the products in one category. Changes only in language in all of my shops. After clicking on Submit button I have a following error but despite it Prestools changed the names correctly (I think). The new names of products included German special characters. Maybe that's relevant to this error.

Time=01:05:44
41-1-1,41-1-2,
41-1-3,41-1-4,41-1-5,41-1-6,41-2-1,41-2-2,41-2-3,41-2-4,41-2-5,41-2-6,41-3-1,41-3-2,41-3-3,41-3-4,41-3-5,41-3-6,
41-4-1,41-4-2,41-4-3,41-4-4,41-4-5,41-4-6,41-5-1,41-5-2,41-5-3,41-5-4,41-5-5,41-5-6,41-6-1,41-6-2,41-6-3,41-6-4,
41-6-5,41-6-6,41-7-1,
Warning: Undefined variable $products_array in /XXXX/adminXXXXX/prestools/ps_sourced_code.php on line 620

Fatal error: Uncaught TypeError: array_unique(): Argument #1 ($array) must be of type array, null given in /XXX/adminXXXXX/prestools/ps_sourced_code.php:620 Stack trace: #0 /XXX/adminXXXXX/prestools/ps_sourced_code.php(620): array_unique(NULL) #1 /XXX/adminXXXXX/prestools/product-proc.php(947): update_shop_index(10, Array) #2 {main} thrown in /XXX/adminXXXXX/prestools/ps_sourced_code.php on line 620

 

This error happens in the indexation part that is done after the product changes have been processed. So the changes have been saved correctly.

I have uploaded a new version that should fix the problem.

[prestalearn]

In the products sold, is it possible to have the stock quantity as well? This would make us able to calculate how much we need to order to do a simple excel column by taking the products sold in a desired time frame and calculate towards what is in stock and then see how much we need to order from supplier?

[musicmaster]

On 4/19/2023 at 8:25 AM, prestalearn said:

In the products sold, is it possible to have the stock quantity as well? This would make us able to calculate how much we need to order to do a simple excel column by taking the products sold in a desired time frame and calculate towards what is in stock and then see how much we need to order from supplier?

I have uploaded a new version with such a function. Can you have a look?

[prestalearn]

14 hours ago, musicmaster said:

I have uploaded a new version with such a function. Can you have a look?

Thanks its great!

Would it be possible to have a field above where you can enter like "expected to be sold in xx days" based on last xxx days? (the last xxx days is same as the current time frame selected on the products sold date fields).

For example you can then enter 180 and see how many that is supposed to be sold in the next 180 days based on the sales from the period originally selected?

 

[musicmaster]

1 hour ago, prestalearn said:

Thanks its great!

Would it be possible to have a field above where you can enter like "expected to be sold in xx days" based on last xxx days? (the last xxx days is same as the current time frame selected on the products sold date fields).

For example you can then enter 180 and see how many that is supposed to be sold in the next 180 days based on the sales from the period originally selected?

 

Sorry, I don't understand this.

If you expect the coming x days to sell the same as the last x days the number is already on the page. So what is the point of repeating it?

[prestalearn]

1 hour ago, musicmaster said:

Sorry, I don't understand this.

If you expect the coming x days to sell the same as the last x days the number is already on the page. So what is the point of repeating it?

Sorry will try to explain:

1. You get a product in stock and start selling it 20230201. 

2. The product sell well and today you want to order a restock that you want to last XX days (for example 365 if you want to calculate purchase for a year).

3. Then you select sales period 20230201-20230421 (since you cant calculate the time if the product was not in stock)

4. If the sales has been 100 items in the time range, like in my example 80 days - The calculation should be 100/80 = 1,25. And if you have entered the 365 value in a calculation field it should say like "Restock for 365 days = 456,25".

SOrry if i was unclear. Simply sometimes you want to calculate the sales for products that has not been active the same time as the calculation period.

[musicmaster]

As far as I know there is nothing in the system that records when a product was active/in stock and when not

[prestalearn]

On 4/21/2023 at 12:48 PM, musicmaster said:

As far as I know there is nothing in the system that records when a product was active/in stock and when not

No, thats why i meant that if you have a datefield to enter your desired date to calculate from you dont need to pick that from Presta.

So the thing that would be great is:

1. A datefield to/from to calculate historic sales and then a field with days.

In this way you can enter like 2022-01-01 to 2022-06-30 for example and based on the sales on this date calculate how much you need to buy in XXX days.

Did you understand how i meant? 😃

[musicmaster]

As I understand it you want a kind of calculator where for example you provide a period of 200 days and then you enter the number 50 and if you sold 80 in those 200 days it will produce 20.

This is much too specific for the general product. So this would need to become a custom made product for which I would need to charge you some money.

As a small concession I have added the number of days to the date range in the following version. I am not yet sure when that will appear.

[prestalearn]

On 4/20/2023 at 5:51 PM, musicmaster said:

I have uploaded a new version with such a function. Can you have a look?

Hi, i tried it, seems to work when output is done in the browser, but when exported to CSV it uses the quantity field in the stock column so you only get the sold products exported in both fields. (and no name on the row for stock)

[musicmaster]

I too realized that I had forgotten csv (a separate program). It will be corrected in the next release.

[musicmaster]

The last Prestools version (1.32a) had some problems saving texts in product-edit. I released a new version that solved that: 1.32b.

One nice feature of the new version is that image-regenerate now has an option to only (re)generate images that are not there or have a different format. This makes it yet faster.

Edited April 26, 2023 by musicmaster (see edit history)

[banan_44]

@musicmasterPrestools show me a warning "You have 1 unindexed products in your shop(s).". When I click on it it turns to "You have 0 unindexed products in your shop(s)." but when I refresh the page it shows me 1 again. I have re-built the entie search index. Prestashop shows me that all products are indexed but Prestools still shows 1 unindexed product. Is there a way to verify somehow which product is problematic in Prestools?

My Presta: Prestashop version: 8.0.3. Prestools version 1.32b. Release date: 26-apr-2023. PHP version 8.1.17 and MySQL version 10.4.27

[musicmaster]

On 4/26/2023 at 7:53 PM, banan_44 said:

@musicmasterPrestools show me a warning "You have 1 unindexed products in your shop(s).". When I click on it it turns to "You have 0 unindexed products in your shop(s)." but when I refresh the page it shows me 1 again. I have re-built the entie search index. Prestashop shows me that all products are indexed but Prestools still shows 1 unindexed product. Is there a way to verify somehow which product is problematic in Prestools?

My Presta: Prestashop version: 8.0.3. Prestools version 1.32b. Release date: 26-apr-2023. PHP version 8.1.17 and MySQL version 10.4.27

There is no specific tool for it. But my guess would be that it some malformed product. Did you run the integrity checks.

When I look at the code Prestashop looks that a product is both in ps_product and ps_product_shop and Prestools looks only in ps_product_shop. So my guess would be that this is a product that is present in ps_product_shop but not in ps_product. 

If you want to run SQL code. This is how it works in Prestools:

SELECT COUNT(DISTINCT id_product) AS unindexedcount FROM ps_product_shop ps
INNER JOIN ps_shop s ON ps.id_shop=s.id_shop AND s.active=1
 WHERE indexed='0' AND visibility IN ('both', 'search') AND ps.`active` = 1

Remove the COUNT() and you get your product.

[banan_44]

@musicmasterthnak you for your quick reply. I have checked my database. It turns out I have a product with ID 0 stored in database 😲 I have no idea how did that happen. I cannot see that product in back office, prestools also does not see it on the list of products. When I dug deeper I found out that this product with ID 0 is an exact copy of my other product with ID 1601. Do you know what could have happen or how to safely remove product ID 0 from database? I can see that this product ID is a few tables and I do not want to mess up the database.

[musicmaster]

20 minutes ago, banan_44 said:

@musicmasterthnak you for your quick reply. I have checked my database. It turns out I have a product with ID 0 stored in database 😲 I have no idea how did that happen. I cannot see that product in back office, prestools also does not see it on the list of products. When I dug deeper I found out that this product with ID 0 is an exact copy of my other product with ID 1601. Do you know what could have happen or how to safely remove product ID 0 from database? I can see that this product ID is a few tables and I do not want to mess up the database.

This kind of things is rather common and usually doesn't do any harm. So if you don't have problems with your webshop it won't hurt to leave it so. Deleting it won't hurt either. If you delete it it is preferable to do so with the function in Integrity Checks as that erases it in all relevant tables.

It is easy to make a programming mistake that results in such a "double" and as it doesn't hurt it is usually not noticed. Don't waste your time searching for a cause.

[banan_44]

@musicmasterthank you for info. I have decided to remove this ID from my database. I also found a reference to ID 0 in other table. Just in case I have made a copy of rows that I have removed. Thank you for your help :)

[musicmaster]

The mini-module is now PS 8.0 compatible too. The rest of the software was already so.

[vmarkovic]

Hallo,

I am trying to run it on a Prestashop 8.04 store but it is just redirecting me to a front store 404 page. It is working fine on my other Prestashop 1.6.x store though.
Any help is appreciated.

[musicmaster]

3 hours ago, vmarkovic said:

Hallo,

I am trying to run it on a Prestashop 8.04 store but it is just redirecting me to a front store 404 page. It is working fine on my other Prestashop 1.6.x store though.
Any help is appreciated.

404 is "file not found". As you don't mention the url in your address bar it is hard to say what goes wrong. But I can mention a few things that may help:

 - don't use the directory, but address a file. So for example "www.shop.com/admin/prestools/product-edit.php" instead of just "www.shop.com/admin/prestools/"

 - download the latest version of Prestools. Due to changes in the Prestashop files in 8.0 the Prestools algorithm to find the shop root had to be changed. Older versions can give problems.

 

[vmarkovic]

14 hours ago, musicmaster said:

404 is "file not found". As you don't mention the url in your address bar it is hard to say what goes wrong. But I can mention a few things that may help:

 - don't use the directory, but address a file. So for example "www.shop.com/admin/prestools/product-edit.php" instead of just "www.shop.com/admin/prestools/"

 - download the latest version of Prestools. Due to changes in the Prestashop files in 8.0 the Prestools algorithm to find the shop root had to be changed. Older versions can give problems.

 

Hi,

Thanks for your time. I have indeed been using the latest Prestools version, as well as pointing my browser to login1.php file.

So I`ve put the script in mysite.com/myadmin/prestools/
When I try to access the script it ends up on the following link: mysite.com/myadmin/prestools/index.php?controller=AdminDashboard&token=01a0aa11f533a7b611d0bc5cc6635fd2 showing the front office site with the text: The page you are trying to access is not found

If I try to access it via back office module it just shows blank site.
 

Regards

Edited May 29, 2023 by vmarkovic (see edit history)

[musicmaster]

1 hour ago, vmarkovic said:

So I`ve put the script in mysite.com/myadmin/prestools/
When I try to access the script it ends up on the following link: mysite.com/myadmin/prestools/index.php?controller=AdminDashboard&token=01a0aa11f533a7b611d0bc5cc6635fd2 showing the front office site with the text: The page you are trying to access is not found

If I try to access it via back office module it just shows blank site.
 

First of all: your images show the location of your admin directory. Please fix that.

Can you replace the mini-module with the most recent version? Note that I made a last moment update. So you will need to download it again.

It puzzles me why a direct call with mysite.com/myadmin/prestools/login1.php shouldn't work. Can you give me access so that I can have a look for myself?

 

 

Edited May 29, 2023 by musicmaster (see edit history)

[vmarkovic]

7 minutes ago, musicmaster said:

First of all: your images show the location of your admin directory. Please fix that.

Can you replace the mini-module with the most recent version? Note that I made a last moment update. So you will need to download it again.

It puzzles me why a direct call with mysite.com/myadmin/prestools/login1.php shouldn't work. Can you give me access so that I can have a look for myself?

 

 

I`ve just sent you login details. Thank you, really appreciate your help.

[RCTSH]

On 6/4/2022 at 12:42 PM, musicmaster said:

Prestools is a suite of user-friendly and .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 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.

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 "[email protected]" 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 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:

Prestools is compatible with Prestashop 1.5, 1.6, 1.7 and 8.0 and Thirty Bees.

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 adds a link to your Prestools installation in the Catalog menu of 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!