eBay

Anonymous · ‎10-29-2023

Hello all,

I am trying to use the bulk upload tool to list many trading cards at once. I thought I had done everything right, but am still getting errors back. Can anyone assist me with this? I think the documentation is very out of date as well.

Error - Input data for tag <Item.ListingType> is invalid or missing. Please check API documentation.|Item.ListingType|

Error - You've provided an invalid return policy.||Error - A return option is missing or not valid. Update your return options.|ReturnsAcceptedOption||Error - A return option is missing or not valid. Update your return options.|ReturnsWithinOption||Error - A return option is missing or not valid. Update your return options.|ShippingCostPaidByOption||Error - You've provided an invalid payment policy.||Error - Condition data is required for selected category 183454.|Condition data is required for selected category 183454.|Condition data is required for selected category 183454.||Error - Picture URL has no file name.||Error - Gallery URL has no file name.||Error - The package weight is not valid or is missing. Provide a valid number for the weight.||Error - Please enter valid dimensions for your package.||Error - Please enter a valid postal code.|

Here is the data that I am testing with:

Info

Version=1.0.0

Template=fx_category_template_EBAY_US

*Action(SiteID=US|Country=US|Currency=USD|Version=1193|CC=UTF-8)

CustomLabel

*Category

StoreCategory

*Title

Subtitle

Relationship

RelationshipDetails

*ConditionID

CD:Professional Grader - (ID: 27501)

CD:Grade - (ID: 27502)

CDA:Certification Number - (ID: 27503)

CD:Card Condition - (ID: 40001)

*C:Game

*C:Card Name

*C:Character

*C:Card Type

C:Grade

C:Speciality

*C:Set

C:Age Level

*C:Features

*C:Rarity

*C:Attribute/MTG:Color

*C:Finish

*C:Manufacturer

*C:Creature/Monster Type

*C:Autographed

*C:Card Number

C:Language

C:Card Size

C:Year Manufactured

C:Graded

C:Stage

C:Professional Grader

C:Material

C:Card Condition

C:Vintage

C:Country/Region of Manufacture

C:Signed By

C:Convention/Event

C:Autograph Format

C:Autograph Authentication

C:Certification Number

C:Illustrator

C:HP

C:Attack/Power

C:Defense/Toughness

C:California Prop 65 Warning

C:Cost

C:Autograph Authentication Number

PicURL

GalleryType

*Description

*Format

*Duration

*StartPrice

BuyItNowPrice

*Quantity

PayPalAccepted

PayPalEmailAddress

ImmediatePayRequired

PaymentInstructions

*Location

ShippingType

ShippingService-1:Option

ShippingService-1:Cost

ShippingService-2:Option

ShippingService-2:Cost

*DispatchTimeMax

PromotionalShippingDiscount

ShippingDiscountProfileID

*ReturnsAcceptedOption

ReturnsWithinOption

RefundOption

ShippingCostPaidByOption

AdditionalDetails

ShippingProfileName

ReturnProfileName

PaymentProfileName

ProductCompliancePolicyID

Regional ProductCompliancePolicies

Add

183454

41640432016

Magic: The Gathering - Single Card - Theros Beyond Death - Mountain

Finish your collection with this amazing Mountain!

Near Mint or Better

400010

Magic: The Gathering

Mountain

Magic: The Gathering

Theros Beyond Death

6+

Single

common

Non-Foil

Wizards of the Coast

253

English

Standard

2020

0

Stage 1

Card Stock

Near Mint or Better

No

United States

https://ecommerce-tools-pkm-singles-card-id-bkt/|https://ecommerce-tools-pkm-singles-card-id-bkt/

Now's your chance to get this special collector item! Our single cards are sleeved IMMEDIATELY upon acquisition, photographed, and then sleeved again in a rigid hard sleeve, and stored in a cool, dry place.

!!! IMPORTANT SHIPPING INFORMATION !!!
Due to the expensive nature of shipping:

If your card's value is under $20, you have the option of selecting the 'eBay Standard Envelope' service. Your card will be shipped in a standard mailing envelope in a *hard sleeve + soft sleeve + pull tab*. The hard sleeve will be taped shut to avoid the card coming out in transit.
You may elect to pay for USPS Ground Advantage OR Fedex Express Mailing, in which case your card will be wrapped in additional layers of protection and placed in a bubble mailer envelope.

