Magento Hosting BLOG

Blog about Magento, Technologies and Hosting Service

Magento Hosting :: Add an administrator password a Magento admin user using MySQL

clock July 29, 2013 11:29 by author ben

Magento is a very powerful and fast growing ecommerce script, created by Varien. It is an open-source platform using Zend PHP and MySQL databases. Magento offers great flexibility through its modular architecture, is completely scalable and has a wide range of control options that its users appreciate.

In this section, we are going to build a MySQL script that you can use for adding a new admin account within seconds.

It is recommended to have a salted password hash ready.

Paste into the MySQL script:


Don’t forget to set your own values on lines 4-8, 26, 27.

Note: If you use Magento CE 1.3.2.4-1.4.*, remove lines 16 and 17.

Now you are ready to run script:


That is it! Now you can execute script any time you need to add admin account.

Alternatively

If you are not comfortable using script than another way can meet your needs:

1. Click Insert button to make new admin_user record. Fill out necessary fields using existing record values and this manual as template.


2. Next we need to add record to admin_role table.

Here user_id – is ID of user that we have created. parent_id is role_id of Administrators record:

Test your new admin account.



ASPHostPortal.com Proudly Announces ASP.NET MVC 5 Hosting

clock July 12, 2013 08:43 by author Mike

ASPHostPortal.com is a premiere web hosting company that specializes in Windows and ASP.NET-based hosting, proudly announces the new Microsoft product, ASP.NET MVC 5 hosting to all new and existing customers.

ASP.NET MVC 5 is the latest update to Microsoft's popular MVC (Model-View-Controller) technology - an established web application framework. MVC enables developers to build dynamic, data-driven web sites. ASP.NET MVC 5 adds sophisticated features like single page applications, mobile optimization, adaptive rendering, and more. Here are some new features of ASP.NET MVC 5:

- ASP.NET Identity
- Bootstrap in the MVC template
- Authentication Filters
- Filter overrides

“We pride ourselves on offering the most up to date Microsoft services. We're pleased to launch this product today on our hosting environment” said Dean Thomas, Manager at ASPHostPortal.com. “We have always had a great appreciation for the products that Microsoft offers. With the launched of ASP.NET MVC 5 hosting services, we hope that developers and our existing clients can try this new features.”

ASPHostPortal.com is one of the Microsoft recommended hosting partner that provide most stable and reliable web hosting platform. With the new launch of ASP.NET MVC 5 into its feature, it will continue to keep ASPHostPortal as one of the front runners in the web hosting market. For more information about new ASP.NET MVC 5, please visit http://www.asphostportal.com.

About ASPHostPortal.com:
ASPHostPortal.com is a hosting company that best support in Windows and ASP.NET-based hosting. Services include shared hosting, reseller hosting, and sharepoint hosting, with specialty in ASP.NET, SQL Server, and architecting highly scalable solutions. As a leading small to mid-sized business web hosting provider, ASPHostPortal strive to offer the most technologically advanced hosting solutions available to all customers across the world. Security, reliability, and performance are at the core of hosting operations to ensure each site and/or application hosted is highly secured and performs at optimum level.



ASPHostPortal.com Proudly Announces ASP.NET MVC 5 Hosting

clock July 12, 2013 08:38 by author Mike

ASPHostPortal.com is a premiere web hosting company that specializes in Windows and ASP.NET-based hosting, proudly announces the new Microsoft product, ASP.NET MVC 5 hosting to all new and existing customers.

ASP.NET MVC 5 is the latest update to Microsoft's popular MVC (Model-View-Controller) technology - an established web application framework. MVC enables developers to build dynamic, data-driven web sites. ASP.NET MVC 5 adds sophisticated features like single page applications, mobile optimization, adaptive rendering, and more. Here are some new features of ASP.NET MVC 5:

- ASP.NET Identity
- Bootstrap in the MVC template
- Authentication Filters
- Filter overrides

“We pride ourselves on offering the most up to date Microsoft services. We're pleased to launch this product today on our hosting environment” said Dean Thomas, Manager at ASPHostPortal.com. “We have always had a great appreciation for the products that Microsoft offers. With the launched of ASP.NET MVC 5 hosting services, we hope that developers and our existing clients can try this new features.”

