Jump to content

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

Deleting All Products Rate Topic   - - - - -

 
  • AMB
  • Newbie
  • Members
  • Join Date: 07-May 18
  • 9 posts

Posted 10 May 2018 - 07:18 AM #1

I want to delete all products - is there a faster way than deleting "all" from the Products page?

 

Since page can only display 10, 25, 50, 100, 250 items per page, it takes a long time to delete all items when the products number is very large (12,000).

 

Also, deleting all when displaying 250 products per page does not work - it kicks you out to dashboard and results in error message "error access denied: possible CSRF attack".

 

Max deletion is using 100 products displayed per page.....

 

Thank you

 

Adrian



 
  • Alt-team
  • CS-Cart Developer
  • Authorized Reseller
  • Join Date: 18-Jan 11
  • 2549 posts

Posted 10 May 2018 - 07:56 AM #2

Delete categories!

After you erase all categories, all products that are assigned to them will be moved to trash category. 

Then, delete trash category.


ADD-ONS  |  Web development service  |  Web design  |  Page speed increasing  | Server Optimization

Buy MULTIVENDOR - USD 1250 (14% off)   Buy CS-CART LICENCE - USD 345 (13% off)

 Email - manager@alt-team.com | Skype - Altteam    


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 17267 posts

Posted 10 May 2018 - 12:48 PM #3

If you want to keep categories, use the following solution

 

https://forum.cs-car...es/#entry154649


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • AMB
  • Newbie
  • Members
  • Join Date: 07-May 18
  • 9 posts

Posted 10 May 2018 - 02:23 PM #4

Thank you very much.

 

Deleting categories will work, since the next importation will rebuild what is desired,

 

Thanks again,

 

Adrian

 

 



 
  • Jamalla
  • Advanced Member
  • Members
  • Join Date: 23-Sep 17
  • 117 posts

Posted 10 May 2018 - 03:29 PM #5

Hi,

 

How about the images related to the products/categories; are they going to be deleted from the storage when we delete products/categories?

 

Thanks



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

Posted 11 May 2018 - 03:49 AM #6

The image files will not be deleted.  However, the image references to them in the database will be.


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.


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 17267 posts

Posted 11 May 2018 - 05:57 AM #7

The image files will not be deleted.  However, the image references to them in the database will be.

 

You are not right, files will be also deleted. Please check the fn_delete_image function


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


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

Posted 11 May 2018 - 05:02 PM #8

Files created that are related to objects are deleted, but source files (I.e. var/.... or other server locations) are not.


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.


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 17267 posts

Posted 14 May 2018 - 06:28 AM #9

Files created that are related to objects are deleted, but source files (I.e. var/.... or other server locations) are not.

 

Looks like you mean import/ export feature? In this case yes, files will not be deleted


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.