Visser Labs – WooCommerce Plugins
  1. Home
  2. Knowledge Base
  3. WooCommerce Store Exporter Deluxe
  4. Available export fields in Store Exporter Deluxe

Available export fields in Store Exporter Deluxe

The following page lists export fields available to include in exports made with Store Exporter Deluxe.

Export field lists are broken into Export Type sections and then, by default, WooCommerce fields and those extended by WordPress and WooCommerce Plugins on our supported export plugins list.


Product fields

WooCommerce Product export fields

Export field IDExport field label
parent_idParent ID
parent_skuParent SKU
product_idProduct ID
skuProduct SKU
global_unique_idGTIN, UPC, EAN, or ISBN
nameProduct Name
post_titlePost Title
slugSlug
permalinkPermalink
product_urlProduct URI
descriptionDescription
excerptExcerpt
post_dateProduct Published
post_modifiedProduct Modified
typeType
visibilityVisibility
featuredFeatured
virtualVirtual
downloadableDownloadable
pricePrice
sale_priceSale Price
sale_price_dates_fromSale Price Dates From
sale_price_dates_toSale Price Dates To
net_priceNet Price
weightWeight
weight_unitWeight Unit
heightHeight
height_unitHeight Unit
widthWidth
width_unitWidth Unit
lengthLength
length_unitLength Unit
categoryCategory
category_level_1Category: Level 1
category_level_2Category: Level 2
category_level_3Category: Level 3
tagTag
grouped_productsGrouped Products
imageFeatured Image
image_thumbnailFeatured Image Thumbnail
image_embedFeatured Image (Embed)
image_titleFeatured Image Title
image_captionFeatured Image Caption
image_altFeatured Image Alternative Text
image_descriptionFeatured Image Description
product_galleryProduct Gallery
product_gallery_thumbnailProduct Gallery Thumbnail
product_gallery_embedProduct Gallery (Embed)
product_gallery_titleProduct Gallery Title
product_gallery_captionProduct Gallery Caption
product_gallery_altProduct Gallery Alt
product_gallery_descriptionProduct Gallery Description
tax_statusTax Status
tax_classTax Class
shipping_classShipping Class
download_file_nameDownload File Name
download_file_pathDownload File URL Path
download_limitDownload Limit
download_expiryDownload Expiry
download_typeDownload Type
manage_stockManage Stock
quantityQuantity
stock_statusStock Status
allow_backordersAllow Backorders
sold_individuallySold Individually
total_salesTotal Sales
upsell_idsUp-sells
crosssell_idsCross-sells
external_urlExternal URL
button_textButton Text
purchase_notePurchase Note
product_statusProduct Status
enable_reviewsEnable Reviews
review_countReview Count
rating_countRating Count
average_ratingAverage Rating
attributesAttributes
custom_attributesCustom Attributes
default_attributesDefault Attributes
custom_product_metaCustom Product meta
menu_orderSort Order
post_authorPost Author
user_nameUsername
user_roleUser Role

Extended Product export fields (third-party plugins)

