Delete Sample Data?

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
8 years ago
What about 3.70 script?   Is this the best way to start with an empty store?  When I used the installation and empty store, I was getting errors when trying to access the Administration.
8 years ago
Hi,

for learning or first try it's always the better way to start with sample data.

/w errors - could you please be more specific:

? Does this conversely means, that when you install with sample data instead, you have no problems to access the admin area?
? What errors do you get? Could you login successfully?

Common mistake: If your public shop is colorful and you could login in your admin area but it looks like a black and white mess (= CSS of the admin area not loaded), you haven't set enough permissions to the nopcommerce folder.
7 years ago
For v.3.8
DELETE FROM ShoppingCartItem
DELETE FROM ReturnRequest
DELETE FROM OrderNote
DELETE FROM GiftCard
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)
7 years ago
and 3.90 ??
5 years ago
Hi,

Does anyone have a delete script v4.0?

Many Thanks
5 years ago
Update..

I used the script posted by dandzomba for v3.8 and it has done the trick.

Cheers
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.