Resolved Import prices into HikaShop (from VM3.x)

Hello,

OK, I've installed all the sample templates and run the HikaShop product export template but it doesn't give me all the data I need i.e. price and related products? The odd thing is, is that they are listed on the template.

Can you send us the debug log of the import? product_price and related_products are supported in HikaShop product export operation so you should be seeing these data if they are in your database. If you don't know on how to get debug log, check Where to get the debug information? section on top of this page.

UPDATE - So I figured out that I can only export either product or price tables at once - is that correct?

It depends on the type of fields you are trying to export. Few product price fields are supported in product export too. It is that If you have product_code/product_sku in your import file, CSVI automatically links the prices to product.

I tried to re-import but it didn't seem to take? I'm getting an error in the log saying ... Missing required field %s ???

I am not sure which import you are doing, you need to send us your debug log to check. It seems that you are missing a required field in your import file. You can check import VirtueMart product and import product prices document to know about the required fields.

Hi, here is the debug log.


com_csvi.log.29.zip


I'm importing into HikaShop - I exported the 2 fields, changed the prices in bulk and then tried to re-import. The confusion is probably caused by the title (I've has to put the order import on hold for now as this is a higher priority).

Thanks for you help

Ok, so I've looked at the log and it gives nothing away. I also read your guide for troubleshooting import errors and I seem to be OK. This is the log details screenshot - it refers to missing %s which is a script variable in MySQL?


Need to get this sorted as I'm getting complaints of incorrect prices in HikaShop.

Thanks.

Hello,

So I figured out that I can only export either product or price tables at once - is that correct?

That is not correct. You can export the product_code and product_price field at the same time.

Ok, so I've looked at the log and it gives nothing away.

Tharuna was actually talking about the debug log not the displayed log. However I can see enough to know what is going wrong. You exported the price_product_id and price_value fields but you should at least be using the product_code field on the import. That way CSVI knows to which product the price belongs.

So if you have a file with product_sku and price_value you should be good to go.

P.s. I split this topic from the original one to stay on-topic.

Thanks Roland, I'm actually exporting from HikaShop, changing the prices in bulk and re-importing into HikaShop. What HikaShop fields do I need as a minimum please.

p.s. the log was in the post above.

EDIT -
So I added the product_code field and it worked!

EDIT2 -
I spoke too soon - it looks like it did it but when I look at the logs it's not actually using the new data?

HikaShop-Products-Export-07oct16-UPDATED-prices-only-2.csv


com_csvi.log.39.zip


As an example, the item with price_product_id of 123 had a pre-tax price of 2.08333, I changed it to 2.5 (on the above import csv) but the sql in the log is telling it to update to 2.08333 again???

Hello,
To update new prices, you need to have price_value_new field with new prices and so CSVI knows that you are trying to update the prices. Change your price_value field to price_value_new in your import file and try doing the import.

That doesn't work either - I'm back to the missing field %s error. Why is this so difficult? I've been trying to import these prices for 5 days now!

Log attached.
com_csvi.log.56.zip

Hello,

What HikaShop fields do I need as a minimum please.

Ok, your explanation is clear to me. So to update prices, CSVI must have the old and the new price. The minimum number of fields you need for export are:

• product_code
• price_value

. The minimum number of fields you need for the import are

• product_code
• price_value
• price_value_new

. The price_value_new column will then have the new price you want. To not have to copy everything you could include the price_value field twice in the export but the second field give it the name price_value_new so it is already filled. You only need to change the prices for the products you need. The rest will be imported with the same price again.

Let me know how it goes.

Great, that finally did it Roland.

Thank you for your help.

Glad to hear it all worked out.