How to Import/Export a Products in Magento

Step 1) Click on System –> Import/Export–>Dataflow-Profiles and you will see this

Step 2) Now After Click on Dataflow-Profiles you will see this

Step 3) Now Click on Add New Profile & it will take you on a new window

Step 4) Now fill all the details in the Columns which i fill below image.

Step 5) Now After Filling all the details click on Save and Continue Edit button

Step 6) Now if you want to Export Product just click on Run Profile in Popup button.It will take a time to download your file so just relax for a 5 minute.

Step 7 ) After All If you want to Import your Product just Follow Above step only change the Import option which i show you in a image

Advertisement

How to Clean Order database in magento

Open Putty with your default Username & Copy – Paste the below Script in it.

Run below script to clean the order database in magento

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE TABLE catalogsearch_fulltext;

TRUNCATE TABLE catalogsearch_query;

TRUNCATE TABLE catalogsearch_result;

TRUNCATE sales_bestsellers_aggregated_daily 

TRUNCATE sales_bestsellers_aggregated_monthly 

TRUNCATE sales_bestsellers_aggregated_yearly 

NOTE-Please Use Very Carefully this Script Because TRUNCATE Delete all the Orders from your DB.

TRUNCATE `sales_flat_creditmemo`;

TRUNCATE `sales_flat_creditmemo_comment`;

TRUNCATE `sales_flat_creditmemo_grid`;

TRUNCATE `sales_flat_creditmemo_item`;

TRUNCATE `sales_flat_invoice`;

TRUNCATE `sales_flat_invoice_comment`;

TRUNCATE `sales_flat_invoice_grid`;

TRUNCATE `sales_flat_invoice_item`;

TRUNCATE `sales_flat_order`;

TRUNCATE `sales_flat_order_address`;

TRUNCATE `sales_flat_order_grid`;

TRUNCATE `sales_flat_order_item`;

TRUNCATE `sales_flat_order_payment`;

TRUNCATE `sales_flat_order_status_history`;

TRUNCATE `sales_flat_quote`;

TRUNCATE `sales_flat_quote_address`;

TRUNCATE `sales_flat_quote_address_item`;

TRUNCATE `sales_flat_quote_item`;

TRUNCATE `sales_flat_quote_item_option`;

TRUNCATE `sales_flat_quote_payment`;

TRUNCATE `sales_flat_quote_shipping_rate`;

TRUNCATE `sales_flat_shipment`;

TRUNCATE `sales_flat_shipment_comment`;

TRUNCATE `sales_flat_shipment_grid`;

TRUNCATE `sales_flat_shipment_item`;

TRUNCATE `sales_flat_shipment_track`;

TRUNCATE `sales_invoiced_aggregated`;            # ??

TRUNCATE `sales_invoiced_aggregated_order`;        # ??

TRUNCATE `log_quote`;

ALTER TABLE `sales_flat_creditmemo_comment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_creditmemo_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_creditmemo_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice_comment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_order_status_history` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment_comment` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1;

ALTER TABLE `sales_flat_shipment_track` AUTO_INCREMENT=1;

ALTER TABLE `sales_invoiced_aggregated` AUTO_INCREMENT=1;

ALTER TABLE `sales_invoiced_aggregated_order` AUTO_INCREMENT=1;

ALTER TABLE `log_quote` AUTO_INCREMENT=1;

 

TRUNCATE `downloadable_link_purchased`;

TRUNCATE `downloadable_link_purchased_item`;

ALTER TABLE `downloadable_link_purchased` AUTO_INCREMENT=1;

ALTER TABLE `downloadable_link_purchased_item` AUTO_INCREMENT=1;

 

TRUNCATE `eav_entity_store`;

ALTER TABLE  `eav_entity_store` AUTO_INCREMENT=1;

TRUNCATE `customer_address_entity`;

TRUNCATE `customer_address_entity_datetime`;

TRUNCATE `customer_address_entity_decimal`;

TRUNCATE `customer_address_entity_int`;

TRUNCATE `customer_address_entity_text`;

TRUNCATE `customer_address_entity_varchar`;

TRUNCATE `customer_entity`;

TRUNCATE `customer_entity_datetime`;

TRUNCATE `customer_entity_decimal`;

TRUNCATE `customer_entity_int`;

TRUNCATE `customer_entity_text`;

TRUNCATE `customer_entity_varchar`;

TRUNCATE `tag`;

TRUNCATE `tag_relation`;

TRUNCATE `tag_summary`;

TRUNCATE `tag_properties`;            ## CHECK ME

TRUNCATE `wishlist`;

TRUNCATE `log_customer`;

ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1;

ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1;

ALTER TABLE `tag` AUTO_INCREMENT=1;

ALTER TABLE `tag_relation` AUTO_INCREMENT=1;

ALTER TABLE `tag_summary` AUTO_INCREMENT=1;

ALTER TABLE `tag_properties` AUTO_INCREMENT=1;

ALTER TABLE `wishlist` AUTO_INCREMENT=1;

ALTER TABLE `log_customer` AUTO_INCREMENT=1;

 

TRUNCATE `log_url`;

TRUNCATE `log_url_info`;

TRUNCATE `log_visitor`;

TRUNCATE `log_visitor_info`;

TRUNCATE `report_event`;

TRUNCATE `report_viewed_product_index`;

TRUNCATE `sendfriend_log`;

### ??? TRUNCATE `log_summary`

ALTER TABLE `log_url` AUTO_INCREMENT=1;

ALTER TABLE `log_url_info` AUTO_INCREMENT=1;

ALTER TABLE `log_visitor` AUTO_INCREMENT=1;

ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1;

ALTER TABLE `report_event` AUTO_INCREMENT=1;

ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1;

ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;

### ??? ALTER TABLE `log_summary` AUTO_INCREMENT=1;

SET FOREIGN_KEY_CHECKS=1;

How to take a db backup in Magento

Open Putty with your default Username & Copy – Paste the below Script in it. 

$ mysqldump -u root -p Tutorials > tut_backup.sql

 

 

 

How to Change Directory of root of server in Magento

Open Putty with your default Username & Copy – Paste the below Script in it. 

#Change Directory of root of server.

sudo nano /etc/apache2/sites-available/000-default.conf
DocumentRoot /var/www/html
sudo nano /etc/apache2/apache2.conf
<Directory /var/www/html/>
Options Indexes FollowSymLinks
AllowOverride None
Require all granted
</Directory>
sudo service apache2 restart

How to Change Permission of Magento Root folder

Open Putty with your default Username & Copy – Paste the below Script in it. 

#Permission changed of html folder

sudo adduser <username> www-data
sudo chown -R www-data:www-data /var/www
sudo chmod -R g+rwX /var/www
restart after it

How to Change Existing Customer Email Address

Open Putty with your default Username & Copy – Paste the below Script in it. 

#Customer Email change

select * from sales_flat_order_address where email='old@gmail';
update sales_flat_order_address set email='new@gmail.com' where email='old@gmail' and telephone='Telephone Number';

select * from customer_entity where email = 'old@gmail';
update customer_entity set email = 'new@gmail.com' where email ='old@gmail';

select * from sales_flat_order where customer_email='old@gmail';
update sales_flat_order set customer_email='new@gmail.com' where customer_email='old@gmail';

select * from sales_flat_quote where customer_email = 'old@gmail';
update sales_flat_quote set customer_email='new@gmail.com' where customer_email='old@gmail';

How To Change Directory of Root In Magento

Open Putty with your default Username & Copy – Paste the below Script in it. 

sudo nano /etc/apache2/sites-available/000-default.conf

DocumentRoot /var/www/html
 sudo nano /etc/apache2/apache2.conf
 <Directory /var/www/html/>
 Options Indexes FollowSymLinks
 AllowOverride None
 Require all granted
 </Directory>

sudo service apache2 restart

How to Create a New Database in Magento & Give Special Privileges

Open Putty with your default Username & Copy – Paste the below Script in it. 

mysql -u root -p

Enter Password: Your Mysql Password

CREATE DATABASE magento;

CREATE USER magento_user@localhost IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON magentodb.* TO magento_user@localhost IDENTIFIED BY 'newpass'; (Permission)

FLUSH PRIVILEGES;

exit

How to Change Magento Backend Admin Password Using MySql

Open Putty with your default Username & Copy – Paste the below Script in it. 

mysql -u username -p password mage_db(Database name)

select username from admin_user;

mysql> update admin_user set password=CONCAT(MD5('hXpassword123'), ':hX') where username='admin';

Upgrading Magento 1.8 To 1.9.2.1

Having had the opportunity to work on a new build using Magento 2 the architecture of the application has changed significantly, to me it has definitely increased the difficulty of getting a Magento project up and running but in return offers a more granular and organised application to work with.

With this view I think it’s unlikely that you would upgrade your site to v2. Magento have not given an upgrade path to 2.0 and I doubt they will, so it’s probably worth waiting for the opportunity to re-design the site before moving over to the new platform.

Magento have committed to 3 years from general release of 2.0 so that gives you till around 2019 to move over. In the meantime that means they will continue to provide security patches and support for the 1.x platform.

Step 1- Enable maintenance mode

cd /magento_folder
 #for example: cd /var/www/magento
 touch maintenance.flag

Step 2: Manually you can take backup of your database and directories

Make sure you take the full backup of your store’s database and directories.

Step 3: Commence the upgrade process

cd /magento_folder
 rm -rf  var/cache/*   var/session/*
 chmod -R 777 /magento_folder
 chmod 550 ./mage
 ./mage mage-setup .
 ./mage config-set preferred_state stable
 ./mage list-installed

#In case, modules are not listed, use the below given command to upgrade further:

./mage install http://connect20.magentocommerce.com/community Mage_All_Latest --force

#And if your Magento modules are listed – use the following commands:

./mage list-upgrades
 ./mage upgrade-all

#Once the upgrade process is done, you’ll see a list of modules – ‘already installed’, ’package upgraded’, make sure your permissions are set back to normal:

php shell/indexer.php reindexall
 chmod -R 644 ./*
 find . -type d -exec chmod 755 {} \;
 chmod 550 ./mage

Step 4: Go live with your website

cd /magento_folder
 rm -f maintenance.flag