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
Because you have Business Policies, we'll work from that.
Below is a spreadsheet I rearranged and colorized for Sports Cards. At the very end are the three yellow fields for Business Policies. You would use those three fields.
- ShippingProfileName
- ReturnProfileName
- PaymentProfileName
Ahead of those Profile names, I have green, orange, and pink fields for Returns/Shipping/Payment that are populated when a seller is NOT enrolled in Business policies. Do NOT complete any of those fields because you are using Business Policies.
Stuck between those colored groups are two white fields for shipping discounts that are not populated in Policies, so you can add those profile names/numbers to the white fields if you are using discounts. https://www.ebay.com/ship/prf
Not included in your template are the weight and dimension columns for calculated shipping.
Because your selected Shipping policy requires calculated shipping, we'll add the missing fields to the template. Here is a sample. We'll assume you have a lightweight padded envelope (the dimensions are not really required for first class package, but I've added them as an example):
The forum is wordwrapping the values, but they won't be wrapped in your spreadsheet.
| ShippingProfile Name | WeightMajor | WeightMinor | WeightUnit | PackageLength | PackageWidth | PackageHeight |
| Calculated First Class Mail | 0 | 12 | lb | 10 | 7 | 1 |
The listing duration for fixed price listings should be GTC
For auctions, the value is a number (1, 3, 5, 7, or 10), although there are limitations. Typically, the number 7 is entered.
The fact that you are getting errors there may mean that there is a column shift, often due to a hidden character like a carriage return (new line).
Are you using business policies? If so, make sure a valid shipping policy name has been added. If not using policies, there may be a missing shipping field. We would have to see that portion of your template.
Make sure that the GTC doesn't have any stray characters before or after (spaces or line breaks). Delete the entire cell contents and go again. Check that the cells ahead as well.
Are the next 7 lines separate listings, or are they variations?
If you are signed up for business policies, then you are required to use them in File Exchange.
https://www.bizpolicy.ebay.com/businesspolicy/manage
There are three that must be populated:
- ShippingProfileName
- ReturnProfileName
- PaymentProfileName
If you have opted out of business policies, then selecting "Flat" shipping is insufficient.
There are other fields that must be populated for shipping, these are the minimum:
- ShippingType ==>> Flat
- ShippingService-1:Option ==>> USPSPriority or USPSFirstClass
- ShippingService-1:Cost ==>> 0
For calculated shipping, you will need weight and dimensions, even when you are using shipping policies.
I believe you can skip this field if you have a policy in place
*ShippingType =>> Calculated
But these will be required:
- WeightMajor => pounds as a whole number
- WeightMinor => ounces as a whole number
- WeightUnit => lb
as whole inches:
- PackageLength
- PackageType
- PackageWidth
Sometimes it is hard to understand what is required and what is not. I find it helpful to look at the manual listing process to see how the fields are grouped. For instance, even with business policies, where individual shipping methods are no longer available on the listing form, the listing form still has the ability to set the dimensions and weight because those are not included in the policy.
@shipscript I'm getting more and more entangled with the shipping. I attached screenshots of what I tried and what the errors are again. My shipping policy. Is this correct or do I remove the spaces? I don't have a weight column in this item specifics template I downloaded. (jewelry).
==================
csv entries for shipping:
Latest error report:
Because you have Business Policies, we'll work from that.
Below is a spreadsheet I rearranged and colorized for Sports Cards. At the very end are the three yellow fields for Business Policies. You would use those three fields.
- ShippingProfileName
- ReturnProfileName
- PaymentProfileName
Ahead of those Profile names, I have green, orange, and pink fields for Returns/Shipping/Payment that are populated when a seller is NOT enrolled in Business policies. Do NOT complete any of those fields because you are using Business Policies.
Stuck between those colored groups are two white fields for shipping discounts that are not populated in Policies, so you can add those profile names/numbers to the white fields if you are using discounts. https://www.ebay.com/ship/prf
Not included in your template are the weight and dimension columns for calculated shipping.
Because your selected Shipping policy requires calculated shipping, we'll add the missing fields to the template. Here is a sample. We'll assume you have a lightweight padded envelope (the dimensions are not really required for first class package, but I've added them as an example):
The forum is wordwrapping the values, but they won't be wrapped in your spreadsheet.
| ShippingProfile Name | WeightMajor | WeightMinor | WeightUnit | PackageLength | PackageWidth | PackageHeight |
| Calculated First Class Mail | 0 | 12 | lb | 10 | 7 | 1 |
I've made a lot of progress! Thank you, @shipscript
Two warnings I'd like to fix. Can you please advise me about them?
1. Warning - Invalid store category ID, 34397426010, since it is non-leaf. So item has been listed to the 'Other' store category
What is "non-leaf"? My category is Jewelry and that's the number I retrieved from the URL when I clicked on "jewelry" in my list of categories. See Screenshot, please.
2. Warning
This selling account is enabled for payments managed by eBay. PayPal is not currently accepted as a payment method and has been removed from the listing.|PayPal|
What field (s) do I remove from the below, please?
PayPalAccepted
PayPalEmailAddress
ImmediatePayRequired
Thank you!
A leaf category is the farthest one can travel down a branch. Your leaf categories under jewelry are Bracelets and Necklaces (I don't know what Category level 2 is). eBay has the same leaf category requirement when choosing a listing category. It must be the farthest choice at the end of a branch. If a category has subcategories, keep going down those subcategories to the end.
Remove these two columns to eliminate paypal when enrolled in Managed Payments:
- PayPalAccepted
- PayPalEmailAddress
Because you are using Business Policies, you can also remove the last blocks of pink, orange, and green columns that I have colorized in my earlier post.
