Magento:订购可配置产品后，由于缺货而取消了该产品 [英] Magento: After ordering configurable product, its canceled because its out of stock

问题描述

我的问题是: 我有一个带有简单产品的产品. (也许是T恤，尺寸为S-XL和一些颜色) 现在，如果我订购其中之一，则订单确认电子邮件将其取消.

my problem is: i have a product with simple products as childs. (maybe tshirts whith size S-XL and some colors) Now if i order one of this, it is canceled with the order-confirmation email.

我认为这是股票的问题，但我不知道. 每种产品都有99件库存，并且所有库存都已激活并可以交付.

I think its a problem with the stock but i dont know. There are 99 items in stock of every kind and all are activated and ready to deliver.

有人遇到过同样的问题吗?

Anybody who has had the same problem?

推荐答案

解决方法:

问题在于在订单表中交叉编号，因此magento混淆了所有商品.

The problem was crossing ids in the order tables so magento mixed up all items.

通过截断所有订单表来解决此问题:

Solved this with truncating all order tables:

截断sales_order; TRUNCATE sales_order_datetime; TRUNCATE sales_order_decimal; TRUNCATE sales_order_entity; TRUNCATE sales_order_entity_datetime; TRUNCATE sales_order_entity_decimal; TRUNCATE sales_order_entity_int; TRUNCATE sales_order_entity_text; 截断sales_order_entity_varchar; 截断sales_order_int; 截断sales_order_text; 截断sales_order_tax; TRUNCATE sales_order_varchar; 截断sendfriend_log; 截断tag; 截断tag_relation; 截断tag_summary; 截断wishlist; 截断log_quote; 截断report_event;

TRUNCATE sales_order; TRUNCATE sales_order_datetime; TRUNCATE sales_order_decimal; TRUNCATE sales_order_entity; TRUNCATE sales_order_entity_datetime; TRUNCATE sales_order_entity_decimal; TRUNCATE sales_order_entity_int; TRUNCATE sales_order_entity_text; TRUNCATE sales_order_entity_varchar; TRUNCATE sales_order_int; TRUNCATE sales_order_text; TRUNCATE sales_order_tax; TRUNCATE sales_order_varchar; TRUNCATE sendfriend_log; TRUNCATE tag; TRUNCATE tag_relation; TRUNCATE tag_summary; TRUNCATE wishlist; TRUNCATE log_quote; TRUNCATE report_event;

截断sales_flat_quote; 截断sales_flat_quote_address; 截断sales_flat_quote_address_item; 截断sales_flat_quote_item; 截断sales_flat_quote_item_option; 截断sales_flat_quote_payment; 截断sales_flat_quote_shipping_rate; 截断sales_flat_order_item;

TRUNCATE sales_flat_quote; TRUNCATE sales_flat_quote_address; TRUNCATE sales_flat_quote_address_item; TRUNCATE sales_flat_quote_item; TRUNCATE sales_flat_quote_item_option; TRUNCATE sales_flat_quote_payment; TRUNCATE sales_flat_quote_shipping_rate; TRUNCATE sales_flat_order_item;

ALTER TABLE sales_order AUTO_INCREMENT = 1; ALTER TABLE sales_order_datetime AUTO_INCREMENT = 1; ALTER TABLE sales_order_decimal AUTO_INCREMENT = 1; ALTER TABLE sales_order_entity AUTO_INCREMENT = 1; ALTER TABLE sales_order_entity_datetime AUTO_INCREMENT = 1; ALTER TABLE sales_order_entity_decimal AUTO_INCREMENT = 1; ALTER TABLE sales_order_entity_int AUTO_INCREMENT = 1; ALTER TABLE sales_order_entity_text AUTO_INCREMENT = 1; ALTER TABLE sales_order_entity_varchar AUTO_INCREMENT = 1; ALTER TABLE sales_order_int AUTO_INCREMENT = 1; ALTER TABLE sales_order_text AUTO_INCREMENT = 1; ALTER TABLE sales_order_tax AUTO_INCREMENT = 1; ALTER TABLE sales_order_varchar AUTO_INCREMENT = 1; ALTER TABLE sendfriend_log AUTO_INCREMENT = 1; ALTER TABLE tag AUTO_INCREMENT = 1; ALTER TABLE tag_relation AUTO_INCREMENT = 1; ALTER TABLE tag_summary AUTO_INCREMENT = 1; ALTER TABLE wishlist AUTO_INCREMENT = 1; ALTER TABLE log_quote AUTO_INCREMENT = 1; ALTER TABLE report_event AUTO_INCREMENT = 1;

ALTER TABLE sales_order AUTO_INCREMENT=1; ALTER TABLE sales_order_datetime AUTO_INCREMENT=1; ALTER TABLE sales_order_decimal AUTO_INCREMENT=1; ALTER TABLE sales_order_entity AUTO_INCREMENT=1; ALTER TABLE sales_order_entity_datetime AUTO_INCREMENT=1; ALTER TABLE sales_order_entity_decimal AUTO_INCREMENT=1; ALTER TABLE sales_order_entity_int AUTO_INCREMENT=1; ALTER TABLE sales_order_entity_text AUTO_INCREMENT=1; ALTER TABLE sales_order_entity_varchar AUTO_INCREMENT=1; ALTER TABLE sales_order_int AUTO_INCREMENT=1; ALTER TABLE sales_order_text AUTO_INCREMENT=1; ALTER TABLE sales_order_tax AUTO_INCREMENT=1; ALTER TABLE sales_order_varchar AUTO_INCREMENT=1; ALTER TABLE sendfriend_log AUTO_INCREMENT=1; ALTER TABLE tag AUTO_INCREMENT=1; ALTER TABLE tag_relation AUTO_INCREMENT=1; ALTER TABLE tag_summary AUTO_INCREMENT=1; ALTER TABLE wishlist AUTO_INCREMENT=1; ALTER TABLE log_quote AUTO_INCREMENT=1; ALTER TABLE report_event AUTO_INCREMENT=1;

ALTER TABLE sales_flat_quote AUTO_INCREMENT = 1; ALTER TABLE sales_flat_quote_address AUTO_INCREMENT = 1; ALTER TABLE sales_flat_quote_address_item AUTO_INCREMENT = 1; ALTER TABLE sales_flat_quote_item AUTO_INCREMENT = 1; ALTER TABLE sales_flat_quote_item_option AUTO_INCREMENT = 1; ALTER TABLE sales_flat_quote_payment AUTO_INCREMENT = 1; ALTER TABLE sales_flat_quote_shipping_rate AUTO_INCREMENT = 1; 更改表sales_flat_order_item AUTO_INCREMENT = 1;

ALTER TABLE sales_flat_quote AUTO_INCREMENT=1; ALTER TABLE sales_flat_quote_address AUTO_INCREMENT=1; ALTER TABLE sales_flat_quote_address_item AUTO_INCREMENT=1; ALTER TABLE sales_flat_quote_item AUTO_INCREMENT=1; ALTER TABLE sales_flat_quote_item_option AUTO_INCREMENT=1; ALTER TABLE sales_flat_quote_payment AUTO_INCREMENT=1; ALTER TABLE sales_flat_quote_shipping_rate AUTO_INCREMENT=1; ALTER TABLE sales_flat_order_item AUTO_INCREMENT=1;

这篇关于Magento:订购可配置产品后，由于缺货而取消了该产品的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！