Resolved Custom field Import Problems

Hello,
As per your import file you are trying to import product details along with custom fields so in your import template settings you have set operation to be product instead of customfield. Change it, save the template and then run the import.

Hello Tharuna

Many thanks for your speedy response. I will try that. Just a question? Can I add the product information fields etc on a customfield import ?

Appreciate the assistance!

Hello,
You can not add product information in custom field import but you can add custom field in product import. Have a look at custom field import and export and product import with custom fields documents to know the difference.

Thank you. One last question. Is my csv file correct?

Hello,
I do see a problem in your csv file. custom_title value is empty for few products but there is a custom_value for those. You need to have both custom_title and custom_value field filled. You can check the examples in the document i linked in my previous post. May i also know why the custom_value is product_name when custom_title is Sizes?

Hi Tharuna

This is my first attempt at using the generic child variant option. Previously I used a string value which I manually updated for each product after upload. This has become really time consuming and the string values don't export when I process order reports. I found a layout on one of the forum questions which I tried to use as a guide.

I am struggling to understand but will try work it out. Can you advise on a way forward on correcting the CSV?

Thank you so much for your help

Regards

Tony

Hello Tony,

This is my first attempt at using the generic child variant option. Previously I used a string value which I manually updated for each product after upload.

You could have used string custom field with product details in your import file instead of updating it manually. If you need any help, post the debug log of the import along with import file to check. To know on how to get the debug log, check Where to get debug information? section on top of this page.

This has become really time consuming and the string values don't export when I process order reports.

VirtueMart stores custom fields in product_attribute field for orders. You need to use this field in your export template.

I am struggling to understand but will try work it out. Can you advise on a way forward on correcting the CSV?

You can follow the example in Product import with custom fields document. All i wanted to say was that you have empty custom_title field in your import file though there is a custom_value. You need to fill in custom_title field else processing of the custom field wont happen for the product as CSVI checks for both custom_title and custom_value while running the import.

Hi Tharuna

Many thanks for all your help. I appreciate your help. Is there perhaps a sample of csv using a string value to populate clothing with size options only? That seems to be where I am struggling to understand. I don't have a debug file as I have only uploaded the products with price etc and then gone in and added the string values.

I think my problem is understanding the CSV creation.

Once again thank you for your help.

Hello Tony,
If you have Size as a string custom field in VirtueMart then you would have this Size as an available field in your template when you update your available fields. You can then use this custom field for single values like

product_sku;product_name;Size
1001;product1;L
1002;product2;XL

If there are multiple values for Size then you can use it as

product_sku;product_name;custom_title;custom_value
1001;product1;Size~Size~Size;L~S~XL

Hope it is clear.

Hi Tharuna

Thank you so much. I will give it a try this side. Might bug you if I get stuck :lol:

Regards

Tony

Hi Tharuna

Have created the attached and tried to import using custom fields. Updated available fields before the import.

Message

Unsupported Failure These fields have been found but are not supported by CSVI:

product_sku
product_name
product_desc
product_price
file_url

. Either these fields do not exist in your system, or the list of available fields need to be updated. To update the list of available fields go to Available Fields and click on Update.

I have attached the csv and debug for you.

Thanks

Tony midas_26_april_2017_test3csv.csv com_csvi.log.110.zip

Hello Tony,
As i already said you need to use operation as product instead of custom fields in your template settings. This way you wont see unsupported fields error. Second is that custom_title and custom_value in your import file they should be separated with ~ like SelectSize~SelectSize~SelectSize~SelectSize and not `SelectSize`SelectSize`SelectSize`SelectSize and the same goes for custom_value, it should be XS~S~M~L~XL~2XL and not XS`S`M`L`XL`2XL. Do these two changes and try doing the import.

Hi Tharuna

it seems you have finally got me on the right path. I have managed to get the clothing along with the sizing in. Another question (I'm sure you are sick if me by now) I also have gift items without custom fields. Can I add these using a separate csv?

Once again, thank you for fixing what I have struggled with for days!!

Warm Regards

Tony

Hello Tony,

Another question (I'm sure you are sick if me by now) I also have gift items without custom fields. Can I add these using a separate csv?

You don't have to create a separate csv file, you can add those in same csv file and leave custom_title and custom_value empty. This way CSVI knows there are no custom fields for that product.

Once again, thank you for fixing what I have struggled with for days!!

Glad to know i was able to help you solve your issues. Would appreciate if you can give us a review on Joomla extension directory.