EcoPets Posted August 11, 2023 Share Posted August 11, 2023 I have bumped into a issue with a suppliers CSV file for importing new products. They provide a URL link to their product images that are stored on a 3rd party server (AmazonAWS). So when the CSV is mapped to the Prestashop file there is no image that would be stored in the "img/p/...." folders. Now this CAN be done after the product file is correctly imported by manually clicking on "Select Files" in the product record and then referencing the URL the supplier provides. If this is a 1 off kind of product import, but if there are a large number of products, this is a HUGE labor intensive process! Does anyone have any suggestions on how to handle this? Link to comment Share on other sites More sharing options...
s4lvozesta Posted August 11, 2023 Share Posted August 11, 2023 Although I could: FTP all files to a tmp folder, then, put its path to the csv (/tmp/uploads/img), then, import the csv … … which will produce products with images (without having to upload image one by one) , I still find it troublesome to get everything in place, such as right image for right combination, cover image, multi category assignment, price and tax config, etc. But that is what I usually do and it has worked for me Link to comment Share on other sites More sharing options...
musicmaster Posted August 13, 2023 Share Posted August 13, 2023 On 8/11/2023 at 7:09 PM, s4lvozesta said: Although I could: FTP all files to a tmp folder, then, put its path to the csv (/tmp/uploads/img), then, import the csv … … which will produce products with images (without having to upload image one by one) , I still find it troublesome to get everything in place, such as right image for right combination, cover image, multi category assignment, price and tax config, etc. But that is what I usually do and it has worked for me Did you try providing the full url of the images at their AWS location? 1 Link to comment Share on other sites More sharing options...
s4lvozesta Posted August 17, 2023 Share Posted August 17, 2023 On 8/13/2023 at 6:48 PM, musicmaster said: Did you try providing the full url of the images at their AWS location? I think I did but there was problem, I forget what was it. I should think PS will download each provided image from the URL which makes it ‘slower’ than running ftp? Link to comment Share on other sites More sharing options...
EcoPets Posted August 17, 2023 Author Share Posted August 17, 2023 My issues seems to have been the way the import of the product file from the supplier was working. I was able to get that working, BUT I can only get 1 image in the import. If the supplier has more than one image in their file, I have not yet figure out how to get them all to import and have to get them manually, one b y one. Link to comment Share on other sites More sharing options...
ps8modules Posted August 18, 2023 Share Posted August 18, 2023 Hi. In the import settings in Prestashop, there is an option to choose a separator for multiple values. So, if you have multiple links to images in the CSV file separated by, for example, a comma, you choose a comma as the multiple separator in the settings. But we can't see your CSV, so that's just guesswork. Link to comment Share on other sites More sharing options...
EcoPets Posted August 18, 2023 Author Share Posted August 18, 2023 Ok. I see that, but the vendor file has the images in separate columns. IE Image-url1, image-url2 etc. How would I import that into the numbers as you describe? See attached - columns AD,AE,AF,AH etc topdawg-import.xlsx Link to comment Share on other sites More sharing options...
ps8modules Posted August 18, 2023 Share Posted August 18, 2023 (edited) Hi. Simply. Just create a new column in Excel and copy the necessary columns with the & condition into it via the command... You can also add an IF condition or TEXTJOIN function =TEXTJOIN(",";1;AD2:AM2) Or write a PHP script that completes everything for you 😉 Edited August 18, 2023 by ps8moduly.cz (see edit history) Link to comment Share on other sites More sharing options...
EcoPets Posted August 18, 2023 Author Share Posted August 18, 2023 Ok. I will give that a try. I was hoping to not have to resort to a lot of manual processes during import. Link to comment Share on other sites More sharing options...
Pritam Posted September 3 Share Posted September 3 Hi, I am able to upload the contents of all products. I have uploaded the image files in the "administration/import/" folder. I then used the url as "http://mydomain.com/import/image1.jpg, http://mydomain.com/import/image2.jpg" However, the images are not uploaded. What am i doing wrong? Link to comment Share on other sites More sharing options...
Pritam Posted September 3 Share Posted September 3 12 minutes ago, Pritam said: Hi, I am able to upload the contents of all products. I have uploaded the image files in the "administration/import/" folder. I then used the url as "http://mydomain.com/import/image1.jpg, http://mydomain.com/import/image2.jpg" However, the images are not uploaded. What am i doing wrong? i also tried the urls, "..import/image1.jpg,../import/image2.jpg" but that too did not work. please help. Link to comment Share on other sites More sharing options...
WisQQ Posted September 3 Share Posted September 3 1 godzinę temu, Pritam napisał: Hi, I am able to upload the contents of all products. I have uploaded the image files in the "administration/import/" folder. I then used the url as "http://mydomain.com/import/image1.jpg, http://mydomain.com/import/image2.jpg" However, the images are not uploaded. What am i doing wrong? remove whitespace and check if you can access images through browser. Link to comment Share on other sites More sharing options...
musicmaster Posted September 3 Share Posted September 3 Try https Link to comment Share on other sites More sharing options...
Pritam Posted September 4 Share Posted September 4 (edited) 16 hours ago, WisQQ said: remove whitespace and check if you can access images through browser. tried that but no luck :(. Thanks for your response. It is good you mention about the accessing the image via browser. I am not able to access the image via browser. I get 403 error - "forbidden - you dont have permission to access the resource." Edited September 4 by Pritam (see edit history) Link to comment Share on other sites More sharing options...
Pritam Posted September 4 Share Posted September 4 14 hours ago, musicmaster said: Try https tried that but it did not work. As i mentioned to @WisQQ I am not able to access the image via browser. How do I resolve the permission ? Link to comment Share on other sites More sharing options...
Pritam Posted September 4 Share Posted September 4 this is the permission set on the folder that has the images. Link to comment Share on other sites More sharing options...
Pritam Posted September 4 Share Posted September 4 22 minutes ago, Pritam said: this is the permission set on the folder that has the images. I tried to upload images into a new folder within "img" folder and it worked well. I could upload multiple images for a single product and it worked well. @WisQQ @musicmaster thank you guys for your inputs. I really appreciate it!! Hope to be of help to others they way I got helped. Link to comment Share on other sites More sharing options...
WisQQ Posted September 4 Share Posted September 4 9 godzin temu, Pritam napisał: this is the permission set on the folder that has the images. it should be 755 and 644 for files. anyway good that you solved the problem. 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