Category: Ecommerce

How to Import/Export a Products in Magento

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

1.png

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

2.png

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

3.png

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

4.png

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

5.png

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

6.png

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 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 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