I'm trying to solve the "No price set" under Product price field in Virtuemart 3.0.9. I've added what I think will satisfy the switch but when I import the 3 new fields, they don't show up in the product admin area or in SQL.
Files attached..
Thanks for looking.
Chris
Hello Chris,
The product_currency field is wrong, this should be the short code of the currency, for example EUR for the Euro. It can't find the currency called 144 ;) If you update that, it should import the currency as well.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Ok I'll give it a go, the 144 came directly from SQL field, the default was like #191 or something, when I changed in admin, it was 144, so I was trying to dump 144 there to have USD be the default.
It is using smallint, which is a number, so that I why I am curious if this will work. I'll give it a try though.
the 144 came directly from SQL field
Exactly, it's an SQL value, the product_currency is not taking an SQL value as you can see when you export. No need to worry about IDs, just put the name of your currency and you should be good to go.
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.