Easy Populate CSV and Excel: how do I update all my product data quickly?

[mc12345678]

Got another question, there are other people are selling the same thing what I am selling from the same warehouse. I want to know on the Quantity is there a way say "25" in stock will consider out of stock?

The usual answer to this is adjust the quantity to 25 less when uploading...

Would depend on what part of "out-of-stock" you are referring. For example if you want the product to still be visible but to just display out of stock, or if there happens to be 26 and a customer orders 2 would they only be allowed 1 of the item?

[wmorris]

The usual answer to this is adjust the quantity to 25 less when uploading...

Would depend on what part of "out-of-stock" you are referring. For example if you want the product to still be visible but to just display out of stock, or if there happens to be 26 and a customer orders 2 would they only be allowed 1 of the item?

Lets say, my warehouse has 20 in stock then when I enter or update the database below 25 it considers out of stock and still shows the product.

[mc12345678]

Lets say, my warehouse has 20 in stock then when I enter or update the database below 25 it considers out of stock and still shows the product.

Can accomplish the same thing with reducing the total quantity uploaded by 25, then when a quantity reaches zero, the product can be prevented from being placed on back-order, the product remains in stock, but unavailable for purchase.

You can add a statement on your website about how the quantity maintained is less than what is in store. This can be very important because there may actually be visitors "to your warehouse" that wish to look up a product and if they see the difference in quantity without that bit of explanation, it can cause an issue/concern.

Obviously the more "robust" solution is for the quantities of the two to be tracked together. That way a reduction of stock on one side is reflected on the other.