Project Detail

Description

I would like an admin module for merging orders. I have a lot of customers making several orders in one day and it is time consuming to merge those orders manually. Therefor I would like to have a specially made admin module to do this for me (merge 2 or more orders into 1).

I have a shop based on a CRE Loaded 6.2 patch 13 that has been heavily modified and are using Norwegian language and tax so some adjustments compared to an original Creloaded shop may be needed. The development of this module will be done on a plain CRELoaded 6.2 version (install files can be provided by me), and I want the module to be developed as a module with install instructions. You will not get access to my live shop. I will implement the module based on your install instructions my self. I am available to test the modules during the development process to give feedback if needed.

GUI
1. I want a new choice in the admin under customers/orders tab menu that is called "Merge Orders".


2. First we want the module to do a check and list all possible orders that should be meged after a set of criteria's.

2b. The module have to list orders that are from the SAME customer and have the SAME order status and the SAME delivery address (all three criteria's have to match).

I want it to be listed like the example in the .jpg file where we have 3 customers with more than one order that should be merged.

LOOK IN THE ATTACHED .JPG FILE HOW WE WANT THIS LISTED!

We shall be able to merge orders from one and one customers by clicking the {merge button} or merge all at the same time by clicking the {merge all button}

We would like to have a configuration option in the admin where all order statuses are listed where we can tick those order statuses we want the merging module to check from. This is because we don't want the check to be executed on for example already delivered orders.

3. When we merge orders we want the orders to be merged into the lowest order number. Example we want to merge order number 104, 107 and 109 when we hit the merge button it should merge all the orders into order number 104 who is the lowest number.

4. The new merged order(the Lowest order number) shall keep it's original order status. While the other ones will get a new predefined status after the merging. We want to be able to set this predefined status in the admin configuration with a drop down box that list all available order statuses.

FUNCTIONALITY (what I want to happen when I press the merge order button):
1. The product lines from the merging order(s) are to be copied to the master order (Master order is the one with the lowest order number).


2. The following should happen to the merged from orders: The products in the merged from orders are to be set to zero in quantity and zero on all total prices, but keep the base/unit price for each product line.

2b. It also have to set all kind of shipping and cash on delivery fee to zero.

2c. The order when finish should still show the product lines, but with zero in quantity and price. and the order total are also set to zero since both the product price and all kind of shipping and fees are set to zero in the order.

2d. The order status shall be updated to the predefined order status and it shall also fill in an order status comment containing "Your order are merged with order number {master order number}" the master order number are to be filled in automatically.

3. The following should happen to the merged to order (master order):

3b. The master order should keep it's original order status and it shall also fill in an order status comment containing "Your order are merged with order number(s) {merged from order number list}" the order number or numbers are to be filled in automatically and an email order update for the order shall be sent to the customer with the comment included and the customer notified is set to yes.

4. We are also using different discount modules as example coupon codes and 2 for 1 and gift codes. so the merging also have to take this into consideration and also move all discounts to the new order.

5. We use a modified Cash on delivery module with the ot_total named "ot_fixed_payment_chg". When payment on the order is COD (cash on delivery) the shipping fee and COD fee has to be deleted on the merged from order, and only keep the shipping and cod fee from the original master order. To be clear: If I merge two orders that have cash on delivery and the shipping fee for each order is $5, the master order will still have a total shipping fee of only $5

If the order DO NOT contain a COD ("ot_fixed_payment_chg") ot_total we want the shipping from the merged from order to be merged/added to the shipping fee on the master order. So to be clear: If i merge two orders that is not cash on delivery and both orders have a shipping fee of $5 each the master order will have a total shipping fee of $10. and with three orders it will of course be $15 and so on. (It's important that the merged shipping fee is merged together as one amount)

It's very important that tax and everything is calculated right on the finished merged order.

Please be sure that you understand completely the project you are bidding on (if not ask us before bidding). We are looking for an Creloaded and php expert that have a deep understanding of the Crelodad shopping cart code base. Please don't bid if you are not 100% sure that you can complete the task in time. If you deliver only a half finished product you will not get paid.


Additional files submitted:
merging_picture.JPG