Is It Possible To Remove "Add This To My Cart" For Just Some Items

I know this is an oddball question, and there might not be any workable solution. But nothing ventured, and all that.

We're setting up a new bookseller website, https://www.book-oasis.com. Obviously it will be a while before this site is well-populated, so the owner has worked out a deal where she can promote books currently on Amazon, using special codes like:

which will create a listing like this: http://book-oasis.com/index.php?main_page=product_info&cPath=2_12&products_id=1

In order for a book cover to show up on the index page, it's necessary to save a copy of it, independent from the iframe listing, which unfortunately looks a little odd on the page listing. But this is only intended as a workaround for the next few months until the site takes off, so that's not a huge concern.

What is an issue is, you're supposed to click on the Amazon listing, and go directly to Amazon to buy the book. But ZenCart is showing the standard "Add This To My Cart" button, which would take the person to the ZenCart checkout. Since this book isn't hosted on the Book Oasis server, that's not going to work.

Is there a way to remove that button just on the Amazon books, but have it visible on "real" books that will be hosted and sold from the server? (fingers crossed)

Thanks very much for any advice you can offer!!

You could use a different product type, like "Document - General", and mark that product type as no-add-to-cart.

Well, that would be easy! :D Can I change existing entries, or will I have to go back and redo them from scratch?

Also compare Document General and Document Product product types ...

Document Products has all of the fields of a Product General and can also be turned off ... the advantage being if you want to show the information or if later you want this to be a regular Product General you have all of the information filled in ...

There is not a setting in the Admin to change the Product Type of a Product, this would have to be done via phpMyAdmin or via the Install SQL Patch, once you get the hang of switching a Product from one Product Type to another ...

Now I'm confused again. Do you mean I can't set up each book listing individually as one or the other; they all have to be one or the other unless I do something special in phpMyAdmin (which I have no idea how to do) or some kind of SQL patch?

No, I tried it, and I can set up each new book individually. That's a relief. Well, it's a good thing I asked before I did too many listings, isn't it? :D So I won't have many to recreate.

THANK YOU for your help on this...I was sure it was an insurmountable problem and we wouldn't be able to do the Amazon affiliate program after all. As always, you guys rock!!

As for the sql in the future, there's a few options depending on what the status is for the new product at that product type.

Individual product update:

update products p set p.products_type=1 where p.products_id=10;

Multiple product of that type, but not all:

update products p set p.producst_type=1 where p.products_id=10 or p.products_id=11;

All product of that type:

update products p set p.products_type=1 where p.products_type=4;

All product of that type but not one product:

update products p set p.producst_type=1 where p.products_type=4 and p.products_id != 12;

All product of that type but not two or more product:

update products p set p.products_type=1 where p.products_type=4 and p.products_id != 13 and p.products_id != 14;

All product regardless of product type (not suggested for everyone because of the constraints described above):

update products p set p.products_type=1;

Even within those there are variations that can be done to make writing the list easier...

Instead of each individual != can do:

where p.products_id not in (15,16,17)

The products_id values above relate to the product in question, the products_type value above is that for document - product in a default install...