Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

Pages: 1

 

#1 11-24-2015 02:19:07

robash
Member
Registered: 02-10-2013
Posts: 344

Statement to delete all products

Hey

can I have the sql statement to delete all products please. MS Excel has fu*ked things up!  grrrrr.

I have a backup copy of products csv.

Thanks

EDIT:

I have a Test product that has a Remote Product Form in the Long Product Description and in one of the Tabs.

On export and import, its the Test product that appears to be causing the issues by adding a hundred or so columns with ID:

<input id=""app"" ty...

.

Google docs is doing the same as excel.

All other products data import/export correctly.

Last edited by robash (11-24-2015 03:06:11)

Rob

God Save The Queen

Offline

 

#2 11-24-2015 06:27:57

tguswell
Member
From: Plymouth, Devon
Registered: 07-31-2010
Posts: 128
Website

Re: Statement to delete all products

Rob

DELETE FROM ecom_prod should delete everything within the table ecom_prod ie all products.

Terry

Last edited by tguswell (11-24-2015 12:48:14)

Offline

 

#3 11-24-2015 11:05:02

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19951
Website

Re: Statement to delete all products

DELETE FROM ecom_prod

^^this

Nick Hendler

Offline

 

#4 11-25-2015 10:33:25

robash
Member
Registered: 02-10-2013
Posts: 344

Re: Statement to delete all products

Thanks smile

Rob

God Save The Queen

Offline

 

 

Pages: 1

Board footer