oscommerce product and orders

(I will be providing prewriten scripts and links later that will make the automatic products job be very simple) overview: I basicly I want my Oscommerce site to be automaticly updated with amazon products. there are MANY MANY PHP scripts that contain autoupdate. I just want the products to be ordered threw my oscommerce, not routed to amazon. I want the products to be updated a different way. That is to somehow design something that after the customer gives there Information (name address) and presses sumbit, that infomation is ordered threw my associates account on amamzon to ship to them. (without them seeing possibily setting up a "loading" page when they sumbit) I can't order products threw my own account, but I have another one that can serve as the buyer. I will not be choosing sloopy/lazy writers that will write scripts that will crash when more then one customer press sumbit, it should be set up so that orders are sumbited one after another. [login to view URL] that is my store that has all the links to give my associate account commission. [login to view URL] has one of the automatic product updates. The bidder will get passwords needed. p.s. the payment method of my buyer should not have anything to do with this, the customers payment will be approved before the order with my emerchant, this way no order is sent that the customer didn't pay. all purchases are made threw amazon with the buyer account. The information that needs to be routed is.. Full Name: Address Line1: (Street address, P.O. box, company name, c/o) Address Line2:(Apartment, suite, unit, building, floor, etc.) City: State/Province/Region: ZIP/Postal Code: Country: (drop box of all countries) Phone Number: FIrst 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 (keep in mind i want to be able to change it, or authorize changes (when products prices change) 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? Additional information submitted: 03/24/2006 at 7:32 EST: all links were stripped.. here they are: Amazon Ajax code sample: [login to view URL] (search this site for "amazon" and you will find more examples) ______________________ [login to view URL] -- Amazon Pear package ______________________ [login to view URL] -- Amazon remote cart code samples ______________________ [login to view URL]