All cards over $20 in value will be wrapped in additional layers of protection and placed in a bubble mailer envelope for a standard shipping fee.

If you would like us to ship your card in a *Card Saver* sleeve (semi-rigid) instead of a rigid sleeve, please ask for us to do so in the comments when making your purchase.

BuyItNow

GTC

1.99

1

0

1

East Amherst, NY

Card Singles - Under $20 - eBay Standard Envelope

All Returns Accepted

Default Payment Policy

Add

183454

41640431016

Pokémon TCG - Single Card - Ultra Shiny GX - Kartana GX

Finish your collection with this amazing Kartana GX!

Near Mint or Better

400010

Pokémon TCG

Kartana GX

Pokémon TCG

Ultra Shiny GX

6+

Single

Foil/Holo

Nintendo

235

Japanese

Standard

2018

0

UPDATE_STAGE

Card Stock

Near Mint or Better

No

Japan

https://ecommerce-tools-pkm-singles-card-id-bkt/|https://ecommerce-tools-pkm-singles-card-id-bkt/

Now's your chance to get this special collector item! Our single cards are sleeved IMMEDIATELY upon acquisition, photographed, and then sleeved again in a rigid hard sleeve, and stored in a cool, dry place.

!!! IMPORTANT SHIPPING INFORMATION !!!
Due to the expensive nature of shipping:

If your card's value is under $20, you have the option of selecting the 'eBay Standard Envelope' service. Your card will be shipped in a standard mailing envelope in a *hard sleeve + soft sleeve + pull tab*. The hard sleeve will be taped shut to avoid the card coming out in transit.
You may elect to pay for USPS Ground Advantage OR Fedex Express Mailing, in which case your card will be wrapped in additional layers of protection and placed in a bubble mailer envelope.

All cards over $20 in value will be wrapped in additional layers of protection and placed in a bubble mailer envelope for a standard shipping fee.

If you would like us to ship your card in a *Card Saver* sleeve (semi-rigid) instead of a rigid sleeve, please ask for us to do so in the comments when making your purchase.

Auction

10

0.99

1

0

East Amherst, NY

Card Singles - Under $20 - eBay Standard Envelope

All Returns Accepted

Default Payment Policy

shipscript · ‎10-29-2023

@Anonymous

It appears that the biggest mismatch surrounds Business Policies. Have you set up your three business policies in Seller Hub for Shipping, Payment, and Returns? If so, then enter those policy names exactly as they appear on your Business policy page (capitalization, punctuation, and spaces).

If you have not defined any business policies, then leave those profile columns empty and fill in all of the other columns associated with shipping, payment, and returns.

Does your shipping specify calculated shipping? If so, packaging fields are required.

See this thread:

https://community.ebay.com/t5/Seller-Tools/File-Exchange-Template-Shipping-Error/m-p/34035903#M44711

Next issue is the ConditionID:

For ungraded trading cards, the column labeled "ConditionID" should be populated with the number: 4000, rather than a condition description. The GalleryType is not needed for Collectibles.

ListingType is the "Format" column, with Auction or FixedPrice (not BuyItNow).

The PicURL column contains an invalid site and a non-image URL. You can use a dummy URL and revise later, as long as it is formatted like a picture URL.

eBay's downloadable XLSX template for trading cards includes hidden pages that respond to macro commands to populate column cells with data. Those are activated by starting with the category selection and then the Condition ID (left to right). When those are selected, the individual cells under the column labels will contain droplists of available options.

I've color-coded an eBay spreadsheet for trading cards, grouped columns together, and populated with some examples, to help sellers determine which columns need to be populated and what values are expected. Because I've rearranged, eBay's macros may not function.

https://shipscript.com/ebayhelp/file_exchange/eBay-category-listing-sport-trading-cards_example_8SEP2023.xlsx

ShipScript has been an eBay Community volunteer since 2003, specializing in HTML, CSS, Scripts, Photos, Active Content, Technical Solutions, and online Seller Tools.

View Best Answer in original post

kensgiftshop · ‎10-29-2023

How many are you trying to upload?

