Title: Import and Update variable products Last modified: April 8, 2019 --- # Import and Update variable products * Resolved [joywp76](https://wordpress.org/support/users/joywp76/) * (@joywp76) * [7 years, 1 month ago](https://wordpress.org/support/topic/import-and-update-variable-products/) * I need to know if is possible with WP All Import + WooCommerce Add-On, import and update variable products from CSV like this: * – Each product has its prodID – Each product variations has its unique sku * Example: ProdID SKU TITLE SIZE Color Quantity 146043 146043_469862 TRUSSARDI SHIRT MAN WHITE STRIPES BLUE M White 1 146043 146043_469863 TRUSSARDI SHIRT MAN WHITE STRIPES BLUE L White 4 146043 146043_469864 TRUSSARDI SHIRT MAN WHITE STRIPES BLUE XL White 4 146043 146043_469865 TRUSSARDI SHIRT MAN WHITE STRIPES BLUE XXL White 0 146044 146044_469866 TRUSSARDI WHITE MAN SQUARE SHIRT M Multi 2 146044 146044_469867 TRUSSARDI WHITE MAN SQUARE SHIRT L Multic 0 146044 146044_469868 TRUSSARDI WHITE MAN SQUARE SHIRT XL Multic 1 146044 146044_469869 TRUSSARDI WHITE MAN SQUARE SHIRT XXL Multic 0 146048 146048_469882 TRUSSARDI WHITE SHIRT WITH STRIPES RED M Multic 1 146048 146048_469883 TRUSSARDI WHITE SHIRT WITH STRIPES RED L Multic 3 146048 146048_469884 TRUSSARDI WHITE SHIRT WITH STRIPES RED XL Multic 2 146048 146048_469885 TRUSSARDI WHITE SHIRT WITH STRIPES RED XXL Multic 2 146055 146055_469908 TRUSSARDI SHIRT MAN WHITE STRIPED BLUE M Multic 1 146055 146055_469909 TRUSSARDI SHIRT MAN WHITE STRIPED BLUE L Multic 2 146055 146055_469910 TRUSSARDI SHIRT MAN WHITE STRIPED BLUE XL Multic 2 146055 146055_469911 TRUSSARDI SHIRT MAN WHITE STRIPED BLUE XXL Multic 0 146059 146059_469923 TRUSSARDI WHITE MAN SQUARE SHIRT M Multic 1 146059 146059_469924 TRUSSARDI WHITE MAN SQUARE SHIRT L Multic 2 146059 146059_469925 TRUSSARDI WHITE MAN SQUARE SHIRT XL Multic 2 146059 146059_469926 TRUSSARDI WHITE MAN SQUARE SHIRT XXL Multic 0 146061 146061_469931 TRUSSARDI WHITE MAN SHIRT M White 2 146061 146061_469932 TRUSSARDI WHITE MAN SHIRT L White 2 146061 146061_469933 TRUSSARDI WHITE MAN SHIRT XL White 5 146061 146061_469934 TRUSSARDI WHITE MAN SHIRT XXL White 1 146064 146064_469942 TRUSSARDI WHITE MAN SHIRT M White 2 146064 146064_469943 TRUSSARDI WHITE MAN SHIRT L White 2 146064 146064_469944 TRUSSARDI WHITE MAN SHIRT XL White 4 146064 146064_469945 TRUSSARDI WHITE MAN SHIRT XXL White 0 * I need to update daily, stock for each variations. So, I’ve to import in my store product with its prodID and each variation with its SKU. Maybe there isn’t other way to have full synch. * I see in the option there is “_All products with variations are grouped with a unique value that is the same for each variation and unique for each product._” * But what I need, maybe shuld be “_All products with variations are grouped with a unique value that is the same for each product and unique for each variation_” * Any suggestion? * THX - This topic was modified 7 years, 1 month ago by [joywp76](https://wordpress.org/support/users/joywp76/). Viewing 1 replies (of 1 total) * Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/) * (@wpallimport) * [7 years, 1 month ago](https://wordpress.org/support/topic/import-and-update-variable-products/#post-11418635) * Hi [@joywp76](https://wordpress.org/support/users/joywp76/) * Based on your example, you should be able to use “_All products with variations are grouped with a unique value that is the same for each variation and unique for each product_” for this: [https://d.pr/i/RQgZtr](https://d.pr/i/RQgZtr). Make sure you use a “New Items” import (see: [https://d.pr/5s8uX9](https://d.pr/5s8uX9)) when creating the products. * When you need to update them, you can update the same import with a new file ( [see documentation](http://www.wpallimport.com/documentation/recurring/update-import)), or you can use a separate import if you only need to update the stock: [http://www.wpallimport.com/documentation/woocommerce/syncing-stock/](http://www.wpallimport.com/documentation/woocommerce/syncing-stock/). * Feel free to test this out at [http://www.wpallimport.com/try/](http://www.wpallimport.com/try/). Viewing 1 replies (of 1 total) The topic ‘Import and Update variable products’ is closed to new replies. * ![](https://ps.w.org/wp-all-import/assets/icon-256x256.png?rev=2570179) * [WP All Import – Drag & Drop Import for CSV, XML, Excel & Google Sheets](https://wordpress.org/plugins/wp-all-import/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-all-import/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-all-import/) * [Active Topics](https://wordpress.org/support/plugin/wp-all-import/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-all-import/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-all-import/reviews/) * 1 reply * 2 participants * Last reply from: [WP All Import](https://wordpress.org/support/users/wpallimport/) * Last activity: [7 years, 1 month ago](https://wordpress.org/support/topic/import-and-update-variable-products/#post-11418635) * Status: resolved