Shopify Data Transfer Automation Tool

We need a local Python app (desktop script with GUI, no hosting) that can export all data from a Shopify store to Excel, translate all relevant text fields into one target language using the OpenAI API, and then re-import the translated data into another Shopify store. The workflow must be safe, modular, and reviewable—translation and upload are always separate steps.

Scope of Work:
The tool should export to an Excel workbook with 17 sheets, one for each entity:

1. Shop
2. Files
3. Menus
4. Pages
5. Orders
6. Blog posts
7. Catalogs
8. Products
9. Companies
10. Discounts
11. Redirects
12. Meta objects
13. Smart collections
14. Manual collections
15. Metafield definitions
16. Metaobject definitions
17. Export summary

Core Requirements:

Export Module (Shopify → Excel)

* Pull all entities into separate Excel sheets (see list above).
* Ensure proper ID-based mapping (handles must remain untouched).
* Maintain relational linking across sheets (e.g., products ↔ collections).
* Support multi-page exports with correct references.
* Add export summary sheet for quick validation.

Translation Module (Excel → Excel)

* Translate only textual fields (titles, descriptions, option names, SEO text, alt text, blog/page content, etc.).
* Preserve Liquid variables, placeholders, product handles, and IDs exactly.
* One target language per run (select via GUI dropdown).
* Batch translations via OpenAI API (default: gpt-4.0-mini).
* Provide before/after columns for verification in Excel.

Import Module (Excel → Shopify)

* Validate Excel workbook before upload.
* Dry-run mode (no writes) with error log.
* Import using ID-based mapping to update/create records.
* Write back an import results sheet with created/updated IDs and statuses.

GUI (Lightweight Desktop)

* Tabs: Export, Translate, Import, Settings.
* Settings tab: upload Shopify credentials and OpenAI key, save locally.
* Dropdown for language selection.
* Progress bars, console log, and error reporting.
* Should run on Windows & macOS.

Tech Requirements:

* Python 3.10+
* Shopify Admin API (REST/GraphQL)
* OpenAI API (batch-friendly setup)
* Excel handling: pandas + openpyxl
* GUI: developer’s choice (PySimpleGUI/Tkinter/Qt)
* Robust error handling, retries, automatic rate limiting

Please let me know if you have any doubts or questions regarding this whole thing. We'd be more than happy to open a call if you need any clarification.