Thread: How to import the stock level for all products

I had imported the products using the excel imports now the problem is that all products are showing the stock 1000000 which I didnt set while imorting products, How can I upload the stock value for each product I am uploading?

Thanks

The Excel import doesn't allow you to set the inventory level. You can do that through WSI.

As Scott says, you can use WSI, or if you have an external inventory feed in a format such as XML and have access to a developer, you could write your own stock level module using the inbuilt XmlProcessing functions of C# and SQL Server.

It does require writing code, but the basic idea is....

- Use an XmlTextReader to read through your inventory file
- Pass the XML to a new SQL Server stored procedure
- The Stored procedure does a mass update of stock levels based on the values in your XML

This is *really* quick due to moving all the data processing into SQL Server and is ideal if you have a lot of products to update in one go.

It also allows you to make logic decisions during processing. For example, one site uses this method to update order shipping information from an external fulfilment provider and the module updates tracking information and auto emails shipping notifications to Customers. If items are returned, it sends notifications to site admins.

or you can make a simple 3 column excel file and update your site in 5 mins
http://www.simrun.com/AspDotNetStore...Commander.aspx