Hello. I managed to create a file for google base solving all errors. Now I should match the categories of my site to categories required for Google, but my product child does not have products categories compiled. Can match the categories father only on export, without changing the data in the database?
Thanks
Kindly help someone I know? it is possible to fill in CSVI categories of children products, only on export, taking classes from parents?
Hello,
I am working on the patch to get this, will be sending it once fixed and tested. Sorry for not letting you know on that.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
OK thanks. I take this opportunity to congratulate you for the work you are doing
Hello,
Can you try doing the export using the attached patch file?. You can load the patch file from maintenance menu option.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello. I installed the patch, now the categories of child products are compiled.
it is possible to have the same function even for the normal export of the products in csv?
Hello,
Please load the attached patch file which will complile parent category for child in normal product export in CSV file.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
Please note that this patch will not be part of a future release of CSVI. Child products with no categories should remain as such on export because if you will import this, the child products will all of a sudden show up on your site. This is usually not wanted because you get a bit of a mess. Child products are just variations of a parent product and thus should only show up when you make a selection at the parent.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thank you for your reply. Without this patch, how do export the products child a single category? If the products are not combined with a child category CSVI not export them when I check the name of the parent category
Alternatively, is possible to apply the patch only on the required export template?
Hello,
Without this patch, how do export the products child a single category?
If you are asking how you can export child products from a specific category, you can do that by setting the options in your template. You select your single category and set the Child products only to Yes.
If the products are not combined with a child category CSVI not export them when I check the name of the parent category
Can you explain this in more detail?
Alternatively, is possible to apply the patch only on the required export template?
That is not possible.
Perhaps I should clear something up as well. The export of the category_path for child products that do not have a category path will be included for the Google base export but not for the regular product export.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
In normal export csv, if I select the template single category and do export only child product, the CSV file is empty.
Hello,
Please post your debug log.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
thanks
The debug log is not attached.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
:blush:
is upload?
Hello,
As per the debug log i don't see the single category is set nor Child products set to Yes. If you don't find these fields, try clicking Advanced button on top right corner. Can you try setting these and do the export?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
sorry, here's the new log file
Hello,
So this log shows you are exporting only child products for a specific category. Now I can't see the name of the category but the ID is 42. The products being exported are these IDs 261,262,263,264,265,454,267,268,269,270,271,272,273.
What is in your export file? If there is nothing in the export file, it would mean that either these IDs don't exist or they do not exist in category ID 42.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Category id 42 exist (cuscini)
IDs 261,262,263,264,265,454,267,268,269,270,271,272,273 is product child (in any category published)
ID 106 is product parent (cuscini) in category id 42
IDs 261,262,263,264,265,454,267,268,269,270,271,272,273 is product child (in any category published)
You mean they don't have a category assigned?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
exact. only the product parent has an assigned category
That is then the reason why your export is empty.
WHERE `#__virtuemart_product_categories`.`virtuemart_category_id` IN (42) AND #__virtuemart_products.virtuemart_product_id IN (261,262,263,264,265,454,267,268,269,270,271,272,273)
This never matches anything because these products are not in category cuscini.
If you only want these couple of products in an export file, you can use the Product SKU filter. The combination you want isn't possible because for the system there is no relation between these child products and category.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
ok thanks
Log in to reply to this topic.