Jump to content

[Free script] Prestools Suite: mass edit, cleanup, integrity checks and much more


Recommended Posts

1 minute ago, musicmaster said:

 

What Prestools version do you have? It works only with the last two releases.

Prestools version 1.24m. Release date: 20-feb-2020.

Share this post


Link to post
Share on other sites
  • Replies 2.2k
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

This is not a module but a script/program. Follow the installation instructions! Prestools Suite is a suite of user-friendly and powerful tools to mass edit your products, orders and categories.

Just wanted to say, once again, thankyou. I was messing around the other day with groups and thought I would create one while trying to do discounts etc. When I logged in to my shop as a cus

Hi, sorry for late answer - do not have much time today. I have product-proc.php in my directory. I uploaded your last file product-edit6 and now is working excellent!!!! Thank You very much for

Posted Images

There are still two problems that I hope to repair with a new version tomorrow. Maybe you experience them:

 - you cannot add an image to a product that doesn't have images.

 - in some circumstances you can end with a product where none of the images are marked as "cover". The result is that you won't see an image in the backoffice products list.

Edited by musicmaster (see edit history)

Share this post


Link to post
Share on other sites

I uploaded a new Prestools version: 1.24n. It contains a new version of the image plugin too. 

The new version fixes a few issues with image edit:

 - you could not add an image to a product that didn't have any images.

 - when you marked a newly added image as cover it wasn't registered as such. As a consequence the product ended with no cover and you didn't see an image in the backoffice product list.

 - when you made the image field editable and the cover image was not the first one it displayed on the first position the cover image too.

The editing is now more wysiwig as it makes  that you to always have an active cover product.

If you find any more problems please let me know.

