How do i change the prices/values of all the items in my catalouge?

[ludvar98]

Hi guys,

Im kinda new here!
I was wondering how to change the prices/values on the items in the catalouge, i only seem to find the staff catalouge wich is around 1000 items but there are like 7000 items in total and i cant find the other items. If someone could show me where and how that would be really helpful!

Thank you in beforehand!

 

[Hypothesis]

Locate the page ID of the page in your catalog_pages table.
Run this query:
SELECT * from catalog_items WHERE page_id = 'put your page id here'
It'll list you every item on that page in your catalog. This allows for easy editing without searching every page.

 

[ludvar98]

Locate the page ID of the page in your catalog_pages table.
Run this query:
SELECT * from catalog_items WHERE page_id = 'put your page id here'
It'll list you every item on that page in your catalog. This allows for easy editing without searching every page.

Thank you for the fast answer!
Im getting an empty page when i run the query, i used the id and parent id but id doesnt seem to work

 

[Joe]

Open your catalog items and find the item you want to change, change the price in credits, pixels or diamonds and then :update cata all

 

[ludvar98]

Open your catalog items and find the item you want to change, change the price in credits, pixels or diamonds and then :update cata all

Yeah ive already changed some prices but i its only 1000 items i can Find. How do i change page so i can edit the other prices

 

[Joe]

Yeah ive already changed some prices but i its only 1000 items i can Find. How do i change page so i can edit the other prices

The bottom right hand side of Navicat you can list all items for that table or flick the pages.

Post automatically merged: May 25, 2019

In on my phone so not much help with this.

 

[Hypothesis]

Thank you for the fast answer!
Im getting an empty page when i run the query, i used the id and parent id but id doesnt seem to work

You're only supposed to select the page_id from catalog_items, not the parent_id, parent_id is for catalog_pages.
For example, the Front Page is Page ID 1, so this is what you'd execute.
SELECT * from catalog_items WHERE page_id = 1
And it'll show all items with the page_id equal to 1.