Page 8 of 8 FirstFirst ... 678
Results 71 to 75 of 75
  1. #71
    Join Date
    Mar 2006
    Posts
    2
    Plugin Contributions
    0

    Default

    Originally posted by JuxiZoza@May 5 2005, 03:08 PM

    It addresses UPDATING your tables, not INSERTING new records. I never finished the 'inserting new records' addendum that I was working on.
    But, that has not prevented numerous users from adapting their worksheets to do that.

    I've managed (finally) to get my update scripts working, but can't seem to get it to upload any new stock I have.
    I've tried changing the 'UPDATE products SET' to say 'INSERT products SET' but this bring back an error. I'm probably just being blonde! ::frust

    I'm fine with anything in excel but fairly new to SQL codes. Can anyone give me a couple of pointers as to what i need to change to get my products inserted rather than just updated.

    Any help is greatly appreciated!

    Zen Cart is fantastic even if it is a steep learning curve (feels more like a cliff!!)

    THANKS

  2. #72
    Join Date
    Mar 2006
    Posts
    20
    Plugin Contributions
    0

    Default

    Somebody please answer this query of mine

    http://www.zen-cart.com/modules/ipb/index....showtopic=44458

  3. #73
    Join Date
    Jan 2005
    Posts
    1,649
    Plugin Contributions
    2

    Default

    Originally posted by redsunflower@Mar 18 2006, 04:16 PM
    I've tried changing the 'UPDATE products SET' to say 'INSERT products SET' but this bring back an error. I'm probably just being blonde! ::frust
    That's not the way to insert rows.
    INSERT syntax
    UPDATE syntax

  4. #74
    Join Date
    Mar 2006
    Posts
    2
    Plugin Contributions
    0

    Default

    THANKS Dwno - that's exactly what I needed. You were a great help! ::tup
    Wish me luck x

  5. #75
    Join Date
    Mar 2006
    Posts
    26
    Plugin Contributions
    0

    Default

    Hi Guys,

    I have read the entire thread and am trying hard to understand uploading data by excel.

    Need a small help. I am planning to create a shopping cart for selling Stock Images. I have same price for 3 types of attributes for these images.
    To mass upload the data for a particular category which tables do I need to populate.

    Thanks.

 

 
Page 8 of 8 FirstFirst ... 678

Similar Threads

  1. Replies: 16
    Last Post: 16 May 2016, 06:10 AM
  2. v139h Product Data Dump to Excel
    By kevinmc3 in forum General Questions
    Replies: 1
    Last Post: 17 Jul 2012, 10:13 PM
  3. Insert new Data With SQLScripts Created In Excel
    By twi in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 15 Mar 2012, 10:57 PM
  4. Excel Data Feed
    By Adds in forum General Questions
    Replies: 2
    Last Post: 11 May 2007, 10:51 AM
  5. update products with data manager?
    By elgabi in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 7 Sep 2006, 10:42 PM

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