Kristoff
-
Posts
86 -
Joined
-
Last visited
Posts posted by Kristoff
-
-
Still no error showing up. Transactions are showing up in the Transaction log:
Order Number Sort by Total descending Sort by Total ascendingTotal Sort by Gateway descending Sort by Gateway ascendingGateway Sort by Date descending Sort by Date ascendingDate 131031-*** £0.50 SagePay Today, 19:49 131031-*** £0.50 SagePay Today, 17:38 131031-*** £0.50 SagePay Today, 16:53
But when you go in to them it shows:
Transaction ID Status Amount Gateway Date/Time Notes Not Available £0.50 SagePay Today, 19:49
-
Yep, here is what I had before:
public function process() { trigger_error('From SagePay: QueryString: ' . print_r($_SERVER['QUERY_STRING'] , true)); $Decoded = $this->_decodeAndDecrypt($_REQUEST['crypt']);Will try that now. Cheers
-
Still no error
-
Yep, obviously an issue with unhiding the categories or something with the database?
-
No error is showing after doing another transaction.
-
In mysagepay when viewing the transaction details it is represented as:
https://www.fullurl.com/index.php?_g=rm&type=gateway&cmd=process&module=SagePay&cart_order_id=*ORDERNUMBER*A
After paying for an item I ended up back on the store with the order page saying "pending" here:
https://www.fullurl.com/index.php?cart_order_id=*ORDERNUMBER*&_a=complete
-
That and a clear of the cache has worked. Cheers!
-
Ok, it's still returning as Status "Not Available" in orders, and no transaction ID, however, this is the URL it returned me to:
*storeURL*/index.php?cart_order_id=1**0*1-1**2*4-9**6&_a=complete
??
Line 363 of gateway.class:
if($values['Status']=="OK"){ $order->orderStatus(Order::ORDER_PROCESS, $cart_order_id); $order->paymentStatus(Order::PAYMENT_SUCCESS, $cart_order_id); $transData['notes'] = $values['StatusDetail']; } else { $order->orderStatus(Order::ORDER_PENDING, $cart_order_id); $order->paymentStatus(Order::PAYMENT_PENDING, $cart_order_id); $transData['notes'] = $values['StatusDetail']; } $order->logTransaction($transData); httpredir(currentPage(array('_g', 'type', 'cmd', 'module'), array('_a' => 'complete'))); return false; } public function form() { return false; } }Mean anything?!
-
In the sagepay transactions area of MySagePay
Have just put another transaction through to confirm that in sagepay it does say the correct order number next to "To pay for:" there is no A following the number. I have asked one of my colleagues if they can get me the callback URL for a previously successful payment.
-
I'm no expert but i'm guessing you could maybe import them via phpMyAdmin in some way. Or in phpMyAdmin run a script such as "Insert into cubecart_categories ". There might be an easier way.
-
."&SuccessURL=".$GLOBALS['storeURL'].'/index.php?_g=rm&type=gateway&cmd=process&module=SagePay&cart_order_id='.$this->_basket['cart_order_id'] ."&FailureURL=".$GLOBALS['storeURL'].'/index.php?_g=rm&type=gateway&cmd=process&module=SagePay&cart_order_id='.$this->_basket['cart_order_id']
That's those lines. The thing that struck me as strange was the fact they were both the same. Does the A stand for authenticated or something? Added on by Sagepay?
-
Just a shot in the dark, try clearing the cache.
Have done, again, and again, and again
-
These are in the admin area:
Dashboard » Orders » 13**1-15***33-59**
Then on the transaction log page.
Callback URL in sagepay is:
**storeurl***/index.php?_g=rm&type=gateway&cmd=process&module=SagePay&cart_order_id=13**1-15***33-59**A
I note an additional A at the end of the URL there, could that be an issue? -
Ok think this may be the problem:
Status - Amount - Gateway - Date/Time
Not Available - £0.50 - SagePay - Today, 15:50
???
Anybody any idea why the status of the order is unavailable?!
Just to verify: are tangible orders going to Processing when paid through SagePay?
No, gone to pending also.
-
That works perfectly thanks my friend. The only issue i've got now (I think it may be a bug?) is that after hiding and unhiding the category called "Hidden" we now can't add any products to it? On Dashboard » Products » Item » Categories, it doesn't even show our category, yet the category is there and active in Categories...
-
Hi again guys, just ran in to a bit of an issue, with our old store (4.4.4) digital products were set as completed as soon as payment was made from sagepay, but now when we pay it's going to the order and the status is "Pending" has something changed? Or have I missed something I should change?
Thanks in advance!
-
Is there a way of me hiding a category ID from the navigation?
-
For what it's worth, is there a way of me hiding a category ID from the navigation?
-
It helps to add your setup info to your sig as well, for just such converstations as this. Also, any time you have a potentially skin related issue it's best to test your problem on a stock skin to see what happens.
Can you provide a link to your store and a product code for a hidden item?
Afraid not as the store is currently offline to public.
One would think a search would be filtered. Also, the Featured Product box will also show a product in a hidden category (CC512, heavily edited, so that may be just my case).
We're not using a featured product box, so we're ok there.
I found this in catalogue.class, but removing and changing the hide=0 (for all instances) hasn't resulted in any joy.
$query = sprintf("SELECT I.*, %2$s AS Relevance FROM %1$sCubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM %1$sCubeCart_pricing_group $group_id GROUP BY product_id) as G ON G.product_id = I.product_id $joinString WHERE I.product_id IN (SELECT product_id FROM `%1$sCubeCart_category_index` as CI INNER JOIN %1$sCubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (%2$s) >= %4$f %3$s %5$s %6$s", $GLOBALS['config']->get('config', 'dbprefix'), $match, $whereString, $match_val, $order_string, $limit); if (($search = $GLOBALS['db']->query($query)) !== false) { $q2 = sprintf("SELECT COUNT(I.product_id) as count, %2$s AS Relevance FROM %1$sCubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM %1$sCubeCart_pricing_group $group_id GROUP BY product_id) as G ON G.product_id = I.product_id $joinString WHERE I.product_id IN (SELECT product_id FROM `%1$sCubeCart_category_index` as CI INNER JOIN %1$sCubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (%2$s) >= %4$f %3$s GROUP BY I.product_id %5$s", $GLOBALS['config']->get('config', 'dbprefix'), $match, $whereString, $match_val, $order_string); -
I've just tried kurouto and still nothing showing up. I've just noticed I need to update my sig, we're now on 5.2.4
Hi Kristoff, I think you found a hidden undocumented and possibly unintentional feature of v4 (unless custom code was added to achieve this). I think other merchants want the behaviour in v5 to make sure that unpublished categories don't allow its inventory to be purchased.
I expect a tweak to the code is needed to get these products to load. Have a look at the catalog class which is most likely to be responsible for this.
Thanks for this Al, for me it makes no sense to show items in a search, but not to be able to link to them directly. Surely it makes more sense to have them hidden on a search whether or not the item is available to view?
-
A custom skin, can't even remember which we used as a base skin. I will take a look at kurouto and see if I can see anything as a give away. Cheers
-
That's what we get, but we actually want to be able to see the item. I will take a look in catalog class
-
We've just updated our store and on 4.4.4 (I think it was) we had a hidden category, but we could link directly to products for people to buy (think things like tickets that only certain clients are invited to.
The problem is though, since updating, when you view a product in a hidden file now, it is just a plain blank page. Anyone know how to sort it? It doesn't make much sense seeing as the items show up in search results, but then when you click them, it's just blank?!
Any help appreciated!
Many thanks
-
That worked perfectly thank you. I had a bit of a shuffle, as I don't use buy buttons on the homepage, but a More Info button, I added the code to the product page itself and as i'm not sure if there would be any issue with it, but I only needed to use the <input onclick="this.name='stay';submit();" value="Add & Remain" class="button_white" /> button, I found it added a load of extra space to the button for some reason, but the original <input type="submit" value="{$LANG.catalogue.buy}"> button works fine for going direct to the basket upon adding.
Many thanks again!
Automatically process digital products with sagepay?!
in Technical Help
Posted
Hi Al, have just tried changing it to AES and still no joy. Do I need to clear the cache?