Noodleman

Acces.... *shudder*... the error I am guessing you are getting will relate to MySQL strict mode. you can disable it if needed

No issue changing, BUT! be aware of this: https://github.com/cubecart/v6/issues/2144

It will need changes to the connector logic, it currently doesn't support matrix options.... but it can

at it's core it's just basic networking. Think of it like dial-up. you dial into your network. your device makes a call to the end point (VPN server) which answers, authenticates you etc. Once connected it builds a "secure tunnel", between it and your device. All traffic between you and the end point goes over that secure tunnel. You'll want different IP ranges / subnets on the two networks otherwise it won't route properly.

How did you set it up on your LAN? If your server is the endpoint, it should already have the route in it's table. remove PIA from this mix, it's not required as that's more for personal privacy rather than S2S

just add a route

PIA is a privacy network, meaning it's masking your endpoint to the internet. if you want a "site to site" VPN, then you'll want an endpoint in your own network. Settiing up a VPN is quite easy in PfSense. https://www.sparklabs.com/support/kb/article/setting-up-an-openvpn-server-with-pfsense-and-viscosity/ Any VPN client shold work assuming it supports your server config. "open VPN" covers most stuff.

it is, I use their app on my phone, My home firewall uses it and I set it up via a kill switch, IE if VPN is down, don't go online. Sometimes their endpoints can be a little flaky, but better than most. It may be overkill for what you need, but it's doable. I'm super paranoid and like my tin foil hat and take my network privacy seriously. I've even got ad blocking setup at the network level. You will find some services will block you, for example some banks block the PIA network block because it allows anonymity, meaning some people who want to malicious can use the service. So, most online banking places block PIA etc. If you can live with that, or put in a work around then you'll all good. PfSense + PIA works well, especially when tweaked for your own needs It depends what your actual requirements are. PfSense server in your home LAN, sat behind your router with some funky natting should do what you want. can run it on low end hardware if it's just for you.

PIA, but not open source, but if you have a VPS just setup a proxy using Squid. I do this to get a static IP for some services

Afternoon, This will do what you want: https://www.cubecart.com/extensions/plugins/discount-price-tiers-plugin

I'm assuming your editing the orders and changing the status as part of order completion, is it really such a chore to add the shipping info at the same time? Out of the box, no.. not that I am aware of. but shouldn't be too big a thing to put together for you if you wanted. For one of my customers we took this further and they books couriers directly from a new tab in the order itself so it does all the updates for them. depends how far you want to go to solve a minor inconvenience?

Sure, it's just a CSS trick. on hover, add a border to the bottom of the item. See: https://www.w3schools.com/cssref/sel_hover.asp and https://www.w3schools.com/css/css_border.asp

check the error logs, if it's a failing SQL query I think CubeCart will log the failed query in your version. Note, you'll want to consider upgrading sooner rather than later, the version you are on has some major security vulnerabilities

this will be because the word "CASE" is a command in an SQL query, so the SQL server may be picking up on this word. however, I can't seem to replicate the issue on my test stores. Try updating to the latest version, I can't replicate it there. seems fixed and probably a former bug

it's fine for me. try clearing your browser cache, it's probably got the old .htaccess file rules cached. I run into this from time to time with Chrome, and it's ##### annoying.