📸
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
TEST DATA
Hammer Online
Your AI Operations Assistant
Try: "What's my best seller this month?" or "Draft a social post about the Benelli shipment"
✉️ Recent Emails
Open Inbox →
Sports South Distribution
Shipment Confirmation — Order #SS-48291 (12x Benelli SBE3)
10:23 AM
RSR Group
Your Dealer Account — March Statement Available
Yesterday
FastBound Support
Re: API Access Request — Your key is ready
Yesterday
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 agoTotal 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%
Inventory
1,847 itemsTotal Items
1,847
Total Value (Retail)
$847,293
Low Stock Alerts
7
Incoming Shipments
3
| Item | Brand | Category | SKU | In Stock | Cost | Price | Margin | Status |
|---|---|---|---|---|---|---|---|---|
| Glock 19 Gen5 MOS 9mm | Glock | Handguns | GLK-G19G5MOS | 3 | $448 | $599 | 34% | 🟢 In Stock |
| Glock 43X 9mm | Glock | Handguns | GLK-G43X | 2 | $398 | $529 | 33% | 🟢 In Stock |
| Sig Sauer P365 X-Macro 9mm | Sig Sauer | Handguns | SIG-P365XM | 1 | $512 | $699 | 37% | 🟡 Low |
| S&W M&P15 Sport II 5.56 | Smith & Wesson | Rifles | SW-MP15S2 | 4 | $489 | $699 | 43% | 🟢 In Stock |
| Benelli SBE3 12ga | Benelli | Shotguns | BEN-SBE3 | 12 | $1,299 | $1,899 | 46% | 🟢 New Arrival |
| Franchi Affinity 3.5 12ga | Franchi | Shotguns | FRA-AFF35 | 0 | $899 | $1,249 | 39% | 📦 Incoming |
| Winchester 94 .30-30 (Used) | Winchester | Rifles | WIN-94-USED | 1 | $450 | $749 | 66% | 🟡 Consignment |
| Henry Big Boy .44 Mag | Henry | Rifles | HEN-BB44 | 2 | $679 | $949 | 40% | 🟢 In Stock |
| Ruger SR22 .22LR | Ruger | Handguns | RUG-SR22 | 5 | $329 | $449 | 36% | 🟢 In Stock |
| Remington 870 Express 12ga | Remington | Shotguns | REM-870EX | 3 | $299 | $449 | 50% | 🟢 In Stock |
| Migra 12ga #2 Steel Shot (box) | Migra | Ammunition | MIG-12-2SS | 3 | $18 | $27 | 50% | 🔴 Critical |
| Federal 9mm 115gr FMJ (box) | Federal | Ammunition | FED-9-115 | 8 | $12 | $19 | 58% | 🔴 Low |
| Hornady 6.5 Creedmoor 140gr (box) | Hornady | Ammunition | HRN-65CM | 22 | $28 | $42 | 50% | 🟢 In Stock |
| Magpul PMAG 30rd 5.56 | Magpul | Accessories | MAG-PMAG30 | 34 | $9 | $16 | 78% | 🟢 In Stock |
| Vortex Crossfire II 3-9x40 | Vortex | Optics | VTX-CF2-394 | 4 | $119 | $179 | 50% | 🟢 In Stock |
No archery items in inventory yet
Archery inventory will appear here once items are routed to Rock City Archery.
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
T
RCT Facebook @RockCityTactical
412 items · Tactical gear, ARs, optics, training
A
RCA Facebook @RockCityArchery
151 items · Bows, crossbows, archery gear
GunBroker — AI Listing Agent
Powered by GunsBot.ai — Photo → ID → Specs → Description → PublishActive 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
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
⚠️ 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
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)