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.

[Obi]

On 8/21/2024 at 7:46 AM, musicmaster said:

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.

Ahhh... installed ver 1.34e and 1.34f and getting this when I choose "with subcats"

MySQL error 1054: Unknown column 'c.nleft' in 'field list'
Generated by URL '/xxxxxxxx/xxxxxxxxxx/product-edit.php'
with Query 'select SQL_CALC_FOUND_ROWS p.*,pl.*,ps.*, cl.name AS catname,p.id_product AS ptest,pl.id_product AS pltest, cl.link_rewrite AS catrewrite, pld.name AS originalname, s.quantity, s.depends_on_stock, s.out_of_stock AS out_of_stock, c.nleft,cp.position FROM tb_product_shop ps LEFT JOIN tb_product p ON p.id_product=ps.id_product LEFT JOIN tb_product_lang pl ON pl.id_product=p.id_product and pl.id_lang='1' AND pl.id_shop='1' LEFT JOIN tb_product_lang pld ON pld.id_product=p.id_product and pld.id_lang='1' AND pld.id_shop='1' LEFT JOIN tb_category_lang cl ON cl.id_category=ps.id_category_default AND cl.id_lang='1' AND cl.id_shop = '1' LEFT JOIN tb_stock_available s ON s.id_product=p.id_product AND s.id_shop = '1' AND id_product_attribute='0' LEFT JOIN tb_category_product cp ON p.id_product=cp.id_product INNER JOIN (SELECT MIN(id_category) AS mincat,id_product,position FROM tb_category_product WHERE id_category IN (35,36,41,42,43,37,38,39,40) GROUP BY id_product) cpx ON cpx.mincat=cp.id_category and cpx.id_product=p.id_product WHERE ps.id_shop='1' ORDER BY p.id_product ASC LIMIT 0,500'

(sensitive data redacted or omitted)

[musicmaster]

Hi Obi,

Thank you for your report. The problem only happened when you had selected subcats AND you displayed the position field. I have fixed it in the attached file.

M

product-edit.php

[Obi]

23 minutes ago, musicmaster said:

Hi Obi,

Thank you for your report. The problem only happened when you had selected subcats AND you displayed the position field. I have fixed it in the attached file.

M

product-edit.php 166.16 kB · 0 downloads

That fixed it - Thanks!

[Obi]

On 8/20/2024 at 10:01 AM, Obi said:

---SNIP FOR BREVITY--- 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.

1) Maybe I am missing it buried in all the features - but is there a place to export all of the product information into a csv (so I can move items in a category between websites/servers)?

2) I still have the issue of VAT showing up in the product-sort.php list even though I have removed both "VAT" fields from the first array line (in settings1.php) - is there somewhere else that VAT and/or VAT Price need to be turned off?

I need to correct the above - when I remove "VAT" and "VAT Price" from the array, I get an error - "You are using an old version of settings1.php. Please update it!" - so how do I remove those items from output, specifically product-sort.php? (I have defaults setup in settings1.php that seem to work fine on the product-edit.php output but seem to be ignored in product-sort.php output.)

3) I want to purchase Tags and Supplier plugins, but I am also considering Carriers plugin and maybe Discounts (I can't find one for Warehousing)... is there a way to see a demo of the last 2(3) and is it possible to get a bundle of only the plugins that I want instead of the whole enchilada option?

Thanks!

Edited September 17 by Obi
update/correction

[musicmaster]

Quote

1) Maybe I am missing it buried in all the features - but is there a place to export all of the product information into a csv (so I can move items in a category between websites/servers)?

I doubt whether you ever will see such a function. With discounts, carriers, etc the product information is enormously complex. The product-edit page has a csv export function and if you have concrete demands we can look.

Quote

2) I still have the issue of VAT showing up in the product-sort.php list even though I have removed both "VAT" fields from the first array line (in settings1.php) - is there somewhere else that VAT and/or VAT Price need to be turned off?

Makes me wonder what you are doing. I have uploaded a new version. Maybe it helps.

Quote

I need to correct the above - when I remove "VAT" and "VAT Price" from the array, I get an error - "You are using an old version of settings1.php. Please update it!" 

People like to preserve their settings1.php when they upgrade. But that is not a good idea when new fields have been added. So you need to take the new settings file and enter your credentials and choices in it.

