da_dim Posted November 28, 2013 Share Posted November 28, 2013 Hi all, I need some advice. I added a good amount of products in my catalog of PrestaShop in a generic category. Now I was asked to divide them into several subcategories, but I would like to avoid doing it one by one. Any advice? Thank you very much! Link to comment Share on other sites More sharing options...
NemoPS Posted November 29, 2013 Share Posted November 29, 2013 Same as here http://www.prestashop.com/forums/topic/292332-how-do-i-move-multiple-products-to-another-category-at-once/ Link to comment Share on other sites More sharing options...
parsifal Posted December 4, 2013 Share Posted December 4, 2013 (edited) I would go about it with the help of the CSV import functionality. CSV import isn't useful only when we want to create new products/categories/customers etc. It can also be used to update already existing information. So, you can open your favorite spreadsheet application or text editor and assemble the IDs of all the products you want to change and the IDs of the new category each product should be moved to. For example, say you had 2 products with IDs 1345 and 1346. You want to move the first one to a category with ID 15 and the second one to a category with ID 16. Your CSV file could look like this: ID;Categories 1345;15 1346;16 Edited December 4, 2013 by parsifal (see edit history) Link to comment Share on other sites More sharing options...
dbeezer99 Posted December 7, 2013 Share Posted December 7, 2013 Well I need same help and i tried test of what you said but this is what happened..see screen shots..i really hope this will work pls help..i have to move 100's of products! http://prntscr.com/29hhj4 http://prntscr.com/29hi19 Link to comment Share on other sites More sharing options...
ExpressTech Posted December 8, 2013 Share Posted December 8, 2013 You are editing the file wrongly - ID and Category are two separate columns. First, see the sample file located at your shop (for example: http://demo.tb3.co.in/ps15/docs/csv_import/products_import.csv) , that will give you an idea of how a valid CSV file looks like. Link to comment Share on other sites More sharing options...
parsifal Posted December 8, 2013 Share Posted December 8, 2013 (edited) Hello dbeezer99. It looks like you used the comma character as a field separator in your test CSV, but in PrestaShop's CSV options you left the default option of semicolon character as field separator. Those two should match... Edited December 8, 2013 by parsifal (see edit history) Link to comment Share on other sites More sharing options...
dbeezer99 Posted December 8, 2013 Share Posted December 8, 2013 Parsifal your a genius! that worked! I was thinking about buying a module to do this but I dont need to now! so I wondering if there is a way to to this some how to update pricing ...I know I can do that by exporting then changing pricing and importing back in and i exported once but now I cant remember how I did it or where that option is in PS??? But what does the message in green mean about rebuildong serach index see screen shot: http://prntscr.com/29oxuz Link to comment Share on other sites More sharing options...
parsifal Posted December 8, 2013 Share Posted December 8, 2013 If you go to BO > Preferences > Search, you'll see something like: Indexed products: XXX / YYY. If XXX equals YYY, you're good to go. If not, some lines below you can click on the "Add missing products to index" link. Link to comment Share on other sites More sharing options...
dbeezer99 Posted December 10, 2013 Share Posted December 10, 2013 thx man but the small text worked but when i tried to move a bunch at once it did work. http://prntscr.com/2a03xv http://prntscr.com/2a04bw I really cant afford that module unless someone wants to go in on it with me but your help is so appreciated! Link to comment Share on other sites More sharing options...
dbeezer99 Posted December 10, 2013 Share Posted December 10, 2013 okay it worked i had selection on category instead of project ( if moving products to diff categories http://prntscr.com/2a29qi Link to comment Share on other sites More sharing options...
Recommended Posts