1. emperor
  2. RO CSVI
  3. Tuesday, 17 October 2017
  4.  Subscribe via email
Greetings, I am assigned on creating a vast amount of products (some thousands of them) so we've decided to use CSV Improved to make the task viable.

The thing is that we are using a lot of custom fields for these products, and i am struggling to understand how to create a CSV that will help with that task.

As i see in the documentation, the only obligatory field is custom_title. Then i have to enter custom_value and field_type.

custom_title, is the title of the custom field. I get that.
field_type is the type of data, which in my case is string.
custom_value is the value that each product will have. Is that correct?

In my case i have to do with sizes, so for example:

Product 1x1 will need to have a custom field custom value of sz-1x1-feet
Product 2x2 will need to have a custom field custom value of sz-2x2-feet
.
.
.
Product 15x15 will need to have a custom field custom value of sz-15x15-feet


How i am going to assign that to the product? I don't see any related field available.

Thanks in advance
Accepted Answer Pending Moderation
Thank you very much! That helped a lot indeed!
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
Now if I need to import multiple custom fields, 32 for each product some of which have the same name. Some of them are plugins, some are strings etc. How can I achieve that? The method I used works only for 1 custom field since custom_title custom_value etc must be unique per CSV file.

String custom fields will be available as template fields in your product import template so you can use them directly as a column header instead of using them in custom_title, custom_value.

An example as per your CSV file is like
product_sku;Standard Product Size
VB1;sz-1x1-feet

For the plugin fields you did not specify which plugin type you are using. You can look at Stockable custom fields import and Custom fields for all import documents if you are using one of them.
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. # 2
Accepted Answer Pending Moderation
Thank you very much. This answered my question.

What i did is to add custom_title and custom value to a product template, and the CSV file productimport3.1.csv

Now if I need to import multiple custom fields, 32 for each product some of which have the same name. Some of them are plugins, some are strings etc. How can I achieve that? The method I used works only for 1 custom field since custom_title custom_value etc must be unique per CSV file.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
Please check the product import with custom fields document to know on how to import custom fields with product. You need to use product_sku field with custom_title, custom_value and custom_params fields in VirtueMart product import.
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. # 4
  • Page :
  • 1


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