Update Data With SQLScripts Created In Excel

This was very helpful, and i did manage to get everything to work, but i am still a little leery of using it, naturally.
I have only one use for it right now, which is to delete a long list of category names that cog imported by a faulty use of easy populate.

I have emptied the categories such there are no products for them, but it would be nice to be able to just delete the wayward elements in the categories table, and I assume i would have to do category descriptions table as well. but as everything is linked together in ways only the gods really understand, i wonder if there is more to it?

tanks K.

Ill check em out :)

Im loving this whole cart thing though I have to say.

no amount of uncorrelated data could ruin it for me...

::frust

I REALLY appreciate you taking the time to answer, point and link for me ::tup

hero!

Data manager...

I tried it. looks great. but I think anyone with non standard table prefixes should check through the code 1st....

I didnt... ouch.

:)

I told the designer dude on his forum... he seems a nice helpful person reading through his posts. Great.

::tup

Being the designer dude, I'd like to ask if you ran the sql through the ZC admin or not, like I suggested? ;)

Edit: let's not hijack the thread though, pm me if you need help with it. ;)

since I dissed you here
I should undiss you here.

I am an idiot, I did not follow the SIMPLE instructions.

forgive me.

it is great.

(doh!) ::frust

hope that helps put anyone who thinks I am not an idiot straight

::tup

JuxiZoza:

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, :D 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

Somebody please answer this query of mine

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

redsunflower:

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

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

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.