Track Shopify order payment terms in a spreadsheet

Mixtable can show Shopify payment terms beside each order. This makes it easier to review due dates, find overdue orders, and export a payment-term schedule for your finance or operations team.

Payment-term fields are read-only in Mixtable. They describe the terms stored on the Shopify order but do not set payment terms, record a payment, or change an order’s financial status.

Available payment-term fields

• Payment Due Date is the earliest due date in the order’s payment schedule and is blank when the order has no payment terms
• Payment Terms Due In Days is the length of the payment terms, such as 30 days, rather than a countdown from today
• Payment Terms Overdue shows whether any payment schedule on the order is overdue
• Payment Terms Name shows the name of the payment-term template used on the order
• Payment Terms Type shows the Shopify term type, such as NET, FIXED, FULFILLMENT, or RECEIPT

Include payment terms when creating an Orders worksheet

1. Open a spreadsheet in Mixtable and click the + button beside the worksheet tabs
2. Select Shopify data worksheet, then click Continue
3. Select Orders (no line items)
4. On Choose your columns, select the payment-term fields you want to include
5. Click Continue and choose the date range or condition for the orders you want to load
6. Click Create Worksheet

Shopify stores can have a large order history, so start with a practical date range. You can load older orders later when needed.

Add payment terms to an existing Orders worksheet

1. Open an Orders (no line items) worksheet
2. To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the button in the column header to open the selection window to choose the data you want to pull in.
3. Select Shopify data fields
4. Choose one of the payment-term fields and click Save Column
5. Repeat for each additional payment-term field you want to see

Mixtable fills the mapped columns from the Shopify orders already loaded in the worksheet.

Useful ways to work with payment terms

• Filter Payment Terms Overdue to true to focus on overdue orders
• Sort Payment Due Date from oldest to newest to prioritize follow-up
• Group or filter by Payment Terms Name to compare orders using different terms
• Export the worksheet to Excel or CSV for reconciliation or collections work
• Keep Financial Status visible beside the payment-term fields for additional context
• Once a customer settles up, mark those orders as paid in bulk

Troubleshooting

Why are the payment-term cells blank?

Orders without Shopify payment terms have blank payment-term fields. A normal card order that was paid at checkout usually does not have a later payment due date. Payment terms appear most often on B2B and wholesale orders, so you are most likely to see them alongside your B2B companies.

Does Payment Terms Due In Days show how many days remain?

No. It shows the original duration of the terms. Use Payment Due Date to see the actual deadline and Payment Terms Overdue to identify overdue schedules.

Can I change the due date from Mixtable?

No. Payment-term fields are read-only. Make payment-term changes on the order in Shopify.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.