Support is online

product_availability shows on-order.gif #7646

Open Julius.Piwowar opened this topic Thursday, 24 September 2015 · 1 reply
Author

VM 3
Joomla 3.4.4
CSVI Pro

Hey Rolandd :)

For some reason during importing data (virtuemart_product_id, product_sku, product_name, category_path , product_desc, custom_title, custom_value, product_price, override, product_currency, file_url, file_url_thumb, file_meta published) my product_availability changed. Some products are now with on-order.gif. I tried to change with importing a table with product_sku, product_availability. In export about 50% of my product_availability flieds show on-order.gif. I deleted all of them and imported the table. No error but the products still have the picture of on order. How can I delete the on order picture? Thanks for you great help! Julius

Support

Hello Julius,

The issue is, that you can't import an empty value. The easiest and fastest is to do a database query via PhpMyAdmin for example to empty this value. The query is

UPDATE jos_virtuemart_products SET product_availability = '';

this will empty all the values in product_availability. You will need to change jos to your own prefix.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.