Export field IDExport field labelPlugin Name
gpf_availabilityAvailabilityAdvanced Google Product Feed
gpf_conditionConditionAdvanced Google Product Feed
gpf_brandBrandAdvanced Google Product Feed
gpf_product_typeProduct TypeAdvanced Google Product Feed
gpf_google_product_categoryGoogle Product CategoryAdvanced Google Product Feed
gpf_gtinGlobal Trade Item Number (GTIN)Advanced Google Product Feed
gpf_mpnManufacturer Part Number (MPN)Advanced Google Product Feed
gpf_genderGenderAdvanced Google Product Feed
gpf_agegroupAge GroupAdvanced Google Product Feed
gpf_colourColourAdvanced Google Product Feed
gpf_sizeSizeAdvanced Google Product Feed
aioseop_keywordsKeywordsAll in One SEO Pack
aioseop_descriptionDescriptionAll in One SEO Pack
aioseop_titleTitleAll in One SEO Pack
aioseop_title_attributesTitle AttributesAll in One SEO Pack
aioseop_menu_labelMenu LabelAll in One SEO Pack
wpseo_focuskwWordPress SEO – Focus KeywordWordPress SEO
wpseo_metadescWordPress SEO – Meta DescriptionWordPress SEO
wpseo_titleWordPress SEO – SEO TitleWordPress SEO
wpseo_noindexWordPress SEO – NoindexWordPress SEO
wpseo_followWordPress SEO – FollowWordPress SEO
wpseo_googleplus_descriptionWordPress SEO – Google+ DescriptionWordPress SEO
wpseo_opengraph_titleWordPress SEO – Facebook TitleWordPress SEO
wpseo_opengraph_descriptionWordPress SEO – Facebook DescriptionWordPress SEO
wpseo_opengraph_imageWordPress SEO – Facebook ImageWordPress SEO
wpseo_twitter_titleWordPress SEO – Twitter TitleWordPress SEO
wpseo_twitter_descriptionWordPress SEO – Twitter DescriptionWordPress SEO
wpseo_twitter_imageWordPress SEO – Twitter ImageWordPress SEO
useo_meta_keywordsMeta KeywordsUltimate SEO
useo_social_titleSocial TitleUltimate SEO
useo_social_descriptionSocial DescriptionUltimate SEO
useo_meta_noindexNoindexUltimate SEO
useo_meta_noautolinksDisable AutolinksUltimate SEO
msrpMSRPWooCommerce MSRP Pricing
cost_of_goodsCost of GoodsCost of Goods
per_product_shippingPer-Product ShippingPer Product Shipping
per_product_shipping_countryPer-Product Shipping – CountryPer Product Shipping
per_product_shipping_statePer-Product Shipping – StatePer Product Shipping
per_product_shipping_postcodePer-Product Shipping – PostcodePer Product Shipping
per_product_shipping_costPer-Product Shipping – CostPer Product Shipping
per_product_shipping_item_costPer-Product Shipping – Item CostPer Product Shipping
per_product_shipping_orderPer-Product Shipping – PriorityPer Product Shipping
vendorsProduct VendorsProduct Vendors
vendorsProduct VendorsWC Vendors
vendorsProduct VendorsYITH WooCommerce Multi Vendor Premium
vendor_idsProduct Vendor ID\’sProduct Vendors
vendor_commissionVendor CommissionProduct Vendors
vendor_commission_rateCommission (%)WC Vendors
vendor_commission_rateCommission (%)YITH WooCommerce Multi Vendor Premium
wholesale_priceWholesale PriceWooCommerce Wholesale Pricing
wholesale_price_textWholesale TextWooCommerce Wholesale Pricing
acfCustom Product FieldsAdvanced Custom Fields
wccfCustom Product FieldsWooCommerce Custom Fields
subscription_priceSubscription PriceWooCommerce Subscriptions
subscription_period_intervalSubscription Period IntervalWooCommerce Subscriptions
subscription_periodSubscription PeriodWooCommerce Subscriptions
subscription_lengthSubscription LengthWooCommerce Subscriptions
subscription_sign_up_feeSubscription Sign-up FeeWooCommerce Subscriptions
subscription_trial_lengthSubscription Trial LengthWooCommerce Subscriptions
subscription_trial_periodSubscription Trial PeriodWooCommerce Subscriptions
subscription_limitLimit SubscriptionWooCommerce Subscriptions
booking_has_personsBooking Has PersonsWooCommerce Bookings
booking_has_resourcesBooking Has ResourcesWooCommerce Bookings
booking_base_costBooking Base CostWooCommerce Bookings
booking_block_costBooking Block CostWooCommerce Bookings
booking_display_costBooking Display CostWooCommerce Bookings
booking_requires_confirmationBooking Requires ConfirmationWooCommerce Bookings
booking_user_can_cancelBooking Can Be CancelledWooCommerce Bookings
barcode_typeBarcode TypeBarcodes for WooCommerce
barcodeBarcodeBarcodes for WooCommerce
pre_orders_enabledPre-Order EnabledWooCommerce Pre-Orders
pre_orders_availability_datePre-Order Availability DateWooCommerce Pre-Orders
pre_orders_feePre-Order FeeWooCommerce Pre-Orders
pre_orders_chargePre-Order ChargeWooCommerce Pre-Orders
fee_nameProduct Fee NameWooCommerce Product Fees
fee_amountProduct Fee AmountWooCommerce Product Fees
fee_multiplierProduct Fee MultiplierWooCommerce Product Fees
is_eventIs EventWooCommerce Events
event_dateEvent DateWooCommerce Events
event_start_timeEvent Start TimeWooCommerce Events
event_end_timeEvent End TimeWooCommerce Events
event_venueEvent VenueWooCommerce Events
event_gpsEvent GPS CoordinatesWooCommerce Events
event_googlemapsEvent Google Maps CoordinatesWooCommerce Events
event_directionsEvent DirectionsWooCommerce Events
event_phoneEvent PhoneWooCommerce Events
event_emailEvent E-mailWooCommerce Events
event_ticket_logoEvent Ticket LogoWooCommerce Events
event_ticket_textEvent Ticket TextWooCommerce Events
enable_uploadsEnable UploadsWooCommerce Uploads
posrCost of GoodWooCommerce Profit of Sales Report
bundled_productsBundled ProductsWooCommerce Product Bundles
bundled_product_idsBundled Product IDsWooCommerce Product Bundles
minimum_quantityMinimum QuantityWooCommerce Min/Max Quantities
maximum_quantityMaximum QuantityWooCommerce Min/Max Quantities
group_ofGroup ofWooCommerce Min/Max Quantities
product_tabCustom Product TabsWooCommerce Tab Manager
wootabCustom Product TabsWooTab
tiered_pricingTiered PricingWooCommerce Tiered Pricing
book_customCustom FieldsWooCommerce BookStore
book_categoryBook CategoryWooCommerce BookStore
book_authorBook AuthorWooCommerce BookStore
book_publisherBook PublisherWooCommerce BookStore
languageLanguageWooCommerce Multilingual
wcj_purchase_priceProduct cost (purchase) priceWooCommerce Jetpack
wcj_purchase_price_extraExtra expenses (shipping)WooCommerce Jetpack
wcj_purchase_price_affiliate_commissionAffiliate commissionWooCommerce Jetpack
wcj_purchase_date(Last) Purchase dateWooCommerce Jetpack
wcj_purchase_partnerSellerWooCommerce Jetpack
wcj_purchase_infoPurchase infoWooCommerce Jetpack
wcumcs_regular_priceRegular Price (Currency)WooCommerce Ultimate Multi Currency Suite
wcae_regular_priceRegular Price (Currency)WooCommerce Currency Switcher
wcumcs_sale_priceSale Price (Currency)WooCommerce Ultimate Multi Currency Suite
wcae_sale_priceSale Price (Currency)WooCommerce Currency Switcher
purchase_pricePurchase PriceProducts Purchase Price for Woocommerce
wholesale_priceWholesale PriceWooCommerce Wholesale Prices
show_search_resultsShow in Search ResultsWooCommerce Show Single Variations
show_filtered_resultsShow in Filtered ResultsWooCommerce Show Single Variations
show_catalogShow in CatalogWooCommerce Show Single Variations
disable_add_to_cartDisable Add to CartWooCommerce Show Single Variations
enable_depositEnable DepositWooCommerce Deposits
force_depositForce DepositWooCommerce Deposits
amount_typeDeposit TypeWooCommerce Deposits
deposit_amountDeposit AmountWooCommerce Deposits
unit_of_measureUnit of MeasureWooCommerce Unit of Measure
bookableBookableWooCommerce Easy Bookings
booking_datesNumber of Dates to SelectWooCommerce Easy Bookings
booking_durationBooking durationWooCommerce Easy Bookings
booking_minMinimum Booking DurationWooCommerce Easy Bookings
booking_maxMaximum Booking DurationWooCommerce Easy Bookings
first_available_dateFirst Available DateWooCommerce Easy Bookings

Category fields

WooCommerce Category export fields

Export field IDExport field label
term_idTerm ID
nameName
slugSlug
term_urlTerm URI
parent_idParent Term ID
parent_nameParent Name
category_level_1Category: Level 1
category_level_2Category: Level 2
category_level_3Category: Level 3
category_level_4Category: Level 4
category_level_5Category: Level 5
category_level_6Category: Level 6
category_level_7Category: Level 7
heirachyHeirachy
descriptionDescription
display_typeDisplay Type
orderOrder
imageImage
image_embedImage (Embed)
countCount

Extended Category export fields (third-party plugins)

Export field IDExport field labelPlugin Name
blog_idBlog IDWordPress Multisite
blog_nameBlog NameWordPress Multisite
wpseo_titleWordPress SEO – SEO TitleWordPress SEO
wpseo_descriptionWordPress SEO – SEO DescriptionWordPress SEO
wpseo_focuskwWordPress SEO – Focus KeywordWordPress SEO
wpseo_canonicalWordPress SEO – CanonicalWordPress SEO
wpseo_noindexWordPress SEO – NoindexWordPress SEO
wpseo_sitemap_includeWordPress SEO – Sitemap IncludeWordPress SEO
wpseo_opengraph_titleWordPress SEO – Facebook TitleWordPress SEO
wpseo_opengraph_descriptionWordPress SEO – Facebook DescriptionWordPress SEO
wpseo_opengraph_imageWordPress SEO – Facebook ImageWordPress SEO
wpseo_twitter_titleWordPress SEO – Twitter TitleWordPress SEO
wpseo_twitter_descriptionWordPress SEO – Twitter DescriptionWordPress SEO
wpseo_twitter_imageWordPress SEO – Twitter ImageWordPress SEO
languageLanguageWooCommerce Multilingual

Product Tag fields

WooCommerce Product Tag export fields

Export field IDExport field label
term_idTerm ID
nameName
slugSlug
term_urlTerm URI
descriptionDescription
countCount

Extended Product Tag export fields (third-party plugins)

Export field IDExport field labelPlugin Name
blog_idBlog IDWordPress Multisite
blog_nameBlog NameWordPress Multisite
wpseo_titleWordPress SEO – SEO TitleWordPress SEO
wpseo_descriptionWordPress SEO – SEO DescriptionWordPress SEO
wpseo_focuskwWordPress SEO – Focus KeywordWordPress SEO
wpseo_canonicalWordPress SEO – CanonicalWordPress SEO
wpseo_noindexWordPress SEO – NoindexWordPress SEO
wpseo_sitemap_includeWordPress SEO – Sitemap IncludeWordPress SEO
wpseo_opengraph_titleWordPress SEO – Facebook TitleWordPress SEO
wpseo_opengraph_descriptionWordPress SEO – Facebook DescriptionWordPress SEO
wpseo_opengraph_imageWordPress SEO – Facebook ImageWordPress SEO
wpseo_twitter_titleWordPress SEO – Twitter TitleWordPress SEO
wpseo_twitter_descriptionWordPress SEO – Twitter DescriptionWordPress SEO
wpseo_twitter_imageWordPress SEO – Twitter ImageWordPress SEO
languageLanguageWooCommerce Multilingual

Brand fields

WooCommerce Brand export fields

Export field IDExport field label
term_idTerm ID
nameBrand Name
slugBrand Slug
parent_idParent Term ID
descriptionBrand Description
imageBrand Image
image_embedBrand Image (Embed)
countCount

Extended Brand export fields (third-party plugins)

Export field IDExport field labelPlugin Name
blog_idBlog IDWordPress Multisite
blog_nameBlog NameWordPress Multisite
custom_urlCustom URLYITH WooCommerce Brands Add-On
bannerBannerYITH WooCommerce Brands Add-On
bannerBannerPerfect WooCommerce Brands
logoLogoPerfect WooCommerce Brands
banner_linkBanner LinkPerfect WooCommerce Brands
wpseo_titleWordPress SEO – SEO TitleWordPress SEO
wpseo_descriptionWordPress SEO – SEO DescriptionWordPress SEO
wpseo_focuskwWordPress SEO – Focus KeywordWordPress SEO
wpseo_canonicalWordPress SEO – CanonicalWordPress SEO
wpseo_noindexWordPress SEO – NoindexWordPress SEO
wpseo_sitemap_includeWordPress SEO – Sitemap IncludeWordPress SEO
wpseo_opengraph_titleWordPress SEO – Facebook TitleWordPress SEO
wpseo_opengraph_descriptionWordPress SEO – Facebook DescriptionWordPress SEO
wpseo_opengraph_imageWordPress SEO – Facebook ImageWordPress SEO
wpseo_twitter_titleWordPress SEO – Twitter TitleWordPress SEO
wpseo_twitter_descriptionWordPress SEO – Twitter DescriptionWordPress SEO
wpseo_twitter_imageWordPress SEO – Twitter ImageWordPress SEO

