Search the Community

Hi there I need to write a MySQL query to get a list of all attribute groups and attributes for a given product. Here's some pseudocode (pseudoSQL): SELECT attribute_group_name, attribute_name, ps_product_attribute.price FROM ps_product_attribute JOIN .... ...WHERE ps_product_attribute.id_product = 23 It's so (in another application) I can generate dropdowns for users to choose product attributes. I need to show the impact on the product price of each attribute. But I'm confused, because I need to link ps_product_attribute to either ps_product_attrbute_combination or ps_attribute_impact, in order then to link to table ps_attribute, and when I do that, I get duplicate values that I can't get rid of with a SELECT DISTINCT. Can anyone tell me what tables I need to use to simplify my query? Thanks for your help! Dave

Hi, I have shop that sells images in various formats, canvases, posters, wall murals etc. I've sorted the combinations out against one of the store's products and done some javascript magic to hide and show various attributes. This is all working as I want. Now I need these combinations/attributes pushed out to all the other products in the store. Could anyone point me at the tables I'll need to populate in order to accomlpish this? I've seen a module that'll do product attribute copying by Presto Changeo but being an Oracle developer by trade think it's unnessary as I'm sure the script can't be too difficult. Any direction and help will be greatfully recieved. Many thanks.

Χερεται, θα ηθελα να μαθω πως μπορουμε να τροποποιησουμε την οθονη εισαγωγης προιοντων δινοντας ετσι την δυνατοτητα να εισαγουμε attributes combinations με την μια χωρις να χρειαζεται να αλλαζουμε tabs χανοντας χρονο. Για να γινω ποιο σαφης θελω να δημειουργησω ενα καταστημα πωλησης ελαστικων και θα ηθελα απο την αρχικη οθονη του προιοντος να φενονται τα attributes group με δικαιομα επιλογης για το πλατος το υψος και το size του ελαστικου. πως μπορει να γινει αυτο

Hello to everyone and a happy new year! I would like to create 3 attributes group (Brand, model, year) and create combinations between each brand with their models and year. The problem is after i use Attributes generator to create my attribute when i select a specific brand i have all the models available for selection from all the brand, but i need to have models from the specific selected brand. for farther info see the link please. http://caraccessories.com.cy/product.php?id_product=269