A per-tab list of every column SyncRange can export from Etsy, with a short description of what each one contains. Use this page when picking columns in the export builder, or when you need to know exactly what a value represents in BigQuery or Google Sheets.
Each tab below notes whether it uses the export date range or always exports a full current snapshot (date range does not apply).
For configuration steps see Configuring Etsy exports.
One row per shop listing. Full export each run: always current listing data; the date range does not apply.
| Column | Description |
|---|---|
| Listing ID | Etsy's numeric ID for the listing. |
| Title | Listing or item title. |
| Description | Full description text. |
| Price | Unit or listing price in the row currency. |
| Currency | ISO 4217 currency code (e.g. USD). |
| Quantity | Available or ordered quantity. |
| State | Listing state (e.g. active, draft, expired, sold_out). |
| URL | Public storefront URL for the listing. |
| Tags | Comma-separated listing tags. |
| Materials | Comma-separated materials listed on the item. |
| Shipping Profile ID | ID of the shipping profile applied to the listing. |
| Shop Section ID | ID of the shop section containing the listing. |
| Featured Rank | Featured ranking position in the shop (when set). |
| Is Customizable | Whether the listing accepts customization requests. |
| Is Personalizable | Whether personalization is offered on the listing. |
| Is Digital | Whether the item is a digital download. |
| Has Variations | Whether the listing has variations (size, color, etc.). |
| Auto Renew | Whether the listing is set to auto-renew. |
| Language | Listing language code. |
| Views | Lifetime of times the listing has been viewed. |
| Created Date | UTC date the listing was created (YYYY-MM-DD). |
| Created Date Time | UTC datetime the listing was created. |
| Last Modified Date | UTC date the listing was last modified (YYYY-MM-DD). |
| Last Modified Date Time | UTC datetime the listing was last modified. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
One row per order receipt. Date range: filtered by order created or updated datetime (UTC day bounds), depending on the order filter you select. Date columns are day-only; use the matching Date Time columns for full precision.
| Column | Description |
|---|---|
| Receipt ID | Etsy receipt (order) ID. |
| Order ID | Etsy order ID associated with the receipt. |
| Buyer User ID | Etsy user ID of the buyer. |
| Buyer Email | Buyer email address. Etsy returns this only when the app has been granted buyer_email access (commercial apps must request it separately; otherwise the field is null). |
| Buyer Name | Buyer or entity display name. |
| Message from Buyer | Message the buyer left on the order. |
| Status | Order or record status as reported by the platform. |
| Payment Method | How the order was paid. |
| Currency | ISO 4217 currency code (e.g. USD). |
| Subtotal | Order subtotal before shipping and tax. |
| Total Shipping Cost | Total shipping charged on the receipt. |
| Total Tax | Total tax charged on the receipt. |
| Total VAT | Total VAT charged on the receipt. |
| Discount Amount | Discount amount applied to the receipt. |
| Total Price | Grand total charged to the buyer. |
| Is Paid | Whether the receipt is marked paid (true / false). |
| Is Shipped | Whether the receipt is marked shipped (true / false). |
| Is Refunded | Whether the receipt has any refunds, or a refund-related status (true / false). Receipt Status may also show fully refunded or partially refunded. |
| Gift Message | Gift message on the order, if any. |
| Gift Wrap Price | Gift wrap charge, if any. |
| Ship To Name | Ship-to recipient name. |
| Ship Address Line 1 | Ship-to address line 1. |
| Ship Address Line 2 | Ship-to address line 2. |
| Ship City | Ship-to city. |
| Ship State | Ship-to state or region. |
| Ship ZIP | Ship-to postal code. |
| Ship Country | Ship-to country ISO code. |
| Order Date | UTC date the receipt was created (YYYY-MM-DD). |
| Order Date Time | UTC datetime the receipt was created. Order created/updated filters use this underlying timestamp. |
| Last Updated | UTC date the receipt was last updated (YYYY-MM-DD). |
| Last Updated Date Time | UTC datetime the receipt was last updated. Order updated filters use this underlying timestamp. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
One row per line item within an order. Date range: uses the same order created/updated filter as Receipts.
| Column | Description |
|---|---|
| Transaction ID | Etsy transaction (line item) ID. |
| Receipt ID | Etsy receipt (order) ID. |
| Listing ID | Etsy listing ID for the purchased item. |
| Title | Listing or item title. |
| Description | Full description text. |
| Quantity | Available or ordered quantity. |
| Price | Unit or listing price in the row currency. |
| Buyer Coupon | Buyer coupon discount amount applied to this line (shop currency). Use with Price × Quantity to get the discounted line subtotal. |
| Shop Coupon | Shop coupon discount amount applied to this line (shop currency). |
| Currency | ISO 4217 currency code (e.g. USD). |
| Seller User ID | Etsy user ID of the seller. |
| Buyer User ID | Etsy user ID of the buyer. |
| Is Digital | Whether the item is a digital download. |
| Transaction Date | UTC date the transaction was created (YYYY-MM-DD). |
| Transaction Date Time | UTC datetime the transaction was created. |
| Paid Date | UTC date the line item was paid (YYYY-MM-DD). |
| Paid Date Time | UTC datetime the line item was paid. |
| Shipped Date | UTC date the line item was marked shipped (YYYY-MM-DD). |
| Shipped Date Time | UTC datetime the line item was marked shipped. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
One row per Etsy Payments account ledger entry (sale credits, fees, refunds, disbursements, and other balance changes). Date range: filtered by ledger entry created datetime. Supports Since last export.
| Column | Description |
|---|---|
| Entry ID | Numeric ID for this ledger entry. |
| Ledger ID | Numeric ID of the shop payment account ledger. |
| Sequence Number | Chronological sequence within the ledger (higher is more recent). |
| Amount | Amount credited or debited on this entry (decimal, from Etsy minor units). |
| Currency | Currency of the ledger entry. |
| Description | Human-readable entry type (payment, refund, disbursement, bill payment, etc.). |
| Balance | Running shop payment-account balance after this entry. |
| Created Date | UTC date the ledger entry was created (YYYY-MM-DD). |
| Created Date Time | UTC datetime the ledger entry was created. |
| Ledger Type | Original reference type for the ledger entry. |
| Reference Type | Object type the entry refers to. |
| Reference ID | Object ID the entry refers to. |
| Parent Entry ID | Parent ledger entry ID used to match related entries (for example VAT to seller fees). Blank when Etsy sends 0 (no parent). Most fee and payment rows have no parent. |
| Payment Adjustments Count | Number of nested refund/adjustment objects on this entry. Often 0; refund details usually appear on the Payments tab instead. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
One row per Etsy Payments payment (order-level gross, fees, and net). Date range: filtered by payment created date via ledger entries (default), or by updated date via receipts that changed in the window (matching the Payments Last Updated field). Payments typically appear after an order ships. Supports Since last export.
| Column | Description |
|---|---|
| Payment ID | Etsy Payments payment ID. |
| Receipt ID | Linked Etsy receipt (order) ID. |
| Buyer User ID | Etsy user ID of the buyer. |
| Shop ID | Etsy shop ID that received the payment. |
| Amount Gross | Original gross amount including shipping and taxes. |
| Amount Fees | Original card processing fees. |
| Amount Net | Original net (amount_gross minus amount_fees). |
| Posted Gross | Gross amount posted when the order ships (may be lower if refunded before shipping). |
| Posted Fees | Fees posted when the order ships. |
| Posted Net | Net amount posted when the order ships. |
| Adjusted Gross | Gross after refunds (partial or full). When Etsy omits this, SyncRange falls back to posted then original gross. |
| Adjusted Fees | Fees after refunds. Falls back to posted then original fees when omitted. |
| Adjusted Net | Net after refunds. Falls back to posted then original net when omitted. |
| Currency | Payment currency. |
| Shop Currency | Shop display currency. |
| Buyer Currency | Buyer currency. |
| Status | Payment status (commonly settled or authed). |
| Shipped Date | UTC date the order shipped (YYYY-MM-DD). |
| Shipped Date Time | UTC datetime the order shipped. |
| Created Date | UTC date the payment record was created (YYYY-MM-DD). |
| Created Date Time | UTC datetime the payment record was created. Created-date filters use this underlying timestamp. |
| Last Updated | UTC date the payment was last updated (YYYY-MM-DD). |
| Last Updated Date Time | UTC datetime the payment was last updated. Updated-date filters use receipt update datetime. |
| Payment Adjustments Count | Number of refund/adjustment objects on the payment. |
| Payment Adjustments JSON | Full nested refund/adjustment payload as JSON. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
One row per buyer transaction review. Date range: filtered by review created date. Supports Since last export.
| Column | Description |
|---|---|
| Shop ID | Etsy shop ID. |
| Listing ID | Listing the review belongs to. |
| Transaction ID | Line-item transaction the review belongs to. |
| Buyer User ID | Buyer user ID when privacy settings allow. |
| Rating | Star rating from 1 to 5. |
| Review | Review text left by the buyer. |
| Language | Review language code. |
| Review Image URL | Photo attached to the review, when present. |
| Created Date | UTC date the review was created (YYYY-MM-DD). |
| Created Date Time | UTC datetime the review was created. |
| Last Updated | UTC date the review was last updated (YYYY-MM-DD). |
| Last Updated Date Time | UTC datetime the review was last updated. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
One row per shipment/tracking event on an order receipt. Date range: uses the same order created/updated filter as Receipts. Supports Since last export.
| Column | Description |
|---|---|
| Receipt ID | Etsy receipt (order) ID. |
| Shipment ID | Etsy receipt shipping record ID. |
| Carrier | Carrier/company name (for example usps). |
| Tracking Code | Carrier tracking code. |
| Shipment Notification Date | UTC date Etsy notified the buyer of the shipment (YYYY-MM-DD). |
| Shipment Notification Date Time | UTC datetime Etsy notified the buyer of the shipment. |
| Buyer Email | Buyer email from the receipt. Same Etsy buyer_email access requirement as Receipts; otherwise blank. |
| Buyer Name | Buyer name from the receipt. |
| Is Shipped | Whether the receipt is marked shipped (true / false). |
| Receipt Status | Receipt status. |
| Order Date | UTC date the receipt was created (YYYY-MM-DD). |
| Order Date Time | UTC datetime the receipt was created. |
| Order Last Updated | UTC date the receipt was last updated (YYYY-MM-DD). |
| Order Last Updated Date Time | UTC datetime the receipt was last updated. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
One row per refund on an order receipt, including reason and note from issuer. Date range: uses the same order created/updated filter as Receipts. Supports Since last export.
| Column | Description |
|---|---|
| Receipt ID | Etsy receipt (order) ID. |
| Refund Amount | Refund total amount. |
| Currency | Currency of the refund amount. |
| Refund Date | UTC date the refund was created (YYYY-MM-DD). |
| Refund Date Time | UTC datetime the refund was created. |
| Reason | Reason string given for the refund. |
| Note from Issuer | Note created by the refund issuer. |
| Status | Refund status indication string. |
| Buyer Email | Buyer email from the receipt. |
| Buyer Name | Buyer name from the receipt. |
| Receipt Status | Receipt status. |
| Order Date | UTC date the receipt was created (YYYY-MM-DD). |
| Order Date Time | UTC datetime the receipt was created. |
| Order Last Updated | UTC date the receipt was last updated (YYYY-MM-DD). |
| Order Last Updated Date Time | UTC datetime the receipt was last updated. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
One row per listing product offering (SKU / variation quantity and price). Full export each run: date range does not apply. Covers active, sold out, and inactive listings. Large catalogs mean one API call per listing.
| Column | Description |
|---|---|
| Listing ID | Parent listing ID. |
| Listing Title | Listing title. |
| Listing State | Listing state (active, sold_out, inactive). |
| Product ID | Inventory product ID for the variation combination. |
| SKU | SKU assigned to the product. |
| Variation Properties | Flattened property values (for example Color: Blue; Size: M). |
| Offering ID | Product offering ID. |
| Quantity | Available quantity for the offering. |
| Price | Offering price. |
| Currency | Offering currency. |
| Is Enabled | Whether the offering is shown to buyers. |
| Readiness State ID | Processing profile ID linked to the offering, when set. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Something missing on this page? Email [email protected]