Skip to content

Umut ADALI

  • Anasayfa

Magento test ürünlerini silme

24 Ağustos 2014 by umut

Magento site kurulumu yaptığınızda test ürünleri, siparişleri ve müşterileri eklenir. Bunları silmek için phpmyadminden Truncate komutunu kullanmamız gerekiyor. Aşağıda yer alan SQL sorgularını bu kısımdan yaptığınızda işlemleriniz tamamlanacaktır. Hata alırsanız aşağıdaki komutlarda mage_ ile başlayan prefix olmayabilir. bunu silerek denerseniz işleminiz tamamlanacaktır.

Test Ürünlerini kaldırmak için;

TRUNCATE TABLE `mage_catalog_product_bundle_option`;
TRUNCATE TABLE `mage_catalog_product_bundle_option_value`;
TRUNCATE TABLE `mage_catalog_product_bundle_selection`;
TRUNCATE TABLE `mage_catalog_product_entity_datetime`;
TRUNCATE TABLE `mage_catalog_product_entity_decimal`;
TRUNCATE TABLE `mage_catalog_product_entity_gallery`;
TRUNCATE TABLE `mage_catalog_product_entity_int`;
TRUNCATE TABLE `mage_catalog_product_entity_media_gallery`;
TRUNCATE TABLE `mage_catalog_product_entity_media_gallery_value`;
TRUNCATE TABLE `mage_catalog_product_entity_text`;
TRUNCATE TABLE `mage_catalog_product_entity_tier_price`;
TRUNCATE TABLE `mage_catalog_product_entity_varchar`;
TRUNCATE TABLE `mage_catalog_product_link`;
TRUNCATE TABLE `mage_catalog_product_link_attribute`;
TRUNCATE TABLE `mage_catalog_product_link_attribute_decimal`;
TRUNCATE TABLE `mage_catalog_product_link_attribute_int`;
TRUNCATE TABLE `mage_catalog_product_link_attribute_varchar`;
TRUNCATE TABLE `mage_catalog_product_link_type`;
TRUNCATE TABLE `mage_catalog_product_option`;
TRUNCATE TABLE `mage_catalog_product_option_price`;
TRUNCATE TABLE `mage_catalog_product_option_title`;
TRUNCATE TABLE `mage_catalog_product_option_type_price`;
TRUNCATE TABLE `mage_catalog_product_option_type_title`;
TRUNCATE TABLE `mage_catalog_product_option_type_value`;
TRUNCATE TABLE `mage_catalog_product_super_attribute`;
TRUNCATE TABLE `mage_catalog_product_super_attribute_label`;
TRUNCATE TABLE `mage_catalog_product_super_attribute_pricing`;
TRUNCATE TABLE `mage_catalog_product_super_link`;
TRUNCATE TABLE `mage_catalog_product_enabled_index`;
TRUNCATE TABLE `mage_catalog_product_website`;
TRUNCATE TABLE `mage_catalog_product_entity`;
     
TRUNCATE TABLE `mage_cataloginventory_stock`;
TRUNCATE TABLE `mage_cataloginventory_stock_item`;
TRUNCATE TABLE `mage_cataloginventory_stock_status`;
     
INSERT  INTO `mage_catalog_product_link_type`(`link_type_id`,`code`) VALUES (1,'relation'),(2,'bundle'),(3,'super'),(4,'up_sell'),(5,'cross_sell');
INSERT  INTO `mage_catalog_product_link_attribute`(`product_link_attribute_id`,`link_type_id`,`product_link_attribute_code`,`data_type`) VALUES (1,2,'qty','decimal'),(2,1,'position','int'),(3,4,'position','int'),(4,5,'position','int'),(6,1,'qty','decimal'),(7,3,'position','int'),(8,3,'qty','decimal');
INSERT  INTO `mage_cataloginventory_stock`(`stock_id`,`stock_name`) VALUES (1,'Default');

Test kategorilerini kaldırmak için;

TRUNCATE TABLE `mage_catalog_category_entity`;
TRUNCATE TABLE `mage_catalog_category_entity_datetime`;
TRUNCATE TABLE `mage_catalog_category_entity_decimal`;
TRUNCATE TABLE `mage_catalog_category_entity_int`;
TRUNCATE TABLE `mage_catalog_category_entity_text`;
TRUNCATE TABLE `mage_catalog_category_entity_varchar`;
TRUNCATE TABLE `mage_catalog_category_product`;
TRUNCATE TABLE `mage_catalog_category_product_index`;
 
