[IMPROVEMENT] Add stock information to order detail

[Hlavtox]

Hi guys, I made this modification on our store, I thought you and other merchants may be interested in this too. Lets start:

The situation
During our years in ecommerce, there was a million situations, where we argued with the customer in this style.
Customer (3 days after order): Where is my goods I have ordered?
Us: The stock information on the product was "On special order - 10 days".
Customer: No, there was written "In stock".
Us: There was not!

The solution
It is useful to display complete stock information that was shown on the product, at the time of order.

Where to display this:

• In mailalerts
• In order admin
• In customer confirmation email

How to do it
Save product->available_later to OrderDetail, along with the other information. (We already have quantities, which is good.)
Echo this information on the respective places.

My quick solution
For now, I use it only in mailalerts, but in the future, it would be good to show it also to customers in order_conf.

I show 3 cases under the product name:
A) All in stock
B) XX pieces in stock, the rest 'On special order'
C) All on 'On special order'

[khouloudbelguith]

Hi @Hlavtox,

We have already some improvement in the FO to add the stock alert as described here: #14572 (comment) & here: #16386 (comment)
Your improvement is to add this information in the Emails sent to the customer.
I think it could a great idea, but it is should be an option we can enable & disable it.
Ping @PrestaShop/prestashop-product-team what do you think of this improvement?

Thanks!

[Hlavtox]

@khouloudbelguith Yes, that will be nice improvements. I did it as one of the first mods. It's just a template modification.

The problem I specified in the first post is, there is no way to retrieve this information from the order object AFTER ordering. There are lots on informations saved to OrderDetail, like quantities, references, prices etc., but the stock information is missing.

Product list:

Cart:

[hibatallahAouadni]

Ping @PrestaShop/product-team friendly reminder 😉 what's the status of this issue? Still need specs?

[marionf]

Hello @Hlavtox

It is useful to display complete stock information that was shown on the product, at the time of order.

By "complete stock information", are you talking of the label of in-stock & out of stock products or of the delivery time of in-stock & out of stock products ?

[Hlavtox]

@marionf Hi Marion! :)

I think we can save both of these values, availability and delivery time. We can then decide if and where we are gonna display these values.

If you agree, we can start with a PR where we save this informations into the database. :-)