Prestools - the free mass edit toolset

[Obi]

1 hour ago, musicmaster said:

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.

I'll see what I can put together.

[Obi]

I found something else that isn't in the free version, but cannot find a plugin for it - warehousing - does this exist as a plugin?

Edited September 20, 2024 by Obi

[musicmaster]

7 hours ago, Obi said:

I found something else that isn't in the free version, but cannot find a plugin for it - warehousing - does this exist as a plugin?

Prestools doesn't support warehousing. That is a limitation. Few people use that, it is complex and its functionality has been reduced In Prestashop 1.7.

[Obi]

On 9/20/2024 at 3:31 AM, musicmaster said:

Prestools doesn't support warehousing. That is a limitation. Few people use that, it is complex and its functionality has been reduced In Prestashop 1.7.

I use it so I can enter a location where products are physically stored - one site I manage has over 20k products - makes it much easier to find in the warehouse when picking. The inventory however has been set to local tracking as the warehouse tracking is quite complicated (and a pita) as you have stated. I have a site that will be going live next year that is tied to a brick and mortar store that also has a remote warehouse, so this feature will be instrumental in being able to tell a customer "yes we have it and it will be here tomorrow" or "yes we have it, and it is located on wall section A7 - let me show you".

[musicmaster]

15 hours ago, Obi said:

I use it so I can enter a location where products are physically stored - one site I manage has over 20k products - makes it much easier to find in the warehouse when picking. The inventory however has been set to local tracking as the warehouse tracking is quite complicated (and a pita) as you have stated. I have a site that will be going live next year that is tied to a brick and mortar store that also has a remote warehouse, so this feature will be instrumental in being able to tell a customer "yes we have it and it will be here tomorrow" or "yes we have it, and it is located on wall section A7 - let me show you".

I understand that it would be useful for you. But it would be a lot of work for me. So I would need to charge you some money to add it. You can pm me if you want a custom addition.

[bhtoys]

Maybe I've missed it, but is it possible to change the weight and height of all items in one category at the same time?

[musicmaster]

1 hour ago, bhtoys said:

Maybe I've missed it, but is it possible to change the weight and height of all items in one category at the same time?

Yes. Note that there are two widths, weights, etc. One is a field in ps_product used for shipping. The other is a feature.

The fields used for calculating shipping costs have been called shipwidth, shipheight, etc in Prestools

[bhtoys]

17 minutes ago, musicmaster said:

Yes. Note that there are two widths, weights, etc. One is a field in ps_product used for shipping. The other is a feature.

The fields used for calculating shipping costs have been called shipwidth, shipheight, etc in Prestools

Got ya. However I'm still doing it manually per item... there's no option to click ALL and give them all the same size / weight for shipping?

[musicmaster]

3 minutes ago, bhtoys said:

Got ya. However I'm still doing it manually per item... there's no option to click ALL and give them all the same size / weight for shipping?

You can do that with mass edit.

[Obi]

Is there a way to add a color to the block where qty is displayed if the quantity value is 0 or less? ...or maybe pink if it is less than qty 1, and green if it is 1 or greater?

I found a "lookup" in the code for what appears to be "remaining quantities" but not quite sure how that does anything, and since I don't believe that it's related to the point, I just moved on.

[musicmaster]

16 hours ago, Obi said:

Is there a way to add a color to the block where qty is displayed if the quantity value is 0 or less? ...or maybe pink if it is less than qty 1, and green if it is 1 or greater?

I found a "lookup" in the code for what appears to be "remaining quantities" but not quite sure how that does anything, and since I don't believe that it's related to the point, I just moved on.

I will think about it. But at the moment I don't see how to do this without making the page more confusing.

I don't know what you refer to in your second paragraph.

[Obi]

5 hours ago, musicmaster said:

I will think about it. But at the moment I don't see how to do this without making the page more confusing.

I don't know what you refer to in your second paragraph.

Thank You.

I'm pretty sure it was in some part of the product-edit.php file, but I've since closed all files related and don't really have the time to go back and sift through that code atm. I simply want to create a visual marker that can quickly identify in the product listing when an item is out of stock. I really don't want to use warehouse stock mgmt, which might actually solve this issue, but that feature seems to make everything more complicated.

