Resolved Import into virtuemart seesm to be wrong

Hello,

i noticed that the first time I try and import the first time it comes up with errors, so i try again and its fine.

Which errors?

you can see the sub categories, which is correct, but there are no products to show.

You are missing the published field in your template. You can add this to the end of the field list in your template, then you don't need to add it to your CSV file. Set the value to 1 or Y. This will make the products show up. As you can see in your screenshot the products are currently unpublished.

Also add to the field list the field product_currency with a default value of your local currency. Now your prices have no currency.

You are going in the right direction for sure.

thanks - I added the published as a default and all the products appear.

I added product_currency and set it to default - British pounds

Its still not showing a price

Hello,

Post your new debug log for me to check.

Sorry - here it is

Ok let's look at the product BC04B. There I see a price is updated as follows:

UPDATE `cjkdz_virtuemart_product_prices` SET `virtuemart_product_id`='186',`virtuemart_shoppergroup_id`='0',`product_price`='18.38',`override`='0',`product_currency`='0',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='2015-03-23 17:10:43',`created_by`='679',`modified_on`='2015-03-23 17:10:43',`modified_by`='679',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='95'

You see there is a currency of 0. That is by the looks of it caused as the product_currency is set to BRITISH POUND but the code for the British Pound is GBP.

See if you change the currency to GBP if that makes a difference.

Nope - didn't work. I also tried setting it to826 which the currency bit suggested - but GBP didn't work either.
I have also noticed that on the test page http://www.tradermick.ee-web.co.uk/index.php/front-page-of-strore there is a category called 'category_path'

Thanks for your help - attached latest log

Edward

there is a category called 'category_path'

That will happen if you have the first line with field names but use the template fields as configuration. In that case you can set in your template to skip the first line.

I also tried setting it to826 which the currency bit suggested

That is not going to work as CSVI is looking for the currency based on the 3-letter-code. Since you posted the debug log with the 826 setting, I can't see if any currency ID is stored.

So I did a test and removed the currency code from one of my prices and VirtueMart still shows the price in the backend. Since the prices are in your system I really don't understand why you don't see any prices when you edit a product. Does the price show up if you manually add a price?

Hi Rolandd

Sorry to be such a pain.... I feel sure that once this clicks for me I'll. Something still isn't right. I have lopped of the header row, and so that's good, I deleted all the categories/products and did an import and got the errors shown below in first-errors.txt.

I then pressed process again, just to see what happened (!) and it was a success. I still have no prices though on the front end or on the product list page 'product price' is blank. If I click onto a product however the cost price, base price and final price are filled in.

Have I got the wrong field in my excel - also attached

I attach the last two logs as well.

Once again thanks for your help.

Hello,

and got the errors shown below in first-errors.txt.

These are actually not errors but informational messages. You can go to System -> Global Configuration -> Server -> Error reporting and set this to System default or if it already is, set it to None. The information messages should be gone.

If I click onto a product however the cost price, base price and final price are filled in.

At least that makes some sense to me since the price is in the database.

Your file looks good, the debug log looks good and you can see the prices when you edit a product. I wonder if something else is wrong.

As I asked before but have not received an answer to, if you save a product with a price manually, does it show up then?

Sorry - forgot about the product.
When i went to add a product as per your instruction I was asked asked to pick the currency - which got me thinking that I hadn't actually set it. And now its all working.

Thanks for your help.

Hopefully that will be it for help! :-)

Thanks for reporting back your solution. I would not have found that