Magento 1.9.1 Porto theme

We had a major problem, had to do a full restore but ever since we are not able to work with product images on the backend.

This is not the issue with flash/browser. It is a long story that is detailed here:

Unable to see the actual images in the back end

What I'm after now is a work-around. We need to add new products to the site urgently. Can I create a product, upload the product photo directly into a folder on the server via FTP and then go to the database, find the correct row and add the reference to the photo's location directly in there? How would one do that?

Updated February 11th:

I've decided to do what was suggested by HelgeB and that is:

  1. I did an All Products export using Dataflow
  2. I then deleted all but the new products
  3. I found the column labeled: image - since there was the following in there:

enter image description here

I created an import directory under media and then /i/m/ folders and I've put the product photos in there named exactly the same: such as /i/m/images2_2_1.jpg

  1. I ran the import, deleted All Cache and re-indexed but the product photos did not appear.

What am I doing wrong?

I went into the database and found the product and it actually has the correct file name and path to the image:

enter image description here

That is the correct ID and all - yet the product does NOT show on the product on the front end.

  • you want to directly programatically product create? Feb 11, 2019 at 10:43
  • @Rakesh Donga I was hoping to create the product in the Admin panel (it let's us do that), then upload the product photo into some folder on the server, then go to the database, find the product somewhere in a row and put the reference to the product photo in there so that it would then show the product with that product photo on the front end. Is this possible and if so - where would I look in the database and how exactly would I do that?
    – Allysin
    Feb 11, 2019 at 10:46
  • you can try this way working fine for me i have used this link popatkaran.wordpress.com/2015/07/24/… Feb 11, 2019 at 10:48
  • Why don't you use an import tool like Dataflow for adding the new products? I know, you used that already for migration :-) I guess it's easier and safer to create a csv file, upload image files to the server and run the import.
    – HelgeB
    Feb 11, 2019 at 10:52
  • @HelgeB - that's brilliant! I can't believe I didn't think of that! Would this work you think: 1. create the products in Admin 2. Export only those new products through the Dataflow 3. open up the Excel file and add references to the product images 4. Put the product images in those folders in the import folder 5. Run the import via Dataflow ? I'm super-excited about this now :)
    – Allysin
    Feb 11, 2019 at 11:11


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.