I have an old Magento database file, but the files associated with it are gone.
The database file is for Magento 7.02
I need to export the orders with the line items and a description of the item from the database.
Does anyone have a way that I can get this data from the database extract, without having the original files for Magento itself?
Fields: Order - Order ID, Customer Name, Email, Order Date, Amount
OrderContents - OrderId, LineItem, Name, Description, Cost
Anyone have a good idea to extract the data?