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
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