IMO, you can use the MarketingCampaignRole (partyId, campaignId, roleTypeId) connect with MarketingCampaign.marketingCampaignId which in turn connect with TrackingCode.marketingCampaignId.
Orders and Visits wrt TrackingCode can be managed in the TrackingCodeOrder and TrackingCodeVisit. Still I'm not sure what you would like to do, I mean after generating the tracking code, party will do with that code and why (is there any benefit party will get after using that code). If only purpose of showing the visit and orders of 50 parties to them selves then you can simply add some additional role to those parties and on the basis of role you can show the visits and orders of those parties. Please give details of main and alternative cases of your requirement. Like if user logged in and if he has tracking code then what should happen with that user? -- Rishi Solanki Manager, Enterprise Software Development HotWax Media Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxmedia.com On Wed, Mar 13, 2013 at 5:38 PM, Deepak Agarwal <[email protected]>wrote: > I want those affiliates to log into the system and check their statistics. > > On Wed, Mar 13, 2013 at 5:38 PM, Deepak Agarwal <[email protected] > >wrote: > > > Thanks Rishi, > > > > I had seen the contact list and infact I am using it for promotional > > mails. > > > > Let me brief the exact requirement. We have, say 50, affiliate those have > > their unique tracking code and any sale through that tracking code can be > > tracked with current functionality. What I want to do is to have 50 > > Accounts/parties in my system so that can log into the system and can see > > their orders/visit. > > I didn't see any way to associate a party with tracking code. > > I have created a TrackingCodeRole table for this purpose now. I just wish > > if it was the right thing to do. ? It looks like: > > > > trackingCodeId partyId roleTypeId > > adfdc 3333 AFFILIATE > > > > On Wed, Mar 13, 2013 at 3:44 PM, Rishi Solanki <[email protected] > >wrote: > > > >> Check the data model in OFBiz for ; > >> > >> - MarketingCampaign > >> - ContactList > >> - TrackingCode > >> > >> All are connected with maketingCampaignId then look into the > >> ContactListParty entity which can use the same or different tracking > code > >> based on the number of TrackingCode generated for the MarketingCampaign. > >> > >> Hope it helps, most of the service and flow available OOTB. > >> > >> -- > >> Rishi Solanki > >> Manager, Enterprise Software Development > >> HotWax Media Pvt. Ltd. > >> Direct: +91-9893287847 > >> http://www.hotwaxmedia.com > >> > >> > >> On Tue, Mar 12, 2013 at 2:09 PM, Deepak Agarwal <[email protected] > >> >wrote: > >> > >> > We can create tracking codes for the affiliates websites from > marketting > >> > manger and it works like a charm. What we now want to do is to > >> associate it > >> > with parties so that we can setup the accounting and calculate the > >> > commission run and give user/pass to them to see their panel. > >> > > >> > Any thoughts. > >> > > >> > Should I use party classification group and then use the same group id > >> in > >> > tracking code group id? > >> > > >> > -- > >> > Thanks, > >> > Deepak Agarwal, > >> > > >> > Mobile: +91 9501190044 > >> > > >> > > > > > > > > -- > > Thanks, > > Deepak Agarwal, > > > > Mobile: +91 9501190044 > > > > > > -- > Thanks, > Deepak Agarwal, > > Mobile: +91 9501190044 >
