RC
Rock City Guns
3
K
Kyle
TEST DATA
🔨
Hammer Online
Your AI Operations Assistant
🔨
Hammer
Morning Kyle 👋 Here's your daily loadout:

📊 Yesterday's revenue: $4,287 (↑12% vs Monday)
🔥 Hot seller: Glock 19 Gen5 — 4 sold this week
⚠️ Low stock: Migra 12ga #2 Steel Shot (3 left)
📦 Incoming: 12x Benelli SBE3 arriving today
📱 3 social posts ready for your approval
✉️ No flagged distributor emails

Looking like a good day. What do you need?
8:15 AM
Pull up the Migra reorder info
8:16 AM
🔨
Hammer
Migra 12ga #2 Steel Shot — current stock: 3 boxes

Last order: 2 cases (50 boxes) from RSR Group on Mar 15
Cost: $18/box | Your price: $27/box | Margin: 50%
Sell-through rate: 12 boxes/week (turkey season bump)

At current pace, you'll be out by Thursday. Want me to draft a PO to RSR for 3 cases?
8:16 AM
Yeah do it. Also what sold today so far?
8:17 AM
🔨
Hammer
✅ PO drafted — 3 cases (75 boxes) Migra 12ga #2 to RSR Group. Ready for your approval in the Inventory tab.

Today's sales so far:
1. Glock 19 Gen5 MOS — $599 — James Mitchell — 10:23 AM
2. Sig P365 X-Macro — $699 — Robert Chen — 11:47 AM

Total: $1,298 | 2 transactions | Avg: $649
Yesterday at this time you were at $1,105, so you're running ahead. 📈
8:17 AM
Try: "What's my best seller this month?" or "Draft a social post about the Benelli shipment"
Today's Numbers
Revenue
$1,298
Transactions
2
Avg Sale
$649
$1,298 / $4,287 yesterday
↑ 18% ahead of yesterday's pace
Alerts
Migra 12ga #2 — 3 left Critical
Federal 9mm 115gr — 8 boxes Low
Benelli SBE3 x12 — Arriving today Incoming
Glock 19 Gen5 — Fast mover (4/week) Trending
Social Media
Quick Actions

Bound Book

Last synced: 2 min ago
Total Firearms on Book
1,847
Acquisitions (This Month)
47
Dispositions (This Month)
31
Pending 4473s
2
Recent Bound Book Activity
Date Type Firearm Serial # Contact Status
Mar 31 Acquisition Benelli SBE3 12ga BN3892174 Sports South (Distributor) ✅ Committed
Mar 31 Acquisition Benelli SBE3 12ga BN3892175 Sports South (Distributor) ✅ Committed
Mar 31 Disposition Glock 19 Gen5 MOS 9mm BSRX482 James Mitchell (Individual) ✅ Committed
Mar 31 Disposition Sig P365 X-Macro 9mm 66B294871 Robert Chen (Individual) ✅ Committed
Mar 30 Acquisition Winchester 94 .30-30 (Used) W94-331087 Tommy Saunders (Consignment) ✅ Committed
Mar 30 Disposition S&W M&P15 Sport II 5.56 TKC8827 Michael Torres (Individual) ✅ Committed
Mar 29 Acquisition Franchi Affinity 3.5 12ga FA35-99201 RSR Group (Distributor) ⏳ Pending
Mar 28 4473 Remington 870 Express 12ga D827493M David Wheeler (Individual) ✅ Approved
Recent Form 4473s
  • James Mitchell Glock 19 Gen5 MOS
    ✅ Approved Mar 31
  • Robert Chen Sig P365 X-Macro
    ✅ Approved Mar 31
  • David Wheeler Remington 870
    ✅ Approved Mar 28
  • Sarah Banks Ruger SR22
    ⏳ Delayed Mar 27
  • Tommy Aldridge Henry Big Boy .44
    ✅ Approved Mar 26

ATF Compliance

✅ All serial numbers matched
✅ Bound book current
✅ Last ATF audit: Sep 2024 — No findings
📊 Accuracy rate: 100%

Armory Inventory

Loading shadow inventory...
Total Products
19,574
Active Item Rows
19,431
On-Hand Products / Items
-
Review Queue
5
Archived Scrap
235
Archive Candidates
0
Product List (Preview Slice)
Visible: 0
Product ID Title Brand Category / Type Condition Caliber Stock Price / Range Review
Shadow inventory only — no Lightspeed writes.
Review Queue (5)
Product Detail (Mapped Source Rows)
Select a product
Choose a row to inspect mapped source item rows.
shadowSKU sourceItemID Title Canonical Condition Category / Type Caliber On Hand Status
shadowSKU and sourceItemID are internal admin identifiers.
Suggested Fixes (v1.4 Enrichment Review)
Preview subset only
Auto Apply
0
Review
0
Needs AI/Search
0
No Change
0
Product Current Suggested Reason / Confidence
Suggested fixes are shadow recommendations only and have not been applied to Lightspeed.
🔎
No products match current filters
Try widening filters or clearing search terms. Shadow inventory only — no Lightspeed writes.

Inventory Routing

