=== WordPress HTML Snippet Migration Analysis ===
1. XYZ Plugin Table Structure Analysis:
Table: wput_xyz_ihs_short_code
Columns:
- id (int(11)) NO PRI
- title (varchar(1000)) NO
- content (longtext) NO
- short_code (varchar(2000)) NO
- status (int(11)) NO
- insertionMethod (int(11)) NO
- insertionLocation (int(11)) NO
- insertionLocationType (int(11)) NO
Total Records: 2
2. Existing XYZ Plugin Snippets:
ID: 1
Title: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Status: Active
Insertion Method: 2
Insertion Location: 0
Short Code: [xyz-ihs snippet="Recommended-Accessories-for-Blackstone-36-Cooking-Station"]
Content Length: 7641 chars
Content Preview:
Recommended Accessories for Blackstone 36" Cooking Station
Enhance your griddle experience ...
------------------------------------------------------------
ID: 2
Title: Recommended-Freezer-Storage-Tools
Status: Active
Insertion Method: 2
Insertion Location: 0
Short Code: [xyz-ihs snippet="Recommended-Freezer-Storage-Tools"]
Content Length: 9724 chars
Content Preview:
Recommended Freezer Storage Tools
These essential freezer storage tools will help maximize your m...
------------------------------------------------------------
3. MCP Plugin Table Structure Analysis:
Table: wput_html_snippets_mcp
Columns:
- id (int(11)) NO PRI
- name (varchar(255)) NO MUL
- content (longtext) NO
- position (varchar(50)) YES MUL
- is_active (tinyint(1)) YES MUL
- priority (int(11)) YES
- page_conditions (text) YES
- created_at (datetime) YES
- updated_at (datetime) YES
Total MCP Records: 45
4. Existing MCP Plugin Snippets:
ID: 1
Name: Google Analytics 4
Position: header
Active: Yes
Priority: 1
Content Length: 322 chars
Created: 2025-07-15 09:25:30
------------------------------------------------------------
ID: 2
Name: BBQ Schema Markup
Position: header
Active: Yes
Priority: 5
Content Length: 232 chars
Created: 2025-07-15 09:25:30
------------------------------------------------------------
ID: 3
Name: BBQ Recipe Card CSS
Position: header
Active: Yes
Priority: 10
Content Length: 369 chars
Created: 2025-07-15 09:25:30
------------------------------------------------------------
ID: 4
Name: Temperature Guide Widget
Position: shortcode
Active: Yes
Priority: 1
Content Length: 537 chars
Created: 2025-07-15 09:25:30
------------------------------------------------------------
ID: 6
Name: BBQ Sauce Rating Widget
Position: shortcode
Active: Yes
Priority: 5
Content Length: 871 chars
Created: 2025-07-15 10:48:01
------------------------------------------------------------
ID: 7
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-07-15 16:31:51
------------------------------------------------------------
ID: 8
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-07-15 16:31:51
------------------------------------------------------------
ID: 10
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-10-11 07:45:44
------------------------------------------------------------
ID: 11
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-10-11 07:45:44
------------------------------------------------------------
ID: 12
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-10-12 13:36:43
------------------------------------------------------------
ID: 13
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-10-12 13:36:43
------------------------------------------------------------
ID: 14
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-10-16 09:31:46
------------------------------------------------------------
ID: 15
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-10-16 09:31:46
------------------------------------------------------------
ID: 16
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-10-17 11:59:17
------------------------------------------------------------
ID: 17
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-10-17 11:59:17
------------------------------------------------------------
ID: 18
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-10-20 16:48:56
------------------------------------------------------------
ID: 19
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-10-20 16:48:56
------------------------------------------------------------
ID: 20
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-10-22 18:42:26
------------------------------------------------------------
ID: 21
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-10-22 18:42:26
------------------------------------------------------------
ID: 22
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-10-24 09:40:03
------------------------------------------------------------
ID: 23
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-10-24 09:40:03
------------------------------------------------------------
ID: 24
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-10-30 07:16:43
------------------------------------------------------------
ID: 25
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-10-30 07:16:43
------------------------------------------------------------
ID: 26
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-10-31 10:01:46
------------------------------------------------------------
ID: 27
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-10-31 10:01:46
------------------------------------------------------------
ID: 28
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-11-02 16:18:49
------------------------------------------------------------
ID: 29
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-11-02 16:18:49
------------------------------------------------------------
ID: 30
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-11-03 21:27:19
------------------------------------------------------------
ID: 31
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-11-03 21:27:19
------------------------------------------------------------
ID: 32
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-11-07 10:04:12
------------------------------------------------------------
ID: 33
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-11-07 10:04:12
------------------------------------------------------------
ID: 34
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-11-08 16:33:12
------------------------------------------------------------
ID: 35
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-11-08 16:33:12
------------------------------------------------------------
ID: 36
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-11-13 08:34:43
------------------------------------------------------------
ID: 37
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-11-13 08:34:43
------------------------------------------------------------
ID: 38
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-11-14 10:13:58
------------------------------------------------------------
ID: 39
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-11-14 10:13:58
------------------------------------------------------------
ID: 40
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-11-14 22:30:44
------------------------------------------------------------
ID: 41
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-11-14 22:30:44
------------------------------------------------------------
ID: 42
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-11-18 04:32:26
------------------------------------------------------------
ID: 43
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-11-18 04:32:26
------------------------------------------------------------
ID: 44
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-11-21 09:54:10
------------------------------------------------------------
ID: 45
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-11-21 09:54:10
------------------------------------------------------------
ID: 46
Name: Recommended-Accessories-for-Blackstone-36-Cooking-Station
Position: shortcode
Active: Yes
Priority: 10
Content Length: 7641 chars
Created: 2025-11-23 09:46:26
------------------------------------------------------------
ID: 47
Name: Recommended-Freezer-Storage-Tools
Position: shortcode
Active: Yes
Priority: 10
Content Length: 9724 chars
Created: 2025-11-23 09:46:26
------------------------------------------------------------
5. Migration Field Mapping:
XYZ Plugin -> MCP Plugin:
- title -> name (truncate if > 255 chars)
- content -> content (direct copy)
- status -> is_active (direct copy)
- insertionMethod -> position mapping:
* 1 (automatic) -> 'header' or 'footer'
* 2 (shortcode) -> 'shortcode'
- insertionLocation -> determine header/footer
- short_code -> skip (MCP auto-generates)
- priority -> default to 10
- timestamps -> set to current time
6. Migration Recommendations:
✅ SAFE TO MIGRATE: 2 snippet(s) found in XYZ plugin
📊 Current MCP snippets: 45
🔄 Migration process will:
1. Backup existing data
2. Transform XYZ snippets to MCP format
3. Insert into MCP table
4. Verify migration success
5. Provide rollback if needed
⚠️ POST-MIGRATION:
- Test all snippets functionality
- Deactivate XYZ plugin
- Keep XYZ table as backup