DaveVerzijl

@valwa do you care to reply?

“Thanks. And how do I get rid of them in the Renamer tab? They still are there although I have locked them because I do not want to rename them.”

Can anyone respond to my last question?

Thanks. And how do I get rid of them in the Renamer tab? They still are there although I have locked them because I do not want to rename them.

I did do the update but unfortunately the link still directs to the old url. Can you please have a look at this?

Due to GDPR I couldn’t just share any actual code from a customer on a public forum. I just created one of myself, which I can share:

The tracking link the plugin creates:

https://www.deutschepost.de/de/s/sendungsverfolgung.html?form.sendungsnummer=LY514907275DE

It should be:

https://www.packet.deutschepost.com/webapp/public/packet_traceit.xhtml?barcode=LY514907275DE

• This reply was modified 1 year, 1 month ago by DaveVerzijl.

If anyone reads this, upvote my feature request here:

https://woo.com/feature-request/ensuring-plugin-syncs-only-products-with-full-variant-availability/

In e-commerce, it is common practice not to advertise fashion items if one or more sizes are not available. Unfortunately, the plugin currently does not provide any option to pre-filter or transmit information to Meta, enabling the filtering out of these items in Meta Commerce Manager. This means that I am currently advertising products for which one or more sizes are no longer available, leading to a waste of my advertising budget by directing people to my site who subsequently discover that their size is unavailable. In my opinion, this should be a standard feature. Why is it not a feature?

That;s not what I meant ??

Example stock availability:

VARIABLE PRODUCT A has
3 x VARIANT AA
6 x VARIANT AB
4 x VARIANT AC
3 x VARIANT AD

This product is OK!

VARIABLE PRODUCT B has
0 x VARIANT AA
3 x VARIANT AB
3 x VARIANT AC
1 x VARIANT AD

This product is NOT OK.

In this case I would need an option to deactivate the VARIABLE PRODUCT from being synchronized to Meta.

Alternatively I would need an option to filter on a value in Meta Commerce Manager to filter out VARIABLE PRODUCTS that have 1 or more VARIANTS with 0 stock.

This issue has not been resolved and is still active. I’m actually quite surprised that you want to close the topic while your last answer was “Let’s want to see if someone else has the answer.” Why the hurry? Closing a topic doesn’t mean a problem is solved ??

• This reply was modified 3 years, 2 months ago by DaveVerzijl.
• This reply was modified 3 years, 2 months ago by DaveVerzijl.

Thank you for your answer. In my previous messages I asked if changing the _wc_facebook_sync_enabled meta value to no would mean that the item would not sync, which was confirmed.

I would also expect that changing it to ‘no’ would delete the variant from the catalog. Do I understand you correctly that only changing that meta value doesn’t remove the product from the catalog and only prevents a non-synced variant to be synced?

If so, what database value do I have to change to what value to get an already synced variant to be also removed from the catalog?

That option does not exist in a Variable product.

I see these options: https://clickthroughom-my.sharepoint.com/:i:/g/personal/dave_clickthrough_nl/EfQ9VJBqyAdFhWvcLZvcmp8BMshdj7uhhIEtw7KEE2frbA?e=GN3h0G

I have done some testing and unfortunately, changing the sync setting of a variant from “Sync and show in catalog” to “Do not sync” through the WordPress Admin interface does not have any effect in the Facebook Catalog. The variant is not being removed from the catalog. Can you test this on your side and confirm this bug?

Thank you for your answer. If I update product A through a database query and after that I update the stock level for a variant for product B through the WooCommerce interface, will product A be updated in the Facebook Catalog, too?

Just to be sure, will it have any effect if I update it directly in the MySQL database through a query or will these updates never be pushed to Facebook without also clicking the Sync Products button (or updating a product)?

Thanks for your answer. Does the plugin re-evaluate the database continiously? So if I update it now, how long would it take for the plugin to notice the database change and update the Facebook catalog?

Is there a query available who does this:

– Find all products that have one or more Variants with 0 stock. Update Meta: _wc_facebook_sync_enabled to ‘no’ for all variants for product

– Find all products where all Variants have 1 or more stock. Update Meta: _wc_facebook_sync_enabled to ‘yes’ for all variants for product