tool

• id: 78
  tools_id: AOAT-000078
  tools_url: https://zipchat.ai
  tools_name: Zipchat AI
  publish_date: 2023-03-29
  is_active: 1
  created_at: 2025-07-23T05:58:33.471061
  updated_at: 2025-07-27T08:15:21.895024
  

---

badges

• tool_id: 78
  badge_id: 35
  is_active:
  created_at: 2025-08-31T10:05:05.282967
  value: 1
  id: 55128
  updated_at: 2025-08-31T12:56:27.351129
  value_text:
  

---

• tool_id: 78
  badge_id: 17
  is_active: 1
  created_at: 2025-07-21T12:34:50.291939
  value: 1
  id: 2240
  updated_at: 2025-07-27T08:11:45.309133
  value_text:
  

---

images

• image_id: 303
  tool_id: 78
  image_url: https://ageofai.tools/wp-content/uploads/img/AOAT-000078-img-160.png
  image_type: gallery
  alt_text:
  order: 1
  is_active: 1
  created_at: 2025-07-23T06:21:01.537453
  updated_at: 2025-07-27T08:07:15.656641
  

---

• image_id: 304
  tool_id: 78
  image_url: https://ageofai.tools/wp-content/uploads/img/AOAT-000078-img-161.png
  image_type: gallery
  alt_text:
  order: 2
  is_active: 1
  created_at: 2025-07-23T06:21:01.537453
  updated_at: 2025-07-27T08:07:15.656641
  

---

• image_id: 301
  tool_id: 78
  image_url: https://ageofai.tools/wp-content/uploads/logo/AOAT-000078-logo.png
  image_type: logo
  alt_text:
  order:
  is_active: 1
  created_at: 2025-07-23T06:21:01.537453
  updated_at: 2025-07-27T08:07:15.656641
  

---

• image_id: 302
  tool_id: 78
  image_url: https://ageofai.tools/wp-content/uploads/sc/AOAT-000078-sc-8413.png
  image_type: screenshot
  alt_text:
  order:
  is_active: 1
  created_at: 2025-07-23T06:21:01.537453
  updated_at: 2025-07-27T08:07:15.656641
  

---

all_pricing_models

• pricing_model_id: 9
  pricing_model_name: Hybrid Models
  is_active:
  sort: 0
  

---

• pricing_model_id: 10
  pricing_model_name: Deprecated/Legacy
  is_active:
  sort: 0
  

---

• pricing_model_id: 1
  pricing_model_name: Free
  is_active: 1
  sort: 1
  

---

• pricing_model_id: 2
  pricing_model_name: Freemium
  is_active: 1
  sort: 2
  

---

• pricing_model_id: 12
  pricing_model_name: Free Trial
  is_active: 1
  sort: 3
  

---

• pricing_model_id: 3
  pricing_model_name: Subscription
  is_active: 1
  sort: 6
  

---

• pricing_model_id: 4
  pricing_model_name: Pay-As-You-Go (PAYG)
  is_active: 1
  sort: 4
  

---

• pricing_model_id: 5
  pricing_model_name: One-Time Purchase
  is_active: 1
  sort: 7
  

---

• pricing_model_id: 6
  pricing_model_name: Credit or Token-Based
  is_active: 1
  sort: 5
  

---

• pricing_model_id: 7
  pricing_model_name: Custom Pricing
  is_active: 1
  sort: 8
  

---

• pricing_model_id: 8
  pricing_model_name: Performance-Based
  is_active: 1
  sort: 9
  

---

• pricing_model_id: 11
  pricing_model_name: Miscellaneous
  is_active: 1
  sort: 10
  

---

active_pricing_model_names

ratings

• rating_id: 78
  tool_id: 78
  source_id: 3
  score: 4.820547
  weight:
  comment:
  created_at: 2025-06-28T07:49:38.28653
  is_active: 1
  updated_at: 2025-07-27T08:17:24.286376
  

---

seo

• seo_id: 78
  tool_id: 78
  title: Zipchat AI: 24/7 AI Chat for E-commerce Success
  tldr:
  short_description: Boost e-commerce with Zipchat's AI chatbot. Drive sales, offer 24/7 support, and streamline customer service.
  introduction_title: AI Chatbot Revolutionizes E-commerce: Introducing Zipchat AI for Effortless Sales & Customer Support
  introduction_body: AI chatbot solutions are transforming the e-commerce landscape, and Zipchat AI leads the charge. Designed specifically for e-commerce businesses, Zipchat leverages 100% AI-powered chat to drive sales, provide exceptional customer service, and automate support processes. This innovative tool acts as your 24/7 virtual sales assistant, maximizing ROI while delivering a seamless and personalized shopping experience. With Zipchat AI, you can streamline operations, enhance customer satisfaction, and focus on growing your business without the burden of human oversight.
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  updated_at: 2025-07-27T08:11:20.221553
  

