Ricmmf Posted July 9, 2013 Share Posted July 9, 2013 Hi, i'm developing an academic business intelligence work over a prestashop mysql database, but i have only a very small number of orders. So i'd like to ask if there is someone that has a sample database that could i use. I have absolutely no "comercial" interest in client details, i only need to have a considerable number of orders and all the related information, to analyse values such as "sells by month/year". Regards Link to comment Share on other sites More sharing options...
Dh42 Posted July 9, 2013 Share Posted July 9, 2013 I cannot think of a business that would give you that without violating their privacy policy and customer privacy. 1 Link to comment Share on other sites More sharing options...
Ricmmf Posted July 9, 2013 Author Share Posted July 9, 2013 Yes, i know it will be difficult to help me out here, but maybe someone has a database for tests... Link to comment Share on other sites More sharing options...
tomerg3 Posted July 9, 2013 Share Posted July 9, 2013 This has got to be one of the most ridiculous requests I have ever seen in the forum (and I've been a member since 09). As DH mentioned, no one in their right mind would share any customer / order info with you. Want some test data, create it yourself... Place order from the front end, or from the back end. 1 Link to comment Share on other sites More sharing options...
Ricmmf Posted July 9, 2013 Author Share Posted July 9, 2013 (edited) I'm a prestashop newbie, which has thousands of users and developers; though my question is ridiculous it could happen that maybe someone could help me out, with a sample database, data generator or something else. I was certainly not expecting that someone would share with me a database in use... Tomerg3, we are precisely creating orders from the front end, the problem is that we need to spread them between months and years. In that sense, we've observed the database tables (related to orders) and i would like to confirm: if i create a simple order with some products and with today's date, and then change columns "date_add" and "date_upd" to a specific date like "2012-07-09 02:27:47", which are the related tables that i must (consistently) update? - the related cart columns "date_add " and "date_upd" in table ps_cart - the related columns "date_add " and "date_upd" in customer thread and order_history Assuming that this is a simple test in database, without messages in ps_message, information payments in ps_payments_cc, and related information in stock_mvt, order return and order_slip tables) Regards Edited July 9, 2013 by Ricmmf (see edit history) Link to comment Share on other sites More sharing options...
tomerg3 Posted July 9, 2013 Share Posted July 9, 2013 I wouldn't hold my breath for a "test data" DB, creating your own would probably be the way to go. You could change the date field in the orders table, I believe that it the only place the date is stored, but you can also create a dump of the DB structure and check for any "date" field in a table that has the word "order" in it. 1 Link to comment Share on other sites More sharing options...
Recommended Posts