musicmaster 677 Posted November 19, 2017 Posted November 19, 2017 (edited) On 19-11-2017 at 4:55 PM, gorkij77 said: up pops a window saying "Not name found"? Yes, the name field should also have been selected. It uses the name field to derive the link from. Edited November 22, 2017 by musicmaster (see edit history) Share this post Link to post Share on other sites
gorkij77 2 Posted November 19, 2017 Posted November 19, 2017 1 minute ago, musicmaster said: Yes, the name field should also have been selected. How else can it derive the link from it. Ah, thank you ever so much. My brain is a bit mushy from hunting similar solutions for other problems as well over the last two days. Wonderful bit of software, by the way! I'll be sure to add my monetary support in the foreseeable future! 2 Share this post Link to post Share on other sites
Szarlej 1 Posted November 22, 2017 Posted November 22, 2017 Just started using presta, I'm not sure if that's the proper thread for feedback, but just wanted to thank the author for an amazing toolset. Very helpful, great job. 1 Share this post Link to post Share on other sites
bluerose 0 Posted November 23, 2017 Posted November 23, 2017 (edited) hi. I've just installed this tools on a local copy of my website, it's all working fine but when I click radio button category to modify it nothing happens. On tutorial video I see that should appear a box that allows me to select the category, is it right? my prestashop version is 1.6.1.11 This error appears on console Uncaught ReferenceError: categoryblock0 is not defined at switchDisplay (product-edit3.js:463) at HTMLInputElement.onclick (product-edit.php?field=price&action=set&myvalue=10:174) Edited November 23, 2017 by bluerose (see edit history) Share this post Link to post Share on other sites
musicmaster 677 Posted November 23, 2017 Posted November 23, 2017 Hi Bluerose, Sorry to hear that you found some problems. Are these the only error messages that you have? Categoryblock0 is the list with all categories that is created in product-edit.php and inserted in each row when you click the edit radio-button. When this is not created something goes wrong in that creation process. My first guess would be that it is some special character in one of the category names that isn't handled correctly by my code. But to check that I need more information from you. Share this post Link to post Share on other sites
bluerose 0 Posted November 23, 2017 Posted November 23, 2017 3 hours ago, musicmaster said: Hi Bluerose, Sorry to hear that you found some problems. Are these the only error messages that you have? Categoryblock0 is the list with all categories that is created in product-edit.php and inserted in each row when you click the edit radio-button. When this is not created something goes wrong in that creation process. My first guess would be that it is some special character in one of the category names that isn't handled correctly by my code. But to check that I need more information from you. GREAT!!! This was the problem, some character caused this poblem. Have deleted all the characters but except letters, can you tell me which characters I can use in addition to letters? Share this post Link to post Share on other sites
musicmaster 677 Posted November 23, 2017 Posted November 23, 2017 1 hour ago, bluerose said: GREAT!!! This was the problem, some character caused this poblem. Have deleted all the characters but except letters, can you tell me which characters I can use in addition to letters? I was hoping that you could tell me that. Then I would have adapted the script so that they were handled correctly. The script should be able to handle all characters that Prestashop does. So if it doesn't with some that is a bug that should be fixed. Share this post Link to post Share on other sites
simberak 15 Posted November 27, 2017 Posted November 27, 2017 Hello, Can this module also re-sort attributes by name? Thank you Daniel Share this post Link to post Share on other sites
musicmaster 677 Posted November 27, 2017 Posted November 27, 2017 22 minutes ago, simberak said: Hello, Can this module also re-sort attributes by name? Thank you Daniel Hi Daniel, No, it cannot. Good idea for future development. Share this post Link to post Share on other sites
simberak 15 Posted November 27, 2017 Posted November 27, 2017 Hi music master, Thank you for the answer. That is a pitty. I am looking for this function because I have looot of attributes in group, for ex. 600 attributes in one group. A cant find another module for it. I font understand noobody other needed this already Share this post Link to post Share on other sites
musicmaster 677 Posted November 27, 2017 Posted November 27, 2017 You could use the function Attribute ex and import of Prestools. With exporting, doing some creative things in a spreadsheet and importing it back it should work. Share this post Link to post Share on other sites
Genocide 0 Posted November 27, 2017 Posted November 27, 2017 Hiya! I tryed to launch this script on PS 1.7.24 but it doesn't work. It stays in a blank page... any help? Share this post Link to post Share on other sites
musicmaster 677 Posted November 27, 2017 Posted November 27, 2017 8 minutes ago, Genocide said: Hiya! I tryed to launch this script on PS 1.7.24 but it doesn't work. It stays in a blank page... any help? Did you install it correctly. That is: NOT as a module? Share this post Link to post Share on other sites
saphire 0 Posted November 27, 2017 Posted November 27, 2017 Hello, I bought the scrip tag edit and I'm having a problem: Example: A store with 3 languages, when setting the tags of each product in the respective language, only the tags of 1 of them are active. The remaining tags are registered but not assigned to the products. Is it script error? Share this post Link to post Share on other sites
musicmaster 677 Posted November 27, 2017 Posted November 27, 2017 21 minutes ago, saphire said: Hello, I bought the scrip tag edit and I'm having a problem: Example: A store with 3 languages, when setting the tags of each product in the respective language, only the tags of 1 of them are active. The remaining tags are registered but not assigned to the products. Is it script error? I will have a look at it on Wednesday. It might help if you could further specify the problem. Share this post Link to post Share on other sites
smalto 1 Posted November 28, 2017 Posted November 28, 2017 Hello, Thank you for your scipt. I have uploaded the directory to admin and have logged in no problem. Everything works. My only problem is with the module to put a link in the BO. I upload the zip inside the script and the module manager says it has been uploeded well but I do not see the module in the module section of the BO and cannot put the directory in the settings. Did you ever have this problem and do you have any idea what to do to solve this. Thank you. Share this post Link to post Share on other sites
saphire 0 Posted November 28, 2017 Posted November 28, 2017 15 hours ago, musicmaster said: I will have a look at it on Wednesday. It might help if you could further specify the problem. Hi, thanks for your replay. Attach screen with the problem: 1 - Set tags to product in one language and they are ok. 2 - Set tags to same product in oher language and they are set but tags set to other language lost associations to product Whish it help to identificate problem. You have a greet tool. Thanks Share this post Link to post Share on other sites
musicmaster 677 Posted November 28, 2017 Posted November 28, 2017 (edited) On 28-11-2017 at 4:03 PM, saphire said: Hi, thanks for your replay. Attach screen with the problem: 1 - Set tags to product in one language and they are ok. 2 - Set tags to same product in oher language and they are set but tags set to other language lost associations to product Whish it help to identificate problem. You have a greet tool. Thanks Thank you for the feedback. I quickly made a fix that should solve the problem (I am rather busy with other things...) . You find it attached to this post (it will be removed afterwards). Can you test it? As, promised, I removed the link after one day. Unfortunately I didn't receive a reaction from you. If you still need it please let me know. Edited November 29, 2017 by musicmaster (see edit history) Share this post Link to post Share on other sites
metalsniper63 5 Posted November 29, 2017 Posted November 29, 2017 I thank you for this wonderful product. I just have one question. I have uploaded several products from a CVS file but without any image file. I want to see if i'm able to edit the field to put a link for the image. I cannot seem to get that done with this. How should i do it? Share this post Link to post Share on other sites
smalto 1 Posted November 29, 2017 Posted November 29, 2017 On 28/11/2017 at 3:19 PM, smalto said: Hello, Thank you for your scipt. I have uploaded the directory to admin and have logged in no problem. Everything works. My only problem is with the module to put a link in the BO. I upload the zip inside the script and the module manager says it has been uploeded well but I do not see the module in the module section of the BO and cannot put the directory in the settings. Did you ever have this problem and do you have any idea what to do to solve this. Thank you. Hello, sorry to re-write this but did not get any answer. Any clue on how to do to make it work. Thank you for your help. Share this post Link to post Share on other sites
musicmaster 677 Posted November 29, 2017 Posted November 29, 2017 2 hours ago, metalsniper63 said: I thank you for this wonderful product. I just have one question. I have uploaded several products from a CVS file but without any image file. I want to see if i'm able to edit the field to put a link for the image. I cannot seem to get that done with this. How should i do it? Sorry, No. Uploading pictures is not possible with Prestools at the moment. You can only edit the alt texts of images and assign images to product combinations. Share this post Link to post Share on other sites
musicmaster 677 Posted November 29, 2017 Posted November 29, 2017 2 hours ago, smalto said: Hello, sorry to re-write this but did not get any answer. Any clue on how to do to make it work. Thank you for your help. As I told I am rather busy at the moment and I hadn't found time yet for your question. I had one similar complaint before. However, in order to solve this I need much more details or direct access to a server where the problem happens. At the moment I am just clueless what is going wrong. Share this post Link to post Share on other sites
bimintl 0 Posted November 30, 2017 Posted November 30, 2017 This looks like a great script. Just found it. I would like to ad an image in the product Description for all the products at the same time. Is there a way to do that? The image is kind of a sales funnel to show benefits, about us, testimonials etc. I would like to insert it in all 3500 products. Or does this only go one by one? Thanks for your time David Share this post Link to post Share on other sites
Genocide 0 Posted November 30, 2017 Posted November 30, 2017 On 27/11/2017 at 4:28 PM, musicmaster said: Did you install it correctly. That is: NOT as a module? yup! I already have it on a PS 1.6, but on this 1.7 I can't access to the script :/ Share this post Link to post Share on other sites
metalsniper63 5 Posted November 30, 2017 Posted November 30, 2017 11 hours ago, bimintl said: This looks like a great script. Just found it. I would like to ad an image in the product Description for all the products at the same time. Is there a way to do that? The image is kind of a sales funnel to show benefits, about us, testimonials etc. I would like to insert it in all 3500 products. Or does this only go one by one? Thanks for your time David I know it may not be the answer you want, but you could just add this script and paste it in every product description: <img src="THE URL FOR YOUR IMAGE"> That's a really fast way of doing it Share this post Link to post Share on other sites
metalsniper63 5 Posted November 30, 2017 Posted November 30, 2017 23 hours ago, musicmaster said: Sorry, No. Uploading pictures is not possible with Prestools at the moment. You can only edit the alt texts of images and assign images to product combinations. Thank you for your response. Again, this is a really great script. I was thinking however, to upload the pictures separately and then just inser the LINK to the picture with your script, so, no uploading pictures, just LINK editing. Maybe just add this to the wishlist for the next release. Thank you again for your magnificent work Share this post Link to post Share on other sites
musicmaster 677 Posted November 30, 2017 Posted November 30, 2017 14 hours ago, bimintl said: This looks like a great script. Just found it. I would like to ad an image in the product Description for all the products at the same time. Is there a way to do that? The image is kind of a sales funnel to show benefits, about us, testimonials etc. I would like to insert it in all 3500 products. Or does this only go one by one? Thanks for your time David Yes, you can. You can add text to the description with Mass Edit. And that text may contain html such as an image link. The image must be uploaded separately. Share this post Link to post Share on other sites
musicmaster 677 Posted November 30, 2017 Posted November 30, 2017 3 hours ago, metalsniper63 said: I was thinking however, to upload the pictures separately and then just inser the LINK to the picture with your script, so, no uploading pictures, just LINK editing. You can have links in the description. Or do you want them somewhere else? Share this post Link to post Share on other sites
musicmaster 677 Posted November 30, 2017 Posted November 30, 2017 9 hours ago, Genocide said: yup! I already have it on a PS 1.6, but on this 1.7 I can't access to the script :/ I don't know of any installation problem that is related to the PS version. The most common problem is security software that for some reason thinks that Prestools is suspect and blocks it. To know more you should do some experiments with varying urls. Suppose www.myshop.com/admin123/prestools/product-edit.php is your normal access url. Then you should try variations like: www.myshop.com/admin123/prestools/image-edit.php (a valid other program that you didn't previously use) www.myshop.com/admin123/prestools/pen.png (some file that is not a program and won't be affected by software errors) www.myshop.com/admin123/prestools/xyuz (some non-existing file name). www.myshop.com/admin123/prestoolsss/image-edit.php (another directory) Share this post Link to post Share on other sites
metalsniper63 5 Posted December 1, 2017 Posted December 1, 2017 18 hours ago, musicmaster said: You can have links in the description. Or do you want them somewhere else? No, i would like to insert the LINK for the image. Let's say you upload a product with no image, then you open your script and in the IMAGE field, you can enter a LINK for an image and have it saved for that product. Is it possible? Share this post Link to post Share on other sites
saphire 0 Posted December 1, 2017 Posted December 1, 2017 On 28/11/2017 at 9:47 PM, musicmaster said: Thank you for the feedback. I quickly made a fix that should solve the problem (I am rather busy with other things...) . You find it attached to this post (it will be removed afterwards). Can you test it? As, promised, I removed the link after one day. Unfortunately I didn't receive a reaction from you. If you still need it please let me know. Sorry, lost the notification. Can you put patch again? Thank you Share this post Link to post Share on other sites
musicmaster 677 Posted December 2, 2017 Posted December 2, 2017 19 hours ago, metalsniper63 said: No, i would like to insert the LINK for the image. Let's say you upload a product with no image, then you open your script and in the IMAGE field, you can enter a LINK for an image and have it saved for that product. Is it possible? No, that is not possible at the moment. Share this post Link to post Share on other sites
musicmaster 677 Posted December 2, 2017 Posted December 2, 2017 16 hours ago, saphire said: Sorry, lost the notification. Can you put patch again? Thank you I updated the file in the shop. When you login to your account on prestools.com you can download the update. Share this post Link to post Share on other sites
saphire 0 Posted December 2, 2017 Posted December 2, 2017 Hi, send you a email with account information under shop account contact, to identify account. Best regards Share this post Link to post Share on other sites
saphire 0 Posted December 4, 2017 Posted December 4, 2017 Hello Musicmaster, don´t find tags patch. My order is id: PKOOMFVXE Thanks Share this post Link to post Share on other sites
musicmaster 677 Posted December 4, 2017 Posted December 4, 2017 12 minutes ago, saphire said: Hello Musicmaster, don´t find tags patch. My order is id: PKOOMFVXE Thanks Click on your user name and then choose the "My Account" page. Click there your orders and then click this order. Look at its order lines. You should be able to download the plugin from there. Share this post Link to post Share on other sites
saphire 0 Posted December 4, 2017 Posted December 4, 2017 Hi, download super package again on order id: PKOOMFVXE and replace my files. Test and same problem. Set tag in one language and are set ok. Set tags other language, they are set but previous language lost products Association. I'll set the labels on BO individually. Best regards Share this post Link to post Share on other sites
musicmaster 677 Posted December 4, 2017 Posted December 4, 2017 14 minutes ago, saphire said: Hi, download super package again on order id: PKOOMFVXE and replace my files. Test and same problem. Set tag in one language and are set ok. Set tags other language, they are set but previous language lost products Association. I'll set the labels on BO individually. Best regards My fault. I had updated the Tags plugin but not the super package. That has now been repaired. Share this post Link to post Share on other sites
saphire 0 Posted December 4, 2017 Posted December 4, 2017 55 minutes ago, musicmaster said: My fault. I had updated the Tags plugin but not the super package. That has now been repaired. Thanks, Uptated but now no tag adition: 6 Records - of which 6 submitted. *0: MySQL error 1052: Column 'id_lang' in where clause is ambiguous with Query 'SELECT pt.id_tag,name FROM ps_product_tag pt LEFT JOIN ps_tag t ON pt.id_tag=t.id_tag AND t.id_lang='3' WHERE pt.id_product='1' AND id_lang='3'' Share this post Link to post Share on other sites
musicmaster 677 Posted December 4, 2017 Posted December 4, 2017 Thanks for the report. I have updated the file. It should work now. Share this post Link to post Share on other sites
saphire 0 Posted December 4, 2017 Posted December 4, 2017 17 minutes ago, musicmaster said: Thanks for the report. I have updated the file. It should work now. Hello, musicmaster. Now is perfect. Script works fine. Thanks for your quick work and patience. Another question: The new plugin Multishop is part off Prestools Super Package or is a extra plugin? Best Regards Share this post Link to post Share on other sites
musicmaster 677 Posted December 4, 2017 Posted December 4, 2017 1 hour ago, saphire said: Hello, musicmaster. Now is perfect. Script works fine. Thanks for your quick work and patience. Another question: The new plugin Multishop is part off Prestools Super Package or is a extra plugin? Best Regards I am glad it is solved now. Multishop is included in the superpackage. Share this post Link to post Share on other sites
zod 37 Posted December 27, 2017 Posted December 27, 2017 (edited) There is a major problem about the mini module and security. I have a customer who has dynamic IP address from his ISP, and the integration with Prestashop is a must, I don't want he must do double login to operate. I followed all instructions changing username and password in the "Settings1.php", then i installed the mini module adding the same credentials. The module integration is not working, when i press "Prestools Suite" in the left menu, it displays the white page of login. I notice that in the Settings1.php there is a part about Cookies and Session. Default is Cookies. Changing to Session the login is working almost like the previous version but showing an alert about IP Addresses to compile for security reasons. And it is right, if i change browser i see that i can launch a fresh new Prestools session without any login!!!! This is a nuke bomb in the hands of anyone. I can't compile IP addresses, because i can't predict them, they change everyday, here below the part in Settings1.php Quote /* when ipaddresses is empty everyone can access your script. You are strongly advised to enter here your ip address(es) so that access becomes restricted to them. */ $ipadresses = array(); // Example: $ipadresses = array("11.12.13.150","15.18.19.*","::1"); Note that "::1" is the IPv6 variation on "127.0.0.1" and used for localhost. $usecookies = false; /* make false to use sessions instead; */ Why this script can't be safe with the mini module integration? It should work without this hole in security, with Session AND Cookies. Never asking login. PS: i confirm that changing Prestools with old version " 1.16j " of february 2017, having Cookies enabled, and no IP address in the array, the auto login is working fine, mini module is the new one "1.0.3". Edited December 27, 2017 by zod (see edit history) Share this post Link to post Share on other sites
musicmaster 677 Posted December 27, 2017 Posted December 27, 2017 (edited) On 27-12-2017 at 0:03 PM, zod said: There is a major problem about the mini module and security. I have a customer who has dynamic IP address from his ISP, and the integration with Prestashop is a must, I don't want he must do double login to operate. I followed all instructions changing username and password in the "Settings1.php", then i installed the mini module adding the same credentials. The module integration is not working, when i press "Prestools Suite" in the left menu, it displays the white page of login. I notice that in the Settings1.php there is a part about Cookies and Session. Default is Cookies. Changing to Session the login is working almost like the previous version but showing an alert about IP Addresses to compile for security reasons. And it is right, if i change browser i see that i can launch a fresh new Prestools session without any login!!!! This is a nuke bomb in the hands of anyone. I can't compile IP addresses, because i can't predict them, they change everyday, here below the part in Settings1.php Why this script can't be safe with the mini module integration? It should work without this hole in security, with Session AND Cookies. Never asking login. PS: i confirm that changing Prestools with old version " 1.16j " of february 2017, having Cookies enabled, and no IP address in the array, the auto login is working fine, mini module is the new one "1.0.3". Hi Zod, Thank you for the feedback. I have made session login impossible in the latest version. I don't believe the problems are as serious as you see them but it is better to be sure. So I advise everyone to update. There are some improvement to the minimodule. It should work now. Edited December 29, 2017 by musicmaster (see edit history) Share this post Link to post Share on other sites
zod 37 Posted December 29, 2017 Posted December 29, 2017 (edited) Hi Musicmaster, now the mini module is working with cookies again. I find that the alert about IP addresses is launched once at the first access (then i think it is flagged off in the cookie). Is that array still used to restrict access, or is it there for backward compatibility? Awesome script, thank you. Edited December 29, 2017 by zod (see edit history) Share this post Link to post Share on other sites
musicmaster 677 Posted December 29, 2017 Posted December 29, 2017 Hi Zod, I am glad that you still like it. The IP warnings are at the moment programmed that they happen random once in about 5 times during login. I am not sure whether you will see them at all with the mini-module working. As far as I know this could be implemented with all providers as you can use wildcards. The only people for who it might be a problem are those regularly on the road using wifi networks. Share this post Link to post Share on other sites
metalsniper63 5 Posted January 11, 2018 Posted January 11, 2018 Hello MusicMaster. Again Thank you for such a great great tool. I just have a question, right now i have 2 people working with your script. However i would like to know if there's a way to add a second or third user so everyone has their own login information. Share this post Link to post Share on other sites
musicmaster 677 Posted January 11, 2018 Posted January 11, 2018 No, the only way to realize that is to have more than one copy of Prestools running below your admin directory in different subdirectories - each with its own login settings. But I wonder what the added value would be. Share this post Link to post Share on other sites
musicmaster 677 Posted January 18, 2018 Posted January 18, 2018 Recently Prestools had some bugs due to a few structural changes. Line submit had been changed to make virtual product edit work and to increase security the cookie format was changed. It should all work now again. Please notify me if you find any remaining problems. Recent improvements in Prestools: - problems with the mini-module were fixed. - product-solo was fixed. It had been dysfunctional since the line submit fix. Now that has been repaired and also a few improvements have been made. - Integrity checks has been improved and offers now the possibility to repair some problems. - Some minor additional functionality: attribute sort, statistics on categories - Some minor bug fixes Share this post Link to post Share on other sites
godlo 5 Posted February 8, 2018 Posted February 8, 2018 (edited) With "Mass Edit" is it possible to mass edit discounts? (not prices) EDIT: I tested the demo, It does edit discounts too. Edited February 8, 2018 by godlo (see edit history) Share this post Link to post Share on other sites
musicmaster 677 Posted February 8, 2018 Posted February 8, 2018 37 minutes ago, godlo said: With "Mass Edit" is it possible to mass edit discounts? (not prices) EDIT: I tested the demo, It does edit discounts too. It is in the paid part of the software. You need to buy a plugin for it. Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted February 19, 2018 Posted February 19, 2018 (edited) Greetings, Really love the module and everything that is possible in it, I bought the full version and have an issue with a limit, hopefully this can be changed so that others also will not have this issue. It is in Tags, the limit in the "Mass update" "Add" is 32 characters and this should be increased, if possible. If I open only one and paste it directly in there then it is no problem, but it would be nice to "Mass update" it in ones. Prestashop version: 1.6.1.17. Prestools version 1.21i. Release date: 10-feb-2018. PHP version 7.0.27 and MySQL version 10.0.33-MariaDB Prestools full version (Prestools version 1.21j is the correct version, but in says in the text below it is version i, just to let you know that I have the latest version. With kind regards, Alexander. Edited February 19, 2018 by coMegaWebMaster (see edit history) Share this post Link to post Share on other sites
musicmaster 677 Posted February 19, 2018 Posted February 19, 2018 Hi Alexander, In the database the tag field is defined as "varchar(32) utf8_general_ci". That is the reason for the 32 position limit in the Mass edit. So raising the limit in Prestools would result in a situation where after submit people see their tag abbreviated. You can write longer texts in the edit fields but that is only for convenience. Regards, M. Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted February 19, 2018 Posted February 19, 2018 Hi, In the database the _tag is indeed "varchar(32) utf8_general_ci", but when in the "Product Edit" and editing there and adding the comma, I would expect that I can add more at ones. Hopefully this can be done. Would it be possible to edit the Tags separately in the future? With kind regards, Alexander Share this post Link to post Share on other sites
musicmaster 677 Posted February 19, 2018 Posted February 19, 2018 I don't know how good your javascript is. To remove the filter that cuts the string to 32 long you just need to delete one line. It is in product-edit3.js in the function MassUpdate on line 2291 in the latest edition. There you need to delete the line "myval = myval.substring(0,32);" I don't understand what you mean with "Would it be possible to edit the Tags separately in the future?" Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted February 19, 2018 Posted February 19, 2018 (edited) I already found that in the script thank you, but I also see now why it is and the best is to leave it like that or there most be a solution to check for duplicate entries, as that will cause errors, or at least give an error report on the end and not stop when an error happens. The best is as it is already designed, just do one-by-one, so add a tag en then "update all editable records" and then "submit all" and repeat with each tag, this will check for duplicate entry (keep in mind this is case sensitive), and this brings me also to my question of "Would it be possible to edit the Tags separately in the future?" Tags really helps in the search, but this can also get messy, and what I found that some tags are dubbel due to the uppercase and lowercase and some tags are useful in the other languages, but there is no easy why to sort this out or so on. Also I had another issue with the "Order edit", if I "Add product" to an order the location of that product is missing, could this be added? Advanced stock management is on an there is only one warehouse, and multi-store is not setup, yet. With kind regards, Alexander. Edited February 19, 2018 by coMegaWebMaster (see edit history) Share this post Link to post Share on other sites
musicmaster 677 Posted February 19, 2018 Posted February 19, 2018 "what I found that some tags are dubbel due to the uppercase and lowercase" Solving that is rather easy. If you make a small change in the Prestools code at the bottom of product-edit.php. so that all words are rendered lowercase you just need to make the fields editable and submit them. The code will filter out doubles. You need a bit of creativity to make sure that all products are processed but I assume you can do that. My policy that I only make changes for free when they are useful to everyone. I don't see that with the product locations in Addproduct. Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted February 20, 2018 Posted February 20, 2018 I totally agree with you, I don't want special changes for a one time case, but something that works for all, am on the same page with you on that. The "what I found that some tags are dubbel due to the uppercase and lowercase" would have been easy in the beginning to solve, but this is an existing database with more then 15k of tags in just one language and some of those tags need to be also in the other languages. It is a pain sorting that out in the current state and there in not a good way of copying a selection to all the products in a category of another language. so if there would be an separate page for tags to edit and assign, check for dubbels and so on would be great. But as I said, maybe that is something for in the future. As for the "Order edit", "Add product" and that the product has no location, here it is in screenshots: Hopefully this is clear enough, if more information is needed then please let me know. With kind regards, Alexander. Share this post Link to post Share on other sites
musicmaster 677 Posted February 20, 2018 Posted February 20, 2018 I get your point about the warehouse now. This field is only visible when you have warehouses enabled. However, I didn't succeed in getting the location name displayed. Maybe it is my old PS version (1.6.0.14).... And so I can't find out whether this is stored in the ps_order_detail table or not. Also it looks like the selection of the warehouse - when there is more than one - is a bit complicated. Maybe you can give me some hints? Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted February 20, 2018 Posted February 20, 2018 (edited) The location is stored in _warehouse_product_location, the structure is: id_warehouse_product_location | id_product | id_product_attribute | id_warehouse | location # Name Type Collation Attributes Null Default 1 id_warehouse_product_location(Primary) int(11) UNSIGNED No None 2 id_product(Index) int(11) UNSIGNED No None 3 id_product_attribute(Index) int(11) UNSIGNED No None 4 id_warehouse(Index) int(11) UNSIGNED No None 5 location varchar(64) utf8_general_ci Yes NULL A sample where it is called up on is in .../.../admin******/themes/default/template/controllers/orders/_product_line.tpl line 86: {if $display_warehouse} <td> {$product.warehouse_name|escape:'html':'UTF-8'} {if $product.warehouse_location} <br>{l s='Location'}: <strong>{$product.warehouse_location|escape:'html':'UTF-8'}</strong> {/if} </td> {/if} Hopes this help you With kind regards, Alexander. Edited February 20, 2018 by coMegaWebMaster (see edit history) Share this post Link to post Share on other sites
musicmaster 677 Posted February 20, 2018 Posted February 20, 2018 Can you test the attached file? order-proc.php Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted February 20, 2018 Posted February 20, 2018 (edited) It works good, tested it also on combination products, had no issues, so it will be a good one for the next update Edited February 20, 2018 by coMegaWebMaster (see edit history) Share this post Link to post Share on other sites
musicmaster 677 Posted February 26, 2018 Posted February 26, 2018 Good to hear that it works. I made an update that is a bit more refined. Could you check that too? order-proc.php Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted February 26, 2018 Posted February 26, 2018 Got this error: 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 'FROM ns_order_detail WHERE id_order=24331' at line 1 Generated by URL '/admin*****/prestoolz/order-proc.php' with Query 'SELECT id_warehouse FROM FROM ns_order_detail WHERE id_order=24331' Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted February 26, 2018 Posted February 26, 2018 I corrected that FROM FROM, to FROM, but testing it then it will work, but the stock is not being updated when adding or removing. Share this post Link to post Share on other sites
musicmaster 677 Posted February 26, 2018 Posted February 26, 2018 Stock keeping has never been possible with ASM. I have been looking at implementing it but I am puzzled about how out-of-stock ordering is handled. Is it possible at all with ASM? When I set that it is allowed in the settings I still cannot order in my front office. Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted February 26, 2018 Posted February 26, 2018 Am on a point of going home, but the first version that you made was good, products where correctly handled, one goes out of the stock when added and when when deleted it when back in stock, so I don't know what else you want to make better, let me know and tomorrow another day to do things Share this post Link to post Share on other sites
musicmaster 677 Posted February 27, 2018 Posted February 27, 2018 I have uploaded a new version of Prestools. Its stock handling should work again for you. Share this post Link to post Share on other sites
musicmaster 677 Posted February 27, 2018 Posted February 27, 2018 (edited) Still found another bug. Fix version is 1.21k2 Edited February 27, 2018 by musicmaster (see edit history) Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted February 27, 2018 Posted February 27, 2018 Now it works good, I was already making an error report, but your latest version is handeling it correct on the stock update and location. Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted March 1, 2018 Posted March 1, 2018 I found another thing with "warehouse location", in the product-edit when "warehouse" is selected the result is good: But when exported to CSV it is missing the location, can you add that in the next update? Also, the Export CSV only exports what is on screen, maybe a compleet query results export could be added later on? With kind regards, Alexander. Share this post Link to post Share on other sites
musicmaster 677 Posted March 1, 2018 Posted March 1, 2018 Hi Alexander, CSV Export exports the settings that are on that moment on the screen. So you can display 100 product, then write 10,000 in the Number of Recs field then it will export 10,000 products. I have attached a version of product-csv with location. However, it will always stay arbitrary which fields are added. I encourage people to dive in the code and make their own variation. product-csv.php Share this post Link to post Share on other sites
musicmaster 677 Posted March 3, 2018 Posted March 3, 2018 Prestools does not yet support the newest Prestashop version 1.7.3. As this version refuses to install on my Windows Xampp installation this situation may last some time. Share this post Link to post Share on other sites
samator79 0 Posted March 5, 2018 Posted March 5, 2018 Hi I want to buy 2 tools from prestatools suite, but the site dont work. Thank for your reply Share this post Link to post Share on other sites
musicmaster 677 Posted March 5, 2018 Posted March 5, 2018 41 minutes ago, samator79 said: Hi I want to buy 2 tools from prestatools suite, but the site dont work. Thank for your reply Thanks for alerting me of the problem. Sorry for the inconvenience. Now it should work again. Share this post Link to post Share on other sites
hakeryk2 133 Posted March 21, 2018 Posted March 21, 2018 Just typing here to once again tell You how this suite is awesome. Share this post Link to post Share on other sites
KevinNash 119 Posted March 21, 2018 Posted March 21, 2018 I 100% agree with hakeryk2, I'll never say it enough, this suite is incredible ! Share this post Link to post Share on other sites
coMegaWebMaster 1 Posted March 29, 2018 Posted March 29, 2018 Saw something in the new version Prestools_Suite-1.21o.zip: Share this post Link to post Share on other sites
musicmaster 677 Posted March 29, 2018 Posted March 29, 2018 Thanks for notifying me. I have fixed it. In the 1.21o version I had included the new variables of Prestashop 1.7.3 but something had gone wrong with the naming and the version check. 1.7.3 is still not supported as I haven't implemented the new handling of the features (you can have multiple values) yet. 1 Share this post Link to post Share on other sites
Maldon Jewellery 3 Posted April 11, 2018 Posted April 11, 2018 Hello, I wonder if someone can help. I purchased the full addons the other day and is a great help to me. I was reading the manual about searching for empty fields and see that there are a few ways depending on the fields being searched for. I need to search for an empty supplier field but everything I try does not give the result I need. As I can't sort by the field either then I end up having to visually notice any empty fields. Any ideas how I can solve this please? Kind regards Simon Share this post Link to post Share on other sites
musicmaster 677 Posted April 11, 2018 Posted April 11, 2018 Like this? product-edit.php Share this post Link to post Share on other sites
Maldon Jewellery 3 Posted April 11, 2018 Posted April 11, 2018 Sorry, for being a bit thick, but do I replace my original product-edit.php with this new one? Just want to clarify so I don't mess anything up. Kind regards Simon Share this post Link to post Share on other sites
musicmaster 677 Posted April 11, 2018 Posted April 11, 2018 Yes, And somewhere preserve the old one to be sure... Share this post Link to post Share on other sites
Maldon Jewellery 3 Posted April 11, 2018 Posted April 11, 2018 7 minutes ago, musicmaster said: Yes, And somewhere preserve the old one to be sure... Many thanks. Share this post Link to post Share on other sites
Maldon Jewellery 3 Posted April 11, 2018 Posted April 11, 2018 Ahhhhhh. Just realised that when I was clicking on the column header, it was only sorting the results of that page and not the entire list. Thankyou for responding Kind regards Simon Share this post Link to post Share on other sites
KeenGamer 2 Posted April 29, 2018 Posted April 29, 2018 Hello, if I try to show just Virtual products, I get error Notice: Undefined variable: combination_count in /home/........../prestools/product-edit.php on line 2295 Can you please tell me what's wrong there in the code so I can fix it? Or if you can fix it? Thank you. Share this post Link to post Share on other sites
musicmaster 677 Posted April 29, 2018 Posted April 29, 2018 Hi KeenGamer Thanks for reporting the problem. I will fix it in the next release. You can fix it for yourself by just deleting the code segment at that line: if($combination_count != 0) $bgcolor = 'style="background-color:#FF8888"'; Regards, M Share this post Link to post Share on other sites
KeenGamer 2 Posted April 30, 2018 Posted April 30, 2018 Ok, it works, thanks. But if you export it in csv, there are no figures in the virtual product column. There is a small bug there as well :-). Share this post Link to post Share on other sites
Recommended Posts