Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [increment-id]

The tag has no usage guidance.

0
votes
0answers
13 views

Order numbers (increment_ids) missing?

I noticed that there are missing order numbers on a daily basis. I did a little research and found Magento Order Number Issue, but I am not sure I really understand how it happens. I tried to ...
0
votes
2answers
112 views

Get order id by order increment id in Magento 2

I want to get order id by order increment id. I have this code but it is returning empty value: $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $incrId = 100005363; $collection =...
3
votes
1answer
41 views

Recently, I have about 10 new orders that have an id and orderid but can't find them in the sales order grid

I have the time of checkout and the amount as well as shipping_first_name and shipping_last_name. The thing is the status is abandoned and the response is "failed" like their CC didn't process ...
0
votes
1answer
24 views

Magento2 : IncrementId value not resulting in an order

I want to load the data of an order with the incremental id after placing an order. I am getting the incremental id in the data array after placing an order, but cant load any orders with it. My ...
1
vote
0answers
41 views

Magento 2: Add invoice Increment ID to Order grid

I am trying to add invoice increment ID to order grid in magento 2 admin like below: app/code/Payment/Status/view/adminhtml/ui_component/sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"...
1
vote
1answer
43 views

Magento Admin - Reorder - New Increment ID

In magento 1.9.x if i click in "reorder" in an order page he duplicate the increment_id of original order and add "-1" in the end. ex: order-> increment_id = 12345 reorder-> increment_id = 12345-1 ...
1
vote
1answer
30 views

Recurring Payment IPN variables confusion

I have created subscription type of products in Magento 2.2.5 CE. And when i tried to purchase subscription type product( recurring payment type) paypal returns three IPNs. 'txn_type' = cart/...
3
votes
2answers
429 views

sales_order table - increment_id doesn't match entity_id

I'm unsure whether they should match or not, I haven't been able to find a definitive answer yet. The start of sales_order table looks fine: But suddenly the increment_id column stopped matching the ...
0
votes
0answers
21 views

Magento 1 EE - Order increment id is not getting incremented sometimes

We have Magento Enterprise edition 1.12 and using FatZebra as a payment method. We observed that when the traffic is more some of the transactions are failing with error "Reference is already taken". ...
1
vote
1answer
362 views

Creating Quote and Order programmatically and the issue with ReservedOrderId

I was trying to create orders and quotes programmatically, in an API resource that is consumed by a Mobile Application, and i was successful. However every now and then I got a ...
0
votes
0answers
56 views

How to generate the next order increment Id in Magento 1.x?

I'm creating an import script to import missing orders from an old database. I have changed the start order numbers in eav_entity_store to higher number by changing increment_last_id. Now what is ...
3
votes
0answers
74 views

How to get custom table next id to be saved?

My scenario is saving an image to a folder. Why I am using id is I have to save a lot of items(images, pdf) into the same folder as it is all related to this item. When new data is created I want to ...
0
votes
1answer
101 views

Increment id is not continuous in magento2

I have got a strange issue when I create a new product in backend my id is incremented +2 see the below image if i place the order .my order id also incremented +2 see the below image in my custom ...
0
votes
2answers
63 views

Get Order by increment_id

I'm trying to read from a csv file a list of increment_ids and get order using them. if (($file = fopen('increment_ids.csv','r')) != FALSE) { while($data = fgetcsv($file,0,"\t")) { $...
1
vote
1answer
292 views

How to change Invoice increment id?

I want to change Invoice increment id from new series with the prefix. I have checked sequence_invoice table in the database. I have found 4 table: sales_invoice_0 sales_invoice_1 sales_invoice_2 ...
1
vote
1answer
423 views

what is the difference between entity id and increment id in sales_order table

which id should be used for order status update. How should the status be updated?
0
votes
1answer
126 views

Magento 2.1: Change increment ID for new orders

Is there any way to change increment ID for new orders. For example if current last order ID is 1000. But for new orders, I want to start it from 1020
1
vote
1answer
335 views

Tracing missing order numbers in the database, possibly even before they are “reserved”

Hoping for someone to chime in who extensively knows the Magento database architecture inside out. Missing order numbers. Example, in Magento, order number increments like: 100002410 100002411 ...
0
votes
1answer
881 views

Magento 2 Can you get Order Increment id from Invoice Increment id?

I am making a module where I am getting Invoice Increment id but I need Order Increment id. How to get the Order Increment Id by using Invoice Increment id? If anyone has ideas please let me know. ...
0
votes
1answer
31 views

Why increment id changes by large value?

I have used increment id for loading and saving orders in my magento stores since long. I've seen it change it's value from 124 to 2000000004 between two consecutive orders. What I do not understand ...
1
vote
1answer
593 views

What is the difference between order id, increment id and quote id?

I observed that all the above term's value are different which I thought to be same. echo $orderId = $observer->getEvent()->getOrderIds(); echo $qid = $order->getQuoteId(); $order_data= $...
2
votes
0answers
166 views

Using numeric only increment_id for orders? READ THIS! Magento 1

There's a bug in MySQL which disabled searching by index if two columns are compared which are of a different type. Magento stores increment_id as VARCHAR in sales_flat_order but Magento does not cast ...
2
votes
1answer
525 views

Magento 2 Random Order/Invoice/Shipping number

I am looking into ways to implement random sequence for Order/Invoice/Shipping number and make sure they are unique in there entity type. Is there a way to make it correct? Since i know that it is ...
0
votes
1answer
1k views

