If using Custom Dynamic SEO Links for X-Cart, this information will be useful to you in writing custom scripts, or useful to anyone you hire to write custom scripts for you.
The URL fields are held in the database in the xcart_products and xcart_categories tables, both with the field name "cdseo_url." The base folders in the URLs are stored in the config.php file located in /modules/cdseolinks/ and are available to both PHP and Smarty Templates as $cdseo_cat and $cdseo_prod.
If you want to link to a product inside a smarty template, you would using something similar to: Product Title where $yourvariable contains fields pulled from the xcart_products database table.
If you want to link to a category inside a smarty template, you would using something similar to: Category Name where $yourvariable contains fields pulled from the xcart_categories database table.