Jump to content

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

Removing old Files in Product Details TAB Rate Topic   - - - - -

 
  • chrisbti
  • Senior Member
  • Members
  • Join Date: 20-Oct 11
  • 263 posts

Posted 19 April 2013 - 03:07 AM #1

When editing a Product i need to remove old FILES list under the Files Tab, but I have over 1000 products. How do I do this efficiently? instead of one by one?

Regards, God Be With You! Jesus Christ our Lord & Savior.
BTI - Better Tools For Industry
Industrial Hand Tools Made in USA | www.BTI-Tool.com | v.4.11.1 SP1 | Apache


 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3809 posts

Posted 19 April 2013 - 07:28 AM #2

Hello chrisbti,

Thank you for your message.

If you want to delete files of all your products at once, you should clear the cscart_product_files and cscart_product_file_descriptions database tables. You can use the following SQL queries in order to implement it:

TRUNCATE TABLE cscart_product_files
TRUNCATE TABLE cscart_product_file_descriptions

After this you should clear the var/downloads directory of your CS-Cart installation.

I hope this information will help you.

Thank you.

---
Pavel Zyukin
CS-Cart Support team

Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation