Unable to update a custom field in the product variations.

Hi,

Is the sf_advanced_ean_field and acf (Advanced custom fields) field or a normal wordpress custom field?

If you create example variable / variation product with this field populated, are you able to use the custom field viewer to see the value of this field? https://www.importwp.com/docs/how-to-import-wordpress-custom-fields/#find-existing-custom-fields

James

Yes, I can see it now, but maybe that's because I created it with WP import. The first time, it was not possible to find it.

So I think it's with ACF.

Just to make sure i am not missing anything, did you create a demo product with the custom field, then use that demo product as an example to find the custom field from the custom field viewer mentioned in the previous response.

Can you Provide me with a temporary login, and a link the an existing product that has the correct sf_advanced_ean_field custom field populated.

Using the username and password does not allow me to login:

Thank you for sending the files, i have had a look through the sql and can see it is a custom field that is named: "sf_advanced_ean_field".

You should be able to import into this field by using the custom field section, and setting the field to "enable text field" and manually entering the name: sf_advanced_ean_field

I have attached a Screenshot attached showing the importer custom field panel, screenshot showing the importer history for the variation in the example #20 , a and a couple others showing the custom field values.

If you are having trouble replicating this, can you please send similar screenshots of the custom field settings in the importer template, the importer history view for a record, and the same records input data (row of xml or csv).

Thanks
James

Thank you, i'll try this now. 

Is the EAN field on the variable product being saved? from the field preview it looks like there is no value.

To set any data on the product variation, you need to have an importer that updates the variation like you have for the variable product.

To set a default value for a field, click on the icon to the right of the select data button (https://www.importwp.com/docs/template-fields/#mapping-fields) , then set it to be (shown in the attachment)

If Value: Equals
This: 
Then return: (the name of your default attribute)

James

The previous attachment, at the bottom right of the screenshot, to the right of the "select data" button, will load up the modal/popup.

I will have a go at creating a video, however they just use the custom fields section the same as any other product: https://www.importwp.com/docs/how-to-import-wordpress-custom-fields/ , so the row in the csv/xml should have the ean column populated. are you able to provide me with:

Your xml / csv file being used so i can use this as an example, and can you please export and attach your importer settings to this ticket by going to Tools > Import WP > Settings / Tools > Import / Export and select and export your importer as a JSON file.

James

Hi Jonathan,

Thank you for providing those 2 files, after loading up your importer and running importer on a fresh woocommerce / wordpress install it created a seperate variable product for each row.

To solve this i changed the "Product type" field from variable product to "{0}".

running it again, it created the variable product, but was unable to create the product variations as it could not find the parent variable product.

To fix this i edited the importer template, changing the "Advanced" section "Parent Field Type" to "Name", and setting the Parent field to the Nom column: "{2}".

Running this on a fresh install created a single product with 6 variations, screenshot attached showing the imported product with the custom fields set.

James

The only thing i can see is the permissions tab, change the unique identifier to "Select a template field to be used as the unique identifier for each record.", and set the Template field: "_sku".

If you re-run that, and take a screenshot of the history, possibly compare the records #id to see if they are targeting the correct products.

James

Hello, 

I made the change and i got this : 

Can you confirm that the sku of records 1-6 exist? and are of type product variation?

Yes : 

Sorry i was meaning to check your woocommerce shop for existing products that have the "Test - (36-41)", as the error message suggests that these exist but are not product variations, so you need to delete them and remove them from the trash.

I will empty the products into the trash; maybe that is what is causing the problem.

It works.

However, I have empty fields, how can I fill them?

Then, how can I add photos?

Have you populated these fields in the importer? 

An introduction to importing woocommerce products can be found here: https://www.importwp.com/docs/import-woocommerce-products-from-csv-xml/

I'll check. 

Thank you