markputt Posted May 30, 2014 Share Posted May 30, 2014 Hey all. Can some one clue me in on the stock prestashop reports that are included in the base product? I'm using 1.6.0.6. I've looked at the dash board and I'm not finding a lot there... unless I'm using it wrong. I've also tried to write my own sql reports in th sql manager but it doesn't like joins. What do you all do for reports? ThanksMark. Link to comment Share on other sites More sharing options...
markputt Posted May 30, 2014 Author Share Posted May 30, 2014 Bump. Should be an easy question. Link to comment Share on other sites More sharing options...
NemoPS Posted May 31, 2014 Share Posted May 31, 2014 Hi! What do you exactly mean by stock reports? What kind of data do you need? Link to comment Share on other sites More sharing options...
cjrhoads Posted July 21, 2014 Share Posted July 21, 2014 This appears to be similar to my question. Any typical financial system comes with a bunch of standard reports. Sales reports by month. Products Sold by month. Customer List. Gross Profit Analysis. If everyone uses credit cards to purchase, I can get a report from my credit card merchant account site, but I have a lot of cash on delivery and checks, so I need a report from Presta that lists everything that was purchased and by whome during a certain time frame. Does this exist? If not, how does one get it? Thanks CJ Rhoads Link to comment Share on other sites More sharing options...
vekia Posted July 21, 2014 Share Posted July 21, 2014 hello what about default prestashop stats feature? have you tried to deal with this feature? i think it's worth to, it's a really huge data mine about orders etc Link to comment Share on other sites More sharing options...
cjrhoads Posted July 21, 2014 Share Posted July 21, 2014 As I mentioned to someone else who suggested this - of course I've looked into stats. I've spent hours in the stats trying to figure out how to get the information I need and either I'm completely dopic and missing it, or the information does not appear to exist in the stats module. I can get how many orders, but not from whom. I can get how many customers, but not what they ordered. I can click into the details of any product and see how many were ordered, but not when or by whom. I must be missing something, because I'm fairly sure the information I need exists somewhere, but for the life of me I can't find it. Can you help help with some specific instructions? For example, I just want to get a list of all the customers who have bought anything in the last month along with what they bought, when, and their address/phone/email info so I can send them what they bought. Where can I get this information? Thanks so much CJ Rhoads Link to comment Share on other sites More sharing options...
NemoPS Posted July 23, 2014 Share Posted July 23, 2014 To answer your last question, more than stats, that is the orders page. So click on Orders. You can filter by the last month only if you add the date under the date column Link to comment Share on other sites More sharing options...
cjrhoads Posted July 23, 2014 Share Posted July 23, 2014 Thanks. We do know how to filter the list. But the orders screen only gives the customer name and order number, not the product they purchased. To find that out, we must actually click into each individual order. I was hoping for a report so that we didn't have to do that. It appears that Prestashop database scheme does not actually include any tables that can join to provide the customer, product, and order/payment information in a single report. Obviously, that is why there are no reports with this information in it. Instead, there appears to be PHP functions that allow programmers (but not non-programmers like me) to pull up the individual information for the individual customer and/or order. That's why the system can show a screen or a PDF with the information, but cannot generate a report with all that information in a table. We are reconsidering Prestashop as a result, but we will continue to investigate our options. In any case, thanks so much for taking the time to answer the question. I greatly appreciate it. Regards CJ Link to comment Share on other sites More sharing options...
tuk66 Posted July 25, 2014 Share Posted July 25, 2014 It appears that Prestashop database scheme does not actually include any tables that can join to provide the customer, product, and order/payment information in a single report. This line of tables ps_product -> ps_order_detail -> ps_orders -> ps_customer can be joined in one query to get such a customer-product report. 1 Link to comment Share on other sites More sharing options...
NemoPS Posted July 25, 2014 Share Posted July 25, 2014 Thanks. We do know how to filter the list. But the orders screen only gives the customer name and order number, not the product they purchased. To find that out, we must actually click into each individual order. I was hoping for a report so that we didn't have to do that. It appears that Prestashop database scheme does not actually include any tables that can join to provide the customer, product, and order/payment information in a single report. Obviously, that is why there are no reports with this information in it. Instead, there appears to be PHP functions that allow programmers (but not non-programmers like me) to pull up the individual information for the individual customer and/or order. That's why the system can show a screen or a PDF with the information, but cannot generate a report with all that information in a table. We are reconsidering Prestashop as a result, but we will continue to investigate our options. In any case, thanks so much for taking the time to answer the question. I greatly appreciate it. Regards CJ Ah! You can try with this modification then http://nemops.com/bought-products-prestashop-order-list/ 1 Link to comment Share on other sites More sharing options...
cjrhoads Posted July 25, 2014 Share Posted July 25, 2014 tuk66 said: >>This line of tables ps_product -> ps_order_detail -> ps_orders -> ps_customer can be joined in one query to get such a customer-product report. Wow!!! I don't know how I could have missed that! I completely missed the ps_orders linking table because it wasn't listed with the other ps_order_ tables. Tuk66 - you just saved me a ton of time and trouble. Thanks!!!! Thanks for the info, Nemo1. I'll check it out as well - it may become very useful! Now I have to go back in to all the forums where I wrote there didn't seem to be a table to join the info and reverse my comments. Thank you again. CJ Rhoads 1 Link to comment Share on other sites More sharing options...
Omk Posted October 23, 2014 Share Posted October 23, 2014 tuk66 said: >>This line of tables ps_product -> ps_order_detail -> ps_orders -> ps_customer can be joined in one query to get such a customer-product report. Wow!!! I don't know how I could have missed that! I completely missed the ps_orders linking table because it wasn't listed with the other ps_order_ tables. Tuk66 - you just saved me a ton of time and trouble. Thanks!!!! Thanks for the info, Nemo1. I'll check it out as well - it may become very useful! Was your trial successful and did you get what you needed? Link to comment Share on other sites More sharing options...
cjrhoads Posted October 23, 2014 Share Posted October 23, 2014 Was your trial successful and did you get what you needed? Yes - I was able to write a SQL query to get the information. I looked at Nemo1 tutorial, but it was way over my head. I'm a database buff, but not a PHP programmer. Link to comment Share on other sites More sharing options...
Recommended Posts