VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: LAP0109 on January 23, 2015, 14:14:58 PM

Title: Change product table of the virtuemart system
Post by: LAP0109 on January 23, 2015, 14:14:58 PM
Hallo everybody

For my website i need to change the product table of the shop from the standard one to my table for some reasons. Is this possible?

kind regards

LAP0109
Title: Re: Change product table of the virtuemart system
Post by: jenkinhill on January 23, 2015, 14:55:32 PM
Please say exactly what you want to do - and why.
Title: Re: Change product table of the virtuemart system
Post by: LAP0109 on January 23, 2015, 15:16:25 PM
I want to organize my products not only from the shop, also from a application that runs on a computer. I want to make an mysql databse + a table(where all the products are in) and then use these tablecontent for my app and the shop. I cannot use the virtuemart standard table because i need some more infomations in the table. My question is now, is it possible to say virtuemart that it has to use my table and not the standard tables?

I hope these explains it a little bit more, just ask if you haven't understood everything.
Title: Re: Change product table of the virtuemart system
Post by: GJC Web Design on January 23, 2015, 23:17:02 PM
IMHO a huge job - VM has many inter-related tables with dependencies between them - the products aren't just in one table - there are relationships between prices, cats, images, etc etc

if your going to hack VM why not add the missing fields you need?
Title: Re: Change product table of the virtuemart system
Post by: LAP0109 on January 24, 2015, 09:44:16 AM
That wouldn't help me. I want all the informations in one table, so i can easily insert update or delete one product from the application. The idee of this all is that i want to have a application that manages the products and that the shop(virtuemart) just takes these products and shows them in the shop and of course be able to sell them.
If this isn't easy to make with virtuemart, have you any other idee how i can makes this?
Title: Re: Change product table of the virtuemart system
Post by: GJC Web Design on January 24, 2015, 11:21:23 AM
QuoteIf this isn't easy to make with virtuemart, have you any other idee how i can makes this?
No ... VM has a totally different architecture
Title: Re: Change product table of the virtuemart system
Post by: LAP0109 on January 24, 2015, 11:26:54 AM
Ok thats not cool

Is it maybe possible to update the products of the shop lets say every evening with a csv file or something? So that i make it with my own product table and just update the content of the shop every evening?

Sounds this possible and makeable?
Title: Re: Change product table of the virtuemart system
Post by: GJC Web Design on January 24, 2015, 12:19:03 PM
csvi is the tool for that - has been mentioned many times on this forum
Title: Re: Change product table of the virtuemart system
Post by: jenkinhill on January 24, 2015, 12:27:24 PM
http://www.csvimproved.com