How to Export and Import Shopify Orders with Excel: Filters, Line Items & More

Описание: How to Export and Import Shopify Orders with Excel: Filters, Line Items & More

Shopify orders hold a lot of data, so one order becomes several rows in a spreadsheet. In this video you'll export orders from Shopify with Altera, read the multi-row layout, bulk update orders from Excel, and create a new order from a spreadsheet.

What's covered:
Exporting orders with the Transactions and Fulfillments field groups
Filtering by Processed At (when the order was placed) instead of Created At, plus payment and fulfillment status
Reading the file: Top Row, and the Line: Type column for Line Item, Shipping Line, and Transaction rows
Adding a tag to many orders with a minimal file: identifier, Command = UPDATE, Tags, and Tags Command = MERGE
Creating a new order with Command = NEW: customer, line items, a shipping line, and a sale transaction
Checking the imported order in the Shopify admin

The file format is compatible with Matrixify, so existing order files carry straight over.

Note: order imports never email your customers unless you set the Send Receipt column to TRUE.

⏱️ Chapters
0:00 Intro
0:16 Creating the order export
0:30 Filters: Processed At, payment and fulfillment status
1:03 Reading the file: Top Row and Line: Type
1:36 Bulk adding a tag to orders
2:09 Creating a new order from a spreadsheet
2:37 Order templates and wrap up

📄 Order templates:
Basic orders: https://static.getaltera.com/sample_f...
Orders with discounts: https://static.getaltera.com/sample_f...
Mark orders as paid: https://static.getaltera.com/sample_f...
Add tracking numbers: https://static.getaltera.com/sample_f...
Cancel orders: https://static.getaltera.com/sample_f...

📚 Order fields reference: https://support.getaltera.com/en/arti...
📚 Bulk update tracking numbers: https://support.getaltera.com/en/arti...
📚 Add line items to existing orders: https://support.getaltera.com/en/arti...
📚 Schedule automated order exports: https://support.getaltera.com/en/arti...
🔗 Get Altera on the Shopify App Store: https://apps.shopify.com/altera-impor...

Questions? Our support team is available 24/7 in the app.