Dfs Data Parser
I need a custom parser that can parse the Shoebuy data feed located at http://extranet.shoebuy.com/affiliates/feed.txt against my database ( i am using datafeedstudio.com script) and create the categories if they do not exist and assign the products to their matching categories if they have not already been assigned.
The script will allow me to provide the url to the file
to be read, it will read the data and make the
conversion/data additions.
The interface will provide Drop-downs that list my DB fields, and another set of drop downs that list all the fields in the CSV file.
I will map the DB fields with the CSV file fields once (and then the mapping will be stored in the DB to be used in the future.
I can then select from saved mappings or create a new mapping
in future uses of the script).
For the field that I label as CATEGORY and SUB CATEGORY I will need to be able to denote whether the field may have one or more categories in it or not and the delimeter seperating the additional categories/subcategories.
For example: In the Shoebuy CSV feed the DEPARTMENT field could have
Men, Teen Guys (The categories to be created would be Dr. Martens for Men, and Dr. Martens for Teen Guys.), the CATEGORY field has Leather Sandals (The sub-category under Dr. Martens for Men would be Dr. Martens Leather Sandals for Men and Dr. Martens for Teen Guys would be Dr. Martens Leather Sandals for Teen Guys.)
Additionally The category and subcategory should
have an option to prepend and/or append the name with a value from one of the fields combined with text. Example: The category Men could be prepended with the field Manufacturer and the words for. If the manufacturer was Nike the category name would be Nike for Men.
It will check for duplicates of cats/subcats/items. Finally, It will write the report showing how many items were added, which items were added, and how many new cats/subcats were created,
and how many skipped. etc…
It should intergrate with my existing script (www.datafeedstudio.com.)
Payment: Scriptlance upon completion and testing
Testing: On my server to ensure it works on my server.
