Trying to get Product and price list

[chris ashdown]

Trying to get a product and price list out of V11,

Can export to excell but end up with

Product
Attribute
and a list of all the choices
then next product etc

Need a way to just list the product and price, have excell and acess, butonly used acess about 10 years ago so not what you would call competent

A few thousand products so highlight and delete would take ages

[Duncan Rounding]

Close Sellerdeck.
In Excel go to Data - From Access, browse to your database and open, select Product in the list and OK.
Leave settings as default and OK again.
You should now see a worksheet with all the product data in it ready for you to play with.

[chris ashdown]

Thanks duncan

But that just gets a list of Products, I also want associated prices

[fergusw]

Or (inside SellerDeck design):
- create a new overall layout
- create a block which is EntiireProductList
- Put

"Product Reference" , "Product Name", "Retail Price Layout" <br/>

in the layout.
- assign layout to temp/dummy brochure page
- do offline preview
- save viewed page as page.csv
- open in excel

It basically loops through all the products spitting out a comma-separated list or each product reference, name and price, line by line.

Duncan's way is easier, but the above way gives you total control of info you get out.

[fergusw]

Thanks duncan

But that just gets a list of Products, I also want associated prices

Slightly trickier.
Are these associated prices set at component permutations level?

My way, with a bit more lateral thinking and playing with component layouts, could give you what you need.
It depends on how you want the csv format to represent a variable output i.e. how would it handle 1 product with 5 permutation prices versus another that may have 50 permutation prices?

[chris ashdown]

Hi Fergus

thanks

just single retail prices

[fergusw]

Hi Fergus

thanks

just single retail prices

e.g.
[reference],[name],[permutation price #1],[permutation price #2],[permutation price #3].....

and so on? Or do you have another format it mind?