adding customers/employees to a company

  • Posts: 16
  • Thank you received: 0
10 years 6 months ago #154998

-- url of the page with the problem -- : www.etk-mood.nl
-- HikaShop version -- : HikaShop Essential: 2.3.0
-- Joomla version -- : 3.2.3
-- PHP version -- : 5.4.27
-- Browser(s) name and version -- : Safari 7.0.2
-- Error-message(debug-mod must be tuned on) -- : n/a
+ Menu extension -- : Skyline Accordeon Menu (ExtStore)

I have a customer database with companies.
Those companies have a certain id with a personal discount code.
And they have several employees that need to be registered on the site with a personal password to be able to view the companies own specific prices, and they need to be able to order.

Now, if I want to add a new customer, I have to add a new user in Joomla. So far so good, but if I add a new user, although I can give him the same company name, there is no link to other employees of the company. Also I have to fill out all the company info again.

What I would like is to add companies with their own discount code, and then add users to that company.
How can I accomplish this?
Did I overlook something, or do I need an extension?

Thanks!

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 6 months ago #155036

Hi,


How about having one joomla user group per company, restrict your product prices/discounts/coupons per user group (with the access level options of the HikaShop Business edition) and assign each user account to its user group ?
That way, the users would automatically benefit from their company discounts/prices via their user group.

Please Log in or Create an account to join the conversation.

  • Posts: 16
  • Thank you received: 0
10 years 6 months ago #155169

Hi Nicolas,

Thank you for your reply. Perhaps I need to try that instead.
One more question though before I purchase the business edition.

So a company is a Joomla user group.

1. In this group, is it possible to assign different discount percentages to different product categories?
2. Additionally, is it possible to assign a specific discount percentage or a price to one article/product?

If not, can you tell how to solve this?

Thanks,

Lida

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 6 months ago #155222

Hi,

Yes, you can have different discount percentages for different categories/products and for different user groups at the same time.

The following user(s) said Thank You: lidacha

Please Log in or Create an account to join the conversation.

  • Posts: 16
  • Thank you received: 0
10 years 6 months ago #155556

I purchased the Business Edition as you suggested.
But not sure how to continue or how to set all up.

I added a usergroup for a company under level Registered. And gave this the name unique account id of that company.
I added a user (employee) and assigned that user to the new usergroup.

We have four discount files, applied in the order 4 to 1:

4. ACCOUNTGROUP / price-productgroup
9 unique accountgroups, 451 records + discountpercentage.

3. ACCOUNTGROUP / Productnumber
9 unique accountgroups, 3140 records + discountpercentage or price.

2. ACCOUNT ID / price-productgroup
71 records + discountpercentage

1. ACCOUNT ID / Productnumber
1691 records + + discountpercentage or price

So now what?

Of coure I cannot configure all manually. Can you please help? I spent quite a bit of time on this, and not getting anywhere.
Or do I need an extension? Or would ACL be handy?

Hope you can help me.
Thanks,
Lida

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
10 years 6 months ago #155562

Hello Lida,

1. In this group, is it possible to assign different discount percentages to different product categories?
2. Additionally, is it possible to assign a specific discount percentage or a price to one article/product?


1. To do that you'll have to use the "category" or "product" option of your discount configuration page.
2. You'll have to add your user on your new company "usergroup", and use that group through the "Access level" option of your discount configuration page.

The following user(s) said Thank You: lidacha

Please Log in or Create an account to join the conversation.

  • Posts: 16
  • Thank you received: 0
10 years 6 months ago #155651

Thank you. But you are answering a previous questions. Could you look at the last ones? Also the discountgroups are not the same as the categories. The discountgroups are more like brands groups and others while the categories used in the menu are types of the product.
also there are 4 levels of discount.

Hope you can help.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 6 months ago #155697

