Marti Orbak Software

Na het maken van een nieuwe webshop is het nodig om deze eerst leeg te maken voordat de eerste synchronisatie gedaan wordt, anders komt er elke keer een foutmelding.

Om een webshop leeg te maken kun je de onderstaande sql statement gebruiken in TablePlus:

Open in TablePlus de sql editor (CTRL+E of klikken op het vierkantje met sql erin)

Hier plak je onderstaande statement (inclusief BEGIN en END):

-- VERWIJDERD OOK ALLE ORDERS EN KLANTEN!

--Paar keer runnen om zeker te zijn dat echt alles weg is!

-- Ook als je een foutmelding krijgt, gewoon nog een keer uitvoeren.

BEGIN

DELETE FROM Media WHERE OrderItemProductAlterationId IS NOT NULL

DELETE FROM OrderItemProductAlterationBacker

DELETE FROM OrderItemProductAlteration

DELETE FROM OrderItemBacker

DELETE FROM OrderItem

DELETE FROM Payment

DELETE FROM [Order]

DELETE FROM OrderBacker

DELETE FROM StandardOrderItemBacker

DELETE FROM StandardOrderItem

DELETE FROM StandardOrderBacker

DELETE FROM StandardOrder

DELETE From RecipeBacker

DELETE FROM PriceGroupItemBacker

DELETE FROM PriceGroupItem

DELETE FROM PriceGroupBacker

DELETE FROM PriceGroup

DELETE FROM PriceGroupDiscountItemBacker

DELETE FROM PriceGroupDiscountItem

DELETE FROM PriceGroupDiscountBacker

DELETE FROM PriceGroupDiscount

DELETE FROM PriceGroupBacker

DELETE FROM PriceGroup

DELETE FROM LocationBacker

DELETE FROM Location

DELETE FROM DeliveryBacker

DELETE FROM Delivery

DELETE FROM AssortimentImage

DELETE FROM AssortimentItemBacker

DELETE FROM AssortimentItem

DELETE FROM AssortimentBacker

DELETE FROM AssortimentLanguage

DELETE FROM Assortiment

DELETE FROM AlterationItemBacker

DELETE FROM AlterationItem

DELETE FROM ProductAlterationBacker

DELETE FROM ProductAlteration

DELETE FROM AlterationOptionBacker

DELETE FROM AlterationOption

DELETE FROM AlterationBacker

DELETE FROM Alteration

DELETE FROM Media WHERE ProductId IS NOT NULL

DELETE FROM RelatedProductBacker

DELETE FROM RelatedProduct

DELETE FROM ProductSubcodeBacker

DELETE FROM ProductSubcode

DELETE FROM RecipeBacker

DELETE FROM DeliverycostVolumeDiscount

DELETE FROM DeliverycostBacker

DELETE FROM Deliverycost

DELETE FROM ProductBacker

DELETE FROM ProductLanguage

DELETE FROM ProductImage

DELETE FROM ProductCharacteristic

DELETE FROM Product

DELETE FROM SubcodeBacker

DELETE FROM SubcodeLanguage

DELETE FROM Subcode

DELETE FROM CustomerBacker

DELETE FROM Customer

DELETE FROM Contact

DELETE FROM ContactBacker

DELETE FROM DebtorBacker

DELETE FROM Debtor

DELETE FROM Coupon

DELETE FROM Gender

DELETE FROM GenderBacker

DELETE FROM Season

DELETE FROM SeasonBacker

END