[Closed] Products tables desyncronization

Hi,

Sure, thanks for your update.

I'll be waiting to hear from you if you need further help with this issue.

Regards,
Itamar.

Hi,

Thanks for trying the workaround.

I assume you are referring to the მოდელის/ნაწილის ნომერი custom attributes.
Is this correct?

If so, I observe a few problems.

A. This attribute was not even imported correctly in Georgian. Only the forward slash (/) is there. Please see the attached screenshot forward-slash.jpg. It might be that it is not possible to include this sign in an attribute label. (This is just an assumption from my side.) So, not being imported into Georgia can be the root of the problem.

B. As far as I can see, you have not added the following functions to the functions.php file of the active Twenty Twenty-One theme.

/**
 * <em><u>hidden link</u></em>
 *
 * Force unserializing of meta data in WC importer.
 */
add_filter( 'woocommerce_product_importer_parsed_data', function ( $data ) {
    if ( isset( $data['meta_data'] ) && is_array( $data['meta_data'] ) ) {
        foreach ( array_keys( $data['meta_data'] ) as $k ) {
            $data['meta_data'][ $k ]['value'] = maybe_unserialize( $data['meta_data'][ $k ]['value'] );
        }
    }

    return $data;
} );

I'm sorry that this code is broken on the link I sent you. I've just fixed it.

C. Your PHP and, in turn, the serialized array are not following this format:

[ 'LANGUAGE_CODE' => [ 'ORIGINAL-ATTRIBUTE-NAME-SLUG' => 'TRANSLATED ATTRIBUTE NAME', ], ]

It is supposed to look something like this, for example:

[ 'ka-ge' => [ 'მოდელის-ნაწილის-ნომერი' => 'Model/Part Number', ], ];

And it is supposed to be for each attribute separately and not as you put it all together.

In any case, writing these lines now, I'm not sure it is the solution for you. I need to consult our second-tier supporters about it. I'll keep you updated about this.

However, I still think you should stick to the guide here:
hidden link
I still don't see the following columns in your CSV files:

wpml:language_code

wpml:original_product_id
(or)
wpml:original_product_sku

I know you said you mapped them. But I think that the columns must be there.

Please note that my weekend hours are Friday to Saturday. If you need further assistance, I'll be available to continue checking this issue and helping you next week.

Regards,
Itamar.

Hi,

Our second-tier supporter wrote the following about this case:

In most cases, when things disappear out of nowhere, it's because there's a DB entry missing. If it was added in any way by the plugin, it could be that something is missing, so ATE would not see it and pass it to the translations.

In light of this, I suggest you try again when the Advanced Translation Editor is canceled. In other words, although it is less convenient, don't work with the Advanced Translation Editor for products that you imported with the Product Import Export for WooCommerce Add-on plugin. You cancel it in the editing screen of each product. You can cancel it for a specific product or all products. Please see the attached screenshot. Then make a new import and check what happens in this case.
Do you still have a problem with the custom attributes?

If the answer is yes, then we must escalate this ticket to our second-tier supporter with a copy of the sandbox site. For this, I want to ask you the following, please (on the sandbox site).

1. Simplify as much as possible your CSV. I mean, reduce the number of columns to the minimum required. Just include the columns needed to replicate the problem. Also, please add just one or two products to this file. This will make the file more manageable and easier to understand.

2. Share with us this file. You can upload it to a service like Google Drive or Dropbox and share the link with me. Or explain where we can find it on the site.

3. Write to us the steps to reproduce the problem. Start from the import process and then move to the steps that trigger the problem. Please write in steps: 1. 2. 3... and so on. It would also be helpful if you could share a clear video on the above steps, where you are explaining what you do. You can use the free online screencast service Komodo - hidden link. This should help me see if you do anything wrong.

Then I'll create a copy of the sandbox site and escalate it to our second-tier supporters.

Please note that my weekend hours are Friday to Saturday. If you need further assistance, I'll be available to continue checking this issue and helping you next week.

Thanks,
Itamar.