Spreadsheet - Adding weights, sizes & zip code for Calculated Shipping when using business policies

[huntfor]

@shipscript 

Do I create separate columns and use the specific names, shown in my screenshot, for the column titles when using calculated shipping?

When you hover over this column (Shipping Profile Name) in the first screenshot, you see the details in my 2nd screenshot with the red arrow.

And, is there an updated user guide? Link, please. Thanks!

[huntfor]

 On the spreadsheet I entered ReturnsNotAccepted exactly as it is in the screenshot.   It will be great once the spreadsheet works so I can start bulk uploading.  🙏

[danli-3564]

Well, that stumps me, honestly.  Make sure you don't have any erroneous spaces(space bar) in either your spreadsheet values or your eBay business policy name.   Click on the policy and copy/paste the name from the dialog box, instead of the page you screen-shotted.  And you already know that they are case-sensitive.

Where/how did you acquire your upload template?  From seller-hub/reports?

[huntfor]

I have no erroneous spaces. I checked. I copied my return policy directly from my policy page. Not from the screenshot. 

yes I got the template from the seller hub reports page. I took about 14 screenshots and created a little tutorial that I thought I was going to post here but I can't post anything until I have it working right

[shipscript]

Oooo... I would love to see your tutorial. Be sure to start a new thread for that.

After you create your CSV file, open it in Notepad to see how many rows are shown.

You would have the two or three header rows that Seller Hub creates and then your one row of data.

You might also try saving the page as a tab-delimited file and try uploading that, just in case there is a glitch in ebay's file reader.

[huntfor]

Wow, that's encouraging!  Thank you. I'll start a new thread for it but first I want to make sure I can successfully upload one item.

I'll try your suggestions tomorrow.  I'm on EST.  🙂

[danli-3564]

Are you on excel or google sheets?

[huntfor]

Excel.  Here is an update which cleared up the ReturnsNotAccepted problem:

I removed "buyer" from the "return shipping cost paid by"  column. I thought I had to add that but I don't since it's in my business policies. 

After that worked, I updated the return name in business policies and on the spreadsheet to  NoReturns

That part is solved. Thank you!

[huntfor]

@shipscript  The short story: the TAB delimited file does not work.

I exported the xlsx file to csv with the  TAB field delimiter.

I closed the csv and opened it with Tab separator (instead of comma separator) and got a long list of zeroes in the category ID column.

Note: I had to again select the comma separator along with the tab separator because there were hundreds of commas.

In a new notepad (TextEdit) file, I opened a plain text format notepad document.

File > Open > Selected the csv and got a long list of zeroes in the category ID column.

I uploaded the csv with the tab and comma separator selected. Upload failed. Blank rows except for the zeroes in the category column which generated BAF.Error.5 Invalid Action *Action(SiteID=US|Country=US|Currency=USD|Version=1193)

End of that story. Please see the new one further down in this thread. Thank you.

[huntfor]

@shipscript 

First issue:   Upload failed: Error - At least one valid shipping service must be specified.|

The upload isn't taking into account that I'm using business policies and my shipping policy name is USPS Calculated First Class Mail.

2nd issue:   Warning - Condition is not applicable for this category. The condition value submitted has been dropped.||

It isn't taking into account that it gives  the specific condition on the downloaded template (for art) 1000-New in Column "K" in the categories tab. See screenshot please.

[huntfor]

@shipscript Here are the screenshots of the rows of zeroes, etc. 

[shipscript]

@huntfor 

Well, it looks like you have located the problem. That column of zeros would trigger the error message for "Action".

The question is how did they get there?

Do you see them in your original template? Do you see them when you open a new tab and paste only the rows you want? Check the format of that column and scroll all the way down to see if there is something where the zeros would have ended.  Look at the other tabs/pages in that file to see if they end at the same count.

You could get around that by clipping off the bottom of your file in notepad, but we need to discover why this is happening.   You might try opening a separate Excel spread sheet and pasting your header rows and single item. Hopefully that would shake off the macros that are attached to eBay's template.

As for the Condition, it looks like they indeed dropped that field.

 

[huntfor]

@shipscript  I'll  go back to my desktop to figure out how all that happened but in the meantime the listing that you grabbed the screenshot from was something that I listed about two months ago.  Whenever I add new art prints I have to select "new" but every once in a while it says "condition not applicable."  Someone can't make up their mind! LOL!

When I save my spreadsheet after working on an image or text,  it says "do you want to save the changes for the connected files."  I don't have any connected files so I keep saying "no".

i'll reply with the results of my investigation as soon as possible. 😀

[danli-3564]

Yes, if you are using columns in which you are inputting business policies, other columns being filled-in are unnecessary/can trigger an error code. 

If you save a spreadsheet to be used as a template for the future, any unused columns, header and all, can be simply deleted, this removes unnecessary whitespace in your spreadsheet, and makes it easier to manage.

I enquired into what software you were using, because in the past I have publicly shared by google sheets documents, on this forum, for trouble-shooting help.  It allowed shipscript to put her eyes on my spreadsheet attempts, as I'm very new to ebay.

[huntfor]

@shipscript ATTENTION PLEASE!  Before investigating the extra zeroes, I started fresh and created a new template - 3 times. 

The category ID column is missing today. It was there yesterday. The actual category ID number shows up in the categories tab, as it should. Please see the summary of fields in the screenshot and that the Category ID column is missing in the spreadsheet screenshot.

Did eBay delete the category ID column?

The only good that came from this was that I worked some more on the tutorial.  🙂

Now I'll investigate the zeroes problem. 

[huntfor]

Yes, I've deleted unnecessary columns many times, but before deleting anything I want to make sure it's working properly. I plan on deleting every column I don't use. We'll see how that goes! 🙂 Thanks for the suggestions! 

Shipscript is great! Welcome to eBay, Danli. 🙂