Title: CSV Stock Sync
Last modified: August 16, 2018

---

# CSV Stock Sync

 *  Resolved [wpforumuser](https://wordpress.org/support/users/wordpressforumhelp/)
 * (@wordpressforumhelp)
 * [7 years, 9 months ago](https://wordpress.org/support/topic/csv-stock-sync/)
 * Hi
 * I have around 600 products that are listed on my store.
 * Once a week I update the stock from the suppliers csv file using the woo standard
   import/export.
 * I remove all columns from the CSV file apart from SKU and STOCK QTY
    I match 
   the SKU and then update STOCK on my store.
 * I have noticed (obviously) that it won’t remove items that were removed from 
   the suppliers csv file (when they discontinue an item) as it has no sku match.
 * All I can envisage at the moment is cross-matching up 600 products lol 🙁
 * Long shot (and possibly a daft question) but is there a workaround for this somehow?
 * Many thanks

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

 *  [Luminus Alabi](https://wordpress.org/support/users/luminus/)
 * (@luminus)
 * Automattic Happiness Engineer
 * [7 years, 9 months ago](https://wordpress.org/support/topic/csv-stock-sync/#post-10598746)
 * [@wordpressforumhelp](https://wordpress.org/support/users/wordpressforumhelp/),
 * If you’re not supplying an SKU or Product ID, there’s no way to update that product
   and the job of the import module is to either introduce a new product or update
   an existing one, not to remove a product.
 * Here are the options that I can see:
    - Manually remove the products that have been discontinued
    - Compare each new CSV document with the one from the previous week to find 
      any missing SKUs that indicate a product has been discontinued. Copy over 
      the information pertaining to the discontinued product and set the stock quantity
      to 0
 *  [Luminus Alabi](https://wordpress.org/support/users/luminus/)
 * (@luminus)
 * Automattic Happiness Engineer
 * [7 years, 8 months ago](https://wordpress.org/support/topic/csv-stock-sync/#post-10620292)
 * [@wordpressforumhelp](https://wordpress.org/support/users/wordpressforumhelp/),
 * 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.

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

The topic ‘CSV Stock Sync’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Luminus Alabi](https://wordpress.org/support/users/luminus/)
 * Last activity: [7 years, 8 months ago](https://wordpress.org/support/topic/csv-stock-sync/#post-10620292)
 * Status: resolved