Adding multiple products to the database with a mySQL query

[hiltunna]

I've searched the forums and elsewhere for an answer on this topic, but I could not come up with one.

Can you add multiple products to the database using a mySQL query or queries? I wrote one with no errors that only updated one table, products, but that product did not show up in the administration pages or on the web.

I figure there's some other attribute, process or method I'm missing. But is there a way to emulate the Add Product function in admin with mySQL queries to aid automation?

I would appreciate comment on this issue very much, Zen community.

Thank you!

[kobra]

There are several tables that require an insert to key a product to display correctly...

Look around for a mod named easy populate that does just what you want.

Check here: http://www.modhole.com/modhole/

[hiltunna]

Thank you, Kobra. I am so impressed with the way the Zen Cart community operates, and how quickly answers come. And while this was my first post to the forum, Kobra's other posts have moved my knowledge along as well. I can say the same about many other "Totally Zenned" folks.

I appreciate that there is no down-talking to newbies going on, that answers are so readily available to anyone who can work a search engine, and the attention to detail of a free program like Zen Cart.

I think I'll go donate a cup of coffee to the team.

Thanks again, Kobra!

[hiltunna]

One SNAFU on all of this -- my hosting company, Brinkster, (shrug), has "strict" SQL mode enabled on its installation of MySQL. Is there a workaround for this? Are there alternatives to Easy Populate? Or am I going to have to reverse engineer the whole thing to get around Brinkster's restrictions? I could get my account cancelled and get a pro-rated discount, I suppose. They don't offer cURL support, either. That makes Google Checkout, Linkpoint API, etc. out of the question.



hiltunna

[DrByte]

There's also this method using Excel to generate SQL scripts suitable for importing/editing multiple items...
http://www.zen-cart.com/forum/showthread.php?t=14096

[DrByte]

One SNAFU on all of this -- my hosting company, Brinkster, (shrug), has "strict" SQL mode enabled on its installation of MySQL. Is there a workaround for this? Are there alternatives to Easy Populate? Or am I going to have to reverse engineer the whole thing to get around Brinkster's restrictions? I could get my account cancelled and get a pro-rated discount, I suppose. They don't offer cURL support, either. That makes Google Checkout, Linkpoint API, etc. out of the question.

I had worked on a site for a client without knowing that they were intending to host on brinkster. What a sad surprise.
It turns out their services are way to restrictive for the more advanced and inclusive feature-set that Zen Cart offers.
We wound up hosting on one of the Certified Hosts found by clicking the "hosting" link at the top of this page.