Thread: Stock count

Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Location
    England
    Posts
    90
    Plugin Contributions
    0

    Default Stock count

    How can I download what stock I have onto any Excel spreadsheet so that I can do a stock take?

    My programmer used to do it for me but I can't get hold of him anymore

    Thanks :)

  2. #2
    Join Date
    Jun 2005
    Location
    Cheney WA
    Posts
    1,138
    Plugin Contributions
    0

    Default Re: Stock count

    The easiest way for me was to use easypopulate. You can find it at, http://www.easyshopmaker.com/.

    But you need some knowledge of excel.

    JP
    John Patrick
    A Zen Cart Advocate!

  3. #3
    Join Date
    Feb 2007
    Location
    NNJ
    Posts
    212
    Plugin Contributions
    0

    Default Re: Stock count

    I'm going to suggest you become familiar with phpMyAdmin.
    I'm pretty sure you can download a CSV backup of any table you want.

    Of course, as long as you don't have commas embedded in your data, you should be able to import any CSV to an EXCEL spreadsheet.

    If you know SQL, you should be able to execute a select to a flat file, such as,

    SELECT
    product_model
    , ','
    ,product_qty
    Elliot

    The loves of my life are a good white zinfandel and my dog Homer.

 

 

Similar Threads

  1. Stock count
    By Gwiazda in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 10 Dec 2009, 01:31 PM
  2. stock count
    By phat in forum Managing Customers and Orders
    Replies: 8
    Last Post: 24 Sep 2008, 10:05 PM
  3. Hide stock count and not check for out of stock
    By microbe in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 12 Feb 2008, 12:08 AM
  4. Stock Count
    By aquaessential in forum General Questions
    Replies: 3
    Last Post: 23 Jun 2006, 09:09 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR