Find Jobs
Hire Freelancers

Auto Entry Amazon Marketplace/zShop orders into osCommerce Database

$300-1500 USD

In Bearbeitung
Veröffentlicht vor mehr als 17 Jahren

$300-1500 USD

Bezahlt bei Lieferung
We need a central place to control the inventory and provide customer service for sales from different channels: mainly Amazon and our own website shop: [login to view URL] (powered by osCommerce). This project involves collect the order details from the Amazon order confirmation emails, then records these orders into the osCommerce system, so that all orders from Amazon marketplace/zShop can be processed in the same way as the orders made via our website. You will need good knowledge of both the osCommerce (PhP+MySQL) and Amazon Marketplace/zShop to handle this project, but most importantly the data structure of osCommerce because we certainly don't want ghost data spread various tables in the database. If you do have good knowledge of both, the above description should be clear enough. Here is more details on the tasks involved: 1. [login to view URL] notify via Email that an order was made and full paid for, normally the Email subject contains "Sold, dispatch now ...", in the email body, it will use separate lines to pass the order details, such as Order #: Listing 1: SKU: Quantity: Buyer's Price: Listing 2: SKU: Quantity: Buyer's Price: Postage & Handling: Total Amount: Delivery address: Dispatch to: Address Line 1: Address Line 2: Town / City : County: Post Code: Country: Buyer Name: Buyer e-mail: 2. The required PhP programme will selectively read those emails via POP connection to the email server (ingore those unrelated), it should also be able to prevent duplicate entry, for examples, the same "order #" may be emailed twice from Amazon for some unknow reasons. 3. The required PhP programme can check if the customer was already in the osCommerce database (MySQL), if not, a new customer will be inserted according to information collected. if yes, then the order will be recorded under his/her name. Note: they are many people with the same name, so please make sure the delivery address and email are the same as well. 4. The required PhP programme will create a new order for the customer in the osCommerce system, the products, the price, the delivery charges ... are all collected from the Amazon's order notification email. An osCommerce order ID should be generated, and payment method is "Amazon", this step might involve modification of one or two existing tables in the osCommerce database. That's it! P.S.: For those who have bid on this similar project, I changed the description quit some from the previous version so I think it better to close the previous and start again. I appologize for waisting your time. But this version of description is final, and one GAF member will win the bid.
Projekt-ID: 74727

Über das Projekt

22 Vorschläge
Remote Projekt
Aktiv vor 18 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten

Über den Kunden

Flagge von UNITED KINGDOM
Birmingham, United Kingdom
4,8
33
Zahlungsmethode verifiziert
Mitglied seit Juni 25, 2006

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.