Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Need help - virtuemart price list
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Need help - virtuemart price list
#56970
Re:Need help - virtuemart price list 1 Year, 10 Months ago Karma: 0
BRILLIANT!
Now it works

Is there a way to get the product's category name in there as well?

The table for the category names is called virtuemart_categories_da_dk and the field is called category_name

The category's id is connected to the virtuemart_product_id in the table called virtuemart_product_categories in the field called virtuemart_category_id
I hope you understand

Thank you so much
You are my hero!!!


Finn
The administrator has disabled public write access.
 
#56971
Re:Need help - virtuemart price list 1 Year, 10 Months ago Karma: 670
Use the following query:

Code:


SELECT
  P.product_sku,
  P.product_height,
  PL.product_name,
  PL.product_s_desc,
  PR.product_price,
  C.category_name
FROM
  #__virtuemart_products P INNER JOIN #__virtuemart_products_da_dk PL
    ON P.virtuemart_product_id = PL.virtuemart_product_id
  INNER JOIN #__virtuemart_product_prices PR
    ON P.virtuemart_product_id = PR.virtuemart_product_id
  INNER JOIN #__virtuemart_product_categories PC
    ON PC.virtuemart_product_id = P.virtuemart_product_id
  INNER JOIN #__virtuemart_product_categories_da_dk C
    ON PC.virtuemart_category_id = C.virtuemart_category_id



Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 12