|
Group: Forum Members
Last Active: Thu 13 Oct 2016
Posts: 27,
Visits: 143
|
I have around 30,000 products in my kartris site. I need to delete around 1000 of them that are outdated. It would take a long time to do manually on the admin screens. So I am looking for any tool or function available that will do a "clean" removal of a batch of products. If know there a lot of different related tables that must be removed as well.Thanks for your help.
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
Jeff,
I do not believe that there is a tool in the system to do this for you. I would do this from the SQL Server database.
Do you have criteria for which products need to be removed so that a query string can be built from this? I'm not suggesting that we write one here but I am curious if there is anything within your need that can be calculated from the backend.
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|
|
Group: Forum Members
Last Active: Thu 13 Oct 2016
Posts: 27,
Visits: 143
|
Actually, after further researh, I decided to use one of the SQL Server stored procedures: the one called "dbo._spKartrisProducts_Delete".
I wrote a little program which just reads a list of the items in question (product ID's) and for each one it executes the stored procedure.
After testing it appears that this does a clean delete i.e. removes the product from multiple tables needed.
Thanks
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
Thank you very much for sharing this. I was unaware that this procedure was in the DB.
I will be sure to use this in future too 
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
Thank you very much for sharing this. I was unaware that this procedure was in the DB.
I will be sure to use this in future too
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|