mali8 Posted June 4, 2013 Share Posted June 4, 2013 Hello, I'm trying to insert all my products from .xml to PrestaShop database, with no success :S I added the product to this tables: ps_product, ps_product_lang and ps_category_product and the Shop is not showing the new product. Can anyone help me? Link to comment Share on other sites More sharing options...
mali8 Posted June 4, 2013 Author Share Posted June 4, 2013 I added the product also to ps_product_shop and it worked 1 Link to comment Share on other sites More sharing options...
mali8 Posted June 4, 2013 Author Share Posted June 4, 2013 You need to add the product to ps_stock_available, so you will have avalibe product Link to comment Share on other sites More sharing options...
mali8 Posted June 5, 2013 Author Share Posted June 5, 2013 Does anyone know how to upload images of the products? I know that PrestaShop makes folder for each product-image and in the databese it has stored the numbers of folder so it can find proper images. I tried to import it via csv ( http://www.home-port.net/user_guide/index.php/article/printer/start3-presta ), but nothing happend :S Any suggestions? Link to comment Share on other sites More sharing options...
mali8 Posted June 5, 2013 Author Share Posted June 5, 2013 PrestaShop forum has 498850 members and no one can not help?? I'm very disappoited. Link to comment Share on other sites More sharing options...
Herland Posted June 7, 2013 Share Posted June 7, 2013 Sometimes it happens, I try other locales (Spanish forum) they have wonderful people willing to help. Back on topic, I'm having this issue to add products. I'm working on prestashop 1.4.7 I added to ps_product_land and ps_product but no success... PD: are there many images you want to upload from the products? I have done csv uploads with success. Link to comment Share on other sites More sharing options...
mali8 Posted June 7, 2013 Author Share Posted June 7, 2013 For every product one picture. I tried to upload them via csv but without success :S Link to comment Share on other sites More sharing options...
Herland Posted June 7, 2013 Share Posted June 7, 2013 (edited) I think csv is the best choice for your situation. I can guide you through uploading your products with the images succesfully. I will give you some posts I made regarding my situation and how I solved. Post 1 : http://www.prestasho...ample-for-v147/ I believe it's important to share what you know, so I made this tutorial for you: STEP 1: STEP2: EDIT: STEP3 Edited June 8, 2013 by Herland (see edit history) Link to comment Share on other sites More sharing options...
PascalVG Posted June 8, 2013 Share Posted June 8, 2013 Hello Herland, Many thanks for your tutorial. For sure helpful for many people! One small remark/check: When reading the story, I make up that I can change the field separator into a comma (which is correct). In your picture STEP 3 you mention that the image URLs "must to be separated by comma's". This can be somewhat confusing. As far as I know from other programs, you have to use different separators for field separator (FS) and multiple value separator (MVS), to distinguish between them. so for example FS=',' and MVS=';' OR FS=';' and MVS=',' but not both ',' Please correct me if I'm wrong, (which is entirely possible) Furthermore, it's great you took your time to educate us. Thanks again. Very useful! pascal. Link to comment Share on other sites More sharing options...
Herland Posted June 8, 2013 Share Posted June 8, 2013 (edited) Thanks @PascalVG you're absolutely right. I always made sure my multiple value separator to be comma (as defined in STEP 1) so I never had problems with that. I made an edit to STEP 3. Edited June 8, 2013 by Herland (see edit history) Link to comment Share on other sites More sharing options...
PascalVG Posted June 8, 2013 Share Posted June 8, 2013 Hi Herland, Thanks for clearing that up for us! mali8, did you manage to use csv import successfully, using Herland's tutorial? Please let us know, so we can mark the post as [sOLVED] pascal Link to comment Share on other sites More sharing options...
mali8 Posted June 10, 2013 Author Share Posted June 10, 2013 Thanks Herland for the tutorial, but that doesn't help me. I gotta do this automatically, not by uploading the .csv file :S Link to comment Share on other sites More sharing options...
mali8 Posted June 10, 2013 Author Share Posted June 10, 2013 Can i update product with .csv file??? Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 10, 2013 Share Posted June 10, 2013 Hi mail8, yes, you can update products via CSV as long as the "ID" is the same as the product you want to update. It will override the corresponding product with the same ID. Link to comment Share on other sites More sharing options...
SmartDataSoft Posted June 10, 2013 Share Posted June 10, 2013 how can any one export there existing product for another shop. is there any easy way to do this.? Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 10, 2013 Share Posted June 10, 2013 how can any one export there existing product for another shop. is there any easy way to do this.? Hi, if you are using 1.5.4, check this thread out, http://www.prestashop.com/forums/topic/239306-exporting-csv-in-154/ Otherwise, there are modules that will export your products for you, this is one of them, http://addons.prestashop.com/en/export-modules/4925-moussiq-extended-product-csv-export.html Link to comment Share on other sites More sharing options...
nalpdog Posted June 10, 2013 Share Posted June 10, 2013 Hello, So far I am getting no real help in moving my Product from Volusion to PrestaShop. Any chance there is someone out there that can help me solve this problem??? Thank you!!! Link to comment Share on other sites More sharing options...
SmartDataSoft Posted June 10, 2013 Share Posted June 10, 2013 Hello, So far I am getting no real help in moving my Product from Volusion to PrestaShop. Any chance there is someone out there that can help me solve this problem??? Thank you!!! Hello, nalpdog you can export your volusion product to csv and than convert that to prestashop format and import. Or you can hire expert who can do this for you. Link to comment Share on other sites More sharing options...
nalpdog Posted June 10, 2013 Share Posted June 10, 2013 I guess this is a service you provide??? How much for this service??? Link to comment Share on other sites More sharing options...
SmartDataSoft Posted June 10, 2013 Share Posted June 10, 2013 I guess this is a service you provide??? How much for this service??? It depend on your site volume how much product your site have. and how much time we need to do. Better we can discuss the mater on message if you like to hire our team. We are prestashop certified agency. Link to comment Share on other sites More sharing options...
nalpdog Posted June 10, 2013 Share Posted June 10, 2013 I have about 750 products at www.WomenWhoride.biz Is this where you want to chat or is there a way we contact one another privately??? Skype??? e-mail??? Link to comment Share on other sites More sharing options...
mali8 Posted June 14, 2013 Author Share Posted June 14, 2013 Mark this post as SOLWED. Thanks for the help. If someone needs help how to insert product, then contact me Link to comment Share on other sites More sharing options...
PascalVG Posted June 14, 2013 Share Posted June 14, 2013 Hi Mali, What way did you add the images in the end? Just for completeness sake :-) Thanks, pascal Link to comment Share on other sites More sharing options...
mali8 Posted June 15, 2013 Author Share Posted June 15, 2013 .csv file import Link to comment Share on other sites More sharing options...
PascalVG Posted June 15, 2013 Share Posted June 15, 2013 Good to hear it worked. Good luck with your shop! Pascal Link to comment Share on other sites More sharing options...
nalpdog Posted June 15, 2013 Share Posted June 15, 2013 I am curious - I have been attempting to move my product from Volusion - the csv files seem to transfer however do not show in my catalogue. When I do get them to show the short description is missing and the photos are missing. Any suggestions on solving this problem??? By the way I even attempted to use cart2cart and they have not solved the issue. Link to comment Share on other sites More sharing options...
mali8 Posted June 15, 2013 Author Share Posted June 15, 2013 I recommend you, to write a script (i done it with php) which creates the .csv for PrestaShop, then you just import it I'm sure it can be done this way Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts