Categories mapping for XML, CSV

Closed Posted Dec 5, 2014 Paid on delivery
Closed Paid on delivery

Categories mapping

I need the follows functions:

Choose supplier from the mysql table suppliers - drop down menu

Set all products from this supplier as inactive in Magento products table - optional checkbox

Choose to read a XML, CSV file and to choose the category field

Read from mysql category table (Magento)

Mapping the category from the XML, CSV file with a category from the store category table

For example:

CATEGORY SRC CATEGORY DEST
 “Sport / Fitness / Jogging” -> “Beginning|Sport|Fitness” (separator is always |)


6. It has to be sure that all categories from the source file (XML, CSV) are mapped. For example two windows with checkbox or color mark when the category is mapped. If you have any other suggestion please let me know to comment on them

7. Create a MySQL CASE construction as a text field which I will be able to copy to import program.

CASE [CSV_COL(2)]

WHEN “CATEGORY SRC1" THEN “CATEGORY DEST1"

WHEN “CATEGORY SRC2" THEN “CATEGORY DEST1”

………..

END

8. Save mapping to config file for next use with same vendor. Because next time there will be new categories.

Files are in cyrillic UTF 8

Example XML: [url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Attached is Magento mysql with table suppliers.

Thank you

Magento MySQL PHP

Project ID: #6827794

About the project

20 proposals Remote project Active Jan 11, 2015

20 freelancers are bidding on average $212 for this job

rinsadsl

A proposal has not yet been provided

$210 USD in 3 days
(433 Reviews)
7.6
VnBestSolutions

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! More

$284 USD in 3 days
(104 Reviews)
6.4
techwelf

hi we are capable of performing the required task perfectly with accuracy, please let us know if you want to clarify in details.. if you want us to share our skill and previous work please initiate the chat by re More

$160 USD in 5 days
(46 Reviews)
5.9
pablotorres

I am working on software development since 1992. I am expert on migration of databases, custom or general purpose. I can migrate any kind of relational databases with just few SQL sentences. I can solve problems abou More

$50 USD in 7 days
(116 Reviews)
5.9
NayaPakistan

A proposal has not yet been provided

$155 USD in 3 days
(93 Reviews)
5.3
softbyteindore

Hello I read and checked the requirement of the project we can do this work. About Us:- we are in team having 2500+ hours of experience please come on chat to discuss more about the project to do this work in quick More

$235 USD in 10 days
(3 Reviews)
1.6
EcommerceDev2014

Hello Sir, I am a magento extension developer .I have developed many extensions some of them are very famous like multi seller Marketplace,Gift cards,ticket system,ebay connector etc ,but I work for a company thats wh More

$155 USD in 3 days
(2 Reviews)
1.5