Nothing built in – the products for each site are in different database tables.
Could you not use the SKU to identify them?
@seank123 Because we don’t have SKU on the variable. The SKU are on the variation. Variable is more of the product grouping while the variation is the specific product so the SKUs are in the variation.
For example if we are selling tshirts, “tshirt” is the variable while “red XL tshirt” is the variation.
And if you query product post type, it will return the variable products for which we don’t have an SKU.
You can still add an SKU to the product to use internally – or there’s the custom fields?
@seank123 I ask the production team and they don’t want that so I guess I’ll just add a global product ID custom field.
Someone also recommended Broadcast plugin (https://broadcast.plainviewplugins.com/basic/) so I’ll also check if that works.
Hi @jaceejoef
Thanks for reaching out!
I understand that you want to know if there is a way to have a global product ID for a multisite environment in order to identify and update products across websites, correct?
In a WordPress multisite environment, each website has its own set of tables in the database, which means that products on different websites will have unique IDs.
This is a bit of a complicated topic that would need some customization to address. Unfortunately, custom coding is not something we can assist with directly. However, I’ll keep this thread open for a bit to see if anyone from the community can lend a hand.
If you have any other questions related to development or custom coding, don’t hesitate to reach out to some of the great resources we have available for support. The WooCommerce community is filled with talented open-source developers, and many of them are active on the channels listed below:
Hope this helps!