Geek Answers Handbook

Magento bulk action solution and problems with a lot of records?

Magento currently has a problem with how it handles bulk actions. It returns a JS bit that contains an EVERY db id for the current collection and filter, regardless of pagination. This is necessary for the "Select All" and "Select All Visible" options in the grid header. This is not such a problem when you have fewer records, but if you have 850k records (in this case orders), this becomes a serious problem.

My question is: does anyone have an elegant solution to this problem?

I can think of several solutions, each of which has its own drawbacks, but I hope someone solved it in a simple way, which works as an additional module. Paid or open source solutions are welcome offers.

Clarification:

I am looking for an elegant / drop -in solution to the 850k + record problem using a grid widget in Magento. Magento's stock code forces the bone solution to return an identifier for each record that matches the current filter, even if they are not displayed. This is not about offline processing of records, but about using a grid widget for daily administrator tasks.

One possible solution is to save the results of the filtered search in the temp table and return a link to the search result. You can then modify it using the actual identifiers in "Select All" to use a specific callback for the action using the link. This will save the current behavior.

So, to ask again, does anyone have a good solution for the one already created?

+5
source share
4 answers

Well, the least invasive solution to the problem is to disable the “Select All” option for grids with a lot of records. This is easy to do by expanding the grid class and adding the following code:

protected function _prepareMassaction()
{
    $this->getMassactionBlock()->setUseSelectAll(false);
    return parent::_prepareMassaction();
}
+3
source

script. ( , ), , . product_iterator script , x ( ).

+6

, fbmc . , 850 . , , . script, , . SQL.

, . .

, !

,

+1

I recently wrote an article “Adding a new bulk action to the admin grid in Magento”,
I hope you like it:
http://www.blog.magepsycho.com/adding-new-mass-action-to-admin-grid-in-magento /

It describes two ways to add Mass Action
1> Extend grid layouts _prepareMassaction () method
2> Use the event: core_block_abstract_prepare_layout_before (a more efficient update option)

Thank you Relationship

0
source

More articles:


All Articles