![]() ![]() You should see them attached to unconverted quote objects (carts). If you want to find your 'missing' increment_ids, take a look in sales_flat_quote under the field reserved_order_id. Which calls Mage_Sales_Model_Quote::reserveOrderId() You can see this happening in the PayPal express module at: Mage_Paypal_Model_Express_Checkout::start() If the customer abandons the payment process in the gateway, the order id is dead (or more correctly still attached to the quote). This behaviour exists to allow Magento to send payment gateways the final order id (increment_id), before the order is completed allowing the gateway to associate the order id with the order. You can see this effect sometimes in the order numbers as they come in on a busy store - occassionally a really old order id comes through in the day's orders from a customer that is checking out an old cart. If a customer abandons their cart (ie the quote object) before completing the checkout process, the reserved increment_id will never show up on an order. The last used ID for each store is stored in eav_entity_store. ![]() You can see the code that gets an increment id at: Mage_Eav_Model_Entity_Type::fetchNewIncrementId() When Magento enters the checkout process it 'reserves' an increment_id and places it on the quote (cart) object. This is normal, albeit understandably disconcerting. Does someone know why this is happening and if there's a way to fix it? My question is why is Magento jumping increments sometimes? And worse yet, in my example order with increment 100000008 goes after 100000020. This is how it looks after a number of live orders placed: increment_id created_at updated_at Unfortunately, the data '999' wasn't automatically copied over into my new column in sales_order_address.For some reason order ID's (increment_id on sales_flat_order table) are not incrementing subsequently on my Magento 1.6.1. When I first land on checkout, I manually (in the database using Sequel Pro) added '999' into the quote_address custom column 'custom_module_table_id' and then proceeded to checkout successfully. ![]() I created two new columns in quote_address and sales_order_address as shown below. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |