RO CSVI

Setting up Google Sheets import using RO CSVI

A step by step instruction on setting up Google Sheets import using RO CSVI with an import template is explained in this document.

Step by step setting up Google Sheets import using RO CSVI

  1. Check that you have setup the Google token as explained in the Google API settings for import and export document.
  2. Create a VirtueMart Product Import template
  3. On Source tab select Source as Load from Google Sheets

    Setting up Google Sheets import using RO CSVI

  4. Now enter the Spreadsheet details. Consider an example spreadsheet like https://docs.google.com/spreadsheets/d/1g9isWCeljHGSpbLbDsdarF89OVvmy8AI4nUWHUZxXis/edit#gid=0
  5. Spreadsheet id is 1g9isWCeljHGSpbLbDsdarF89OVvmy8AI4nUWHUZxXis
  6. Sheet name is Sheet 1
  7. From cell is A
  8. To cell is G
  9. Enter these details and save the template. We are all set for import. 

    Spreadheet details Google

  10. Go to RO CSVI Import page and do the import as usual, RO CSVI will read the Google Sheet and show the details on Preview page. If everything is good, the import can be started.

  11. Once the import is done, the log details page shows the import result

    Import result from importing data out of Google Sheets

Related Articles