How would you approach this?
The scenario I am looking at is:
- a user creates/makes some changes to a Google Docs Spreadsheet (in a format quite similar to the one needed by Magento)
- a script takes this Spreadsheet and performs a validation (columns are valid, attribute values are valid, sku exist and so on)
- if the Spreadsheet is valid for import, additional processing takes place to make it compatible with Magento's Import format (not DataFlow); Magento's import format for attributes with multiple values is not that friendly from a user perspective
- then this Spreadsheet can be imported in Magento.
Are there some extensions that already do this? Other people that have done this, share your experience. Additional things to consider?
Best Answer
Ashley Schroder has written a Google Docs/Drive adapter for the ImportExport module. It's not dataflow and it's fast!
If you really want to do additional processing before doing an import, you may consider using an array-based ImportExport extension such as ApiImport. An added benefit is that it takes care of a bunch of stuff for you (such as indexing). In that case you would have to write the glue between fetching google docs CVS, converting it to an appropriate format, and doing the import.