Categories
View Replies (3)

Resolved Import custom field with multiple values

  1. lucafo
    lucafo
  2. RO CSVI
  3. Wednesday, 04 July 2018
  4.  Subscribe via email
Hi,

I need to import a product csv , with field with multiple values

The product have 2 fields: COM_CROMPARTS_HOMOLOGACION_DEL_VEHICULO_PARA_ITV-1 and EXTENSION_DE_GARANTIA_AUTOMOCION

Product Backend:

cromparts-fields.jpg
I have 2 values for COM_CROMPARTS_HOMOLOGACION_DEL_VEHICULO_PARA_ITV-1 and 2 values for EXTENSION_DE_GARANTIA_AUTOMOCION, everyone with price modification...

Product Frontend -> show a select for these fields, when user select one option the prices change

cromparts-fields1.jpg

I follow the instructions to generate a CSV with these fields in https://csvimproved.com/support/import/1120-product-import-with-custom-fields (section CUSTOM FIELDS WITH MULTIPLE VALUES)

I create a csv with with '~' character to separate values

Example field in csv file:

COM_CROMPARTS_HOMOLOGACION_DEL_VEHICULO_PARA_ITV-1~COM_CROMPARTS_HOMOLOGACION_DEL_VEHICULO_PARA_ITV-1
Homologación del vehículo sin la modificación~Homologación del vehículo sin la modificación2222

EXPORTACION_SUSPENSION_DEPORTIVA.CSV

but when I import the custom field COM_CROMPARTS_HOMOLOGACION_DEL_VEHICULO_PARA_ITV-1 have online one value with all the values
tercersectormapa4.jpg


Can you explain how can create a csv to import these custom fields with its prices ?


thanks a lot
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Lucafo,
The problem is the way you have your custom fields in your import file. Since you have to import multiple values for custom fields you need to use custom_title and custom_value fields. This is also explained in the document you posted and in CUSTOM FIELDS WITH MULTIPLE VALUES section. Take a look at the example CSV file in the document. And here is an example with your custom fields on how it should look like

product_sku;custom_title;custom_value

PROVA;COM_CROMPARTS_HOMOLOGACION_DEL_VEHICULO_PARA_ITV-1~COM_CROMPARTS_HOMOLOGACION_DEL_VEHICULO_PARA_ITV-1;Homologación del vehículo sin la modificación~Homologación del vehículo sin la modificación2222
Kind regards,

Tharuna

=========================
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
lucafo
lucafo
Accepted Answer Pending Moderation
Hello Taruna

thanks for your reply

How can I set the price for every custom_value ?

thanks a lot
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Lucafo,
You should use custom_price field for prices for custom_value fields. It is explained in Import product with custom fields document.
Kind regards,

Tharuna

=========================
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!