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 | 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:
|
CustomLabel |
100001 |
Product Handle for Product rows.
Product Variant SKU for variant rows. |
*Category |
88433 |
Taken from Shopify Product:
Default value: 88433, “Everything Else > Every Other Thing”. To get the list of all eBay categories, download this eBay categories file. |
StoreCategory |
3014796013 |
|
*Title | T-shirt | Product Title.
It will be cut off at 80 characters, according to eBay requirements. |
Subtitle | Very nice indeed |
|
*ConditionID |
1000 |
E.g. 1000 means “New”. |
C:Type | Car | Custom field in eBay.
|
*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.
|
|
C:Other Part Number | Custom field in eBay.
|
|
C:Placement on Vehicle | Custom field in eBay.
|
|
C:Surface Finish | Custom field in eBay.
|
|
C:Warranty | Custom field in eBay.
|
|
C:Bundle Listing | Custom field in eBay.
|
|
C:Fitment Type | Custom field in eBay.
|
|
C:Material | Metal | Custom field in eBay.
|
C:Color | Red | Custom field in eBay.
|
C:Features | Custom field in eBay.
|
|
C:Bed Length | Custom field in eBay.
|
|
C:Mounting Hardware Included | Custom field in eBay.
|
|
C:Attachment Method | Custom field in eBay.
|
|
C:Country/Region of Manufacture | Custom field in eBay.
|
|
C:Superseded Part Number | Custom field in eBay.
|
|
PicURL | Image URLs joined with | | Image Src |
GalleryType | Featured |
|
*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 |
|
*Duration |
7 |
|
*StartPrice |
56.99 |
Variant Price |
BuyItNowPrice |
80.00 |
|
*Quantity |
20 |
Variant Inventory Quantity |
PayPalAccepted |
1 |
|
PayPalEmailAddress | [email protected] |
|
ImmediatePayRequired |
1 |
|
PaymentInstructions |
|
|
*Location |
FloridaUnitedStates |
|
*ShippingType |
Flat |
|
ShippingService-1:FreeShipping |
1 |
|
ShippingService-1:Option |
CA_ExpressShipping |
|
ShippingService-1:Cost |
3.99 |
|
ShippingService-2:Option |
CA_StandardShipping |
|
ShippingService-2:Cost |
5.99 |
|
*DispatchTimeMax |
2 |
|
PromotionalShippingDiscount |
1 |
|
ShippingDiscountProfileID |
780385439 |
|
DomesticRateTable |
Default |
|
*ReturnsAcceptedOption |
ReturnsAccepted |
|
ReturnsWithinOption |
Days_30 |
|
RefundOption |
|
|
ShippingCostPaidByOption |
Buyer |
|
AdditionalDetails |
|
|
UseTaxTable |
|
|
WeightMajor | Variant Weight | |
ShipFromZipCode |
|
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. |