Magneto 2 runs approximately 20% faster than Magento 1, which can lead to improved SEO and increased sales. All of the content from a static page can be cached, thus increasing site performance and drastically reducing the server load. This makes the Magento 2 platform more scalable for large eCommerce stores.
Iam a Wfm Scheduler in Conduent business services india LLP. As an scheduler, I am the responsible to check and create each and evey schedule assigned in the operations for the business line. This blog explains about Magento only.
Add code
Thursday 1 October 2020
Wednesday 30 September 2020
Magento 1.9 Import products issue
Question:
I am trying to import some products, Magento performs everything right, but when I look at the catalog, there is no imported product
Starting profile execution, please wait...
Warning: Please do not close the window during importing/exporting data
Starting Mage_Dataflow_Model_Convert_Parser_Csv :: parse
Found 453 rows.
Starting catalog/convert_adapter_product :: parse
Processed 100% 453/453 records
Imported 453 records
Please wait while the indexes are being refreshed.
Finished profile execution.
The message below shows that it was 100% successful, but there is no product.
One Possible Solution:
It seems a Re-index issue.
Please run the following commands
php bin/magento indexer:reindex
php bin/magento cache:flush
Thursday 31 May 2018
Magento 1 : Hide other shipping methods when free shipping is available
Open :
/app/design/frontend/[Your_package]/[Your_theme]/template/checkout/onepage/shipping_method/available.phtml
<?php
if ( array_key_exists('freeshipping', $_shippingRateGroups )) {
unset($_shippingRateGroups["flatrateperproduct"]);
}
?>
Then , flatrateperproduct Method will be remove from the shipping method.
Tuesday 15 May 2018
How to add Buy Now At Product Page in Magento - 1 version ?
/app/design/frontend/[package name]/[themename]/template/ajaxcart/catalog/product/view/addtoCart.phtml
<button type="button"
/app/design/frontend/[package name]/[theme name]/template/catalog/product/view.phtml
Saturday 1 July 2017
How to add custom attribute for category
Step : 1 app\etc\modules\TEJA_Dbchange.xml
<?xml version="1.0"?>
<config>
<modules>
<TEJA_Dbchange>
<active>true</active>
<codePool>local</codePool>
</TEJA_Dbchange>
</modules>
</config>
Step : 2 app\code\local\TEJA\Dbchange\etc\config.xml
<?xml version="1.0"?>
<config>
<modules>
<TEJA_Dbchange>
<version>0.1.0</version>
</TEJA_Dbchange>
</modules>
<global>
<resources>
<teja_dbchange_setup>
<setup>
<module>TEJA_Dbchange</module>
<class>Mage_Catalog_Model_Resource_Eav_Mysql4_Setup</class>
</setup>
</teja_dbchange_setup>
</resources>
</global>
</config>
Step : 3 app\code\local\TEJA\Dbchange\sql\teja_dbchange_setup\mysql4-install-0.1.0.php
<?php
$installer = $this;
$installer->startSetup();
$attribute = array(
'group' => 'General',
'input' => 'select',
'type' => 'int',
'label' => 'Testing',
'source' => 'eav/entity_attribute_source_boolean',
'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
'visible' => 1,
'required' => 0,
'visible_on_front' => 0,
'is_html_allowed_on_front' => 0,
'is_configurable' => 0,
'searchable' => 0,
'filterable' => 0,
'comparable' => 0,
'unique' => false,
'user_defined' => false,
'default' => '0',
'is_user_defined' => false,
'used_in_product_listing' => true
);
$installer->addAttribute('catalog_category', 'testing', $attribute);
$installer->endSetup();
?>
Step : 4 After refresh all magento cache by going System -> Cache Management
Step : 5 Logout and login again.
Wednesday 21 June 2017
What is the difference between convention and configuration?
- Configuration - would have been manually mapping controllers to use specific views, almost like a code behind scenario.
- Convention - A Controller method named Index most likely wants to use a View called the same, so the framework goes and looks for that.
Wednesday 14 June 2017
Difference among Order Invoice, Cancel, Void, Hold and Ship in Magento
Processing - You are raise a invoice from Magento admin status is change to
On Hold - This status can only be assigned manually. You can put any order on hold.
Cancelled - This status is assigned manually by you or, on some payment gateways, when customer does not pay within the specified time.
Complete - This status means that order is crated, paid and shipped to customer.
Closed - Closed orders are orders that have had a credit memo assigned to it and the customer has been refunded for their order.
Pending Payment - This is the status used if order is created and PayPal or similar payment method is used. This means that customer has been sent to payment gateway website but no return information has been received yet. This status will change when customer pays. Some gateways do cancel abandoned orders automatically after some 'idle' time. If order had this status for a long time, you should cancel it manually to free product stock.
Wednesday 22 March 2017
How to access localhost website from another computer on the same network?
- Set up a virtual host
- Configure your hosts file
httpd-vhosts.conf
file. On XAMP, you can find this file here: C:\xampp\apache\conf\extra\httpd-vhosts.conf This step
prepares the Web server on your computer for handling symfony.local
requests. You need to provide the name of the Virtual Host as well as
the root/main folder of your website. To do this, add the following line
at the end of that file. You need to change the DocumentRoot
to wherever your main folder is. Here I have taken /Applications/MAMP/htdocs/Symfony/
as the root of my website.<VirtualHost *:80>
DocumentRoot "/Applications/MAMP/htdocs/Symfony/"
ServerName symfony.local
</VirtualHost>
Configure your hosts file:
For the browser understand what symfony.local
really means,
you need to edit the hosts file on your computer.
(if you're using WINDOWS 7, this file is in
\Windows\system32\drivers\etc\hosts
).
## # Host Database # localhost is used to configure the loopback interface ## #... 127.0.0.1 symfony.local
Thats it. Now the configuration is completed.
Note: you should replace the above ip address with your system ip address.Finally, you have to change the base secure and unsecure urls in
database at
core_config_data table.
Then your url will be change from http:localhost/projecttohttp://127.0.0.1/project.
Tuesday 21 March 2017
Warning: a form on this page has more than 1000 fields PHP MySql
Warning: a form on this page has more than 1000 fields PHP MySql
After reaching so many entries PhpMyAdmin started showing this warning:
Warning: a form on this page has more than 1000 fields. On submission, some of the fields might be ignored, due to PHP's max_input_vars configuration.
Solution:
For this, I have added the following lines at the bottom of php.ini file.
max_input_vars = 5000
suhosin.request.max_vars = 5000
suhosin.post.max_vars = 5000
Saturday 18 March 2017
Magento Vs Open cart
Generally, Magento and OpenCart actually have a lot in common.
1. They are both open source platforms that are ultimately designed to facilitate eCommerce activity.
2. Both are developed in PHP and use templates to upload products, so they can be maintained by non-programmers.
3. They are also rich in resources such as extensions, add-on products and plugins that can easily be added to them to support new functions.
4. One of the greatest advantages that both Magento and Open Cart users enjoy is their ability to support multiple languages and currencies, making them a global solution that can suit businesses all around the world.
Some Market Share Figures
In terms of Market share,
1. Magento is definitely bigger, with about 30% of top eCommerce websites being built on Magento, making it the largest eCommerce platform in the world.
2. Open cart may be a lot smaller and newer on the market, but that doesn’t mean it falls in quality.
3. Magento is the most popular open source e-commerce platform among sites ranking in the top 1,000,000 such websites in the world.
4. Only when counting all open source e-commerce websites in the entire Internet does Magento fall to second behind Open Cart.
Hosting Plans and Options
1. Open cart in this case will be cheaper to host thanks to its light weight, and will tend to work better for small to medium size stores.
2. Magento performs better in hosting medium to large sized business websites.
Usage and Features
Magento :
- Magento has been gaining world wide recognition for its ability to do just about anything you like and build the store of your dreams.
- It offers highly customizable shopping experiences, unlimited design options, powerful SEO resources and unlimited plugins and integrations.
- Every feature you can think of was probably built already and is available on MagentoCommerce. If its not on there, then surely a talented and certified Magento developer can create that solution for you.
- With it’s flexibility comes also its complexity, which probably isn’t a problem if you’re a Magento developer and know what you’re doing. If you’re not a Magento developer or if you don’t know PHP, you’ll probably find Magento a bit too complex, especially when it comes to taking advantage of its flexibility and custom features.
OpenCart :
- OpenCart on the other hand is a lot easier to program, but has a smaller community basis.
- Its great for start-ups that need to deliver quickly without many integrations.
- It provides a powerful shopping cart and some great tools which are far more intuitive and straight forward, so much so that some professional developers may find it a bit too simplistic, with not enough features to play with. It’s a bit like comparing between WordPress and Wix, or Microsoft Office Picture Manager and Adobe Photoshop.
Community Support
Both Magento and OpenCart have well-established developer communities that offer support and advice by demand, but obviously the Magento community is far more robust. Magento also certifies and recommends developers to grant them with credibility, which makes it easy to filter the advice you receive and know who you should listen to. We expect that overtime, as Opencart continues to grow, more tutorials and resources will become available, and the number of users that can provide online support will increase.
Conclusion
1. Magento is great for larger stores with larger budgets. Its got scale-ability to support the growth of your business for years to come, and support any need you may have in the future.
2. Open cart is more suitable if you’re trying to build your store independently because its more intuitive, and its (almost) free to use, but take into consideration that one day, your business may grow out of it. Whichever your choose- we wish you luck with your new business!
Top Magento Interview Questions & Answers
Magento is an e-commerce platform created on open source technology, which provides online merchants with an exceptional flexibility and control over the content, look and functionality of their e-commerce store.
2) Mention what is the architecture of Magento? What are the different versions of Magento?
Magento architecture is a typical PHP MVC (Model-View-Controller) application, where all the Controllers will be in one folder and all the Models in another, etc. Based on their functionality files are grouped together, which are referred as modules in Magento.
Different version of Magento includes
- Magento Enterprise
- Magento .go
- Magento Community
Magento use PHP as a web server scripting language and MySQL for database.
4) Mention what is the difference between Mage::getModel() and Mage::getSingletone() in Magento?
- Mage::getModel(): It always creates a new object
- Mage: :getSingleton(): It always look for an existing object and if not then creates a new object
Basic features of Magento includes
- Reporting and Analytics
- Product and Catalog Browsing
- Customer Accounts
- Order Management
- Payment
- Site Management
- Shipping
- Search engine optimization
- Marketing promotions and tools
- Checkout
- International Support
- Magento is supported by PHP, comparatively to other e-commerce solutions, Magento might be slow in performance
- It becomes a complex system if it is not using object-oriented programming
- Magento requires much space and memory
To enhance the Magento performance
- Disable the Magento log
- Combine external CSS/JS into one file
- Disable any unused modules
- MySQL Query Caching
- Enable Magento caching
- Enable Gzip compression
- Optimize your image
In the toolbar block you will see
app/code/core/Mage/Catalog/Block/Product/List/Toolbar.php
there is a method:
Public function setCollection($collection);
Inside there is a piece of code:
$limit= (int)$this->get Limit();
If ($limit) {
$this ->_collection->setPageSize($limit);
}
You have to change variable $limit; you should override that block in the local pool, not change directly in the core. In order to see whether the customer is a guest, you can use this code
Mage:: getSingleton(‘customer/session’) -> isLoggedIn()
9) Mention what all billing information can be managed through Magento?
From the client Magento account, you can do following things
- Update your billing address
- Add a credit card
- View your billing history
- Add a PayPal account
- Produce a print ready receipt
To change Magento Core API settings, you have to
- Go to Admin menu, choose System -> Configuration
- Select Magento Core API on the left side of the Configuration Panel, under Services
- Tap on to expand the General Settings section and you can
- Type the name of the Default Response Charset that you want to use
- Determine the Client Session Timeout in seconds
- Click the Save Config button when complete
Best practices for Magento includes
- Using a strong password and changing them at regular interval
- Disable remote access to Magento Connect Manager
- Disable Downloader on production sites
- Restrict access to safe IP addresses
In Magento, applying connect patch
- It enables easy installation of packages with installation; it overwrites any existing translations for the same time
- For enhancing security, by default Magento Connect uses HTTP to download extensions instead of FTP
- With a dash character in the name, extension developers can now create extensions
- Magento administrators will be informed now who tries to install an extension with insufficient file system privileges
To move Magento to other Directory you have to follow the following steps.
- Suppose you have Magento installed in the following location
- On visiting your site, you want Magento to be the first thing to come up
- Let assume you have a directory structure like this
- Which means Magento would be installed here
- Login to the backend of the Magento first and go to
Update the Secure and Unsecure URL for your store and then link to your site via SSH and then go to the directory, where you will be shifting Magento
cd public_html/
- Now, transfer all the files from the store directory to the directory you are in
- Delete the cache data
Now Magento is moved to another directory.
14) Explain how you can reset Magento file & Directory permissions?
You can reset Magento file & Directory to their default and secure permissions, by following commands from the directory where Magento is installed
find . –type f –exec chmod 644 {} \;
find . –type d –exec chmod 755 {} \;
chmod +x mage
15) Explain how you can configure Magento to work with another domain?
To do that, in the admin area, you have to change the Magento Base URL option. To do this, visit to your Magento admin area> System > Configuration and click Web on the left menu. Select the Unsecure option after that edit the base URL field to change the URL that will be used for normal (HTTP) connections.
16) Why to use Magento?
The uses of Magento are:
Magento is open source E-commerce software.
it is scalable and offers small companies to build business.
It provides the searching and sorting of products in several ways.
Easily integrates with many of the third-party sites which are needed to run effective E-commerce website.
Using this, customer can order or purchase number of products. There are no limits on number of purchasing products.
17) List the Web-Hosting sites of Magento?
- SiteGround
- BlueHost
- HostGator
- Inmotion
- Arvixe
- site5
- Magento uses larger disk space and memory.
- It takes much time to build the customized functionality.
- It is very slow compared to other E-commerce sites.
- It needs proper hosting environment, if the hosting environment is improper the user can face the problems.
- Apache 2.x
- Nginx 1.7.x
- Simple Products
- Grouped Products
- Configurable Products
- Virtual Products
- Bundled Products
- Downloadable Products
- Business to Business(B2B)
- Business to Consumer(B2C)
- Consumer to Consumer(C2C)
- Consumer to Business(C2B)
- Payflow Pro (Includes Express Checkout)
- Payflow Link (Includes Express Checkout)
Friday 17 March 2017
Delete All URL Rewrites In Magento-1 (Truncate all existed url i magento)
By using this following SQL Query.
- SET FOREIGN_KEY_CHECKS = 0;
- TRUNCATE TABLE `core_url_rewrite`;
- SET FOREIGN_KEY_CHECKS = 1;
Wednesday 1 March 2017
How to apply schedule for themes in magento-1 and magento-2 ?
1) Login to Admin panel
2) Go to Content > Design > Schedule
3) Click on “Add new Design” theme
4) Select the theme,start date, from date and save the design theme
Magento-2:
1) Login to Admin panel
2) Go to Content > Design > Schedule
3) Click on “Add new Design” theme
4) Select the theme,start date, from date and save the design theme
Magento : 404 error is showing admin page
Hello, Sometimes we may get the error on admin page once done with the Magento installation. In that scenario, we have to do the following: ...
-
I have tested this and worked for me on my server : INSERT INTO `directory_country_region` VALUES ( NULL , "IN" , "...
-
Warning: a form on this page has more than 1000 fields PHP MySql After reaching so many entries PhpMyAdmin started showing this warning:...
-
Hi , In this blog I’m going to explain you how to create accordion tabs in magento for layered navigation as displayed below for attribut...
-
Open your phpmyadmin from your host try once this sql command. Run this Sql : SET FOREIGN_KEY_CHECKS=0; UPDATE core_store SET store_i...
-
Step 1 : First, Optimize your Server and the System Requirements Step 2: Update your Magento 2 to the latest version of Magento 2 Step 3 ...
-
To prevent other shipping options to display when Free Shipping is available, add the following code to your template: Open : /app/des...
-
Find out the easiest way to setup Magento with SSL The private SSL certificate is an important upgrade to your website. The basic functi...
-
How to create and manage pages in Magento In order to manage your web site pages you need to navigate to the CMS section in the Magento ...
-
To create a 404 page Create a CMS Page with Correct 'Store View'. Then go to System=>Config=>General=>Web in Default ...
-
If you want both Add to Cart and Buy now, add the buy now button to addtoCart.phtml Go to /app/design/frontend/[package name]/[themen...