eBay: File Exchange – Advanced Template

You can export your Shopify Products into the eBay “File Exchange – Advanced Template” file format.

Shopify export to eBay - choose eBay File Exchange - Advanced Template

When the Excelify app is selecting data from your Shopify store to insert into the columns, it is able to take additional data from your Tags or Metafields.

Read each of the columns below to find out what values are taken from which Shopify fields, and how you can pass values from your Tags or Metafields to set specific values.

This format can only be exported.

Exported Columns

ColumnExampleSource Field in Shopify
*Action(
SiteID=YourSite|
Country=CA|
Currency=USD|
Version=745|
CC=UTF-8
)
Add
The value of the column is always “Add“.

The column name is changing dynamically depending on your Shopify store settings and Shop Metafields:

  • SiteID value is taken from Shop Metafield “ebay.site_id”.
  • Country value is taken from your Shop Settings country code.
  • Currency value is taken from your Shop Settings currency.
CustomLabel
100001
Product Handle for Product rows.

Product Variant SKU for variant rows.

*Category
88433
Taken from Shopify Product:

  • Tag: “eBayCategory:<value>“
  • Metafield: ebay.category

Default value: 88433, “Everything Else > Every Other Thing”.

To get the list of all eBay categories, download this eBay categories file.

StoreCategory
3014796013
  • Tag: “eBayStoreCategory:<value>“
  • Metafield: ebay.store_category
*TitleT-shirtProduct Title.

It will be cut off at 80 characters, according to eBay requirements.

SubtitleVery nice indeed
  • Tag: “eBaySubtitle:<value>“
  • Metafield: ebay.subtitle
*ConditionID
1000
  • Tag: “eBayconditionId:<value>“
  • Metafield: ebay.condition_id

E.g. 1000 means “New”.

C:TypeCarCustom field in eBay.

  • Tag: “eBayType:<value>“
  • Metafield: ebay.type
*C:BrandVolvoCustom field in eBay.

Taken from Shopify Product “Vendor” field.

*C:MPN
ABC-12345
Custom field in eBay.

Taken from Shopify Product “Variant SKU” field.

C:Interchange Part NumberCustom field in eBay.

  • Tag: “eBayInterchangePartNumber:<value>“
  • Metafield: ebay.interchange_part_number
C:Other Part NumberCustom field in eBay.

  • Tag: “eBayOtherPartNumber:<value>“
  • Metafield: ebay.other_part_number
C:Placement on VehicleCustom field in eBay.

  • Tag: “eBayPlacementOnVehicle:<value>“
  • Metafield: ebay.placement_on_vehicle
C:Surface FinishCustom field in eBay.

  • Tag: “eBaySurfaceFinish:<value>“
  • Metafield: ebay.surface_finish
C:WarrantyCustom field in eBay.

  • Tag: “eBayWarranty:<value>“
  • Metafield: ebay.warranty
C:Bundle ListingCustom field in eBay.

  • Tag: “eBayBundleListing:<value>“
  • Metafield: ebay.bundle_listing
C:Fitment TypeCustom field in eBay.

  • Tag: “eBayFitmentType:<value>“
  • Metafield: ebay.fitment_type
C:MaterialMetalCustom field in eBay.

  • Tag: “eBayMaterial:<value>“
  • Metafield: ebay.material
C:ColorRedCustom field in eBay.

  • Tag: “eBayColor:<value>“
  • Metafield: ebay.color
C:FeaturesCustom field in eBay.

  • Tag: “eBayFeatures:<value>“
  • Metafield: ebay.features
C:Bed LengthCustom field in eBay.

  • Tag: “eBayBedLength:<value>“
  • Metafield: ebay.bed_length
C:Mounting Hardware IncludedCustom field in eBay.

  • Tag: “eBayMountingHardwareIncluded:<value>“
  • Metafield: ebay.mounting_hardware_included
C:Attachment MethodCustom field in eBay.

  • Tag: “eBayAttachmentMethod:<value>“
  • Metafield: ebay.attachment_method
C:Country/Region of ManufactureCustom field in eBay.

  • Tag: “eBayCountryRegionOfManufacture:<value>“
  • Metafield: ebay.country_region_of_manufacture
C:Superseded Part NumberCustom field in eBay.

  • Tag: “eBaySupersededPartNumber:<value>“
  • Metafield: ebay.superseded_part_number
PicURLImage URLs joined with |Image Src
GalleryTypeFeatured
  • Tag: “eBayGalleryType:<value>“
  • Metafield: ebay.gallery_type
*DescriptionThis is really nice T-shirt, you will like it.Body HTML

All the newlines will be removed from the description according to eBay requirements.

*Format
Auction
  • Tag: “eBayFormat:<value>“
  • Metafield: ebay.format
*Duration
7
  • Tag: “eBayDuration:<value>“
  • Metafield: ebay.duration
*StartPrice
56.99
Variant Price
BuyItNowPrice
80.00
  • Tag: “eBayBuyItNowPrice:<value>“
  • Metafield: ebay.buy_it_now_price
*Quantity
20
Variant Inventory Quantity
PayPalAccepted
1
  • Tag: “eBayPaypalAccepted:<value>“
  • Metafield: ebay.paypal_accepted
PayPalEmailAddress[email protected]
  • Tag: “eBayPaypalEmailAddress:<value>“
  • Metafield: ebay.paypal_email_address
ImmediatePayRequired
1
  • Tag: “eBayImmediatePayRequired:<value>“
  • Metafield: ebay.immediate_pay_required
PaymentInstructions
  • Tag: “eBayPaymentInstructions:<value>“
  • Metafield: ebay.payment_instructions
*Location
FloridaUnitedStates
  • Tag: “eBayLocation:<value>“
  • Metafield: ebay.location
*ShippingType
Flat
  • Tag: “eBayShippingType:<value>“
  • Metafield: ebay.shipping_type
ShippingService-1:FreeShipping
1
  • Tag: “eBayShippingService1FreeShipping:<value>“
  • Metafield: ebay.shipping_service_1_free_shipping
ShippingService-1:Option
CA_ExpressShipping
  • Tag: “eBayShippingService1Option:<value>“
  • Metafield: ebay.shipping_service_1_option
ShippingService-1:Cost
3.99
  • Tag: “eBayShippingService1Cost:<value>“
  • Metafield: ebay.shipping_service_1_cost
ShippingService-2:Option
CA_StandardShipping
  • Tag: “eBayShippingService2Option:<value>“
  • Metafield: ebay.shipping_service_2_option
ShippingService-2:Cost
5.99
  • Tag: “eBayShippingService2Cost:<value>“
  • Metafield: ebay.shipping_service_2_cost
*DispatchTimeMax
2
  • Tag: “eBayDispatchTimeMax:<value>“
  • Metafield: ebay.dispatch_time_max
PromotionalShippingDiscount
1
  • Tag: “eBayPromotionalShippingDiscount:<value>“
  • Metafield: ebay.promotional_shipping_discount
ShippingDiscountProfileID
780385439
  • Tag: “eBayShippingDiscountProfileId:<value>“
  • Metafield: ebay.shipping_discount_profile_id
DomesticRateTable
Default
  • Tag: “eBayDomesticRateTable:<value>“
  • Metafield: ebay.domestic_rate_table
*ReturnsAcceptedOption
ReturnsAccepted
  • Tag: “eBayReturnsAcceptedOption:<value>“
  • Metafield: ebay.returns_accepted_option
ReturnsWithinOption
Days_30
  • Tag: “eBayReturnsWithinOption:<value>“
  • Metafield: ebay.returns_within_option
RefundOption
  • Tag: “eBayRefundOption:<value>“
  • Metafield: ebay.refund_option
ShippingCostPaidByOption
Buyer
  • Tag: “eBayShippingCostPaidByOption:<value>“
  • Metafield: ebay.shipping_cost_paid_by_option
AdditionalDetails
  • Tag: “eBayAdditionalDetails:<value>“
  • Metafield: ebay.additional_details
UseTaxTable
  • Tag: “eBayUseTaxTable:<value>“
  • Metafield: ebay.use_tax_table
WeightMajorVariant Weight
ShipFromZipCode
  • Tag: “eBayShipFromZipCode:<value>“
  • Metafield: ebay.ship_from_zip_code

Relationships for Variants

Relationship columns and rows are used to attach additional relationships for product Variants.

ExampleSource Field in Shopify
Relationship
Variation
RelationshipDetails
Color=Red|Size=S
Variant Options
Relationships for Car Part Fitments
Relationship columns and rows are also added for car part fitments.
Fitments will be generated from Product Tags which start with “Fit:” and contain the fitment information in the format:
Fit:<Year>|<Make>|<Model>|<Trim>
For example:
Fit:2015|Volvo|S80|CLI
ColumnExampleSource Field in Shopify
Relationship
Compatibility
RelationshipDetails
Make=Volvo|Model=S80|Year=2015|Trim=CLI
Tags starting with “Fit:”, containing fitment data.