Mass Upload / Quantity in stock problems

[theabove]

I needed a way to set up inventory so that I have different ammounts of stock per size, because I have a clothing store. So i download the mod and tried to install it. I FTPed all the files and overwrote what I had to. When I try to install the SQL I get


1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stock_attribute.sql' at line 1
in:
[stock_attribute.sql;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

What Am I doing wrong. When I try and upload the .sql file again I get


1062 Duplicate entry 'STOCK_SHOW_LOW_IN_CART' for key 2
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false', 'When customer places more items in cart than are available, show the available amount on the shopping cart page:', '9', '6', NULL, now(), NULL, "zen_cfg_select_option(array('true', 'false')," );]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

My second question is, is there a way to mass upload inventory?

[poolprorich]

I needed a way to set up inventory so that I have different ammounts of stock per size, because I have a clothing store. So i download the mod and tried to install it. I FTPed all the files and overwrote what I had to. When I try to install the SQL I get


1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stock_attribute.sql' at line 1
in:
[stock_attribute.sql;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

What Am I doing wrong. When I try and upload the .sql file again I get


1062 Duplicate entry 'STOCK_SHOW_LOW_IN_CART' for key 2
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false', 'When customer places more items in cart than are available, show the available amount on the shopping cart page:', '9', '6', NULL, now(), NULL, "zen_cfg_select_option(array('true', 'false')," );]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

My second question is, is there a way to mass upload inventory?

This is only showing the part of the sql that was sucsesful on your first atempt can you display all of the sql that u tried to upload so i can see where the eror in it is, as far as the duplicate entry you can fix the part of your sql that has the problem and you can ether delete wat was done already or start new from where u left off,

if you get your data base the way you need it you can export it to a cvs file enter all your info in excel and upload to database, and then ftp all images to directory