Page 5 of 8 FirstFirst ... 34567 ... LastLast
Results 41 to 50 of 75
  1. #41
    Join Date
    Apr 2004
    Location
    Berkshire, UK
    Posts
    1,482
    Plugin Contributions
    1

    Default

    Originally posted by TheWhiteKnight+May 23 2005, 05:03 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>QUOTE (TheWhiteKnight &#064; May 23 2005, 05:03 PM)</td></tr><tr><td id='QUOTE'>Kelvyn, I don&#39;t have Easypopulate and have never used it [/b]

    No one should be without this contrib&#33; Take a look
    http://www.zen-cart.com/modules/mydownload...ile.php?lid=372
    <!--QuoteBegin-TheWhiteKnight
    @May 23 2005, 05:03 PM
    however, I like the OO and Excel way of doing this. [/quote]
    OK, fair enough, I only wish I had as much time on my hands&#33;

  2. #42
    Join Date
    Jun 2005
    Posts
    162
    Plugin Contributions
    0

    Default

    I&#39;ve tried to follow your tutorial and i am now stuck

    I have got to the following chapter (if you will)

    Add &#39;model&#39; and &#39;name&#39; information to product rows

    it states:

    Copy &#39;C88&#39; to &#39;C11:C??&#39;
    While &#39;C11??&#39; is still highlighted, copy to clipboard, and &#39;edit / paste special / values / ok&#39;.
    Cols &#39;C&#39; & &#39;D&#39; are used for your own reference. Either can be left off or hidden, if only one column gives you enough information to be sure that you are working with the correct item.
    Do NOT convert &#39;C88&#39; to values. They may be needed again.



    Why do you change to ?? copy c8:d8 to c11:c??

    This has really confused me???

    Can you please shed any light on this subject for me.

    Thanks
    D4

  3. #43

    Default

    I&#39;m not trying to update the products files. My problem is in updating the products_options_values file.

    For instance, I need to create over 100 option values for an option name. Very easy to do in Excel. I downloaded the CSV file and did so.

    Field Names are as follows:

    products_options_values_id
    language_id
    products_options_values_name
    products_options_values_sort_order

    I am very new to MySQL but the statements are easy to follow, it&#39;s the set up for the rows I&#39;m confused about in the CSV file. I don&#39;t need lookups to other files for this so the tutorial is a bit confusing for what I want to do.

    I think

    Thanks for your help&#33;

  4. #44
    Join Date
    Apr 2005
    Posts
    32
    Plugin Contributions
    0

    Default

    The information you provided is very useful. One question, I am trying to import new products from csv or Excel file, into zen-cart, and I have no clue where to begin. Any idea?

    Thanks in advance.

  5. #45

    Default

    Now I am developing Easypopulate which works directly with Excel 95. I think it will be good additional tools for Zen Cart.
    Be advanced!
    AdvanceWebSoft.com

  6. #46
    Join Date
    Dec 2005
    Posts
    4
    Plugin Contributions
    0

    Default

    Can someone post a sample excel file they ended up with? Thanks.

  7. #47
    Join Date
    Dec 2005
    Posts
    66
    Plugin Contributions
    0

    Default

    wouldn&#39;t using easypopulate accomplish this as well? just wondering

  8. #48
    Join Date
    Apr 2004
    Location
    Berkshire, UK
    Posts
    1,482
    Plugin Contributions
    1

    Default

    Originally posted by eProsComputers@Jan 7 2006, 07:05 PM
    wouldn&#39;t using easypopulate accomplish this as well? just wondering
    Yes, and a lot quicker and easier too&#33; This is the "self-harmers" script :)

  9. #49
    Join Date
    Nov 2005
    Posts
    30
    Plugin Contributions
    0

    Default

    Well,

    I am struggeling with Easy Populate. EP works fantastic, and it is the ideal solution if you are not using the "model" field: EP uses this as primary key, and I am a bit stuck on how to solve this: i DO need the model field, but there are a lot of duplicates in my models meaning these are not inserted. It took me a while to figure this out.

    So.... I have a couple of spreadsheets with thousands of products I want to insert in the database. I want to insert them in the Product Name, Model, Weight and Price fields in a number of categories. All fields (name, model, weight and price do have duplicate entries.

    This should be faily easy IMHO..... How to tackle this?[B]

  10. #50
    Join Date
    Feb 2006
    Location
    Wiltshire UK
    Posts
    49
    Plugin Contributions
    0

    Default

    Originally posted by blindsnake@Apr 18 2005, 10:35 AM
    hi there. First of all thanks a lot for sharing the info.
    My actual problem is finding "the_table" to export. Or do i have to create the table myself?
    Any info is welcomed
    Ok, I&#39;m being dumb. Just found this handy thread , read it, think I follow it. Well, thought I did&#33;

    Not going to give up though&#33;

    Don&#39;t understand the "the_table" reference, and didn&#39;t understand the follow up response - but I refuse to give up&#33;

    Please help&#33;

 

 
Page 5 of 8 FirstFirst ... 34567 ... LastLast

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