Find Jobs
Hire Freelancers

Auto Entry Amazon Marketplace/zShop orders into osCommerce Database

$300-1500 USD

In Progress
Posted over 17 years ago

$300-1500 USD

Paid on delivery
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.
Project ID: 74727

About the project

22 proposals
Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED KINGDOM
Birmingham, United Kingdom
4.8
33
Payment method verified
Member since Jun 25, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.