mamandis Posted June 2, 2012 Share Posted June 2, 2012 ok, I want to create a CSV file with products. I think I found a solution after so much reading and looking into my DB. but I cant find in witch table is quantity of products. where it is? help me please Link to comment Share on other sites More sharing options...
tuk66 Posted June 2, 2012 Share Posted June 2, 2012 ps_product Link to comment Share on other sites More sharing options...
mamandis Posted June 3, 2012 Author Share Posted June 3, 2012 Thanks for an answer and now I need to create four CSV files? one for categories(ps_category_lang), one for products(ps_product_lang), other for images(ps_image_lang) and last for quantity(ps_product)? Link to comment Share on other sites More sharing options...
jhnstcks Posted June 3, 2012 Share Posted June 3, 2012 and now I need to create four CSV files? one for categories(ps_category_lang), one for products(ps_product_lang), other for images(ps_image_lang) and last for quantity(ps_product)? Why? Link to comment Share on other sites More sharing options...
mamandis Posted June 3, 2012 Author Share Posted June 3, 2012 do I just need to create one CSV file and different data I need to put in different tables? Link to comment Share on other sites More sharing options...
jhnstcks Posted June 3, 2012 Share Posted June 3, 2012 Why not just use http://www.prestashop.com/forums/topic/37900-module-product-export-module-v10-updated-for-14-free/page__st__400__p__840695__fromsearch__1?do=findComment&comment=840695 Link to comment Share on other sites More sharing options...
mamandis Posted June 3, 2012 Author Share Posted June 3, 2012 (edited) Thanks, jhnstcks I tried this 'export products' module. I set the sequence as how I need, I exported it. by this csv sequence I created a new one and stock.. how can I imort csv document created by sequence I created in 'export products'? and if I have a lot of products (~5000), how would be with CSV uploading? Edited June 3, 2012 by mamandis (see edit history) Link to comment Share on other sites More sharing options...
Reivax Posted January 8, 2013 Share Posted January 8, 2013 (edited) Hi, It's look like product quantity is not anymore available using product table. Field "quantity" is still there but not filled properly. Instead, you have to use stock_management table. See related topic http://www.prestasho...uct-quantities/ For previous version (mine is 1.2.4), quantity is in product_attribute table. In order to get total quantity for a product, you have to sum up "quantity" field using all attribute rows related to the product. Also: http://www.tosd.com....ing-attributes/ Edited January 8, 2013 by Reivax (see edit history) 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts