• This plugin certainly works well for simple spreadsheets. You start by importing a spreadsheet template of just the field names (not the values). You then map these to Woo Commerce product fields. If there isn’t an equivalent Woo Commerce field you can create your own custom ones in Woo Commerce first them map your spreadsheet template fields to those.

    It does, however, have one major downside with large number of fields. Once you import you fields you can’t go back an edit them after. My client’s spreadsheet had over 20 fields – mostly to output into custom templates. If I even made one mistake mapping any of these to Woo commerce fields I would have to start again – no going back.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author allaerd

    (@allaerd)

    Hi,

    you can edit them afterwards, update them etc. If you have the SKU and use the merge function.

    If some how you made a mistake in for example price. You make enable the merge function, make a new CSV with only sku,price and a header to match it.

    And you can update all you want!

    There is also a tutorial for this in the documentation! You can find it here

    Thread Starter screenbeetle

    (@screenbeetle)

    Hi Allaerd.

    Thanks for your reply. I didn’t explain my issue very well. The product merge function is very useful. My client has to regularly update just prices so that feature is essential.

    I guess I have two issues:
    Firstly – as far as i can see – you can’t edit the header. My client’s product spreadsheet had 26 fields in it. If I accidentally mapped one field wrong – say product name to post title instead of post name – then I would need to start again with a new header. Ok I could use a new header with just sku and product along with your merge but then that deleted the old header.

    Secondly there is no way to save multiple headers. My client has different spreadsheets from different suppliers so it would be great if she could store different headers to use with each one.

    Hope that helps
    Still a very good plugin – especially with the custom fields extension

    Regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Works well but not so good for lots of fields’ is closed to new replies.