Thread: Anyway to Export Weights for Product ID's ?

Does anyone know a way I can export the weight information for my products / variants ? I can't get WSI to work because my developer didn't install some files and hence no ipx.asmx file anywhere....

someone please help, it's getting tiring to see products being ordered without weights from past people who worked on the site ... Thank you a bunch

Do you have access to SQL Server Management Studio on your db server?

If so then you want to run this bit of SQL:

Code:

SELECT pv.ProductID, VariantID, SKUSuffix, p.Name, pv.Name, Weight FROM ProductVariant AS pv WITH (NOLOCK) JOIN Product AS p WITH (NOLOCK) ON pv.ProductID = p.ProductID

Then you can cut'n'paste to a spreadsheet

Hello, I'm new to SQL, I have Microsoft SQL Server Management Studio Express, I have the diagram tree open on the left where I clicked "Databases", and then expanded and went to my site's folder - now from this point on do I just highlight my site name and then click new query and then copy paste that query in and im good ? I'm just afraid I don't want to do anything to crash the site .. ..

Nevermind, I did it ...now ... do you know how to export extended prices ???

SELECT * FROM ExtendedPrice

Hello ese, I tried using the SELECT pv.ProductID, VariantID, SKUSuffix, p.Name, pv.Name, ExtendedPrice FROM ProductVariant AS pv WITH (NOLOCK) JOIN Product AS p WITH (NOLOCK) ON pv.ProductID = p.ProductID, I edited what you told me, didn't return anything ... it said


"Msg 207, Level 16, State 1, Line 1
Invalid column name 'ExtendedPrice'. "

Any suggestions ?

Ok nvm, I see what you meant, but it's rreturning me the product GUID's, I want to be able to see the product id, name, variant id and name and then the extended price ... Sorry for the c onfusion ...

Ok, nevermind, I used vlookup in excel with the variant ID's, I have that taken care of...I guess my last and final question is ... How can I pull out the Descriptions / product URLs / and Image URLs ? I want to manually make a data feed ...

Try something like this, it includes the correct syntax for getting the extended price as well:

Code:

SELECT pv.ProductID, pv.VariantID, SKUSuffix, p.Name AS ProductName, pv.Name AS VariantName, p.Description, ep.Price, 'p-' + CONVERT(VARCHAR(10),p.ProductID) + '-' + p.SEName + '.aspx' AS URL, 'images/product/large/' + CONVERT(VARCHAR(10),p.ProductID) + '.jpg' AS ImageURL
FROM ProductVariant AS pv WITH (NOLOCK) 
JOIN Product AS p WITH (NOLOCK) ON pv.ProductID = p.ProductID 
JOIN ExtendedPrice AS ep WITH (NOLOCK) ON ep.VariantID = pv.VariantID