Challenge: to embbed Amazon's AWS into osCommerce (and add "second" (amazon-only) shopping cart )
Purpose: to be able to assign, display and sell Amazon's products from within osCommerce's categories.
Amazon feed must be parsed exactly into osCommerce's standard fields, so it wouldn't interfer with any of the current osCommerce unctionality, such as RSS export (and actually all "outside" items should be IN this feed, just like any item of the store's catalog). Amazon's feed should be parsed as follows:
Amazon's price -> osCommerce price
Amazon's item's description --> osCommerce' item's description
Amazon's brand --> osCommerce's brand
Amazon's photo --> osCommerce's photo and so on.
Here is my vision on how it should be done (i might be wrong though)
First, we need to add a new field, called "ASIN" into osCommerce's item's description . ASIN is product's identificator in Amazon. If ASIN is ZERO, then it would mean that it is a "native" osCommerce's product and checkout should be processed in standard osCommerce's way. If ASIN is a number, then it would mean that it's Amazon's item, and it should be processed through "amazon's remote cart"
2 osCommerce forms must be modifed (new item insertion and item modification) in order to be able to insert ASIN. Two new buttons "Search for ASIN" and "Populate" should be placed next to "Products Name:". After hitting "Search for ASIN" button script will search Amazon for possible matched and will display:
Administrator will choose correct item and will get ASIN. This functionality should be created using AJAX to avoid page reloading .
Here is a source code sample and explanations: (search this site for "amazon" and you will find more examples)
As soon as admin chose ASIN, he will hit "Populate" button, which will pull price/description/ brand/photo from Amazon feed and insert this data into osCommerce database,
Keeping prices up-to-date
By using cron?
I am open to other ways as long as they make sense :)
Amazon Pear package
Amazon remote cart code samples
" from amazon but gives you full control of products you want to display and feature in categories that you create. It does take a little more work as you have to enter in all product info except for price which is automatically updated"
I don't think that someone, who knows Amazon's AWS and osCommerce will spend more than 2-3 hours to implement this functionality. No?
all links were stripped.. here they are:
Amazon Ajax code sample:
http://ajax.phpmagazine.net/2006/02/explore_amazon_web_services_wi.html (search this site for "amazon" and you will find more examples)
http://pear.php.net/package/Services_Amazon -- Amazon Pear package
http://amazoop.sourceforge.net/docs/amazOOP/tutorial_manual.cart.pkg.html -- Amazon remote cart code samples