Resolved Import Custom Field

Hello Fernando,

Let's check a few things. The custom fields you are importing, which type do they have? I see you have these custom fields:

• 1- Escoge una Medida
• 2- Escoge acabado del cuadro
• 2- Escoge acabado del cuadro
• 2- Escoge acabado del cuadro~Tags

Notice you have a number of duplicate names, this means you must use the custom_multiple field, otherwise only the last one will be updated.

What is this Tags you mention?

Hi Rolandd
The field " 1- Escoge una Medida-" is of type generic child variant.
The field "2- Escoge acabado del cuadro" is of type chain
The field "tags" is of type plugin.
Are the parameters that an export shipment of a product with these custom fields.
Greetings.
Fernando.

Hello Fernando,

The field "2- Escoge acabado del cuadro" is of type chain

I don't see the type chain in the default VirtueMart installation.

The field "tags" is of type plugin.

There are only a few plugins supported by CSVI and the tags plugin, I have never heard of.

So the problems with these 2 fields is that they are not supported by CSVI and that is why they won't show up. That is why you only see the generic child variant show up with the product.

As for the releated categories issue, I don't see anything about that in the debug log because the log is too short. If you could import only 1 product with related categories, I can check that debug log.

Which version of CSVI are you using?

Hi Rolandd
Csvi version is 5.21.2
attached configuring product settings and custom fields.
Greetings

Hello Fernando,

The tags plugin cannot be imported by CSVI, since it has no support for it. The other issue is that your custom_values are not the same amount of values as the custom title field. The Cadena field is not a chain but a string

So let's look at the first product with a custom field in it and clean it up, this is product_sku 1014. The custom_title field needs to be

1- Escoge una Medida~2- Escoge acabado del cuadro~2- Escoge acabado del cuadro~2- Escoge acabado del cuadro

Because you have field 2- Escoge acabado del cuadro more than one time you must add the field custom_multiple with

N~Y~Y~Y

Next is the custom_values this needs to be

product_sku~Color~Blanco y Negro~Sepia

The custom_param field does not need to be used. This should import these fields for you if you update your file accordingly.

Hi Roland
Thank you very much for the support, now to operate normally. Any ideas for the categories related import properly?

Greetings

Fernando

Hello Fernando,

As asked before, import only a product with related categories and post that debug log. So far the debug logs are too small and don't show the product with the related categories, so there is nothing for me to see. Once I have the debug log I can check.

Hi Roland
Attached log and view view category imported.

Greetins

Hello Fernando,

You did not include the debug log, can you post it?

Sorry.
Attached

Hello Fernando,

This debug log is good, I can see the related categories being processed. This one for example

INSERT INTO `jos_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_params`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES  ('122','1','116','wPrice=0|wImage=0|wDescr=0|width=\"90\"|height=\"90\"|','0','2015-06-05 17:16:01','500','2015-06-05 17:16:01','500')

This links category ID 116 to product ID 122. You don't see this at all?

Do you see the related categories in the Custom fields list?

I not see the categories in the Product custom fields Fig.
The text is the product of 122 and relate it to the categories 34 and 35.

The link ID 116 is another product. The ID categories is 34 and 35

I see that you have the same category used for category_path and related_category, CUADROS DE MADRID/Fotos en Lienzo de Madrid, that doesn't make sense

The code I posted before is of the related products, not the related categories. Apologies.Looking further, I see it actually doesn't find the category ID. This is the category query

INSERT INTO `jos_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES  ('122','2','0','2015-06-05 17:16:01','500','2015-06-05 17:16:01','500')

this is missing the customfield_value field.

If you execute this query in PhpMyAdmin, do you get any result:

SELECT c.virtuemart_category_id FROM jos_virtuemart_categories c LEFT JOIN jos_virtuemart_category_categories x ON c.virtuemart_category_id = x.category_child_id LEFT JOIN jos_virtuemart_categories_es_es l ON l.virtuemart_category_id = c.virtuemart_category_id WHERE l.category_name = 'Cuadros de Jorge Arranz' AND x.category_child_id = c.virtuemart_category_id AND x.category_parent_id = 33

as far as I can tell, this doesn't give any result.

Hello Roland
Thanks for your support.
I've tried various configurations in the field related categories: put the full path, only the subcategory, category without subcategories, the id of the category, and I get nothing.

what else I can do?

Thanks.

Fernando.

Hello Fernando,

Send me an email or private message with the file you are importing, URL and login details of the site and FTP and I will take a look.

private message sent

http://eurowebmaster.es/taller/administrator/index.php

Hello Fernando,

You can import the related categories now. The issue was that you are using a newer version of VirtueMart and the code has not been updated yet to deal with the column changes. These changes are now in your file and will be in the next release of CSVI.

Hi Roland
Now it works, thank you very much for your management, you do feel a great support.
kind regards