Order fields

WooCommerce Order export fields

Export field IDExport field label
purchase_idOrder ID
post_idPost ID
purchase_totalOrder Total
purchase_subtotalOrder Subtotal
order_currencyOrder Currency
order_discountOrder Discount
coupon_codeCoupon Code
coupon_expiry_dateCoupon Expiry Date
coupon_descriptionCoupon Description
purchase_total_taxOrder Total Tax
order_incl_taxOrder Incl. Tax
order_subtotal_excl_taxOrder Subtotal Excl. Tax
order_sales_taxSales Tax Total
order_shipping_taxShipping Tax Total
shipping_incl_taxShipping Incl. Tax
shipping_excl_taxShipping Excl. Tax
refund_totalRefund Total
refund_dateRefund Date
order_tax_percentageOrder Tax Percentage
order_tax_rateOrder Tax Rate
payment_gateway_idPayment Gateway ID
payment_gatewayPayment Gateway
shipping_method_idShipping Method ID
shipping_instance_idShipping Instance ID
shipping_methodShipping Method
shipping_costShipping Cost
shipping_weight_totalShipping Weight
payment_statusOrder Status
post_statusPost Status
order_keyOrder Key
transaction_idTransaction ID
purchase_dateOrder Date
purchase_timeOrder Time
customer_messageCustomer Message
customer_notesCustomer Notes
order_notesOrder Notes
total_quantityTotal Quantity
total_order_itemsTotal Order Items
user_idUser ID
user_nameUsername
user_roleUser Role
ip_addressCheckout IP Address
browser_agentCheckout Browser Agent
has_downloadsHas Downloads
has_downloadedHas Downloaded
billing_full_nameBilling: Full Name
billing_first_nameBilling: First Name
billing_last_nameBilling: Last Name
billing_companyBilling: Company
billing_addressBilling: Street Address (Full)
billing_address_1Billing: Street Address 1
billing_address_2Billing: Street Address 2
billing_cityBilling: City
billing_postcodeBilling: ZIP Code
billing_stateBilling: State (prefix)
billing_state_fullBilling: State
billing_countryBilling: Country (prefix)
billing_country_fullBilling: Country
billing_phoneBilling: Phone Number
billing_emailBilling: E-mail Address
shipping_full_nameShipping: Full Name
shipping_first_nameShipping: First Name
shipping_last_nameShipping: Last Name
shipping_companyShipping: Company
shipping_addressShipping: Street Address (Full)
shipping_address_1Shipping: Street Address 1
shipping_address_2Shipping: Street Address 2
shipping_cityShipping: City
shipping_postcodeShipping: ZIP Code
shipping_stateShipping: State (prefix)
shipping_state_fullShipping: State
shipping_countryShipping: Country (prefix)
shipping_country_fullShipping: Country
custom_order_metaCustom Order meta
custom_user_metaCustom User meta
modified_dateOrder Modified Date
created_viaCreated Via
cart_hashCart Hash
paypal_payer_paypal_addressPayPal: Payer PayPal Address
paypal_payer_first_namePayPal: Payer First Name
paypal_payer_last_namePayPal: Payer Last Name
paypal_payment_typePayPal: Payment Type
paypal_payment_statusPayPal: Payment Status

Extended Order export fields (third-party plugins)

