Metro Style Dashboard Menu for Elgg

Elgg provides by default a dashboard menu, where your users can add or remove widgets. It is a pretty basic dashboard with some useful information. However what if you want to give the dashboard a better user interface? How can you do that? In this article I will give you a step by step guide on how to enhance your Elgg network with a Metro Style Dashboard Menu Learn More

Tags: , , , , , , , , , , , , , , , , | Posted under Elgg | Leave a comment

[TomatoCart] Show a brand column in the products grid

In this article, I will teach you how to show a brand column in the products grid like shown below:

Snip20141221_1

It’s easy to apply the same change for your store admin panel. Please complete the following steps to achieve it.

Step 1. Open products.php under admin > includes > jsons fold and then find following code snippet:

if ( $current_category_id > 0 ) {
        $osC_CategoryTree = new osC_CategoryTree_Admin();
        $osC_CategoryTree->setBreadcrumbUsage(false);
    
        $in_categories = array($current_category_id);
    
        foreach($osC_CategoryTree->getTree($current_category_id) as $category) {
          $in_categories[] = $category['id'];
        }
    
        $Qproducts = $osC_Database->query('select distinct p.products_id, p.products_type, pd.products_name, p.products_sku, p.products_quantity, 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 = :language_id and p.products_id = p2c.products_id and p2c.categories_id in (:categories_id)');
        $Qproducts->bindTable(':table_products_to_categories', TABLE_PRODUCTS_TO_CATEGORIES);
        $Qproducts->bindRaw(':categories_id', implode(',', $in_categories));
      } else {
        $Qproducts = $osC_Database->query('select p.products_id, p.products_type, pd.products_name, p.products_sku, p.products_quantity, 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 where p.products_id = pd.products_id and pd.language_id = :language_id');
      }

Replace it with:

if ( $current_category_id > 0 ) {
        $osC_CategoryTree = new osC_CategoryTree_Admin();
        $osC_CategoryTree->setBreadcrumbUsage(false);
    
        $in_categories = array($current_category_id);
    
        foreach($osC_CategoryTree->getTree($current_category_id) as $category) {
          $in_categories[] = $category['id'];
        }
    
        $Qproducts = $osC_Database->query('select distinct p.products_id, p.products_type, pd.products_name, p.products_sku, m.manufacturers_name, p.products_quantity, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from :table_products p left join :table_manufacturers m on p.manufacturers_id = m.manufacturers_id, :table_products_description pd, :table_products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = :language_id and p.products_id = p2c.products_id and p2c.categories_id in (:categories_id)');
        $Qproducts->bindTable(':table_products_to_categories', TABLE_PRODUCTS_TO_CATEGORIES);
        $Qproducts->bindRaw(':categories_id', implode(',', $in_categories));
      } else {
        $Qproducts = $osC_Database->query('select p.products_id, p.products_type, pd.products_name, p.products_sku, m.manufacturers_name, p.products_quantity, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from :table_products p left join :table_manufacturers m on p.manufacturers_id = m.manufacturers_id, :table_products_description pd where p.products_id = pd.products_id and pd.language_id = :language_id');
      }

Find following code:

$Qproducts->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);

Add following code after it:

$Qproducts->bindTable(':table_manufacturers', TABLE_MANUFACTURERS);

Find following code:

'products_sku'	=> $Qproducts->value('products_sku'),

Add following code after it:

'products_brand'   => $Qproducts>value('manufacturers_name') ? $Qproducts->value('manufacturers_name') : '--',

Step2. Open products_grid.php under admin > includes > extmodules > products fold.

Find following code:

{name: 'products_sku'},

Add following code after it:

{name: 'products_brand'},

Find following code:

{header: "<?php echo $osC_Language->get('table_heading_sku'); ?>", align: 'center', sortable: true, dataIndex: 'products_sku', width: 80},

Add following code after it:

{header: "<?php echo $osC_Language->get('table_heading_brand'); ?>", align: 'center', sortable: true, dataIndex: 'products_brand', width: 80},

Step 3. Open products.php under admin > includes > languages > en_US fold.

Find following code:

table_heading_sku = SKU

Add following code after it:

table_heading_brand = Brand

Note: if you are using the other language rather than English, please just open the same file under the language file to add above code.

Okay now. When you access the products module in the admin panel, you will see a brand column shown in it.

Looking for quality TomatoCart hosting? Check out Arvixe Web Solutions.

Tags: , , , , | Posted under TomatoCart | 1 Comment

How to add a rental product in nopCommerce

Many nopCommerce users have been requesting the rental feature in nopCommerce for a long time. Finally, with the release of nopCommerce 3.50, this “in-demand” feature has been added  to nopCommerce solution.

Today we will be discussing, how to add a rental product in nopCommerce.

Go to Administration > Catalog > Products > Manage Products

Now, add a new product.

In the new product details page, provide the details of this new rental product. At the bottom, you will see this setting: Is Rental: [CHECK]

Note: Check if this is a rental product (price is set for some period). Please note that inventory management is not fully supported for rental products yet. It’s recommended to set ‘Manage inventory method’ to ‘Don’t track inventory’ now.

Once the enable the rental product, you will see different options:

Rental period length: Specify period length for rental product. Price is specified for this period.

Rental period: Specify period for rental product. Price is specified for this period.

After adding a rental product successfully in the database, your product will look like this:

 

Looking for quality nopCommerce Web Hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , | Posted under nopCommerce | Leave a comment