Is it within your listing limits?

As far as the bulk uploader, never used it so can't be any help there.

Have a great day.

Anonymous · ‎10-29-2023

Only two listings for testing purposes, however I have a business account and so have 75k item limit. that's not the issue.

The issue is that the template I got from eBay doesn't seem to match up with what the uploader requires, and the documentation is wildly out of date.

Do you know of any alternative means of uploading lots of listings at once using CSV data?

kensgiftshop · ‎10-29-2023

Sorry, no, but maybe @shipscript can help.

Have a great day.

shipscript · ‎10-29-2023

@Anonymous

It appears that the biggest mismatch surrounds Business Policies. Have you set up your three business policies in Seller Hub for Shipping, Payment, and Returns? If so, then enter those policy names exactly as they appear on your Business policy page (capitalization, punctuation, and spaces).

If you have not defined any business policies, then leave those profile columns empty and fill in all of the other columns associated with shipping, payment, and returns.

Does your shipping specify calculated shipping? If so, packaging fields are required.

See this thread:

https://community.ebay.com/t5/Seller-Tools/File-Exchange-Template-Shipping-Error/m-p/34035903#M44711

Next issue is the ConditionID:

For ungraded trading cards, the column labeled "ConditionID" should be populated with the number: 4000, rather than a condition description. The GalleryType is not needed for Collectibles.

ListingType is the "Format" column, with Auction or FixedPrice (not BuyItNow).

The PicURL column contains an invalid site and a non-image URL. You can use a dummy URL and revise later, as long as it is formatted like a picture URL.

eBay's downloadable XLSX template for trading cards includes hidden pages that respond to macro commands to populate column cells with data. Those are activated by starting with the category selection and then the Condition ID (left to right). When those are selected, the individual cells under the column labels will contain droplists of available options.

I've color-coded an eBay spreadsheet for trading cards, grouped columns together, and populated with some examples, to help sellers determine which columns need to be populated and what values are expected. Because I've rearranged, eBay's macros may not function.

https://shipscript.com/ebayhelp/file_exchange/eBay-category-listing-sport-trading-cards_example_8SEP2023.xlsx

ShipScript has been an eBay Community volunteer since 2003, specializing in HTML, CSS, Scripts, Photos, Active Content, Technical Solutions, and online Seller Tools.

Anonymous · ‎10-29-2023

@shipscript this is seriously great! Thank you so so SO much for your insight. I will see about adding all of this in when I have time to sit down with it. Will let you know if I hit any snags. Once again, thanks very much.

shipscript · ‎10-29-2023

Post back if you encounter problems. 🙂

ShipScript has been an eBay Community volunteer since 2003, specializing in HTML, CSS, Scripts, Photos, Active Content, Technical Solutions, and online Seller Tools.

Anonymous · ‎10-29-2023

Hi @shipscript , I tried replying before but it seems it didn't 'take'.

Your advice got me past most of the errors, so thanks very much! Now I am encountering an error regarding pricing.

I want to follow the basic logic of:

1. If I don't know the value of the card, list it as an auction at $0.99

2. If I know the value and it is over $1, list it as the market value with ".99" appended. So all the prices end up as "X.99".

Here is my code (PowerShell Core):

$SingleListing | Add-Member -MemberType NoteProperty -Name "ListingType" -Value $(
    switch ($SingleCardListing.CardListingTypeParams.ListingType) {
        "Auction" { "Auction" }
        "GTC" { "FixedPrice" }
    }
)
$SingleListing | Add-Member -MemberType NoteProperty -Name "Duration" -Value $(
    switch ($SingleCardListing.CardListingTypeParams.ListingType) {
        "Auction" { 10 }
        "GTC" { "GTC" }
    }
)
$SingleListing | Add-Member -MemberType NoteProperty -Name "StartPrice" -Value $(
    switch ($SingleCardListing.CardListingTypeParams.ListingType) {
        "Auction" { $SingleCardListing.CardListingTypeParams.StartPrice }
        "GTC" { $null }
    }
)
$SingleListing | Add-Member -MemberType NoteProperty -Name "BuyItNowPrice" -Value $(
    switch ($SingleCardListing.CardListingTypeParams.ListingType) {
        "Auction" { $null }
        "GTC" { $SingleCardListing.CardListingTypeParams.StartPrice }
    }
)

