Zen Cart Logo
Forums / General Questions / Import Products/Attributes by SQL Patches - Pro's/Con's

Import Products/Attributes by SQL Patches - Pro's/Con's

Locked

Views: 1,042

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
2 Dec 2007, 1:51 PM
#1
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Import Products/Attributes by SQL Patches - Pro's/Con's

Can anyone advise me any problems I could come up with by import products by a SQL file via the ' Install SQL Patches' SQL Query Executor within Zen Cart.

I have so many Attributes that I cannot use Excel or OO so I am looking at other alternatives. ( I am aware of CSVd its just slow a way)
I am looking at writing a script in Python linked to a database using a spreadsheet style input form. Then producing a SQL file to import directly into ZC.
Currently I am using a script I wrote with check box's to include attributes (Work's great )and imported by Easypopulate 1.2.5.4, but each time I have to add another attribute I have to add that to the code. So I am thinking of adding a database which would make it more user friendly.

I understand what database tables are effected for the different imports and ZC uses product_id's with product_attributes_id to list the products.

I really just need to know any known issues I could fall into by doing it this way, and to see if it is really a viable idea :mellow:

any comments would be helpful... :yes: