Algolia Upload Records with hierarchy of categories through CSV to index from dashboard

Question

I have product CSV data to upload to Algolia index with hierarchy of Category->Sub-Category-> Sub-Category-2

Example is as follows:

level0 - categories.level0: Cutlery

level1 - categories.level1: Cutlery /// Tablekraft Cutlery

level2 - categories.level2: Cutlery /// Tablekraft Cutlery /// Bogart

I'm using either CSV or TSV to upload records to Algolia. I'm happy to use JSON import if its easy to use.

Result set is as follows:

"sku","name","categories"
"GR10107","Tablekraft Oberon Satin 58pce Cutlery","Cutlery"
"GR10108","Tablekraft Gable 58pce Cutlery","Cutlery /// Tablekraft Cutlery"
"GR10109","Tablekraft Gable Bogart","Cutlery /// Tablekraft Cutlery /// Bogart"

Final objective is to use category field as facet.

Answer 1

等待大神答复