Mass populate GTIN Value

  • Resolved WPUser1234

    (@wpuser1234)


    6 years, 10 months ago

    Hello,

    We have over 3000 items, is there a way to mass populate this field?
    We already store the UPC / GTIN value in woocommerce as a custom attribute value, it would be easy to copy it over in mass through an import (visser labs), or better yet, use that custom attribute value, but that didn’t look like an option unfortunately.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter WPUser1234

    (@wpuser1234)

    Actually, I just noticed that some of my custom attribute values are an option in the drop down list box but it’s cut off – not all values are listed. Could it be possible that the dropdown list box in the setting screen to select the value to use for the GTIN is limited by a number of value to return?

    Hi @wpuser1234, thanks for your patience. I’m working through a spike in support tickets.

    I’ll need to reproduce this as Attribute generation and importing may be limited to the Pro Plugin, let me reproduce this and confirm.

    Plugin Contributor natekinkead

    (@natekinkead)

    @wpuser1234, if you see your GTIN field with a sample of your data entered, give that a try. You can always switch it back. That dropdown shows the product meta key along with a sample value from just one product in your system (so you can get an idea for the type of data that meta key contains).

    Thread Starter WPUser1234

    (@wpuser1234)

    Hello Natkinkead, actually the problem is that the drop down box for selecting the product meta key does not show ALL values and is cut off – I cannot select mine as it is a little further down the list. It seems that the dropdown is limited to x number of records.

    Plugin Contributor natekinkead

    (@natekinkead)

    It could be a special character breaking it. Could you view the source and find the last selection option before it broke, and see if the next option maybe has a special character that’s breaking the select element?

    Thread Starter WPUser1234

    (@wpuser1234)

    So, it only brings back the attributes that are used on a variation of a product.
    The particular Attribute was never used on a variation, however I could see the other attributes that were, were used on a variation of an item.

    After adding the attribute to the variation of a product, the attribute showed up on the plugin configuration screen dropdown and allowed me to select it – HOWEVER it shows the following:

    attribute_pa_upc-gtin (75862####rest of UPC code####) – so I’m not sure if it selected JUST the particular UPC code, or uses the attribute. It appears the query only works for attributes used on a variation of an item, and I’m not sure if the selection brings back just the UPC code now, or the particular entry for the attribute field.

    • This reply was modified 6 years, 10 months ago by WPUser1234.
    Plugin Contributor natekinkead

    (@natekinkead)

    It will use whatever is stored in the attribute_pa_upc-gtin postmeta for the products/variations that are purchased. The “(75862####rest of UPC code####)” is JUST A SAMPLE to help you identify the correct postmeta field to use as your GTIN.

    So, it looks like that will work fine for you. Give it a test. If you view a Thank You (order-received) page, you can view source and see the section where GTIN values are setup for each of the products in the order.

    Thread Starter WPUser1234

    (@wpuser1234)

    Well, it appears that when you add an attribute to the variation it becomes something you have to ‘select’ on the front end so using attributes as I’ve previously done is not a good option.
    I will migrate the UPC value from the attribute to your GTIN field using visserlab export import to bulk update.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Mass populate GTIN Value’ is closed to new replies.