Price shows Free in frontend, but it is set in backend with Restrictions

  • Posts: 174
  • Thank you received: 2
  • Hikashop Business
3 years 5 months ago #336154

Imported products using csv. I have two prices for products for different user groups (Access levels). The backend shows everything fine, but on frontend for users that is in group "Registered" the price is not showing. In backend i can see that price for "Registered" users are set correctly. When i remove "Registred" from access level in backend, save product and then again add "Registred" in aceess level all works fine. Simple "open and save" product does not solve my problem. I need to remove (uncheck the checkbox), save and check again and save for solve this. Its too complicated for thousands of products, how to solve this?

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

  • Posts: 83402
  • Thank you received: 13496
  • MODERATOR
3 years 5 months ago #336159

Hi,

The issue is probably with your CSV file.
In the price_access column, the ids of user groups need to be prefixed a postfixed with a comma.
So if you want to set the price for the user groups with the ids 11 and 5, you need to have that text in that column:

,11,5,
and not
11,5
That's because when the search is made, it searches for ,11, or ,5,
If it was searching for 11 only, then it would match with the user group with the id 115, the one with the id 211, etc.

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

  • Posts: 174
  • Thank you received: 2
  • Hikashop Business
3 years 5 months ago #336179

The problem is that all these products was imported long time ago, and i don't have csv file now. But in backend everything is displayed correctly all the prices and user groups is displayed correctly. Is it possible to fix it?

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

  • Posts: 83402
  • Thank you received: 13496
  • MODERATOR
3 years 5 months ago #336183

Hi,

Well, it probably is possible.
Check the table hikashop_price in your database via your PHPMyAdmin.
There, you should see what you have under the price_access column.
If many prices have the same text in that price_access column, then you can update them all by running a MySQL query in your PHPMyAdmin.
For example, if you have 11,5 instead of ,11,5, in many of your products, you can run this MySQL query:

UPDATE #__hikashop_price SET price_access = ',11,5,' WHERE price_access = '11,5';
Note that you need to replace #__ by the prefix of your tables.
That will fix for access level on the prices of all these products.

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

Time to create page: 0.061 seconds
Powered by Kunena Forum