I need to transfer all my records from OpenCart to WooCommerce powered WordPress site. I used custom query to insert the image urls from opencart db to wp_posts as attachment and guid as the URL of the image, along with post_parent being the product id for that particular image. While the listings show in Media, it still does not load show images and also does not appear on Featured Image box of related products. But if I copy the url from Media manager and open it in new tab. The image shows up just fine. What could be the reason?

Also is there any other way to transfer OpenCart data to WooCommerce? Any help would be appreciated.


  • In the media library, is the image being shown as "attached" to a post/post_id? – userabuser Jun 28 '13 at 5:41
  • to make an image appear as a featured image for a post, you have to add a meta key named _thumbnail_id with the image's ID. – Milo Jun 28 '13 at 6:14
  • @userabuser it shows the product name under Uploaded to Section. – Utsav Singh Rathour Jun 28 '13 at 6:38
  • @Milo will try that. but since i saw only two postmeta added to other featured images, I did only that. – Utsav Singh Rathour Jun 28 '13 at 6:39
  • @Milo I tried what you said, but still it does not show up – Utsav Singh Rathour Jun 28 '13 at 7:15

I am sorry for the incomplete question. Also I managed to solve it. It was missing "_wp_attachment_metadata" post meta.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.