Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>What version of OpenCart are you working with? The latest?</p> <p>The standard MVC structure of OpenCart combined with native PHP coding makes it a tremendously flexible CMS solution.. (I actually use the core for numerous types of sites).</p> <p>OpenCart currently depends on the two files you mentioned combined with the SEO table in the database to handle rewrites. </p> <p>It does not really 'break' the breadcrumbs. Breadcrums are more a history/navigation aid. With SEO urls if you enter a specific product URL you are navigating immediatly navigating to a specific item. So in the heirarchy it would only be one level below the home page..<br> e.g. yoursite.com/seoproduct</p> <p>'home' -> 'seo product'</p> <p>If you use the navigation heirarchy it still renders correctly (without the mod you mentioned) 'home' -> 'category -> 'sub-category' -> 'seo product'</p> <p>That said, in theory it is easy to acomplish whatever you want with SEO urls. A simple modification to the two files is enough.</p> <hr> <p>In practice, it just depends on how you want to handle them... </p> <p>How are you going to handle specifying the SEO url for the product? Based on product name? Product model? Or are you going to use the native SEO field in the product info?</p> <p>If it is the latter, the cart will automatically handle the rewrite. Unfortunately, letting the cart handle it natively also carries the greatest risk of links breaking over time as changes are made. </p> <p>If it is one of the former options, you will need to make some modifications to how the SEO rewrite is handled. </p> <hr> <p>Once you determine how you are going to be handling the rewrite you can put it in action... </p> <p>The easiest modification would be to use the native SEO but then add in a redundant search fallback. If no results are found on the in the common/seo controller, have it search for results. If one is found display the product - if more than one is found display the results.. </p> <p>On the other hand, you could completly modify both files and go with a custom SEO handling. (again using a search to find the product)...</p> <p>I have done it both ways... The first tends to have a bit better performance as it does database/text search only if the direct query returns no results... </p>
    singulars
    1. This table or related slice is empty.
    1. POOpencart, remove category string from the canonical URL of a product
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USCarpeNoctumDC
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThanks for the complex answer! Yeah well at this stage I'm alternating between having bogus links for the categories or between working within those files. Probably I've managed to explain a bit better on this page: http://forum.opencart.com/viewtopic.php?f=19&t=6677&p=208233#p208233. I'm still confused and I don't know what approach to take for a long term opencart commitment.
      singulars
      1. PO
      1. USBogdan Ciocoiu
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload