Title: Advice on configuring multiple variations
Last modified: November 28, 2018

---

# Advice on configuring multiple variations

 *  Resolved [paulmcmanus](https://wordpress.org/support/users/paulmcmanus/)
 * (@paulmcmanus)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/advice-on-configuring-multiple-variations/)
 * Hi, first let me say that I don’t have a problem, I’m looking for advice.
 * I have installed WordPress and Woocommerce and everything appears to be working
   fine.
 * I’m about to start the task of entering around 80 products each of which has 
   attributes from two sets of variations: size and finish (colour). Each product
   variation has a different price determined from suppliers pricing and foreign
   exchange rates i.e. both size and finish affect the price.
 * My strategy to get started is to group all products with the same attributes 
   together. Then, for each group, create the first one manually and then duplicate
   the product record for the other similar ones.
 * My concern is when a price change arrives how can I efficiently and accurately
   update the prices. With up to four sizes and four finishes per product this is
   going to amount to (a max of) 80 x 4 x 4 = 1280 product instances in the system.
   I can see me losing whole days to performing the edits to say nothing of the 
   risk of error.
 * What I’m trying to avoid is doing all this work and then finding out there was
   a better way to do it.
 * Is this the correct way to do this? Any suggestions for a more efficient way 
   to go about this?
 * Thanks.

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

 *  Plugin Contributor [Gerhard Potgieter](https://wordpress.org/support/users/kloon/)
 * (@kloon)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/advice-on-configuring-multiple-variations/#post-10928892)
 * Hi Paul, great to hear you have your store up and running fine. Your idea of 
   setting up a product and cloning it is perfect, the easiest way to then update
   the pricing would be to do a CSV export of the products, this can be done via
   WP-Admin and going to Products and then clicking the export button at the top.
 * This will generate a CSV file with all your products, you can then open that 
   in a editor and then modify the prices and then save the file again and import
   it on the same Products page by clicking the import button.
 * When importing be sure to select the option to update products with matching 
   ids and skus.
 *  Thread Starter [paulmcmanus](https://wordpress.org/support/users/paulmcmanus/)
 * (@paulmcmanus)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/advice-on-configuring-multiple-variations/#post-10933460)
 * Thank you very much, Gerhard. That looks like it will be a straightforward solution.
   Thank you for taking the time to explain.
 * Kind regards
 *  [Kimball31](https://wordpress.org/support/users/kimball31/)
 * (@kimball31)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/advice-on-configuring-multiple-variations/#post-10955321)
 * Paul,
 * You have another option too. There is also a plugin where you can set the price
   adjustment on the attribute list. That attribute increase/decrease can be a fix
   price or percentage. The when you run “Set regular pricing” on the variations
   it will calculate each price for you.
 * Markup by Attribute:
    [https://wordpress.org/plugins/markup-by-attribute-for-woocommerce/](https://wordpress.org/plugins/markup-by-attribute-for-woocommerce/)

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

The topic ‘Advice on configuring multiple variations’ 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/)

## Tags

 * [variations](https://wordpress.org/support/topic-tag/variations/)

 * 3 replies
 * 3 participants
 * Last reply from: [Kimball31](https://wordpress.org/support/users/kimball31/)
 * Last activity: [7 years, 5 months ago](https://wordpress.org/support/topic/advice-on-configuring-multiple-variations/#post-10955321)
 * Status: resolved