Barcode (isbn) lookup / API Database injection

CLOSED
Bids
16
Avg Bid (GBP)
£786
Project Budget (GBP)
£350 - £1000

Project Description:
We require a web based application and possible maintenance.

Primary function of the application, is to allow the end user to scan a barcode or import file which the application will use to lookup all required item information (detailed below) and then inject into a remote database via api (api documentation to be provided).

We would like the end user to be able to choose the condition of new or used via a dropdown menu, then also select a format option (ie book/dvd/game/audio). Finally select via another dropdown (options propagated via api from remote database) the relevant supplier. Once those three options are complete the end user should be able to scan a barcode or import a file which the application will automatically check to verify if the item barcode already exists in the remote database against the same condition chosen.

The results are to be shown in a list format, if the item barcode exists in the remote database data checking should be utilised to ensure data is complete. Where data is not complete according to the list specified below data should be retrieved from the sources same as for a new item.

If the item barcode is deemed to be new in stock then generate new SKU and pull data as specified below. Primarily all information should be sourced from Amazon.co.uk (upon multiple results relating to one barcode provide a method of choosing desired item). If no information can be found on Amazon.co.uk I am open to suggestion of secondary sources of isbn data so long as it is UK relevant with exception of synopses and category.

Specific requirements for application:
1. To be able to enter up to 500 barcode ( list view, cached results)
2. Additional editable fields (new items only): bin, quantity, Supplier Barcode, Supplier cost, Supplier code.
3. Ability to select all or individual items for entry into database
4. If already existing in database highlight in red within list view, do not allow edit of bin or quantity. Automatically fill in data gaps and refresh amazon sale rank and amazon lowest market place price (country requirements as below), show where information has been appended.
5. Export results to csv or excel
6. Link to view item on amazon UK

Data Fields Required
SKU (existing items only, pulled from remote db via api)
Supplier Barcode (existing items only, pulled from remote db via api)
Supplier code (existing items only, pulled from remote db via api)
Supplier cost (existing items only, pulled from remote db via api)
Book Name (Title)
Publisher
Author
ISBN
ASIN
Cover Picture
Synopses (can be US Data pulled from ISBNdb.com, or openISBN.com)
Number of pages
Publication Date
RRP (list price) GBP
Binding
Dimensions in cm
Weight in grams
Reviews (can be US Data pulled from ISBNdb.com, or openISBN.com)
Category (extended property) (can be US Data pulled from ISBNdb.com, or openISBN.com)
Sale rank for Amazon UK, France, Germany, Spain, Italy
Amazon price for Amazon UK only
Amazon lowest marketplace price for Amazon UK, France, Germany, Spain, Italy
Number of sellers (do not injected in to database)


Time frame is 7-10 days.

Skills required:
Amazon Web Services, Javascript, MySQL, PHP, XML
Hire DISCOBALL
Project posted by:
DISCOBALL United Kingdom
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 896
in 12 days
£ 695
in 22 days
£ 789
in 30 days
£ 1030
in 15 days
£ 578
in 3 days
£ 1030
in 10 days
£ 583
in 5 days
Hire ksupport
£ 695
in 3 days
£ 1030
in 25 days
£ 1030
in 25 days