Advertisement
miriamdepaula

OpenCart - SEO URLs - SQL Queries

Sep 19th, 2011
389
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.16 KB | None | 0 0
  1. //Altere a keyword da forma que quiser, por exemplo: ('account/wishlist', 'lista-de-desejos') ... ou deixe em ingles.
  2.  
  3. INSERT INTO url_alias (query, keyword) VALUES ('common/home', '');
  4. INSERT INTO url_alias (query, keyword) VALUES ('account/wishlist', 'wishlist');
  5. INSERT INTO url_alias (query, keyword) VALUES ('account/account', 'my-account');
  6. INSERT INTO url_alias (query, keyword) VALUES ('account/edit', 'edit-account');
  7. INSERT INTO url_alias (query, keyword) VALUES ('account/password', 'change-password');
  8. INSERT INTO url_alias (query, keyword) VALUES ('account/address', 'address-book');
  9. INSERT INTO url_alias (query, keyword) VALUES ('account/reward', 'reward-points');
  10. INSERT INTO url_alias (query, keyword) VALUES ('account/login', 'login');
  11. INSERT INTO url_alias (query, keyword) VALUES ('account/logout', 'logout');
  12. INSERT INTO url_alias (query, keyword) VALUES ('account/order', 'order-history');
  13. INSERT INTO url_alias (query, keyword) VALUES ('account/newsletter', 'newsletter');
  14. INSERT INTO url_alias (query, keyword) VALUES ('account/forgotten', 'forgot-password');
  15. INSERT INTO url_alias (query, keyword) VALUES ('account/download', 'downloads');
  16. INSERT INTO url_alias (query, keyword) VALUES ('account/return', 'returns');
  17. INSERT INTO url_alias (query, keyword) VALUES ('account/transaction', 'transactions');
  18. INSERT INTO url_alias (query, keyword) VALUES ('account/register', 'create-account');
  19. INSERT INTO url_alias (query, keyword) VALUES ('account/return/insert', 'request-return');
  20. INSERT INTO url_alias (query, keyword) VALUES ('affiliate/account', 'affiliates');
  21. INSERT INTO url_alias (query, keyword) VALUES ('affiliate/edit', 'edit-affiliate-account');
  22. INSERT INTO url_alias (query, keyword) VALUES ('affiliate/password', 'change-affiliate-password');
  23. INSERT INTO url_alias (query, keyword) VALUES ('affiliate/payment', 'affiliate-payment-options');
  24. INSERT INTO url_alias (query, keyword) VALUES ('affiliate/tracking', 'affiliate-tracking-code');
  25. INSERT INTO url_alias (query, keyword) VALUES ('affiliate/transaction', 'affiliate-transactions');
  26. INSERT INTO url_alias (query, keyword) VALUES ('affiliate/logout', 'affiliate-logout');
  27. INSERT INTO url_alias (query, keyword) VALUES ('affiliate/forgotten', 'affiliate-forgot-password');
  28. INSERT INTO url_alias (query, keyword) VALUES ('affiliate/register', 'create-affiliate-account');
  29. INSERT INTO url_alias (query, keyword) VALUES ('affiliate/login', 'affiliate-login');
  30. INSERT INTO url_alias (query, keyword) VALUES ('checkout/cart', 'shopping-cart');
  31. INSERT INTO url_alias (query, keyword) VALUES ('checkout/checkout', 'checkout');
  32. INSERT INTO url_alias (query, keyword) VALUES ('checkout/voucher', 'gift-vouchers'); //vale presente
  33. INSERT INTO url_alias (query, keyword) VALUES ('information/contact', 'contact-us');
  34. INSERT INTO url_alias (query, keyword) VALUES ('information/sitemap', 'sitemap');
  35. INSERT INTO url_alias (query, keyword) VALUES ('product/special', 'specials');
  36. INSERT INTO url_alias (query, keyword) VALUES ('product/manufacturer', 'brands');
  37. INSERT INTO url_alias (query, keyword) VALUES ('product/compare', 'compare-products');
  38. INSERT INTO url_alias (query, keyword) VALUES ('product/search', 'search');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement