Magento Order Export SQL

Замовник: AI | Опубліковано: 09.11.2025
Бюджет: 30 $

I need a clean, single-run SQL query that I can drop into phpMyAdmin to pull a basic order report from my Magento database. Required flexibility • Start order number – editable placeholder • End order number – editable placeholder • Order status – editable placeholder; the store mainly uses “On Hold”, “Processing”, or “Imported”, but the clause must accept any status I type in (I am aware of the correct names used in the Order Status table on our installation. Result set – one row per product line with these exact fields: 1. Order number 2. Customer name (first + last) 3. Product name 4. Product quantity 5. Order status If an order contains several products, the query must return several rows—one for each product/quantity combination. Deliverable • A well-commented SQL statement that runs on a standard Magento schema (no custom prefixes) • Clear inline notes showing where to adjust the three parameters I’ve attached a sample spreadsheet that shows the exact layout I expect. Please test the query on your own Magento database before handing it over and let me know if anything in my brief needs clarification. Budget is $20 - $25 don't bother bidding if you intend to over bid or "negotiate" you know exactly what is needed so if you cannot work for this budget don't bid please.