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
any comments would be helpful...![]()




