Resolved Correct path for template override

Hello Dennis,

I read the posts referring to setting all images to published on import,

Can you send the link of the post you are referring to? I am asking this because to publish a image on import you can use media_published field with value set to Y so if you can post more details on what you are looking for may be i can help you.

created the products.php override (took it from the plugin) but don't know the exact path I should put the override in.

Have a look at Create an override for import and export document for details.

Hi Tharuna,

Here's my issue.

I execute a product update import which updates existing products in regards to availability, prices and of course whether they should be published or not.

I've inserted the media_published field with default value 1 but it does not update the media status. It still remains unpublished. Could it be because the update does not process images?

Thanks

Dennis

Hello Dennis,

Could it be because the update does not process images?

Yes that's correct. If no image processing then media_published wont update. Are you looking for publishing all media items or only specific ones?

I'm looking to publish all media regardless of the product status so that when the product becomes available again (through the update import I mentioned before) its media will be available.

Thanks

Dennis

Hello Dennis,
You can publish all media items by running the below query from phpMyAdmin. To do that, go to your phpMyAdmin, select your database and look for table #__virtuemart_medias, click on SQL tab, paste the below query and click Go. Dont forget to replace #_ with your table prefix.

UPDATE `#__virtuemart_medias` set `published`=1

Hi Tharuna,

Did that already ;-) I was looking for a way to secure that each time I imported products, their media would be and remain published.

Thanks, your previous tip for the media_published field will do the trick I think ;-)

D

Hello Dennis,
Glad to know that you ran the query already. Yes, media_published should help you to publish images during import