SKU problem for imported variable products

Hi there,

How did you import products from Sello.io? It sounds like you might need to find a way to remove the letter V from the import process using your import tool.

Unfortunately, we don’t have an import tool to import products from Sello.io. I’d recommend checking into the tool you used for importing to see if there’s an option to remove the letter.

Alternatively, I’d recommend editing your variations using our CSV import/export tool. You can do this by exporting your variations to a CSV file, edit it to remove the letter then importing the file back to your site.

Feel free to get back to us in case you have any additional questions!

Hi,

I connected Sello.io to Woocommerce from their webpage, no need for a plugin to do that, which means I don’t use CSV files neither.

Here is what Sello told me is sent from them to Woocommerce:

2021-09-05T17:25:58.863Z    ab53151f-2b10-46f1-9498-134c7806d964    INFO    Using group id as main product sku

2021-09-05T17:25:58.863Z    ab53151f-2b10-46f1-9498-134c7806d964    INFO    Creating product with data: {
    "description": "<p>Flexibel konsol i h&aring;llbart st&aring;l. Justerbar till olika dimensioner, balkongr&auml;cke 3-14 cm, balkongl&aring;da: 10,5 cm - 21 cm. Max vikt: 20 Kg. 1 par.&nbsp;</p><p>Varning! Montera alltid balkongl&aring;dan p&aring; insidan av balkongen.</p>",
    "manage_stock": true,
    "stock_quantity": 28,
    "weight": "0.48",
    "sale_price": "89.00",
    "regular_price": "89.00",
    "attributes": [
        {
            "id": "4",
            "option": "Svart"
        },
        {
            "id": "7",
            "options": [
                "Orthex"
            ],
            "variation": false,
            "visible": true
        },
        {
            "id": "4",
            "options": [
                "Svart",
                "Vit"
            ],
            "variation": true,
            "visible": true
        }
    ],
    "meta_data": [],
    "categories": [
        {
            "id": 92
        }
    ],
    "images": [
        {
            "alt": "Orthex Konsol 1 par ",
            "name": "Orthex Konsol 1 par ",
            "position": 0,
            "src": "https://images.sello.io/products/acc/32548/622050938029883e5e805cf9b8a5b8c214fe3066.jpg"
        }
    ],
    "name": "Orthex Konsol 1 par ",
    "short_description": "",
    "type": "variable"
}?

And this is the data that was saved to Sello's Woocommerce product database:

{
  "integration_id": {
    "N": "52164"
  },
  "group_id": {
    "N": "42874168"
  },
  "woo_product_id": {
    "N": "31055"
  },
  "image_ids": {
    "M": {
      "https://images.sello.io/products/acc/32548/622050938029883e5e805cf9b8a5b8c214fe3066.jpg": {
        "N": "31054"
      }
    }
  },
  "variation_ids": {
    "M": {
      "62205093": {
        "N": "31057"
      },
      "62205094": {
        "N": "31059"
      }
    }
  },
  "permalink": {
    "S": "https://koksgladje.se/produkt/orthex-konsol-1-par/"
  }
}

Hi @blaweb,

Thanks for sharing this information.

As on this forum, we do only support the WooCommerce core functions bundled with the plugin (including the CSV import/export tool) and not external integrations, you’ll want to get back to the Sello.io support team and see if they can find the root cause of that unwanted letter “V” showing in front of the SKU.

If they can’t help, I recommend hiring a developer who can look at the code and help find a solution. You can get in touch with a web developer or one of the customization experts listed at: https://woocommerce.com/customizations/

Thanks.

Hi there,

I’m going to mark this as resolved now. Feel free to start a new thread if you have any more questions!

Cheers.