Jump to content

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


musicmaster
 Share

Recommended Posts

  • 2 weeks later...
  • 3 weeks later...

I guess I should write in this thread because I am using the new module...

 

This module works just fine, however, there is one potential problem... When a product is manually added to the order, the appropriate TAX RATE is not applied - tax is listed at 0%. Is this normal? I cannot manually modify the Tax either.

 

Any suggestions to this issue?

  • Like 1

Share this post


Link to post
Share on other sites

@spiffyd: I saw you are from the US. So I assume the tax is specific for the states. As the script only took the country into account when determining which tax was applicable that may have caused the problem.

 

I have adapted the script (see at post #1). Can you test it?

  • Like 2

Share this post


Link to post
Share on other sites

I just tested out 1.02. When I added a new product to the order with your module, I don't see changes in tax column, it still says 0%.

 

If you can't get it working, maybe is there a way to turn that column to an input box so the user can manually specify a tax percentage? It's at least a workaround.

Share this post


Link to post
Share on other sites

My preferred way to go forward would be if you sent me some of your database files (product and all the tax files). I could then check better what goes wrong. You might also help with a screendump of what the order_edit looks immediately after you added a product.

 

I added a little debug line to the code so please use the newly updated version. It gives a line with info at the right top when you add a product .

 

Changing the tax field would be a major effort. Besides, I think it would be disadvantageous for most people as they would run the risk to accidentally change their taxes. If you want a workaround you could put the taxes as a negative discount in the general section of the order.

Share this post


Link to post
Share on other sites

Hi musicmaster and ty for this great script!

I have 2 questions for you (sorry for my english...

- Is possible insert the stock quantity data in the Product Edit sections?

- Is possible a "mass update system" and not 1by1? (like Mass Update module)

 

i'm looking for a mass update method for the stock of my ecommerce filtered by name...

Edited by PEPPE83 (see edit history)

Share this post


Link to post
Share on other sites

Hi Peppe83,

 

I added the stock quantity and made mass update a bit easier with a "submit all" function. Mass changes are planned for some future version. Please have a look and see if everything works ok.

 

Hi musicmaster.........THANK YOU!!!!!! I test the new version now... :D

 

EDIT: i see only a big X in the quantity row....

Edited by PEPPE83 (see edit history)

Share this post


Link to post
Share on other sites

  • 2 weeks later...

HI,

 

Thanks for your script. Works perfect!

 

i have a question about security of the script.

 

What do i need to delete from login1.php, that it won't give the popup anymore and after that only the login? so this line also removed : Please first generate a hash key from your password and insert it at the top of the file "login1.php"

 

Thanks again for your script,

 

Fabian

Share this post


Link to post
Share on other sites

Hi, I'm using this great script to edit product descriptions. Is it possible to increase the size of the textarea for short and long descriptions without manually expanding the box, by using rows and cols?

 

I assume these lines would need editing but I'm not sure how:

 

 

if (in_array("shortdescription", $input["fields"]))   $infofields[$if_index++] = array("description_short","", "description_short", DISPLAY, 0, LEFT, NO_SORTER, TEXTAREA); if (in_array("description", $input["fields"]))   $infofields[$if_index++] = array("description","", "description", DISPLAY, 0, LEFT, NO_SORTER, TEXTAREA);

 

 

Cheers

  • Like 1

Share this post


Link to post
Share on other sites

Hi, I've tried editing the below line by increasing the height and adding a width but I can't get it to work. To be honest I'm not sure what I'm doing!

 

else if((field=="description") || (field=="meta_description"))
    tblEl.rows[i].cells[fieldno].innerHTML = '<textarea name="'+field+row+'" height="3" onchange="reg_change(this);">'+tmp+'</textarea>';

 

Cheers

Share this post


Link to post
Share on other sites

The "height=" attribute very probably doesn't do anything. An unfortunate but harmless programming mistake.

 

Instead you should use the usual attributes of a textarea: rows and columns. So instead of 'height="3"' you might get 'rows="5" cols="30"' for example.

Share this post


Link to post
Share on other sites

  • 2 weeks later...

Hi,

 

Is there any chance this has been updated for 1.5.2? I desperately need to manually edit the Warehouse Id field in the order_details table. If it hasn't been updated yet, any pointers on how to edit the code to include the Warehouse_Id field would be greatly appreciated! Excellent Script

Share this post


Link to post
Share on other sites

I have just given up (again) on PS 1.5 because it is so instable and because unlike 1.4 persistent trying doesn't help. So I very probably won't spend any time on fitting the script for 1.5 before next year.

 

The easiest way to insert the warehouse id is probably to put it in place of another similar variable. You should start with the big table as that is the place where the variable name is set. If the variable is not in the product table itself you should also look at the processing file and add the right processing code there.

Edited by musicmaster (see edit history)

Share this post


Link to post
Share on other sites

  • 4 weeks later...

Anyone ever try this in PS 1.5.2? I'm getting the error below because it doesn't look like approve.php exists in the admin directory.

 

Fatal error: require() [function.require]: Failed opening required 'approve.php' (include_path='.:/usr/local/php52/pear') in /home/incontis/public_html/admin123/order_edit.php on line 3

Share this post


Link to post
Share on other sites

Anyone ever try this in PS 1.5.2? I'm getting the error below because it doesn't look like approve.php exists in the admin directory.

 

Fatal error: require() [function.require]: Failed opening required 'approve.php' (include_path='.:/usr/local/php52/pear') in /home/incontis/public_html/admin123/order_edit.php on line 3

 

Ok, I see what I did. I only downloaded the order_edit.zip file from post #29 which only had the order_edit.php file in it. I now downloaded the zip file 1.04 from the original post and get the following error message. I know I am logged in because I have my admin page opened on another tab. Even tried logging out and back in.

 

"Plz login to view this page"

Share this post


Link to post
Share on other sites

Works fine in 1.5.2.

and for order in 1.3.

 

Do oy have the edit product php for Prestashop 1.3.3

Thanks

Best regards

 

the Error in PS 133

 

MySQL error 1146: Table 'lxxx_tax_rule' doesn't exist

Generated by URL '/lxxxx/product_edit.php'

with Query 'SELECT rate,name,tr.id_tax_rule,g.id_tax_rules_group FROM axxxx_tax_rule tr LEFT JOIN a133_tax t ON (t.id_tax = tr.id_tax) LEFT JOIN axxxxx_tax_rules_group g ON (tr.id_tax_rules_group = g.id_tax_rules_group) WHERE tr.id_country = '8''

Share this post


Link to post
Share on other sites

Tried in PS 1.5.2 and it works, but it would be nice if it was possible to (for products)

Edit more than one language at once

Edit combinations

Edit images (and, nothing happens when I toggle hide/show for image)

Edit categories

 

Question: What is the X at the first row?

 

/Mats

Share this post


Link to post
Share on other sites

Mohsart, thanks for your suggestions.

 

The X at the first row is to remove records from the view. This is easy to keep overview. It is also with an eye on future extensions where you might get the possibility to apply certain changes for all products in view. For example to raise all prices with 5% or to add the same description to a number of related products.

Share this post


Link to post
Share on other sites

Well its important for me to see deducting ITEM (which is usually VOUCHER) on invoice. nothing to do shipping and handling.

 

I dont want to change price directly, but with voucher. If customer did use voucher, its OK on invoice. But sometimes they forgot to use it, so i need to deduct price. I dont want to change price directly, but with voucher.

 

hope you understand

thanks

Share this post


Link to post
Share on other sites

Hello I am using PS1.4.7.0

When trying to see the order_edit.php I get:

 

Plz login to view this page

Warning: Cannot modify header information - headers already sent by (output started at /var/www/web-owner/data/********/someadminfolder/approve.php:5) in /var/www/web-owner/data/********/someadminfolder/approve.php on line 6

Edited by a_smith (see edit history)

Share this post


Link to post
Share on other sites

In their simplest form categories are rather similar to manufacturers. What makes it complicated is that you can have more than one category for a product and that there is a default category. An additional problem is that you would need a format that displayed in a transparent way in which categories a product is. That is difficult to do without taking a lot of space.

 

It is for those complications that categories are not changeable. It is just too much work - at least for the moment.

Share this post


Link to post
Share on other sites

  • 1 month later...

Hello musicmaster, at first thx a lot for a great job :-)

 

i have one little problem, if i want to edit order, and add item which is in sale, it add a product with a non-sale price, for example product cost 28,50€, sale price is 22,50€, if i add this product to order, the price added will be 28,50... could you look on it ? thanks for your answer

Share this post


Link to post
Share on other sites

Hello I am using PS1.4.5.1

When trying to see the order_edit.php I get:

 

Plz login to view this page

Warning: Cannot modify header information - headers already sent by (output started at /home/fancyc6/public_html/****admin/triple_edit_1.04/approve.php:5) in /home/fancyc6/public_html/*****ADMIN/triple_edit_1.04/approve.php on line 6

 

Any Idea?

 

thanks

Share this post


Link to post
Share on other sites

@lubo_ke: I have looked at it but adding discounts would have its own problems. What do you do when the discount has changed between the order date and the date of the change?

 

So I think it is better when discounts are applied manually in the discounts field of the order.

Share this post


Link to post
Share on other sites

Hello,

 

I'm having problems when I try to add a new product with 1.3.2.3:

 

The error message says:

 

from ps_product p left join ps_product_lang pl on p.id_product=pl.id_product and pl.id_lang='3' left join ps_lang l on pl.id_lang=l.id_lang left join ps_tax_rule tr on tr.id_tax_rules_group=p.id_tax_rules_group AND tr.id_country='6' AND tr.id_state='173' left join ps_tax t on t.id_tax=tr.id_tax left join ps_tax_lang tl on t.id_tax=tl.id_tax and tl.id_lang='3' left outer join ps_product_attribute a ON a.id_product=p.id_product AND a.default_on='1' where true AND (p.reference like '%protector%' or p.supplier_reference like '%protector%' or pl.name like '%protector%')

MySQL error 1146: Table 'prestashop.ps_tax_rule' doesn't exist

Generated by URL '/adminA2/add_product.php'

with Query 'SELECT COUNT(*) AS rcount from ps_product p left join ps_product_lang pl on p.id_product=pl.id_product and pl.id_lang='3' left join ps_lang l on pl.id_lang=l.id_lang left join ps_tax_rule tr on tr.id_tax_rules_group=p.id_tax_rules_group AND tr.id_country='6' AND tr.id_state='173' left join ps_tax t on t.id_tax=tr.id_tax left join ps_tax_lang tl on t.id_tax=tl.id_tax and tl.id_lang='3' left outer join ps_product_attribute a ON a.id_product=p.id_product AND a.default_on='1' where true AND (p.reference like '%protector%' or p.supplier_reference like '%protector%' or pl.name like '%protector%') '

Could you help me??

Thanks a lot!!!

Share this post


Link to post
Share on other sites

I have tried with the 1.5 and with 1.4 version. But the result is the same:

 

MySQL error 1146: Table 'prestashop.ps_tax_rule' doesn't exist

 

:(

 

I have checked on my database this table, and it doesn't exist. How can I solve it?

 

Thanks a lot!

 

@OrtopediaPlus.com: in the first post with the downloads you will also find links to the previous version of this script. You should look there.

Share this post


Link to post
Share on other sites

@OrtopediaPlus.com: I don't understand you. First you complain that the present software doesn't work with version 1.3. And when I then refer you to a version that should work with 1.3 you complain that that software doesn't work with 1.4 and 1.5.

Share this post


Link to post
Share on other sites

  • 2 weeks later...

Hi all,

Upon logging in I get the following error:

 

Warning: require(../config/settings.inc.php) [function.require]: failed to open stream: No such file or directory in /admin123/Orderedit/order_edit.php on line 4

 

Fatal error: require() [function.require]: Failed opening required '../config/settings.inc.php' (include_path='.:/usr/local/php5/lib/php') in /admin123/Orderedit/order_edit.php on line 4

Edited by lisajef (see edit history)

Share this post


Link to post
Share on other sites

  • 3 weeks later...

Hello,

thank you very much for the changes made. I still had the old version and so far everything has worked in version 1.4.7.3

 

I wanted to ask if you have solved the issue of why yes combinations would be good to have it.

Another thing, if I have wholesale and retail prices for different groups of customers, non lo manages why this script? I read in one of the lines order_edit.php including calling prices for groups, but does not work.

Share this post


Link to post
Share on other sites

  • 3 weeks later...

Hi,

I used a earlier version with a lot of pleasure! It really helped me a lot thanks for that.

 

But 4 months ago it did not work anymore... it can be because i changed server but i am not sure about that. In firefox i get to see a white page with noting on it, in chrome i get the following error: HTTP-fout 500 (Internal Server Error). Putting the restrictions to 777 didn't help for testing. Any idea what can it can be?

Share this post


Link to post
Share on other sites

Hi.

 

Thank you for this script.Need help plss..

Using ps1.4.8.2 and already unzipped and upload all the files in triple edit 1.08 to admin directory..

So I think already in the correct directory - my link:www.myshop.com/shop/myadmin/order_edit.php

 

but when try to access the status is Plz login to view this page.

But i already login to my backoffice.

 

What I did wrong?

 

Thanks in advance!

Edited by halenaa (see edit history)

Share this post


Link to post
Share on other sites

Hi Smiles,

 

Can you check that you copied all the files to your admin directory? You might take a fresh install to be sure you have all the files.

 

As i had the same error wit the 4 files version i tryed to instal it again. And on your advice once more but the error stays the same...

Share this post


Link to post
Share on other sites

Hi.

 

Thank you for this script.Need help plss..

Using ps1.4.8.2 and already unzipped and upload all the files in triple edit 1.08 to admin directory..

So I think already in the correct directory - my link:www.myshop.com/shop/myadmin/order_edit.php

 

but when try to access the status is Plz login to view this page.

But i already login to my backoffice.

 

What I did wrong?

 

Thanks in advance!

This is comes from a readme file of an earlyer version it is missing in the lates version:

 

** Security addon ** note this is lite security!!

 

upload md5.php and visit it, then fill in the box with you brand new password

 

edit login1.php and replace your_md5_hash_goes_here with your new md5 hash string

 

delete md5.php from server

 

uploade the other files to /prestashop_folder/admin_folder/

 

go ahead and safely change orders.

Share this post


Link to post
Share on other sites

Hi.

 

Thank you for this script.Need help plss..

Using ps1.4.8.2 and already unzipped and upload all the files in triple edit 1.08 to admin directory..

So I think already in the correct directory - my link:www.myshop.com/shop/myadmin/order_edit.php

 

but when try to access the status is Plz login to view this page.

But i already login to my backoffice.

 

What I did wrong?

 

Thanks in advance!

I Halenaa, i had your same problem.

I solved using www.myshop.com/shop/myadmin/login1.php

 

Hy

Share this post


Link to post
Share on other sites

I Halenaa, i had your same problem.

I solved using www.myshop.com/shop/myadmin/login1.php

 

Hy

 

Updated

 

for product.edit php.

After i click edit the short description my short description text is not in the editable box unlike long description which in the editable box.

 

and in the editable box have this <p>◄<span style= or this <div id= and my description (not editable) and at the end got this code " onchange="reg_change(this);" /> (not editable)

 

so I don't know how to edit my short description.

 

Please guide me

 

Thanks

Edited by halenaa (see edit history)

Share this post


Link to post
Share on other sites

Here is a first release of version 1.09.

 

The main difference is that it can edit categories in product_edit. As it involves quite a lot of new code (nearly 200 lines) I would appreciate it when some people test it and give feedback.

 

Can i test it on a live site or (of course) better in test enviroment?

Share this post


Link to post
Share on other sites

@McDaim: PS offers excellent options for changing payment from bankwire to Paypal - so there is no need for that in the script. As for the tax: which module do you mean: order_edit or product_edit?

 

@Smiles: You can see the software as version 1.08 with some extra's. With 1.08 I haven't heard complaints so it is mainly editing categories where you should take some care.

Share this post


Link to post
Share on other sites

@McDaim: PS offers excellent options for changing payment from bankwire to Paypal - so there is no need for that in the script. As for the tax: which module do you mean: order_edit or product_edit?

 

@Smiles: You can see the software as version 1.08 with some extra's. With 1.08 I haven't heard complaints so it is mainly editing categories where you should take some care.

I mean order edit, exsample customer buy, payment methode Bank Wire but will edit to PayPal, or payment PayPal edit to Bank Wire and also nice is if Tax edit possible

Share this post


Link to post
Share on other sites