Edited by musicmaster (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites

Hello,


Im getting this error with latest and previous version of module also... trying to change category name 😕

 

 

2246 Records - of which 1 submitted.
*****4: 
Notice: Undefined index: id_shop in ....../myprestools/cat-proc.php on line 101

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
Generated by URL '...../myprestools/cat-proc.php'
with Query 'UPDATE ps_product_shop set indexed=0 WHERE id_category_default='5132' AND id_shop='

Share this post


Link to post
Share on other sites
  • 2 weeks later...

Hello, I have been using this script for a long time, no problems whatsoever, but recently I tried to use the Image Cleanup and it gives me an error:

MySQL error 1146: Table 'delikate_prest58.psm9_PRESTOOLS_imgspace' doesn't exist
Generated by URL '/deladmin/d_mass/diskspace.php'
with Query 'SHOW COLUMNS FROM psm9_PRESTOOLS_imgspace WHERE field="path"'

Any idea what the problem is? I'm using prestools 1.24q with Prestashop version 1.6.1.23

Thank you for your hard work.

Cléon Adónis Santos

Share this post


Link to post
Share on other sites
21 hours ago, cleon said:

Hello, I have been using this script for a long time, no problems whatsoever, but recently I tried to use the Image Cleanup and it gives me an error:

MySQL error 1146: Table 'delikate_prest58.psm9_PRESTOOLS_imgspace' doesn't exist
Generated by URL '/deladmin/d_mass/diskspace.php'
with Query 'SHOW COLUMNS FROM psm9_PRESTOOLS_imgspace WHERE field="path"'

Any idea what the problem is? I'm using prestools 1.24q with Prestashop version 1.6.1.23

Thank you for your hard work.

Cléon Adónis Santos

Hi Cléon,

Can you try the attached file?

Regards,

M

diskspace.php

Share this post


Link to post
Share on other sites
1 hour ago, cleon said:

Hello,

Just replaced the file "diskspace.php" and the got the same error.

Thank you.

Very strange. The new version puts a check for the imgspace table before the line that produces the error. So this shouldn't happen.

Share this post


Link to post
Share on other sites
22 minutes ago, musicmaster said:

Very strange. The new version puts a check for the imgspace table before the line that produces the error. So this shouldn't happen.

Could the query be case sensitive? I've noticed that my table is "psm9_prestools_imgspace" and the error returns "psm9_PRESTOOLS_imgspace"?

I've double checked the file and the server has the new one:

806102798_Annotation2020-03-29170151.png.09c69103b9aab6cf8706c3c53288c521.png

564799457_Annotation2020-03-29170152.png.6a9fdadd14aa8d83d443e577d5d5972b.png

Share this post


Link to post
Share on other sites

Can you test for the case sensitive option?

In settings1.php there is a line

define('_PRESTOOLS_PREFIX_', 'PRESTOOLS_');

Could you change that to

define('_PRESTOOLS_PREFIX_', prestools_');

Share this post


Link to post
Share on other sites
On 3/29/2020 at 6:12 PM, cleon said:

Just some thoughts, could it be the prefix of the DB/table?

delikate_prest58.psm9_PRESTOOLS_imgspace' - VS - psm9_PRESTOOLS_imgspace? Thank you.

A pity that you didn't react to my previous post. I suspect the problem is one of those MariaDb-MySql differences but I cannot be sure without your feedback.

Share this post


Link to post
Share on other sites
On 3/29/2020 at 5:20 PM, musicmaster said:

Can you test for the case sensitive option?

In settings1.php there is a line

define('_PRESTOOLS_PREFIX_', 'PRESTOOLS_');

Could you change that to

define('_PRESTOOLS_PREFIX_', prestools_');

Sorry for my delay, busy days.

I've tried that with no results also. But I did try to change the name in the DB, and apparently it worked. It doesn't give any error as previous, it just stands there, until it appears this message:
 

504 Gateway Time-out

nginx

Haven't test it more, but I will do it later. Is this normal? Should I keep clicking until it list the images?

Thank you

Cléon

Share this post


Link to post
Share on other sites

When I click "Gather unused product images" there's no error, and after some time it gives me that message. I know that this timeout is related to the server, and I can give a higher value.

Since there's no DB error as previous, can I assume that the problem is solved? I have around 20GB of images, what happens when it times out? What message or error should I expect before clicking again?

Thank you.

image.thumb.png.6ca34f2cd1dee7a501d52e8262678de4.png

image.png

Share this post


Link to post
Share on other sites

 

24 minutes ago, cleon said:

When I click "Gather unused product images" there's no error, and after some time it gives me that message. I know that this timeout is related to the server, and I can give a higher value.

Since there's no DB error as previous, can I assume that the problem is solved? I have around 20GB of images, what happens when it times out? What message or error should I expect before clicking again?

Gathering unused images is a time-consuming process. Prestools crawls the harddisk and then checks for every image  that it finds that it is also present in the database.

In your case that is a problem. You have lots of images and your server doesn't like task taking too long.

I am still not sure what the problem was that gave your prior error. So I can't say anything about that. I am glad it is solved. But from the technical point of view the question is still open.

It looks like Nginx is just cutting off the server. Not very nice but the database should be able to handle it. And Prestools uses its own tables so I consider it very unlikely that anything would be damaged. The main problem is that Prestools isn't built to handle this kind of situations. So the next time you start to gather you start again from image one and you are unlikely ever to reach the last image unless you change the timeout in the server settings.

 

 

Share this post


Link to post
Share on other sites

Hello, I tried to use copy_shopdata  script to transfer data from one shop to another, but after running the script I get an error:

oldconn = <old db host>.<dbuser> = 67917811
new conn = <new db host>.<dbuser> = 67917809
1 old languages: sk (1); 1 new languages: sk (1); Language check ok.
 

No language transformations needed.Initialization skipped because it had already run
Copying tables

1 accessory 724

MySQL error 1045: Access denied for user '<old db user>'@'%' (using password: YES)
Generated by URL '/adminXX/ptools/copy_shopdata.php'
with Query 'SELECT `id_product_1`,`id_product_2` INTO OUTFILE '/home/html/XXXXX/public_html/adminXX/ptools/copy_shopdata_accessory.dtx' FROM `shplive_accessory`'

 

What access is denied? Ptools tool works for me without any problems. Thanks.

Share this post


Link to post
Share on other sites
9 minutes ago, Juraj said:

Hello, I tried to use copy_shopdata  script to transfer data from one shop to another, but after running the script I get an error:

oldconn = <old db host>.<dbuser> = 67917811
new conn = <new db host>.<dbuser> = 67917809
1 old languages: sk (1); 1 new languages: sk (1); Language check ok.
 

No language transformations needed.Initialization skipped because it had already run
Copying tables

1 accessory 724

MySQL error 1045: Access denied for user '<old db user>'@'%' (using password: YES)
Generated by URL '/adminXX/ptools/copy_shopdata.php'
with Query 'SELECT `id_product_1`,`id_product_2` INTO OUTFILE '/home/html/XXXXX/public_html/adminXX/ptools/copy_shopdata_accessory.dtx' FROM `shplive_accessory`'

 

What access is denied? Ptools tool works for me without any problems. Thanks.

This is about the shop from which you copy the data and for which you entered the credentials in copy_shopdata_config.php. So check those credentials.

Share this post


Link to post
Share on other sites

Hello, I have just downloaded the latest version of the script. I want to set the low stock alerst to all products. Curently I have 0 value.

obraz.png.d16e80630ae6394636194334399e6455.png

When I select Edit on LowStockAlrt column the values change to tick box

obraz.png.5c804ddf48139c9c816b5e63e9977760.png

When I set value 1 on LowStockAlrt on Mass update field the PresTools script refresh the page and shows me the default view. No changes are made.

obraz.png.4c9da83208e5b9f203c947892203dd7b.png

 

Is there a way to set "1" value in that column in mass update mode? Updating values manually is possible but I have a lot of products.

Share this post


Link to post
Share on other sites
15 hours ago, banan_44 said:

Hello, I have just downloaded the latest version of the script. I want to set the low stock alerst to all products. Curently I have 0 value.

obraz.png.d16e80630ae6394636194334399e6455.png

When I select Edit on LowStockAlrt column the values change to tick box

obraz.png.5c804ddf48139c9c816b5e63e9977760.png

When I set value 1 on LowStockAlrt on Mass update field the PresTools script refresh the page and shows me the default view. No changes are made.

obraz.png.4c9da83208e5b9f203c947892203dd7b.png

 

Is there a way to set "1" value in that column in mass update mode? Updating values manually is possible but I have a lot of products.

Thank you for your error report.

Can you try the attached file? It should renamed product-edit6.js and replace the existing file.

 

product-edit6.txt

  • Like 1

Share this post


Link to post
Share on other sites

@musicmaster, thanks for fast reply. I copy copied the content of your TXT file a replaced the content of product-edit6.js on my server. I confirm the problem is solved. I was able to tick all checkboxes. Mass update was successful.

  • Like 1

Share this post


Link to post
Share on other sites
On 4/2/2020 at 8:33 PM, musicmaster said:

I am still not sure what the problem was that gave your prior error. So I can't say anything about that. I am glad it is solved. But from the technical point of view the question is still open.

Hello,

I'm back again and I have some time to test and try to solve the problem. I have undo my previous step, where I have manually changed the name of the table from lower case to upper case (apart from the timeout, it didn't do nothing). I'm using your file diskspace.php.

Doing that, I notice that the error is different. Initially it was error 1146, now it's 1064:

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'psm9_PRESTOOLS_imgspace' at line 1
Generated by URL '/deladmin/d_mass/diskspace.php'
with Query 'show tables like psm9_PRESTOOLS_imgspace'

what else do you need from me? thank you.

Share this post


Link to post
Share on other sites

@musicmaster I increased the max_execution_time and apparently it worked, but didn't finish (probably because of the large number of images I have). But what I have noticed is that when I press the gather unused product images, the PRESTOOLS_imgspace table, starts to increase and goes up to 200.000 rows, but no matter I select Restart collection or not, it always restart the process from 0. Shouldn't it continues from the last row? Thank you.

Share this post


Link to post
Share on other sites
16 hours ago, cleon said:

@musicmaster I increased the max_execution_time and apparently it worked, but didn't finish (probably because of the large number of images I have). But what I have noticed is that when I press the gather unused product images, the PRESTOOLS_imgspace table, starts to increase and goes up to 200.000 rows, but no matter I select Restart collection or not, it always restart the process from 0. Shouldn't it continues from the last row? Thank you.

It was probably my fault (more than one click). I just bought the "delete images" plugin and it looks that is working ok.

Thank you for your support!

Share this post


Link to post
Share on other sites
7 hours ago, cleon said:

It was probably my fault (more than one click). I just bought the "delete images" plugin and it looks that is working ok.

Thank you for your support!

Actually you may have had a point. To look for where it ended last time the system now looks for the highest id_image. But the script is spidering the disk in a different way. After it starts with the "1" it goes into its tree: "11", "123", etc. Only when it has completed this tree it goes to the "2" and its tree. But if it stopped after handling "55" "123" might still be the highest number. So it would do all of "2", "3", "4" and "5" again.

Share this post


Link to post
Share on other sites
On 4/6/2020 at 6:39 PM, cleon said:

@musicmaster I increased the max_execution_time and apparently it worked, but didn't finish (probably because of the large number of images I have). But what I have noticed is that when I press the gather unused product images, the PRESTOOLS_imgspace table, starts to increase and goes up to 200.000 rows, but no matter I select Restart collection or not, it always restart the process from 0. Shouldn't it continues from the last row? Thank you.

Fixed in version 1.24s.

Share this post


Link to post
Share on other sites

Just wanted to say, once again, thankyou.

I was messing around the other day with groups and thought I would create one while trying to do discounts etc.

When I logged in to my shop as a customer, I realised it showed no products.  I started investigating and found that I needed to set all the categories to accept the new group.

I did a little search and all sorts of scripts and sql as they is no natural way to assign all categories to groups.  I didn't want to edit 300 + categories manually, or play with sql.

Then it dawned on me that Prestools MIGHT handle this, so I did a little delving and it it does.

Around 30 seconds later 300 categories had the new group added.

Just now I discovered that I needed to stop visibility on around 30 products.  Bish bash bosh, done in 10 seconds.

It's the best money I have ever spent in relation to Prestashop.!!

  • Like 2

Share this post


Link to post
Share on other sites

Version 1.26 offers multi-language editing.

If you have more than one language you will see all other languages than the selected languages on the third row as extra languages that you can select:

extra1.jpg.d08478ab5479c9d6840af3ee00aa4a92.jpg

If you do so all language sensitive fields will appear in versions for all the selected languages. The main language will be have its usual names. For the others names will have a suffix with the isocode of the language:

extra2.jpg.b7043755bf5267dc9756f9729e97fab2.jpg

Share this post


Link to post
Share on other sites
  • 2 weeks later...

Hi, I have been using prestools without problem until today I got this error;

No access allowed for IP addresses: Array ([0] => 'my IP')
You may not use this script from IP Adress: 'my IP'

What could have happened?
Is there a way to fix it?

Thanks!

Share this post


Link to post
Share on other sites
15 minutes ago, oncle said:

Hi, I have been using prestools without problem until today I got this error;

No access allowed for IP addresses: Array ([0] => 'my IP')
You may not use this script from IP Adress: 'my IP'

What could have happened?
Is there a way to fix it?

Thanks!

Is your ip address still correct? Some providers occasionally change it - for example when your router reboots.

You can always make the ip array empty and the remove the filter. But it should work.

 

  • Like 1

Share this post


Link to post
Share on other sites

Perfect musicmaster, the IP had been modified. I have changed it in settings1.php and it already works.
Thanks for the quick reply.

Share this post


Link to post
Share on other sites

Hey, 

I have the newest one prestools, and prestashop 1.7.6.4 . When I export to CSV I have in ID column something like:

 

<br />
<b>Notice</b>:  Undefined offset: 1358 in <b>/home/.............../prestools/product-csv.php</b> on line <b>795</b><br />
<br />
<b>Notice</b>:  Undefined offset: 0 in <b>/home/.............../prestools/product-csv.php</b> on line <b>800</b><br />

 

Something simmilar is in category column, how to fix this ? 

 

Thanks

Edited by conderus (see edit history)

Share this post


Link to post
Share on other sites

I have no idea what this is. I cannot reproduce it in a fresh PS installation.

So my guess would be that there is something unusual in the database that causes this. To determine what I would need to have access.

If you want to look yourself, here is something to look for:

 - in line 800 it sees a value 0 for id_category in the ps_category_product table. There is no category with such an id. So that would be a faulty value in the database.

 - similarly it sees an id_category of 1358 in the error on line 795. You should check whether there is a category with such an id.

Share this post


Link to post
Share on other sites

The image mass edit module has now all the planned functions and is for sale in the Prestools webshop. 

In the final version legend and image editing have been integrated. So there are no longer three options for editing images.

In the free part image regeneration and preprocessing have been improved. Png's are now supported. And with preprocessing you can define a target size. Note that in the process two options have been added to the settings file.

Share this post


Link to post
Share on other sites

I have latest version 1.27 and it is not possible to mass update Low stock alert and Low stock threshold on Product Combis page.

The mass update action does not change the values on combinations - there seems to be different input field name (low_stock_threshold and low_stock_alert) in Mass update field selector to the field name in combination items (ls_threshold and ls_alert).
Can you please fix it? Thanks :)

Share this post


Link to post
Share on other sites
On 8/4/2020 at 3:21 PM, Juraj said:

I have latest version 1.27 and it is not possible to mass update Low stock alert and Low stock threshold on Product Combis page.

The mass update action does not change the values on combinations - there seems to be different input field name (low_stock_threshold and low_stock_alert) in Mass update field selector to the field name in combination items (ls_threshold and ls_alert).
Can you please fix it? Thanks :)

