Simple Invoices logo
HOME | DOWNLOAD | BLOG | FORUM | WIKI
Not signed in (Sign In)

Wish List: Product database upload

Bottom of Page

1 to 2 of 2

  1.  
    • CommentAuthorMario
    • CommentTimeOct 27th 2006 edited
     permalink
    Hi everyone, this is my first post and I have to say that I am not a programmer so I apologize for dumb questions. My english is not very good, too.

    I have a large product database in excel that I want to load in simply invoices...there is diferent way to load it than one by one?.....Im not sure but I think that it is possible to do from phpMyAdmin, import CSV, etc....but theres is a easy way?

    Greetings
    • CommentAuthorjustin
    • CommentTimeOct 27th 2006 edited
     permalink
    Hi Mario

    thers no dumb questions here.

    re importing into SImple Invoices,
    phpMyAdmin has an import function, so all you need to do is get you product list into a csv file(ie using OpenOffice) with the following 4 columns (dont use column headers)

    prod_id (leave blank as mysql auto assigns a number)
    prod_description
    prod_unit_price
    prod_enabled (use 1 or 0, 0 is disabled and 1 is enabled)

    so you csv file would look something like

    ,"test product", 12, 1
    ,"test product2", 4, 1
    ,"test disabled product3", 1, 0

    also in phpMyAdmin make sure you say that Fields terminated by , and not ;

    Cheers

    Justin
    justin@kelly.org.au

1 to 2 of 2

  1.