Etsy data reference

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.

Listings

One row per shop listing. Full export each run: always current listing data; the date range does not apply.

ColumnDescription
Listing IDEtsy's numeric ID for the listing.
TitleListing or item title.
DescriptionFull description text.
PriceUnit or listing price in the row currency.
CurrencyISO 4217 currency code (e.g. USD).
QuantityAvailable or ordered quantity.
StateListing state (e.g. active, draft, expired, sold_out).
URLPublic storefront URL for the listing.
TagsComma-separated listing tags.
MaterialsComma-separated materials listed on the item.
Shipping Profile IDID of the shipping profile applied to the listing.
Shop Section IDID of the shop section containing the listing.
Featured RankFeatured ranking position in the shop (when set).
Is CustomizableWhether the listing accepts customization requests.
Is PersonalizableWhether personalization is offered on the listing.
Is DigitalWhether the item is a digital download.
Has VariationsWhether the listing has variations (size, color, etc.).
Auto RenewWhether the listing is set to auto-renew.
LanguageListing language code.
ViewsLifetime of times the listing has been viewed.
Created DateUTC date the listing was created (YYYY-MM-DD).
Created Date TimeUTC datetime the listing was created.
Last Modified DateUTC date the listing was last modified (YYYY-MM-DD).
Last Modified Date TimeUTC datetime the listing was last modified.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Receipts (Orders)

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.

ColumnDescription
Receipt IDEtsy receipt (order) ID.
Order IDEtsy order ID associated with the receipt.
Buyer User IDEtsy user ID of the buyer.
Buyer EmailBuyer 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 NameBuyer or entity display name.
Message from BuyerMessage the buyer left on the order.
StatusOrder or record status as reported by the platform.
Payment MethodHow the order was paid.
CurrencyISO 4217 currency code (e.g. USD).
SubtotalOrder subtotal before shipping and tax.
Total Shipping CostTotal shipping charged on the receipt.
Total TaxTotal tax charged on the receipt.
Total VATTotal VAT charged on the receipt.
Discount AmountDiscount amount applied to the receipt.
Total PriceGrand total charged to the buyer.
Is PaidWhether the receipt is marked paid (true / false).
Is ShippedWhether the receipt is marked shipped (true / false).
Is RefundedWhether the receipt has any refunds, or a refund-related status (true / false). Receipt Status may also show fully refunded or partially refunded.
Gift MessageGift message on the order, if any.
Gift Wrap PriceGift wrap charge, if any.
Ship To NameShip-to recipient name.
Ship Address Line 1Ship-to address line 1.
Ship Address Line 2Ship-to address line 2.
Ship CityShip-to city.
Ship StateShip-to state or region.
Ship ZIPShip-to postal code.
Ship CountryShip-to country ISO code.
Order DateUTC date the receipt was created (YYYY-MM-DD).
Order Date TimeUTC datetime the receipt was created. Order created/updated filters use this underlying timestamp.
Last UpdatedUTC date the receipt was last updated (YYYY-MM-DD).
Last Updated Date TimeUTC datetime the receipt was last updated. Order updated filters use this underlying timestamp.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Transactions (Line Items)

One row per line item within an order. Date range: uses the same order created/updated filter as Receipts.

ColumnDescription
Transaction IDEtsy transaction (line item) ID.
Receipt IDEtsy receipt (order) ID.
Listing IDEtsy listing ID for the purchased item.
TitleListing or item title.
DescriptionFull description text.
QuantityAvailable or ordered quantity.
PriceUnit or listing price in the row currency.
Buyer CouponBuyer coupon discount amount applied to this line (shop currency). Use with Price × Quantity to get the discounted line subtotal.
Shop CouponShop coupon discount amount applied to this line (shop currency).
CurrencyISO 4217 currency code (e.g. USD).
Seller User IDEtsy user ID of the seller.
Buyer User IDEtsy user ID of the buyer.
Is DigitalWhether the item is a digital download.
Transaction DateUTC date the transaction was created (YYYY-MM-DD).
Transaction Date TimeUTC datetime the transaction was created.
Paid DateUTC date the line item was paid (YYYY-MM-DD).
Paid Date TimeUTC datetime the line item was paid.
Shipped DateUTC date the line item was marked shipped (YYYY-MM-DD).
Shipped Date TimeUTC datetime the line item was marked shipped.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Ledger Entries

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.

ColumnDescription
Entry IDNumeric ID for this ledger entry.
Ledger IDNumeric ID of the shop payment account ledger.
Sequence NumberChronological sequence within the ledger (higher is more recent).
AmountAmount credited or debited on this entry (decimal, from Etsy minor units).
CurrencyCurrency of the ledger entry.
DescriptionHuman-readable entry type (payment, refund, disbursement, bill payment, etc.).
BalanceRunning shop payment-account balance after this entry.
Created DateUTC date the ledger entry was created (YYYY-MM-DD).
Created Date TimeUTC datetime the ledger entry was created.
Ledger TypeOriginal reference type for the ledger entry.
Reference TypeObject type the entry refers to.
Reference IDObject ID the entry refers to.
Parent Entry IDParent 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 CountNumber of nested refund/adjustment objects on this entry. Often 0; refund details usually appear on the Payments tab instead.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Payments

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.

ColumnDescription
Payment IDEtsy Payments payment ID.
Receipt IDLinked Etsy receipt (order) ID.
Buyer User IDEtsy user ID of the buyer.
Shop IDEtsy shop ID that received the payment.
Amount GrossOriginal gross amount including shipping and taxes.
Amount FeesOriginal card processing fees.
Amount NetOriginal net (amount_gross minus amount_fees).
Posted GrossGross amount posted when the order ships (may be lower if refunded before shipping).
Posted FeesFees posted when the order ships.
Posted NetNet amount posted when the order ships.
Adjusted GrossGross after refunds (partial or full). When Etsy omits this, SyncRange falls back to posted then original gross.
Adjusted FeesFees after refunds. Falls back to posted then original fees when omitted.
Adjusted NetNet after refunds. Falls back to posted then original net when omitted.
CurrencyPayment currency.
Shop CurrencyShop display currency.
Buyer CurrencyBuyer currency.
StatusPayment status (commonly settled or authed).
Shipped DateUTC date the order shipped (YYYY-MM-DD).
Shipped Date TimeUTC datetime the order shipped.
Created DateUTC date the payment record was created (YYYY-MM-DD).
Created Date TimeUTC datetime the payment record was created. Created-date filters use this underlying timestamp.
Last UpdatedUTC date the payment was last updated (YYYY-MM-DD).
Last Updated Date TimeUTC datetime the payment was last updated. Updated-date filters use receipt update datetime.
Payment Adjustments CountNumber of refund/adjustment objects on the payment.
Payment Adjustments JSONFull nested refund/adjustment payload as JSON.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Reviews

One row per buyer transaction review. Date range: filtered by review created date. Supports Since last export.

ColumnDescription
Shop IDEtsy shop ID.
Listing IDListing the review belongs to.
Transaction IDLine-item transaction the review belongs to.
Buyer User IDBuyer user ID when privacy settings allow.
RatingStar rating from 1 to 5.
ReviewReview text left by the buyer.
LanguageReview language code.
Review Image URLPhoto attached to the review, when present.
Created DateUTC date the review was created (YYYY-MM-DD).
Created Date TimeUTC datetime the review was created.
Last UpdatedUTC date the review was last updated (YYYY-MM-DD).
Last Updated Date TimeUTC datetime the review was last updated.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Shipments

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.

ColumnDescription
Receipt IDEtsy receipt (order) ID.
Shipment IDEtsy receipt shipping record ID.
CarrierCarrier/company name (for example usps).
Tracking CodeCarrier tracking code.
Shipment Notification DateUTC date Etsy notified the buyer of the shipment (YYYY-MM-DD).
Shipment Notification Date TimeUTC datetime Etsy notified the buyer of the shipment.
Buyer EmailBuyer email from the receipt. Same Etsy buyer_email access requirement as Receipts; otherwise blank.
Buyer NameBuyer name from the receipt.
Is ShippedWhether the receipt is marked shipped (true / false).
Receipt StatusReceipt status.
Order DateUTC date the receipt was created (YYYY-MM-DD).
Order Date TimeUTC datetime the receipt was created.
Order Last UpdatedUTC date the receipt was last updated (YYYY-MM-DD).
Order Last Updated Date TimeUTC datetime the receipt was last updated.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Refunds

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.

ColumnDescription
Receipt IDEtsy receipt (order) ID.
Refund AmountRefund total amount.
CurrencyCurrency of the refund amount.
Refund DateUTC date the refund was created (YYYY-MM-DD).
Refund Date TimeUTC datetime the refund was created.
ReasonReason string given for the refund.
Note from IssuerNote created by the refund issuer.
StatusRefund status indication string.
Buyer EmailBuyer email from the receipt.
Buyer NameBuyer name from the receipt.
Receipt StatusReceipt status.
Order DateUTC date the receipt was created (YYYY-MM-DD).
Order Date TimeUTC datetime the receipt was created.
Order Last UpdatedUTC date the receipt was last updated (YYYY-MM-DD).
Order Last Updated Date TimeUTC datetime the receipt was last updated.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Inventory

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.

ColumnDescription
Listing IDParent listing ID.
Listing TitleListing title.
Listing StateListing state (active, sold_out, inactive).
Product IDInventory product ID for the variation combination.
SKUSKU assigned to the product.
Variation PropertiesFlattened property values (for example Color: Blue; Size: M).
Offering IDProduct offering ID.
QuantityAvailable quantity for the offering.
PriceOffering price.
CurrencyOffering currency.
Is EnabledWhether the offering is shown to buyers.
Readiness State IDProcessing profile ID linked to the offering, when set.
Date ExportedTimestamp this row was written by SyncRange (your account timezone).

Related documentation

Something missing on this page? Email [email protected]

Start syncing your ecommerce data in minutes Start free today. No credit card required.