Computer Help Forum

Go Back   vBulletin and Computer Help Forum > Site News and Things > FREEBS PHP Amazon Book Store Support

FREEBS PHP Amazon Book Store Support This forum is for downloads and support of the FREEBS Free Amazon Book Store software. FREEBS is a php based book shop that creates content pages for your website that may get listed in the search engines and helps you profit from Amazon book sales.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 12-12-2005   #1
reDDevil
Junior Member
 
Join Date: Dec 2005
Posts: 7
Too many skipped books and problems with discounted items

I have been trying to use FREEBS with a search phrase "slot machines" and noticed the following strange things and probably bugs:

1. Amazon finds 208 items for keywords "slot machines" but FREEBS with its script p3.php gets only 177 items. Moreover it skips 114 items so only 63 books are added to a database. The question here is why there is a difference between search results and why so many books skipped by FREEBS?

2. There is a price-problem with all discounted books like this one:
[url]http://www.amazon.com/exec/obidos/tg/detail/-/156980169X/qid=1134396775/sr=1-1/ref=sr_1_1/104-2384456-4830333?v=glance&s=books[/url]
As you can see there is no "Our Price" field but there are "List price" and "Price" fields. The problem is that FREEBS doesn't show any price for such items on detailed page
Strange thing here that in alphabetical list there is a parsed price:

Quote:
Don't Play the Slot Machines (Until You've Read This Book)
ISBN: 156980169X ASIN: 156980169X
Author: Michael D. Geller
Publisher: Barricade Books, Inc. March, 2001
Our Price: $9.60 Usually ships in 2 to 3 weeks
As of: December 12th, 2005 04:41:23 PM
But on details page of item there is no any price.
Quote:
Don't Play the Slot Machines (Until You've Read This Book)
Published: March, 2001
Our price:
List price:

As of: December 12th, 2005 05:55:01 PM

Author: Michael D. Geller
Is it possible to show "List Price", "Price" and "You Save" fields for discounted items? Or as a minimum "Our price" as it's parced?

3. The second problems with discounted books is that the button "Buy from Us" always leeds to a Not Found page of Amazon with a notice:
Quote:
Important Message:
The item that you tried to add to your cart is not recognized by our catalog. To find the item that you're looking for, try using the search box at the top of the page.
Look here:
[url]http://www.amazon.com/gp/legacy-handle-buy-box.html/104-2384456-4830333?asin.156980169x=1&tag%5Fvalue=eurocazino-20&tag-value=eurocazino-20&dev-tag-value=0DZDQYXBZ0N8AYB379G2&submit.add-to-cart=Buy%20From%20Us[/url]

4. The block "Similar Slot Machines Books" has always the same book and only one as current book is loaded
Example:
A description page of book "Don't Play the Slot Machines..."
/slot-machines-books/isbn156980169X.html
Has the same book as "Similar Slot Machines Books" with the same link:
/slot-machines-books/isbn156980169X.html

Quote:
Don't Play the Slot Machines (Until You've Read This Book)
Published: March, 2001
Our price:
List price:

As of: December 12th, 2005 05:55:01 PM

Author: Michael D. Geller

Similar Slot Machines Books

Don't Play the Slot Machines (Until You've Read This Book)
Unfortunately I can not show you all these problems on my public server because I have the following errors while trying to run p3.php script there:
Quote:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM' at line 24You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM' at line 7

Processing search record 1 of 177 actual search records returned.
ASIN: 1566250013
Name: Break the One-Armed Bandits!
Availability: Usually ships in 2 to 4 weeks

MySql Error Result Code: No Database Selected
on item asin: 1566250013 no DB insert occured.
My Sql Error Result Code: No Database Selected
on sims for asin: 0929712099 no DB insert occured.
My Sql Error Result Code: No Database Selected
on sims for asin: 1566252350 no DB insert occured.
My Sql Error Result Code: No Database Selected
on sims for asin: 0818406402 no DB insert occured.
My Sql Error Result Code: No Database Selected
on sims for asin: 0818405848 no DB insert occured.
My Sql Error Result Code: No Database Selected
on sims for asin: 0966459229 no DB insert occured.
And so on...

Any ideas how to resolve it?

Last edited by reDDevil; 12-12-2005 at 10:45 AM.
reDDevil is offline  
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 02:17 PM.



vBulletin 3.8.7 Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright vB and Computer Help Forum

EZ software products copyright Greg Lynch 2006-2013