Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Shall We Delete Old Products For Cleaning Database ? Rate Topic   - - - - -

 
  • Pascal
  • Senior Member
  • Members
  • Join Date: 13-Jun 12
  • 190 posts

Posted 20 February 2019 - 12:22 PM #1

Does the old disabled products in database slow down the cs-cart webshop ?

 

Is it a good idea to delete these products or the impact by let them in database as inactive is minor ?



 
  • soft-solid
  • Junior Member
  • Members
  • Join Date: 19-Apr 10
  • 727 posts

Posted 20 February 2019 - 12:24 PM #2

Hello Pascal

 

How many products do you have in the database? How many disabled products are there?

 

Best regards

Robert.


Team of SoftSolid
cs-cart.pl

 
  • Pascal
  • Senior Member
  • Members
  • Join Date: 13-Jun 12
  • 190 posts

Posted 20 February 2019 - 12:53 PM #3

Our DB includes about 100'000 products with 56'000 active references.

 

So we have approx 40'000 inactive products.



 
  • soft-solid
  • Junior Member
  • Members
  • Join Date: 19-Apr 10
  • 727 posts

Posted 20 February 2019 - 12:58 PM #4

Hello Pascal

 

You can remove these products - it's almost half. It's best to write a simple script that will use the "fn_delete_product" function to clear all data related to the product.

 

Best regards

Robert.


Team of SoftSolid
cs-cart.pl

 
  • Pascal
  • Senior Member
  • Members
  • Join Date: 13-Jun 12
  • 190 posts

Posted 20 February 2019 - 01:14 PM #5

Thanks for your answer Robert. But i'm asking myself if I will get some benefice doing it ?



 
  • imago
  • Senior Member
  • Members
  • Join Date: 18-Oct 18
  • 461 posts

Posted 20 February 2019 - 01:19 PM #6

You better think how to redirect the attention of the half-disappointed user to another similar product. 



 
  • soft-solid
  • Junior Member
  • Members
  • Join Date: 19-Apr 10
  • 727 posts

Posted 20 February 2019 - 01:21 PM #7

Hello Pascal

 

Do not expect spectacular improvement, but I think so. You can always make a copy of the store, delete the products there and compare with production store.

 

Best regards

Robert.


Team of SoftSolid
cs-cart.pl

 
  • Pascal
  • Senior Member
  • Members
  • Join Date: 13-Jun 12
  • 190 posts

Posted 20 February 2019 - 01:33 PM #8

You better think how to redirect the attention of the half-disappointed user to another similar product. 

 

It's done :)
we always propose new products to replace old ones to our customer.

Thanks for the tip !



 
  • imago
  • Senior Member
  • Members
  • Join Date: 18-Oct 18
  • 461 posts

Posted 20 February 2019 - 01:50 PM #9

That's good. Because their eagerness to buy the product increases by 23%. :-)