Quantity for each Combination(helpme!:S)

[gzoztra]

help me !

im going crazy

 

how can i see the quantity not for all the combinations together in total

 

but for each one in separte so i could track of each and every size of product i have ?

 

any idea ?

 

thanks, im going crazy here

 

 

for exemple if you didnt understood it

 

i got 1.0 parfum

1.7 and 3.4 in combination but when i see in catalog the quantity it shows me everything together

i need them separtly to show me that .. :wacko:

[tomerg3]

you can see it in the combination tab of the product editor.

[gzoztra]

you can see it in the combination tab of the product editor.

 

thanks for the reply, i can only see it one by one like that, i was looking for something to show me :

 

All items in a list, with quantity per each combination

 

like this :

 

Amor Amor by Cacharel

1.7 oz - 5

2.2 - 2

3.0 - 9

3.4 - 4

 

bvlgari

1.0 - 6

1.7 - 7

3.4 - 5

 

i was looking to gather it all together instead of going one by one by one...

 

i got about 1000 different products, with 2-3 combinations each,and each one is with a different quantity..so i was looking for a list where i could see like how i wrote..

 

any idea ?

Edited July 29, 2012 by gzoztra (see edit history)

[tomerg3]

You can create a SQL query that will show those results.

The info is stored in the DB ps_product_attribute table

[gzoztra]

You can create a SQL query that will show those results.

The info is stored in the DB ps_product_attribute table

 

 

i tried to google how to do it and came across a few articles but even the Dummies one was a problem for me, any video guide or place you can recommend that might and help me ? any modules for it ?

 

thanks for the fast response btw.. appreciate it

[tomerg3]

It really depends on what information you want from that table.

You can start with running this in phpMyAdmin

SELECT * FROM ps_product_attribute

And then select only the columns you want.

[gzoztra]

It really depends on what information you want from that table.

You can start with running this in phpMyAdmin

SELECT * FROM ps_product_attribute

And then select only the columns you want.

 

is there a way to see the product name on it instead of just the product id ?

[tomerg3]

yes, add a a left join on the product table (on id_product)

[gzoztra]

yes, add a a left join on the product table (on id_product)

 

i didn't understood what you directed me to do :S

heres a screenshot

 

[gzoztra]

Bump...any clue ?

[tomerg3]

Try

SELECT pl.name, pa.id_product_attribute, pa.quantity FROM ps_product_attribute pa
LEFT JOIN ps_product_lang pl ON pl.id_product = pa.id_product AND pl.id_lang = 1

[gzoztra]

it didnt worked but even with all the attributes shown i cant see the name of the product, only the id #

 

any idea ?