Google Merchant Center XML Export Question for Virtuemart.
Joomla 3.5.1
VM3.0.16
CSVi 6.5.7
Nearly finished with this, but I have another question/problem :huh:
We need to remove parent products from the export, where the parent product is set "Not Orderable".
We have parent Products set up in most cases as a sort of placeholder for the children products.
Running the export, exports all the "Not - Orderable" products, which causes problems when importing that to Google.
Any ideas, solutions welcomed.
Thanks,
Andy
Nil Satis Nisi Optimum !
Hey Andy,
On the product export template under the Options tab you have a Product SKU filter here you can set which SKUs to exclude. That is the only thing I can think of that can be used to not export certain products.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
On the product export template under the Options tab you have a Product SKU filter here you can set which SKUs to exclude.
:blink: Ah OK, I'll give that a go.
I just wandered wether there was a way to exclude these Parent products (where that products is not orderable) for the** Google Merchant Export**(only), as these will never be needed & cause problems with the XML import to Google.
The filter option will work for now :)
Nil Satis Nisi Optimum !
Hey Andy,
That is something we can do, just no one asked/mentioned/thought about it before.
The Not Orderable option is part of a plugin right? Which plugin are you using in this case?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
The Not Orderable option is part of a plugin right? Which plugin are you using in this case
The checkbox for Parent products "Not Orderable" is part of the generic child plugin.
I am using the newer Multi-Variant Custom Field Plugin (Part of VM Core) , where the "Not Orderable" is assumed when you set the products options.
*See the last 2 lines of this support document here *- http://docs.virtuemart.net/tutorials/product-creation/221-multivariant.html
I have not tested your idea of using the Product SKU Filter, but I am guessing that if I exclude a parent SKU, then the export will not pull the data for the children that is re-used, like; Description, Manufacturer, Category, etc, as these are all values stored only in the Parent -* In 99% of cases anyway*
Nil Satis Nisi Optimum !
Hello Andy,
but I am guessing that if I exclude a parent SKU, then the export will not pull the data for the children that is re-used
We don't need to guess that, I can tell you that the parent data is not re-used by CSVI. The reason is pretty simple, if CSVI would export the parent data for the child product you wouldn't be able to see what is actually stored for the child.
This will hold true for the product export but for the Google Merchant export that could be changed as there it is just a matter of exporting the data and not maintaining it for import. So another job on my todo list :)
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
This will hold true for the product export but for the Google Merchant export that could be changed as there it is just a matter of exporting the data and not maintaining it for import. So another job on my todo list :)
That sounds perfect for my specific problem here, Would we still add the parent products to the SKU filer & your "Google Merchant" Plugin does all the magic?
What about other shops that do have different data for there child products? I don't there are many scenarios like this (I certainly don't have any), but I assume there are shops out there that may have a different short or long description for there child product.
In this case if a Short Long Description exists, will the plugin use that instead of the parent data?
Let me know if theres anything I can do or help test?
Nil Satis Nisi Optimum !
Would we still add the parent products to the SKU filer & your "Google Merchant" Plugin does all the magic?
That I need to check what I can do, haven't decided yet as I want to get a clearer picture of what needs to happen.
What about other shops that do have different data for there child products?
Another thing I need to find out because that is the pain with plugins, nothing is standard. Usually every exception needs to be coded.
In this case if a Short Long Description exists, will the plugin use that instead of the parent data?
The parent data is only used if the child has no value set for it.
Let me know if theres anything I can do or help test?
I will report back here when I have something to test. Thanks.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
I am not pressuring :whistle: ,but is there anything I can do to help with this, as I think this is the last part of the jigsaw that is holding us back from using this properly now?
Thanks in advance,
Andy
Nil Satis Nisi Optimum !
Hey Andy,
Not feeling any pressure :silly: I have started to look into it but it's not as easy as I was expecting and Joomla has kept me busy :)
At this moment, I can't really say how much more work it is but still quite a bit more heavy lifting to do.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Andy,
I finally got my mind put to this and I believe the attached patch works as expected. If you are exporting any product parent it will be exported unless it is either has a multi-variant or generic plugin linked. The multi-variant parent will only export if it matches the rules. The generic plugin will only export if the option is set for the parent to be orderable.
Please give it a try and let know what you think.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Not sure where it has crept back in, but Parents are now being exported again, where they are not needed?
We have updated CSVi to 6.6.2, Updated the plugin & installed the patch file from this thread - https://csvimproved.com/forum?view=topic&catid=44&id=33339#50572
Nil Satis Nisi Optimum !
Hey Andy,
The patch Tharuna posted is only an update on the SQL file, so this has no effect on the code side of things. If you install the patch I posted 2 posts prior. Does that fix the export?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
com_csvi.log.62.txt.zip
I re installed this patch file
Cleared cache, re installed again , but exporting still shows the parents of multi variant products.
Not sure if the log helps, but attached it?
Thanks
Andy
Nil Satis Nisi Optimum !
Hey Andy,
So I have been looking into this issue but I don't see a reason why it would export the parent products. The debug log has no logging when it is processing parent products.
What you need is version CSVI 6.6.2, CSVI VirtueMart 6.6.2 and the custom field patch. That should be enough to export your data.
Now if you have parent products exported with that combo, we need to look at the why and if it happens for all parent products. A product with a value set for product_parent_id is always exported since that is a child product. If the parent value is 0, then CSVI checks if there is any plugin associated with the product. In case there are no plugins associated, the parent product is exported because it is a single product. In case there are any plugins associated with the product, CSVI checks if it is an orderable parent. The check is only done for multi-variant and generic child variants. Anything else the product is exported.
The question now is, can we look at one parent product that is being exported and what are the properties of this product that may cause it to be exported.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Yes we are using version CSVI 6.6.2, CSVI VirtueMart 6.6.2 and the custom field patch.
The very first product in this Google XML export, "Draughtex" is a Parent - https://www.lowenergysupermarket.com/Google-MC/LES-GMC.xml
This has 3 children set up as Multi Variant - All of our Parent/Children are set up as Multi variant & only the children are orderable
Here is the same draughtex product in the front end - https://www.lowenergysupermarket.com/insulation/56/draughtex-floorboard-skirting-board-insulation-les
Do you need admin access to take a peak to see what may be wrong here?
Nil Satis Nisi Optimum !
Hey Andy,
If you can give me access that would be great, so I have to guess less. Never won the lottery, so don't count on my guessing :P
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Add here, email or send via skype?
Nil Satis Nisi Optimum !
The issue is with 2 bugs in CSVI, these will be resolved in the upcoming 6.6.3 release.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.