update order - edit order

[tudoroiuj]

Hi,

 

i want to be able to up[date an order of a client.

 

Often i call clients to confirm order, and they want to add another product or to change the product.

 

how can i do this?

 

thank you,

tj

[musicmaster]

Prestashop does not offer the possibility to edit your order. They seem to consider this a kind of bookkeeping package where you shouldn't be able to change such information. So you need some additional software.

 

There are two options:

 

The free option. It is not integrated in the Backoffice but works well.

http://www.prestashop.com/forums/topic/45384-module-free-script-to-edit-orders/page__st__120

 

The paid option: Orlique (89$)

http://addons.prestashop.com/en/administration-tools/2290-orlique-the-order-manager.html

[ganador]

so stupid that it doesn't allow editing of orders.

Tons of features but essential functions are missing... like the documentation...

 

Yes, as it is written in the about-us:

PrestaShop has revolutionized the industry by providing features

 

Consider using another shop software which is simpler and better documented...

 

Buying modules and being dependent of third party software vendors which may not update a module to the next version is another question...

 

First I had the WOW-(Free)-Effect which turned now into a OH-SHIT-Effect....

[jberezhnoy]

so stupid that it doesn't allow editing of orders.

Tons of features but essential functions are missing... like the documentation...

 

Yes, as it is written in the about-us:

 

 

Consider using another shop software which is simpler and better documented...

 

Buying modules and being dependent of third party software vendors which may not update a module to the next version is another question...

 

First I had the WOW-(Free)-Effect which turned now into a OH-SHIT-Effect....

 

Well, probably have to agree that order updating is a required feature.

But in any case you can edit it directly from MYSQL DB

[musicmaster]

You can update orders in 1.5 without additional software.

[Maury Markowitz]

Can you add new user/orders/addresses and add/delete/change items, and so forth?

[pxloft]

Well, probably have to agree that order updating is a required feature.

But in any case you can edit it directly from MYSQL DB

Where exactly in the DB do I have to edit??

[mauglee]

Maybe my solution will be good for some of you googling for "how to edit edit order in prestashop". For example, we have a shop in which all orders must be revised before any other actions. E.g. we want to increase quantity, add another product, reduce price for some of them, etc. Here is a solution.

 

1. BackOffice:

Orders → Statuses → Add new order status

2. Create status (e.g. „Not confirmed yet“) and remember its ID. Lets say the ID is 16.

3. This step is unnecessary. Prevent status from deletion. Run query in DB:

UPDATE `ps_order_state`
SET `unremovable` = '1'
WHERE `id_order_state` = '16';

4. Now find all existing status values in DB:

SELECT *
FROM `ps_configuration`
WHERE `name` LIKE '%PS_OS_%'
ORDER BY `value` ASC;

5. Export result for backuping purposes and keep somewhere safe

name,value
PS_OS_CHEQUE,1
PS_OS_BANKWIRE,10
PS_OS_PAYPAL,11
PS_OS_WS_PAYMENT,12
PS_OS_OUTOFSTOCK_UNPAID,13
PS_OS_COD_VALIDATION,14
PS_OS_PAYMENT,2
PS_OS_PREPARATION,3
PS_OS_SHIPPING,4
PS_OS_DELIVERED,5
PS_OS_CANCELED,6
PS_OS_REFUND,7
PS_OS_ERROR,8
PS_OS_OUTOFSTOCK,9
PS_OS_OUTOFSTOCK_PAID,9

6. Now the last part. To change status value for „Preparation in progress“ do:

UPDATE `ps_configuration`
SET `value` = '16'
WHERE `name` = 'PS_OS_PREPARATION';

7. Please, make test shopping and you will see, that an order which normally was with status „Preparation in progress“ now is with our new status „Not confirmed yet“.

8. Now the order is editable in BackOffice.

9. Of course after you edit an order, you must change its status to some other (lets say to „Preparation in progress“).

Thats all.

Edited February 18, 2016 by mauglee (see edit history)

[cvikenzi]

Hello,

for update order in your back office, you can try Edit Existing Orders module here:

http://addons.prestashop.com/en/23760-orders-management-edit-existing-orders.html

 

Also for advanced order management with automatically genarating documents numbers you can try this one:

http://addons.prestashop.com/en/24429-orders-management-pro-edit-orders-and-custom-numbers.html

Edited October 14, 2016 by cvikenzi (see edit history)

[karolretezan]

https://www.prestashop.com/forums/topic/276384-solvedunable-to-modify-customer-order-from-backoffice/

 

It work perfect.

Edited October 6, 2016 by karolretezan (see edit history)