I'm stumped. I'm not so sure what is the answer to your question. I'll do some research and get back to you if I discover an anything. You should email the people at iPage as they probably could help you..
I never really thought of it in terms of using the category instead of the product itself. Hmm... I'll need to think that through in that regard. The thing is, I was originally thinking a general category called "my photos" and inside that having sub categories like "family portraits", "weddings", etc. These same sub-categories would apply to any customers who have the photographer do anything, as their pics could be dropped in the appropriate category when the time comes. That would also help the photographer keep the types of photos organized in a particular way.
Definitely need to brainstorm on it some more great idea though! For the time being already started playing with some code in admin/categories.php and it's all using a new field in the products table called products_customers_id. I guess I can try it the other way once I get some of the primary logic figured out..
What I've got thus far: when adding a new product, I've now got a drop down above the manufacturers one, that successfully calls up a complete list of registered users, displaying just their last names. I click the "preview" button, everything seems cool, then when I hit the "insert" button, I start getting errors. I'm basically trying to base most of the interaction of the customer aspect off of the manufacturer aspect, but there's obviously something I'm screwing up in the MySQL queries when it goes to insert the info. I'll keep working on it and see what happens..
Thanks a million for the input and feedback!..
I've found the solution, many thanks to a more experienced programmer who was willing to work with me on it. I will be posting a new contribution for it in a week or so. It basically allows you to add a new product, assign a customer name to that product, then when the customer logs in with their name and pass, they get a new category with their specific stuff in it. And for customer privacy, the new products modules, search results, etc. eliminate custom products from their listings too. It's pretty swank..
Woohoo I have been after something like this for a while now and when I posted about it on here I didn't get a response. LOL..
I posted this over in the General support area, but some how the thread deviated to something about watermarks on images. Anyway, I desperately need some help trying to customize/re-configure OSC for one of my clients and thought perhaps some of the gurus hanging out in this area might have some insight. My client runs a small photography studio, wants to sell general prints to the general public, and then offer their own clients the option of purchasing their custom photo sets online. Seems like this would be simple, or even common place for an e-commerce site, right? Well, I'm not having any luck finding any contributions like this, and not getting much feedback so far..
Here's my logic on this concept at this point... some one tell me if I'm on the right track, at least in my theory.....
- add a field to the products table in the DB, called something like user_id (some how this needs to be related to the "customers" table I guess, for cross referencing)..
- add a drop down in the "add product" area of the admin section, say under the "manufacturer" drop down, to select a user name to associate with the product yes, this could over time become a HUGE drop down - perhaps something other than a drop down?.. whatever.
- if anonymous user goes to site, they see the generic products and categories, period..
- user registers, contacts photographer for session, they do their thing, a week or so later, the photographer puts the products into a category called "My Photos" and selects the user name from the aformentioned drop down in the admin area..
- the registered user logs in, suddenly sees this "My Photos" category, and their photos within - NO OTHER USER WOULD BE ABLE TO SEE OR PURCHASE THESE PARTICULAR PHOTOS..
My problem - I'm still moderately new with PHP and MySQL. So far I just keep breaking stuff when I try to modify queries and stuff. I'm a pretty fast learner once I get steered in the right direction though. SURELY some one else in this community has had to do a mod at least KIND OF like this! It seems to me that this would almost be a requirement for a lot of shops in all sorts of industries. (perhaps this should also go into the Suggestions forum?).
PLEASE SOME ONE HELP! Thanks in advance!!..
Hrm...interesting idea! I'm not a guru by any means, but let me see if I can help you out..
I think my first impulse would be to relate it to categories, not individual products. I think that would be faster in the long run - if someone shoots 20 photos in a session, you only have to set the user_id for one category rather than 20 photos..
So...once a user does his thing with the photographer, you create a category called "<user name> Personal Pictures" or perhaps "<user name> <date of session>." Add a new field to the database, like you suggested, called customers_id in the categories table. Set the default to 0 for "all customers." Then, edit the "categories" box...find the sql query that gathers the category structure and tack onto the end of it something like:.
Where c.user_id='"$customer_id"' or user_id='0'.
I'm pretty sure there's a global variable for the customer's ID number, but I'm not too sure what it is..
To make that dropdown, check out admin/mail.php for some code you can probably swipe. You'll need to put it into categories.php somewhere after where it says:.
Case new category;.
Hope this helps you!..