ASPHostPortal.com is one of the Microsoft recommended hosting partner that provide most stable and reliable web hosting platform. With the new launch of ASP.NET MVC 5 into its feature, it will continue to keep ASPHostPortal as one of the front runners in the web hosting market. For more information about new ASP.NET MVC 5, please visit http://www.asphostportal.com.

About ASPHostPortal.com:
ASPHostPortal.com is a hosting company that best support in Windows and ASP.NET-based hosting. Services include shared hosting, reseller hosting, and sharepoint hosting, with specialty in ASP.NET, SQL Server, and architecting highly scalable solutions. As a leading small to mid-sized business web hosting provider, ASPHostPortal strive to offer the most technologically advanced hosting solutions available to all customers across the world. Security, reliability, and performance are at the core of hosting operations to ensure each site and/or application hosted is highly secured and performs at optimum level.



Magento Hosting – ASPHostPortal.com :: Optimize SEO on Your Magneto Platform

clock July 2, 2013 10:13 by author ben

The Magento eCommerce platform is sufficiently scalable, flexible and ready for your increasing online business targets. Magento is one of the most popular business e-commerce tools. Like any other web platform, Magento can and should be managed to obtain SEO (search engine optimization). This article will provide users of Magento e-commerce sites to optimize their websites for SEO.

Implement Magento Multistore carefully

One of the greatest advantages of Magento is its inherent ability to support multiple stores. A single administration and interface will manage all orders, your products and every other thing. This benefit can act negatively for search engine optimisation. Often the developers use same product description for similar products that are sold through multiple sites. Repetition of exact information on each site for these similar products means that you are duplicating yourself. This allegation becomes strong when your multiple sites use same IP block depending on the host.

Setting the header

Your Magento install will have a title of “Magento commerce” by default; you need to change it. You need to remember few things to draw traffic in your online store. Search engines put weightage on preliminary words; so putting keywords at the beginning of the page can ensure a better rank. Even those scanning search results can only view those early words. They will click on the page if the keywords are at the beginning. All people do not rely on the brand name while performing search. So select keywords carefully. If you add common keywords that may be used for a product search this will help product pages to rank in long tail searches.

Managing site images

A neglected aspect in Magento SEO is how to manage images. You will surely achieve extra traffic by writing suitable alt tags for images and sincerely deciding the name of the image files. The images will have the product title by default which you can rename with some extra effort.

Optimising the categories

The most important fields to consider when improving your Magneto Site SEO are :

Meta description: this part will appear in the search result and you need to put an attractive description in this part.

Page title: it is better to keep this section empty so that you can use category name in addition to parent categories. If you wish to customise this portion, select a title exactly similar to your input and without parent category.

URL key: Create short yet keyword rich URL. It is a good idea to avoid stop words like “and”, “for”, “the” and many others.

Specify name, metadata, title and description for each store. It is a great feature when you have a Multilanguage store.

Speed is an important Ranking and conversion factor

“How quickly your shop loads”- is a vital factor in terms of making conversion as well as SEO. Attracting people in your site is only the primary work done. Your main aim is to engage them and guide them to make purchase. However, if the pages take enough time to load; there are competitors. Modern people have time constraint and they will switch to a website that takes lesser time to load. The search engine spiders will crawl on maximum pages each day if your online shop loads quickly.

Disabled Products

A common condition that most online shop owners experience is when a popular product is disabled. It is possible that a particular product attracts much attention and thus has thousands of inbound links. When the website disabled that product, users and search engine land on a 404 error page if they clicked on the dysfunctional URL. It will be most effective from the perspective of user and search engine if they are directed to another page related to the product that no longer exists. Thus, it will create a better user experience and retain the position of search engine that the product used to hold.

 



Magento Hosting - ASPHostPortal.com :: Tips To maximize the performance of Magento

clock July 1, 2013 11:23 by author ben