Export field IDExport field labelPlugin Name
invoice_numberInvoice NumberWooCommerce Print Invoice & Delivery Note
invoice_numberInvoice NumberWooCommerce Germanized
invoice_dateInvoice DateWooCommerce Print Invoice & Delivery Note
invoice_dateInvoice DateWooCommerce Germanized
_wcpdf_invoice_numberPDF Invoice NumberWooCommerce PDF Invoices & Packing Slips
_wcpdf_invoice_date; _wcpdf_invoice_date_formattedPDF Invoice Date (Unix time); PDF Invoice Date (formatted)WooCommerce PDF Invoices & Packing Slips
hear_about_usSourceWooCommerce Hear About Us
delivery_dateDelivery DateOrder Delivery Date for WooCommerce
delivery_dateDelivery DateOrder Delivery Date Pro for WooCommerce
active_membershipsActive MembershipsWooCommerce Memberships
uploaded_filesUploaded FilesWooCommerce Uploads
uploaded_files_thumbnailUploaded Files (Thumbnail)WooCommerce Uploads
languageLanguageWPML
languageLanguageWooCommerce Multilingual
ean_numberEAN NumberWooCommerce EAN Payment Gateway
billing_fieldsCustom Billing FieldsWooCommerce Checkout Manager
billing_fieldsCustom Billing FieldsPoor Guys Swiss Knife
billing_fieldsCustom Billing FieldsCheckout Field Editor
billing_fieldsCustom Billing FieldsCheckout Field Manager
billing_fieldsCustom Billing FieldsYITH WooCommerce Checkout Manager
shipping_fieldsCustom Shipping FieldsWooCommerce Checkout Manager
shipping_fieldsCustom Shipping FieldsPoor Guys Swiss Knife
shipping_fieldsCustom Shipping FieldsCheckout Field Editor
shipping_fieldsCustom Shipping FieldsCheckout Field Manager
shipping_fieldsCustom Shipping FieldsYITH WooCommerce Checkout Manager
custom_fieldsCustom Additional FieldsWooCommerce Checkout Manager
custom_fieldsCustom Additional FieldsPoor Guys Swiss Knife
custom_fieldsCustom Additional FieldsCheckout Field Editor
custom_fieldsCustom Additional FieldsCheckout Field Manager
custom_fieldsCustom Additional FieldsYITH WooCommerce Checkout Manager
custom_fieldsCustom Additional FieldsWooCommerce Easy Checkout Fields Editor
custom_fieldsCustom Additional FieldsWooCommerce Custom Fields
billing_cpfBilling: CPFWooCommerce Extra Checkout Fields for Brazil
billing_rgBilling: RGWooCommerce Extra Checkout Fields for Brazil
billing_cnpjBilling: CNPJWooCommerce Extra Checkout Fields for Brazil
billing_ieBilling: IEWooCommerce Extra Checkout Fields for Brazil
billing_birthdateBilling: Birth DateWooCommerce Extra Checkout Fields for Brazil
billing_sexBilling: SexWooCommerce Extra Checkout Fields for Brazil
billing_numberBilling: NumberWooCommerce Extra Checkout Fields for Brazil
billing_neighborhoodBilling: NeighborhoodWooCommerce Extra Checkout Fields for Brazil
billing_cellphoneBilling: Cell PhoneWooCommerce Extra Checkout Fields for Brazil
shipping_numberShipping: NumberWooCommerce Extra Checkout Fields for Brazil
shipping_neighborhoodShipping: NeighborhoodWooCommerce Extra Checkout Fields for Brazil
order_typeSubscription RelationshipWooCommerce Subscriptions
subscription_renewalSubscription RenewalWooCommerce Subscriptions
subscription_resubscribeSubscription ResubscribeWooCommerce Subscriptions
subscription_switchSubscription SwitchWooCommerce Subscriptions
project_idProject IDWooCommerce Quick Donation
project_nameProject NameWooCommerce Quick Donation
tickets_purchasedTickets PurchasedWooCommerce Events
order_currencyOrder CurrencyWooCommerce Currency Switcher
eu_vatVAT IDWooCommerce EU VAT Number
eu_vatVAT IDWooCommerce EU VAT Compliance
eu_vatVAT IDWooCommerce EU VAT Compliance (Premium)
eu_vatVAT IDWooCommerce Jetpack
eu_vatVAT IDWooCommerce Jetpack Plus
eu_vat_validatedVAT ID ValidatedWooCommerce EU VAT Number
eu_vat_validatedVAT ID ValidatedWooCommerce EU VAT Compliance
eu_vat_validatedVAT ID ValidatedWooCommerce EU VAT Compliance (Premium)
eu_vat_b2bVAT B2B TransactionWooCommerce EU VAT Number
eu_vat_b2bVAT B2B TransactionWooCommerce EU VAT Compliance
eu_vat_b2bVAT B2B TransactionWooCommerce EU VAT Compliance (Premium)
eu_vat_valid_idValid VAT IDWooCommerce EU VAT Compliance (Premium)
eu_vat_countryVAT ID CountryWooCommerce EU VAT Compliance (Premium)
eu_vat_country_sourceVAT Country SourceWooCommerce EU VAT Compliance
eu_vat_country_sourceVAT Country SourceWooCommerce EU VAT Compliance (Premium)
eu_vat_country_sourceVAT Country SourceWooCommerce EU VAT Compliance
eu_vat_country_sourceVAT Country SourceWooCommerce EU VAT Compliance (Premium)
eu_vat_b2bVAT B2B TransactionWooCommerce EU VAT Compliance
eu_vat_b2bVAT B2B TransactionWooCommerce EU VAT Compliance (Premium)
arrival_dateArrival DateAweBooking
departure_dateDeparture DateAweBooking
adultsAdultsAweBooking
childrenChildrenAweBooking
room_type_idRoom Type IDAweBooking
room_type_nameRoom Type NameAweBooking
wc_acofAdmin Custom Order FieldsWooCommerce Custom Admin Order Fields
shipping_dateShipping DateYITH WooCommerce Delivery Date Premium
delivery_dateDelivery DateYITH WooCommerce Delivery Date Premium
delivery_time_slotDelivery Time SlotYITH WooCommerce Delivery Date Premium
order_typeOrder TypeWooCommerce Point of Sale
order_register_idRegister IDWooCommerce Point of Sale
order_cashierCashierWooCommerce Point of Sale
voucher_redeemedVoucher RedeemedWooCommerce PDF Product Vouchers
delivery_dateDelivery DateWooCommerce Delivery Slots
delivery_timeslotDelivery TimeslotWooCommerce Delivery Slots
wcms_number_packagesNumber of PackagesWooCommerce Ship to Multiple Addresses
has_depositHas DepositWooCommerce Deposits
deposit_paidDeposit PaidWooCommerce Deposits
deposit_second_payment_paidSecond Payment PaidWooCommerce Deposits
deposit_amountDeposit AmountWooCommerce Deposits
deposit_second_paymentSecond Payment AmountWooCommerce Deposits
deposit_original_totalOriginal TotalWooCommerce Deposits
wccf_ofCustom Order FieldsWooCommerce Custom Fields
cost_of_goodsOrder Total Cost of GoodsCost of Goods
access_point_nameAccess Point Location: NameUPS WooCommerce Shipping
access_point_addressAccess Point Location: AddressUPS WooCommerce Shipping
access_point_cityAccess Point Location: CityUPS WooCommerce Shipping
access_point_stateAccess Point Location: StateUPS WooCommerce Shipping
access_point_countryAccess Point Location: CountryUPS WooCommerce Shipping
access_point_postcodeAccess Point Location: PostcodeUPS WooCommerce Shipping
ups_shipment_idShipment IDUPS WooCommerce Shipping

