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 191 posts 484 karma points
    15 days ago
    Edgar Rasquin
    0

    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
  • Alex Skrypnyk 5960 posts 22668 karma points MVP 4x admin c-trib
    15 days ago
    Alex Skrypnyk
    0

    Hi Edgar,

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

    Thanks,

    Alex

  • Edgar Rasquin 191 posts 484 karma points
    15 days ago
    Edgar Rasquin
    0

    Hi Alex,

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

    Thanks

Please Sign in or register to post replies

Write your reply to:

Draft