Investigate cloning of WooCommerce products

[bobbingwide]

For WP-a2z we need WooCommerce products in multiple sites. They’re needed to give live examples for blocks which use them. The existing cloning logic is not enough.

Expected result

When a Product is cloned then it shouldn't need editing on the target server

Actual result

Not all the required data is created on the target. This can lead to blocks that rely on WooCommerce data to fail to produce the expected output.

One example is the woocommerce/product-on-sale block. For this block to work it appears to need the data that WooCommerce populates in the wc_product_meta_lookup table.

Another example is that attachments, such as download files, are not cloned. This isn't really a problem for WP-a2z since the products are mostly examples. We don't expect any orders to be fulfilled.

Proposed solution

Determine the best way to copy WooCommerce products and attempt to apply the same logic in cloning.

Hints:

• WooCommerce provides a Duplicate product action in the Dashboard.
• There's a built-in CSV importer and exporter. See https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting
• There's also a premium plugin, Product CSV Import Suite, which extends the built-in product CSV importer and exporter.

[bobbingwide]

There's a further complication when it comes to cloning certain WooCommerce blocks. In the Products by Attributes block there are attributes representing the selected Product attributes. These values are stored in more complex structures than catered for in #38. Cloning would have to take into account the mapping of the id attrs

<!-- wp:woocommerce/products-by-attribute 
{"attributes":[{"id":411,"attr_slug":"pa_size"},{"id":410,"attr_slug":"pa_size"}],
"editMode":false} /-->\n\n

[bobbingwide]

The Products by Category block has an attr called categories.

<!-- wp:woocommerce/product-category {"categories":[322,320]} /-->

[bobbingwide]

The Products by Tag block has an attr called tags.

<!-- wp:woocommerce/product-tag {"tags":[323]} /-->

[bobbingwide]

The Top Rated Products block includes a categories filter, which may be an empty array.

<!-- wp:woocommerce/product-top-rated {
"categories":[],
"contentVisibility":{"title":true,"price":true,"rating":true,"button":true}} /-->

[bobbingwide]

One example is the woocommerce/product-on-sale block. For this block to work it appears to need the data that WooCommerce populates in the wc_product_meta_lookup table.

Q. How do we correct this after cloning?

• Adjust the product's price or sale price.