Advice on configuring multiple variations

  • Resolved paulmcmanus

    (@paulmcmanus)


    7 years, 5 months ago

    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

    (@kloon)

    7 years, 5 months ago

    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

    (@paulmcmanus)

    7 years, 5 months ago

    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

    (@kimball31)

    7 years, 5 months ago

    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/

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

The topic ‘Advice on configuring multiple variations’ is closed to new replies.