Bulk Price Editor is Empty

Phoca Cart - complex e-commerce extension
TechMistress
Phoca Enthusiast
Phoca Enthusiast
Posts: 54
Joined: 27 May 2015, 21:24

Bulk Price Editor is Empty

Post by TechMistress » 20 Jun 2022, 18:21

Hello, is there something I'm doing wrong? When I click on the Bulk Price Editor, there are no products listed. Thanks!

Joomla 3.10.9, PhocaCart 3.5.8

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 45190
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Bulk Price Editor is Empty

Post by Jan » 21 Jun 2022, 11:55

Hi, where exactly are not listed the products? Can you paste a screenshot?

Jan
If you find Phoca extensions useful, please support the project

TechMistress
Phoca Enthusiast
Phoca Enthusiast
Posts: 54
Joined: 27 May 2015, 21:24

Re: Bulk Price Editor is Empty

Post by TechMistress » 23 Jun 2022, 23:35

When you click "Bulk Price Editor". However, it's starting to dawn on me that what I would see in that screen are bulk pricing rules that I've CREATED, yes?

I thought that it would show a list of products that I could select to update, but if I understand it, I add a NEW rule to update pricing. Do I have it right?

Thank you!

User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 8203
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Bulk Price Editor is Empty

Post by Benno » 24 Jun 2022, 07:56

Hi,
I thought that it would show a list of products that I could select to update, but if I understand it, I add a NEW rule to update pricing. Do I have it right?
Yes, you are right!

See images of this example:
Image

Image

Image

Image

Image

User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 8203
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Bulk Price Editor is Empty

Post by Benno » 24 Jun 2022, 07:57

Image

Kind regards,
Benno

TechMistress
Phoca Enthusiast
Phoca Enthusiast
Posts: 54
Joined: 27 May 2015, 21:24

Re: Bulk Price Editor is Empty

Post by TechMistress » 24 Jun 2022, 18:08

Ok, so my next question is - if I want to change, for example, the price of all products that are currently "$10" to be "$20", no matter what category they may be in, is there a way to do that? To set the price edit by current price, rather than by choosing categories?

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 45190
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Bulk Price Editor is Empty

Post by Jan » 27 Jun 2022, 16:21

Hi, for now there is no such rule, so this is maybe better to do directly in databse where you edit all the products where the proice is 10 to be 20.

Code: Select all

UPDATE phocacart_products SET price = "20.0000" WHERE price = "10.0000"
Jan
If you find Phoca extensions useful, please support the project

TechMistress
Phoca Enthusiast
Phoca Enthusiast
Posts: 54
Joined: 27 May 2015, 21:24

Re: Bulk Price Editor is Empty

Post by TechMistress » 01 Jul 2022, 00:04

Great idea, thanks!

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 45190
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Bulk Price Editor is Empty

Post by Jan » 01 Jul 2022, 16:29

Ok
If you find Phoca extensions useful, please support the project

Post Reply