Resolved CSVI Pro in Joomla 3.4, Virtuemart 3.06

Hello Michael,

Where do you set the condition of the product in VirtueMart? Nowhere, VirtueMart doesn't have this by default. If all your products are new you can add a [b]custom[b] field to your template and set the default value to new. So the export will always export this field with new. That may be enough in your case.

Hi rolandd,

thanks for your fast answer.
But how I can add a costum-field like "condition" global to all products?
I need a detailed description for doing this. You now, beside of that I must translate all your tips the into german language :S

Regards Michael

Hi RolandD,

i have solved it by myself.
The whole problem was a >"< at the beginning of one short-descritpion from a product. This little thing makes the csv-file completely confused. So google can´t read it.

THANKX! Michael

Hello Michael,

Thank you for your feedback. A short description with a " symbol shouldn't be a problem though if you also set the text enclosure in your export template. At least you found your solution.

Hello Roland,

The google merchant center can read products out of the csvi-Pro-files.
The problems are the URL relativ-links for product and images that was generated by csvi.
They must be change to absolute links.
But how I can manage this? I found no options therefore.

Best regards Michael

Sorry, I found the options in "Einstellungen". Here is the field for the domain-name. Dont forget "http://".
Sometimes it is not easy to translate the backend to german.

Best regards Michael

Thank you for posting your solution Michael. Indeed, the domain name needs to be set in the Settings of CSVI.

Hi rolandd,

suddenly I have massive problems to compile any file with products wirh csvi.
Database is not correct:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM trawH_virtuemart_products LEFT JOIN trawH_virtuemart_product_prices ON traw' at line 2 SQL=SELECT FROM trawH_virtuemart_products LEFT JOIN
trawH_virtuemart_product_prices ON trawH_virtuemart_products.virtuemart_product_id = trawH_virtuemart_product_prices.virtuemart_product_id LEFT JOIN trawH_virtuemart_product_manufacturers ON trawH_virtuemart_products.virtuemart_product_id = trawH_virtuemart_product_manufacturers.virtuemart_product_id LEFT JOIN trawH_virtuemart_manufacturers ON trawH_virtuemart_product_manufacturers.virtuemart_manufacturer_id = trawH_virtuemart_manufacturers.virtuemart_manufacturer_id LEFT JOIN trawH_virtuemart_product_categories ON trawH_virtuemart_products.virtuemart_product_id = trawH_virtuemart_product_categories.virtuemart_product_id LEFT JOIN trawH_virtuemart_categories ON trawH_virtuemart_product_categories.virtuemart_category_id = trawH_virtuemart_categories.virtuemart_category_id LEFT JOIN trawH_virtuemart_currencies ON trawH_virtuemart_currencies.virtuemart_currency_id = trawH_virtuemart_product_prices.product_currency LEFT JOIN trawH_virtuemart_product_shoppergroups ON trawH_virtuemart_product_shoppergroups.virtuemart_product_id = trawH_virtuemart_products.virtuemart_product_id WHERE trawH_virtuemart_products.published = '1' LIMIT 0, 169

Whats wrong?

Best regards Michael

Hello rolandd,

apparently a joomla-update and a virtuemart update at the same time bred the database-error.
After these updates all fields for all templates in csvi suddenly gets the status unpuplished.
Additional, product-edits in virtuemart have no save or cancel function (Version 3.062).
In this case csvi reads any other contents out of the database.

Please don´t update to virtuemart 3.062 under joomla 3.41. Take directly virtuemart 3.064!

Best regards Michael

Hello Michael,

Indeed there was a problem between Joomla 3.4.1 (not 41 :silly and VirtueMart. The same issue appeared in some other extension I heard. It was a problem Joomla fixed which in turn broke extensions that luckily worked with the problem but broke when the problem was corrected.

Funky situation for sure