WP-Ecommerce Customize

WP-Ecommerce Customize

Closed - This job posting has been filled and work has been completed.

Job Description

1- Integrate coupon code and import data to database
2- Shipping cost
1-6 charge per product 4.99
7-11 charge flat fee 29.94
12 or more Free shipping
Priority Processing is one time fee only, and if people order more than 2 cans is free.


Email Expalining how to send the datas to the fulfillment via XML

**************************************************************************

**************************************************************************


Hi Ernesto,



Before I advise you of anything, keep in mind you would need to do the formulas/logic and calculations on your end and then pass us the order through the API format with the adjusted amount. Once we get the order, we will apply the adjusted amount to the order.



Ordered Rules

1) 1-6 cans, charges apply normally.

2) 7-11 cans, special flat rate $29.94 for S&H.

3) 12 or more cans is free S&H.

4) Some customers might have a coupon/gift cert for $20 off.



Example, CLNO ST offers each Flex Can the following price: ST003: $12.99 + $4.99s&h, ST005 $14.99 + $4.99s&h

Pass data element AMT_DISC amount with the total amount you want to adjust OFF the order and ADJ_CODE needs to be ‘D’.



· Let’s say a customer ordered 8 cans of the ST003 with no coupon. It would be $103.92 + $39.92 S&H. Per the rules above, since it’s between 7-11, the source would pass this order with 8 of the offer codes ST003, and then pass through the API, the AMT_DISC of $9.98.

· Let’s say this same customer purchase 8 cans of the ST003 but this time has a $20 off coupon as well. The AMT_DISC would be passed as $29.98.


Please let us know when you are ready to starting throwing in some test orders to ensure the price calculation that you place is correct.

**************************************************************************

HOW WILL GET THE COUPON CODE FROM FULFILLMENT

Ernesto, Tavid and I are available anytime tomorrow can we jump on a call to discuss the passing of the Discount Amount.



Attached is the OFFERS codes



Regarding the COUPON CODE and EXP.DATE, the shipment file will contain the MLM order# which is going to be the coupon code and the expiration date will be 30D from the ORIG ORDER Date . The FILE is CSV format will also include the ORIG Order Date and Ship Date.



File :

ORIG ORDER DATE

MLM Order#

First Name

Last Name

Ship Date

Is there anything else you want in the file and do you have a FTP where you want the file posted to daily?

---
Skills: import, test

Open Attachment