Borrar orden de prueba manualmente

[radge]

Buenas , tengo un par de pedidos de prueba que me gustaria borrar , hace tiempo con la versión 1.3 de magento usaba este script pero ahora no me funciona, a ver si sabeis como hacerlo

gracias , radge

/* SET '100000045 ' = '100000045 '; */



SET FOREIGN_KEY_CHECKS = 1;

SET @salesFlatQuoteId = (SELECT entity_id FROM sales_flat_quote WHERE reserved_order_id = '100000045 ');

SET @salesOrderId = (
    SELECT entity_id
      FROM sales_order
     WHERE increment_id = '100000045 '
);


/* temp table used as an array */
CREATE TEMPORARY TABLE del_sales(
    id      INT AUTO_INCREMENT PRIMARY KEY,
    salesId INT(10)
);

/* temp table used as an array */
CREATE TEMPORARY TABLE del_statusSales(
    id      INT AUTO_INCREMENT PRIMARY KEY,
    salesId INT(10)
);
     
INSERT INTO del_statusSales (salesId)
    SELECT entity_id
      FROM sales_order_entity_int
     WHERE value = @salesOrderId
       AND attribute_id = ANY (
        SELECT attribute_id
          FROM eav_attribute
         WHERE attribute_code = 'order_id'
    )
       AND entity_id = ANY (
        SELECT entity_id
          FROM sales_order_entity
         WHERE entity_type_id = ANY (
            SELECT entity_type_id
              FROM eav_entity_type
             WHERE entity_type_code = 'invoice'
                OR entity_type_code = 'shipment'
                OR entity_type_code = 'creditmemo'
        )
    );

INSERT INTO del_sales (salesId)
    SELECT entity_id
      FROM sales_order_entity
     WHERE parent_id = ANY (
        SELECT salesId
          FROM del_statusSales
    )
       AND entity_type_id = ANY (
        SELECT entity_type_id
          FROM eav_entity_type
          WHERE entity_type_code = 'invoice_item'
             OR entity_type_code = 'invoice_comment'
             OR entity_type_code = 'shipment_item'
             OR entity_type_code = 'shipment_comment'
             OR entity_type_code = 'shipment_track'
             OR entity_type_code = 'creditmemo_item'
             OR entity_type_code = 'creditmemo_comment'
    );

INSERT INTO del_sales (salesId)
    SELECT salesId
      FROM del_statusSales;

INSERT INTO del_sales (salesId)
    SELECT entity_id
      FROM sales_order_entity
     WHERE parent_id = @salesOrderId;

DELETE FROM sales_order_entity
      WHERE entity_id = ANY (
    SELECT salesId
      FROM del_sales
);

DELETE FROM sales_flat_quote
      WHERE reserved_order_id = '100000045 ';
      
DELETE FROM sales_flat_order_item
      WHERE quote_item_id = @salesFlatQuoteId;
      
DELETE FROM sales_order
      WHERE increment_id = '100000045 ';

/* drop temp tables */
DROP TEMPORARY TABLE del_sales;
DROP TEMPORARY TABLE del_statusSales; 

[OSdave]

http://www.magentocommerce.com/magen...em_deleteorder

[radge]

Buenas , ya tengo esa extensión pero no me borra estos pedidos ... los tengo como cancelados y al intentar hacer-lo me dice

The order(s) cannot be canceled

[radge]

Buenas , ya tengo esa extensión pero no me borra estos pedidos ... los tengo como cancelados y al intentar hacer-lo me dice

The order(s) cannot be canceled

[Xarlie]

Es de pago pero...
http://www.magentocommerce.com/magen...mspl_orderbook

[radge]

gracias , al final lo hize borrando los registros de la tabla sales_ordes_XXXX no recuerdo la coletilla... pero borrandolo de ahi ya no me aparece en pedidos.

gracias , radge