Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: Insert product using SQL query

  1. 03-19-2010, 01:51 AM #1
    duke is offline Junior Member
    Join Date
    Nov 2009
    Posts
    28

    Default Insert product using SQL query

    i want to add product using query. anybody can assist me?
    i try to insert using this query

    INSERT INTO product (Name)
    VALUES ('tes product');


    but the product doesn't displayed in product page


    please help me
  2. 03-19-2010, 03:42 AM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Why do you want to do that? WSI is much easier to handle when it comes to that.
  3. 03-19-2010, 04:08 AM #3
    duke is offline Junior Member
    Join Date
    Nov 2009
    Posts
    28

    Default I am creating my own win service

    Because I am creating my own win service to monitor a folder that can be accessed via FTP.
    also I do a product customization that need to insert to another new custom table. so that folder contains CSV file with thousand lines and need to insert to product table and new custom tables
  4. 03-21-2010, 03:38 AM #4
    tbadowski is offline Junior Member
    Join Date
    Jun 2009
    Posts
    15

    Default

    I haven't tried doing this, but you probably need to also insert a PRODUCT_VARIANT corresponding to your PRODUCT. Otherwise you won't have a PRODUCT_VARIANT.PRICE