StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20726888
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-12-22T06:31:47
FavoriteCount
0
LastActivityDate
2014-05-02T07:57:50.777
LastEditDate
2014-05-02T07:57:50.777
LastEditorUserId
1577396
OwnerUserId
1577396
ParentId
20655597
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
After searching for a long time and failing to extract a solution from mage core files, I created an attribute which does the same as <code>status</code> attribute. I named that attribute as <code>Archive</code> (Yes/No). This new attribute will justify whether a product is discontinued or not. Atlast, I filter all my product listing, product details and home page related to this new attribute <code>Archive</code> only. I am planning to write a MVC action, which will change all the products <code>status</code> as <code>enabled</code> and at the same time triggering the <code>Archive</code> as yes for the <code>status = disabled</code> products. I will share the code here soon. Code: Write a dummy controller which runs the following code when the url is called: <pre><code>public function updateproductsAction() { Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID); $collectionConfigurable = Mage::getResourceModel('catalog/product_collection') ->addAttributeToFilter('type_id', array('eq' => 'configurable')) ->addAttributeToFilter('entity_id', array('gt' => 0)); // This line should be removed to affect all the configurable products. (to avoid execution time-out) echo 'Total are ' . count($collectionConfigurable) . ' '; $i = 1; foreach($collectionConfigurable as $p) { $product = Mage::getModel('catalog/product')->load($p->getId()); $product->save(); echo $i++ . ') The product Id with ' . $p->getId() . " is done...." . " "; // if the execution time-out occurs, note down the last product id and change the value above in addAttributeToFilter. so the execution runs from the last stopped product. } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POShow deactivated/disabled products in comparison view
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMr_Green
UserOwnerUserId
1. USMr_Green
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POShow deactivated/disabled products in comparison view
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.