Accessing back-end order information

[ChapHarrison]

Hi,

 

I need some guidance -- if only a pointer to another forum -- on how I can extract "raw" table data from osC's database.

 

Specifically, I'm assisting a client who's moving her store from Miva to osCommerce. In its administrative tools, Miva provided an export function that wrote the latest orders to a .CSV flat file, which my client then FTP'd to her computer and imported into the analysis tool that I wrote for her. I need to know what methods are available in an osCommerce store that would allow me to extract a similar file, so that the analysis tool would continue to work as before.

 

Briefly, the flat file is nothing but a join between an order and its line items.

 

I would greatly appreciate any help!

 

Thanks,

Chap

[Guest]

A quick and dirty method qould be to use phpMyAdmin - use the following query to product a data set then use the Export feature to produce the csv file

 

SELECT *
FROM orders o
LEFT JOIN orders_products op ON op.orders_id = o.orders_id;

 

This will give you the order details and each product line for that order

[Guest]

Hi

 

I have been looking for something like this for some time, I love it

 

Just wondering if there is a way to get a list of products sold from a certain date to another certain date for example

 

get a list of products sold from 1/12/2011 to 17/12/2011

 

Is there a way to do that using the same sort of way as above by running a query in the myphpadmin

 

Thanks in advance

 

Ian

[Guest]

Problem Solved

 

I used the filter option in Excel to pick certain date range

 

Regards

 

Ian