Get Excelify now
Get Excelify now

eBay: File Exchange – Advanced Template

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

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 Source Field in Shopify
*Action(
SiteID=YourSite|
Country=CA|
Currency=USD|
Version=745|
CC=UTF-8
)
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.

Add
CustomLabel
  • Product Handle for Product rows.
  • Product Variant SKU for variant rows.

100001
*Category 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.

88433
StoreCategory
  • Tag: “eBayStoreCategory:<value>
  • Metafield: ebay.store_category

3014796013
*Title Product Title.

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

T-shirt
Subtitle
  • Tag: “eBaySubtitle:<value>
  • Metafield: ebay.subtitle

Very nice indeed
*ConditionID
  • Tag: “eBayconditionId:<value>
  • Metafield: ebay.condition_id

E.g. 1000 means “New”.

1000
C:Type Custom field in eBay.

  • Tag: “eBayType:<value>
  • Metafield: ebay.type

Car
*C:Brand Custom field in eBay.Taken from Shopify Product “Vendor” field.

Volvo
*C:MPN Custom field in eBay.Taken from Shopify Product “Variant SKU” field.

ABC-12345
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 Custom field in eBay.

  • Tag: “eBayMaterial:<value>
  • Metafield: ebay.material
C:Color 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 Src

Image URLs joined with |

GalleryType
  • Tag: “eBayGalleryType:<value>
  • Metafield: ebay.gallery_type

Featured
*Description Body HTMLAll the newlines will be removed from the description according to eBay requirements.
*Format
  • Tag: “eBayFormat:<value>
  • Metafield: ebay.format

Auction
*Duration
  • Tag: “eBayDuration:<value>
  • Metafield: ebay.duration

7
*StartPrice Variant Price

56.99
BuyItNowPrice
  • Tag: “eBayBuyItNowPrice:<value>
  • Metafield: ebay.buy_it_now_price

80.00
*Quantity Variant Inventory Quantity

20
PayPalAccepted
  • Tag: “eBayPaypalAccepted:<value>
  • Metafield: ebay.paypal_accepted

1
PayPalEmailAddress
  • Tag: “eBayPaypalEmailAddress:<value>
  • Metafield: ebay.paypal_email_address

[email protected]
ImmediatePayRequired
  • Tag: “eBayImmediatePayRequired:<value>
  • Metafield: ebay.immediate_pay_required

1
PaymentInstructions
  • Tag: “eBayPaymentInstructions:<value>
  • Metafield: ebay.payment_instructions
*Location
  • Tag: “eBayLocation:<value>
  • Metafield: ebay.location

FloridaUnitedStates
*ShippingType
  • Tag: “eBayShippingType:<value>
  • Metafield: ebay.shipping_type

Flat
ShippingService-1:FreeShipping
  • Tag: “eBayShippingService1FreeShipping:<value>
  • Metafield: ebay.shipping_service_1_free_shipping

1
ShippingService-1:Option
  • Tag: “eBayShippingService1Option:<value>
  • Metafield: ebay.shipping_service_1_option

CA_ExpressShipping
ShippingService-1:Cost
  • Tag: “eBayShippingService1Cost:<value>
  • Metafield: ebay.shipping_service_1_cost

3.99
ShippingService-2:Option
  • Tag: “eBayShippingService2Option:<value>
  • Metafield: ebay.shipping_service_2_option

CA_StandardShipping
ShippingService-2:Cost
  • Tag: “eBayShippingService2Cost:<value>
  • Metafield: ebay.shipping_service_2_cost

5.99
*DispatchTimeMax
  • Tag: “eBayDispatchTimeMax:<value>
  • Metafield: ebay.dispatch_time_max

2
PromotionalShippingDiscount
  • Tag: “eBayPromotionalShippingDiscount:<value>
  • Metafield: ebay.promotional_shipping_discount

1
ShippingDiscountProfileID
  • Tag: “eBayShippingDiscountProfileId:<value>
  • Metafield: ebay.shipping_discount_profile_id

780385439
DomesticRateTable
  • Tag: “eBayDomesticRateTable:<value>
  • Metafield: ebay.domestic_rate_table

Default
*ReturnsAcceptedOption
  • Tag: “eBayReturnsAcceptedOption:<value>
  • Metafield: ebay.returns_accepted_option

ReturnsAccepted
ReturnsWithinOption
  • Tag: “eBayReturnsWithinOption:<value>
  • Metafield: ebay.returns_within_option

Days_30
RefundOption
  • Tag: “eBayRefundOption:<value>
  • Metafield: ebay.refund_option
ShippingCostPaidByOption
  • Tag: “eBayShippingCostPaidByOption:<value>
  • Metafield: ebay.shipping_cost_paid_by_option

Buyer
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.

Source Field in Shopify
Relationship

Variation
RelationshipDetails Variant Options

Color=Red|Size=S

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 Source Field in Shopify
Relationship

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

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