cancel
Showing results for 
Search instead for 
Did you mean: 

Cant access Backend! Read out Orders and Registered Users data

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Cant access Backend! Read out Orders and Registered Users data

Hey there,

i cant access to the magento 1.9. backend since days, i need the orders made and the user data in order to migrate to a new website.

 

I have access to MYSQL> phpmyadmin

where can i read out the given information

2 REPLIES 2

Re: Cant access Backend! Read out Orders and Registered Users data

Hello,

You should check these tables :

 

Orders :

sales_flat_order

sales_flat_order_items

Customers:

customer_entity

(split in  customer_entity_datetime,customer_entity_decimal,int,customer_entity_varchar beacause of magento eav system)

Customer address:

customer_address_entity  

(split incustomer_address_entity_datetime,customer_address_entity_decimal,customer_address_entity_int,customer_address_entity_varchar)

Re: Cant access Backend! Read out Orders and Registered Users data

Create one php file say "Orderinfo.php" into your magento root with the following code.

<?php
$mageFilename = 'app/Mage.php';
if (!file_exists($mageFilename)) {
    echo $mageFilename." was not found";
    exit;
}
require_once $mageFilename;
Mage::app();

try {
     $collection = Mage::getModel('sales/order')->getCollection()
          ->addAttributeToSort('entity_id','DESC');  
     foreach($collection as $order)
     {
         // YOU CAN ACCESS ALL THE DETAIL OF ORDER WHICH YOU WANT HERE.
     }
} catch (Exception $e) {
    echo $e->getMessage();
    exit;
} 

 
Now you need to access this file from browser "http://yourmagento/Orderinfo.php

Was my answer helpful? You can Click Kudos/Accept As Solution.
200+ professional extensions for M1 & M2 with free lifetime updates!