-- Seed data: 18 SKUs from catalog U.pdf, plus default admin user placeholder. -- Idempotent: safe to re-run. -- Default admin: username 'admin', password 'admin123' (CHANGE IMMEDIATELY after first login) -- Generated by password_hash('admin123', PASSWORD_BCRYPT, ['cost'=>10]) INSERT INTO `admin_users` (`username`, `password_hash`, `name`, `role`) VALUES ('admin', '$2y$10$TYcohUDw80SjTX8tE6lT1.vTLqgS1mGgmyC8DjkBZMIQSGSbYIowm', 'Site Admin', 'admin') ON DUPLICATE KEY UPDATE `name` = VALUES(`name`); -- Products (18 SKUs) INSERT INTO `products` (`slug`,`name`,`series`,`type`,`summary`,`key_specs`,`full_specs`,`moq`,`lead_time`,`sample`,`color`,`image`,`badge`,`certifications`,`sort_order`,`status`) VALUES ('65w-gan-charger','65W GaN Smart Charger','GaN Series','charger', 'Compact 65W GaN wall charger with 2× USB-C + 1× USB-A, smart power distribution.', JSON_ARRAY('65W','2× USB-C + 1× USB-A','GaN III','PD 3.0 / QC 5'), JSON_OBJECT('Rated Power','65W max','Ports','2× USB-C, 1× USB-A','Protocols','PD 3.0 / QC 5.0 / PPS / AFC / Apple 2.4A','Plug','US / EU / UK foldable','Material','PC + ABS fireproof V0','Dimensions','58 × 58 × 30 mm','Weight','115 g','Input','AC 100–240V, 50/60Hz'), 1000,'15–25 days','Available (free, freight collect)','Black / White','gradient-1','Best Seller', JSON_ARRAY('FCC','CE','ROHS','ISO9001','CCC'),10,1), ('100w-smart-gan-charger','100W Smart GaN Charger','GaN Series','charger', '100W high-power GaN charger with AI display screen and 2C1A multi-port output.', JSON_ARRAY('100W','2× USB-C + 1× USB-A','Digital Display','GaN III'), JSON_OBJECT('Rated Power','100W max','Ports','2× USB-C, 1× USB-A','Display','1.4\" LED digital power readout','Protocols','PD 3.1 / QC 5.0 / PPS / SCP','Plug','US / EU / UK foldable','Material','PC + ABS V0','Dimensions','70 × 70 × 32 mm','Weight','185 g','Input','AC 100–240V, 50/60Hz'), 1000,'15–25 days','Available','Black / White','gradient-2','Hot', JSON_ARRAY('FCC','CE','ROHS'),20,1), ('140w-smart-gan-charger','140W Smart GaN Charger','GaN Series','charger', '140W flagship 4-port (3C+1A) charger with per-port smart display, ideal for laptops.', JSON_ARRAY('140W','3× USB-C + 1× USB-A','Smart Display','Laptop-grade'), JSON_OBJECT('Rated Power','140W max (single port PD 3.1 140W)','Ports','3× USB-C, 1× USB-A','Display','Per-port LED power indicators','Protocols','PD 3.1 EPR / QC 5.0 / PPS / SCP / FCP','Plug','US / EU / UK foldable','Material','PC + ABS V0','Dimensions','78 × 78 × 35 mm','Weight','245 g','Input','AC 100–240V, 50/60Hz'), 500,'20–30 days','Available','Black / White','gradient-3','Flagship', JSON_ARRAY('FCC','CE','ROHS','ISO9001','CCC'),30,1), ('70w-gan-smart-charger','70W GaN Smart Charger','GaN Series','charger', '70W 2C1A with built-in USB-C cable, smart TFT display, foldable plug.', JSON_ARRAY('70W','2C1A + Built-in Cable','TFT Display','Foldable'), JSON_OBJECT('Rated Power','70W max','Ports','2× USB-C, 1× USB-A, 1× built-in USB-C cable','Display','TFT color display','Protocols','PD 3.0 / QC 5.0 / PPS','Plug','Foldable US / EU / UK','Material','PC + ABS V0','Dimensions','62 × 62 × 32 mm','Weight','160 g','Input','AC 100–240V, 50/60Hz'), 1000,'15–25 days','Available','Black / White','gradient-4','New', JSON_ARRAY('FCC','CE','ROHS'),40,1), ('65w-3-port-fast-charger','65W 3-Port Fast Charger','Multi-Port Series','charger', 'Gradient-color 65W 2C1A fast charger, slim European design.', JSON_ARRAY('65W','2× USB-C + 1× USB-A','Gradient Color','Slim Body'), JSON_OBJECT('Rated Power','65W max','Ports','2× USB-C, 1× USB-A','Protocols','PD 3.0 / QC 5.0 / PPS / Apple 2.4A','Plug','EU foldable','Material','PC + ABS V0','Dimensions','55 × 48 × 28 mm','Weight','110 g','Input','AC 100–240V, 50/60Hz'), 1000,'15–25 days','Available','Purple gradient / White','gradient-5','', JSON_ARRAY('CE','ROHS'),50,1), ('45w-ice-clear-charger','45W Ice-Clear Fast Charger','Multi-Port Series','charger', '45W foldable fast charger with transparent ice-clear shell, USB-C + USB-A.', JSON_ARRAY('45W','USB-C + USB-A','Ice-Clear','Foldable'), JSON_OBJECT('Rated Power','45W max','Ports','1× USB-C, 1× USB-A','Protocols','PD 3.0 / QC 4+ / PPS','Plug','US / EU / UK foldable','Material','PC transparent + ABS','Dimensions','50 × 42 × 28 mm','Weight','75 g','Input','AC 100–240V, 50/60Hz'), 2000,'15–25 days','Available','Transparent / Frost','gradient-6','', JSON_ARRAY('FCC','CE','ROHS'),60,1), ('120w-4-port-fast-charger','120W 4-Port Fast Charger','Multi-Port Series','charger', '120W 2C2A desktop-class charger, charges 4 devices simultaneously.', JSON_ARRAY('120W','2× USB-C + 2× USB-A','4-Port','Desktop-grade'), JSON_OBJECT('Rated Power','120W max','Ports','2× USB-C, 2× USB-A','Protocols','PD 3.0 / QC 5.0 / PPS / SCP / FCP','Plug','US / EU / UK','Material','PC + ABS V0','Dimensions','85 × 75 × 32 mm','Weight','230 g','Input','AC 100–240V, 50/60Hz'), 500,'20–30 days','Available','Black / White','gradient-7','Hot', JSON_ARRAY('FCC','CE','ROHS'),70,1), ('240w-8-port-fast-charger','240W 8-Port Fast Charger','Multi-Port Series','charger', '240W 4C+4A 8-port desktop charger for office / hotel / retail scenarios.', JSON_ARRAY('240W','4× USB-C + 4× USB-A','8-Port','Office-ready'), JSON_OBJECT('Rated Power','240W max','Ports','4× USB-C, 4× USB-A','Protocols','PD 3.0 / QC 5.0 / PPS / SCP / FCP / AFC','Plug','US / EU / UK / AU','Material','PC + ABS V0','Dimensions','115 × 95 × 38 mm','Weight','510 g','Input','AC 100–240V, 50/60Hz'), 300,'25–40 days','Available','Black / White','gradient-8','', JSON_ARRAY('FCC','CE','ROHS','ISO9001','CCC'),80,1), ('45w-usb-c-fast-charger','45W USB-C Fast Charger','Classic Series','charger', 'Classic 45W single USB-C charger with LED indicator, multiple fast-charge protocols.', JSON_ARRAY('45W','1× USB-C','Classic','LED Indicator'), JSON_OBJECT('Rated Power','45W max','Ports','1× USB-C','Protocols','PD 3.0 / QC 4+ / PPS / Apple 2.4A','Plug','US / EU / UK / AU','Material','PC + ABS V0','Dimensions','48 × 45 × 28 mm','Weight','70 g','Input','AC 100–240V, 50/60Hz'), 2000,'12–20 days','Available','Black / White','gradient-1','', JSON_ARRAY('FCC','CE','ROHS','ISO9001','CCC'),90,1), ('35w-eu-plug-fast-charger','35W EU Plug Fast Charger','Classic Series','charger', '35W EU-plug USB-C charger compliant with European standards.', JSON_ARRAY('35W','1× USB-C','EU Plug','Compact'), JSON_OBJECT('Rated Power','35W max','Ports','1× USB-C','Protocols','PD 3.0 / QC 4+ / PPS / Apple 2.4A','Plug','EU fixed','Material','PC + ABS V0','Dimensions','42 × 42 × 26 mm','Weight','55 g','Input','AC 100–240V, 50/60Hz'), 3000,'10–18 days','Available','Black / White','gradient-2','', JSON_ARRAY('CE','ROHS'),100,1), ('80w-3-port-gan-charger','80W 3-Port GaN Charger','Retractable Series','charger', '80W 2C1A with built-in retractable USB-C cable, 3-device simultaneous fast charging.', JSON_ARRAY('80W','2C1A + Retractable Cable','GaN','3-Device'), JSON_OBJECT('Rated Power','80W max','Ports','2× USB-C, 1× USB-A, 1× built-in retractable USB-C','Retractable Length','≈ 75 cm','Protocols','PD 3.0 / QC 5.0 / PPS','Plug','US / EU / UK foldable','Material','PC + ABS V0','Dimensions','70 × 70 × 35 mm','Weight','210 g','Input','AC 100–240V, 50/60Hz'), 500,'20–30 days','Available','Black / White','gradient-3','', JSON_ARRAY('FCC','CE','ROHS'),110,1), ('120w-3-port-gan-charger','120W 3-Port GaN Charger','Retractable Series','charger', '120W with dual retractable cables (USB-C + Lightning) for multi-device travel.', JSON_ARRAY('120W','Dual-Retractable','USB-C + Lightning','Travel'), JSON_OBJECT('Rated Power','120W max','Ports','Built-in retractable USB-C + Lightning','Retractable Length','≈ 75 cm each','Protocols','PD 3.0 / QC 5.0 / PPS / Apple 2.4A','Plug','US / EU / UK foldable','Material','PC + ABS V0','Dimensions','80 × 80 × 40 mm','Weight','290 g','Input','AC 100–240V, 50/60Hz'), 500,'25–35 days','Available','Black / Orange / Green','gradient-4','', JSON_ARRAY('FCC','CE','ROHS'),120,1), ('4-in-1-data-cable','4-in-1 Universal Data Cable','4-in-1 Data Cable','cable', '100W universal 4-in-1 cable (USB-C ×2, Lightning, USB-A). Nylon braided.', JSON_ARRAY('100W PD','USB-C ×2 + Lightning + USB-A','Nylon Braided','0.25–2m'), JSON_OBJECT('Power','100W PD (20V/5A) max','Connectors','USB-C ×2, Lightning, USB-A','Lengths','0.25 / 0.5 / 1 / 1.5 / 2 m','Material','Nylon braided + aluminum shell','Data Rate','USB 2.0 (480 Mbps)','Color','Black / White / Custom'), 1000,'12–20 days','Available','Black / White / Custom','gradient-5','Best Seller', JSON_ARRAY('CE','ROHS','FCC'),210,1), ('magnetic-retractable-cable','Magnetic Retractable Data Cable','Magnetic Retractable','cable', 'Magnetic self-retracting cable, 100W PD, supports USB-C / Lightning.', JSON_ARRAY('100W','Magnetic','Self-Retracting','0.8m'), JSON_OBJECT('Power','100W PD max','Connectors','USB-C ↔ USB-C / Lightning','Length','≈ 0.8 m retractable','Material','Nylon braided + zinc alloy','Data Rate','USB 2.0 (480 Mbps)','Color','Black / White / Custom'), 1000,'15–25 days','Available','Black / White / Custom','gradient-6','', JSON_ARRAY('CE','ROHS','FCC'),220,1), ('braided-data-cable','Braided Fast-Charging Data Cable','Braided Cable','cable', 'Durable braided 6A data cable, 100W PD, aluminum housing.', JSON_ARRAY('100W','6A','Nylon Braided','Aluminum Shell'), JSON_OBJECT('Power','100W PD (20V/5A) max','Connectors','USB-C ↔ USB-C / Lightning','Lengths','1 / 1.5 / 2 m','Material','Nylon braided + aluminum alloy','Data Rate','USB 2.0 (480 Mbps)','Color','Black / White / Gray / Custom'), 2000,'10–18 days','Available','Black / White / Custom','gradient-7','', JSON_ARRAY('CE','ROHS','FCC'),230,1), ('digital-display-cable','Digital Display Fast-Charging Cable','Digital Display Cable','cable', 'Smart LED-screen cable displays real-time charging power. 100W PD.', JSON_ARRAY('100W','LED Display','Real-time Wattage','1m / 1.5m / 2m'), JSON_OBJECT('Power','100W PD max','Connectors','USB-C ↔ USB-C / Lightning','Lengths','1 / 1.5 / 2 m','Display','Built-in LED power readout','Material','Nylon braided + zinc alloy','Data Rate','USB 2.0 (480 Mbps)','Color','Black / White / Custom'), 1000,'15–25 days','Available','Black / White / Custom','gradient-8','New', JSON_ARRAY('CE','ROHS','FCC'),240,1), ('silicone-fast-cable','Liquid Silicone Data Cable','Silicone Cable','cable', 'Soft-touch liquid silicone cable, 60W, tangle-free, ideal for retail gift sets.', JSON_ARRAY('60W','Liquid Silicone','Soft Touch','1m / 1.5m'), JSON_OBJECT('Power','60W PD max','Connectors','USB-C ↔ USB-C / Lightning','Lengths','1 / 1.5 m','Material','Food-grade liquid silicone','Data Rate','USB 2.0 (480 Mbps)','Color','White / Pink / Blue / Black / Custom'), 2000,'12–20 days','Available','Multiple','gradient-1','', JSON_ARRAY('CE','ROHS','FCC'),250,1), ('tpe-classic-cable','TPE Classic Data Cable','Classic Cable','cable', 'Reliable 65W TPE cable, 3 length options, white box packaging.', JSON_ARRAY('65W','TPE','1m / 1.5m / 2m','White Box'), JSON_OBJECT('Power','65W PD max','Connectors','USB-C ↔ USB-C / Lightning / USB-A','Lengths','1 / 1.5 / 2 m','Material','TPE','Data Rate','USB 2.0 (480 Mbps)','Color','Black / White'), 3000,'10–15 days','Available','Black / White','gradient-2','', JSON_ARRAY('CE','ROHS','FCC'),260,1) ON DUPLICATE KEY UPDATE `name`=VALUES(`name`),`series`=VALUES(`series`),`type`=VALUES(`type`),`summary`=VALUES(`summary`), `key_specs`=VALUES(`key_specs`),`full_specs`=VALUES(`full_specs`), `moq`=VALUES(`moq`),`lead_time`=VALUES(`lead_time`),`sample`=VALUES(`sample`), `color`=VALUES(`color`),`image`=VALUES(`image`),`badge`=VALUES(`badge`), `certifications`=VALUES(`certifications`),`sort_order`=VALUES(`sort_order`),`status`=VALUES(`status`); -- Default content pages INSERT INTO `content_pages` (`slug`,`title`,`body`) VALUES ('about', 'About Luckus', 'Guangzhou Luckus Technology Co., Ltd. has been an OEM/ODM partner for charger and cable brands worldwide for 15+ years. 100+ employees, 10+ R&D engineers, 5+ designers, dedicated QC team. 600,000+ units monthly capacity. 50+ countries shipped.'), ('capabilities','Our Capabilities', 'FCC / CE / ROHS / ISO9001 / CCC certified. 100+ employees. 600,000+ units monthly capacity. 50,000+ units in stock. 20,000+ custom units per day.'), ('customization','Customization Services', 'From the first sketch to the last carton on the pallet — one supplier, one contract, one accountable team. Length / Mold / Color / Logo / Packaging all in-house.'), ('contact', 'Contact', 'Email: sales@luckustech.com · Working hours: Mon–Fri 09:00–18:00 (GMT+8). Guangzhou, China. Export to 50+ countries.') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`),`body`=VALUES(`body`); -- Default site settings. The admin "Website Setup" page can edit these -- without redeploying. Empty values fall back to config.php defaults. INSERT INTO `site_settings` (`key`, `value`) VALUES ('site.name', 'Luckus'), ('site.tagline', 'Trusted Charger & Cable Manufacturer'), ('site.logo', ''), ('site.favicon', ''), ('site.meta_desc', 'OEM/ODM manufacturer of GaN chargers, PD power supplies, and data cables. FCC/CE/ROHS certified. 600K+ units / month. 50+ countries.'), ('site.email', 'sales@luckustech.com'), ('site.whatsapp', '8613800000000'), ('site.phone', '+86 138 0000 0000'), ('site.address', 'Guangzhou, China'), ('site.hours', 'Mon–Fri 09:00–18:00 (GMT+8)'), ('site.footer_copy', '© '), ('site.hero_kicker', 'OEM / ODM Since 2008'), ('site.wa_message', 'Hi Luckus, I am interested in your products. Please send catalog, MOQ and lead time.'), ('inquiry.to_email', 'sales@luckustech.com'), ('inquiry.cc_email', '') ON DUPLICATE KEY UPDATE `value` = VALUES(`value`); -- Sample news / blog posts (English). Idempotent on slug. INSERT INTO `posts` (`slug`,`title`,`excerpt`,`body`,`cover_image`,`author`,`tags`,`status`,`published_at`) VALUES ('why-gan-iii-charger-technology-matters-in-2026', 'Why GaN III Charger Technology Matters in 2026', 'GaN III is now 30% smaller, 20% cooler, and 15% more efficient than GaN II. Here is what B2B buyers need to know before specifying a charger for 2026.', '

By 2026 most OEM/ODM programs have moved on from silicon and even GaN II. Gallium-nitride (GaN) III is now the default for any charger above 30 W — and almost universal above 65 W.

What changed in GaN III

GaN III halves the on-resistance per die and improves thermal conductivity by ~40%. The net result: a 65 W charger that was 70 × 45 × 28 mm in 2022 is now 58 × 30 × 28 mm, with cooler surface temps at full load.

What it means for your SKU

Procurement checklist

Ask your supplier for: 1) the actual GaN vendor (TI / Navitas / Innoscience / proprietary), 2) per-port protocol support table, 3) sustained-output thermal data at 25 °C ambient, and 4) FCC / CE / ROHS / ISO9001 / CCC cert scope. We share this matrix for every Luckus SKU on request.

', NULL, 'Luckus R&D', JSON_ARRAY('Industry','GaN','Chargers'), 'published', '2026-09-12 09:00:00'), ('fcc-vs-ce-vs-ukca-certification-cost-and-timeline', 'FCC vs CE vs UKCA: Cost and Timeline for B2B Brands', 'Comparing the three most-requested certifications for chargers and data cables: cost band, lead time, and which markets they actually unlock.', '

If you sell chargers or cables into the US, EU, or UK, you need at least one of FCC, CE, or UKCA. Many brands also need all three. Here is what to budget for and how long each takes.

FCC (USA)

FCC Part 15B for unintentional radiators and FCC Part 15C / 15E for intentional radiators (e.g. Qi wireless). Most chargers and cables fall under 15B. Cost: USD 1,500 – 4,500. Lead time: 4 – 8 weeks.

CE (EU)

CE is self-declared for most consumer electronics, with the EMC Directive 2014/30/EU and Low Voltage Directive 2014/35/EU as the main scopes. Cost: USD 2,000 – 6,000. Lead time: 6 – 10 weeks.

UKCA (UK)

UKCA is a UK-specific marking that has applied since January 2022. For most product categories it can be self-declared if the product is already CE compliant. Cost: USD 500 – 1,500. Lead time: 1 – 3 weeks.

Bundle pricing

Most labs give a 20 – 30% discount if you bundle FCC + CE + UKCA on the same SKU. Luckus can pre-test at our own lab and only send final samples for the third-party cert — a typical 4-week saving.

', NULL, 'Compliance Team', JSON_ARRAY('Certification','Compliance'), 'published', '2026-08-28 09:00:00'), ('plan-your-2026-charger-lineup', 'Plan Your 2026 Charger Lineup: A Workbook for Brand Owners', 'Three product tiers, six SKU slots, and one rule that keeps your catalog competitive. Use this framework to brief your OEM before sampling.', '

The charger market in 2026 rewards focused catalogs. A line of three tiers — every-day, premium, and pro — covers 90% of retail demand without the operational drag of a sprawling SKU list.

The three tiers

  1. Every-day (20 – 30 W): USB-C PD, single port, foldable plug, sub-USD 8 retail. The commodity SKU. Volume is high, margin is thin.
  2. Premium (65 – 100 W): 2C+1A, GaN III, multi-protocol (PD 3.1 / QC 5 / PPS). Margin is healthy. This is the workhorse tier for most D2C brands.
  3. Pro (140 W+): 3C+1A or 4C, smart display, designed for laptops. Higher entry cost but unlocks B2B and corporate-channel sales.

SKU math

For each tier, plan two colors and two plug variants (US foldable, EU fixed, UK optional). That is 3 tiers × 2 colors × 2 plugs = 12 SKUs at most. Anything more starts to cannibalize itself.

Pre-sample brief template

Send your OEM a 1-page brief covering: tier, color, plug variants, key specs, target retail price, target margin, MOQ, and packaging type. We have a free template you can adapt — request it via the inquiry form.

', NULL, 'Marketing', JSON_ARRAY('Strategy','OEM','Buyers Guide'), 'published', '2026-08-05 09:00:00'), ('data-cable-specs-most-brands-miss', 'Data Cable Specs That Most Brands Miss', 'Chargers get all the attention, but the cable is what determines whether users can actually use fast charging. Here are six spec details to specify before sampling.', '

A 240 W EPR-ready cable and a 60 W cable look almost identical on the shelf. The spec sheet is what separates them. Six details brands often miss:

1. E-Marker chip

Any cable above 60 W (5 A) must have an E-Marker to safely advertise current and protocol support. Look for USB-IF certified E-Markers from ST or VIA Labs.

2. Wire gauge

21 AWG is fine for 100 W cables up to 1 m. 1.5 m and 2 m cables should use 19 AWG to keep voltage drop under 150 mV at full load.

3. Connector plating

Gold flash is industry standard but wears off in 6 – 12 months. Nickel underplate + 3 µin gold overplate lasts 3+ years in daily use.

4. Jacket material

PVC is cheapest but cracks in cold weather and is being banned in some markets. TPE is the sweet spot for cost vs durability. Braided nylon is premium-only.

5. Bend rating

A consumer-grade cable should survive at least 10,000 90° bends. A 100,000-bend rating is what we ship in our premium OEM cables.

6. USB-IF certification

If your brand uses USB-IF logos, every cable SKU needs a TID (Test ID) number. Without it, you are not allowed to use the official logos.

', NULL, 'Engineering', JSON_ARRAY('Cables','OEM','Specs'), 'published', '2026-07-22 09:00:00') ON DUPLICATE KEY UPDATE `title`=VALUES(`title`), `excerpt`=VALUES(`excerpt`), `body`=VALUES(`body`), `tags`=VALUES(`tags`), `status`=VALUES(`status`), `published_at`=VALUES(`published_at`); -- Product categories. Top-level (parent_id NULL) is the type bucket, -- child rows (parent_id set) filter by product.series. -- Idempotent on slug. INSERT INTO `categories` (`parent_id`,`name`,`slug`,`type`,`match_field`,`match_value`,`description`,`icon`,`sort_order`,`status`) VALUES (NULL, 'Charger', 'charger', 'charger', 'type', NULL, 'GaN, PD and multi-port wall chargers', 'plug', 10, 1), (1, 'GaN Series', 'gan-series-chargers', 'charger', 'series', 'GaN Series', '65–140W GaN III wall chargers', 'bolt', 11, 1), (1, 'Multi-Port Series', 'multi-port-chargers', 'charger', 'series', 'Multi-Port Series', '2C+1A / 3C+1A / 4-port desktop units', 'grid', 12, 1), (1, 'Classic Series', 'classic-chargers', 'charger', 'series', 'Classic Series', 'Single- and dual-port PD adapters', 'zap', 13, 1), (1, 'Retractable Series', 'retractable-chargers', 'charger', 'series', 'Retractable Series', 'Travel chargers with retractable cable', 'plane', 14, 1), (NULL, 'Cable', 'cable', 'cable', 'type', NULL, 'USB-C, Lightning, and specialty cables', 'usb', 20, 1), (6, 'Braided Cables', 'braided-cables', 'cable', 'series', 'Braided Cable', 'Nylon-braided fast-charge cables', 'shield', 21, 1), (6, 'Magnetic Retractable','magnetic-retractable', 'cable', 'series', 'Magnetic Retractable','Magnetic charging + retractable', 'magnet', 22, 1), (6, '4-in-1 Data Cables', '4-in-1-cables', 'cable', 'series', '4-in-1 Data Cable', 'Multi-connector travel cables', 'cable', 23, 1), (6, 'Digital Display', 'digital-display-cables', 'cable', 'series', 'Digital Display Cable','Cables with on-cable wattage display', 'monitor', 24, 1), (6, 'Silicone Cables', 'silicone-cables', 'cable', 'series', 'Silicone Cable', 'Soft-touch silicone-jacket cables', 'heart', 25, 1), (6, 'Classic Cables', 'classic-cables', 'cable', 'series', 'Classic Cable', 'Standard PVC / TPE cables', 'circle', 26, 1), (NULL, 'Accessory', 'accessory', 'accessory', 'type', NULL, 'Hubs, adapters and travel accessories', 'package', 30, 1) ON DUPLICATE KEY UPDATE `name`=VALUES(`name`), `parent_id`=VALUES(`parent_id`), `type`=VALUES(`type`), `match_field`=VALUES(`match_field`), `match_value`=VALUES(`match_value`), `description`=VALUES(`description`), `icon`=VALUES(`icon`), `sort_order`=VALUES(`sort_order`), `status`=VALUES(`status`);