Resolved Create Shopper groups and add products on import

Hello,

I understand your issue but which extension do you want to import data into, VirtueMart or HikaShop? Let's assume you use VirtueMart. If you want to assign shopper groups to products, the shopper group should already exist. Multiple shopper groups are separated by a |.

In case you want more feedback, post the information requested at the top of this page under Looking for a useful answer?.

Hi Roland

Thank you for responding. I am exporting into Virtuemart 3. I have already created the shopper groups prior to trying to import.

Sample csv attached

Thank you famous_csv_26_aug_2017_sample.csv

Hello,

I need the debug log as well as requested at the top of this page under Looking for a useful answer?

Apologies. Was using my mobile so missed some of the page.

I have tried again and the product is now being imported into the shopper group. However it is not setting up in the price section. Only that shopper group should be able to see those prices. Log file is not being accepted as it is 514kb

Thanks again for your help

Not having a good day. Please find zipped log attached com_csvi.log.158.zip

Hello,

Ok, so we are talking about the shopper groups for prices and not the shopper groups for products. That makes a world of difference actually. Adding or updating shopper groups for price tiers requires more data as CSVI needs to pinpoint the correct price.

So to use the shopper group of the price you need to use the field shopper_group_name_price. So here is a query where CSVI is looking for a given price:

SELECT `virtuemart_product_price_id` FROM `efamo_virtuemart_product_prices` WHERE `virtuemart_product_id` = 1 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 7 AND `product_currency` = 153 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'

As you can see here, the quantities are important as well, in case you are using multiple prices.

If I look at your screenshot I see that the prices have no settings are than just the price and the shoppergroup. This makes it impossible for CSVI to know which price you want to update. There is no distinctive characteristic on them. If it is only to change the shoppergroup name on multiple existing prices, you will have to use the Price import. This import has the fields shopper_group_name and shopper_group_name_new available, so CSVI can find the price based on the shopper group name.

Hope that clears things up.

HI Roland

Thank you so much for that. I think I understand what to do now. Will keep you posted if I get stuck

Much appreciated

Tony