Woo/Dropshipping – Stock Quan not Updating

  • Issue: Stock quantity value not changing upon Inventory CSV processing.
    WP 4.9.8, Woo 3.5.1, Dropshipping plugin, Supplier is defined. Products imported ok.
    Four Woo test products assigned to supplier. Dropshipping supplier inventory update columns set to: 1 (SKU) and 2 (stock).
    Am trying to update inventory(stock quan) with Dropshipping using this 4 row, 2 column CSV: ([mgr_sku, inv amt] x 4, no column headings [using headings didn’t make a diference])

    1235, 88
    2345, 71
    3456, 19
    4567, 21

    Product record:
    SKU (my sku), meta:supsku (supplier sku), stock
    bci1234, 1234, 50
    bci2345, 2345, 45
    bci3456, 3456, 3
    bci4567, 4567, 2

    How is Woo looking for the correct product record to update? (it is not working).
    Is it looking it up by Woo product SKU?
    I dont quite understand what this means: “Dropship Manager Pro will append the SKU code for this suppler automatically when you upload.”
    Which SKU does it want (mine, or my supplier’s) in the CSV? (I tried with both) (I can easily massage the data)
    More tha 4000 products to update if I get this working.
    Also, I will have multiple suppliers.
    Thx!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there,

    It sounds like the dropshipping module is complicating matters here. WooCommerce searches either by product ID or by SKU for the products to update – the core importer doesn’t know about the supplier, as it’s not part of WooCommerce core. It’s likely been added by another plugin.

    I’d recommend disabling everything but WooCommerce and then trying the import to see if it works correctly – that’ll tell you if the problem if actually with that dropshipping plugin or if it’s something else.

    Thread Starter ijimmoore

    (@ijimmoore)

    Thank you, Hannah.
    I deactivated Dropshipping then Import/updated my 4 test product stock values ok.
    Am now about to try again with Dropshipping activated but not using it.
    I will then try a few things with Dropshipping itself and update this thread.
    (I think I really need DS, or something similar, to differentiate between suppliers, and orders for suppliers.)

    Thread Starter ijimmoore

    (@ijimmoore)

    I activated Dropshipping. The suppliers were still there.
    I clicked on Inventory CSV button for my only active supplier, BCI (having 4 products defined in Woo), the CSV containing SKU and Stock. The Stock field was updated for each product. It worked, once. I tried to it again a few times to emulate realtiew nme, repeating the update – stock values were not updated. I attempted several times seeing no change in the Stock values each time; even chaging the Stock values a few times.
    Here are some screen shots:
    https://drive.google.com/drive/folders/1zGEqQGqdkxWSxoCiX-wmZ-HJrpWai3wT?usp=sharing
    Thank you for looking at this!

    Plugin Support Hannah S.L.

    (@fernashes)

    Automattic Happiness Engineer

    Thanks for the information!

    I deactivated Dropshipping then Import/updated my 4 test product stock values ok.

    Did that work?

    Did you have any luck with disabling all plugins except for WooCommerce?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Woo/Dropshipping – Stock Quan not Updating’ is closed to new replies.