Magento 2 Reset order increment id after deleting test orders

I've cleaned my db from the test orders, following this instructions here https://stackoverflow.com/questions/37861046/how-to-remove-test-orders-from-magento2 But the order increment id, still ...
1
vote
0answers
255 views

Magento 2 - How to modify order increment_id before saving it to sales_order_grid table?

I want to remove prefix only from sales order grid increment_id.
4
votes
1answer
786 views

Add Dynamic Order Number Prefix [mm-yy-ordernumber]

My client wants the current month and year as a prefix in order numbers. I have read many blogs but they are all for static prefix for order number. I am looking for a solution in Magento 2.
4
votes
3answers
737 views

How to set order increment id iterator in magento 1?

Is there possible for magento 1 to increase order id each time plus 4. Ex. My current order is 10001 and when we placed next time order from store next id would be 10005, after another next time it ...
1
vote
1answer
319 views

Few questions about developing custom Payment Gateway

I am creating a custom payment module using Paypal API(Don't want to use any Magento Paypal Module). I have 2 question while developing the custom module. Please help me to solve it. My logic is as ...
0
votes
1answer
160 views

Order / Invoice - Prefix “16-” NOT POSSIBLE?

I need to customize my prefix for the order / invoice ID´s. So my order number should look like this: 16-0001 I need the year as prefix with an "-". But when I try this: UPDATE eav_entity_store SET ...
0
votes
1answer
209 views

Order increment id not saving correctly

I have code that saves order details to a custom table: foreach($links as $link) { $pdf = Mage::getModel('custom_sales/pdf'); $pdf->setOrderId($order->getId()) -&...
0
votes
2answers
753 views

How to Create custom increment id like sales order increment_id for custom module

I want custom increment_id field in custom module. Like sales_flat_order increment_id. Is EAV table format is best solution?
1
vote
1answer
306 views

How to get increment id on current page?

I need to redirect to get data relevant to current increment ID of Order entity? So how I find current increment ID? public function viewAction() { $this->loadLayout(); if($...
2
votes
1answer
661 views

Magento 1: Exceeding the Padding Length of an Increment ID

Can a Magento 1 system survive an increment ID that exceeds its padding length? That is -- the eav_entity_type table contains an increment_pad_length column that defaults to 8. This means when ...
0
votes
1answer
97 views

Apply Order Number Prefix For Orders Container Recurring / Nominal Products

I am in the process of trying to highlight specific orders containing recurring / nominal products to an admin user as well as inside a data feed that exports order data on a daily basis to a ...
0
votes
2answers
259 views

Get order id from purchased downlodable product id

How can I get order id from purchased downlodable product ? Please check my below code : $purchased = Mage::getResourceModel('downloadable/link_purchased_collection') ->addFieldToFilter('...
2
votes
2answers
731 views

Is the incremental order Id unique across all customers/orders/websites?

My question is, how unique is the incremental order Id? The payment gateway I'm using requires a unique order Id for every purchase attempt. So let's say customer A tries to purchase, but his ...
1
vote
3answers
2k views

How to search orders using a purchase order number [closed]

I need to be able to filter orders by searching the purchase order number from the order. Is this possible?
0
votes
1answer
202 views

Magento set product sku as prefix of order id

I know that, Magento has it's own way of generating order ids for orders placed through it. Instead of the default way, I want to set product sku as the prefix for order-ids and keep order increment ...
0
votes
2answers
399 views

Increment quote_id manually

I'm having problems with the credit card payment transaction and I'm kind of sure that the quote_id is the cause of it. The problem is I don't know how to increment manually the quote_id in order to ...
5
votes
4answers
20k views

How to change order increment prefix?

I run a shop (Magento CE 1.6.2) with 4 different store-views, which have (for historical reasons) ID's 1, 3, 4 and 7. Order numbers have been looking like this 10000001, 30000001, 40000001, 70000001. ...
0
votes
1answer
4k views

How to get the shipment number of an order item?

Once an order is placed, I programmatically generate associated shipments (because of different manufacturing time on my products) I can then have for a single order several associated shipments: ex:...
2
votes
2answers
160 views

make increment_id of an order syncron to external system

We are integrating Magento with an existing system. Our existing system already has order numbers. There has been a lot of confusion since Magento has its own order numbers, and our existing system ...
1
vote
1answer
2k views

Change order increment_id of existing orders

In a test system I would like to change increment_id for all orders. Otherwise I would get conflics with another module. Can I simple change increment_id in sales_flat_order or will this messup ...
4
votes
2answers
12k views

get order details by Order Id in magento [duplicate]

I am trying to get order details by order id in my code. For this I have created a php file and copy that file to a folder in public_html. this is my code : <?php error_reporting( E_ALL ); ...
1
vote
4answers
4k views

Event to use to fetch Order Id and not Increment Id

I am using the event <sales_order_place_after> in my observer to perform some action. I am inserting the Order ID in my custom table. But what I observe is that it does not give me Order ID but ...
0
votes
2answers
3k views

Custom order number or increment id in Magento

I want to shorten order number (increment id) but I don't want to use any modules.
1
vote
1answer
739 views

Error in M2E Pro invoice/shipment increment ID duplicate key [closed]

I am using M2E Pro and sometimes Magento shows me an error stating that invoice or shipment is not created. Error for invoice creation: Invoice was not created. Reason: SQLSTATE[23000]: Integrity ...