WooCommerce Order Item export fields

Export field IDExport field label
order_items_idOrder Items: ID
order_items_product_idOrder Items: Product ID
order_items_variation_idOrder Items: Variation ID
order_items_skuOrder Items: SKU
order_items_global_unique_idOrder Items: GTIN, UPC, EAN, or ISBN
order_items_nameOrder Items: Product Name
order_items_variationOrder Items: Product Variation
order_items_image_embedOrder Items: Featured Image (Embed)
order_items_descriptionOrder Items: Product Description
order_items_publish_dateOrder Items: Publish Date
order_items_modified_dateOrder Items: Modified Date
order_items_excerptOrder Items: Product Excerpt
order_items_tax_classOrder Items: Tax Class
order_items_quantityOrder Items: Quantity
order_items_totalOrder Items: Total
order_items_subtotalOrder Items: Subtotal
order_items_discountOrder Items: Discount
order_items_rrpOrder Items: RRP
order_items_stockOrder Items: Stock
order_items_taxOrder Items: Tax
order_items_tax_percentageOrder Items: Tax Percentage
order_items_tax_subtotalOrder Items: Tax Subtotal
order_items_refund_subtotalOrder Items: Refund Subtotal
order_items_refund_subtotal_incl_taxOrder Items: Refund Subtotal Incl. Tax
order_items_refund_quantityOrder Items: Refund Quantity
order_items_typeOrder Items: Type
order_items_type_idOrder Items: Type ID
order_items_categoryOrder Items: Category
order_items_tagOrder Items: Tag
order_items_total_salesOrder Items: Total Sales
order_items_weightOrder Items: Weight
order_items_heightOrder Items: Height
order_items_widthOrder Items: Width
order_items_lengthOrder Items: Length
order_items_total_weightOrder Items: Total Weight
order_items_attributesOrder Items: Attributes
order_items_custom_attributesOrder Items: Custom Attributes
order_items_custom_metaOrder Items: Custom Order Item meta
order_items_custom_product_metaOrder Items: Custom Product meta
order_items_attributeOrder Items: Attribute Variation
order_items_product_attributeOrder Items: Product Attribute

Extended Order Item export fields (third-party plugins)

Export field IDExport field labelPlugin Name
order_items_checkout_addon_idOrder Items: Checkout Add-ons IDWooCommerce Checkout Add-Ons
order_items_checkout_addon_labelOrder Items: Checkout Add-ons LabelWooCommerce Checkout Add-Ons
order_items_checkout_addon_valueOrder Items: Checkout Add-ons ValueWooCommerce Checkout Add-Ons
order_items_brandOrder Items: BrandWooCommerce Brands
order_items_brandOrder Items: BrandWooCommerce Brands Addon
order_items_vendorOrder Items: Product VendorProduct Vendors
order_items_vendorOrder Items: Product VendorYITH WooCommerce Multi Vendor Premium
order_items_cost_of_goodsOrder Items: Cost of GoodsCost of Goods
order_items_total_cost_of_goodsOrder Items: Total Cost of GoodsCost of Goods
order_items_posrOrder Items: Cost of GoodsWooCommerce Profit of Sales Report
order_items_msrpOrder Items: MSRPWooCommerce MSRP Pricing
order_items_pickup_locationOrder Items: Pickup LocationLocal Pickup Plus
order_items_booking_idOrder Items: Booking IDWooCommerce Bookings
order_items_booking_dateOrder Items: Booking DateWooCommerce Bookings
order_items_booking_typeOrder Items: Booking TypeWooCommerce Bookings
order_items_booking_start_dateOrder Items: Start DateWooCommerce Bookings
order_items_booking_end_dateOrder Items: End DateWooCommerce Bookings
order_items_booking_all_dayOrder Items: All Day BookingWooCommerce Bookings
order_items_booking_resource_idOrder Items: Booking Resource IDWooCommerce Bookings
order_items_booking_resource_titleOrder Items: Booking Resource NameWooCommerce Bookings
order_items_booking_personsOrder Items: Booking # of PersonsWooCommerce Bookings
order_items_gf_form_idOrder Items: Gravity Form IDGravity Forms
order_items_gf_form_labelOrder Items: Gravity Form LabelGravity Forms
order_items_gfOrder Items: Gravity Form Add-on detailsGravity Forms
order_items_tmOrder Items: EPO FieldsWooCommerce TM Extra Product Options
order_items_wccfOrder Items: Custom FieldsWooCommerce Custom Fields
order_items_pcoOrder Items: Custom FieldsWooCommerce Product Custom Options Lite
order_items_barcode_typeOrder Items: Barcode TypeBarcodes for WooCommerce
order_items_barcodeOrder Items: BarcodeBarcodes for WooCommerce
order_items_start_dateOrder Items: StartWooCommerce Easy Bookings
order_items_end_dateOrder Items: EndWooCommerce Easy Bookings
order_items_product_addons_summaryOrder Items: Product Add-onsProduct Add-ons

Customer fields

WooCommerce fields

Export field IDExport field label
user_idUser ID
user_nameUsername
user_roleUser Role
billing_full_nameBilling: Full Name
billing_first_nameBilling: First Name
billing_last_nameBilling: Last Name
billing_companyBilling: Company
billing_addressBilling: Street Address (Full)
billing_address_1Billing: Street Address 1
billing_address_2Billing: Street Address 2
billing_cityBilling: City
billing_postcodeBilling: ZIP Code
billing_stateBilling: State (prefix)
billing_state_fullBilling: State
billing_countryBilling: Country (prefix)
billing_country_fullBilling: Country
billing_phoneBilling: Phone Number
billing_emailBilling: E-mail Address
shipping_full_nameShipping: Full Name
shipping_first_nameShipping: First Name
shipping_last_nameShipping: Last Name
shipping_companyShipping: Company
shipping_addressShipping: Street Address (Full)
shipping_address_1Shipping: Street Address 1
shipping_address_2Shipping: Street Address 2
shipping_cityShipping: City
shipping_postcodeShipping: ZIP Code
shipping_stateShipping: State (prefix)
shipping_state_fullShipping: State
shipping_countryShipping: Country (prefix)
shipping_country_fullShipping: Country
total_spentTotal Spent
completed_ordersCompleted Orders
total_ordersTotal Orders
custom_user_metaCustom User meta

Extended Customer export fields (third-party plugins)

Export field IDExport field labelPlugin Name
followup_optoutFollow-Up Emails: Opted OutWooCommerce Follow-Up Emails
hear_about_usSourceWooCommerce Hear About Us

User fields

WooCommerce User export fields

Export field IDExport field label
user_idUser ID
user_nameUsername
user_roleUser Role
first_nameFirst Name
last_nameLast Name
full_nameFull Name
nick_nameNickname
emailE-mail
ordersOrders
money_spentMoney Spent
urlWebsite
date_registeredDate Registered
last_updateLast Updated
descriptionBiographical Info
aimAIM
yimYahoo IM
jabberJabber / Google Talk

Extended User export fields (third-party plugins)

Export field IDExport field labelPlugin Name
blog_idBlog IDWordPress Multisite
blog_nameBlog NameWordPress Multisite
hear_about_usSourceWooCommerce Hear About Us
user_membershipsUser MembershipsWooCommerce Memberships
user_membership_statusUser Membership StatusWooCommerce Memberships
shop_nameShop NameWC Vendors
shop_slugShop SlugWC Vendors
paypal_emailPayPal E-mailWC Vendors
commission_rateCommission Rate (%)WC Vendors
seller_infoSeller InfoWC Vendors
shop_descriptionShop DescriptionWC Vendors
active_subscriberActive SubscriberWooCommerce Subscriptions

Review fields

WooCommerce Review export fields

Export field IDExport field label
comment_IDReview ID
comment_post_IDProduct ID
skuProduct SKU
product_nameProduct Name
comment_authorReviewer
comment_author_emailE-mail
comment_contentContent
comment_dateReview Date
comment_timeReview Time
ratingRating
verifiedVerified
comment_author_IPIP Address

Extended Review export fields (third-party plugins)

Export field IDExport field labelPlugin Name
blog_idBlog IDWordPress Multisite
blog_nameBlog NameWordPress Multisite

Coupon fields

WooCommerce Coupon export fields

Export field IDExport field label
coupon_codeCoupon Code
coupon_descriptionCoupon Description
discount_typeDiscount Type
coupon_amountCoupon Amount
individual_useIndividual Use
post_dateCoupon Published
post_modifiedCoupon Modified
apply_before_taxApply Before Tax
exclude_sale_itemsExclude Sale Items
minimum_amountMinimum Amount
maximum_amountMaximum Amount
product_idsProducts
exclude_product_idsExclude Products
product_categoriesProduct Categories
exclude_product_categoriesExclude Product Categories
customer_emailCustomer E-mails
usage_limitUsage Limit
expiry_dateExpiry Date
usage_countUsage Count
usage_costUsage Cost
used_byUsed By
used_inUsed In

Extended Coupon export fields (third-party plugins)

Export field IDExport field labelPlugin Name
blog_idBlog IDWordPress Multisite
blog_nameBlog NameWordPress Multisite
valid_forValid ForWooCommerce Smart Coupons
is_pick_price_of_productPick Product’s PriceWooCommerce Smart Coupons
auto_generate_couponAuto-Generate CouponWooCommerce Smart Coupons
coupon_title_prefixCoupon Title PrefixWooCommerce Smart Coupons
coupon_title_suffixCoupon Title SuffixWooCommerce Smart Coupons
visible_storewideVisible StorewideWooCommerce Smart Coupons
disable_email_restrictionDisable E-mail RestrictionWooCommerce Smart Coupons
coupon_amount_{currency}Coupon Amount ({currency})WooCommerce Currency Switcher
minimum_amount_{currency}Minimum Amount ({currency})WooCommerce Currency Switcher
maximum_amount_{currency}Maximum Amount ({currency})WooCommerce Currency Switcher

Subscription fields

Subscription export fields

