AbanteCart Community

AbanteCart Development => General Discussion => Topic started by: Sam_78 on May 08, 2017, 04:15:53 PM

Title: Which table has products for block
Post by: Sam_78 on May 08, 2017, 04:15:53 PM
I am looking into Database and trying to find out which table contains the product_id to be displayed in block
Example: Featured block has 7 products so which table have this information???.. products_featured has them but I have created custom listing block and looking for their DB

I am trying to find products only if its in any block.. is there a query which I can run to find only those products who are in any of the block..
I have so many blocks so it is confusing to maintain inventory and lots of duplicate
Title: Re: Which table has products for block
Post by: abolabo on May 09, 2017, 03:52:17 AM
Hello.
For listing blocks just look into table block_descriptions for custom block contents.
If block is generic try to find controller for it, such as block/featured.php (also you can use template debug setting (system->settings->system) to define it)
Title: Re: Which table has products for block
Post by: Sam_78 on May 09, 2017, 09:19:25 AM
Thanks abolabo,
But I have many products that are not assigned in any block and are still ON(old products). Is there any easier way(query) I can run to find list of products whose status is ON and are in any block. So that I can look at them individually and turn them OFF.
Title: Re: Which table has products for block
Post by: teelatrmo on March 24, 2023, 04:08:35 AM
The template debug setting (system->settings->system) can be used to define the controller to utilize if the block is generic, like block/featured.php.
Title: Re: Which table has products for block
Post by: abigailkent1122 on May 17, 2023, 02:55:07 AM
Not necessary to have product_id in blocks, just copy from database and paste it over your backend.