bammichael

I wonder if at this point, just writing some kind of script on one of our Windows Server machines and having it “GET” from Knack and “PUT” into WordPress would be the most effective route. I’m not a seasoned webdev, so I don’t trust that I could properly cloak our application API data. I’d rather hide the process inside our company network on a protected machine, instead of on a WordPress machine that could become an attack target.

Is WooCommerce part of the WordPress SQL database? Where do you recommend I look for the documentation on putting/updating/deleting records in WooCommerce via API calls?

Also thanks a ton for the help, we don’t have an in-house software developer and I serve as the IT Admin for our business. We aren’t huge, so I imagine I’ll be a jack-of-all-trades by the end of the year haha.

We also want to go about this practically, especially since issues like “load times” can complicate things and discourage users from buying products.

The main reason we don’t want to go WooCommerce is simply this: we don’t want two databases of products. Unless there existed a mechanism to make WooCommerce always 100% sync up with Knack’s record data, it would never work out for us.

Knack has api keys, so the authorization would need those keys. There is an app key and a private key. I’m unsure how to hide the private key at this time, haven’t researched this extensively yet. Then again, we do other work in this database, so we cannot allow public access to everything.

Regardless, if Authorize.net won’t work without a solution like WooCommerce, that doesn’t really leave us an “other” option.

How difficult and practical (or unpractical) would it be to look into some kind of external server script to perform maybe 4-12 syncs a day, downloading data out of Knack and syncing it directly into the WooCommerce database? Maybe we run a small virtual server via one of our machines or a cloud solution like Amazon to perform this sync maintenance for us? It only needs to go one way, the only time we’d need to go the other way would be making sure a product is hidden on a sale (only one of each), we have triggers in our Knack database to determine this.

• This reply was modified 2 years, 10 months ago by bammichael.
• This reply was modified 2 years, 10 months ago by bammichael.
• This reply was modified 2 years, 10 months ago by bammichael.