---

social_media

• tool_id: 78
  network_id: 12
  social_media_url: https://linkedin.com/company/zipchat-ai
  is_active: 1
  created_at: 2025-07-01T18:37:01.857979
  id: 211
  updated_at: 2025-07-27T08:14:10.033253
  

---

• tool_id: 78
  network_id: 13
  social_media_url: https://instagram.com/stan.vision
  is_active: 1
  created_at: 2025-07-01T18:37:01.857979
  id: 212
  updated_at: 2025-07-27T08:14:10.033253
  

---

• tool_id: 78
  network_id: 14
  social_media_url: https://twitter.com/stan_vision
  is_active: 1
  created_at: 2025-07-01T18:37:01.857979
  id: 213
  updated_at: 2025-07-27T08:14:10.033253
  

---

• tool_id: 78
  network_id: 15
  social_media_url: https://facebook.com/zipchatai
  is_active: 1
  created_at: 2025-07-01T18:37:01.857979
  id: 214
  updated_at: 2025-07-27T08:14:10.033253
  

---

tags

• tool_id: 78
  tag_id: 3
  weight: 1
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 27
  updated_at: 2025-07-27T08:14:35.369098
  

---

• tool_id: 78
  tag_id: 18
  weight: 4
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 79
  updated_at: 2025-07-27T08:14:35.369098
  

---

• tool_id: 78
  tag_id: 17
  weight: 5
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 232
  updated_at: 2025-07-27T08:14:35.369098
  

---

• tool_id: 78
  tag_id: 52
  weight: 6
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 315
  updated_at: 2025-07-27T08:14:35.369098
  

---

• tool_id: 78
  tag_id: 63
  weight: 3
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 336
  updated_at: 2025-07-27T08:14:35.369098
  

---

• tool_id: 78
  tag_id: 115
  weight: 2
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 353
  updated_at: 2025-07-27T08:14:35.369098
  

---

toolsets

• tool_id: 78
  toolset_id: 16
  weight: 1
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 818
  updated_at: 2025-07-27T08:15:00.645841
  

---

• tool_id: 78
  toolset_id: 39
  weight: 2
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 819
  updated_at: 2025-07-27T08:15:00.645841
  

---

• tool_id: 78
  toolset_id: 33
  weight: 3
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 820
  updated_at: 2025-07-27T08:15:00.645841
  

---

• tool_id: 78
  toolset_id: 14
  weight: 4
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 821
  updated_at: 2025-07-27T08:15:00.645841
  

---

• tool_id: 78
  toolset_id: 29
  weight: 5
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 822
  updated_at: 2025-07-27T08:15:00.645841
  

---

• tool_id: 78
  toolset_id: 31
  weight: 6
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 823
  updated_at: 2025-07-27T08:15:00.645841
  

---

• tool_id: 78
  toolset_id: 17
  weight: 7
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 824
  updated_at: 2025-07-27T08:15:00.645841
  

---

jobs

• tool_id: 78
  job_id: 4
  weight: 1
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1788
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 6
  weight: 2
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1789
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 8
  weight: 3
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1790
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 5
  weight: 4
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1791
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 18
  weight: 5
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1792
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 22
  weight: 6
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1793
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 3
  weight: 7
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1794
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 21
  weight: 8
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1795
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 13
  weight: 9
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1796
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 24
  weight: 10
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1797
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 15
  weight: 11
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1798
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 9
  weight: 12
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1799
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 1
  weight: 13
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1800
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 11
  weight: 14
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1801
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 16
  weight: 15
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1802
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 12
  weight: 16
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1803
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 17
  weight: 17
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1804
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 10
  weight: 18
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1805
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 23
  weight: 19
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1806
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 14
  weight: 20
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1807
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 28
  weight: 21
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1808
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 2
  weight: 22
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1809
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 41
  weight: 23
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1810
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 25
  weight: 24
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1811
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 20
  weight: 25
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1812
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 7
  weight: 26
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1813
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 26
  weight: 27
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1814
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 27
  weight: 28
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1815
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 33
  weight: 29
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1816
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 32
  weight: 30
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1817
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 31
  weight: 31
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1818
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 29
  weight: 32
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1819
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 43
  weight: 33
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1820
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 34
  weight: 34
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1821
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 35
  weight: 35
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1822
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 36
  weight: 36
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1823
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 38
  weight: 37
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1824
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 37
  weight: 38
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1825
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 39
  weight: 39
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1826
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 19
  weight: 40
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1827
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 40
  weight: 41
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1828
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 42
  weight: 42
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1829
  updated_at: 2025-07-27T08:12:08.543303
  

