curl -X POST http://localhost:9200/spymerch_product_dead/_search?rest_total_hits_as_int=true -H 'Content-Type: application/json' -d '{"size":1}'

curl -X DELETE http://localhost:9200/spyamz_products

curl -X PUT http://localhost:9200/spyamz_products -H 'Content-Type: application/json' -d '
{
  "mappings": {
    "properties": {
      "name": {
        "type": "text"
      },
      "brand": {
        "type": "text",
        "fields": {
          "raw": {
            "type":  "keyword"
          }
        }
      },
      "img_sm": {
        "enabled": false
      },
      "img_lg": {
        "enabled": false
      },
      "price": {
        "type": "scaled_float",
        "scaling_factor": 100
      },
      "rating": {
        "type": "scaled_float",
        "scaling_factor": 100
      },
      "reviews": {
        "type": "short"
      },
      "rank": {
        "type": "integer"
      },
      "status": {
        "type": "byte"
      },
      "trademark": {
        "type": "byte"
      },
      "node": {
        "type": "keyword"
      },
      "store_id": {
        "type": "keyword"
      },
      "publish_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss"
      },
      "first_sold_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss"
      },
      "created_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
      },
      "updated_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
      },
      "deleted_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
      }
    }
  }
}
'


curl -X DELETE http://localhost:9200/spymerch_products

curl -X PUT http://localhost:9200/spymerch_products -H 'Content-Type: application/json' -d '
{
  "mappings": {
    "properties": {
      "name": {
        "type": "text"
      },
      "brand": {
        "type": "text",
        "fields": {
          "raw": {
            "type":  "keyword"
          }
        }
      },
      "keywords": {
        "type": "text"
      },
      "img": {
        "enabled": false
      },
      "img_lg": {
        "enabled": false
      },
      "colors": {
        "type": "keyword"
      },
      "type": {
        "type": "byte"
      },
      "price": {
        "type": "scaled_float",
        "scaling_factor": 100
      },
      "rating": {
        "type": "scaled_float",
        "scaling_factor": 100
      },
      "reviews": {
        "type": "short"
      },
      "rank": {
        "type": "integer"
      },
      "score": {
        "type": "float"
      },
      "status": {
        "type": "byte"
      },
      "first_sold_days": {
        "type": "integer"
      },
      "first_sold_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss"
      },
      "publish_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss"
      },
      "created_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
      },
      "updated_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
      },
      "deleted_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
      }
    }
  }
}
'



curl -X DELETE http://localhost:9200/spymerch_product_dead

curl -X PUT http://localhost:9200/spymerch_product_dead -H 'Content-Type: application/json' -d '
{
  "mappings": {
    "properties": {
      "name": {
        "type": "text"
      },
      "brand": {
        "type": "text",
        "fields": {
          "raw": {
            "type":  "keyword"
          }
        }
      },
      "keywords": {
        "type": "text"
      },
      "img": {
        "enabled": false
      },
      "img_lg": {
        "enabled": false
      },
      "colors": {
        "type": "keyword"
      },
      "type": {
        "type": "byte"
      },
      "price": {
        "type": "scaled_float",
        "scaling_factor": 100
      },
      "rating": {
        "type": "scaled_float",
        "scaling_factor": 100
      },
      "reviews": {
        "type": "short"
      },
      "rank": {
        "type": "integer"
      },
      "score": {
        "type": "float"
      },
      "first_sold_days": {
        "type": "integer"
      },
      "first_sold_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss"
      },
      "publish_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss"
      },
      "created_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
      },
      "updated_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
      },
      "deleted_at": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
      }
    }
  }
}
'