Jump to content

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

Moving Old Products To More Rate Topic   - - - - -

 
  • beta
  • Advanced Member
  • Trial users
  • Join Date: 18-Oct 11
  • 57 posts

Posted 08 November 2021 - 02:46 PM #1

Hi CS-Cart team,

 

I have a big problem. The server has slowed down due to the large number of products. On the other hand, this number of products have no special use and many of them are old. But our products are unique and we need their history and we can not delete them. Is it possible for you to specify an option in the product called Archive? To move the product there ?! In this way, the tables of the product and its accessories are lightened. And old products are removed from the main list of the site. On the other hand, whenever a user wants to access a particular product through a specific search or invoice, there is no problem. And it is possible that the Google index and Yandex will not be lost. And the product link is live.

 

Thanks your kind attention!



 
  • harmsmitsdev
  • Senior Member
  • Members
  • Join Date: 22-Feb 20
  • 240 posts

Posted 08 November 2021 - 04:20 PM #2

How many products do you have?


Best Brands Support - We empower your business!

info@bestbrands.eu


 

Posted 02 January 2022 - 03:56 PM #3

Hi CS-Cart team,

 

I have a big problem. The server has slowed down due to the large number of products. On the other hand, this number of products have no special use and many of them are old. But our products are unique and we need their history and we can not delete them. Is it possible for you to specify an option in the product called Archive? To move the product there ?! In this way, the tables of the product and its accessories are lightened. And old products are removed from the main list of the site. On the other hand, whenever a user wants to access a particular product through a specific search or invoice, there is no problem. And it is possible that the Google index and Yandex will not be lost. And the product link is live.

 

Thanks your kind attention!

try this: https://store.cart-p...d-products.html


John Carroll
My Webshop: Alpha Spas

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12156 posts

Posted 03 January 2022 - 10:52 PM #4

If you want those discontinued products to be visible in old orders/invoices and want a customer to be able to search them, then you will need to address your root-performance issue versus trying to move the data around and then enable access to it.

 

You might consider changing your product related tables to InnoDb versus MyIsam tables.  MyIsam will lock a table while it does an insert whereby InnoDb will lock the row.  However, there is more overhead to read an InnoDb table than a MyIsam.

 

As Harm asked, how many products does your Database have?  How many options and variations? Where are you seeing the slowness?


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.