---

• tool_id: 78
  job_id: 30
  weight: 43
  is_active: 1
  created_at: 2025-07-23T06:17:37.581901
  id: 1830
  updated_at: 2025-07-27T08:12:08.543303
  

---

platforms

• tool_id: 78
  platform_id: 1
  priority: 1
  platform_url: https://zipchat.ai
  is_active:
  created_at: 2025-07-23T06:17:37.581901
  id: 78
  updated_at: 2025-08-14T23:37:36.26
  

---

• tool_id: 78
  platform_id: 1
  priority: 1
  platform_url: https://zipchat.ai
  is_active: 1
  created_at: 2025-08-14T20:07:37.97171
  id: 29724
  updated_at: 2025-08-14T20:07:37.97171
  

---

• tool_id: 78
  platform_id: 20
  priority:
  platform_url: https://apps.shopify.com/zipchat
  is_active: 1
  created_at: 2025-09-06T17:10:30.568141
  id: 57643
  updated_at: 2025-09-06T17:10:30.568141
  

---

score_log

• log_id: 178684
  tool_id: 78
  final_score: 4.33
  logged_at: 2025-08-19T16:20:53.067949
  change_reason: rating_sources changed | Coverage: 8.6% | Penalty: 0.8982
  triggered_by: System
  source_summary: Similar web Raiting: 4.820547000 (w=58.000) | Base Score: 4.821 | Final: 4.330
  final_score_2: 4.329829777
  

---

• log_id: 163139
  tool_id: 78
  final_score: 4.34
  logged_at: 2025-08-19T16:20:25.813463
  change_reason: rating_sources changed | Coverage: 10.2% | Penalty: 0.8999
  triggered_by: System
  source_summary: Similar web Raiting: 4.820547000 (w=59.000) | Base Score: 4.821 | Final: 4.338
  final_score_2: 4.3381500412
  

---

• log_id: 146352
  tool_id: 78
  final_score: 4.33
  logged_at: 2025-08-12T06:15:25.263278
  change_reason: Rating source weights updated | Coverage: 8.6% | Penalty: 0.8982
  triggered_by: System
  source_summary: Similar web Raiting: 4.820547000 (w=58.000) | Base Score: 4.821 | Final: 4.330
  final_score_2: 4.329829777
  

---

• log_id: 126801
  tool_id: 78
  final_score: 4.34
  logged_at: 2025-08-11T16:36:22.187859
  change_reason: Applied precise penalty formula - Similar Web = 4.5 | Coverage: 10.2% | Penalty: 0.9000
  triggered_by: Manual Refresh
  source_summary: Similar web Raiting: 4.820547000 (w=49.000) | Base Score: 4.821 | Final: 4.338
  final_score_2: 4.3383332219
  

---

• log_id: 115668
  tool_id: 78
  final_score: 3.74
  logged_at: 2025-08-11T16:32:06.680827
  change_reason: Applied milder penalty formula - v2 | Coverage: 10.2% | Penalty: 0.776
  triggered_by: Manual Refresh
  source_summary: Similar web Raiting: 4.820547000 (w=49.000) | Base Score: 4.821 | Final: 3.738
  final_score_2: 3.738382404
  

---

• log_id: 104535
  tool_id: 78
  final_score: 2.66
  logged_at: 2025-08-11T16:28:07.06408
  change_reason: Applied new fair penalty system | Coverage: 10.2% | Penalty: 0.551
  triggered_by: Manual Refresh
  source_summary: Similar web Raiting: 4.820547000 (w=49.000) | Base Score: 4.821 | Final: 2.656
  final_score_2: 2.6562226285
  

---

• log_id: 93402
  tool_id: 78
  final_score: 4.82
  logged_at: 2025-08-11T16:16:08.254948
  change_reason: weights updated to defaults
  triggered_by: Manual
  source_summary: Similar web Raiting: 4.820547000 (w=49.000)
  final_score_2: 4.820547
  

---

• log_id: 64707
  tool_id: 78
  final_score: 0.49
  logged_at: 2025-08-11T16:10:08.878468
  change_reason: weights updated to defaults
  triggered_by: Manual
  source_summary: Similar web Raiting: 4.820547000 (w=5.00)
  final_score_2: 0.491892551
  

---

• log_id: 29601
  tool_id: 78
  final_score: 4.82
  logged_at: 2025-06-28T07:38:11.151992
  change_reason: New rating added
  triggered_by: System
  source_summary: Similar web Raiting: 4.820547000 (weight: 1.0000)
  final_score_2: 4.820547
  

---

last_update

• tool_id: 78
  last_update: 2025-07-27T08:15:21.895024
  

---