thread Re: Retail Features Need More Development, Here is my attempt to bridge the gap for myself with AI in Feedback Discussions

Retail Features Need More Development, Here is my attempt to bridge the gap for myself with AI

JTPets — Thu, 13 Nov 2025 20:03:55 GMT

JTPets Inventory System - Complete Summary

What We Built

A production-ready inventory management system for JTPets pet supply business with Square POS integration. The system automates reorder suggestions, tracks sales velocity, manages purchase orders, and provides comprehensive business intelligence.

Core Features Implemented

1. Square Integration

Full catalog sync (items, variations, categories, images)
Multi-location inventory tracking
Vendor management
Sales velocity analysis (91/182/365-day periods)
Smart sync with configurable intervals (90% fewer API calls)
Soft-delete tracking with automatic inventory zeroing

2. Intelligent Reorder System

Priority-based suggestions (URGENT/HIGH/MEDIUM/LOW)
Multi-factor analysis:
- Days until stockout
- Square stock alert thresholds (location-specific)
- Sales velocity trends
- Lead times
Case pack and reorder multiple adjustments
Secondary vendor warnings
Handles items with no sales data

3. Purchase Order Management

Create POs from reorder suggestions
Edit quantities inline before submitting
Square CSV export (RFC 4180 compliant) for easy import
Track PO status (Draft/Submitted/Partial/Received)
Vendor and location filtering

4. Expiration Tracking

Set expiration dates per variation
"Never expires" flag
Filter by time ranges (30/60/90/120 days)
In-line editing with confirmation

Re: Retail Features Need More Development, Here is my attempt to bridge the gap for myself with AI

TCSlaguna — Thu, 13 Nov 2025 20:02:35 GMT

Wow @JTPets , I am blown away!

You have been working hard on this. Incredible.

Kudos to you!

Re: Retail Features Need More Development, Here is my attempt to bridge the gap for myself with AI

JTPets — Thu, 13 Nov 2025 20:12:20 GMT

Anyone from Square want to clone this for me into the actual dashboard? my code is open source 🙂

@alexschiff @isabelle @Summer2024 @GJ_Square @alexws @Divyac @brianstanish @issara_p @JessicaVersaw @Jink @KCfromProduct @mkochanowski @shireenb @victorial @MaddyV

Re: Retail Features Need More Development, Here is my attempt to bridge the gap for myself with AI

DinaLRosenberg — Sun, 16 Nov 2025 19:16:35 GMT

please... we need this! you're unreal!

Re: Retail Features Need More Development, Here is my attempt to bridge the gap for myself with AI

JTPets — Sun, 16 Nov 2025 19:29:58 GMT

Its on my github if you want to try and run it. Only the vendor functions won't work fully without some database tweaking due to api limitations at this time, the po exports are also a WIP

Re: Retail Features Need More Development, Here is my attempt to bridge the gap for myself with AI

JTPets — Mon, 17 Nov 2025 01:29:41 GMT

Believe it or not, $100 in claude clode tokens and about 8 hours of real focus

Re: Retail Features Need More Development, Here is my attempt to bridge the gap for myself with AI

JTPets — Tue, 18 Nov 2025 19:28:24 GMT

@dokidoki Here is a video of the current cycle count system I've implemented, for your count by category you could set the daily batch to 0 in the .env, export your catalog and copy upc/gtin into the box after filtering by category:

(view in My Videos)

Alternativly, use the source code as a project with claude code to pivot to something more suitable to you 🙂