Thank you for your error report.

I have now standardized the naming on ls_threshold and ls_alert - also in product-edit. The new version is 1,27a.

It will mean that everyone who now updates needs to use the new settings1.php as the old one will give errors. So while it is normally possible to keep your settings1.php file that is now not an option.

Edited by musicmaster (see edit history)

Share this post


Link to post
Share on other sites

I got the following error:  Notice: Trying to access array offset on value of type null in /home/airgunpl/public_html/panel/Prestool/functions1.php on line 9

Prestashop version: 1.7.6.0. Prestools version 1.24t.  I don't see an option to update PresTools. Is there such a functionality or should I reinstall it?
I cannot edit the category and activity of an item.

Edited by Panzerkampf (see edit history)

Share this post


Link to post
Share on other sites
16 minutes ago, Panzerkampf said:

I got the following error:  Notice: Trying to access array offset on value of type null in /home/airgunpl/public_html/panel/Prestool/functions1.php on line 9

Prestashop version: 1.7.6.0. Prestools version 1.24t.  I don't see an option to update PresTools. Is there such a functionality or should I reinstall it?

This is a strange type of error that I never heard of before. Your Prestools is several months old. Did it give this error from the beginning or is it a recent problem>

The error tells that some Prestashop configuration flag is missing. Nothing serious. Anyway, I have uploaded a new version that might fix the message.

