Hi all. I don’t sell on Abebooks, but I am considering registering with them, mainly so that I could use the ISBN lookup function in HomeBase. I currently use a Google Sheets spreadsheet for my data. I have tried to import the data to HomeBase via a tsv file, but the fields are not associating corr…

In case anyone is still interested (!), I’ve completed my Google Sheets script, using data from both Google Books and Open Library. It’s over 500 lines of code, but Gemini did most of the work. The data is often rather spotty, but better than nothing. Now to get down to work!

Hi @NCIrving2 I’m going to tag some folks who are more familiar with file types and possibly HomeBase than I am… @Pepper_Thine_Angus @oneida_books @Dogtamer @booknut7 @bookwormapril

Hi @papy , Thanks for your reply. I have just been in lengthy session with Gemini (Google’s AI chatbot), and we have been able to develop an Apps Script that returns author and title from the ISBN, using Google Books data, to my Google sheet. I should be able to add the rest of the bibliographic det…

Wherever the data comes from it may or may not be accurate. Everything has to be checked anyway.

[image] NCIrving2: tsv I assume you mean CSV? So one of the funny little quirks about CSV’s is that you can’t have any actual commas in your data, and this has caught me a few times, double check your values

I assumed that the OP meant tab separated value. Seems to me that no bookseller could ever use comma separated values as the data (mine certainly) would be riddled with commas.

I am possibly the least technical computer person you are likely to come across. I do use Homebase and love the ISBN lookup, it’s one of the best features of the database. When I was having upload file issues, @oneida_books looked at every type of file that one can create using Homebase, so he might…

April is right, tsv is tab-separated values. Commas definitely would NOT work for us booksellers.

Hi @papy , Yes, some. I’ve pretty much given up on HomeBase, and I’m still working on the script for Google Sheets. I find I can get data from Google Books or Open Library; there is also a paid program called ISBN Magic that I’m looking into. Each offers a different constellation of data, so I’m goi…

Sellers Ask Sellers Ecommerce Forum - Amazon Seller Help, eBay, Walmart and more

Problem porting data from Google Sheets to HomeBase

Selling on Amazon