Delete Sample Data?

I'm using nopCommerce 2.8. I installed it with sample data so I could see how things are set up. Now I want to delete all the sample data to keep my database size as small as possible. In the product table I see where items are marked for delete, but I can't delete them yet because I don't know how many tables are affected. Can someone tell me which tables I need to look at to make sure all the data is removed?

Why don't you just delete your App_Data\Settings.txt file and relaunch the website? This is 5-minute operation, and it will get you a brand new database. If your hosting plan gives you only one database, delete the old one. If not, just make sure you specify a different database name during installation.

Besides, since you are still trying the product, why don't you use the latest version? nopCommerce 3.0 has been released a week ago.

I added a lot of information to the database in figuring out how everything worked. I was trying to avoid re entering everything again. I also noticed that it kept products in the table that I entered incorrectly, which is something I was also trying to delete.

I didn't know the new version was out. I will have a look.
Thanks

Jim

This worked for me - it is based off an older script I found from another user.  I too enjoy the ability to use the sample data during development, but I needed a way to remove all the products/orders/etc. prior to going live.  The problem with r_omar's solution is that recreating a new database means I lose all my settings, custom text/languages/etc. which I want to keep.  I just want to get rid of the products and orders.

Note: this does not remove existing customers, in-case you created them as part of your development cycle as we do.

Here is the script.It is compatible with nop v2.65 as that is the version we are currently running.  
We will be upgrading to 3.10 soon and I will post an updated script if I have the chance.

DELETE FROM ShoppingCartItem
DELETE FROM OrderNote
DELETE FROM OrderProductVariant
DELETE FROM RecurringPayment
DELETE FROM RewardPointsHistory
DELETE FROM [Order]
DELETE FROM ProductVariantAttributeCombination
DELETE FROM RelatedProduct
DELETE FROM ProductVariantAttributeValue
DELETE FROM ProductVariant_ProductAttribute_Mapping
DELETE FROM ProductAttribute
DELETE FROM ProductVariant
DELETE FROM Picture
DELETE FROM Product_Category_Mapping
DELETE FROM Product
DELETE FROM Category
DELETE FROM Picture

DBCC CHECKIDENT (ShoppingCartItem, RESEED, 0)
DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (OrderProductVariant, RESEED, 0)
DBCC CHECKIDENT (RecurringPayment, RESEED, 0)
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)
DBCC CHECKIDENT (ProductVariantAttributeCombination, RESEED, 0)
DBCC CHECKIDENT (RelatedProduct, RESEED, 0)
DBCC CHECKIDENT (ProductVariantAttributeValue, RESEED, 0)
DBCC CHECKIDENT (ProductVariant_ProductAttribute_Mapping, RESEED, 0)
DBCC CHECKIDENT (ProductAttribute, RESEED, 0)
DBCC CHECKIDENT (ProductVariant, RESEED, 0)
DBCC CHECKIDENT (Picture, RESEED, 0)
DBCC CHECKIDENT (Product_Category_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product, RESEED, 0)
DBCC CHECKIDENT (Category, RESEED, 0)
DBCC CHECKIDENT (Picture, RESEED, 0)

Does anyone have a delete script for 3.0? Any help will be much appreciated.

Does anyone have a delete script for 3.4 or 3.3?  Anyone from the nopCommerce dev team or any experts out there?  Thanks in advance.

th34261 wrote:

Modified Scott's script.  This worked for me

DELETE FROM ShoppingCartItem
DELETE FROM ReturnRequest
DELETE FROM OrderNote
DELETE FROM OrderItem
DELETE FROM RecurringPaymentHistory
DELETE FROM RewardPointsHistory
DELETE FROM [Order]
DELETE FROM RelatedProduct
DELETE FROM ProductVariantAttributeCombination
DELETE FROM ProductVariantAttributeValue
DELETE FROM Product_ProductAttribute_Mapping
DELETE FROM ProductAttribute
DELETE FROM ProductReviewHelpfulness
DELETE FROM ProductReview
DELETE FROM Product_Picture_Mapping
DELETE FROM Picture
DELETE FROM Product_ProductTag_Mapping
DELETE FROM ProductTag
DELETE FROM Product_Category_Mapping
DELETE FROM Product
DELETE FROM Category
DELETE FROM Manufacturer

