Registers users can not see prices when uploaded with csv

  • Posts: 85
  • Thank you received: 1
  • Hikashop Business
3 years 11 months ago #326816

Hi there
I have setup only registered users to see the prices. When uploaded products from the menu products -> new products etc set the price for registers and then all ok only registered users can see the prices.
The problem start when upload products mass via csv file. So all the new products from csv file have the price only for registered users (here ok) but in this case they can't see the price (registered users). The only solution that i found is to open each one product to click in price -> Restrictions to unclick the regitered to click again and save! Then users can see the price. But is not a soluton because i have to do it for more than 1000 products!
May do you know how to fix it?

thanks!

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

  • Posts: 82864
  • Thank you received: 13372
  • MODERATOR
3 years 11 months ago #326828

Hi,

That means that you have an error in your CSV file.
I suppose that in the price_access column of your CSV, you've entered something like this:
xxx,yyy,zzz
where xxx yyy and zzz are the ids of user groups. But that's not correct. Instead you should have:
,xxx,yyy,zzz,
The commas at the beginning and the end allows for MySQL queries optimizations which aren't possible without the commas there.
When you go through the interface, HikaShop adds them properly. But if you go through the import, the import process imports what you're giving it and doesn't check these commas.
Going through the interface and saving the access levels once allow for HikaShop to fix the commas which is why it then works.
So I'll recommend you review your CSV file.

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

Time to create page: 0.055 seconds
Powered by Kunena Forum