Increase / decrease stock with CSV – NOT REPLACE

  • Resolved vitalseeds

    (@vitalseeds)


    7 years, 5 months ago

    Hello woo-ers

    I would like to know if there is a way to increase / decrease stock levels with csv importer rather than replace the current levels?

    This would be very useful for me otherwise i need to check how much stock there is and then manually calculate the new stock levels before importing which seems very long winded. And also if someone buys something while im in the process then the new stock level might be wrong!

    Any thoughts greatly appreciated

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Ross V. a11n

    (@rossviviano)

    Automattic Happiness Engineer

    7 years, 5 months ago

    Hi there,

    > I would like to know if there is a way to increase / decrease stock levels with csv importer rather than replace the current levels?

    Sure. You can do this with the built-in WooCommerce CSV importer. After heading to WooCommerce–> Products–> Import, make sure to tick the ‘Update existing products’ box. This guide goes over the process in more detail.

    http://cld.wthms.co/6bIXFq

    Best,

    Ross

    Thread Starter vitalseeds

    (@vitalseeds)

    7 years, 5 months ago

    Thanks Ross – yes i am aware of the process of uploading a csv file, but my problem is specifically that the ‘stock’ column REPLACES the existing stock level rather than INCREASING it which is what i need to do.

    Example – i have 17 packets in stock already of product A, and 13 of product B and 7 of product C.

    I have packed up 25 more packets of each product and want to update the stock through csv, to get the correct stock level i have to manually calculate: 17+25, 13+25, 7+25 which seems extremely inefficient and if someone buys something while im calculating, the levels will be incorrect. I want to be able to just INCREASE the stock of each by 25.

    Does that make sense? Do you know if this is possible?

    Cheers

    Fred

    con

    (@conschneider)

    Engineer

    7 years, 5 months ago

    Hello there,

    I have packed up 25 more packets of each product and want to update the stock through csv, to get the correct stock level i have to manually calculate: 17+25, 13+25, 7+25 which seems extremely inefficient and if someone buys something while im calculating, the levels will be incorrect. I want to be able to just INCREASE the stock of each by 25.
    Does that make sense? Do you know if this is possible?

    Totally makes sense, but I have not come across any stock manager that does this. You will have to do the math for now and set stock values instead of wanting to increase them.
    But then again, CSV sheets can do that math for you if your cells have a SUM function instead of a set value. That maybe makes it a bit more convenient: http://cld.wthms.co/wuJSlG

    I am marking this as resolved, but feel free to follow up or open a new thread anytime.

    Kind regards,

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Increase / decrease stock with CSV – NOT REPLACE’ is closed to new replies.