VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: ivacademyru on February 01, 2015, 23:32:03 PM

Title: How to take out hammer and other defauld products in VM 304
Post by: ivacademyru on February 01, 2015, 23:32:03 PM
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
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: jenkinhill on February 01, 2015, 23:46:51 PM
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.
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: GJC Web Design on February 01, 2015, 23:52:30 PM
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?
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: ivacademyru on February 02, 2015, 09:44:05 AM
yes i migrate my shopm from vm2 to vm3
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: GJC Web Design on February 02, 2015, 11:15:40 AM
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?
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: ivacademyru on February 04, 2015, 20:53:22 PM
Yes BUT there in administrator I couldnt see this VM default product even serch by id etc these products are shown only in frontend
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: GJC Web Design on February 04, 2015, 22:13:53 PM
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.....  :o
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: ivacademyru on February 05, 2015, 20:43:07 PM
Yes ghost hammer so to take out need to reset DB?
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: GJC Web Design on February 05, 2015, 21:56:01 PM
just remove them if they exist individually -- how many can there be - 20 mins work max
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: ivacademyru on February 07, 2015, 10:25:10 AM
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?
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: GJC Web Design on February 07, 2015, 10:33:29 AM
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
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: ivacademyru on February 07, 2015, 22:07:49 PM
 ;D If id know where to search it in DB I will rather not spend time in vmforum for sure
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: GJC Web Design on February 08, 2015, 00:19:47 AM
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?
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: ivacademyru on May 21, 2015, 18:28:12 PM
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?
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: ivacademyru on June 17, 2015, 15:14:29 PM
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?
Title: Re: How to take out hammer and other defauld products in VM 304
Post by: rs3511 on June 17, 2015, 23:16:20 PM
Although I may be wrong because I have never seen that happen, I think you will have to identify the product IDs and remove the IDs from _virtuemart_products table in addition to the _virtuemart_products_en_gb.