My guess is your orders are going to the missing orders, try to use the filter in admin order page to check missing orders and see if they’re there.
Get a secure, fast, and reliable web hosting service from https://turnuphosting.com.
I agree...more info needed.mikeinterserv wrote: ↑Fri Jan 15, 2021 9:09 amYou might want to translate that a bit better and ADD which OC version your using, whether you have extensions and whether its the standard theme or not.
Get a secure, fast, and reliable web hosting service from https://turnuphosting.com.
Yes that's normal.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
user 1 : has order_id number 1 hasn't finished checking out
user 2: has finished checkout it will assign order_id 2 instate of 1
looking for a addon that will not skip the order_id, once they finish checking out then vacate the order_id not like it has the item in the cart that user gets a order_id
using: 3.0.3.3
admin/sale/model/order.php
$sql .= " WHERE o.order_status_id > '0'";
to
$sql .= "";
it will show everything
So
If user no1 does NOT checkout then user no1 does NOT have an order ID
If user no2 checks out he has the NEXT INCREMENTAL ID available in the DB
order_idPrimary int(11) No None AUTO_INCREMENT Change Change Drop Drop More More
any addon i can use - on confirmation page then they get a order_id #
If you DON'T CHECKOUT you DO NOT have an order ID
OTHERWISE ALL visitors browsing the site and putting stuff in cart etc etc etc would just keep creating hundreds of wasted order IDs
That is NOT what happens OR how it works.
The ONLY way you lose an order ID is when the order goes into MISSING ORDERS AFTER checking out or cancelling the order at payment
Every time you reach the confirm section on the on checkout an order id is generated. If you reach the confirm section and go back to edit your address, another order id is generated. .
Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!
Yes still the NEXT incremental ID available - No order ID is LOST or SKIPPED
AND
I can't make 3.0.3.6 work like that
You would soon NOTICE these MISSING or SKIPPPED order IDs and wonder where the heck they are wouldn't you.
Because one day you see last order with ID 100 next day you see the NEXT order with ID 150 then there are EITHER 49 orders in MISSING ORDERS or WHAT ?
If they are NOT in MISSING ORDERS your ORDER ID is going to still be 101 NOT 150
Already plenty of threads and its been discussed many times.
Feel free to read through this thread to understand its working - viewtopic.php?f=121&t=9192#p43453
Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!
They HAVE to be in MISSING ORDERS - simple as that OR they have NO order IDsw!tch wrote: ↑Sat Jan 16, 2021 2:54 amRight, but where did the OP mention not seeing them in missing orders? This is how opencart works.
Already plenty of threads and its been discussed many times.
Feel free to read through this thread to understand its working - viewtopic.php?f=121&t=9192#p43453
THEN if you had a list of ALL orders including missing ones there are NO SKIPPED or MISSING IDs
If you change that behaviour your order IDs will be all over the place.
in reality on a descent working site missing orders tend to be very few and far between anyway
Re the topic TL:DR but got the jist, thanks for that link
New Customer
Checkout:
Create Account
Guest Checkout
for example i am guess
once i put my info next page i am getting a order_id sql shows i haven't reach to final confirmation page.
why should i get a order_id if i haven't got to successful checkout confirmation page order was processed.
you right, people still don't get it, my opinion it's done wrong, that's just me. i will not give you a order_id # if you haven't bought this item from me. for example "OsCommerce" doesn't work like the opencart dose - end of the checkout successful page you get a order #sw!tch wrote: ↑Sat Jan 16, 2021 2:54 amRight, but where did the OP mention not seeing them in missing orders? This is how opencart works.
Already plenty of threads and its been discussed many times.
Feel free to read through this thread to understand its working - viewtopic.php?f=121&t=9192#p43453
got a find a way to recode this.
thank you guys for all the HELP
Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!
I'm sure the problem with this is that if paypal callback cannot get through and a customer click back instead of returning to the store the order with be overwritten.
Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!
What makes you think that people are going to go as far as entering their information for checkout and THEN NOT checking out.
I know there could be the RARE reason but not many will do that in reality.
I understand what you want and the topic link by switch has many answers take a deeper look.
I think you may find you are worrying about something unnecessarily.
Users browsing this forum: No registered users and 570 guests