Phoca Forum

Hi, I would like the order number to be separate from the billing number, to have two different numbers, let me explain:

Progressive numbering regardless of the order status, whether the user concludes the purchase, is on hold or cancelled. Progressive order numbering I don't really care about this, while the invoice numbering is only progressive when the payment actually takes place!

User 1 > waiting status = order 0001
User 2 > canceled status = order 0002
User 3 > completed status (payment done) = order 0003 / Invoice 0001


How can I do?

Hi, in Phoca Cart there can be independent order and invoice numbers.

E.g. each order gets own number but invoice number is set e.g. only in case the order has some specific order status (like e.g. confirmed).

Order numbers are automatically created by database auto-increment feature so there is no option to somehow change it

Jan

I'm reading your answer with translator, I may not have understood. So you're telling me that the order number is independent of the billing number?

I set the invoice to be issued only when a payment actually takes place and I put COMPLETED, the same COMPLETED status that I use in the paypal plugin when a payment takes place. Is the COMPLETED status in the billing correct? Or should I set CONFIRMED?

Let me explain, yesterday a customer tried to purchase by completing the entire payment process, but the paypal system gave him an error, in fact only after he didn't have the money on his card.

The status of his order from the phoca cart backend went PENDING, although I don't understand why since I set the pay pal plugin with COMPLETED for completed order and SHIPPED for orders that I ship, everything else is set to CANCELLED , so I don't understand why the phoca cart system gave me PENDING status.

PayPal plugin payment method settings: https://imgur.com/R8str7t

This thing generated me an order number or the number 00297 (payment not successful).

Then after a short time I received another order from another customer and the payment was successful, generating order No. 000298 and invoice No. 000298

However, I would have liked that the system had generated me the invoice N° 000297 so that I don't have a numbering hole in case something goes wrong with the order.

Basically I don't care if order N° goes on your behalf, I'm interested that the billing number (when payment is made and the system issues the invoice) is progressive but without gaps. Is it possible to do this? If so how?

It is probable that I did not understand your previous answer, if you can kindly re-explain me, thank you

Yes, it is possible. It depends on options.

As default, order number = invoice number. But you can set that invoice number can be only set when some specific order status will be set (e.g. confirmed). In such case invoice numbers will continue chronologically - just see the options.

Jan

Thanks for the reply. I wanted to ask advice for the paypal plugin. I am selling physical products and the payment option is paypal only. When a user completes the payment I set the status to completed. I also see the confirmed status, so I ask you for my condition of sale, which status is more suitable when a user completes the payment with paypal, STATUS COMPLETED or STATUS CONFIRMED?
Then I ask you what is the difference between these 2 states and when to use them?

Hi, in fact it is up to you, there are just default statuses and depends on you if you like more completed or confirmed.

Mostly confirmed means, you you accepted the order and know about it and it is e.g. paid) and then you set completed for orders which were finished (e.g. the product was successfully sent to customer)

Ok now I understand the meaning of COMPLETED and THE MEANING of CONFIRMED.
So I would say in the paypal plugin options to change the current option of COMPLETED to the new CONFIRMED option.
Since I don't have digital products, but I ship physical products only after receiving the payment, the CONFIRMED option is better at this point.

Then subsequently enter the phoca cart options and the billing section and under "Create invoice number based on order status" set the selection to CONFIRMED, then under "Method of creating invoice numbers" set to ANNUAL BASIS, in order to have a progressive billing number (without holes) only when the order has actually been paid.

In this way, the numbering of the invoice will not take into account the order statuses, but will advance progressively and without gaps, only if the order status is CONFIRMED.

Right?

Hi, each time you save the order (or it will be saved by plugin method) with selected order status, it will just add new number. So in fact, you manage the numbers, because when you are sure, the order is really finished, then only it gets new invoice number. And in fact the chance of getting gaps between invoice numbers is then very minimized.

Jan