How to take out hammer and other defauld products in VM 304

[ivacademyru]

I just install latest VM 304 and it shows between my shop products VM default products hummer etc please check www.kupiti-kover.ru.

How to take out hammer and other default products in VM 304? I couldnt find them in admin panel but it show in frontpage

[jenkinhill]

You must have installed default products in an earlier version and not deleted them before adding your own products? They don't exist in 3.0.4 sample data.  Not seen that before, but they must be in the database so I'm surprised they don't also show in the BE product list.  I'd try using Install or if necessary update tables facility in Tools.

[GJC Web Design]

with bizzare urls as well - very odd   ->   http://www.kupiti-kover.ru/index.php/-detail.html

you might have to actually track them down directly in the DB tables - is this a migration from an older version?

[ivacademyru]

yes i migrate my shopm from vm2 to vm3

[GJC Web Design]

they are left over somewhere in some but not all tables - check all the #__virtuemart_products_xxxx tables

find it's product id from #__virtuemart_products (and probably the #__virtuemart_products_en_gb ) and remove any entries

a thought - if you change your admin to english do they show up in admin?

[ivacademyru]

Yes BUT there in administrator I couldnt see this VM default product even serch by id etc these products are shown only in frontend

[GJC Web Design]

and so?

to show they have to be in the tables whether u can see them in admin or not.. unless there's some sort of freaky half-life out of soul experience going on... ?

ghost hammers..... 

[ivacademyru]

Yes ghost hammer so to take out need to reset DB?

[GJC Web Design]

just remove them if they exist individually -- how many can there be - 20 mins work max

[ivacademyru]

Yes thank you for the answer but to remove them hammer suppose to be at list in admin area BUT they are not there!!! I reset DB in vm admin BUT VMghost-dafauld products still remain in frontend . Do you know where actualy default products of VM  are located to removed them out?

[GJC Web Design]

You can keep banging on that they aren't in your admin till the cows come home.. yes - they aren't there..  so? 
Your solution?
There is none -- take them out directly in the DB .. just repeating the same complaint over and over doesn't help you

[ivacademyru]

  If id know where to search it in DB I will rather not spend time in vmforum for sure

[GJC Web Design]

If you look in the db it is sooo obvious where and what the tables are ..
they are clearly labelled as to what they are for

#__virtuemart_products ...  what could be clearer?

#__virtuemart_products_en_gb  -> all product parameters that are lang based -> english - linked by unique product ids

#__virtuemart_products_ru_ru

beginning to see a pattern here?

[ivacademyru]

Hi I take out all products in DB within the #__virtuemart_products_en_gb so products photos/images disapear but still remain this products in the shop. Could somebody give me an advice how to remove hummer and all default products from VM3?

[ivacademyru]

Seems like there is not a solution for this problem I take out all products in DB within the #__virtuemart_products_en_gb so products photos/images disapear but still remain this products in my shop http://www.kupiti-cover.ru/index.php/glavnaya-2.html?dir=ASC. Could somebody give me an advice how to remove hummer and all default products details from VM3?