WorldPay Module for ZenCartv1.3x

[duncanad]

Marc,

Instead of waiting to see if you lose any more orders why not quickly change your WorldPay module to test mode and put an order through yourself to see what happens and then change back to live mode. Or simply put through a low value order using your debit card. If you run the store the card payment will come to you anyway and all it will cost you is the debit card transaction fee - about 50p.

All my Zencart installations are set to store sessions in the database and I have never had a callback problem.

There is no easy solution to retrieving the order information you require. The following may help.

1. In your WorldPay control panel identify the payments you cannot match to orders.
2. Take a note of customer names and order values.
3. In ZenCart Admin >> Customers >> Customers use the search box to find each customer within ZenCart and take a note of their ID.
4. Access your store database using phpMyAdmin
5. Run the following query on your database to identify the current contents of each affected customer's shopping basket

SELECT cb.customers_id, c.customers_firstname, c.customers_lastname, ab.entry_street_address, ab.entry_suburb, ab.entry_postcode, ab.entry_city, c.customers_email_address, c.customers_telephone, p.products_id, p.products_model, cb.customers_basket_quantity, p.products_price
FROM customers_basket cb, customers c, products p, address_book ab
WHERE cb.customers_id = XXXX
AND c.customers_id = cb.customers_id
AND c.customers_default_address_id = ab.address_book_id
AND p.products_id = SUBSTRING_INDEX(cb.products_id, ':', 1)

6. Run this query for each of your affected customers replacing 'XXXX' with each customer's ID
7. Use the phpMyAdmin print view function to print the results for each customer.
With any luck when you add up the total cost of the items in each basket you should arrive at the total cost of the customer's transaction in WorldPay.

Limitations:

1. Won't be accurate if the customer has revisited the site since placing the 'lost' order and added or deleted items in their cart.
2. Doesn't provide any attribute information for products in the cart so if you have colour, size etc options on any of the products you will need to do a bit more delving within the database.

Once you have done the above you will have enough information to contact each customer by telephone, email or post to confirm their order details, delivery address etc and subsequently fulfil their order.

Every ########-up is an opportunity to sell so you might want to send each customer affected a discount voucher for use with their next order. The chances are they won't have noticed a problem before you contact them. By the time you contact them you have a solution and you only want to double check their order details, and hey they get a discount off their next order for their trouble. If that doesn't impress them - who needs them anyway!

Hope the above helps.

Alan

[marcps]

Great solution - but i found a slightly better one.......

I have produced a custom statement in worldpay control panel - which lists all authorised amounts and transaction ID's

I then installed master password module.

I then activated pay by cheque.

I then logged in as each customer - placed the order again (which means the order is in zen and customer gets confirmation) and then deleted the cheque module.

not ideal - but as soon as worldpay updates DNS the problem will be solved.

It seems they cache dns data for 24 hours - shame it wasn't 3 hours!

Right - back to manually checking.

THANKS AGAIN FOR YOUR HELP AND ADVICE.

[duncanad]

Marc,

Master Password Module!

Sounds just what I need for something completely different.

Yours seems a much better solution than mine.

Glad you have developed a good recovery strategy.

Hope your DNS problem resolves soon.

Regards,

Alan

[duncanad]

Sarah,

Relatively simple solution - just one line of code.

In includes/modules/payment/worldpay.php at around line 123 find this section of code:

      $process_button_string = 
      zen_draw_hidden_field('instId', MODULE_PAYMENT_WORLDPAY_ID) .

Add a new line immediately below this as follows:

zen_draw_hidden_field('accId1', 'x') .

Replace the 'x' with the appropriate account number.

That's it!

I haven't tested this so test it out first yourself before using live. Please report back here whether it works or not.

Regards,

Alan

[swalka]

Many thanks for that - i'll try it today and let you know how it goes.

Sarah

[swalka]

First signs are good. test transactions completed.

Client will run a live transaction through and hopefully the funds will be placed in the correct account.

I'll let you know the outcome.

Thanks so much for your help - its really appreciated!

[Tropheus]

Hi,

I have installed this module and it all works fine, the module is set to live. I have noticed on the customer confirmation page a line that says:

This is a TEST TRANSACTION. No money has changed hands.

But the site is live and the transaction has gone through?

[aeisecurity]

Sarah,

Relatively simple solution - just one line of code.

In includes/modules/payment/worldpay.php at around line 123 find this section of code:

      $process_button_string = 
      zen_draw_hidden_field('instId', MODULE_PAYMENT_WORLDPAY_ID) .

Add a new line immediately below this as follows:

zen_draw_hidden_field('accId1', 'x') .

Replace the 'x' with the appropriate account number.

That's it!

I haven't tested this so test it out first yourself before using live. Please report back here whether it works or not.

Regards,

Alan

Hello, i have this problem and this did not solve it, do you have another suggestion?