Future store updates planned (backend)
Re: Future store updates planned (backend)
I am no expert, but the point of the EU (or any trade agreement really) is not to pay customs when selling to another member country. The 20% VAT is a UK tax, as the 19% here is a german tax. For you Sweden is cheaper, but the receipient would have to pay customs and the swedish VAT (for goods and postage), so for him it is most likely more expensive.
Ingo
| Atari 1040STE@32MHz | Amiga 1200 (ACA1220) | Atari 800XL (U1MB, SIDE2) | Atari 130XL (Sophia DVI) | C64 (1541 Ultimate II, Rev3 RFMod Replacement) | TI 99/4A (F18A, 32k, FlashROM 99) | Sinclair ZX Spectrum 128 (Stereo, DivMMC) | Amstrad CPC664 (512k, M4 Wifi) | ... |
| Atari 1040STE@32MHz | Amiga 1200 (ACA1220) | Atari 800XL (U1MB, SIDE2) | Atari 130XL (Sophia DVI) | C64 (1541 Ultimate II, Rev3 RFMod Replacement) | TI 99/4A (F18A, 32k, FlashROM 99) | Sinclair ZX Spectrum 128 (Stereo, DivMMC) | Amstrad CPC664 (512k, M4 Wifi) | ... |
Re: Future store updates planned (backend)
I have finally got all the postage prices in a database for all parts of the world. I'm going to revamp how the calculation is done on the site. Currently it displays the postage at the top of the page, but it defaults to "USA" so displays USA post. Then no end of people moan because of expensive postage (because USA is selected) or moan its got the wrong location up ( because USA is selected) . I know a automatic location could be done, but I decided against it when I first put my store online.
So there will be a "GET PRICES" button for postage, which will only enable when people select the country. Then it will calculate the postage based on weight rather than a flat rate postage cost as it is now.
As mentioned before, there is a 2KG limit for overseas, so the store will basically refuse to process orders heavier than 2KG. You will have to put in 2 separate orders. This isn't a limitation, its to save people paying huge parcelforce prices. Shipping 2 packages of 1KG each is a lot cheaper than sending a single 2KG package. People may well moan about this system, but its there to save you money!
As the country list is large, I will put in a sort option. Such as A-Z, by zone or popular. The popular setting will put for example France or Germany at the top depending how many orders have gone to them. Place we never ship to, will be at the bottom of the list. Though this sort system is only going to likely start working after about 6 month worth of orders, as the "count" for all counties is starting from zero. The "by zone" will list EU countries first, then zone 1 locations (USA Canada etc) , and zone 2 is rest of the world which nobody cares about.
So there will be a "GET PRICES" button for postage, which will only enable when people select the country. Then it will calculate the postage based on weight rather than a flat rate postage cost as it is now.
As mentioned before, there is a 2KG limit for overseas, so the store will basically refuse to process orders heavier than 2KG. You will have to put in 2 separate orders. This isn't a limitation, its to save people paying huge parcelforce prices. Shipping 2 packages of 1KG each is a lot cheaper than sending a single 2KG package. People may well moan about this system, but its there to save you money!
As the country list is large, I will put in a sort option. Such as A-Z, by zone or popular. The popular setting will put for example France or Germany at the top depending how many orders have gone to them. Place we never ship to, will be at the bottom of the list. Though this sort system is only going to likely start working after about 6 month worth of orders, as the "count" for all counties is starting from zero. The "by zone" will list EU countries first, then zone 1 locations (USA Canada etc) , and zone 2 is rest of the world which nobody cares about.
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
Re: Future store updates planned (backend)
Massive stock check now done which took 2 days. It worked out well really as there was a few items where there was a lot more stock than listed in the store. So now all quantities should be correct.
All items have being weighed as well. All that information is now in the database. I have done the bulk of the new postage calculator script and need to test it out next.
I think in a few more days the "front end" will be all finished. So I hope sage get back to be soon as I'm getting close to needing to start programming the payment back end..
All items have being weighed as well. All that information is now in the database. I have done the bulk of the new postage calculator script and need to test it out next.
I think in a few more days the "front end" will be all finished. So I hope sage get back to be soon as I'm getting close to needing to start programming the payment back end..
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
Re: Future store updates planned (backend)
Been doing a lot of optimising today. I didn't like how I program some stuff earlier, so I have rewrote chunks again.
I did a analysis from my old store to my new store...
So I have managed to get the code down a little bit least.
One annoying thing I have just fixed, is when you change quantity in the basket, the page would refresh after each change. It no longer does that, and only refreshes the page when you delete a item out of the basket.
I have also noticed with Sage, That there seems to be a lot more hoops to jump through, like displaying privacy policy and return policy pages etc while I have already started working on the pages, There will be all the "review" aspects and related waiting etc. I can see me not even having my Sage account setup for some days, then I have to jump hoops, figure out how to program it all in.. I just cannot realistically see this all been finished by the 14th next month..
So I am actually sidestepping and looking into integrating my store with the "payacard" system. Then at least after the 14th next month, I should still be able to accept some credit card payments through this system as it has already been set up a couple of years ago...
I did a analysis from my old store to my new store...
So I have managed to get the code down a little bit least.
One annoying thing I have just fixed, is when you change quantity in the basket, the page would refresh after each change. It no longer does that, and only refreshes the page when you delete a item out of the basket.
I have also noticed with Sage, That there seems to be a lot more hoops to jump through, like displaying privacy policy and return policy pages etc while I have already started working on the pages, There will be all the "review" aspects and related waiting etc. I can see me not even having my Sage account setup for some days, then I have to jump hoops, figure out how to program it all in.. I just cannot realistically see this all been finished by the 14th next month..
So I am actually sidestepping and looking into integrating my store with the "payacard" system. Then at least after the 14th next month, I should still be able to accept some credit card payments through this system as it has already been set up a couple of years ago...
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
Re: Future store updates planned (backend)
I saw this which was interesting...
So basically a merchant change is legal, as long as its not based on what card type is used (debit or credit).
I guess I could just list the 1.5% store charge separately rather than dumping it onto the postage, but probably no point really as bottom line total will be the same anyway.
So basically a merchant change is legal, as long as its not based on what card type is used (debit or credit).
I guess I could just list the 1.5% store charge separately rather than dumping it onto the postage, but probably no point really as bottom line total will be the same anyway.
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
Re: Future store updates planned (backend)
I have been playing around with the paya system, but it looks like the sandbox mode doesn't work right I should be able to out even charge amounts to simulate a pass, and odd amount for fail, but it just keeps failing either way. Oddly putting valid card numbers in causes the sandbox to bounce back to the wrong URL not only that, I don't see a easy way to pass info to their system from a php script. The charge amount comes from the client side which is a no no, so I have given up with that system.
My sage account still isn't setup,BUT, I found they have a test account and a sandbox mode so I have been working through that and have worked out how to complete a card payment. The problem is, their code examples sux and I see lots of people on forums saying similar its like they give you the code , but don't tell you have to link all the bits together.
Currently I am a bit stuck with the 3D with stuff. They say it should run in a iframe so the user doesnt navigate away from the page, fair enough, but then the response comes back to the iframe , which isn't running exactly in the main store code. It would end up with payment completed in the iframe and the basket page left stuck on checkout.
Alternatively, it would just be easier to redirect the store page to the bank page, then return back to my store on a new page. Problem being with so much authentication going on, I had to store data in a session as I basically have to reloaded the page 3 times. BUT, the session seems to get trashed once the page navigates to the bank site, at least going by a quick test I did this morning.
Because sage don't give any clues how it's supposed to actually work, i am a bit stuck. The way which would work, would be to store all the data along with the order info. A order id number gets passed each step, so I should be able to store the data and just read from the server rather than sessions.
There wouldn't be any credit card info in all this, and any data would become invalid after a couple of mins tops anyway. Order pass or failures would invalid the data instantly anyway. It just seems a bit of a overkill to store in the SQL database.
I did wonder about trying to use client cookies for the data. There be no harm in it. But if the client PC is slow to respond each step of the way, then the payment session could time out. So its better just to keep it all running server side, let's hops with the data .
So will keep hunting to see if I can come up with a more elegent solution to all this.
My sage account still isn't setup,BUT, I found they have a test account and a sandbox mode so I have been working through that and have worked out how to complete a card payment. The problem is, their code examples sux and I see lots of people on forums saying similar its like they give you the code , but don't tell you have to link all the bits together.
Currently I am a bit stuck with the 3D with stuff. They say it should run in a iframe so the user doesnt navigate away from the page, fair enough, but then the response comes back to the iframe , which isn't running exactly in the main store code. It would end up with payment completed in the iframe and the basket page left stuck on checkout.
Alternatively, it would just be easier to redirect the store page to the bank page, then return back to my store on a new page. Problem being with so much authentication going on, I had to store data in a session as I basically have to reloaded the page 3 times. BUT, the session seems to get trashed once the page navigates to the bank site, at least going by a quick test I did this morning.
Because sage don't give any clues how it's supposed to actually work, i am a bit stuck. The way which would work, would be to store all the data along with the order info. A order id number gets passed each step, so I should be able to store the data and just read from the server rather than sessions.
There wouldn't be any credit card info in all this, and any data would become invalid after a couple of mins tops anyway. Order pass or failures would invalid the data instantly anyway. It just seems a bit of a overkill to store in the SQL database.
I did wonder about trying to use client cookies for the data. There be no harm in it. But if the client PC is slow to respond each step of the way, then the payment session could time out. So its better just to keep it all running server side, let's hops with the data .
So will keep hunting to see if I can come up with a more elegent solution to all this.
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
Re: Future store updates planned (backend)
Made some progress. I managed to dump the 3D-secure box in a frame and it loads..
Then I get back a verification number, which I send back to Sage.. but I just get this back...
So am stuck again Can't help but feel these payment systems are way more complicated than they need to be
Then I get back a verification number, which I send back to Sage.. but I just get this back...
The transaction ID is what sage send right from the start, and I have debugged the number to the screen every step of the way, but Sage reports its not found.. and they are the ones sending me the number{"description":"Transaction not found","code":1012}
So am stuck again Can't help but feel these payment systems are way more complicated than they need to be
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
Re: Future store updates planned (backend)
Have emailed Sage to see if I can get help..
They mostly seem to want to farm stuff out to stackoverflow.com . That site is impossible to post anything on
I'm not fighting with with this stuff. So will see if sage actually help. If I can't get a resolution to this problem, it looks like I will be looking for another payment processor again
They mostly seem to want to farm stuff out to stackoverflow.com . That site is impossible to post anything on
I'm not fighting with with this stuff. So will see if sage actually help. If I can't get a resolution to this problem, it looks like I will be looking for another payment processor again
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
Re: Future store updates planned (backend)
Stackoverflow is pretty picky about Titles, to avoid filling the rolls with titles that don't sufficiently describe the nature of the issue.
If you include some text about "Transaction not found errors after verification number issued" or somesuch, it'll post.
Re: Future store updates planned (backend)
ah ok thanks. May give it a try again if I get no where.derkom wrote: ↑Wed Aug 28, 2019 11:14 am Stackoverflow is pretty picky about Titles, to avoid filling the rolls with titles that don't sufficiently describe the nature of the issue.
If you include some text about "Transaction not found errors after verification number issued" or somesuch, it'll post.
https://www.exxosforum.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.
https://www.exxosforum.co.uk/atari/store2/ - All my hardware mods for sale - Please help support by making a purchase.
viewtopic.php?f=17&t=1585 Have you done the Mandatory Fixes ?
Just because a lot of people agree on something, doesn't make it a fact. ~exxos ~
People should find solutions to problems, not find problems with solutions.