News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Change product table of the virtuemart system

Started by LAP0109, January 23, 2015, 14:14:58 PM

Previous topic - Next topic

LAP0109

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

jenkinhill

Please say exactly what you want to do - and why.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

LAP0109

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.

GJC Web Design

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?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

LAP0109

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?

GJC Web Design

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

LAP0109

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?

GJC Web Design

csvi is the tool for that - has been mentioned many times on this forum
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum