Thread: Product Import

Can Any one help me
how to import only one filed to the website products.

i already have the products on the website, now i would like to import it'sRestrictedQuantities


so basically, i will prepare a spread sheet, with SKU and RestrictedQuantities

and want to import this file.

please help me how to do this even with WSI.


thanks

Look at this thread, it might help

Certainly. One way to do it would be to export the content of the table to an excel spreadsheet. You must include at least the primary key of the table in the columns, and any other data columns you're interested in changing. Then using a formula in excel create an update statement for each row, and copy that down. Copy the SQL back out and fire it against the db. You'll need something like SQL Server Management Studio to get at the data in the first place.

when you say Copy the SQL back out and fire it against the db.

i have SQL Server Management Studio.
Can you please elaborate the above statement.
am i suppose to to Excel Import from SQL Server Studio Management.

thank you.

Yes, absolutely. You are only using Excel to create the SQL statements. Copy those statements to either SQL Server Management Studio, or the built-in 'Run SQL' window in ASDNSF admin site.

If in that case, i will be ending up creating 1500 SQL Statements.
and i have to copy each Statement to SQL Server Management Studio.

or else do we have any option to run all 1500 Statements at once?

thanks

Harsha I believe you want the Bulk Product Updater: http://www.ecommercecartmods.com/p-2...torefront.aspx you would give it your Excel with SKU column and Restricted Quantities in the other and it will update the existing products with that information based on the SKU given!

Why pay $400, when u can do it for free, if you have Excel and SSMS?

If you looked at the spreadsheet in the thread I pointed you to, you could see that the 4th column D, has the SQL statements prepared via a forumla based on the content of columns A, B & C.

Your spreadsheet would look different because you would be using the SKU instead of the ProductID/VariantID, but the principal of creating the formula is the same. Then copy the formula down for all of the rows, and then copy and paste the resulting SQL into SSMS.

If you alreayd have the SQLs, then you have the work done practically :-), just execute the SQLs directly.

I'm sorry I misunderstood, our Bulk Updater can be used to update any product data based on any identifier (ProductID, VariantID, SKU, ManufacturerPartNumber etc) using ANY Excel file you have.

But yes, if you setup your Excel alreayd with formulas to generate your SQLs, then you can execute them directly in your SQL Management Studio, just make sure to make full backups.