Categories
View Replies (1)

Resolved product_availability shows on-order.gif

  1. Julius.Piwowar
    Julius.Piwowar
  2. RO CSVI
  3. Thursday, 24 September 2015
  4.  Subscribe via email
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
0
Responses (1)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!