Total Categories

142

12% from last month

Active Products

2,847

8% from last month

New Structure Coverage

78%

42 categories migrated

System Health

Healthy

All systems operational

Product Distribution by Category

Price Range Analysis

Recent Deployments

View All

Category Restructure v2.0

Deployed to Production

Completed

2 hours ago

Database Migration

Schema Update v4.1

In Progress

Started 15 min ago

New Structure Migration

Phase 3: Bags & Folders

Completed

1 day ago

System Status

Database

Connected

API Server

Running

Cache System

85% Used

Backup System

Ready

SDLC Pipeline

Active

Storage Usage

65% used 1.2TB of 2TB

Recent Audit Activity

View All Logs

Action	Entity	Admin	Time
CREATE	Product: "Stainless Steel Water Bottle"	admin@bordales-forge.com	10 minutes ago
UPDATE	Category: "Bottles"	system@bordales-forge.com	1 hour ago
PUBLISH	Deployment: "Category Restructure v2.0"	admin@bordales-forge.com	2 hours ago
MIGRATE	Category Structure	system@bordales-forge.com	5 hours ago
BACKUP	Database: Full Backup	admin@bordales-forge.com	1 day ago

Category Management

Organize and manage product categories, hierarchy, and structure

All Categories

ID	Name	Slug	Parent	Products	Status	New Structure
1242	Drinkware Collection Main collection for all drinkware	drinkware	-	420	Active	Yes
90036	Bottles Water bottles, sports bottles, etc.	bottles	Drinkware Collection	310	Active	Yes
434	Bags and Folders All bags, cases, and folders	bags-and-folders	-	380	Active	Yes
90050	All Bags Collection of all bag types	all-bags	Bags and Folders	280	Active	Yes
1250	Mugs & Cups Coffee mugs, tea cups, etc.	mugs-cups	Drinkware Collection	195	Active	Pending
1260	Wine & Barware Glasses, bar accessories	wine-barware	Drinkware Collection	145	Active	Yes
1270	Tumblers Insulated tumblers and cups	tumblers	Drinkware Collection	120	Active	Pending
1280	Travel Mugs Insulated travel mugs	travel-mugs	Drinkware Collection	95	Active	Yes

Showing 1 to 8 of 142 categories

Category Hierarchy

Drinkware Collection

ID: 1242 | Products: 420 | New Structure: Yes

Bottles

ID: 90036 | Products: 310 | New Structure: Yes

Water Bottles

ID: 90037 | Products: 150

Sports Bottles

ID: 90038 | Products: 85

Glass Bottles

ID: 90039 | Products: 75

Mugs & Cups

ID: 1250 | Products: 195 | New Structure: Pending

Wine & Barware

ID: 1260 | Products: 145 | New Structure: Yes

Bags and Folders

ID: 434 | Products: 380 | New Structure: Yes

All Bags

ID: 90050 | Products: 280 | New Structure: Yes

Apparel

ID: 550 | Products: 210 | New Structure: No

Promotional Items

ID: 620 | Products: 185 | New Structure: No

New Structure Overview

New Structure Status

Migration Progress

Active

Overall Progress 78%

Drinkware Collection 85%

Bags and Folders 92%

Legacy Categories 65%

Key Statistics

42

Categories Organized

1,240

Products Migrated

8

City Categories Removed

6

Duplicates Consolidated

Migration Recommendations

City Categories Found

8 city-specific categories detected (Johannesburg, Cape Town, etc.). These should be deactivated as they violate the new structure policy.

Duplicate Categories

6 duplicate categories found (e.g., "Travel Mugs" appears twice). Recommend merging duplicates and deactivating redundant entries.

Legacy Categories to Migrate

24 legacy categories with active products can be migrated to the new structure. This will improve navigation and product discovery.

Orphaned Categories

12 categories have no products and no children. Consider archiving these to clean up the category tree.

Product Management

Manage products, inventory, pricing, and attributes

All Products

2,847 products

View:

SKU	Product	Category	Stock	Price	Status
BT-001	Stainless Steel Water Bottle 750ml, Double-walled insulation	Bottles	125	R 249.99	Active
BG-045	Leather Laptop Bag 15-inch, Water-resistant	All Bags	12	R 899.99	Active
MC-112	Ceramic Coffee Mug 350ml, Custom logo printing	Mugs & Cups	3	R 89.99	Low Stock
TM-023	Insulated Travel Tumbler 500ml, Leak-proof lid	Tumblers	200	R 199.99	Active
WB-008	Wine Glass Set Set of 6, Lead-free crystal	Wine & Barware	90	R 349.99	Active
PR-156	Executive Pen Set Ballpoint, Gift box included	Promotional Items	380	R 129.99	Active
TS-089	Polo Shirt Cotton, Multiple colors	Apparel	0	R 179.99	Out of Stock
DP-042	Product Sample Kit Assorted promotional items	Promotional Items	150	R 499.99	Active

Showing 1 to 8 of 2,847 products

Attribute Management

Define and manage product attributes, specifications, and filters

Attribute Definitions

Code	Name	Data Type	Products
brand	Brand Product manufacturer or brand	String	2,540
color	Color Product color variations	String	1,850
material	Material Construction material	String	1,920
capacity_ml	Capacity (ml) Volume capacity in milliliters	Integer	650
size	Size Product dimensions or size	String	1,420
lead_time	Lead Time Estimated delivery time	Integer	2,540

Showing 1 to 6 of 42 attributes

Pricing Management

Manage product pricing, discounts, and price rules

Active Price Rules

Rule Name	Type	Products	Discount	Valid From	Valid To	Status	Actions
Summer Sale 2024	Percentage	42	15%	2024-12-01	2024-12-31	Active
Bulk Order Discount	Fixed	All	R 50.00	2024-01-01	2024-12-31	Active

Bulk Pricing Editor

Bulk Pricing Instructions

Select categories or products and apply price adjustments in bulk. Changes will be applied immediately.

Adjustment Type

Adjustment Value

Apply To

New Structure Management

Manage and monitor the new category structure migration

78%

Overall Progress

42

Categories Organized

of 142 total categories

1,240

Products Migrated

of 2,847 total products

Migration Status by Category

Drinkware Collection 85%

1242 products migrated

Bags and Folders 92%

434 products migrated

Legacy Categories 65%

Cleanup in progress

City Categories 100%

8 categories removed

Migration Actions

Database Management

Manage database schema, backups, and maintenance

Database Statistics

Total Tables 48

Total Rows 124,582

Database Size 1.2 GB

Index Size 350 MB

Last Backup 2 hours ago

Quick Actions

Migrations Management

Manage database migrations and schema changes

Recent Migrations

Migration ID	Type	Status	Started	Duration	Changes	Actions
MIG-001242	Category Restructure	Completed	2 hours ago	15 min	42 categories migrated
MIG-001241	Schema Update	Completed	1 day ago	8 min	Index optimization

Bordales Forge

System Administrator

142