tolito Posted June 28, 2013 Share Posted June 28, 2013 (edited) Hello colleagues, I am continuing my journey with prestashop. At the moment I have to insert a big set of product to the shop. If I have to do it one by one it will took too many time. Is there any other way, I mean for example with excel file? I Have the products in excel table so how can I import them from the file automatically? Thanks in advance Edited June 28, 2013 by tolito (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted June 28, 2013 Share Posted June 28, 2013 you can import products via IMPORT tool: create CSV file with products specification, then you will be able to easily insert many products with this tool 1 Link to comment Share on other sites More sharing options...
tolito Posted June 28, 2013 Author Share Posted June 28, 2013 I am going to try but yesterday I tried Export tool and it did not export my 2 test products correctly..... Link to comment Share on other sites More sharing options...
officeshoppers Posted June 29, 2013 Share Posted June 29, 2013 Please I need to know where to find this free tool am having the same problem (Import & Export). Thanks. Link to comment Share on other sites More sharing options...
vekia Posted June 29, 2013 Share Posted June 29, 2013 this is default prestashop tool, you've got it in back office under the catalog > products tab 1 Link to comment Share on other sites More sharing options...
tolito Posted June 30, 2013 Author Share Posted June 30, 2013 I saw the tool but I need something different. At the moment I have around 200 products entered by hand. Is it possible to export them to csv file with all fields? I have to edit for example the prices for all products and after that I have to import all products back to the database. After a month the products will be more than 300 and every month I need to update the prices for all products. As I see import/export buttons cannot be used, because export cvs format is different than import. How can I do this actions? Is it possible with default tools? Link to comment Share on other sites More sharing options...
vekia Posted June 30, 2013 Share Posted June 30, 2013 you can achieve this in many ways, you can use default tools (that i mentioned) you can also go to the preferences > CSV import another thing is to use database managers, for example - PHPMyAdmin - you can export there all products, you can also import stuff there. But in this case you have to be familiar with mysql Link to comment Share on other sites More sharing options...
tolito Posted July 1, 2013 Author Share Posted July 1, 2013 (edited) I have strong expirience with mysql and php and many other things. At the moment I am searching for ecommerce platform to use for my future projects. In the past I have created my own platform for that but it is not so feature rich as PS. If I should use PHPMyAdmin to edit database it means PS does not have a good tool for products' import/export. Edited July 1, 2013 by tolito (see edit history) Link to comment Share on other sites More sharing options...
Kogkalidis Posted July 1, 2013 Share Posted July 1, 2013 Exactly.. The default tool for imports/exports is not the best. But that's not a big deal, because there are plenty of them with best "custom" the mysql import/export as vekia mentioned and "ps customized" store manager for prestashop by emagicone.. These are the best according to my opinion.. The 2nd one has a big plus because you can work offline and synchronize later!! Regards 1 Link to comment Share on other sites More sharing options...
tolito Posted July 1, 2013 Author Share Posted July 1, 2013 (edited) Exactly.. The default tool for imports/exports is not the best. But that's not a big deal, because there are plenty of them with best "custom" the mysql import/export as vekia mentioned and "ps customized" store manager for prestashop by emagicone.. These are the best according to my opinion.. The 2nd one has a big plus because you can work offline and synchronize later!! Regards Hmm I never heard about emagicone. Can you give an url to see it? Is it free? Edited July 1, 2013 by tolito (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted July 1, 2013 Share Posted July 1, 2013 he probably talked about store manager software from emagicone but off course im not sure at all Link to comment Share on other sites More sharing options...
tolito Posted July 1, 2013 Author Share Posted July 1, 2013 (edited) I found it. It cost $348! Very strange that this gorgeous software don't have such simple tool as product import/export in the same format. It will be very useful. I am just curious what is the benefit to have product export in different format than import? Edited July 1, 2013 by tolito (see edit history) Link to comment Share on other sites More sharing options...
tolito Posted July 1, 2013 Author Share Posted July 1, 2013 (edited) Some ideas from magento: Basically you can use the import/export tool to do mass imports of products. It makes it much easier if you would like to add 50 products all at once, you would just create a csv or xml file with the matching fields for the database, add your information and then use the import tool to import the products. You can retrieve a sample csv or xml file, by doing an export. http://www.magentoco...ort/export_tool Edited July 1, 2013 by tolito (see edit history) Link to comment Share on other sites More sharing options...
Kogkalidis Posted July 1, 2013 Share Posted July 1, 2013 he probably talked about store manager software from emagicone but off course im not sure at all I found it. It cost $348! Very strange that this gorgeous software don't have such simple tool as product import/export in the same format. It will be very useful. I am just curious what is the benefit to have product export in different format than import? Vekia: Yes I mean that one! Tolito: You mean different formats in prestashop or in Store Manager? Link to comment Share on other sites More sharing options...
tolito Posted July 1, 2013 Author Share Posted July 1, 2013 I mean different format in prestashop products section. Export and import actions there don't use one and the same csv format. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now