Resolved Product and price import hikashop went wrong

Hi Rolandd,

I figured out what happened! I just deleted the 2 imported prices of one of the corrupted products and manually added the prices again: the products was fine again.

I think that when manually adding prices, hikashop fills in some sort of mandatory field in the database. When importing the prices, that step is missed. From the backend (gui) there's no difference between an imported price and a manually filled in price.So, the product didn't get corrupted, the price(s) did.

What I did:
1) manually typed in a few products with 2 prices each
2) imported new products (didn't touch the existing ones)
3) imported the 2 prices (=2 import jobs) for all products (also for the existing products - except one)

My product import has the following fields: category_path, nietverzenden (custom thing), product_access, product_code, product_description, product_name, product_published, product_quantity, product_tax_category, product_weight and product_weight_unit

My price import has the following fields: price_currency_id, product_code, product_price, price_access

So, something was missed during the import!

Ok, I'm back again:

I think it is the field price_site_id of the hikashop_price table.
It is 0 for the imported prices and blank for the manually filled in prices.

Hi Rolandd,

I'm trying now to get a NULL value in the price_site_id during import (as default value), but to start with, I'm having difficulties to get the NULL value in (tried NULL, "", ''). Type is varchar(255).

And, I'm still not sure if this will solve the problem.
I think there are at least 2 things wrong. I see the price_access value of the existing products is shown as ,11, but the import (use the acl group, not id) places the value as 11 in the database (no comma's).

Can you please have a look?

regards

Suzanne

Hello Suzanne,

First things first, you can't import NULL values with CSVI.

The missing comma's is a problem, however that is fixed in the 6.4.2. release, are you using that version?

I believe with the commas fixed, the prices should show correct.

Well, it worked actually. I got the NULL value in, by exporting from MS Access with Null AS price_site_id, but that didn't solve anything. So, don't know what price_site_id actually does, but it didn't make my new products visible nor made my prices show up.

I thinks it's in the ACL names/id's and the comma's.
I am using 6.4.2.

So, there were these two problems:
1) new products not showing
2) prices not showing (after updating prices existing products)

When I edit a newly imported product, remove the shopper ACL, save the product, re-apply the shopper ACL again and save again then this will make the product visible (problem 1 solved).Still no prices though...
But, then, when I remove price-access, save product, re-apply price-access and save again, then this will make the price visible (problem 2 solved).

So... the comma's...
I tried the ACL id's before, but didn't check then what happened in the price_table. I'll try a few things and get back...

Suzanne

Hello Suzanne,

Just to follow-up here. The comma issue was because of a conflict with a patch I sent you earlier, the new patch I sent you fixed it. These fixes will be available in CSVI Pro 6.5.0.