Exporting products for single manufacturer - Ecommerce Forums
Results 1 to 3 of 3

Thread: Exporting products for single manufacturer

  1. #1

    Exporting products for single manufacturer

    This has to be so easy that I'm overlooking something.

    I just need an excel report with a list of product codes/names for one manufacturer. Plain and simple.

    Thought I could do a fast product table search by manufacturer and export the results, but it's returning a download with all products vs. the single manufacturer.

    Am I missing something?

    Thanks.

  2. #2
    Run a saved SQL query.

    Code:
    SELECT Products_Joined.ProductCode,
    Products_Joined.ProductName
    FROM Products_Joined WITH (NOLOCK) 
    WHERE Products_Joined.ProductManufacturer = 'XYZ'
    ORDER BY Products_Joined.ProductCode

  3. #3
    Thanks, Marc!

    I'm still waiting to buy that Volusion SQL query book that hasn't been published yet...

Similar Threads

  1. Replies: 2
    Last Post: 02-16-2015, 10:07 AM
  2. Report by manufacturer, $, date?
    By GGG in forum Reporting
    Replies: 4
    Last Post: 09-30-2014, 08:49 AM
  3. How to override mobile site on a single page?
    By RaveReady in forum Store Design
    Replies: 3
    Last Post: 03-12-2014, 02:52 PM
  4. Manufacturer Product Shows
    By AWCthreads in forum Ecommerce Industry
    Replies: 6
    Last Post: 08-03-2012, 11:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •