This is a 4 part project for assigning products to customers. Assigned products fall into two categories: purchased / promotional.
1) Based on the product gallery, we need an admin module that allows us to assign products to customers. When we assign a product to the customer, we will use one of two types of flags. The product assigned to the customer can be either "purchased" or "promotional".
1a) Assigning a product to a customer with the "purchased" flag would be similar to a customer purchasing the product from the website. This is used when our customer purchases a product over the phone, rather than using the website.
1b) Assigning a product to a customer with the "promotional" flag would be a way to suggest products to the customer.
2) We need to create a php script using mage that will retrieve these assigned products as a product_collection.
3) We also need a front-end based module that shows the products assigned to the customer, allowing the customer to easily re-order the product. We need to label the products being listed as "purchased" or "promotional".
4) We also need a front-end based module that allows the customer to add more products to their custom product list, including the flag for "purchased" or "promotional".
We want to wrap the modules with ajax to avoid page loading time. We don't have a layout design guide for it yet, so this project will require us to agree on a design together. We assume that it will be based on the standard product gallery, but include the ability to select which type of assignment is being used: "purchased" or "promotional".
What we need to do is, assign products to different customers. And when we assign a product, we need to mark that assignment with a flag (purchased / promotional). So for example: Customer X purchased products A,B, and C. Also Customer X wants to advertise product D and E. So our module will allow us to assign products A,B,C,D,E to Customer X. Products A,B,C assigned to Customer X will have the "purchased" flag. Products D, E assigned to Customer X will have "promotional" flag. Same thing can be repeated for different customers with different products.
For the admin section, I was thinking we could use a datagrid similar to what we see at "admin -> catalog -> manage products", we can select the customer at the top of the page from a dropdown, then in the datagrid we can add one column with a dropdown to select "purchased/promotional", or two columns each containing a button: one which says "purchased", and one which says "promotional"
For the front section, on a custom CMS page, the customer can browse the products same as the standard front-end gallery, and they can add products to their "promotional" list.
I will not release any funds for any reason until have viewed a demo of the project.