• Resolved Jaiji

    (@jaiji)


    I have a WooCommerce store set up with 190+ products, many with multiple variations, imported from Etsy some months ago. Much editing was needed in WooCommerce after import, creating product bundles (Frequently Bought Together), adding product videos etc. For various reasons the development was paused for a few months, and now I need to update just the stock quantities, which are correct on Etsy but out of date in WooCommerce. We are using a Woo/Etsy Syncer but have just found out that the WooCommerce stock quantities need to be correct initially for it to work, syncronising orders and stock.

    Is there a way to import just the stock quantities from Etsy into matching products (same SKUs etc.) in WooCommerce? Due to all the editing already done in WooCommerce I don’t want to have to reimport all the products from Etsy, or manually update the the stock quantities. The site is currently still in development, in Coming Soon mode on the live server.

    Any help much appreciated.

    • This topic was modified 2 years, 1 month ago by Jaiji.
Viewing 11 replies - 1 through 11 (of 11 total)
  • Hello,

    If I understand correctly, you are using a plugin to sync WooCommerce and Etsy. If that’s the case, I’d recommend checking with the plugin developer directly to see if there is a way to import stock quantities only.

    Thread Starter Jaiji

    (@jaiji)

    Sadly the plugin does not do this, it requires stock levels to match initially before syncing, which is why I’m asking here. The developer has suggested that I update stock quantities by exporting a CSV from Etsy and importing just the stock levels to WooCommerce, though I am unsure how to go about this without overwriting all the products.

    Don’t worry – you won’t overwrite the existing products. There is a checkbox to select ‘update existing products’.

    You can use a CSV file with just the SKU and Stock columns as the import.

    Hi @jaiji

    the plugin does not do this, it requires stock levels to match initially before syncing, which is why I’m asking here

    As Maykato already advised, the plugin developer is best placed to help you with this because this particular forum is for questions that are directly related to the features and functionality of the free WooCommerce plugin. While we’re experts on our own products, third-party plugins are best supported by their own developers. However, it is great that you already contacted the plugin developer and have got their response.

    The developer has suggested that I update stock quantities by exporting a CSV from Etsy and importing just the stock levels to WooCommerce, though I am unsure how to go about this without overwriting all the products.

    Just to add to Seank123’s solution – here’s the documentation for our built-in product CSV Importer Exporter that you may refer to: https://docs.woocommerce.com/document/product-csv-importer-exporter/

    If you happen to require further help from us, please share the following:

    1. your CSV file (you can use Google Drive/Drobox or any online file-sharing service, and share the link here)

    2. your site’s System Status – You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Cheers

    Thread Starter Jaiji

    (@jaiji)

    @margaretwporg – OK thanks. My enquiry here is just about how to update ONLY stock quantities using CSV, which is a core WooCommerce feature. I’ll check out the link. Another unhelpful issue is that Etsy’s export CSV just lists total quantities per product, not per variation, so it seems a lot of manual editing will be needed anyway and I’m wondering if I may as well just update directly by hand.

    @seank123 – thanks, good to know.

    Plugin Support Sérgio L. a11n

    (@csnlima)

    Hi @jaiji,

    Let us know if you have any further questions after checking the documentation Margaret sent.

    Kind regards,

    Thread Starter Jaiji

    (@jaiji)

    @csnlima – just checking I’ve understood this right?

    I’ve exported a CSV from WooCommerce, with just the ID, Name (to help identify visually when changing the stock quantities), SKU and Stock columns for all listings. I’ve also taken a full site backup.

    It’s a jewellery store so I have different types of variations. For things like necklaces, the variations are just chain length, so they all use the main product SKU because the necklace itself is the same regardless of chain length.

    For rings, each different size variation of a given ring has its own SKU.

    To update only the stock, once I have the correct quantities in the CSV, I can remove the ID and Name columns, and also variation rows where there is no SKU (e.g. necklaces), so just keeping SKU and Stock, and import that back into WooCommerce. Or instead of removing those columns and rows, just specify the mapping during import.

    Would that be correct?

    Mirko P.

    (@rainfallnixfig)

    Hi @jaiji,

    so just keeping SKU and Stock

    There may be some unmatched fields so I recommend also keeping the ID together with SKU and Stock. When importing the CSV file don’t forget to select the checkbox to update existing products. Only the changes made to the stock will be updated while all the other fields will remain intact.

    To be on the safe side I always suggest having a full backup in place before running the Product CSV Importer and Exporter tool.

    Best regards.

    Thread Starter Jaiji

    (@jaiji)

    Thanks for this @rainfallnixfig. As I say I’ve taken a backup already. I just have to manually edit the CSV so it may be a while before it’s ready to try.

    Hello,

    On the market there are third-party repricing tools that allow you to sync stock and price from Etsy to WooCommerce, this is totally up to you and it is outside of our scope, but tools like an App like this might help you out with this.

    For this type of business model, where the source of the products is Etsy, and the products need to be sold on the WooCommerce store, you can definitely try the option of updating the CSV.

    If you have any questions regarding the CSV file part, let us know 🙂

    • This reply was modified 2 years, 1 month ago by Igor H.

    Hi @benlen79

    If you have questions about WooCommerce core, feel free to create a separate thread:
    https://wordpress.org/support/plugin/woocommerce/#new-topic-0.

    We want to ensure that every user’s issues receive its own thread with proper attention. We’ll be glad to help.

    Best.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Import just stock quantities from Etsy’ is closed to new replies.