Shopify Discount Code Retirement Automation

via Freelancer ·

Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted2 hours ago
I maintain a Microsoft Access interface tied to an Azure SQL database where we manage thousands of Shopify discount codes. Right now, retiring codes is a slow, error-prone, manual task. I’d like you to build a Python-driven automation that is triggered directly from a button or menu item inside the Access front-end.

Here’s the workflow I need: I will enter or paste the exact codes to be retired into an Access table. When I choose “Retire Codes”, the Python service should pick up that list, call the Shopify Admin API, and deactivate each code. For every call, the system must:

• flip a “Retired” flag in the same Access table,
• store the retirement timestamp and success / failure result, and
• save the full JSON response (or any error message) so we have an audit trail.

All data writes should occur in Azure SQL; Access will simply display what’s in the database. The first version only needs to run on demand from Access, but please design it so a scheduled run could be added later without re-architecting everything.

Key expectations
• Clean, well-commented Python (preferably using requests, but I’m open).
• Secure handling of Shopify API keys and Azure connection strings.
• Clear installation steps so I can deploy this on our Windows Server with Office 365 and an existing ODBC link to Azure SQL.
• A short walkthrough or screen-share at hand-off so I understand how to extend or troubleshoot the process.

If you have tackled similar Shopify API tasks or built Access-Python bridges before, let me know—sample code or a quick summary of your approach will help me choose faster.
python software architecture microsoft access amazon web services database programming automation database management api development
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.