Before doing anything make sure you have good backups and you continue at your own risk.
You will need to know the product references of your products - if you don't and have the product references set to auto then export the catalog first and filter by product and you will see them.
First make sure you have added quite few related products to your products and you will easily see the way it works.
Close Actinic.
In Access right click on the table RelatedProducts and select to export it to Excel.
Now open it in Excel.
The column headed nID must continue sequentially for all rows, so when you add rows make sure it is sequential.
The column eProductRef must contain the product reference that you want to add related products to. This may be duplicated if you want more than one related product per product.
The column sRelatedProductRef is just that - the related product's product reference.
The last column nOrder starts at zero for each product and is the order that the related products are shown.
Now add extra lines to the Excel sheet in the format above. When completed save the spreadsheet as the same name and go back to Access.
In Access right click in the white space in the table window and select to import - then select the Excel spreadsheet you just saved. Select to overwrite the existing table when prompted.
Close Access and open Actinic and you should now see the products populated with the related product information you entered in Excel.
You will need to know the product references of your products - if you don't and have the product references set to auto then export the catalog first and filter by product and you will see them.
First make sure you have added quite few related products to your products and you will easily see the way it works.
Close Actinic.
In Access right click on the table RelatedProducts and select to export it to Excel.
Now open it in Excel.
The column headed nID must continue sequentially for all rows, so when you add rows make sure it is sequential.
The column eProductRef must contain the product reference that you want to add related products to. This may be duplicated if you want more than one related product per product.
The column sRelatedProductRef is just that - the related product's product reference.
The last column nOrder starts at zero for each product and is the order that the related products are shown.
Now add extra lines to the Excel sheet in the format above. When completed save the spreadsheet as the same name and go back to Access.
In Access right click in the white space in the table window and select to import - then select the Excel spreadsheet you just saved. Select to overwrite the existing table when prompted.
Close Access and open Actinic and you should now see the products populated with the related product information you entered in Excel.
Comment