Jump to content
musicmaster

[Free Script] Prestools Suite: Mass Edit, Order Edit And Much More

Recommended Posts

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?

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?

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

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.

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

Share this post


Link to post
Share on other sites

I made a few more changes. The main problem was that when the table had been sorted with one of the headings above the columns it no longer worked correctly. I hope that is now repaired (it was quite complicated).

Share this post


Link to post
Share on other sites

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

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

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

Share this post


Link to post
Share on other sites

Hi, I've just noticed a problem with the edit orders mod - If you add a product to the order the currency is in the shop default currency rather than the order currency.

Share this post


Link to post
Share on other sites

Hi Pel024, Could you have a look at the attached file an test it for me? It should solve your currency problem.

 

Update: File removed. It can be found as part of the latest version of the script in post #1

Edited by musicmaster

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

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

Share this post


Link to post
Share on other sites

it works in 1.5 great tool!!

 

any hint on how to enable edit categories too in product_edit.php?

 

(i mean for changing the category products are in)

Edited by misthero

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×