Add Product to an order *preparation in progress*

[mytwocentimes]

So, a client ordered a product that didn't have sufficient quantity. I refunded and restocked the item (don't know if this is correct procedure), BUT the difficult bit is that I get the following message when I try to add a product to the order: "Can't add a product on delivered order"

 

Status on the order is "preparation in progress"

 

thanks for any tips / advice

[troyrob]

I have the same issue

[benjamin utterback]

Hello, thank you for this message. How did you attempt to add a product to an existing order? Did you refund the whole order?

[mytwocentimes]

Partial refund. Client has ordered TWO of a product and I can only deliver ONE. I refunded ONE and then tried to add the product in a different combination (GREEN). Then the message.

 

It is unclear to me when the FLAG_DELIVERY gets set, but it is set to "1" for delivered in the status "preparation in progress"

 

D

[benjamin utterback]

How did the customer pay? Did you have Out of Stock Ordering set to Yes?

[mytwocentimes]

How did the customer pay? Did you have Out of Stock Ordering set to Yes?

 

@Benjamin Customer pays via a bank transfer (Awaiting bank wire payment) - I set the status to "preparation in progress"

 

No. Out of Stock Ordering is set to No.

[benjamin utterback]

Hi, thanks for the response. It is strange that you have Out of Stock Ordering set to No but still your customer still was able to order a product that was out of stock.

 

When you send a refund from the BackOffice, it does not automatically take a certain amount from the bank transfer. You would have to manually do it through your bank.

 

I'm also a little confused as to how you are going about adding a product to a completed and paid for order.

[mytwocentimes]

Hi, thanks for the response. It is strange that you have Out of Stock Ordering set to No but still your customer still was able to order a product that was out of stock.

 

You are sooo cute :-)

 

The difference between the stock in the warehouse and the stock in the Prestashop differs at times. This is a function of the real world ...

 

 

When you send a refund from the BackOffice, it does not automatically take a certain amount from the bank transfer. You would have to manually do it through your bank.

 

To be clear - yes, the "partial refund" in the BO is purely to manage a) the invoice the stock level (I guess stock is added back into the inventory) c) reduce the invoiced amount ... actually dealing with funds is another process

 

I'm also a little confused as to how you are going about adding a product to a completed and paid for order.

 

Let's recap ...

1. client logs into PS

2. client creates order from shopping cart

3. client chooses to pay via bank wire (this means - for me - that she will make a transfer in the next days)

4. I see the order - and that the client is planning to pay.

5. I change the status to "preparation in progress"

6. create delivery slip and send it to the warehouse

7. warehouse picks product and informs that we don't have sufficient article

8. I go to client and ask if she wants a refund, partial refund, replacement product

9. client chose a different color of same product

10. I give a partial refund - reduce the quantity of the offending product

11. I attempt to add a new product (as client wants)

12. I get annoying "can't add product on delivered order"

 

13. dumb and weakened by days of hacking at 1.5.2 - I come to the forum looking for a workaround or insight

 

@benjamin - thanks for putting your nose in my business :-)

[www.exclusivepen.eu]

Hello.

I got the same problem, but I did not any refunds or any other operations. Just simple example - customer placed an order of one product. I wanted to add other product to the order in BO by clicking "add a product" and start typing name of product to find the right one. After I selected desired product, I clicked "add product". I just received an error message "Alert -

Can't add a product on delivered order

" BUT this order has just one status "Preparation in progress" and it has never been in delivered status.

Could you please help me? I have 1.5.2. version.

 

Thanx.

Andrej

[mytwocentimes]

I've changed the value of the DELIVERY field for the "preparation in progress" line 3 from 1 to 0.

 

Seems to fix issue

 

id_order_state,invoice,send_email,module_name,color,unremovable,hidden,logable,delivery,shipped,paid,deleted
1,0,1,cheque,RoyalBlue,1,0,0,0,0,0,0
2,1,1,,LimeGreen,1,0,1,0,0,1,0
3,1,1,,DarkOrange,1,0,1,0,0,1,0
4,1,1,,BlueViolet,1,0,1,1,1,1,0
5,1,0,,#108510,1,0,1,1,1,1,0
6,0,1,,Crimson,1,0,0,0,0,0,0
7,1,1,,#ec2e15,1,0,0,0,0,0,0
8,0,1,,#8f0621,1,0,0,0,0,0,0
9,1,1,,HotPink,1,0,0,0,0,1,0
10,0,1,bankwire,RoyalBlue,1,0,0,0,0,0,0
11,0,0,,RoyalBlue,1,0,0,0,0,0,0
12,1,0,,LimeGreen,1,0,1,0,0,1,0
13,1,0,,#DDEEFF,0,0,1,0,0,0,0