Magento is a feature-rich eCommerce platform built on open-source technology that provides online merchants with unprecedented flexibility and control over the look, content and functionality of their eCommerce store. Magento’s intuitive administration interface features powerful marketing, search engine optimization and catalog-management tools to give merchants the power to create sites that are tailored to their unique business needs. many of the benefits if using Magento, including:

  • Total ecommerce solutions 
  • Open community
  • Its open source
  • Full featured
  • Out-of-the-box Features
  • Total ecommerce solutions
  • Extensions
  • Effective admin facilities
  • Flexibility
  • Easy to learn and update
  • Easy to maintain to shop owners

Here is tips to check and maximize your  store’s performance provided by Magento:

1. Load test your system under peak load scenarios. Use your holiday sales projections and predictive load testing to test your system for capacity to handle concurrent users in both browsing and buying scenarios. Predictive load testing services are available from companies such as Gomez, Concentric, and Magento’s Expert Consulting Group (ECG).

2. Enable Magento application caching features. Magento allows you to cache configuration, layouts, blocks output, translations, collections data, Web services configuration, and full pages (Full Page Caching is exclusive to Magento Enterprise Edition). All these cache types can be enabled/disabled via the Magento Admin panel and can help improve overall system performance.

3. Know your backup or failover strategy. Your System Integrator or technical support team may have created one for you, but have you reviewed it lately? Know what—and who—is involved so you can be prepared.

4. Clean up any inactive CMS pages and remove out-of-date promotions or products. The less data you have to serve up or rules you have to validate against, the faster your response times.

5. Know your scale and database replication strategy. Beyond knowing what to do if a server fails, you should have a plan in place for quickly deploying additional standby hardware to accommodate load spikes on days such as Black Friday or Cyber Monday.

6. Schedule heavy admin activity outside of peak hours. Also, refrain from flushing cache or re-indexing via the admin panel during peak traffic periods.

7. Check the timing of your scheduled processes. Be sure that back-end processes such as database backups and batched imports or exports don’t coincide with expected peak holiday hours. You don’t want to find out during an outage that routine backups brought down your system.

8. Apply catalog price rules well in advance of peak hours. Magento requires time to update price rules such as markdowns; apply the rules early to avoid slowing down your system while these updates occur.

9. Use a Content Delivery Network (CDN) to serve static content and HTML pages. CDN services (Akamai and Peer 1 Hosting are examples of two such service providers) work by storing copies of your files on servers located in datacenters around the world; the server located nearest to your site’s visitor responds to the page request. Offloading static pages, images, CSS style sheets, and Javascript files can increase your ability to serve more concurrent users during the holidays and improve your site’s overall responsiveness.

10. Archive old orders and limit your shopping cart lifespan. Unless you specify otherwise, your customers’ abandoned shopping carts will retain their items indefinitely. Set a reasonable limit on shopping cart lifetime values (such as 30 or 60 days during the holidays). Likewise, archiving order data is a manual process in Magento. Offload last season’s data to make room for more orders and transactions.

11. Disable extra functionality you’re not using. Magento is a robust and feature-rich platform. If you’re not using certain native functionality—such as wish lists or gift cards—in your store, have your SI temporarily disable these so you can realize the best possible performance. (Note: Disabling functionality must be done at the programming level.)

12. Limit the number of concurrent promotions in the system. The more promotional rules you create, the more calculations the system needs to perform at checkout—and the slower your site performance. Instead of setting up multiple promotions, try targeting specific customers using conditions. (Customer segmentation is exclusive to Magento Enterprise Edition).



About ASPHostPortal.com

We’re a company that works differently to most. Value is what we output and help our customers achieve, not how much money we put in the bank. It’s not because we are altruistic. It’s based on an even simpler principle. "Do good things, and good things will come to you".

Success for us is something that is continually experienced, not something that is reached. For us it is all about the experience – more than the journey. Life is a continual experience. We see the Internet as being an incredible amplifier to the experience of life for all of us. It can help humanity come together to explode in knowledge exploration and discussion. It is continual enlightenment of new ideas, experiences, and passions

Corporate Address (Location)

ASPHostPortal
170 W 56th Street, Suite 121
New York, NY 10019
United States

Sign in