Thread: Clear inventory and categories to test imports?

We are testing ML V9 XML import processing. Does anyone know if there a method / stored procedure to clear all inventory, categories and entities to test an import process? That is without loosing all store settings by dropping the database and starting all over?

There's no sproc to do that, but a few quick SQL queries will do it:

This will clear ALL product data:

Code:

DELETE FROM Product
DELETE FROM ProductAffiliate
DELETE FROM ProductCategory
DELETE FROM ProductCustomerLevel
DELETE FROM ProductDistributor
DELETE FROM ProductGenre
DELETE FROM ProductLocaleSetting
DELETE FROM ProductManufacturer
DELETE FROM ProductSection
DELETE FROM ProductVariant
DELETE FROM ProductVector
DELETE FROM ShippingByProduct

This will clear ALL entities:

Code:

DELETE FROM Category
DELETE FROM Distributor
DELETE FROM Genre
DELETE FROM Manufacturer
DELETE FROM Section
DELETE FROM Vector
DELETE FROM Library

Make sure you have a backup first just in case.