Prestools - the free mass edit toolset

[30knees]

8 hours ago, musicmaster said:

Which program are you using? I don't recognize the page. This is not order-edit.php.

That's a screenshot of the invoice I generated from within the tb order page.
What part of order-edit.php do you want to see? This is order-edit.php for the shipping costs:

[musicmaster]

BTW: do you use the most recent Prestools version? This part of the code recently had quite a few changes.

[musicmaster]

On 3/22/2023 at 8:32 AM, musicmaster said:

BTW: do you use the most recent Prestools version? This part of the code recently had quite a few changes.

I assume that the new version solved your problem.

[30knees]

11 hours ago, musicmaster said:

I assume that the new version solved your problem.

Unforunately not.

I am using:

Prestools version 1.31j. Release date: 14-feb-2023.

Changing the shipping price does not affect the taxes as shown in the invoice.

[Cassim]

@musicmaster

Do your newest version support adding/removing/updating the Multiple Features of TB ?

[musicmaster]

20 hours ago, Cassim said:

@musicmaster

Do your newest version support adding/removing/updating the Multiple Features of TB ?

Not yet

[Cassim]

37 minutes ago, musicmaster said:

Not yet

Something your working on.?
Or do you have a date on when it will? 

[musicmaster]

19 hours ago, Cassim said:

Something your working on.?
Or do you have a date on when it will? 

Probably a few weeks. There are also some other changes I am working on.

[30knees]

On 3/22/2023 at 7:19 AM, 30knees said:

That's a screenshot of the invoice I generated from within the tb order page.
What part of order-edit.php do you want to see? This is order-edit.php for the shipping costs:

Prodded by a chat @musicmasterand I had, I think this is the problem:

• Prestools is assigning a VAT rate of 7% to shipping costs.
• The invoice shows that is assigning a VAT rate of 19% but in reality it is using the 7% calculated by Prestools.

--> Prestools should be assigning a VAT rate of 19% and not 7% for this order because 19% is the VAT rate of the product that was bought.

Perhaps Prestools is ignoring the Advanced EU Compliance Module feature "Proportionate tax for shipping and wrapping"? 

A solution might be to be able to set the tax rate for Prestools (or even better, adopt "Proportionate tax for shipping and wrapping")?

Edited March 30, 2023 by 30knees

[musicmaster]

I uploaded a new version of Prestools. Quite a lot of changes.

@CassimMulti-feature should now work for Thirty Bees. You need to download both to download this version and the newest version of the paid-for software.

@30knees"Proportionate tax for shipping and wrapping" should now work as in Thirty Bees.

Other parts that had major revisions:

 - the repair part of integrity checks

 - the adding of images in product-edit

 - indexation

The manual also got some updates.

Don't forget to use ctrl-F5 on your PC after the update in order to reload ignoring the browser cache. Otherwise you might be running the new version with the old javascript file.

Edited April 8, 2023 by musicmaster

[musicmaster]

I found one more problem. A fix has been uploaded.

[musicmaster]

The previous release (1.32a) had some problems that made that it didn't always save texts in product-edit. I made a new release that corrects that: 1.32b.

Please update when you downloaded 1.32a.

Edited April 26, 2023 by musicmaster

[Lukasz Flak]

Hi there,

 I'm looking for solution to clean category pages tree with the fastest way.

I've got old category tree so with seo agency decided to:

- firstly, remove products from category that are not in the main tree (they come from older version of presta etc)

- secondly, remove from page category description

- thirdly, create page FAQ that will cover words from description

- fouthly, set-up redirection 301 from old category pages to FAQ

- lastly, delete old category pages.

 

Can you advise my approch is ok?

With prestatools I can edit and remove category from each page but its very time-consuming approach.

Looking for help, 

thank you for the reply in advance.

 

[musicmaster]

4 hours ago, Lukasz Flak said:

I'm looking for solution to clean category pages tree with the fastest way.

I've got old category tree so with seo agency decided to:

- firstly, remove products from category that are not in the main tree (they come from older version of presta etc)

- secondly, remove from page category description

- thirdly, create page FAQ that will cover words from description

- fouthly, set-up redirection 301 from old category pages to FAQ

- lastly, delete old category pages.

 

Can you advise my approch is ok?

With prestatools I can edit and remove category from each page but its very time-consuming approach.

If you find the Prestools mass edit functions time-consuming then you will need to build your own tools. But it is not even clear to me whether you are using mass edit.

[Obi]

I finally got around to using Prestools for something other than resorting products within a category using products-sold.php. (My PrestaStore Manager program messes up the sorting if I move an item in the list - think lazy click where an item gets accidentally dragged to a new position - it cannot be resolved in the PrestaStore Manager program.)

Anyway, I found the report created by products-sold.php to be useful for some sales analysis I have wanted to do for some time now, except there is no quantity on hand field/column in the report. I would like to be able to see the stock status/quantity of any given item in the list.

So my question is this: What would it take to add a QTY display for the quantity in stock to be displayed in this report?

I have more than 20,000 products in the catalog and have installed Prestools version 1.34e in the hope that this field had been added, it has not, so having a quick-at-a-glance best sellers report with current available stock would be helpful. Is this something available in a different part of the toolsuite or is it possible to add this to the existing products-sold.php report as an extra fields option? (I guess this is a redundant question, but left for clarity.)

Also

PS: There is also a bug where I am unable to export to csv from the products-sold.php report.

PPS: There is also a bug in product-sort.php where VAT and PriceVAT are not selected, yet these columns still appear in the report list. Is there a simple code change to fix that? Having these two unnecessary/unwanted fields in the report output is not only distracting clutter, but takes up valuable report space.

PPPS: So far, great job on the tool, I'll likely purchase an add-on or two in the near future.

Edited August 20 by Obi

[musicmaster]

21 hours ago, Obi said:

I finally got around to using Prestools for something other than resorting products within a category using products-sold.php. (My PrestaStore Manager program messes up the sorting if I move an item in the list - think lazy click where an item gets accidentally dragged to a new position - it cannot be resolved in the PrestaStore Manager program.)

Anyway, I found the report created by products-sold.php to be useful for some sales analysis I have wanted to do for some time now, except there is no quantity on hand field/column in the report. I would like to be able to see the stock status/quantity of any given item in the list.

So my question is this: What would it take to add a QTY display for the quantity in stock to be displayed in this report?

I have more than 20,000 products in the catalog and have installed Prestools version 1.34e in the hope that this field had been added, it has not, so having a quick-at-a-glance best sellers report with current available stock would be helpful. Is this something available in a different part of the toolsuite or is it possible to add this to the existing products-sold.php report as an extra fields option? (I guess this is a redundant question, but left for clarity.)

Also

PS: There is also a bug where I am unable to export to csv from the products-sold.php report.

PPS: There is also a bug in product-sort.php where VAT and PriceVAT are not selected, yet these columns still appear in the report list. Is there a simple code change to fix that? Having these two unnecessary/unwanted fields in the report output is not only distracting clutter, but takes up valuable report space.

PPPS: So far, great job on the tool, I'll likely purchase an add-on or two in the near future.

Thank you for liking Prestools. I have uploaded a new version that may solve some of your problems.

 - stock is one of the optional extra fields that you can select.

 - I fixed one bug in products-sold, but as you didn't provide details I am not sure it is the one you meant.