Big file, no prices after import #7136

Hello,

Second thing is that "Append categories" function is not working. It add more categories on

That is exactly what this feature is supposed to do. Set this to No unless you know why you need it ;)

That you see no prices has most likely to do with the shopper group because I do see the prices are being added:

INSERT INTO `jos_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES  ('1','0','745','0','152','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','2015-02-12 20:59:36','680','2015-02-12 20:59:36','680')

the shopper group on the other hand is empty. Any reason why you have no shoppergroup?

Hello,

If you have no specific shopper group the shopper_group_name_price field can be set to *****.

The log file you posted is an empty one. Did you post the wrong one?

Hello,

It doesn't do anything because you have set Overwrite existing data to No. Of course nothing happens because you tell CSVI not to touch existing products. You will have set this to No if you want to update your products.

Hello,

Post me the new debug with the Overwrite data option set to Yes, without this log I can't help.

The salesprice in your import file is not used by CSVI.

So this last one is interesting because when I look at the first product you imported, CSVI finds a price and updates the price for this product to 745:

UPDATE `jos_virtuemart_product_prices` SET `virtuemart_product_id`='1',`virtuemart_shoppergroup_id`='0',`product_price`='745',`override`='0',`product_currency`='152',`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-02-16 10:19:00',`created_by`='680',`modified_on`='2015-02-16 10:19:00',`modified_by`='680',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='1'

This is for the product

UPDATE `jos_virtuemart_products_sr_yu` SET `product_name`='AM MASTER 30-40cm/15mm' WHERE `virtuemart_product_id`='1'

. So let's focus on this product. Do you see this price in the backend?

Hello,

Thank you for the pictures, so we see the price in the backend but not the frontend. The price is there so that is all good. The first thing that comes to mind is cache. This can be several things like SEF URLs, Joomla cache, server cache, browser cache.

Turn off SEF URLs and all the Joomla caching and then see if you get the price but somewhere you are being given some outdated info it seems.

Hello,

Nope, I made import and it is same.

I don't believe anything is wrong with the import because you see the price in the backend and we see the price being updated in the debug log.

You know what is interesting?! On fresh install,on his test products in US dollars all works.Crazy

That almost sounds like you have a misconfiguration. Have you set in the shop settings that your currency is to be accepted?

Let's do a test, create a product manually with that currency and see if it displays or not. As far as I can see there is nothing wrong with your import. The problem seems to be in the output. As you said it works fine with dollars but not with your own currency.

Hello,

Let's say this is good news :) Do a Price export with all fields and post it here please. Let me know what the product ID is of the product we are testing.

Ok, you did a product export and not a price export ;)

If I understand you correctly, it works all good on the product pages but not the module. One thing I noticed looking back at your logs is that the published field is set to 0. In other words, your products are actually not even published. Is it correct that you import your products unpublished?

Apologies, I missed your reply.

Just can not see prices and add to cart btns in moduls and some category pages.

That is very inconsistent isn't it? That almost sounds like caching. Also if you use SEF, try to look at the pages without SEF. Especially because you see all the prices in the backend. Also, you are not using a CDN? That would be another cache to empty.

So looking at your export, I don't see any duplicates or any differences, so that looks all good.

But isn't is strange that if I upload picture manually it is in a moment on, everything visible.

When saving a product VirtueMart cleans all it's caches, perhaps that is the case here.

but no prices and add to cart btn. What do you think?

This would mean that VirtueMart thinks that either the product has no price, or stock control is in place and there is not enough stock. The same happens when using non-SEF and no cache?

What is CDN?

If you have to ask, then you are not using it :) CDN stands for Content Distributed Network.

Hello,

Sent me an email or private message with URL, login details for Joomla and FTP. Also include an example product and example CSV file I can use. I will have a closer look at it.

Ok, details received.

I did an import of the test moje.csv file and it updated the existing product SKU 1092. When checking the front-end, it still shows the price and add-to-cart button.

Is there anything in particular I need to do to make the add-to-cart button disappear?

P.s. I noticed in your template Proizvodi VM that you use the | symbol as separator, you can't. That symbol is reserved for specifying multiple categories.

Not sure what you are trying to tell me. Are you telling me that you fixed it?

Aha :) That would be a great fix if that was the problem. :silly:

Can you tell me the exact steps to reproduce the problem? As I mentioned, I tried it on your site but I can't get it reproduced.

So, I imported the file but which product can I see that has no price and no button now?

Can you sent me the database access as well? This way I can check for any changes between now and when I modify the product manually.

Hello,

So I had a look and what I found is this. After import of the CSV file, some products are shown with a price and some without. Changing 1 product and saving it again, does not make the price show up. I saved the product again, added an image to it, not change.

More interesting is that when I changed the template to the default Protostar, all products have prices and add to cart buttons. So I am quite sure the data in the database is fine but the template decides for some reason not to add the price/button.

This may be something you need to check with the template creator.

Hello,

I don't see why I should create a new product. If you look at the shop and then at this product PUNJENE ROLNICE SA ., this product I changed and saved. None of my changes made the price appear when checking with your template. Changing the template to Protostar does show the price and button.

Because if you create new product and upload new picture from computer everything will be ok.

I thought you said when you modified an imported product and saved it, it would show up. That is what I have tried.

You gave mi classical answer from virtuemart forum support.

That could be but why do you think it has nothing to do with your template?

I do agree it is weird that when we change an imported product nothing shows up on the frontend, as I don't see how that is different from creating a new one.

I still think there is some kind of caching active. That would explain why a new product is shown with everything because there is no cache present for this product.

Do you know if your template uses any kind of caching?

I am not trying to send you somewhere else, was just asking if you can ask about the caching from the template place where you bought it.

Caching is a curse and blessing at the same time. When doing testing caching is horrible because you never know if you are looking at your latest results.

Something else just came to mind, have you tried to test the website locally? That way you can eliminate many of the factors you have no control over when on a server.

Let me know what you find.

Hello,

assist me how to make all pictures displayable on import? Which field I need?

How to import images is explained in the Import VirtueMart 2 images tutorial. You can just use the product import to load the images.