• Resolved andy3000

    (@andy3000)


    Is there a way to uncheck this box on all products at once. I want to manage all of them at the variation level?
    I am looking for an sql command to change it for all variable products or a column to change in imports. I don’t see the setting when I export products.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Doug – a11n

    (@dougaitken)

    Automattic Happiness Engineer

    Hey @andy3000

    Is there a way to uncheck this box on all products at once. I want to manage all of them at the variation level?

    Depending on how many products/product variations you have, this is possible with a CSV file.

    * Go to Products, then click on Export up the top
    * Select these columns: ID, Type, Name, In stock?, Stock, Parent
    * Choose variable product and product variations in the product types
    * Export

    Then you’ll have a CSV file you can edit. Remove the Stock quantity from the parent and add a number under Stock for a variation. This will mean that stock management is enabled at a variation level.

    Save as a new CSV, then go back to Import on your site.

    * Upload new saved CSV file
    * Check Update existing products
    * Continue
    * Make sure all fields are mapped
    * Import

    You will then have all products updated with the stock now being managed at a variation level.

    Let me know how you get on!

    Thanks,

    Thread Starter andy3000

    (@andy3000)

    I did something similar using _manage_stock yes|no
    for skus whose parent =0
    This time I made sure that I also deleted the stock number from the parents in the csv and it seemed to work better. Every one I checked was correct.

    However when I did the next stock import I changed all instock (from inventory list) ones to a higher number and all out of stock to a lower negative number which should force the in/out of stock ones to update. They all had the correct positive values after the import and the others showed as 0. However there were a number that had positive values that show as out of stock. If I change them manually they update but they don’t seem to if I import the stock quantities. ( In other words -items after the last import showed the positive stock number that I used for all of them yet still showed out of stock.

    Doug – a11n

    (@dougaitken)

    Automattic Happiness Engineer

    Hey @andy3000

    That is an odd one for sure!

    I did something similar using _manage_stock yes|no
    for skus whose parent =0

    I’m not familiar with that format, it doesn’t look like you’re using the core CSV importer/exporter.

    However there were a number that had positive values that show as out of stock.

    Hmm, I wonder if something made the stock_status change to 0 for some reason. The context is that a product can have stock but be out of stock.

    Did you export a product CSV at that point to see if that was the case?

    Thanks,

    Plugin Support con

    (@conschneider)

    Engineer

    Hi there,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Kind regards,

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘changing all Enable stock management at product level’ is closed to new replies.