Jack_mcs Posted June 21, 2009 Posted June 21, 2009 (edited) This contribution provides a way to add and track sales people that are attached to your shop in some way. Some of the options are: - Sales people are assigned to groups for better control. - A sales commission is assigned each group. - Various reports can be generated for each sales person or group. Jack Edited June 21, 2009 by Jack_mcs Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
chooch Posted June 22, 2009 Posted June 22, 2009 (edited) Hi Jack, I had a quick look at the files but have not added them to a store yet until I am sure as to what the contribution does. I think I understand how part of the contribution works. You add people in admin but how does the front end customer and the sales rep link together? Does the customer select a rep from a list of reps in checkout or does the rep give a code to enter at checkout? Also if any sales are generated via a rep then does the module allow for the rep to have access to that information? Finally in your opinion does this contribution compliment, hinder or not affect the oscAffiliates contribution and do you think it can be used as a substitute for oscAffiliates? Many Thanks Edited June 22, 2009 by chooch Quote Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH
Jack_mcs Posted June 22, 2009 Author Posted June 22, 2009 There is a dropdiwon on the checkout shipping page where the customer seltects their sales rep. No, the sales rep doesn't have access although that would be a relatively simple page to create. It won't have any affect on the affiliates contribution. I don't think it could substitute for it since it only tracks sales reps where affiliates tracks everyone. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
Guest Posted July 3, 2009 Posted July 3, 2009 Hi Jack, I wanted to ask you if there is any way to activate and deactivate this? Thanks Quote
Jack_mcs Posted July 3, 2009 Author Posted July 3, 2009 No, there's not. You would have to remove the changes from the checkout pages. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
chee Posted July 8, 2009 Posted July 8, 2009 Great Contribution but some bugs or installation steps missed. All works well except on report, order entry are multiple, sometimes 1, sometimes twice or more. Any idea? Quote
Jack_mcs Posted July 8, 2009 Author Posted July 8, 2009 Please be more specific so I can test it here. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
chee Posted July 14, 2009 Posted July 14, 2009 Please be more specific so I can test it here. Jack Hi Jack, on the report section on admin, normally 1 order 1 commission entry. But the same order got multiple entry, somehow it recorded more than one time. Any idea? Quote
Jack_mcs Posted July 14, 2009 Author Posted July 14, 2009 Is the order ID in the report the same in the duplicates? Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
chee Posted July 16, 2009 Posted July 16, 2009 Is the order ID in the report the same in the duplicates? Jack Yes all field data is same and same ID. Meaning it seems to "insert" a few times. Quote
Jack_mcs Posted July 16, 2009 Author Posted July 16, 2009 Hmm, I don't know what could be causing that. It works fine for me here and in the shops I've installed it into. What versions of php and mysql is your server using? Maybe that is causing an issue. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
chee Posted July 17, 2009 Posted July 17, 2009 Hmm, I don't know what could be causing that. It works fine for me here and in the shops I've installed it into. What versions of php and mysql is your server using? Maybe that is causing an issue. Jack i have check the "order" db and the sales person recorded is fine. It seems the /admin/includes/modules/sales_reports.php line 145 sql query statement issue? Quote
Jack_mcs Posted July 18, 2009 Author Posted July 18, 2009 I don't see anything wrong with that statement and it should be mysql 5 compatible. But if your database has multiple (duplicate) entries in the sales tables, then that code will just show them all. So the problem may be on the other side where the data gets entered. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
chee Posted July 18, 2009 Posted July 18, 2009 (edited) I don't see anything wrong with that statement and it should be mysql 5 compatible. But if your database has multiple (duplicate) entries in the sales tables, then that code will just show them all. So the problem may be on the other side where the data gets entered. Jack Hmm strange. Can i know where is the part of the code it "insert" the salesforce? Is it on the customer order table where it links to the salesforce sales person ID on the orderID? if so, there is only 1 order entry as I checked. No duplicate orderID. OH I am using mysql v4. Edited July 18, 2009 by chee Quote
Jack_mcs Posted July 18, 2009 Author Posted July 18, 2009 The orders tables are updated by an order as they always were with this contribution except the sales reps information is also stored. So unless you made a mistake in those edites, I don't think those tables wouldn't be the cause. The sales force tables are also updated. I suppose there could be a mistake there, although I'm not seeing it. But as with most options in oscommerce, the code in the sales reports page in admin is just loading what has been saved. So you need to determine if the problem is on the shop side or the admin side. I'm sorry I can't be more help but it works fine here. Maybe installing it into a clean shop to see if it works at all for you would be a good way to go. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
chee Posted July 18, 2009 Posted July 18, 2009 The orders tables are updated by an order as they always were with this contribution except the sales reps information is also stored. So unless you made a mistake in those edites, I don't think those tables wouldn't be the cause. The sales force tables are also updated. I suppose there could be a mistake there, although I'm not seeing it. But as with most options in oscommerce, the code in the sales reports page in admin is just loading what has been saved. So you need to determine if the problem is on the shop side or the admin side. I'm sorry I can't be more help but it works fine here. Maybe installing it into a clean shop to see if it works at all for you would be a good way to go. Jack yes i think should not be the order database. The strange part is that the report output sometimes 2 entries, sometimes 3 upto 6 entries and not consistent. Meaning somewhere on the query looping issue i suppose. Still trying to find out. Quote
reidwalley Posted August 22, 2009 Posted August 22, 2009 This contribution provides a way to add and track sales people that are attached to your shop in some way. Some of the options are: - Sales people are assigned to groups for better control. - A sales commission is assigned each group. - Various reports can be generated for each sales person or group. Jack Re: Commission field Thanks for a great contrib. When I set up a Sales Group via the Admin the commission field states "* Required (a number between 0 and 1)". I can't seem to enter 15% as 0.15, it just keeps resetting to 1.00. How can I enter 0.15 in the commission field.? Quote
Jack_mcs Posted August 22, 2009 Author Posted August 22, 2009 Re: Commission field Thanks for a great contrib. When I set up a Sales Group via the Admin the commission field states "* Required (a number between 0 and 1)". I can't seem to enter 15% as 0.15, it just keeps resetting to 1.00. How can I enter 0.15 in the commission field.? If you are referring to editing a commission, there is a coding problem in the sales_group.php file. To fix it, find default: and change to default: echo tep_draw_hidden_field('group_id', $group_id); If you are referring to entering a number on a new group, use .15, not 0.15. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
reidwalley Posted August 23, 2009 Posted August 23, 2009 (edited) If you are referring to editing a commission, there is a coding problem in the sales_group.php file. To fix it, find default: and change to default: echo tep_draw_hidden_field('group_id', $group_id); If you are referring to entering a number on a new group, use .15, not 0.15. Jack Thanks for both recommendations - worked like a charm! Edited August 23, 2009 by reidwalley Quote
axioma Posted September 20, 2009 Posted September 20, 2009 I dont want to the catalog side, i want only use admin side, in order to receive order by phone.... is that possible? thanks Quote
Jack_mcs Posted September 20, 2009 Author Posted September 20, 2009 This contribution works with the order code. It will not allow you to take orders in any way. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
chee Posted October 23, 2009 Posted October 23, 2009 The orders tables are updated by an order as they always were with this contribution except the sales reps information is also stored. So unless you made a mistake in those edites, I don't think those tables wouldn't be the cause. The sales force tables are also updated. I suppose there could be a mistake there, although I'm not seeing it. But as with most options in oscommerce, the code in the sales reports page in admin is just loading what has been saved. So you need to determine if the problem is on the shop side or the admin side. I'm sorry I can't be more help but it works fine here. Maybe installing it into a clean shop to see if it works at all for you would be a good way to go. Jack still having same issues, comments out your line 57, it is showing this. Any idea!? new line at 0 - 1 - Jeff new line at 1 - 2 - Outlet1 new line at 2 - 3 - 2726 new line at 3 - 4 - 10/01/2009 new line at 4 - 5 - new line at 5 - 6 - Online Store new line at 6 - 7 - new line at 7 - 8 - new line at 8 - 9 - new line at 9 - 10 - new line at 10 - 11 - 8.80 new line at 0 - 12 - Outlet1 new line at 1 - 13 - 2726 new line at 2 - 14 - 10/01/2009 new line at 3 - 15 - new line at 4 - 16 - Online Store new line at 5 - 17 - new line at 6 - 18 - new line at 7 - 19 - new line at 8 - 20 - new line at 9 - 21 - 8.80 new line at 10 - 22 - Jeff new line at 0 - 23 - 2726 new line at 1 - 24 - 10/01/2009 new line at 2 - 25 - new line at 3 - 26 - Online Store new line at 4 - 27 - new line at 5 - 28 - new line at 6 - 29 - new line at 7 - 30 - Quote
Jack_mcs Posted October 23, 2009 Author Posted October 23, 2009 Does that happen in a new, clean shop, as suggested? Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
2johnsons Posted October 27, 2009 Posted October 27, 2009 I installed the SalesForce contribution and as i was testing out my site I was unable to complete a transaction at checkout unless I chose a sales person. I don't want this to be a problem for people visiting my site from search engines,advertisements, etc... that do not have a sale rep. How do I correct this? Some of my customers will not have sales reps at all. Thank you Quote
Jack_mcs Posted October 27, 2009 Author Posted October 27, 2009 I installed the SalesForce contribution and as i was testing out my site I was unable to complete a transaction at checkout unless I chose a sales person. I don't want this to be a problem for people visiting my site from search engines,advertisements, etc... that do not have a sale rep. How do I correct this? Some of my customers will not have sales reps at all. Thank you Search engines shouldn't be able to get to the checkout shipping page so that isn't a concern. For the rest, you can create a sales rep named "No Sales Rep," or something like that so the person doesn't have to have a sales rep assigned. Otherwise, the code would have to be altered to remove the checking of the sales rep. But if you do that, you will probably get a lot of wrong selections since people will not select it and which ever rep is showing will be the one selected and that would defeat a large part of the reason of the addon. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.