ShipScript has been an eBay Community volunteer since 2003, specializing in HTML, CSS, Scripts, Photos, Active Content, Technical Solutions, and online Seller Tools.
1 BEST ANSWER
Accepted Solutions
Oh, I didn't realize you were creating a draft listing. Drafts are quite limited. You will get all of those errors because the draft template does not accept any additional columns except item specifics.
Do you really want only drafts, or do you just want something that you can manually edit to add the photos before posting?
Creating a full blown listing with a schedule will allow you to manually tweak the listing before it is visible. Use the template I posted and add a column for scheduling. When it posts to your scheduled listings, you can edit it there and then remove the scheduling.
ScheduleTime
2024-04-28T16:30:00
Are you manually uploading a spreadsheet through Seller Hub? It would be helpful to see your spreadsheet. It appears you are using File Exchange headings for most of these columns, while Seller Hub headings have spaces between words. Nonetheless, the File Exchange headings should also work in Seller Hub uploads.
1) Error: Location Missing.
PostalCode
33647
This is the correct format when the PostalCode column replaces the Location column, and Location must be omitted; otherwise, look for spaces or hidden characters in the data.
2) Error: A shipping service is not specified.
ShippingService-1:Option
US_eBayStandardEnvelope
This is correct; have you included related fields, like ShippingService-1:Cost (if Flat rate)? Are you including a PackageType of Envelope?
3) Error: Return policy is not specified.
ReturnsAcceptedOption
ReturnsNotAccepted
This appears to be correct, unless you are using Business Policies. There are dependencies if ReturnsAccepted.
4) Error: Condition data is required for selected category 261328.
Condition
Ungraded
CD:Card Condition - (ID: 40001)
Near mint or better
Card conditions are trickier. See card condition fields and values here:
https://www.shipscript.com/ebayhelp/sellerhub/example_card_revisions.htm
Notice that the number of digits increases down the cascade:
Condition
4000
CD:Card Condition - (ID: 40001)
400010
This forum addresses many questions of this type.
https://community.ebay.com/t5/Seller-Tools/bd-p/tools-apps-db
Did you download a trading card template from Seller Hub? That should get you started on the right path. The XLSX file includes droplists for many items. Starting from the left, completing a cell, or making a selection from the droplist inside each cell, could modify later cell requirements in that row.
I created a sample upload with 3 sorts of card listings, based on a template I had from last year, so this is not a new template download. Nonetheless, it fills in the basics so you can see what might be required for a successful upload.
https://shipscript.com/test/fileexchange/eBay-sport-trading-cards_example_APR-13-2024_ver3.csv
Please note that in my prior example I used the heading "Condition", which should have been "Condition ID".
Columns that you don't use can be removed from the template.
Oh, I didn't realize you were creating a draft listing. Drafts are quite limited. You will get all of those errors because the draft template does not accept any additional columns except item specifics.
Do you really want only drafts, or do you just want something that you can manually edit to add the photos before posting?
Creating a full blown listing with a schedule will allow you to manually tweak the listing before it is visible. Use the template I posted and add a column for scheduling. When it posts to your scheduled listings, you can edit it there and then remove the scheduling.
ScheduleTime
2024-04-28T16:30:00
Well, here's the cherry on top because that is a simple task:
<CENTER><H4>BARGAIN BIN: 2022 Topps Chrome Platinum Test Blue Prism Refractor Giants</H4></CENTER> <p>Our Bargain Bin items are designed to cost as little as possible for you, usually less than $1.50. This includes low cost shipping which is just $1.00 (+$.50) for each additional item. In order to keep costs low, your card(s) will be shipped using ebay standard envelope protected by a semi-rigid card holder. If you make multiple purchases and pay the full shipping, we will refund any overage. We cannot accept returns or guarantee the items using the ebay standard envelope shipping method for these Bargain Bin cards. If you choose to buy five or more cards, we will automatically upgrade the shipping to Ground Advantage.</p>
I've allowed the centered title to remain, but no one likes a centered paragraph because it is too difficult to read.
However, I would like to take it one step further and limit the width of the text to avoid ping-pong reading syndrome.
<div style="max-width:700px; margin:auto"><CENTER><H4>BARGAIN BIN: 2022 Topps Chrome Platinum Test Blue Prism Refractor Giants</H4></CENTER> <p>Our Bargain Bin items are designed to cost as little as possible for you, usually less than $1.50. This includes low cost shipping which is just $1.00 (+$.50) for each additional item. In order to keep costs low, your card(s) will be shipped using ebay standard envelope protected by a semi-rigid card holder. If you make multiple purchases and pay the full shipping, we will refund any overage. We cannot accept returns or guarantee the items using the ebay standard envelope shipping method for these Bargain Bin cards. If you choose to buy five or more cards, we will automatically upgrade the shipping to Ground Advantage.</p></div>
Just copy what I pasted into a cell and make sure it is one continuously wrapping line with no hard line breaks. But perhaps you are asking for concatenation automation.
First, there is an HTML error in the original code. I don't know how you want to deal with that. The <CENTER> tags encompassing the title are block-level elements around the <H4> block-level heading. Your example then puts some other block-level <p>, <P>, and </P> fragments before and aft. Can you purge those P tags (or at least the very first one)?
If you can, then put your boilerplate paragraph in an adjacent cell and ask Excel to combine them into yet a third cell.
| A | B | =CONCAT(A2:B2) | |
| 1 | Part1 | Part2 | Description |
| 2 | <center><h4>title</h4></center> | <p>boilerplate</p> | <center><h4>title</h4></center><p>boilerplate<p> |
But that doesn't take into effect the wrapper <div> that I offered, so there may be four cells to concatenate into a fifth cell:
| A | B | C | D | =CONCAT(A2:D2) | |
| 1 | Part1 | Part2 | Part3 | Part4 | Description |
| 2 | <div style=....> | <center><h4>title</h4></center> | <p>boilerplate</p> | </div> | <div...><center><h4>title</h4></center><p>boilerplate</p></div> |
After you export as CSV, you can open again and delete all the constructor columns and use the resultant column as the description.
