Jump to content

FREE script - Prestools-Suite mass edit order - Edit and much more


Recommended Posts

  • 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

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!

  • Like 2

Share this post


Link to post
Share on other sites

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 by bluerose (see edit history)

Share this post


Link to post
Share on other sites

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

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

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

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

 

1st-en_tags_display_in_bo.png

2st-set_pt_tags.png

1st-notags.png

1st-pt_tags_display_in_bo_Tags_are_active_but_tags_set_in_en_are_no_products_assocated.png

1st-set_en_tags.png

Share this post


Link to post
Share on other sites
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 by musicmaster (see edit history)

Share this post


Link to post
Share on other sites

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

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

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

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 by zod (see edit history)

Share this post


Link to post
Share on other sites
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 by musicmaster (see edit history)

Share this post


Link to post
Share on other sites

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 by zod (see edit history)

Share this post


Link to post
Share on other sites

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

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

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

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

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 by coMegaWebMaster (see edit history)

Share this post


Link to post
Share on other sites

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

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

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

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 by coMegaWebMaster (see edit history)

Share this post


Link to post
Share on other sites

"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

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:

2018-02-20_083406.thumb.PNG.12a9f8da9a258b38ec27453dbba7635a.PNG

2018-02-20_083441.thumb.PNG.5d0dd35470588d31348774aac94fa15c.PNG

2018-02-20_085459.PNG.462ff259ccc9978497418b145772a57d.PNG

2018-02-20_083519.PNG.43845fe2829d68a0f960368a7d1fcc83.PNG

2018-02-20_083639.thumb.PNG.d84d9971811e7a3737adf47d831a1a4c.PNG

2018-02-20_083721.thumb.PNG.76467944743159b6a0ca279b354929c3.PNG

2018-02-20_084842.PNG.e0ffbba826fd4d7422dc38229f210b3f.PNG

2018-02-20_084902.thumb.PNG.7f3041528aeb2dc681c80414722883bf.PNG

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

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

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 by coMegaWebMaster (see edit history)

Share this post


Link to post
Share on other sites

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

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

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

I found another thing with "warehouse location", in the product-edit when "warehouse" is selected the result is good:2018-03-01_153237.PNG.59cd556ef99e75456b1d6573f577d246.PNG
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

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
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
  • 2 weeks later...

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.

  • Like 1

Share this post


Link to post
Share on other sites

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
  • 2 weeks later...

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

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