Thread: Modifying "Related Products function"

Hi,

In the Related Products function, how do I show only products with the field "ShowBuyButton = 1"?

I'm currently using AspDotNetStorefront ML 8.0.1.2/8.0.1.2

Thanks.

You'd need to modify the aspdnsf_GetCustomersRelatedProducts sproc a bit and add the ShowBuyButton =1 in the whereclause condition.

Thanks alfred, please let me know how to modify the aspdnsf_GetCustomersRelatedProducts sproc? Which file do I look at?

Thanks.

That's no file. If you have access to your DB, open sql server management studio, select your DB -> programability -> stored procedure.

Excellent! I've located it.

MS SQL Server Management Studio -> DB -> programability -> stored procedures ->
aspdnsf_GetCustomersRelatedProducts


I've got 2 questions,

1) How do I back it up (in case I mess up during modifying it)
2) How do I modify and save the changes to aspdnsf_GetCustomersRelatedProducts?

Thanks!

Firstly, you ought to be running more than just your production server. At the very least you should have a development server as well as the production server. And if you were doing it properly you would have a development server, a user test server and then the production server. You would then change the sp on the development server, thoroughly test, move it to the user test server and have someone else test it and agree your results, and then move it to the production server. With this scenario you would have a backup on the user test and production server, so if it all went wrong you could get a copy from them.

Finally, if you wanted to do it without these extra servers, then in management studio you could right-click and choose "Modify" on the sp (aspdnsf_GetCustomersRelatedProducts), and choose right-click and "Modify" again so that you had 2 copies open at once. Make your changes in one and keep the other as a backup, or export the second to a text file, or copy and paste it to another text editor, or right-click and choose "Script stored procedure as...". So many ways!

Then once you're happy that it's working on your dev box, move it up to your user test, and once it's working there move it up to your production box.

#1 backup your db, renamed it, or just re-create the same stored proc using a different name. Right click "aspdnsf_GetCustomersRelatedProducts" -> Script Stored procedure as -> Create to -> New window, and rename it, then run. That should create another stored proc.

#2 after you made the change, run/execute it.