01-30-2023 08:36 PM
I am trying to create and upload eBay excel file, getting multiple errors and dont know whats going on errors are as follows:
Error - Variation Specifics provided does not match with the variation specifics of the variations on the item.||Error - Missing name in the variation specifics or variation specifics set.|
I have T-shirt template, I will post excel below: what am I doing wrong, also another issue I cant generate template for T-shirts category its not listed on eBay so I chose Sweater instead and probably will update in bulk once listed.
Add | MEN-FP-DesignName | /Clothing, Shoes & Accessories/Men/Men's Clothing/Sweaters | Mens Funny T-shirt | Color=Black|Size:S;M;L;XL;2XL;3XL;4XL;5XL | https://i.imgur.com/JotWTQa.jpg|https://i.imgur.com/Ius0L3j.jpg | 1000-New with tags | test description | FixedPrice | GTC | 1 | salomebeshidze@yahoo.com | 1 | Princeton,NJ | USPSFirstClass | 0 | 1 | USPSPriority | 5.99 | 2 | 1 | ReturnsAccepted | Days_30 | MoneyBackOrExchange | Seller | Silver Lake T-shirts | Full Zip | Sweater | Regular | Black | Men | Cotton | Crew Neck | Funny|halloween | Biden|trump | All Seasons | United States | ||||||||||||||||||||
MEN-FP-DesignName-SML-BLK | Mens Funny T-shirt | Variation | Color=Black|Size=S | 18.99 | 499 | |||||||||||||||||||||||||||||||||||||||||||||||||||
MEN-FP-DesignName-MED-BLK | Mens Funny T-shirt | Variation | Color=Black|Size=M | 18.99 | 499 | |||||||||||||||||||||||||||||||||||||||||||||||||||
MEN-FP-DesignName-LRG-BLK | Mens Funny T-shirt | Variation | Color=Black|Size=L | 18.99 | 499 | |||||||||||||||||||||||||||||||||||||||||||||||||||
MEN-FP-DesignName-XLG-BLK | Mens Funny T-shirt | Variation | Color=Black|Size=XL | 18.99 | 499 | |||||||||||||||||||||||||||||||||||||||||||||||||||
MEN-FP-DesignName-2XL-BLK | Mens Funny T-shirt | Variation | Color=Black|Size=2XL | 19.99 | 499 | |||||||||||||||||||||||||||||||||||||||||||||||||||
MEN-FP-DesignName-3XL-BLK | Mens Funny T-shirt | Variation | Color=Black|Size=3XL | 20.99 | 499 | |||||||||||||||||||||||||||||||||||||||||||||||||||
MEN-FP-DesignName-4XL-BLK | Mens Funny T-shirt | Variation | Color=Black|Size=4XL | 21.99 | 499 | |||||||||||||||||||||||||||||||||||||||||||||||||||
MEN-FP-DesignName-5XL-BLK | Mens Funny T-shirt | Variation | Color=Black|Size=5XL | 21.99 | 499 | |||||||||||||||||||||||||||||||||||||||||||||||||||
Solved! Go to Best Answer
01-31-2023 08:04 AM
The master record is formatted incorrectly with a colon instead of equal sign:
Color=Black|Size:S;M;L;XL;2XL;3XL;4XL;5XL
You can use a common template for similar items. Just remove the columns that do not relate to your item.
If you encounter other errors, feel free to post on the "seller tools" forum.
https://community.ebay.com/t5/Seller-Tools/bd-p/tools-apps-db
01-31-2023 08:04 AM
The master record is formatted incorrectly with a colon instead of equal sign:
Color=Black|Size:S;M;L;XL;2XL;3XL;4XL;5XL
You can use a common template for similar items. Just remove the columns that do not relate to your item.
If you encounter other errors, feel free to post on the "seller tools" forum.
https://community.ebay.com/t5/Seller-Tools/bd-p/tools-apps-db
01-31-2023 08:55 AM
Thank you so much! I dont know how I missed, that error went away but still have this error "Error - Variations Specifics and Item Specifics entered for a Multi-SKU item should be different.||" any idea whats its asking for? usually its whenever variation and parent has same values, like same size or same color.
01-31-2023 09:01 AM
In many categories, eBay has reserved labels for Item Specifics. Those reserved labels can not be used as variations (internally called Multi-SKU items). In your case, Color and Size are reserved. So change those to Colors and Sizes, so your Variation labels they won't match eBay's Item Specific labels.
01-31-2023 09:11 AM
yes thats what I did and it worked, I removed Color from parent listing and it was listed successfully, last issue I am facing is getting template in category: "Clothing, Shoes & Accessories > Men > Men's Clothing > Shirts > T-Shirts"
closest match I can find is: "Clothing, Shoes & Accessories > Men > Men's Clothing > Sweaters"
I am not sure why t-shirts is missing from template, is there any other place I can get template from? I tried to edit category in excel but error occurs and wont let me change to t-shirts
The value doesn't match the data validation restrictions
01-31-2023 09:19 AM
Actually I figured this out also, I changed source file to T-shirt, hopefully upload will not fail, last thing I need to find is Category ID for T-shirts, I do have it for sweaters, any idea where to find it?
01-31-2023 09:29 AM
There is a category selector for a T-shirt template:
01-31-2023 01:47 PM
Thank you so much! I dont know how I missed it, I think I got this working, only thing thats not in there is international shipping options, I have two options for local (domestic) shipping but no international, any idea how to enable it? or can I add rows in there thats missing like Garment Care and so on?
01-31-2023 02:56 PM
If using shipping policies, then add the policy names.
If not using policies, then add the missing columns.
• IntlShippingService-1:Option (need to find the value for GSP or EIS...)
• IntlShippingService-2:Cost (do not use if calculated)
Include these columns for both calculated shipping and international services:
• WeightMajor (whole pounds or empty)
• WeightMinor (whole ounces)
• WeightUnit ("lb" or "kg")
• PackageDepth (whole inches)
• PackageLength (whole inches)
• PackageWidth (whole inches)
• PackageType (None, Letter, LargeEnvelope, PackageThickEnvelope,
USPSLargePack-for all service providers-not just USPS)
• PostalCode (instead of Location)
01-31-2023 03:06 PM
Thank you, thank you. Could you tell me where can I find all those rows that can be added but its not in template by default. because IntlShippingService-1:Option is not in original template. So its missing Care instructions menu and so on.
01-31-2023 03:39 PM
Custom item specifics are not anywhere in a handy table.
If you see one on the listing form, use the same heading as shown in the item specifics.
So if there is one called "Garment Care" then create a column heading called
C:Garment Care
Use the exact capitalization and spelling as on the listing form.
Options are:
The listing form also allows making up a care option of your own, but I would avoid doing so, as it messes with eBay's database.
If a column like C:Material allows more than one selection, then concatenate the values on a single line with a vertical-pipe (|) separator, like this: Cotton|Polyester
01-31-2023 06:43 PM
Thank you very much! I would not be able to troubleshoot it without your help, everything works as intended, yes I was able to add columns in excel and add values as they appear in eBay listing specifics, only issue I had is URL images are not showing properly until I edit listing and relist it, but I think it may need time so will wait if it fixes itself without editing the listing
01-31-2023 07:39 PM
I noticed your images are on imgur.com.
That service blocks images from appearing on eBay because it violates their terms of service (they are not a content host for other sites). But I wasn't sure if you could use them for transloading to eBay hosting. Apparently not. Imgur simply denies the eBay server's request for an image.
You must include at least one placeholder image to upload a new listing.
If you don't have an alternate image host, you can make up an image like:
https://example.com/placeholder.jpg
It will return an error, but should list successfully.
Then "delete all images" when you manually revise the listing and add the photos from your desktop for your parent record and for your variation colors.
01-31-2023 07:45 PM - edited 01-31-2023 07:46 PM
I think something else could be going on, because when revising I am not actually uploading images again, they are showing as blank, but if I click on image and it goes in variation details, all images appear by itself, so I am guessing something going on with eBay template?
Here are screenshots of listing revision image 1 and image 2
listing has an error when viewing as customer "Your listing is successful but there's a problem with your Gallery picture" I dont even have to click submit on revision, once images load as shown in screenshot I can close the listing without saving and it will display images normally
01-31-2023 08:29 PM - edited 01-31-2023 08:34 PM
I think you are dealing with a browser cache, since eBay is saving your URL for you, and your browser is serving the remotely hosted URL from the cached image. If your browser has incognito mode or private browsing mode (where cookies and cache are not preserved) take a look at your listing from there. Or, clear your browser cache and revise your listings to check again.
I don't see any photos when viewing your two newest listings because I don't have the images cached in my browser.
When I used the Bulk Photo Scanner tool to download your eBay listing photos, I could see that they were all still hosted on imgur. That means eBay was unable to fetch them for transloading. eBay was also unable to create a gallery photo. The scanner tool grabbed the imgur URLs from the listing, and they were successfully displayed in the tool because the tool is not yet blocked like eBay is.
So, bottom line, imgur will not work.
The largest image eBay will host is 1600x1600 (2.5M pixels).
I can see that your originals are 4000x4000 pixels (16M pixels).
That means you are uploading 6 times more data than you need to. There is no need to supply eBay with an image that is larger than 1600, as they will simply downscale it anyway and then make other sizes from that smaller master. So it is better (and faster) to give eBay a master image that is close to the size eBay keeps as a master and not slow the transmission with extra (6x) baggage.
If you manually upload through the listing editor, then the images are scaled down in your browser by eBay's uploader tool prior to transmission to eBay. But if sending from an image host via spreadsheet, it is better to be mindful of bandwidth.
Welcome to the Seller Tools board! You can chat with other members about seller tools and best practices in using them.
Tools related questions? Learn more about:
Videos: