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 6168 posts 24148 karma points MVP 8x 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
Please Sign in or register to post replies

Write your reply to:

Draft