The current error I am getting is:

ErrorCode	ErrorMessage
307	Error - You have entered invalid start price or Buy It Now price.\|

Do you have any advice on how to properly enter the prices for both auctions and GTC? I also want to make sure my auctions do not have a 'Buy It Now' price.

I also seem to be having trouble posting because it keeps saying my HTML is not valid, so let me know if I need to provide a link to the data or spreadsheet, happy to do so.

shipscript · ‎10-29-2023

@Anonymous

Both Auction and GTC use "StartPrice" to define the initial item price (so no 'switch' selector necessary). The "BuyItNowPrice" is reserved for auctions, and since you don't want that in auctions, remove the BuyItNowPrice column entirely from your spreadsheet.

For posting here on the forums, use the "preview" function to strip disallowed copy/pasted HTML from your post. We get that error all the time and I habitually use "preview" if I've copied from elsewhere. Some types of HTML just won't strip after "preview", so I paste to a text editor and copy/paste from there. It appears you have found the </> raw code option.

ShipScript has been an eBay Community volunteer since 2003, specializing in HTML, CSS, Scripts, Photos, Active Content, Technical Solutions, and online Seller Tools.

Anonymous · ‎10-30-2023

Whew. After some digging I finally got most of it worked out. But still hitting a few snags.

For my GTC listing, it keeps telling me to enter valid dimensions for my package.

Based on the value of the card, I have two business policies:

Under $20 - Selections include eBay Std Envelope, USPS, or Fedex (in case the buyers wish to pay more for shipping in a bubble mailer)

Over $20 - Selections include USPS or Fedex.

$SingleListing | Add-Member -MemberType NoteProperty -Name "ShippingProfileName" -Value $(
    switch ($SingleCardListing.CardListingTypeParams.StartPrice) {
        { $_ -gt 20 } { "Card Singles - Over `$20" }
        default { "Card Singles - Under `$20 - eBay Standard Envelope" }
    }
)

For both postings (Auction and GTC) I see the following:

ErrorMessage

Error - Please enter valid dimensions for your package.|

Here is what I currently have for these values (which were completely absent from the documentation, thanks eBay)

$SingleListing | Add-Member -MemberType NoteProperty -Name "WeightMajor" -Value 0
$SingleListing | Add-Member -MemberType NoteProperty -Name "WeightMinor" -Value 2
$SingleListing | Add-Member -MemberType NoteProperty -Name "WeightUnit" -Value "lb"
$SingleListing | Add-Member -MemberType NoteProperty -Name "PackageLength" -Value 6
$SingleListing | Add-Member -MemberType NoteProperty -Name "PackageWidth" -Value 0
$SingleListing | Add-Member -MemberType NoteProperty -Name "PackageHeight" -Value 4

The second issue is I am still getting an error on the 'BuyItNow' price for the Auctions.

I tried using two different business policies, one with 'Must Pay Immediately' and one without, but on both I get this error:

Error - To require immediate payment, you must specify a Buy It Now price.

I took your suggestion and removed the column from my spreadsheet entirely, as I thought the business policies would take care of it.

Thoughts?

shipscript · ‎10-30-2023

My apologies - it appears I typoed that reference thread.

The package dimensions should be:

PackageLength

PackageWidth

PackageDepth

I typically put the zero value in PackageDepth.

Error - To require immediate payment, you must specify a Buy It Now price.

Usually, eBay simply issues a warning that IPR will not be applied to an auction, and it is not a show stopper. But I've only seen the warning when not using business policies (I don't have policies enabled).

Gotta run. I'll check back later.

ShipScript has been an eBay Community volunteer since 2003, specializing in HTML, CSS, Scripts, Photos, Active Content, Technical Solutions, and online Seller Tools.

Anonymous · ‎10-30-2023

@shipscript appreciate all you do, my friend.

I got a GTC to list correctly! Woo!

My auction listing is still saying:

Action	Status	ErrorCode	ErrorMessage
Add	Failure	21917141	Error - To require immediate payment, you must specify a Buy It Now price.\|

Here is the relevant data. The first entry fails, the second one succeeds.

Action

