Thread: Script to 'relate products' by SKU instead of ProductID

Could anyone reading this contact me ASAP if you are interested in modifying my relatedproducts.xml.config to use SKUs instead of productids.

Currently products can be 'related' to each other by entering the ProductID's in a comma separated list.

I need to be able to do this using the SKU.

Has anyone implemented this before? (i have a spreadsheet with all related SKUs in comma separated list)....

The field in the Product table is a string field, so you should be able to just have a new XMLPackage created that can accomplish the split by SKU instead of ProductID.

I don't think we've done this, but it would be easy enough to build.

You'd need to create a modified version of aspdnsf_GetCustomersRelatedProducts at a minimum, and probably a good idea to create another XMLPackage along the lines of the stock standard relatedproducts.xml.config.

Could anyone reading this contact me ASAP if you are interested in modifying my relatedproducts.xml.config to use SKUs instead of productids.