Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Edgar Rasquin 326 posts 925 karma points
    Apr 07, 2021 @ 11:01
    Edgar Rasquin
    0

    Bulk edit field value

    Hi,

    I need to edit the sku of about 4000 products.

    All need the prefix "1". So if the sku is

    74184

    it needs to be updated in

    174184

    What would be the best way to go with this?

    1. Would be best practice to change the values directly in the SQL table via SQL query?
    2. Or is it better to set up a controller using the contentService?

    I am on :

    • Umbraco version 8.11.1
    • SQL Server 15.0.2080.9
    Copy Link
  • Alex Skrypnyk 6182 posts 24284 karma points MVP 9x admin c-trib
    Apr 07, 2021 @ 14:07
    Alex Skrypnyk
    0

    Hi Edgar,

    What are you using as eCommerce plugin? How do you store sku?

    Thanks,

    Alex

    Copy Link
  • Edgar Rasquin 326 posts 925 karma points
    Apr 07, 2021 @ 15:03
    Edgar Rasquin
    0

    Hi Alex,

    I'm using Vendr. SKU is just a Textstring.

    Thanks

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies