Is there an easy way to update my existing index using a CSV file?
By easy I mean, no code involved.
I’m keeping a Google Sheet as my source of truth (dataset). Every now and then (twice a year) I’ll need to sync the Sheet with Algolia. I’m planning to export a CSV file and use it to update existing records and add new ones.
Yes, you can upload a CSV file to your index via the dashboard:
Note that if you want to update your existing records, the CSV file must include an objectID field and the value in the CSV must match the existing value in the index – otherwise we will create a new record rather than updating the existing one.
You may also be interested in our new Connector and Flow feature we will be debuting next week at our Developer Conference – these will help automate the process if retrieving the CSV file and mapping objectIDs.
Finally, there is a basic Zapier integration you could use for doing the attribute mapping, if you’re comfortable with stitching things together in Zapier:
Do you have any tips on the “Connector and Flow” feature you mentioned?
I can produce a CSV file with all the info I need for indexing (I might be able to do a Jason format too) but my ecommerce website doesn’t have a feature to upload this to Algolia using the API and I’m just after an easy solution for this.
If I produce a file accessible at a URL that’s updated hourly what’s the easiest way of sending this to Algolia for indexing?
Ah this looks great, exactly what I’m looking for. I’d love to be a test case if this is possible? If not is there a time frame for the connector and flow becoming available?
I use the Maropost / Neto platform. At the moment and I have an integration by a third party but the synchronisation is really slow 4->5hrs at best, possibly 12hrs or longer and as a retail store it doesn’t work when we start a sale or add products as updates in search don’t happen for ages.
I was looking at using AWS to host my own tool to push the csv to Algolia but it seems overkill when I can export a csv or jason file to a url every hour, I just need to send this file to Algolia.
Hi @keshia.rose! I just watched the video about the connectors and flows and it looks incredible! I’ve been waiting for this feature since the original post. Do you think I could also take it for a spin?
Thank you and a happy new yar to you and all the Algolia team!