You should reinstall Prestools. You don't need to update the mini-module for the backoffice if you use that.

 

  • Like 1

Share this post


Link to post
Share on other sites
6 minutes ago, musicmaster said:

Did it give this error from the beginning or is it a recent problem

Honestly don't know, until everything works, I didn't pay attention to the top of the screen. Today (01/09) my hosting updated PHP to 7.4. Could this have had an impact?
Thank you very much for your quick reply :) 

Share this post


Link to post
Share on other sites
22 minutes ago, Panzerkampf said:

Honestly don't know, until everything works, I didn't pay attention to the top of the screen. Today (01/09) my hosting updated PHP to 7.4. Could this have had an impact?
Thank you very much for your quick reply :) 

It could be PHP 7.4. The newer versions have stricter error control, so they catch more.

Share this post


Link to post
Share on other sites

After installing the latest version, the following information appears:

Notice: Undefined index: LowStockNr in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

Notice: Trying to access array offset on value of type null in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

Notice: Trying to access array offset on value of type null in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

Notice: Undefined index: LowStockAlrt in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

Notice: Trying to access array offset on value of type null in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

Notice: Trying to access array offset on value of type null in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

Edited by Panzerkampf (see edit history)

Share this post


Link to post
Share on other sites
1 hour ago, Panzerkampf said:

