Simple php & mysql script, to help manual category mapping
Paid on delivery
I need an interface to manualy match categories from different merchants to my site categories. The goal is to assigned category_ids from my site category table to the merchant categories. There are two tables. My site categories table that contains: Category_id, parent_id, and category_name. and the merchant category table that contains: category_name, matched_cat_id, example_image_link, and example_item_url. The script should do the following:
- Creates the interface as shown in the screenshot
o Collect categories from the merchants category tables where the matched_cat_id = 0. And display the categories in the textarea as shown in the screenshot of document attached.
o Using the merchant dropdown to filter and display categories for the merchant selected. Default should display all categories where matched_cat_id = 0
o Display my categories and sub categories as dropdown box. As shown in the screenshot. The categories have child or subcategories. When a parent(first level category is selected, new dropdown box should be displayed with the subcategories of the category selected. This should continue untill all the category levels have been displayed.
o Display of example_image_link & example_item_url when a user selects category in the Textarea.
- The mapping is down as follows.
- From the textarea a user will select category/categories(more than one category can be selected at the same time).
Please see attachment for screenshot. Please before bidding make sure you have read the description. Auto and generic responses will be ignored.
Questions, suggestion, comments are welcome.
Project ID: #36641042
About the project
59 freelancers are bidding on average €152 for this job
Hi, I can give you the interface in 2 hours .... I have understood all your requirements...i will need your sample dump of your categories table and merchants categories table...thanks