As far as we understood, the questions of your previous message were all pertaining to your first message. Basically, how to setup the discounts with the user group and category/product restrictions, and thus Mohamed told you how to do that with a bit more precisions on what option to use in HikaShop (which implicitly means that you don't need another extension).

If you want to apply discounts to groups of products which don't match your product categories, you want to create unpublished cateogries and add them to the corresponding products as second categories and use these unpublished categories in your discounts.

The following user(s) said Thank You: lidacha

Please Log in or Create an account to join the conversation.

  • Posts: 16
  • Thank you received: 0
10 years 6 months ago #155720

Thank you Nicolas,

Thank you, but I still have a few questions. Sorry if I am not making myself very clear, but I am still a little confused about how to configure.
I had created different categories for the discount groups, but when I imported products, the test ones from the main category were gone, and they now only appeared in the discount groups. But perhaps if I unpublish these... will look further.

1. As there are 4 types of discount that can apply to a customer, will the discount that generates the lowest price automatically be the price that is displayed?

2. As I have a LOT of records... and I am sure I am not the only one... there must be a way to import these discount records.
Can you tell me how? I don't see an option in the menu.

I will try to configure again...

Thanks.

Lida

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 6 months ago #155732

Hi,

0. The import can remove categories associations. If your CSV has a row for the product with only a discount category configured in the "categories" column of the product, the import system will remove the other category links and only add a link to that discount category for the product already in the database.

1. Not necessarily. If you have a discount configured to apply to a specific product and another one configured to apply to all the products of the category of the product, the first discount will be used in priority since we suppose that if you set a discount on a product, it's because you want it to be used over the other one, which is more global.
But then if you have two discounts applying on two different categories which are both listed in the categories of a product, then the system will indeed take the one which is the most interesting for the customer.

2. There is no option via the interface, but you can actually do it via your PHPMyAdmin. First, export the table hikashop_discount as a CSV via PHPMyAdmin. Then, open your CSV in Excel and add the rows you need, basing yourself on the ones that you already have. And then import back the CSV in the hikashop_discount table via PHPMyAdmin.

The following user(s) said Thank You: lidacha

Please Log in or Create an account to join the conversation.

  • Posts: 16
  • Thank you received: 0
10 years 6 months ago #156551

Hi again,

I uploaded User Groups via PhpMyAdmin. 3000 rows, 2 columns. All went well and I could see them when accessing User Groups in the Administrator.

But when I try to access Users or Global Configuration the screen goes blank. If I delete the User Groups again, the problem with the blank screen is also gone.

I added User Groups in smaller steps. I noticed that if I can add up to roughly 1050 User Groups without a blank screen appearing when selecting Users. And only up to roughly 730 User Groups without a blank screen when selecting Global Configuration.

When almost reaching the limit I get the message:
A script on this page may be busy, or it have stopped responding. You can stop the script now or you can continue to see if the script will complete.
Script: www.etk-mood.nl/media/jui/js/jquery.min.js:2

_____________________________________________________________________

After having read several topics on this on the internet, this one for instance: groups.google.com/forum/#!topic ... pDLD_kOv6c
I tried the following:

In php.ini I changed max_input_vars = 1000 to max_input_vars = 10000
Did not help.

In php.ini I changed post_max_size=40M to post_max_size=256M
Did not help.

In PhpMyAdmin, in _assets table I changed the rules-field varchar(5120) to LONGTEXT.
Did not help.

I contacted my hosting but they say it cannot be a matter of disk space, nor of database limits.


I am getting desperate, no idea where to look, what to try or who to contact...
Or perhaps there is another way to implement a company with several users and several discount rules.

I hope you can help me.

Thank you very much,

Lida

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 6 months ago #156603

Hi,

That's only only method I know of.
These errors means that there are a lot of user groups and that the Joomla javascript/PHP is not coded to support so many user groups.
3000 user groups, that's a lot of user groups.

Maybe ACLManager ( www.aclmanager.net/ ) would be a better alternative to using the standard Joomla user group manager ?

Please Log in or Create an account to join the conversation.

  • Posts: 16
  • Thank you received: 0
10 years 6 months ago #156684

Thank you Nicolas,

but if the only way I can set up a shop with companies, employees and discounts, is using Joomla User Groups for companies, the maximum number of companies is less than 700?
Because that is the max amount of complains I can implement so far without a problem.
It does not seem like an awful lot.

By the way, I contacted ACLManager, and this was their reply:

ACL Manager does not change the way Joomla handles user groups. It does not use the Joomla way to load users and groups in ACL Manager itself, as that could indeed cause performance issues, but it won't change anything for Joomla itself.
So it won't fix issues of Joomla that you can't access currently.

Last edit: 10 years 6 months ago by lidacha.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
10 years 6 months ago #156765

Yes. Actually I'm proposing to use ACL manager instead of the joomla user group manager in order to avoid the performance issues that you got in the group manager of Joomla. AS he says, that should work better with ACL Manager since it doesn't uses Joomla stuff.
However, for the other things that are cannot be handled by ACL manager, if you had a problem with them, you would still have the problem, even with ACL manager.

Usually, user groups are not meant to be used for thousands of groups. But yes, there's room for improvement in the Joomla user group system. Unfortunately, I can't provide a solution for that as it is a limitation of Joomla, not HikaShop. You'll have the same issue with other ecommerce solutions which uses the user groups system of Joomla for their user groups.

Please Log in or Create an account to join the conversation.

  • Posts: 16
  • Thank you received: 0
10 years 6 months ago #156940

Thank you Nicolas,

I have not solved my problem completely, but I had not imported the User Groups the right way. The lft and rgt were not imported.
But although the database tables are ok now (3000 User Groups), it takes a very long time for User Groups in the Administrator to respond, and longer when selecting User Manager. But when trying to access Global Configuration, it takes even longer, and the screen displays the options as plain text, see screenshot attached.

So... what to do. I have not even imported my articles, my discounts, my users, plus the images, and files to go with them.
What do you think, is Hikashop for shops smaller than mine and should I look elsewhere? I really like Hikashop and the support and all. But if it cannot function with my needs, I need another solution.
If you have any suggestions at all, I will welcome them. I spent so much time, and money too, trying to configure this, I now need a solution that works without any problems.

Thanks.

Attachments:

Please Log in or Create an account to join the conversation.

Time to create page: 0.088 seconds
Powered by Kunena Forum