DBCC CHECKIDENT (ShoppingCartItem, RESEED, 0)
DBCC CHECKIDENT (ReturnRequest, RESEED, 0)
DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (OrderItem, RESEED, 0)
DBCC CHECKIDENT (RecurringPaymentHistory, RESEED, 0)
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)
DBCC CHECKIDENT (RelatedProduct, RESEED, 0)
DBCC CHECKIDENT (ProductVariantAttributeCombination, 0)
DBCC CHECKIDENT (ProductVariantAttributeValue, RESEED, 0)
DBCC CHECKIDENT (ProductVariant_ProductAttribute_Mapping, RESEED, 0)
DBCC CHECKIDENT (ProductAttribute, RESEED, 0)
DBCC CHECKIDENT (ProductReviewHelpfulness, RESEED, 0)
DBCC CHECKIDENT (ProductReview, RESEED, 0)
DBCC CHECKIDENT (Product_Picture_Mapping, RESEED, 0)
DBCC CHECKIDENT (Picture, RESEED, 0)
DBCC CHECKIDENT (Product_ProductTag_Mapping, RESEED, 0)
DBCC CHECKIDENT (ProductTag, RESEED, 0)
DBCC CHECKIDENT (Product_Category_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product, RESEED, 0)
DBCC CHECKIDENT (Category, RESEED, 0)
DBCC CHECKIDENT (Manufacturer, RESEED, 0)

pbsdjames wrote:



thanks, it worked for me..i added delete from urlrecord..
and had some warning for dbcc command..but delete worked fine..thanks again

Is any One have Updated script to delete sample database for nop commerce version 3.60. like you have in above post.

Ran this against 3.60 and it works

DELETE FROM ShoppingCartItem
DELETE FROM ReturnRequest
DELETE FROM OrderNote
DELETE FROM OrderItem
DELETE FROM RecurringPaymentHistory
DELETE FROM RewardPointsHistory
DELETE FROM [Order]
DELETE FROM RelatedProduct
DELETE FROM ProductAttributeCombination
DELETE FROM ProductAttributeValue
DELETE FROM Product_ProductAttribute_Mapping
DELETE FROM ProductAttribute
DELETE FROM ProductReviewHelpfulness
DELETE FROM ProductReview
DELETE FROM Product_Picture_Mapping
DELETE FROM Picture
DELETE FROM Product_ProductTag_Mapping
DELETE FROM ProductTag
DELETE FROM Product_Category_Mapping
DELETE FROM Product
DELETE FROM Category
DELETE FROM Manufacturer

DBCC CHECKIDENT (ShoppingCartItem, RESEED, 0)
DBCC CHECKIDENT (ReturnRequest, RESEED, 0)
DBCC CHECKIDENT (OrderNote, RESEED, 0)
DBCC CHECKIDENT (OrderItem, RESEED, 0)
DBCC CHECKIDENT (RecurringPaymentHistory, RESEED, 0)
DBCC CHECKIDENT (RewardPointsHistory, RESEED, 0)
DBCC CHECKIDENT ([Order], RESEED, 0)
DBCC CHECKIDENT (RelatedProduct, RESEED, 0)
DBCC CHECKIDENT (ProductAttributeCombination, RESEED, 0)
DBCC CHECKIDENT (ProductAttributeValue, RESEED, 0)
DBCC CHECKIDENT (ProductAttribute, RESEED, 0)
DBCC CHECKIDENT (ProductReviewHelpfulness, RESEED, 0)
DBCC CHECKIDENT (ProductReview, RESEED, 0)
DBCC CHECKIDENT (Product_Picture_Mapping, RESEED, 0)
DBCC CHECKIDENT (Picture, RESEED, 0)
DBCC CHECKIDENT (ProductTag, RESEED, 0)
DBCC CHECKIDENT (Product_Category_Mapping, RESEED, 0)
DBCC CHECKIDENT (Product, RESEED, 0)
DBCC CHECKIDENT (Category, RESEED, 0)
DBCC CHECKIDENT (Manufacturer, RESEED, 0)