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]

@shipscript  Something strange is happening. I created a new tab on the brand new downloaded template and called it "TEST".  I copied only the headers from the listings tab / sheet and pasted them into the first line of the new sheet.

Now, on the test sheet, the category ID column shows up! It still doesn't show up in the listings sheet.  Is it hidden? Am I supposed to click on something to make it appear? I did not have to do that yesterday. 

I can't see the Category ID Header or Column:

[huntfor]

@shipscript  I don't see any zeroes but I can never reach the end because the rows seem infinite.  That's for all the sheets. Also these templates indicate there

About this:  "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." 

I did that yesterday and it still added a lot of zeroes.  

About the item condition, I'll leave it out.

[danli-3564]

@huntfor 

Is it possible that the column is just hidden, I see that a column C does not exist.

[danli-3564]

@huntfor 

Can confirm that the missing column is simply hidden, I had to unhide it in my google sheets to see it, same problem with templates from a few different categories that I just checked.  This explains why you could see it after you copy/pasted the rows into a different spreadsheet, you were copying the hidden cells at the same time.

Cannot help you with the 0's issue, as I'm not having the same issue in google sheets.  VLOOKUP is being used in column C, but the function is written just the same as it has been for months.

[huntfor]

Great job! That's one mystery solved!  

Since that happened I haven't tried to upload my data, so I don't know if the zeros are still there. I'll try uploading and get back with the results. 

[huntfor]

@shipscript @danli-3564 After a lot of tweaking, I have successfully uploaded a multiple listing of three items.

Unfortunately, the business policies shipping is creating huge issues. I started a new thread and tagged John@Tools with this issue.

John, I need a timeframe for how long it will take to resolve the BP Shipping snafus. Thanks.

[huntfor · Accepted solution]

I have a working template and will post a tutorial as soon as a few errors are cleared up. 

[Anonymous]

How much for a working templete example?

[Anonymous]

Worrywart233@yahoo.com is my email please help I've had trouble since last year.