Export field IDExport field label
subscription_idSubscription ID
order_idOrder ID
statusSubscription Status
recurringRecurring
userUser
user_idUser ID
order_statusOrder Status
post_statusPost Status
transaction_idTransaction ID
start_dateStart Date
end_dateEnd Date
trial_end_dateTrial End Date
last_paymentLast Payment
next_paymentNext Payment
payment_methodPayment Method
purchase_totalOrder Total
purchase_subtotalOrder Subtotal
recurring_totalRecurring Total
shipping_method_idShipping Method ID
shipping_methodShipping Method
shipping_costShipping Cost
sign_up_feeSign-up Fee
trial_lengthTrial Length
trial_periodTrial Period
couponCoupon Code
related_ordersRelated Orders
billing_full_nameBilling: Full Name
billing_first_nameBilling: First Name
billing_last_nameBilling: Last Name
billing_companyBilling: Company
billing_addressBilling: Street Address (Full)
billing_address_1Billing: Street Address 1
billing_address_2Billing: Street Address 2
billing_cityBilling: City
billing_postcodeBilling: ZIP Code
billing_stateBilling: State (prefix)
billing_state_fullBilling: State
billing_countryBilling: Country (prefix)
billing_country_fullBilling: Country
billing_phoneBilling: Phone Number
billing_emailBilling: E-mail Address
shipping_full_nameShipping: Full Name
shipping_first_nameShipping: First Name
shipping_last_nameShipping: Last Name
shipping_companyShipping: Company
shipping_addressShipping: Street Address (Full)
shipping_address_1Shipping: Street Address 1
shipping_address_2Shipping: Street Address 2
shipping_cityShipping: City
shipping_postcodeShipping: ZIP Code
shipping_stateShipping: State (prefix)
shipping_state_fullShipping: State
shipping_countryShipping: Country (prefix)
shipping_country_fullShipping: Country
order_items_product_idSubscription Items: Product ID
order_items_variation_idSubscription Items: Variation ID
order_items_skuSubscription Items: Product SKU
order_items_nameSubscription Items: Product Name
order_items_variationSubscription Items: Product Variation
order_items_quantitySubscription Items: Quantity

YITH Subscription fields

YITH WooCommerce Subscription export fields

Export field IDExport field label
subscription_idSubscription ID
order_idOrder ID
statusSubscription Status
userUser
user_idUser ID
start_dateStart Date
end_dateEnd Date
expired_dateExpired Date
cancelled_dateCancelled Date
payment_due_datePayment Due Date
recurring_priceRecurring Price
price_perPrice Per Period
trial_perTrial Period
max_lengthMax Length
product_idProduct ID
product_nameProduct Name
product_skuProduct SKU
billing_full_nameBilling: Full Name
billing_first_nameBilling: First Name
billing_last_nameBilling: Last Name
billing_companyBilling: Company
billing_addressBilling: Street Address (Full)
billing_address_1Billing: Street Address 1
billing_address_2Billing: Street Address 2
billing_cityBilling: City
billing_postcodeBilling: ZIP Code
billing_stateBilling: State (prefix)
billing_state_fullBilling: State
billing_countryBilling: Country (prefix)
billing_country_fullBilling: Country
billing_phoneBilling: Phone Number
billing_emailBilling: E-mail Address

Booking fields

WooCommerce Bookings export fields

Export field IDExport field label
booking_numberBooking Number
order_idOrder ID
date_createdDate Created
last_modifiedLast Modified
booking_statusBooking Status
user_idUser ID
user_nameUsername
user_roleUser Role
customer_nameCustomer Name
customer_emailCustomer E-mail
booked_product_idBooked Product ID
booked_product_skuBooked Product SKU
booked_product_nameBooked Product
parent_booking_idParent Booking ID
order_item_idOrder Item ID
booking_start_dateBooking Start Date
booking_start_timeBooking Start Time
booking_end_dateBooking End Date
booking_end_timeBooking End Time
booking_all_dayAll Day Booking
person_typePerson Type
person_type_countPerson Type Count

Product Vendor fields

Product Vendor export fields

Export field IDExport field label
IDProduct Vendor ID
titleName
slugSlug
descriptionDescription
urlProduct Vendor URL
commissionCommission
paypal_emailPayPal E-mail Address
user_nameVendor Username
user_idVendor User ID

Commission fields

Commission export fields

Export field IDExport field label
IDCommission ID
post_dateCommission Date
product_idProduct ID
product_nameProduct Name
product_skuProduct SKU
product_vendor_idProduct Vendor ID
product_vendor_nameProduct Vendor Name
commission_amountCommission Amount
paid_statusCommission Status
post_statusPost Status

Shipping Class fields

WooCommerce Shipping Class export fields

Export field IDExport field label
term_idTerm ID
nameName
slugSlug
descriptionDescription

Extended Shipping Class export fields (third-party plugins)

Export field IDExport field labelPlugin Name
blog_idBlog IDWordPress Multisite
blog_nameBlog NameWordPress Multisite

Ticket fields

Ticket export fields

Export field IDExport field label
post_idPost ID
ticket_idTicket ID
statusStatus
product_idProduct ID
order_idOrder ID
user_idUser ID

Need more help?

If you’re on Store Exporter Deluxe, open a support ticket, and our team will help you find or map the field you need.

If you’re using the free Store Exporter plugin, post your question on the WordPress.org support forum, and the community or our team will help you out.

Was this article helpful?

Related Articles

Resources & Help