After installing the latest version, the following information appears:

Notice: Undefined index: LowStockNr in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

Notice: Trying to access array offset on value of type null in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

Notice: Trying to access array offset on value of type null in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

Notice: Undefined index: LowStockAlrt in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

Notice: Trying to access array offset on value of type null in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

Notice: Trying to access array offset on value of type null in /home/airgunpl/public_html/panel/Prestool/product-edit.php on line 1171

It looks like you are using the old settings1.php file. The low stock field names have been changed and for that reason you need to use the new one.

Share this post


Link to post
Share on other sites

Aftera clean  installation, I first tried order-edit.php and ran into some issues.

I can modify all values at the thop of the page but not in the items. When I decrease a quantity or delete an item, the "Success" page pops up but nothing changes. When I increase a quantity, I receive the following error:

MySQL error 1054: Unknown column 'reserved_quantity' in 'field list'
Generated by URL '/admin162123123/prestools/order-proc.php'
with Query 'upDATE ps_product_attribute set quantity=quantity+0,reserved_quantity=reserved_quantity-0 where id_product_attribute=409'

 

All orders are marked unpaid and I am able to edit them in the PS backend if that makes any difference.

 

Prestashop version: 1.7.6.7. Prestools version 1.27b. Release date: 10-aug-2020. PHP version 7.2.33 and MySQL version 5.7.31

