Timeline for SQL query to obtain all products info from a specific category
Current License: CC BY-SA 3.0
8 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
May 14, 2017 at 8:05 | comment | added | Arminius | Thank you so much. I am indeed learning about the queries but yet dont know where to paste them so as to export the results. I do use Laravel MVC and I am familiar with this MVC model. However, once I finish this I won't need magento anymore, this was just a friend request to me. | |
May 13, 2017 at 20:19 | comment | added | sv3n |
I can send you some sample queries at the begining of next week (have them at work and im too lazy to write them again now :P ) ... BUT ... i defintly suggest to learn some things about "magentos way" to build queries (Mage::getModel('catalog/product')... and append ->getSelect()->__toString() I'm pretty sure it takes less time as building correct queries at your own.
|
|
May 13, 2017 at 9:56 | vote | accept | Arminius | ||
May 12, 2017 at 11:10 | comment | added | Arminius | yes, because I want to export that table to another database that is not based on magento. | |
May 11, 2017 at 17:00 | comment | added | sv3n | Do you want to get all product details? Name, description .... ? | |
May 11, 2017 at 16:42 | comment | added | Arminius | I only get numbers as result: 860 4 11 simple 163180 0 0 2014-04-04 20:53:43 2016-03-29 12:33:58 1 861 4 11 simple 45600 0 0 2014-04-04 20:53:45 2015-08-14 12:37:22 1 899 4 11 simple 161420 0 0 2014-04-04 20:54:37 2015-10-13 07:04:15 1 927 4 11 simple 275230 0 0 2014-04-04 20:55:18 2015-08-14 12:39:44 1 963 4 11 simple 160933 0 0 2014-04-04 20:56:08 2017-03-13 17:55:41 1 | |
May 11, 2017 at 16:36 | vote | accept | Arminius | ||
May 11, 2017 at 16:40 | |||||
May 11, 2017 at 14:37 | history | answered | sv3n | CC BY-SA 3.0 |