Not forwarding product code

Hi
The product code (the sku ID) is sent part of the shopping cart data, if you look at the additional information in sagepay for that order it will appear next to the title in square brackets. The billing phone number is sent to sagepay also.

Regards

Steve

Thanks for coming back to me. I’m using Sage 50 pro to download the data into sage, the sagePay support team says that the SKU isn’t being passed on.

We use a product called Connect to synch our stock, customers and orders. This works separately to sagepay. I’m happy to look into integrating it. Do you have anymore information?

Currently the Sagepay Direct plugin just generates a shopping basket and the details of the order.

Regards

Steve

Thanks again for your reply. This sounds interesting. Not at all happy with sagepay & sage sales people. they said this solution would work for our business, but information downloaded to sage bypasses the sales order module and shortfall function. We order from our supplier on demand, so we input the customer order by hand, the system knows we dont have stock, so then we highlight the sales orders, click on the shortfall button, and bam, we can automatically create the supplier order. we hoped by integrating sagepay we could download the customer orders as well.

looking at the integration documentation if should be a simple change. I will try and get the change out today.

i understand that you don’t stock items and you order when required.

Presumably your items appear in sage as products? I would hope that when your order is processed in Sage that came from SagePay your inventory count would decrease for the items ordered, then giving you the ability to run a short fall on your orders in Sage and allow you to place a purchase order with your supplier. Are you saying it doesn’t work like that?

Regards,

Steve

Sage & SagePay and telling me we need to use sales orders to use the shortfall function, where as the SagePay integration will only create invoices… So, fairly gutted after a long wait and quite a lot of funds, to find out this is the case. Depending on price, I’d be interested in other forms of integration that would make this possible.

I understand what you mean now – how stupid that they don’t offer the option to import as sales orders as well as invoices.

The fact they support stock reconciliation, would imply you may be able to a ‘shortfall’ on ‘products’ rather than ‘sales orders’ to get your re-order quantities.

I’ve used a product called Connect for Sage (now called Zynk) quite old now but it integrates with your ecommerce software rather than the payment gateway, I don’t know if anyone has written a plugin for woocommerce.

thanks for the heads up on that, just spoke with Zynk. Not sure if we can afford it at present, but good to know there’s a solution.

This maybe irrelevant for you now, but I’ll make it available to others – in file ‘ds-sagepay-direct.php’ line 638 (version 0.1.7.3)

modify this:-
$desc = $item['name'] . ' [' . $sku . ']';

and change to:-
$desc = '[' . $sku . '] ' . $item['name'];

Sage will now be able to interoperate the product code.

Regarding your other issues Sage’s SData maybe an option, I’d imagine there will be more utilities out there supporting your integration needs – I will be looking at it for my own requirements.

good luck

Steve

Thanks a lot for your attention to this. Much appreciated.

Jasper