Edited by Dp. (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites
3 hours ago, Dp. said:

Aftera clean  installation, I first tried order-edit.php and ran into some issues.

I can modify all values at the thop of the page but not in the items. When I decrease a quantity or delete an item, the "Success" page pops up but nothing changes. When I increase a quantity, I receive the following error:


MySQL error 1054: Unknown column 'reserved_quantity' in 'field list'
Generated by URL '/admin162123123/prestools/order-proc.php'
with Query 'upDATE ps_product_attribute set quantity=quantity+0,reserved_quantity=reserved_quantity-0 where id_product_attribute=409'

 

All orders are marked unpaid and I am able to edit them in the PS backend if that makes any difference.

 

Prestashop version: 1.7.6.7. Prestools version 1.27b. Release date: 10-aug-2020. PHP version 7.2.33 and MySQL version 5.7.31

Thank you for reporting this bug - that only happened for products with attributes. I have uploaded a new version that should fix the problem.

Please let me know if you find any more problems.

Share this post


Link to post
Share on other sites

Cheers, works like a charm now!

In shop-rescue.php below the intro text I only see this:

MySQL error 1054: Unknown column 'themename' in 'field list'
Generated by URL '/admin162paqlzl/prestools/shop-rescue.php'
with Query 'SELECT themename AS name FROM ps_shop WHERE id_shop=1'

 

I checked and in my ps_shop the column is called theme_name.

  • Like 1

Share this post


Link to post
Share on other sites
9 hours ago, Dp. said:

Cheers, works like a charm now!

In shop-rescue.php below the intro text I only see this:


MySQL error 1054: Unknown column 'themename' in 'field list'
Generated by URL '/admin162paqlzl/prestools/shop-rescue.php'
with Query 'SELECT themename AS name FROM ps_shop WHERE id_shop=1'

 

I checked and in my ps_shop the column is called theme_name.

Thank you. I fixed the theme_name too now.

Share this post


Link to post
Share on other sites

Thanky, sorry for keeping you busy 🤣

 

image-regenerate.php returns for one specific product ID: 

Fatal error: Uncaught ImagickException: insufficient image data in file `/homepages/u71277/shop-live/img/p/5/2/6/526.jpg' @ error/jpeg.c/ReadJPEGImage/1039 in /homepages/u71277/shop-live/admin162123123/prestools/image-regenerate-proc.php:327 Stack trace: #0 /homepages/u71277/shop-live/admin162123123/prestools/image-regenerate-proc.php(327): Imagick->__construct('/homepages/u712...') #1 /homepages/u712770/shop-live/admin162123123/prestools/image-regenerate-proc.php(312): regenerate_image_imagick('526', '526.jpg', '../../img/p/5/2...') #2 /homepages/u71277/shop-live/admin162123123/prestools/image-regenerate-proc.php(200): regenerate_image('526') #3 {main} thrown in /homepages/u71277/shop-live/admin162123123/prestools/image-regenerate-proc.php on line 327

Is this an isue on my end?

Share this post


Link to post
Share on other sites

Prestools keeps being updated. Most are small improvements and bug fixes. But new functions are added too.

Recently the accent has been on maintenance functions. The cleanup page has been expanded and offers now 14 options. The Shop Rescue and Integrity Checks pages have been somewhat expanded too.

TinyMCE has been updated to version 4. This shouldn't change the functionality. Please report if you find any problem.

Edited by musicmaster (see edit history)

Share this post


Link to post
Share on other sites
  • 2 weeks later...

Below you will find version 1.28. It got some serious changes in product-edit and I would like to receive feedback on them.

The main changes are:

 - there are now three instead of two text fields

 - a lot of id fields have been added, including one for each of the features and attributes.

 - you are allowed to enter more than one value in the id fields. They should be comma separated. This is only possible when the comparison field is "in" or "!in".

 

Edited by musicmaster (see edit history)

Share this post


Link to post
Share on other sites

Hi Thank you for this great tool. I have a problem - when I use TinyMce Deluxe editor -> Submit all -> then I get error 403 forbidden  (You don't have permission to access this resource. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.)

When I use standard text editor or TinyMce it allows me to save changes. All files in the prestatool I have with 755 permissions. Any ideas why only TinyMce deluxe is not working? 

Share this post


Link to post
Share on other sites
24 minutes ago, mgrzadka said:

Hi Thank you for this great tool. I have a problem - when I use TinyMce Deluxe editor -> Submit all -> then I get error 403 forbidden  (You don't have permission to access this resource. Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.)

When I use standard text editor or TinyMce it allows me to save changes. All files in the prestatool I have with 755 permissions. Any ideas why only TinyMce deluxe is not working? 

Prestools recently updated its TinyMce version from 4.9.6 to 4.9.11.  You can see the version number on the first line of tinymce.min.js. Can you look which version you are using?

Share this post


Link to post
Share on other sites
1 minute ago, mgrzadka said:

Looks like Iam using the latest version

image.png.2e9a0ff9db16c2ecb56fb00965ae741f.png

But before my Prestool update when I was submitting my changes it shows me "Page not found".

When exactly did you get "page not found"?

Share this post


Link to post
Share on other sites
1 hour ago, mgrzadka said:

When I used TinyMCE-Deluxe -> write something in the box (usually product description) -> submit all -> error eariel "page not found" now "403 Forbidden"

I am not sure whether the attached file will help. But at least it will improve performance. Can you try it? You need to rename it to .js.

One possible explanation for 403 errors is client side problems like add blockers and firewalls. So if the problems remain you might do some experiments in that area like another browser.

Don't forget to make sure that you load the new javascript file (ctrl-F5 under Windows) so that it replaces the one in the cache.

product-edit6.txt

Edited by musicmaster (see edit history)

Share this post


Link to post
Share on other sites

Now it looks like the speed up a bit but when I click "Submit all" I am redirected to page MYPAGE/product-proc.php?c=100&d=1 - and get error message: This page doesn't seem to exist.

Share this post


Link to post
Share on other sites
7 hours ago, mgrzadka said:

Now it looks like the speed up a bit but when I click "Submit all" I am redirected to page MYPAGE/product-proc.php?c=100&d=1 - and get error message: This page doesn't seem to exist.

product-proc.php doesn't exist in your Prestools directory?

Share this post


Link to post
Share on other sites
15 hours ago, mgrzadka said:

Now it looks like the speed up a bit but when I click "Submit all" I am redirected to page MYPAGE/product-proc.php?c=100&d=1 - and get error message: This page doesn't seem to exist.

I made some further optimizations.

The main problem is now likely in product-proc that takes too long. As the main time consumer there is indexation you could try to skip indexation by checking that option. I will look whether some optimizations there are possible.

product-edit6.txt

  • Thanks 1

Share this post


Link to post
Share on other sites
16 hours ago, musicmaster said:

product-proc.php doesn't exist in your Prestools directory?

Hi, sorry for late answer - do not have much time today. I have product-proc.php in my directory.

I uploaded your last file product-edit6 and now is working excellent!!!! Thank You very much for your assistance! 

  • Like 1

Share this post


Link to post
Share on other sites

Hello dear musicmaster, I am in search of a module (free or paid) or a script that could mass update a PrestaShop 1.7.5.1 (30k products) in just 2 fields: "description" and ""description_short" for all my product at once. as an example I would like to add such a text in my description field: Dear reader, for today we offer you to read the book entitled <<Product title>> written by the famous author <<Product Manufacturer>> at the <<Characteristic IDX1X>> publishing house , with a symbolic price of only <<Product Price>> , a book published in <<Characteristic IDX2X>> in <<Characteristic IDX3X>> with a total number of <<Characteristic IDX4X>> of pages, the condition of the book is antique, <<Characteristic IDX5X>> .<<Website Name>> invites you to place an order and wishes you good health in these challenging times.

Thank you in advance for your time, please let me know if your product can do such a mass update.

Here is an example of the website where I populated manually the description field, all the other products are blank

https://anticariatalbert.com/critica-teorie-literara/29674-continut-si-forma-in-arta.html

yours,

Marius

Share this post


Link to post
Share on other sites
20 hours ago, cogeanumarius said:

Hello dear musicmaster, I am in search of a module (free or paid) or a script that could mass update a PrestaShop 1.7.5.1 (30k products) in just 2 fields: "description" and ""description_short" for all my product at once. as an example I would like to add such a text in my description field: Dear reader, for today we offer you to read the book entitled <<Product title>> written by the famous author <<Product Manufacturer>> at the <<Characteristic IDX1X>> publishing house , with a symbolic price of only <<Product Price>> , a book published in <<Characteristic IDX2X>> in <<Characteristic IDX3X>> with a total number of <<Characteristic IDX4X>> of pages, the condition of the book is antique, <<Characteristic IDX5X>> .<<Website Name>> invites you to place an order and wishes you good health in these challenging times.

Thank you in advance for your time, please let me know if your product can do such a mass update.

Here is an example of the website where I populated manually the description field, all the other products are blank

https://anticariatalbert.com/critica-teorie-literara/29674-continut-si-forma-in-arta.html

yours,

Marius

It wouldn't be difficult to accomplish this with product-edit with the mass-edit options "insert before" and "copy from field". However, 30k at once very likely won't work. It is just too much and will likely cause some type of timeout. But the same applies if you write a custom script.

Share this post


Link to post
Share on other sites

Hi musicmaster,

I have been using the suite for many years without problems and with great satisfaction, but today I have a problem: I need to make a simple change to the names and descriptions of products in all the languages in the database, but it only works for three languages (1- English, 5-Italian and 6-German), but does NOT work for 15-Spanish and 16-French.

Simply when I click on "submit" nothing happens (it does not take the change and remains blocked on the edit page), or it returns to the main product edit page, without having made the changes. This is only for languages with id 15 and 16, while it works normally for the other languages (1, 5 and 6).

I did not find anything strange in the database and anyway prestools finds all recors correctly. It just doesn't change the fields.

Can you help me understand?

Thank you.

Good day.

--

Alessandro

 

 

Share this post


Link to post
Share on other sites
20 minutes ago, SandroR1 said:

Hi musicmaster,

I have been using the suite for many years without problems and with great satisfaction, but today I have a problem: I need to make a simple change to the names and descriptions of products in all the languages in the database, but it only works for three languages (1- English, 5-Italian and 6-German), but does NOT work for 15-Spanish and 16-French.

Simply when I click on "submit" nothing happens (it does not take the change and remains blocked on the edit page), or it returns to the main product edit page, without having made the changes. This is only for languages with id 15 and 16, while it works normally for the other languages (1, 5 and 6).

I did not find anything strange in the database and anyway prestools finds all recors correctly. It just doesn't change the fields.

Can you help me understand?

Thank you.

Good day.

--

Alessandro

 

 

hi Alessandro,

My first guess would be that maybe some javascript error is happening. Returning to the main page signals that too.

French and Spanish have accents so I would expect that to be the source of trouble.

Is it possible for you to give me access so that I can have a look myself? Otherwise: can you give more details?

M

Edited by musicmaster (see edit history)

Share this post


Link to post
Share on other sites
9 minutes ago, musicmaster said:

hi Alessandro,

My first guess would be that maybe some javascript error is happening. Returning to the main page signals that too.

French and Spanish have accents so I would expect that to be the source of trouble.

Is it possible for you to give me access so that I can have a look myself? Otherwise: can you give more details?

M

 

I send You a message in pm.

Thank you.

--

Alessandro

Share this post


Link to post
Share on other sites

Hello, 

2 questions about Prestools and working with attributes and features. I just updated to Septembre free version.

Can you create attributes with Prestools?

Can you create features with the paid feature plugin?

I did just buy the Features plugin to test it.

OR do I have to do this in the backoffice and only manipulate them with Prestools?

Thanks for the software, I ahve been using it for a month and works great.

Randy

Edited by RhinoRudi
Add info to message (see edit history)

Share this post


Link to post
Share on other sites

Hello RhinoRudi,

Unlike software like Store Commander Prestools doesn't aim to offer a complete alternative interface. Instead the focus is on added value, offering functionality that is not available in Prestashop and making the life of a webshop owner easier.

It is hard to improve on the creation of features or attributes itself. The process is straightforward and the number of them in almost any webshop is low.

So to answer your question:

 - you cannot create features in Prestools. However, you can (mass)assign them to products and you can get an overview of which products have a feature.

 - you cannot create attributes in Prestools. And the only way to assign them and create combinations is by copying them from another product with combi-copy. And you can get an overview of which products have an attribute.

Share this post


Link to post
Share on other sites
3 hours ago, musicmaster said:

 - you cannot create features in Prestools. However, you can (mass)assign them to products and you can get an overview of which products have a feature.

 - you cannot create attributes in Prestools. And the only way to assign them and create combinations is by copying them from another product with combi-copy. And you can get an overview of which products have an attribute.

Hello Musicmaster,

Thanks and your "software" works great when I have used it to bul ecit category products in bulk. 

The attribute import worked great last night as long as I create the attribute name before. 

Features are low but I have a few that help with a faceted search. 

New question, is there a way in the download to see a version? I see it at the bottom in the disclaimer. Just curious as I had t version in my files and one was from 3 Aug, one from 20 Sept and then the new one yesterday from 28 Oct. I usually update settings with Un & PW before FTPing new version. Just curious if there is an easy way to know about updates.

I appreciate your work this tools saves lots of time, bedankt en tot zeins.

Randy

 

Share this post


Link to post
Share on other sites

 

1 hour ago, RhinoRudi said:

New question, is there a way in the download to see a version? I see it at the bottom in the disclaimer. Just curious as I had t version in my files and one was from 3 Aug, one from 20 Sept and then the new one yesterday from 28 Oct. I usually update settings with Un & PW before FTPing new version. Just curious if there is an easy way to know about updates

There is an update about once every two weeks. The average user updates less than once a year. So I don't see much need for noise about updates.

Edited by musicmaster (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites
  • 3 weeks later...
On 9/3/2012 at 9:52 AM, musicmaster said:

Hello there musicmaster.

I've been testing prestatools demo, it's a very useful tool, thank you for your effort.

Right now I'm searching for a solution to change order status, I need to change several orders status everyday and I was wondering if there is a way to do that massively using a list or something.

If this tool can do that it would save my time big time.

 

Share this post


Link to post
Share on other sites
1 hour ago, NoslenZuir said:

Hello there musicmaster.

I've been testing prestatools demo, it's a very useful tool, thank you for your effort.

Right now I'm searching for a solution to change order status, I need to change several orders status everyday and I was wondering if there is a way to do that massively using a list or something.

If this tool can do that it would save my time big time.

Sorry, but that is not possible with Prestools.

Share this post


Link to post
Share on other sites

Hi,

I have a little problem with setting the price. I have multistore on my Prestashop. All shops use the same currency but one shop have different prices of all items. I want to make the same price in all shops. I have chosen a shop with correct prices from the list, then I have edited the Price VAT column for all items but I left the original prices. Then I have selected an option to apply these changes (prices to all shops). I think this should set the same price visible in the Price VAT column to all shop. I my case the price stays the same in all shops. I also tried with the Price column. The same situation. Am I doing something wrong? I do the same procedure in order to change the quantity of the items in all shop and this functionality works with no problem. The quantity changes in all shops. I have Prestashop version: 1.7.6.8. Prestools version 1.28h

obraz.png.ff44104b5d74b367d8206545533397c8.png

 

 

Share this post


Link to post
Share on other sites

If I could jump in.

You always have to click EDIT on the item you are wanting to change.

So if you click edit on "Price" this will then allow you to change the price.

Hope that helps.  

Always try with one or two items before change vast quantities B-)

Just rereading your question, so not sure if I have misunderstood.

 

Edited by Maldon Jewellery (see edit history)

Share this post


Link to post
Share on other sites
4 minutes ago, Maldon Jewellery said:

If I could jump in.

You always have to click EDIT on the item you are wanting to change.

So if you click edit on "Price" this will then allow you to change the price.

Hope that helps.  

Always try with one or two items before change vast quantities B-)

Just rereading your question, so not sure if I have misunderstood.

 

Hi, thank you for your reply. Please, take a look at the screenshot I have attached to my post. You can notice that PriceVAT column is in Edit mode and the yellow background means I have activated this option to all shops. After clicking on Submit All button the price in white input field (608,44) should be set in all shops. Unfortunately, it does not change anywhere.

Share this post


Link to post
Share on other sites