CustomLabel

Category

StoreCategory

Title

SubTitle

Relationship

RelationshipDetails

ConditionID

CD:Professional Grader - (ID: 27501)

CD:Grade - (ID: 27502)

CDA:Certification Number - (ID: 27503)

CD:Card Condition - (ID: 40001)

C:Game

C:Card Name

C:Character

C:Card Type

C:Grade

C:Speciality

C:Set

C:Age Level

C:Feature

C:Rarity

Attribute/MTG:Color

Finish

Manufacturer

Creature/Monster Type

Autographed

Card Number

Language

Card Size

Year Manufactured

Graded

Stage

Professional Grader

Material

Card Condition

Vintage

Country/Region of Manufacture

Signed By

Convention/Event

Autograph Format

Autograph Authentication

Certification Number

Illustrator

HP

Attack/Power

Defense/Toughness

California Prop 65 Warning

Cost

Autograph Authentication Number

PicURL

GalleryType

Description

ListingType

Duration

StartPrice

Quantity

PayPalAccepted

PayPalEmailAddress

PaymentInstructions

Location

PostalCode

ShippingType

ShippingService-1:Option

ShippingService-1:Cost

ShippingService-2:Option

ShippingService-2:Cost

DispatchTimeMax

PromotionalShippingDiscount

ShippingDiscountProfileID

ReturnsAcceptedOption

ReturnsWithinOption

RefundOption

ShippingCostPaidByOption

AdditionalDetails

ShippingProfileName

WeightMajor

WeightMinor

WeightUnit

PackageType

ReturnProfileName

PaymentProfileName

ProductCompliancePolicyID

Regional ProductCompliancePolicies

Add

183454

41640431016

Card Single - Ashs Pikachu

Sun & Moon Promos - #SM114

4000

Near Mint or Better -(ID: 400010)

Pokémon TCG

Ashs Pikachu

Pokémon TCG

Sun & Moon Promos

6+

Single

Promo

Lightning

Regular

Nintendo

SM114

English

Standard

2018

0

Card Stock

Near Mint or Better

0

United States

https://ecommerce-tools-pkm-singles-card-id-bkt/IMG_4010.JPG|https://ecommerce-tools-pkm-singles-card-id-bkt/IMG_4011.JPG

Now's your chance to get this special collector item! Our single cards are sleeved IMMEDIATELY upon acquisition, photographed, and then sleeved again in a rigid hard sleeve, and stored in a cool, dry place.

!!! IMPORTANT SHIPPING INFORMATION !!!
Due to the expensive nature of shipping:

If your card's value is under $20, you have the option of selecting the 'eBay Standard Envelope' service. Your card will be shipped in a standard mailing envelope in a *hard sleeve + soft sleeve + pull tab*. The hard sleeve will be taped shut to avoid the card coming out in transit.
You may elect to pay for USPS Ground Advantage OR Fedex Express Mailing, in which case your card will be wrapped in additional layers of protection and placed in a bubble mailer envelope.

All cards over $20 in value will be wrapped in additional layers of protection and placed in a bubble mailer envelope for a standard shipping fee.

If you would like us to ship your card in a *Card Saver* sleeve (semi-rigid) instead of a rigid sleeve, please ask for us to do so in the comments when making your purchase.

Auction

10

0.99

1

0

14051

Card Singles - Under $20 - eBay Standard Envelope

0

1

lb

Letter

Default - All Returns Accepted

Default - Payment Policy

Add

183454

41640432016

Card Single - Athreos, Shroud-Veiled

Theros Beyond Death - #269

4000

Near Mint or Better -(ID: 400010)

Magic: The Gathering

Athreos, Shroud-Veiled

Magic: The Gathering

Theros Beyond Death

6+

Single

mythic

Foil

Wizards of the Coast

269

English

Standard

2020

0

Card Stock

Near Mint or Better

0

United States

https://ecommerce-tools-pkm-singles-card-id-bkt/IMG_3823.JPG|https://ecommerce-tools-pkm-singles-card-id-bkt/IMG_3824.JPG

Now's your chance to get this special collector item! Our single cards are sleeved IMMEDIATELY upon acquisition, photographed, and then sleeved again in a rigid hard sleeve, and stored in a cool, dry place.

