News:

AbanteCart v1.4.2 is released.

Main Menu

Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

Which table has products for block

Started by Sam_78, May 08, 2017, 04:15:53 PM

Previous topic - Next topic

Sam_78

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

abolabo

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)
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

Sam_78

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.

teelatrmo

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.

abigailkent1122

Not necessary to have product_id in blocks, just copy from database and paste it over your backend.

Forum Rules Code of conduct
AbanteCart.com 2010 -