|
JBeardon
|
Posted Thu 16 Aug 2012
|
|
Group: Awaiting Activation
Last Active: Thu 13 Dec 2012
Posts: 9,
Visits: 18
|
Hi GuysWe have a site using SagePay as the payment gateway and want to import sagepay transactions into Sage Line 50. So that we can us Sage for stock control, we need to have stock codes (ie version codes) present in the order information that is passed to SagePay. At the moment it would appear that none of these codes are being passed to the payment gateway. Sage have advised that they need to be in square brackets at the front of the product line when passed over to Sagepay. Can you advise if this is in-built functionality. If so, what do I need to do to enable it or if not, is there any way of getting the codes over to Sagepay. |
|
|
|
|
Neil
|
Posted Thu 16 Aug 2012
|
|
Group: Forum Members
Last Active: Sat 3 Nov 2018
Posts: 192,
Visits: 5,220
|
Not sure about the details passed to Sagepay, but we do a similar thing for accountancy purposes by just running a query against the invoice rows table in the database.
If you do a select on the invoice rows table you can see the order numbers and pull the version codes and other info (prices etc).
|
|
|
|
|
JBeardon
|
Posted Thu 16 Aug 2012
|
|
Group: Awaiting Activation
Last Active: Thu 13 Dec 2012
Posts: 9,
Visits: 18
|
Many thanks Neil.That may be of some use. Hopefully it will not be too much of a problem to use the direct SagePay imports as we have already gone to a great deal of effort getting that side to work. It would be a shame for it to be 'scuppered' by something so basic. If not, I will certainly look at your solution. |
|
|
|
|
JBeardon
|
Posted Wed 29 Aug 2012
|
|
Group: Awaiting Activation
Last Active: Thu 13 Dec 2012
Posts: 9,
Visits: 18
|
I was quite hoping for a response from the Kartris guys regarding this.
|
|
|
|
|
Paul
|
Posted Sat 1 Sep 2012
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
The sagepay plugin does format an order description, which is a text built up of the order contents, although this doesn't include the version code, only the version name and product name (or just one, if it is a single version type product, since these are the same).
I'll see if we can get this added into the plugin...
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
|
|
|
Medz
|
Posted Wed 5 Sep 2012
|
|
Group: Administrators
Last Active: Tue 3 Dec 2013
Posts: 99,
Visits: 1,400
|
Hi John, attached is an updated SagePay.dll that includes the Version CodeNumber in the product description field passed to SagePay. Can you let me know if this works for you? I've just appended the version codenumber inside square brackets at the beginning of the product description field. Its not mentioned anywhere in their documentation so I just did it based on whats written in your post.
[codenumber]productdescription
|
|
|
|
|
JBeardon
|
Posted Thu 6 Sep 2012
|
|
Group: Awaiting Activation
Last Active: Thu 13 Dec 2012
Posts: 9,
Visits: 18
|
Many thanks Medz. I will give it a go and report back.
|
|
|
|
|
JBeardon
|
Posted Thu 6 Sep 2012
|
|
Group: Awaiting Activation
Last Active: Thu 13 Dec 2012
Posts: 9,
Visits: 18
|
That worked Guys but we do have another problem :-(
When the shipping cost is being passed to SagePay, it appears on a line titled 'Shipping, discounts and other adjustments' - see attached screen shot.
This doesn't cause an issue apart from if the user wants to import transactions from SagePay into Sage Line 50. From what I can gather, Sage Line 50 is expecting to see the line title to be Delivery instead. The problem this causes is that when the import takes place, Sage actually sees the shipping value as a discount and takes it from the order total.
I am seeing if the accountant can work out if this is a Sage configuration issue but looking at page 22 of the SagePay/Sage integration guide, I don't think this is the case. This page also mentions the product code in square brackets so I've attached it for your reference.
Will report back regarding the Delivery charges/Sage import. |
|
|
|
|
Medz
|
Posted Fri 7 Sep 2012
|
|
Group: Administrators
Last Active: Tue 3 Dec 2013
Posts: 99,
Visits: 1,400
|
Ok. This one separates the shipping charges and puts it in a separate line as "Delivery". It then puts the remaining amount (if theres any) ->
order total - (total basket items value + shipping price) as "Discounts and other adjustments" line. Can you check if this one does it? |
|
|
|
|
JBeardon
|
Posted Tue 2 Oct 2012
|
|
Group: Awaiting Activation
Last Active: Thu 13 Dec 2012
Posts: 9,
Visits: 18
|
Sorry for the delay Medz.We should be testing this tomorrow so will get back to you with results. Many thanks for your help John
|
|
|
|