Quote

 I want to purchase Tags and Supplier plugins, but I am also considering Carriers plugin and maybe Discounts (I can't find one for Warehousing)... is there a way to see a demo of the last 2(3) and is it possible to get a bundle of only the plugins that I want instead of the whole enchilada option?

When you enable the field you see how it will look like and how it works. The only thing that doesn't work is the submit. I don't understand what you mean when you ask for a demo.

Most people who buy the package use some plugins more than others. That is one of the reasons why it is much cheaper than the sum of the parts.

 

 

[Obi]

2 hours ago, musicmaster said:

I doubt whether you ever will see such a function. With discounts, carriers, etc the product information is enormously complex. The product-edit page has a csv export function and if you have concrete demands we can look.

I am looking for a basic product export with all the fields on the information tab, the price and wholesale price values, the 3 SEO fields on the SEO tab, the Associations tab fields, Shipping Tab fields, Quantity Tab fields, and Suppliers Tab information.

Warehouse info would probably be too much to hope for - but mentioned here just in case.

I could definitely live without being able to export sales/specials data, but maybe if the basics (default options available under a default install of TB1.4?) were available?

2 hours ago, musicmaster said:

People like to preserve their settings1.php when they upgrade. But that is not a good idea when new fields have been added. So you need to take the new settings file and enter your credentials and choices in it.

I used the new version settings1.php file and only changed settings from within the new file since this installation is on a beta site at present.

/* the following array determines which fields are shown in the search block of product-edit */
/* pack_stock_type was new in version 1.6.0.12. New fields in 1.7 are isbn, state, show_condition */
/* sosh_title and sosh_description (social_sharing) were present in the first 1.7 version but not later */
/* new in 1.7.3 were low_stock_threshold, additional_delivery_times, delivery_in_stock,delivery_out_stock, low_stock_alert */
/* new in 1.7.7 was mpn */
/* it is recommended that when you delete some of the fields you keep an outcommented copy of the original */
$productedit_fieldblock = Array(
	Array("name","VAT","priceVAT","reference","link_rewrite","description","description_short","meta_title","meta_keywords","meta_description"),
	Array("quantity","price","category","wholesaleprice","position","manufacturer","virtualp","availorder","on_sale","online_only"),
	Array("ean","image","date_upd","minimal_quantity","shipweight","shipheight","shipwidth","shipdepth","aShipCost","attachmnts"),
	Array("upc","active","date_add","visibility","condition","pack_stock_type","reserved","customizations","indexed","indexes"),
	Array("unity","unitPrice","unitPRatio","available_now","available_later","available_date","stockflags","warehousing","redirect","out_of_stock"),
    Array("isbn","state","show_condition","aDeliveryT", "deliInStock","deliOutStock","ls_threshold", "ls_alert","location","mpn"),
	Array("ecotax"),
	Array("tags","shopz","carrier","discount","accessories","combinations","supplier","featureEdit","features","statistics")
	);

I only removed "VAT","priceVAT", from the array string and I get the green error screen:

2 hours ago, musicmaster said:

When you enable the field you see how it will look like and how it works. The only thing that doesn't work is the submit. I don't understand what you mean when you ask for a demo.

duh... I feel stupid for not even clicking the button. "Some fields (supplier,image) are in demo mode. You can buy plugin(s) to use them at Prestools.com." I ASSumed that they were non-functional so what was the point. ¯\_(0.0)_/¯

2 hours ago, musicmaster said:

Most people who buy the package use some plugins more than others. That is one of the reasons why it is much cheaper than the sum of the parts.

Sooo... Whole enchilada or pay the individual prices. Had to ask. 🙂

Edited September 18 by Obi

[Obi]

Ok, purchased what I need for now... I'll let you know if any problems once I get around to using them.

[Obi]

19 hours ago, Obi said:

Ok, purchased what I need for now... I'll let you know if any problems once I get around to using them.

Works like a charm!

[musicmaster]

20 hours ago, Obi said:

I am looking for a basic product export with all the fields on the information tab, the price and wholesale price values, the 3 SEO fields on the SEO tab, the Associations tab fields, Shipping Tab fields, Quantity Tab fields, and Suppliers Tab information.

Warehouse info would probably be too much to hope for - but mentioned here just in case.

This is useless for me. I need concrete pictures and data that show both the present output and what changes you would like to see.