INSERT  INTO `mage_catalog_category_entity`(`entity_id`,`entity_type_id`,`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,`POSITION`,`level`,`children_count`) VALUES (1,3,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','1',1,0,1), (2,3,3,1,'0000-00-00 00:00:00','0000-00-00 00:00:00','1/2','1','1','0');
INSERT  INTO `mage_catalog_category_entity_int`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,32,0,2,1),(2,3,36,0,2,1),(3,3,61,0,2,1),(4,3,44,0,2,NULL),(5,3,45,0,2,1),(6,3,62,0,2,1),(7,3,63,0,2,1),(8,3,64,0,2,NULL);
INSERT  INTO `mage_catalog_category_entity_varchar`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,31,0,1,'Root Catalog'),(2,3,35,0,2,'Default Category'),(3,3,37,0,2,'default-category'),(4,3,40,0,2,NULL),(5,3,43,0,2,'PRODUCTS'),(6,3,52,0,2,NULL),(7,3,55,0,2,NULL);

Test kullanıcılarını kaldırmak için;

TRUNCATE TABLE `mage_customer_address_entity`;
TRUNCATE TABLE `mage_customer_address_entity_datetime`;
TRUNCATE TABLE `mage_customer_address_entity_decimal`;
TRUNCATE TABLE `mage_customer_address_entity_int`;
TRUNCATE TABLE `mage_customer_address_entity_text`;
TRUNCATE TABLE `mage_customer_address_entity_varchar`;
TRUNCATE TABLE `mage_customer_entity`;
TRUNCATE TABLE `mage_customer_entity_datetime`;
TRUNCATE TABLE `mage_customer_entity_decimal`;
TRUNCATE TABLE `mage_customer_entity_int`;
TRUNCATE TABLE `mage_customer_entity_text`;
TRUNCATE TABLE `mage_customer_entity_varchar`;

Test siparişlerini kaldırmak için

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE `mage_sales_flat_creditmemo`;
TRUNCATE `mage_sales_flat_creditmemo_comment`;
TRUNCATE `mage_sales_flat_creditmemo_grid`;
TRUNCATE `mage_sales_flat_creditmemo_item`;
TRUNCATE `mage_sales_flat_invoice`;
TRUNCATE `mage_sales_flat_invoice_comment`;
TRUNCATE `mage_sales_flat_invoice_grid`;
TRUNCATE `mage_sales_flat_invoice_item`;
TRUNCATE `mage_sales_flat_order`;
TRUNCATE `mage_sales_flat_order_address`;
TRUNCATE `mage_sales_flat_order_grid`;
TRUNCATE `mage_sales_flat_order_item`;
TRUNCATE `mage_sales_flat_order_payment`;
TRUNCATE `mage_sales_flat_order_status_history`;
TRUNCATE `mage_sales_flat_quote`;
TRUNCATE `mage_sales_flat_quote_address`;
TRUNCATE `mage_sales_flat_quote_address_item`;
TRUNCATE `mage_sales_flat_quote_item`;
TRUNCATE `mage_sales_flat_quote_item_option`;
TRUNCATE `mage_sales_flat_quote_payment`;
TRUNCATE `mage_sales_flat_quote_shipping_rate`;
TRUNCATE `mage_sales_flat_shipment`;
TRUNCATE `mage_sales_flat_shipment_comment`;
TRUNCATE `mage_sales_flat_shipment_grid`;
TRUNCATE `mage_sales_flat_shipment_item`;
TRUNCATE `mage_sales_flat_shipment_track`;
TRUNCATE `mage_sales_invoiced_aggregated`;
TRUNCATE `mage_sales_invoiced_aggregated_order`;
TRUNCATE `mage_log_quote`;
 
ALTER TABLE `mage_sales_flat_creditmemo_comment` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_creditmemo_grid` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_creditmemo_item` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_invoice` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_invoice_comment` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_invoice_grid` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_invoice_item` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_order` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_order_address` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_order_grid` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_order_item` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_order_payment` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_order_status_history` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_quote` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_quote_address` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_quote_address_item` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_quote_item` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_quote_item_option` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_quote_payment` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_shipment` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_shipment_comment` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_shipment_grid` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_shipment_item` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_flat_shipment_track` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_invoiced_aggregated` AUTO_INCREMENT=1;
ALTER TABLE `mage_sales_invoiced_aggregated_order` AUTO_INCREMENT=1;
ALTER TABLE `mage_log_quote` AUTO_INCREMENT=1;
 
TRUNCATE `mage_downloadable_link_purchased`;
TRUNCATE `mage_downloadable_link_purchased_item`;
 
ALTER TABLE `mage_downloadable_link_purchased` AUTO_INCREMENT=1;
ALTER TABLE `mage_downloadable_link_purchased_item` AUTO_INCREMENT=1;
 
TRUNCATE `mage_eav_entity_store`;
ALTER TABLE  `mage_eav_entity_store` AUTO_INCREMENT=1;

SET FOREIGN_KEY_CHECKS=1;

Eğer bunları nereye yazacam diyorsanız phpmyadminden veritabınınızı seçip sql sorgusu yapılan SQL yazan kısma girip grup grup ekleyip yapabilirsiniz.

Post navigation

Previous Post:

phpbb3 logo değiştirme&boyutları

Next Post:

Ücretsiz Hosting Satın Alma Rehberi

Bir cevap yazın Cevabı iptal et

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

M.Umut ADALI

...

Son Yazılar

  • Deezer vs Spotify: 1 numara kim?
  • Arkaplanda Servis Çalıştırma İşlemi – Nohup Kullanımı [Linux]
  • 2 Farklı Şekilde Dosya Kaydetme [Kotlin]
  • Android Studio 4.0’de neler yeni
  • 5 yazılım diliyle Merhaba dünya!

Kategoriler

  • Android
  • Başlangıç
  • Coroutines
  • CSS
  • Genel
  • İnceleme
  • Linux
  • Magento
  • Mysql
  • PHP
  • Phpbb
  • Ücretsiz Hosting

Son Yorumlar

    Arşivler

    • Eylül 2020
    • Haziran 2020
    • Mayıs 2020
    • Mart 2019
    • Nisan 2018
    • Mart 2018
    • Mart 2016
    • Şubat 2016
    • Kasım 2014
    • Ekim 2014
    • Eylül 2014
    • Ağustos 2014
    © 2021 Umut ADALI | Built using WordPress and SuperbThemes