How to get all product list

English forums
1

Hi All,
Is there a built in function ( I have searched but couldn’t be able to find any) that can return all details of all products against a particular language? Because if I have to do this it seems very complicated task to query all tables.
I have gone through article.php, article_list.php, article_main.php but couldn’t the stuff. Please guide me how to accomplish this task.
Regards,
Awais Qarni

2

Hello Awais,

not all information of the article object are available on every page --> lazy loading :wink:
Maybe this documentation is helpful for you:
http://docu.oxid-esales.com/CE/sourcecodedocumentation/4.5.7.41909/

Try to search for getArticle and you’ll get a list.

Hope this is helpful.

3

[QUOTE=Marco Steinhaeuser;82874]Hello Awais,

not all information of the article object are available on every page --> lazy loading :wink:
Maybe this documentation is helpful for you:
http://docu.oxid-esales.com/CE/sourcecodedocumentation/4.5.7.41909/

Try to search for getArticle and you’ll get a list.

Hope this is helpful.[/QUOTE]
Macro thanks again dude. I have tried to get the article in my class using the function of aList class like this

$arttcle_list = new aList();
 $all_products = $arttcle_list->getArticleList();

Bit it returns null. I think this is dude to the fact the aList is a view class and I am accessing it in admin folder (some thing like controller). Can you tell how to access view function to any class in admin folder?

4

Just call me “El Duderino” :wink:
I reckon you have to write a getter module to achieve this.

Regards

5

Hello,
I also try to get a list of all products.

I have the feeling I will just extend oxarticlelist and add there a function loadAllProducts()…
If that works I will post it here.

Regards,
Florian

6

hello,
I just extended oxarticlelist.
the function to get all the products looks like this:

public function loadAllArticles(){
$sSelect = "select * from oxarticles ORDER BY oxartnum";
$this->selectString( $sSelect );
}

and then i putted that function in oxubase:

public function getAllArticles(){
$aArticleList = oxNew( 'oxarticlelist' );
$aArticleList->loadAllArticles();
return $aArticleList;
}

just to have it everywhere available.
unfortunately it´s not possible to extend oxubase.
maybe someone has a suggestion where i could put it instead.

kind regards,
florian