Find Jobs
Hire Freelancers

Order management system for PayPal e-commerce orders

$30-5000 USD

Terminado
Publicado hace casi 12 años

$30-5000 USD

Pagado a la entrega
This project is for the development of a web-based order management and fulfillment system that extracts orders from PayPal (via SOAP API) and allows the user to quickly and easily edit order data, and create shipments by choosing which items from the order to ship. The pending shipments should be available via an ODBC connection. ## Deliverables The emphasis in this application is on speed, ease of use, and simplicity. Your application should be web-based and written using mainstream technology. HTML5 (preferred), ASP.NET 4.0+, PHP, Silverlight are all acceptable. Java is discouraged. Flash is not acceptable. At a minimum this initial phase / trialsourcing project needs to have the following features: * extract orders from PayPal via SOAP interface (you will receive API keys; source code in C# that already performs this function is also available for you to use as a model) * store orders in a mainstream database (MySQL or SQL Server) * list orders on a web interface; each row expands to allow the user to easily see what items are in the order, when the order was shipped, etc. * * if there are up to two items they are visible in the order row (i.e. without expanding) * user can scroll through large order lists easily (no complicated pagination; infinite paging is ideal) * user can search orders (by name, email, SKU) * user can filter orders by status * user can edit order information (e.g. shipping address) * user can add and edit order notes; orders with notes have an icon to alert user that notes have been entered * user can select one or more orders (e.g. checkboxes; must support selecting a range of orders easily by holding SHIFT and clicking) * by default all items in the order will be selected if the order is selected; user can unselect one or more items, or select items from an unselected order (in effect selecting the order) * orders or individual items that were already shipped (see below) can no longer be selected * user clicks a button to create shipment records from the selected orders * shipment records that have Status=Not Shipped can be queried and updated via ODBC (e.g. exposed in a view) Your database will probably have the following tables and columns (there will probably be more columns; these are examples) ? PayPalTransaction o Timestamp o TransactionID o Email o Name o ShippingAddress o TotalAmount ? PayPalTransactionItem o TransactionID o SKU o Description o Quantity o Price ? Item o SKU o Description o Weight ? Order o ID o Timestamp o Source (e.g. PayPal) o Email o Name o ShippingAddress o Notes o TotalAmount o Status ? OrderItem o OrderID o SKU o Description o Quantity o Price o ShipmentID ? Shipment o OrderID o Timestamp o TrackingNumber o Address o Status o TotalWeight ? ShipmentItem o ShipmentID o SKU o Quantity * * *This broadcast message was sent to all bidders on Friday May 25, 2012 3:15:38 PM: If you prefer, instead of extracting orders from PayPal via the SOAP API you can retrieve them from a SQL Server database (the code to extract PayPal orders has already been written and the records are placed in a database automatically) * * *This broadcast message was sent to all bidders on Sunday May 27, 2012 9:52:03 AM: Several of you have inquired about reading PayPal orders from a database instead of directly from PayPal (which is of course more work). If you decide to use our existing process that imports transactions from PayPal, and read them from a SQL Server database, then you may consider the following: * There are multiple types of transactions in PayPal, and not all of them represent orders. You should apply the following filter to the Transaction table in order to retrieve only the orders: from [Transaction] t where [login to view URL] > 0 and Type = 'Payment' and Status != 'Refunded' * in order to keep track of which transactions are new and which were already imported I recommend you create columns [login to view URL] (willl always be "PayPal" for this first phase), [login to view URL] (PayPal's TransactionID value), and Order.PaymentTransactionStatus. This last column is necessary because sometimes the PayPal transaction takes several days to clear. In that case the status will be "Pending" instead of "Completed." The user should be able to see this status on the order page so that they don't ship orders that are not cleared yet. * * *This broadcast message was sent to all bidders on Wednesday May 30, 2012 8:44:01 AM: You can download the PayPal database schema and sample records from here: [login to view URL] Your code should import records from this table into a separate Order table. No user interface code should query PayPalTransaction directly. * * *This broadcast message was sent to all bidders on Tuesday Jun 5, 2012 2:50:43 PM: You can see user interface wireframes at the links below. These are intended for the final application. The contest does not cover all of these features. It might give you ideas for how to complete the contest though. [login to view URL] [login to view URL]
ID del proyecto: 2745018

Información sobre el proyecto

1 propuesta
Proyecto remoto
Activo hace 12 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
See private message.
$270 USD en 14 días
5,0 (31 comentarios)
4,6
4,6

Sobre este cliente

Bandera de UNITED STATES
Stamford, United States
5,0
65
Forma de pago verificada
Miembro desde ene 29, 2010

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.