Anil Paul

Web Developer – Designer

About Me

Here are some things that you should know about me.

Anil Paul

Web Developer
I am a web developer based in Melbourne , Australia. I used to create stylish, dynamic and accessible websites for all kinds of clients, from individuals and small companies, to large high-profile and social networking websites.My interests are anything web/online related .. I enjoy web development and its a huge part of my life.

Services

Things that I work on.

Skills

Things that I'm good at.

PHP
90%
MySQL
90%
JQuery
90%
HTML
90%
CSS
90%
Magento
80%
Zend
80%
WordPress
80%
Nginx
60%
Apache
70%
Ansible
40%

Blog

My thoughts.

Magento Collections Store Filter

Product Collection

Category Collection First we should retrieve the Root Category of the Store. $rootCategoryId = $store->getRootCategoryId(); Then set Store for the collection, and add the attributes you want to select

As you can see I am joining the collection with url rewrite table to retrieve the category url for the store. $collection->getSelect()->joinLeft( […]

Magento Store wise Month wise Price wise Qty Sales Report

movie Bolshoi 2017 streaming

VBA Excel Function to vlookup for comma separated values in a cell

Use this function to vlookup for a key in a key value range. Example =ListValues(E5,Categories!A$2:B$243,2)

Magento Category Sales Report

For generating Category wise sales report from the magento database you can use following query.