Avisos
Vaciar todo
Hola,
Tengo productos sin stock y quiero ponerlos no visibles, como se puede hacer via SQL que es mas sencillo para mi.
Lo único es que no conozco las tablas y sus relaciones entre ellas, hay algun manual que lo explique?
saludos
Paco
URL del sitio: Contenido solo visible a usuarios registrados
Respondido : 20/12/2014 11:50 pm
Hola Francisco,
Revisa este hilo del Foro por si te es de utilidad:
- https://www.webempresa.com/foro/30-VirtueMart-20/37926-Quitar-control-de-stock-en-Virtuemart-20.html
No te recomiendo hacer el cambio que indicas en la base de datos.
Estas son todas las tablas de VirtueMart 2.6.x:
w47fa_virtuemart_adminmenuentries
w47fa_virtuemart_calcs
w47fa_virtuemart_calc_categories
w47fa_virtuemart_calc_countries
w47fa_virtuemart_calc_manufacturers
w47fa_virtuemart_calc_shoppergroups
w47fa_virtuemart_calc_states
w47fa_virtuemart_categories
w47fa_virtuemart_categories_es_es
w47fa_virtuemart_category_categories
w47fa_virtuemart_category_medias
w47fa_virtuemart_configs
w47fa_virtuemart_countries
w47fa_virtuemart_coupons
w47fa_virtuemart_currencies
w47fa_virtuemart_customs
w47fa_virtuemart_favorites
w47fa_virtuemart_favorites_log
w47fa_virtuemart_favorites_sh
w47fa_virtuemart_invoices
w47fa_virtuemart_manufacturercategories
w47fa_virtuemart_manufacturercategories_es_es
w47fa_virtuemart_manufacturers
w47fa_virtuemart_manufacturers_es_es
w47fa_virtuemart_manufacturer_medias
w47fa_virtuemart_medias
w47fa_virtuemart_migration_oldtonew_ids
w47fa_virtuemart_modules
w47fa_virtuemart_orders
w47fa_virtuemart_orderstates
w47fa_virtuemart_order_calc_rules
w47fa_virtuemart_order_histories
w47fa_virtuemart_order_items
w47fa_virtuemart_order_userinfos
w47fa_virtuemart_paymentmethods
w47fa_virtuemart_paymentmethods_es_es
w47fa_virtuemart_paymentmethod_shoppergroups
w47fa_virtuemart_payment_plg_paypal
w47fa_virtuemart_payment_plg_servired
w47fa_virtuemart_payment_plg_standard
w47fa_virtuemart_permgroups
w47fa_virtuemart_products
w47fa_virtuemart_products_es_es
w47fa_virtuemart_product_categories
w47fa_virtuemart_product_customfields
w47fa_virtuemart_product_downloads
w47fa_virtuemart_product_manufacturers
w47fa_virtuemart_product_medias
w47fa_virtuemart_product_prices
w47fa_virtuemart_product_relations
w47fa_virtuemart_product_shoppergroups
w47fa_virtuemart_ratings
w47fa_virtuemart_rating_reviews
w47fa_virtuemart_rating_votes
w47fa_virtuemart_shipmentmethods
w47fa_virtuemart_shipmentmethods_es_es
w47fa_virtuemart_shipmentmethod_shoppergroups
w47fa_virtuemart_shipment_plg_weight_countries
w47fa_virtuemart_shoppergroups
w47fa_virtuemart_states
w47fa_virtuemart_userfields
w47fa_virtuemart_userfield_values
w47fa_virtuemart_userinfos
w47fa_virtuemart_vendors
w47fa_virtuemart_vendors_es_es
w47fa_virtuemart_vendor_medias
w47fa_virtuemart_vmusers
w47fa_virtuemart_vmuser_shoppergroups
w47fa_virtuemart_waitingusers
w47fa_virtuemart_worldzones
No tengo información sobre la estructura y su relacionamiento.
Saludos
Respondido : 21/12/2014 12:56 am
