Update Data With SQLScripts Created In Excel

[kelvyn]

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;

[d4funky1]

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

[allinaname]

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;

[sonny-bob]

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.

[Warrior]

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

[phearless]

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

[eProsComputers]

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

[kelvyn]

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 :)

[pjcvdpol]

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]

[chai_rick]

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;