Hi Rolandd
I'm trying to import products with custom fields. First I have exported a product with custom fields, generic child variant, chain and tags. Then I copied the same parameters to another product, and have imported the table, but not update the custom fields. (Fig 1)
Nor updates related categories. (Fig.2)
Deputy sending the import table, and the log file. Not that I'm doing wrong, can you help?
Thanks greetings.
Fernando
Accepted Answer
Pending Moderation
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:
What is this Tags you mention?
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
What is this Tags you mention?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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.
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.
Accepted Answer
Pending Moderation
Hello Fernando,
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?
The field "2- Escoge acabado del cuadro" is of type chainI 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?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Rolandd
Csvi version is 5.21.2
attached configuring product settings and custom fields.
Greetings
Csvi version is 5.21.2
attached configuring product settings and custom fields.
Greetings
Attachments (5)
Accepted Answer
Pending Moderation
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![;)](/csvimig/media/com_easydiscuss/images/markitup/emoticon-wink.png)
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
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
![;)](/csvimig/media/com_easydiscuss/images/markitup/emoticon-wink.png)
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 cuadroBecause you have field 2- Escoge acabado del cuadro more than one time you must add the field custom_multiple with
N~Y~Y~YNext is the custom_values this needs to be
product_sku~Color~Blanco y Negro~SepiaThe custom_param field does not need to be used. This should import these fields for you if you update your file accordingly.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Roland
Thank you very much for the support, now to operate normally. Any ideas for the categories related import properly?
Greetings
Fernando
Thank you very much for the support, now to operate normally. Any ideas for the categories related import properly?
Greetings
Fernando
Accepted Answer
Pending Moderation
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.
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Roland
Attached log and view view category imported.
Greetins
Attached log and view view category imported.
Greetins
Attachments (2)
Accepted Answer
Pending Moderation
Hello Fernando,
You did not include the debug log, can you post it?
You did not include the debug log, can you post it?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello Fernando,
This debug log is good, I can see the related categories being processed. This one for example
Do you see the related categories in the Custom fields list?
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?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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
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
Attachments (1)
Accepted Answer
Pending Moderation
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 ![:)](/csvimig/media/com_easydiscuss/images/markitup/emoticon-smile.png)
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
If you execute this query in PhpMyAdmin, do you get any result:
![:)](/csvimig/media/com_easydiscuss/images/markitup/emoticon-smile.png)
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. Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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.
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.
Accepted Answer
Pending Moderation
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.
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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.
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »