Database designing with content management

  • Posted
  • Proposals 1
  • Remote
  • #6405
  • Expired
Sunil S. has already sent a proposal.
  • 4

Description

Experience Level: Intermediate
Website Project

There are 9 main areas on this platform:
-----------------------------------------------------------------------------------------------


1. ORDER PROCESSING

Search functions:
Paid orders, overpaid orders, underpaid orders and not paid orders.

Change address in orders
Add payment manually if required.

Item has to show as paid and awaiting postage, after payment received (PayPal, google checkout),

Printing invoices

Email confirmation after product is paid and dispatched email.
-----------------------------------------------------------------------------------------------


2. INVENTORY

Inventory management which is generally used in shopping carts:
Item quantity
Item categories
Item details
Actual item cost field for revenue and profit overview (see revenue section)

Items needs to be linked with eBay templates section (see eBay templates below)
Allocate shipping profile for item (see shipping profile area)
Optional email to supplier when stock is running low.

Excel spreadsheet inventory bulk upload and download.
If an item is sold on eBay inventory details have to automatically
update Amazon and retailers website.
----------------------------------------------------------------------------------------------


3. SHIPPING PROFILE

Option to create shipping profiles based on country, delivery method size and weight.
-----------------------------------------------------------------------------------------------


4. CUSTOMER RELATIONSHIP MANAGEMENT

Database where customer details and purchase history for online retailers are stored.

eBay messages and emails should show in message field. It is important that email templates can be created.
-----------------------------------------------------------------------------------------------


5. PHOTO HOSTING

Photo database, where customer can organize their photos for eBay and website.
-----------------------------------------------------------------------------------------------


6. EBAY TEMPLATES

Option to add eBay templates which can be linked to individual products in the inventory area.
-----------------------------------------------------------------------------------------------


7. REVENUE ANALYZER

Area to see daily and monthly revenue and profit.
-----------------------------------------------------------------------------------------------


8. E-COMMERCE WEBSITE

Customer should be able to create an e-commerce website with shopping card and payment processor.
-----------------------------------------------------------------------------------------------


9. EMPLOYEES LOG IN MANAGER

Online retailer should also be able to create log in accounts for their employees with limited access e.g. packer can only see order processing section.
-----------------------------------------------------------------------------------------------



API EBAY INTEGRATION

Possibility to sell an item on eBay (auction/fixed price/store, .. ) with a choosen template .

Listing items based on inventory information on eBay in different auction formats and auction duration.
Scheduled listings, and automatic re-listings.

Option to change live listings.

Inventory changes should be synchronized with ebay quantities .

Payment reminder emails
-----------------------------------------------------------------------------------------------


API AMAZON INTEGRATION

Inventory changes should be synchronized with inventory shown on amazon.com and amazon.co.uk

Orders received from Amazon should show in awaiting dispatch area.
Payment reminder email
-----------------------------------------------------------------------------------------------


API PAYPAL integration so items are updated as payment when orders are processed.

Clarification Board

    There are no clarification messages.