Future store updates planned (backend)

Latest Atari related news.
User avatar
IngoQ
Site Admin
Site Admin
Posts: 817
Joined: Tue Aug 22, 2017 8:38 am
Location: Germany

Re: Future store updates planned (backend)

Post by IngoQ » Thu Aug 15, 2019 8:33 pm

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 :geek:

| 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) | ... |

User avatar
exxos
Site Admin
Site Admin
Posts: 7639
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Future store updates planned (backend)

Post by exxos » Sun Aug 18, 2019 10:27 am

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.
4MB STFM 1.44 FD- VELOCE+ 020 STE - 4MB STE 32MHz - STFM 16MHz - STM - MEGA ST - Falcon 030 CT60 - Atari 2600 - Atari 7800 - Gigafile - SD Floppy Emulator - PeST - HxC - CosmosEx - Ultrasatan - various clutter

https://www.exxoshost.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxoshost.co.uk/atari/last/storenew/ - All my hardware mods for sale - Please help support by making a purchase.

User avatar
exxos
Site Admin
Site Admin
Posts: 7639
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Future store updates planned (backend)

Post by exxos » Mon Aug 19, 2019 11:29 pm

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..
4MB STFM 1.44 FD- VELOCE+ 020 STE - 4MB STE 32MHz - STFM 16MHz - STM - MEGA ST - Falcon 030 CT60 - Atari 2600 - Atari 7800 - Gigafile - SD Floppy Emulator - PeST - HxC - CosmosEx - Ultrasatan - various clutter

https://www.exxoshost.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxoshost.co.uk/atari/last/storenew/ - All my hardware mods for sale - Please help support by making a purchase.

User avatar
exxos
Site Admin
Site Admin
Posts: 7639
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Future store updates planned (backend)

Post by exxos » Thu Aug 22, 2019 6:10 pm

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...
old.jpg
old.jpg (14.58 KiB) Viewed 691 times
new.jpg
new.jpg (15.58 KiB) Viewed 691 times

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...
4MB STFM 1.44 FD- VELOCE+ 020 STE - 4MB STE 32MHz - STFM 16MHz - STM - MEGA ST - Falcon 030 CT60 - Atari 2600 - Atari 7800 - Gigafile - SD Floppy Emulator - PeST - HxC - CosmosEx - Ultrasatan - various clutter

https://www.exxoshost.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxoshost.co.uk/atari/last/storenew/ - All my hardware mods for sale - Please help support by making a purchase.

User avatar
exxos
Site Admin
Site Admin
Posts: 7639
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Future store updates planned (backend)

Post by exxos » Fri Aug 23, 2019 2:12 pm

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.

sc.png
sc.png (185.56 KiB) Viewed 674 times
4MB STFM 1.44 FD- VELOCE+ 020 STE - 4MB STE 32MHz - STFM 16MHz - STM - MEGA ST - Falcon 030 CT60 - Atari 2600 - Atari 7800 - Gigafile - SD Floppy Emulator - PeST - HxC - CosmosEx - Ultrasatan - various clutter

https://www.exxoshost.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxoshost.co.uk/atari/last/storenew/ - All my hardware mods for sale - Please help support by making a purchase.

User avatar
exxos
Site Admin
Site Admin
Posts: 7639
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Future store updates planned (backend)

Post by exxos » Sun Aug 25, 2019 12:38 am

I have been playing around with the paya system, but it looks like the sandbox mode doesn't work right :roll: 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 :roll: 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 :roll: 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.
4MB STFM 1.44 FD- VELOCE+ 020 STE - 4MB STE 32MHz - STFM 16MHz - STM - MEGA ST - Falcon 030 CT60 - Atari 2600 - Atari 7800 - Gigafile - SD Floppy Emulator - PeST - HxC - CosmosEx - Ultrasatan - various clutter

https://www.exxoshost.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxoshost.co.uk/atari/last/storenew/ - All my hardware mods for sale - Please help support by making a purchase.

User avatar
exxos
Site Admin
Site Admin
Posts: 7639
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Future store updates planned (backend)

Post by exxos » Tue Aug 27, 2019 6:41 pm

Made some progress. I managed to dump the 3D-secure box in a frame and it loads..

1.jpg
1.jpg (31.01 KiB) Viewed 609 times

Then I get back a verification number, which I send back to Sage.. but I just get this back...

{"description":"Transaction not found","code":1012}
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 :stars: :stars:

So am stuck again :( Can't help but feel these payment systems are way more complicated than they need to be :roll:
4MB STFM 1.44 FD- VELOCE+ 020 STE - 4MB STE 32MHz - STFM 16MHz - STM - MEGA ST - Falcon 030 CT60 - Atari 2600 - Atari 7800 - Gigafile - SD Floppy Emulator - PeST - HxC - CosmosEx - Ultrasatan - various clutter

https://www.exxoshost.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxoshost.co.uk/atari/last/storenew/ - All my hardware mods for sale - Please help support by making a purchase.

User avatar
exxos
Site Admin
Site Admin
Posts: 7639
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Future store updates planned (backend)

Post by exxos » Wed Aug 28, 2019 10:21 am

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 :roll:

Capture.JPG
Capture.JPG (13.07 KiB) Viewed 582 times
2.JPG
2.JPG (14.46 KiB) Viewed 582 times

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 :roll:
4MB STFM 1.44 FD- VELOCE+ 020 STE - 4MB STE 32MHz - STFM 16MHz - STM - MEGA ST - Falcon 030 CT60 - Atari 2600 - Atari 7800 - Gigafile - SD Floppy Emulator - PeST - HxC - CosmosEx - Ultrasatan - various clutter

https://www.exxoshost.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxoshost.co.uk/atari/last/storenew/ - All my hardware mods for sale - Please help support by making a purchase.

derkom
Posts: 63
Joined: Sun Jul 29, 2018 6:45 pm

Re: Future store updates planned (backend)

Post by derkom » Wed Aug 28, 2019 11:14 am

exxos wrote:
Wed Aug 28, 2019 10:21 am
They mostly seem to want to farm stuff out to stackoverflow.com . That site is impossible to post anything on :roll:
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.

User avatar
exxos
Site Admin
Site Admin
Posts: 7639
Joined: Wed Aug 16, 2017 11:19 pm
Location: UK
Contact:

Re: Future store updates planned (backend)

Post by exxos » Wed Aug 28, 2019 9:17 pm

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.
ah ok thanks. May give it a try again if I get no where.
4MB STFM 1.44 FD- VELOCE+ 020 STE - 4MB STE 32MHz - STFM 16MHz - STM - MEGA ST - Falcon 030 CT60 - Atari 2600 - Atari 7800 - Gigafile - SD Floppy Emulator - PeST - HxC - CosmosEx - Ultrasatan - various clutter

https://www.exxoshost.co.uk/atari/ All my hardware guides - mods - games - STOS
https://www.exxoshost.co.uk/atari/last/storenew/ - All my hardware mods for sale - Please help support by making a purchase.

Post Reply