Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Report of specific product sole and to whom


Jolly Blackburn

Recommended Posts

Hi, my partner recently passed away and I'm a noob with no oscommerce exprience stepping into this shoes.

We had a pre-order product for sell on our oscommerce site for three years. It's been something of a crowd-funding endeavor.
That product is about ready to be released only my partner left no record who who ordered and paid for this pre-order (we have over a 100 products on our webstore)

I can enter a customer name and verify that they bought the product. So I know the info is there.

What I need to do is get a report with shipping info for every customer who bought the product. I have no clue how to do that.

Can someone point me in the right direction?

Link to comment
Share on other sites

Because I like playing board games, I'll message you a .zip file which you can upload to your admin area and then use to download that data.  It might work or it might not - no harm in trying - your shop is ancient version of osCommerce unfortunately.

Sorry for your loss.

Link to comment
Share on other sites

SELECT o.*, op.*
 FROM orders o INNER JOIN orders_products op ON o.orders_id = op.orders_id
 WHERE op.products_id = 1

Replace 1 with the correct product ID.  The product ID will be visible on the product page, e.g. product_info?products_id=1

You'd put that query into phpMyAdmin (SQL tab) or similar.  Note that you might be better off taking the generated list and viewing the orders individually in your admin. 

This is probably more work than Burt's solution, but it is also more likely to work.  So try his first and then if it doesn't do what you want, you can try this. 

Always back up before making changes.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...