Route items to the right storefront automatically
Auto-Assign All New
Total Items Routed
1,847
Auto-Assigned
1,623 (88%)
Pending Review
12
Routing Rules
24
🔔 New Items — Needs Routing 5 pending
Item Brand RCG RCT RCA Confidence AI Reasoning Actions
Benelli SBE3 12ga Benelli 94% Hunting shotgun, also popular tactical
Franchi Affinity 3.5 12ga Franchi 97% Hunting/field shotgun
Magpul MOE Carbine Stock Magpul 99% Tactical AR accessory
TruGlo Brite-Site Fiber Optic TruGlo 72% ⚠️ Fits both firearms and crossbow sights — needs review
Hornady Superformance .308 Win Hornady 98% Hunting ammunition
📋 Category Routing Rules
Category Rock City Guns Rock City Tactical Rock City Archery FB Feed Auto-Publish
Handguns — Semi-Auto ✅ ✅ — RCG, RCT ✅
Handguns — Revolvers ✅ — — RCG ✅
Rifles — Bolt/Lever Action ✅ — — RCG ✅
Rifles — AR-15/MSR ✅ ✅ — RCT ✅
Shotguns — Hunting ✅ — — RCG ✅
Shotguns — Tactical ✅ ✅ — RCG, RCT ✅
Ammunition — All ✅ — — RCG ✅
Optics — Rifle Scopes ✅ ✅ — RCT ✅
Optics — Red Dots — ✅ — RCT ✅
Bows — Compound — — ✅ RCA ✅
Bows — Crossbow — — ✅ RCA ✅
Archery Accessories — — ✅ RCA ✅
Used / Consignment ✅ — — RCG ⏸️ Review
Tactical Gear — ✅ — RCT ✅
📊 Site Distribution
Rock City Guns 1,284 items (69%)
Rock City Tactical 412 items (22%)
Rock City Archery 151 items (8%)
* Some items appear on multiple sites — percentages may exceed 100%
📘 Facebook Feed Assignment
G
RCG Facebook @RockCityGuns
1,284 items · General firearms, hunting, ammunition
🟢 Active
T
RCT Facebook @RockCityTactical
412 items · Tactical gear, ARs, optics, training
🟡 Setup Pending
A
RCA Facebook @RockCityArchery
151 items · Bows, crossbows, archery gear
🟡 Setup Pending

GunBroker — AI Listing Agent

Powered by GunsBot.ai — Photo → ID → Specs → Description → Publish
Open Full App ↗
Active Listings
5
Sold This Month
3
GB Revenue (Month)
$2,197
Avg Sell Price
$732
Recent GunBroker Listings
Item Listed Status Bids Watchers Price Time Left
Sig Sauer P365 X-Macro 9mm Apr 12 Active 7 23 $649.00 2d 4h
Remington 870 Express 12ga Apr 10 Active 3 11 $389.00 4d 12h
S&W M&P15 Sport II 5.56 Apr 8 Sold ✅ 12 31 $649.00 —
Winchester 94 .30-30 (Used) Apr 5 Sold ✅ 8 18 $899.00 —
Ruger SR22 .22LR Apr 3 Active 1 6 $349.00 6d 8h
🤝 Consignment Queue Customer firearms waiting to be listed
Tommy Saunders — Winchester 94 .30-30
✅ ListedFee: 15% ($134.85)
Mike Aldridge — Browning A5 12ga
📸 Needs PhotosFee: 15% (TBD)
Sarah Banks — S&W 642 .38 Spl
⏳ Awaiting ApprovalFee: 15% (TBD)

Social Media

Posts This Week
5
Avg. Engagement
3.2%
Followers (FB)
847
Posts Pending Approval
3
Ready for Approval 📅 Tomorrow, 10:00 AM
📸
Range day essentials 🎯 The Sig P365 X-Macro continues to impress. Compact, reliable, and ready for anything. Stop by Rock City Guns and see why it's our most popular carry gun this month. #RockCityGuns #EDC #PersonCounty #RoxboroNC
FB IG ✅ Passed — No policy violations detected
Ready for Approval 📅 Tomorrow, 2:00 PM
📸
Fresh from Benelli 🦆 The Super Black Eagle III just landed at Rock City Guns. If you're serious about turkey season, this is the shotgun. Come check them out before they're gone. #Benelli #SBE3 #TurkeySeason #Roxboro #NCHunting
FB IG ✅ Passed — No policy violations detected
⚠️ Review Recommended 📅 Thursday, 11:00 AM
📸
New inventory alert! We just got a shipment of Glock 19 Gen5 pistols in stock. These won't last — come grab yours at Rock City Guns! Best prices in Person County. #Glock #G19 #InStock #GunShop
FB IG ⚠️ Review — phrases 'in stock', 'grab yours', and 'best prices' may trigger Meta policy flags. Consider rephrasing.
🏹
No archery content queued yet
Create your first post for Rock City Archery!

Content Calendar — This Week

Mon
Tue
Wed
Thu
Fri
Sat
Sun
31
Range Day
1
Benelli Arrival
2
3
Needs Review
4
5
Weekend Special
6

🤖 AI Suggestions

🤖 Hammer suggests: Turkey season opens April 12 — schedule a hunting shotgun feature this week
🤖 Trending: #2ACommunity has 2.1M posts this week — consider a community-focused post
🤖 Your best performing post type: Range day content (4.7% avg engagement)