In Progress

eBay API Script revision

I have an SQL database which stores the details of all my eBay listings.

Once every hour I have a script that runs every hour and uses the eBay API to carry out the following actions:

1) The script ends any eBay listings that meets a set criteria in the database

2) The script relists any eBay listing that meets a set criteria in the database

3) The script revises the price of any listing that meets a set criteria in the database.

This project is to add the following functionality to the script

a) Before the script ends any eBay listing it needs to query eBay to return any listings that have the same "custom Label" (the custom label is stored in the database) and compare the item id of the listings returned against the database entry and carry out the following actions;

i) If no listing is returned - take no action

ii) If a listing is returned and the item ID matches whats stored in the database - take no action

iii) If a listing is returned and the item ID doesn't match - update the item id field in the database with the correct ID.

iv) If multiple listings are returned - update the item id field in the database with the ID of the listing with the most recent start date and end all listings that have been returned.

The script should then move on to carry out it's usual function to end listings meeting the set criteria in the database

b) Before the script relists any eBay listing, it needs to query eBay to return any listings that have the same "custom Label" (the custom label is stored in the database) and compare the item id of the listings returned against the database entry and carry out the following actions:

i) If no listing is returned - take no action

ii) If a listing is returned - update the item id field in he database with the id returned and update the "status" field in the database with the term "Processing" and the "revision" field with a value of 1

iii) If multiple listings are returned - update the item id field in the database with the ID of the listing with the most recent start date and end all other listings, and update the "status" field in the database with the term "Processing" and the "revision" field with a value of 1

The script should then move on to carry out it's usual function to relist listings meeting the set criteria in the database.

c) Before the script revises the price on any eBay listing, it needs to query eBay to return any listings that have the same "custom Label" (the custom label is stored in the database) and compare the item id of the listings returned against the database entry and carry out the following actions:

i) If no listing is returned - update the status field in the database to "ended".

ii) If a listing is returned and the item id matches whats stored in the database - take no action

iii) If a listing is returned and the item id doesn't match, update the itemid field in the database with the correct id.

iv) If multiple listings are returned - update the item id field in the database with the ID of the listing with the most recent start date and end all other listings.

The script should then move on to carry out it's usual function to revise the price in any listings meeting the set criteria in the database.

Ending, Relisting and Revising items are identified in the database by the following method

Ending - Any database entry with a status of "Quarantine"

Relisting - Any database entry with a status of "Ended", Availability value of "usually dispatched within 24 hours" and a price of less than £20

Revising - Any database entry with a status of "Processing" and a Revison_required status of "1".

I'm happy to provide more information if required.

Skills: eBay, MySQL, PHP

See more: ebay api script, ebay update details, value stores, sql less than, revises, php ebay api, ebay API, ebay project php, update status script php, status update script, ebay revise item api, sql stored function, ebay add item, ebay multiple listings, ebay listing update, compare update, api status, php api date, revise api, ebay label, update field sql field field, ebay api revise item, revision required, ebay listing item, script meeting

About the Employer:
( 53 reviews ) Clevedon, United Kingdom

Project ID: #2540661

Awarded to:

rinsadsl

Please see private message

£200 GBP in 10 days
(240 Reviews)
6.9

5 freelancers are bidding on average £202 for this job

toinnisfree

pls chk pmb

£335 GBP in 5 days
(551 Reviews)
7.9
Tpojka

Let me look the script. Regards, Goran

£75 GBP in 3 days
(1 Review)
1.0
toolkitsolutions

Toolkit Solutions today boasts of maintaining and working with a large database of desirable programmers. If you hired Toolkit Solutions today, you can be assured that at least someone professional will be looking a More

£150 GBP in 5 days
(0 Reviews)
0.0
R564CgNzK

Custom software development ([url removed, login to view] Administrator removed this message for containing contact details which breaches our Terms of Service)

£250 GBP in 1 day
(0 Reviews)
0.0