1. rocketcert
  2. RO CSVI
  3. Tuesday, 20 April 2021
  4.  Subscribe via email
Is it possible to have the file that is exported into google sheets be a csv? As of right now, it appears to be an xml, and not the easiest to see or understand the data.
Attachments (1)
Accepted Answer Pending Moderation
Hello,
Is it possible to have the file that is exported into google sheets be a csv? As of right now, it appears to be an xml, and not the easiest to see or understand the data.

The settings in export template would have been set to export as XML and so the output is saved as XML. Can you post the debug log of the export to check? To get the debug log check How to collect debug information? document.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Attached are screenshots of our settings as well as debug log.
Attachments (4)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Thank you for the screenshots and debug log. I see that you have set export operation as Google Merchant in Details tab in export template settings. This operation is used to generate XML file so to upload product information to Google Product Search. Are you looking to export product information for Google Product Search or you want to export product details from VirtueMart to Google sheets?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
I think that is where I'm a bit confused with regards to the best way to achieve our goal.

Our goal, is to have google merchant center read a google sheet of product data.

Tom
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Tom,
Our goal, is to have google merchant center read a google sheet of product data.

With Google merchant operation it is only possible to export data in XML format. So if you want to export product data to google sheet then i would suggest to use VirtueMart Product export operation instead of Google merchant. You can set the needed column headers in template fields in Column headers field. See attached screenshot.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!