!!! IMPORTANT SHIPPING INFORMATION !!!
Due to the expensive nature of shipping:

If your card's value is under $20, you have the option of selecting the 'eBay Standard Envelope' service. Your card will be shipped in a standard mailing envelope in a *hard sleeve + soft sleeve + pull tab*. The hard sleeve will be taped shut to avoid the card coming out in transit.
You may elect to pay for USPS Ground Advantage OR Fedex Express Mailing, in which case your card will be wrapped in additional layers of protection and placed in a bubble mailer envelope.

All cards over $20 in value will be wrapped in additional layers of protection and placed in a bubble mailer envelope for a standard shipping fee.

If you would like us to ship your card in a *Card Saver* sleeve (semi-rigid) instead of a rigid sleeve, please ask for us to do so in the comments when making your purchase.

FixedPrice

GTC

4.99

1

0

14051

Card Singles - Under $20 - eBay Standard Envelope

0

1

lb

Letter

Default - All Returns Accepted

Default - Payment Policy

I've tried to exclude the column as you suggested previously, tried including it with a value of '0', tried messing with the Business Policies by changing the toggle for BuyItNow on/off. No dice at all.

Anonymous · ‎10-30-2023

Hello @shipscript . Once gain, huge help!

My GTC listing went through! Woohoo!

For my auction listing, it still throws the following error message and I can't think as to why. I've tried toying with the payment policy by toggling immediate pay on/off, I've tried your suggestion of omitting the column entirely, or setting it to 1 or 0 either way. No luck. Any thoughts?

ErrorCode	ErrorMessage
21917141	Error - To require immediate payment, you must specify a Buy It Now price.\|

As an aside: Do you happen to know the correct character to include so that the description field includes newlines / returns?

shipscript · ‎10-30-2023

Great news on the GTC listing!

For the description, use HTML codes to format the text. Thus <br> would be a newline (break). Below is an example single line of code that is compatible with the spreadsheet uploader and that will maintain paragraphs (<p>...</p>) and internal line breaks (<br>).

<p>Now's your chance to get this special collector item! Our single cards are sleeved IMMEDIATELY upon acquisition, photographed, and then sleeved again in a rigid hard sleeve, and stored in a cool, dry place.</p><p>!!! IMPORTANT SHIPPING INFORMATION !!!<br>Due to the expensive nature of shipping:</p><p>If your card's value is under $20, you have the option of selecting the 'eBay Standard Envelope' service. Your card will be shipped in a standard mailing envelope in a *hard sleeve + soft sleeve + pull tab*. The hard sleeve will be taped shut to avoid the card coming out in transit.You may elect to pay for USPS Ground Advantage OR Fedex Express Mailing, in which case your card will be wrapped in additional layers of protection and placed in a bubble mailer envelope.</p><p>All cards over $20 in value will be wrapped in additional layers of protection and placed in a bubble mailer envelope for a standard shipping fee.</p><p>If you would like us to ship your card in a *Card Saver* sleeve (semi-rigid) instead of a rigid sleeve, please ask for us to do so in the comments when making your purchase.</p>

One way to create your default text is to write your description in eBay's description editor, switch to the HTML view to copy the code, and then pull it all together into a single line of text/code for the spreadsheet cell. eBay FileExchange (now Seller Hub Uploads) has a tool to condense the code, but It didn't add spaces at the end of paragraphs and a few other small gotchas, so I posted a tool here to more completely perform that task.

https://www.isdntek.com/listingtools/compress.htm

To condense code to paste into a spreadsheet cell for Seller Hub, use the "condense" button on the tool.

Since IPR (immediate payment reqd) can not be applied to an auction, and since your auctions will not have a BIN (buy-it-now) option to which an IPR could be applied, it looks like the only option is to provide a payment policy that does not have IPR turned on.

Since your goal is to let the market set your auction item prices, it would defeat that goal to include a BuyItNow price. Thus, you will need a payment option without IPR.

As I don't have Policies turned on, I can't test any of that for you, but that is certainly where the logic leads.

ShipScript has been an eBay Community volunteer since 2003, specializing in HTML, CSS, Scripts, Photos, Active Content, Technical Solutions, and online Seller Tools.