Спасибо, помогло)
Но запрос делал немного по другому
INSERT INTO oc_url_alias (query, keyword) VALUES
('common/home', ''),
('account/wishlist', 'wishlist'),
('account/account', 'my-account'),
('checkout/cart', 'shopping-cart'),
('checkout/checkout', 'checkout'),
('account/login', 'login'),
('account/logout', 'logout'),
('account/order', 'order-history'),
('account/newsletter', 'newsletter'),
('product/special', 'specials'),
('affiliate/account', 'affiliates'),
('checkout/voucher', 'gift-vouchers'),
('product/manufacturer', 'brands'),
('information/contact', 'contact-us'),
('account/return/insert', 'request-return'),
('information/sitemap', 'sitemap'),
('account/forgotten', 'forgot-password'),
('account/download', 'downloads'),
('account/return', 'returns'),
('account/transaction', 'transactions'),
('account/register', 'create-account'),
('product/compare', 'compare-products'),
('product/search', 'search'),
('account/edit', 'edit-account'),
('account/password', 'change-password'),
('account/address', 'address-book'),
('account/reward', 'reward-points'),
('affiliate/edit', 'edit-affiliate-account'),
('affiliate/password', 'change-affiliate-password'),
('affiliate/payment', 'affiliate-payment-options'),
('affiliate/tracking', 'affiliate-tracking-code'),
('affiliate/transaction', 'affiliate-transactions'),
('affiliate/logout', 'affiliate-logout'),
('affiliate/forgotten', 'affiliate-forgot-password'),
('affiliate/register', 'create-affiliate-account'),
('affiliate/login', 'affiliate-login');