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

Column Example Source 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
*Title T-shirt Product Title.

It will be cut off at 80 characters, according to eBay requirements.
Subtitle Very nice indeed
  • Tag: “eBaySubtitle:<value>“
  • Metafield: ebay.subtitle
*ConditionID 
1000
  • Tag: “eBayconditionId:<value>“
  • Metafield: ebay.condition_id

E.g. 1000 means “New”.
C:Type Car Custom field in eBay.

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

Taken from Shopify Product “Vendor” field.
*C:Manufacturer Part Number 
ABC-12345
 Custom field in eBay.

Taken from Shopify Product “Variant SKU” field.
C:Interchange Part Number Custom field in eBay.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Tag: “eBaySupersededPartNumber:<value>“
  • Metafield: ebay.superseded_part_number
PicURL Image URLs joined with | Image Src
GalleryType Featured
  • Tag: “eBayGalleryType:<value>“
  • Metafield: ebay.gallery_type
*Description This 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
WeightMajor Variant 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.








Example
Source 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






Column
Example
Source Field in Shopify






Relationship


Compatibility







RelationshipDetails


Make=Volvo|Model=S80|Year=2015|Trim=CLI


Tags starting with “Fit:”, containing fitment data.