Admin Pagination

[Guest]

Hi all,

 

Does anyone know a simple way to paginate the admin cateogry listings.

 

We have just done a bulk upload of about 80,000 products to our website and it's impossible to get in and update them because some of the categories have got so many titles it takes ten minutes for each category page to load and list on the admin side!

 

I have tried the the admin pagination contribution but it seems to have more bugs then our local wildlife reserve and does not work correctly.

 

Any ideas would be appreciated.

 

Andrew

[♥Monika in Germany]

if it were my store, I'd display products only if search was used.

[Guest]

if it were my store, I'd display products only if search was used.

 

Thank you Monika, that may not be a bad idea in the near future...

 

Would anyone know how to modify this:

$records_per_page=$lmt;
		$page_num=ceil($np/$records_per_page);
		echo "Page Number: ";
		$lim_1=0;
		$lim_2=$lmt;
		for ($i=0; $i < $page_num; $i++)	{
			$a=$i+1; 
			echo (($lim_1!=$limite_1_)? "<a href=categories.php?cPath=$cPath&limite_1=$lim_1&limite_2=$lim_2>":"<u><b>");

			echo $a;

			echo (($lim_1!=$limite_1)? "</a>":"</b></u>");

			echo (($a < $page_num)? "|":"");

			$lim_1=$lim_1+$lim_2;

 

To just display maybe the next ten or so forward and previous pages. With the admin pagination sort of working, I still have 450 pages and it does not wrap and dissapears off to the side of the screen making it a nightmare.

[Jan Zonjee]

To just display maybe the next ten or so forward and previous pages. With the admin pagination sort of working, I still have 450 pages and it does not wrap and dissapears off to the side of the screen making it a nightmare.

Would Quick Price Updates be helpful too?

[Guest]

if it were my store, I'd display products only if search was used.

 

I give up! Monika are you able to explain to me how to do this please?

 

Regards,

 

Andrew

[♥Monika in Germany]

I give up! Monika are you able to explain to me how to do this please?

 

Regards,

 

Andrew

the method I used shows your categories only ... unless you enter a search string. You will then see all search results. Of course you would make sure that you do not get 80.000 results by entering a nice search string.

 

in admin categories find the product search else clause:

 

	  $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name");

 

replace by this new else clause, that will only return 1 line if an item was highlighted on the search result page and needs to be worked on (edit, delete etc)

	  $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' and p.products_id = '" . $HTTP_GET_VARS['pID'] . "'");

 

HTH

[Guest]

the method I used shows your categories only ... unless you enter a search string. You will then see all search results. Of course you would make sure that you do not get 80.000 results by entering a nice search string.

 

in admin categories find the product search else clause:

 

Now THIS is awesome! Thank you so much this has helped me no end.

 

Cheers,

 

Andrew

[♥Monika in Germany]

Delighted to hear Andrew. Make sure your product related tables are well indexed for the expressions used in catalog joins, and 80.000 should not be a big issue. I just worked on a 300.000 one ;-) ... used this very same admin module. Always stunned to see how much stuff you guys sell ... hehe.