[size=4]

[/size]

[djmila]

I've changed the value of the DELIVERY field for the "preparation in progress" line 3 from 1 to 0.

 

Seems to fix issue

 

id_order_state,invoice,send_email,module_name,color,unremovable,hidden,logable,delivery,shipped,paid,deleted
1,0,1,cheque,RoyalBlue,1,0,0,0,0,0,0
2,1,1,,LimeGreen,1,0,1,0,0,1,0
3,1,1,,DarkOrange,1,0,1,0,0,1,0
4,1,1,,BlueViolet,1,0,1,1,1,1,0
5,1,0,,#108510,1,0,1,1,1,1,0
6,0,1,,Crimson,1,0,0,0,0,0,0
7,1,1,,#ec2e15,1,0,0,0,0,0,0
8,0,1,,#8f0621,1,0,0,0,0,0,0
9,1,1,,HotPink,1,0,0,0,0,1,0
10,0,1,bankwire,RoyalBlue,1,0,0,0,0,0,0
11,0,0,,RoyalBlue,1,0,0,0,0,0,0
12,1,0,,LimeGreen,1,0,1,0,0,1,0
13,1,0,,#DDEEFF,0,0,1,0,0,0,0

[size=4]

[/size]

 

Very ... Thank you .... very nice Jobs

Edited December 27, 2012 by djmila (see edit history)

[mytwocentimes]

and where can I change this? Thank you

 

Went directly to the database via PHPMYADMIN panel - I don't recall the exact table, but it is one of the ORDER tables

[djmila]

Went directly to the database via PHPMYADMIN panel - I don't recall the exact table, but it is one of the ORDER tables

 

Yes ,it's alright

 

Thank you for help

[djmila]

New problem

 

Back office/new order/Search customer/search a product with Define the label of the text fields:

required/

 

 

You can not add

(Solved) - you must re save all produkts with Define the label of the text fields:

Edited December 27, 2012 by djmila (see edit history)

[sadlyblue]

I've changed the value of the DELIVERY field for the "preparation in progress" line 3 from 1 to 0.

 

Seems to fix issue

 

id_order_state,invoice,send_email,module_name,color,unremovable,hidden,logable,delivery,shipped,paid,deleted
1,0,1,cheque,RoyalBlue,1,0,0,0,0,0,0
2,1,1,,LimeGreen,1,0,1,0,0,1,0
3,1,1,,DarkOrange,1,0,1,0,0,1,0
4,1,1,,BlueViolet,1,0,1,1,1,1,0
5,1,0,,#108510,1,0,1,1,1,1,0
6,0,1,,Crimson,1,0,0,0,0,0,0
7,1,1,,#ec2e15,1,0,0,0,0,0,0
8,0,1,,#8f0621,1,0,0,0,0,0,0
9,1,1,,HotPink,1,0,0,0,0,1,0
10,0,1,bankwire,RoyalBlue,1,0,0,0,0,0,0
11,0,0,,RoyalBlue,1,0,0,0,0,0,0
12,1,0,,LimeGreen,1,0,1,0,0,1,0
13,1,0,,#DDEEFF,0,0,1,0,0,0,0

[size=4]

[/size]

 

Thanks, I had the same problem.

Also, i want to make a check list to go inside the package, but first i had to edit the order so it reflected the sent items.

[sadlyblue]

Just found a bug.

When i add a product, it doesn't get the specific price for that client's group.

The strangest thing is that it doesn't get the price with no discount either...

Anyone has the same problem? Or know a possible solution?

Thanks

[benjamin utterback]

Hello sadlyblue, please make a new thread for this separate issue. I'm not sure if that is a bug or a misconfiguration In any way, you should make a new thread please. Thank you!