Amazon products/cart to osCommerce

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"

Finding ASIN

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:

Product name-price-ASIN

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)

Parsing data

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 :)

Useful resources:

Amazon Pear package

Amazon remote cart code samples

Amazon script

" 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
______________________
http://www.chipmunk-scripts.com/page.php?ID=33

Evner: PHP, XML

Se mere: using oscommerce amazon feed, want to create new brand name, up to standard, populate xml from database, photo store script, n vision it, make products, i.t. administrator, how to make a product catalog, how to make a catalog of my products, how to get a brand name, how to find a brand name, how to create forms in php, how to create database using php, how to create a database using php, find new brand name, find name brand, find a database administrator, description of products product, data challenge, create products, code challenge, choose a challenge, challenge s, challenge examples

Projekt ID: #51154