Announcement

Collapse
No announcement yet.

Single Product Page Converter

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    #61
    copy section data over to products

    These are the 2 querys we used to copy over the sections page names , Titles, meta data, sequence (on what order to display products on page) and if to include the product in sitemap.

    Please note you are useing these in your own risk !

    Please make sure you have a good working backup copy of your database before trying this !


    1st query to copy over data :

    UPDATE Product INNER JOIN [Catalog section] ON Product.nParentSectionID = [Catalog section].nSectionID SET Product.sSingleProductPageName = [Catalog section].[sPageName], Product.sSingleProductPageTitle = [Catalog section].[sPageTitle], Product.sSPPMetaDescription = [Catalog section].[sMetaDescription], Product.sSPPMetaKeyWords = [Catalog section].[sMetaKeywords], Product.[Product sequence] = [Catalog section].[Catalogue section sequence], Product.bSPPIncludeInSiteMap = [Catalog section].[bIncludeToSiteMap];



    2nd query to move the products out of sections and all the sections to 1 parent section so it would be easy to delete them - please note you need to create the section in actinic beforehand - make section DELETEx with Subsection DELETE and find the DELETE sections ID in the catalog section table - use that number to replace the XXX - marked in red:

    UPDATE Product INNER JOIN [Catalog section] ON Product.nParentSectionID = [Catalog section].nSectionID SET Product.nParentSectionID = [Catalog section].[nParentSectionID], [Catalog section].nParentSectionID = XXX;


    To use these queries open up actinic access database - create new query in SQL View paste in the code save 1st as copy-data-from-section-to-prodcut & 2nd as copy-products-locations-move-subsections or whatever suits you
    to run the query just double click.

    used in database with over 6000 products with success

    Cheers

    let me know if u think we missed something out

    Cheers
    Timo

    Comment

    Working...
    X