Categories
View Replies (3)

Resolved 3 Fields not importing even when preview says yes

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


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