We have a CMS where we insert products in a MySQL database. Since we want to sell on international ebay sites we need a tool that links the different country Ebay categories to each other.
What we need done:
1. You have to to program a script that gets all eBay categories ( with the GetCategories from the ebay API) and include these in a MySQL table from every ebay country (USA, Germany, France etc.). with the full category path & name.
For example the MySQL table should look like this
(Please see attached PDF. The tables are displayed nicer there.)
id path ebay_id
56789 Jewlery/Fine Jewlery/Fine Rings/Diamond/Yellow Gold/14 KT / Solitaire / [url removed, login to view] 67543
id path ebay_id
12345 Uhren & Schmuck / Goldschmuck / Ringe / 585er-Gold/ Mit Diamant 55253
In our understanding it should be possible to get the path with the ebay API.
Also the script has to be able to reconize changes and updates in the ebay categories. This means if a category is deleted, from ebay in general, it should notify us about this.
If (for example) the ebay category 67543 changes it's name to „ Jewlery/Fine Jewlery/Fine Rings/Diamond/Yellow Gold/14 KT / Solitaire / [url removed, login to view] “ this should be automaticaly corrected.
Also if ebay should decide to open another subsidary (for example south africa) there should be no problem to upgrade the script.
I will provide the DEVID, AppID and CertID from ebay.
2. Once the categories are stored in a MySQL table you have to supply a php interface to crosslink the ebay categories (this will be done manually by us).
The base ebay site is Ebay-Germany. This means I want to assign a German ebay category to a different ebay site.
The MySQL table „new_ebay_linked“ should look something like this:
Id main_categorie_1 Main_categorie_2 Ebay_de Ebay_us Ebay_fr Ebay_...
12345 9 8 12345 56789 59393 19394
The design of the interface can be very basic, since we will implement it in our CMS. (see attached file)
3. The interface also has to be able to edit the crosslinked categories (delete, change update from the German category). This can be either implemented on the same or a seperate interface page.
Please note: all above supplied category names and id’s are not the actual ebay path. I named them for demonstration purposes only.
***IF YOU HAVE A BETTER SOLUTION (DATABSE DESIGN etc.) OF MAKING THIS JOB MORE BETTER FEEL FREE TO LET ME KNOW***
All variables, class names, MySQL table names and comments in the script should be in understandable English. Also communication between us should be in English or German.
Expert knowledge in PHP and MySQL-Databsas and the eBay API are necessery.
***Rights & Files***
All rights for use and distribution will be in my name. Also all original files (i. e. PSD) have to be made available to me.
Please specify in your bid how long the completion time will be.
20 % Down Payment (negotiable), rest upon completion
For internationl Transfers I’m only familiar with PayPal. If you want to make a other form of payment please contact me beforehand.