Categories
View Replies (1)

Resolved import VM custom fields

  1. ptrouw
    ptrouw
  2. RO CSVI
  3. Wednesday, 04 November 2015
  4.  Subscribe via email
I did an import of multiple custom fields, like this.
"product_sku","custom_title","custom_param","custom_value","custom_price","custom_ordering"
"ALF1GTBP","COM_VIRTUEMART_PAINTEDINCOLOUR_SELECT_COLOUR","param","COM_VIRTUEMART_PAINTEDINCOLOUR_MATT_BLACK",0.00,1
"ALF1GTBP","COM_VIRTUEMART_PAINTEDINCOLOUR_SELECT_COLOUR","param","COM_VIRTUEMART_PAINTEDINCOLOUR_SILVER",11.57,2
"ALF1GTBP","COM_VIRTUEMART_PAINTEDINCOLOUR_SELECT_COLOUR","param","COM_VIRTUEMART_PAINTEDINCOLOUR_CARBON",11.57,3
That works.

But i also tried it in one row, like your example in the tutorials. Something like this:
"product_sku","custom_title","custom_param","custom_value","custom_price"
"ALF1GTBP","COM_VIRTUEMART_PAINTEDINCOLOUR_SELECT_COLOUR","param~param~param~param","COM_VIRTUEMART_PAINTEDINCOLOUR_MATT_BLACK#COM_VIRTUEMART_PAINTEDINCOLOUR_SILVER#COM_VIRTUEMART_PAINTEDINCOLOUR_CARBON#COM_VIRTUEMART_PAINTEDINCOLOUR_BRUSHED","0.00~11.57~12.57~13.57"

but that doesn't seem to work. Is that VM2 of VM 3?

The reason is that I want it in 1 row, is after an export all custom fields are in 1 row, and I just want to update part of this row. Export look like:
"ALF146BP","Alfa Romeo 146 1994-2001 5d side protection set","COM_VIRTUEMART_PAINTEDINCOLOUR~COM_VIRTUEMART_PAINTEDINCOLOUR_SEND_EMAIL~~COM_VIRTUEMART_PRODUCTDETAIL_5D~1994-2001~COM_VIRTUEMART_PAINTEDINCOLOUR_MATT_BLACK~J","","0.00~102.48~~~~~"

So basically, I want to change custom_price, and import row back again. How can I do this easy?
0
Responses (1)
rolandd
rolandd
Accepted Answer Pending Moderation
but that doesn't seem to work. Is that VM2 of VM 3?
That doesn't tell me much, what doesn't work?

You can't do the same product on multiple lines, only the last one will be used in that case.

So basically, I want to change custom_price, and import row back again. How can I do this easy?
You will have to import all the custom fields for that product. CSVI can't update individual parts in a single custom field.

The CSV on one line has issues. There is only 1 custom_title but there are 4 custom_param values. The custom_value field has 4 values but are separated by the wrong character. You have used # but the separator should be ~ just like in the custom_param field. The same separator needs to be used for the custom_title. The custom_price looks good. All the fields need the same amount of values.
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!