Future store updates planned (backend)

Latest Atari related news.
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 Sep 03, 2019 3:26 pm

The new checkout (still WIP ) is almost the same as the old one. Though billing has to go in as well. This is because billing has to be the address of the card holder (I may re-word it to card holder address)

I plonked on a copy button to copy shipping address over which may help save some typing.

co.jpg
co.jpg (145.1 KiB) Viewed 210 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 » Tue Sep 03, 2019 9:17 pm

god dang it...

:lol:

huh.jpg
huh.jpg (19.43 KiB) Viewed 195 times

Sage also has a option to pass the basket contents.. but Sage dies when I do that :roll: So ask them about it.. and reports the formatting issue in the order emails it sends out :lol:
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 » Tue Sep 03, 2019 9:21 pm

exxos wrote:
Tue Sep 03, 2019 9:17 pm
Sage also has a option to pass the basket contents.
What is the advantage of doing this?

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 Sep 03, 2019 9:24 pm

derkom wrote:
Tue Sep 03, 2019 9:21 pm
exxos wrote:
Tue Sep 03, 2019 9:17 pm
Sage also has a option to pass the basket contents.
What is the advantage of doing this?
Order history mostly on my sage account I think. Nothing really important.
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 Sep 04, 2019 10:05 am

Just got this from Stripe...
Hello,
Thank you for completing the SCA questionnaire. We wanted to remind you about required changes to your Stripe integration. We estimate that 75% of your yearly payments volume could be impacted by new Strong Customer Authentication (SCA) requirements being introduced for European payments.

Although we anticipate a gradual enforcement of these requirements, we expect the first banks to start declining payments that aren’t SCA ready on 14 September. As a result, we still recommend updating your integration before then to help avoid increases in declined payments. Our SCA-ready solutions will only start applying authentication when it’s required by the cardholder’s bank—taking into account each country’s enforcement timeline to minimise friction.

Visit the Dashboard to see your SCA recommendations based on your answers to our questionnaire and start updating your integration.
Only I didn't complete any questionnaires.....
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 Sep 05, 2019 7:31 pm

Still programming stuff. Sage only accepts 2 letter codes for countries, so had to add all 209 country letters to the database :roll:

Currently I am coding the script which converts all the store items to order, address data etc into a format SAGE needs. This all ends up encrypted as well.

What's taking time with this script is the amount of error checking I am adding into it all :roll: This came about as I changed how ordered items propagate through the system ,so I couldn't use chunks from my old store :( Its not helping as I can't type much or fast anymore either :(

Hopefully I will get this script done by the weekend. Then I can start on the order processing scripts next week. I *hope* I can re-use large chunks of code from my old store. I am also tidying up routines as well which is taking a fair bit of time.
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 Sep 06, 2019 10:55 pm

Made a lot of progress today. I've made the first test transaction though the store just. Still a lot of programming to do yet though.

I had to dump the order onto the server before payment as I can only send transaction codes easily via Sage. So was just easier to store everything on the server and just mark it as paid or not later. Which involved a lot of database updates and changes :roll: As the checkout script was looping through all the info, it generates order emails as it going along.. which I had to store also because I cannot send them until the order is actually paid before. I could generate the emails after payment, but I would just end up creating the same code twice pretty much.. It's only ordered items being stored anyway. Just seems a little wasteful in SQL space. I guess I could just clear the data after payment anyway... much to think about yet...

exxos's brain is burnt out now.... :stars:
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 Sep 09, 2019 10:30 am

I have decided for the time being, to remove the "place order on out of stock items" option from the checkout.

I am not even sure if anyone actually use that option or not anyway. But the problem I see with it, is if the main item someone wanted to order was a power supply for example, and it went out of stock a few seconds before they placed their order, and they had that option ticked, the order would still go ahead and could potentially be rather annoying for the customer, even though that is what they decided to do.

The default option was to abort orders anyway, and it will simply report that some items are out of stock, and the order will not go ahead. The customer simply has to go back to the basket and go from there.

I also just realised, that because card details were entered before checkout on my current store, the stock quantities would be altered very quickly after payment was successful. However, with the Sage system, there could be some delay while users completes the card payments. Because of this, technically, the stock quantities should be altered as quickly as possible which is right at the start of the sage payment screen. However, if the payment fails, that "purchased stock" would have to be returned to the main stock list. This way items are "reserved" in your basket until payment. This is basically how shopping works in any high street store etc

BUT.. It is technically possible for Sage to come up a error screen without being returned to my store. On such errors the reserved contents would not be returned back to the main stock list. On that basis, I should only deduct stock quantities after a successful payment.

BUT.. This opens up the door to the situation where if several people just happens to order the same item within about five minutes of each other, The transaction would complete and the quantities in my store could actually end up a negative value. In which case two orders I would not be able to fulfil because items were actually out of stock.

Technically at this point, such items would be automatically placed on back order (with other shops such as farnell etc) . But I really do not want to go down backorder routes because I may or may not produce that item again, and it could be several weeks or months before that item would be back in stock again. I really do not want to go down that road again with all the "nagging emails" that go along with it.

The easiest thing to do & program overall, is to only deduct stock quantities after successful payment. The chances of two people ordering the same item at the same time as it going out of stock, is pretty slim, but I really do not want to build in "potential bugs" into the store :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 » Mon Sep 09, 2019 11:54 am

I have just noticed a potential bug which I have just fixed..


For this item, there is 8 items in the basket, but only 3 in stock. There was no warning of this situation before and no automatic correction.
Capture.JPG
Capture.JPG (84.71 KiB) Viewed 90 times

So now when the basket is loaded, this is now checked and informs you that you have added more items in your basket than is currently in stock.
c2.JPG
c2.JPG (83.66 KiB) Viewed 90 times

This situation would only really occur, if you had for example, 8 items in your basket, when there was 8 or more in stock at the time you put them in your basket. Then if you waited a few days, the stock level could actually drop, and the contents of your basket would actually be invalid.

I think this "issue" would have been trapped on the server side scripts anyway, but now it is trapped on the user side as well.
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 Sep 09, 2019 12:51 pm

:lolbig:

Capture.JPG
Capture.JPG (20.9 KiB) Viewed 84 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.

Post Reply