I don't know why these combination items have highlighting in the qty column, because none of the single items in this category do. I've also noticed yellow previously but haven't been able to locate any lists that have that qty coloring so far since the newest upgrade. (Not sure the latest upgrade has anything to do with that, just mentioning it in case it jogs your memory about something.)

I'm using your tool to manage a database of 20k plus products in place of the eMagicOne PrestaStore Manager software. I have tried to reactivate that software on my new laptop, but they have stated I must essentially purchase the software again, even though my current license is a 2-seat license and supposed to be "lifetime". They're based in Ukraine, so no point in trying to pursue any other action than ending the use of their software.

The Prestools product has been helpful in numerous ways to this end, but so far, it's been some of the "little things" that have been the stumbling block to meaningful utilization in this endeavor.

[musicmaster]

On 1/12/2025 at 8:33 PM, Obi said:

Thank You.

I'm pretty sure it was in some part of the product-edit.php file, but I've since closed all files related and don't really have the time to go back and sift through that code atm. I simply want to create a visual marker that can quickly identify in the product listing when an item is out of stock. I really don't want to use warehouse stock mgmt, which might actually solve this issue, but that feature seems to make everything more complicated.

I don't know why these combination items have highlighting in the qty column, because none of the single items in this category do. I've also noticed yellow previously but haven't been able to locate any lists that have that qty coloring so far since the newest upgrade. (Not sure the latest upgrade has anything to do with that, just mentioning it in case it jogs your memory about something.)

I'm using your tool to manage a database of 20k plus products in place of the eMagicOne PrestaStore Manager software. I have tried to reactivate that software on my new laptop, but they have stated I must essentially purchase the software again, even though my current license is a 2-seat license and supposed to be "lifetime". They're based in Ukraine, so no point in trying to pursue any other action than ending the use of their software.

The Prestools product has been helpful in numerous ways to this end, but so far, it's been some of the "little things" that have been the stumbling block to meaningful utilization in this endeavor.

The yellow background is for products with the depends_on_stock flag set. 

It puzzles me a bit why someone would depend on a background color to see that a product is out of stock. A search for products with quantity lower than 1 would seem much easier. But I can add it as an option if you want.

[Obi]

5 hours ago, musicmaster said:

The yellow background is for products with the depends_on_stock flag set. 

It puzzles me a bit why someone would depend on a background color to see that a product is out of stock. A search for products with quantity lower than 1 would seem much easier. But I can add it as an option if you want.

It's only an indicator. When your category lists (my site has over 1,000 categories) contain as many as 500 items AND you want a quick visual scan to see if you are out of stock of anything in a particular category while preparing a purchase order, having some sort of color indicator for out-of-stock items will make it easier to spot those items for those of us with older eyes.

This is the best we can hope for since there is no "desired stock level", "reorder point" or "reorder qty" fields in a product inventory or stock_reorder table. I've tried to use the "Stock Coverage" capability built into the Advanced Stock Mgmt feature of Prestashop, but to be frank, I find it woefully inadequate for the purpose it is supposed to perform.

Since most people don't run stores my size, I can only assume it was more important for Prestashop to focus on making their product incompatible with previous versions - which is why I have 2 beta sites running TB. The migration of the main site I operate, which must contain all current features of the existing PS website, to TB has basically been stalled for over a year now. But I digress...

Your tool has afforded a much improved ability to perform mass-edits on things, similar in outcome to what the eMagicOne PrestaStore Manager application provided in the way of inventory/stock management. It just needs a tweak here or there as I find ways to use your tool to make my ecommerce life easier!

My next Prestools purchase will likely be the "special prices" plugin.

[datakick]

16 hours ago, Obi said:

This is the best we can hope for since there is no "desired stock level", "reorder point" or "reorder qty" fields in a product inventory or stock_reorder table. I've tried to use the "Stock Coverage" capability built into the Advanced Stock Mgmt feature of Prestashop, but to be frank, I find it woefully inadequate for the purpose it is supposed to perform.

I don't want to spam this topic with off-topic, so just quickly -- there is a Purchases module that can quite nicely handle the purchase orders. It's intended to be used with (upcoming) warehouse management system, but can be used separately as well